Prepare a MySQL statement

Prepare a MySQL statement.

Get collation name

Get collation name.

User provides the collation but not the charset.

User provides the collation but not the charset.

Test if _id is preserved when JSON doc contains _id field and not overridden by generated ID.

Test when _id is given string.

Test if ID is generated for multiple JSON docs when _id field is not provided.

Test to ensure that the generated ID depends on client's MAC.

Test if ID is generated with big JSON docs without _id field.

Test ID is not generated by adding big JSON docs with _id field.

Test adding duplicate values to _id. User should get error.

Test inserting invalid values to _id.

Test if ID is generated for multiple JSON docs when _id field is not provided.

Test if ID is generated for multiple JSON docs when _id field is not provided.

Test ID generation when few docs contain _id while others doesn't contain.

Test ID is not generated when multiple docs are added with _id field.

Testing IDs are not duplicate when data added without _id filed from multiple sessions to the same collection.

Test ID is generated when different values are provided to _id field.

Test when _id is given value 0.

Test when _id is given big positive number.

Test collection.add_or_replace_one to replace if the id already exists or add if not.

Test collection.add_or_replace_one when a unique key matches passes, as index is not unique (not supported yet).

Test collection.add_or_replace_one when 2 different keys matches since index is not unique, duplicate data will be added.

Test collection.

Test the collection.add with empty document.

MCPY-384 add an empty array to a collection which doesnt exist.

Test the parameter list.

Test collection.find.fields.

Test collection.find using where() condition.

Test collection.find with offset as large positive number.

Test collection.find with offset as negative number.

Test the collection.find.groupby and having.

Test collection.find with sort.

Test collection.find with limit with offset.

Test collection.find with like.

Test collection.find with bind.

Test collection.find with parameter list.

Test collection.find.groupby with parameter list.

Test collection.find.sort with param list.

Test collection.replace_one to replace one doc.

Test get_one() should return None if matching ID is not found.

Create a basic index.

Test create index with different index names.

Test create invalid indexes.

Test dropping an invalid index.

Create index with "unique" option is True.

Create index on different datatypes with field type as array. Create index on DECIMAL array field.

Create array index with "unique" option is True. Should raise exception.

Test create index with different index names.

Create array index on fields with mismatched datatypes.

Test creating an index on array field with "array" set to false.

Test creating an index on empty array field - should pass.

Create index on all int datatypes.

Create a NOT NULL index on array field - should fail.

Create index on nested array - should fail.

Use overlaps/not-overlaps operators which intern uses the index. This is integration scenario: Index WL + overlaps WL

Create index on array fields with mixed datatype values.

Test creating an index on array field which contains None value.

Test giving an invalid value to array property.

Integration scenario between Index and overlaps.

Create basic index on all float types.

Create basic index on other datatypes. Server bug 27252354 has been opened. When we load the data and then try to create index gives e

Test create index with TEXT type.

Test create index on GEOJSON type.

Test create_index on collection which already has some data.

Test create index with multiple fields.

Create duplicate indexes.

Test basic collection.modify.

Test the collection.modify set and sort and param.

Test the collection.modify UNSET with param list.

Test the collection.modify with an empty string and is expected to return an exception.

Test the collection.modify with null condition and is expected to return an exception.

Test the collection.modify.where for entire collection.

Test the collection.modify.where with a condition which results into true.

Test the collection.modify with a condition which results into true.

Test the collection.modify with a false condition. if where condition is provided then "false" condition will be overwritten and the d

Test the collection.modify with a false condition. If where condition is provided then "false" condition will be overwritten and the d

Test the collection.modify without condition.

Test the collection.modify UNSET.

Test the collection.modify change.

Test the collection.modify set and sort for entire collection using TRUE.

Test the collection.modify set bind.

Test the collection.modify.array-insert.

Test the collection.modify.array-append.

Test the collection.modify.where for entire collection.

Test multiple lock calls.

Test multiple lock calls.

Test the collection.remove with where using "TRUE" condition.

Test the collection.remove with empty search condition.

Test the collection.remove with null search condition.

Test the collection.remove with a condition which results to false.

Test the collection.remove with bind.