tests Package

tests Package

mqlalchemy.tests.__init__

Tests for our new query syntax.

class tests.MQLAlchemyTests(methodName='runTest')

Bases: TestCase

A collection of MQLAlchemy tests.

setUp()

Configure a db session for the chinook database.

tearDown()

Clean up database connections.

test_db()

Make sure our test db is functional.

test_simple_query()

Test a very simple mqlalchemy query.

test_simple_prior_query()

Test a simple mqlalchemy query using a preformed query.

test_no_match()

Test that a query that should have no match works.

test_list_relation()

Test that a list relation .any query works.

test_complex_list_relation()

Test that a multi-level list relation query works.

test_more_complex_list_relation()

Test that a complex list relation query works.

test_complex_convert_name()

Test that converting from camelCase to underscore works.

test_explicit_elem_match()

Test that an explicit elemMatch.

test_implicit_elem_match()

Test that an implicit elemMatch works.

test_list_relation_eq_fail()

Make sure we can’t check a relation for equality.

test_list_relation_neq_fail()

Make sure we can’t check a relation for inequality.

test_non_list_relation()

Test that a non-list relation .has query works.

test_attr_exists()

Test $exists on a simple attr.

test_attr_not_exists()

Test not $exists on a simple attr.

test_child_list_not_exists()

Test a child list can be filtered for being missing.

test_child_list_exists()

Test a child list can be checked for existence.

test_child_non_list_not_exists()

Test a non list child can be filtered for being missing.

test_child_non_list_exists()

Test a non list child can be checked for existence.

test_implicit_and()

Test that an implicit and query works.

test_explicit_and()

Test that the $and operator works.

test_or()

Test that the $or operator works.

test_negation()

Test that the $not operator works.

test_nor()

Test that the $nor operator works.

test_neq()

Test that the $ne operator works.

test_lt()

Test that the $lt operator works.

test_lte()

Test that the $lte operator works.

test_eq()

Test that the new $eq operator works.

test_gte()

Test that the $gte operator works.

test_gt()

Test that the $gt operator works.

test_mod()

Test that the $mod operator works.

test_mod_str_fail()

Test passing string values to $mod op fails.

test_mod_decimal_divisor_fails()

Test passing a decimal divisor to $mod op fails.

test_mod_decimal_remainder_fails()

Test passing a decimal remainder to $mod op fails.

test_mod_non_list()

Test passing a non list to $mod op rails.

test_mod_non_int_field()

Test trying to $mod a non int field fails.

test_in()

Test that the $in operator works.

test_in_nested()

Test that the $in operator works on nested objects.

test_in_non_list_fails()

Test that the $in op fails when not supplied with a list.

test_nin()

Test that the $nin operator works.

test_nin_non_list_fails()

Test that the $nin op fails when not supplied with a list.

test_like()

Test that the new $like operator works.

test_elemmatch_fail()

Test that the $elemMatch operator properly fails.

test_nested_attr_query_fail()

Test that a nested attribute query fails.

test_bad_operator_fail()

Test that a invalid operator fails.

test_empty_dict_fail()

Test that a nested attribute query fails.

test_whitelist()

Test that whitelisting works as expected.

test_custom_whitelist_func()

Test that providing a whitelist function works.

test_convert_to_int()

Test that we can convert a string to integer.

test_convert_to_float()

Test that we can convert a string to a float.

test_convert_to_bool()

Test that we can convert a value to a boolean.

test_convert_to_datetime()

Test that we can convert a value to a datetime.

test_convert_to_date()

Test that we can convert a value to a date.

test_convert_to_time()

Test that we can convert a value to a time.

test_convert_to_string()

Test that we can convert a string to integer.

test_convert_to_null()

Test that convert_to_alchemy_type properly returns None.

test_convert_fail()

Test that convert_to_alchemy_type properly fails.

test_get_attr_class_attributes()

Test that _get_class_attributes works.

test_stack_size_limit()

Make sure that limiting the stack size works as expected.

test_stack_size_limit_fail()

Make sure that limiting the stack size fails as expected.

test_type_conversion_fail()

Make sure we can’t check a relation for equality.

test_self_referential_relation()

Test relationship chain leading to the same model.

test_required_filters()

Test nested conditions are applied properly.

test_required_filters_tuple()

Test nested conditions are applied properly as a tuple.

test_nested_conditions_dict()

Test dict nested conditions are applied properly.

models Module

mqlalchemy.tests.models.py

SQLAlchemy models for the Chinook database.

class tests.models.Album(**kwargs)

Bases: Base

SQLAlchemy model for the Album table in our database.

album_id

title

artist_id

artist

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

tracks

class tests.models.Artist(**kwargs)

Bases: Base

SQLAlchemy model for the Artist table in our database.

artist_id

name

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

albums

class tests.models.Customer(**kwargs)

Bases: Base

SQLAlchemy model for the Customer table in our database.

customer_id

first_name

last_name

company

address

city

state

country

postal_code

phone

fax

email

support_rep_id

employee

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

class tests.models.Employee(**kwargs)

Bases: Base

SQLAlchemy model for the Employee table in our database.

employee_id

last_name

first_name

title

reports_to

birth_date

hire_date

address

city

state

country

postal_code

phone

fax

email

manager

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

subordinates

class tests.models.Genre(**kwargs)

Bases: Base

SQLAlchemy model for the Genre table in our database.

genre_id

name

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

class tests.models.Invoice(**kwargs)

Bases: Base

SQLAlchemy model for the Invoice table in our database.

invoice_id

customer_id

invoice_date

billing_address

billing_city

billing_state

billing_country

billing_postal_code

total

customer

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

class tests.models.InvoiceLine(**kwargs)

Bases: Base

SQLAlchemy model for the InvoiceLine table in our database.

invoice_line_id

invoice_id

track_id

unit_price

quantity

invoice

track

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

class tests.models.MediaType(**kwargs)

Bases: Base

SQLAlchemy model for the MediaType table in our database.

media_type_id

name

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

class tests.models.Playlist(**kwargs)

Bases: Base

SQLAlchemy model for the Playlist table in our database.

playlist_id

name

tracks

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

class tests.models.Track(**kwargs)

Bases: Base

SQLAlchemy model for the Track table in our database.

track_id

name

album_id

media_type_id

genre_id

composer

milliseconds

bytes

unit_price

album

genre

media_type

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

playlists