diff options
Diffstat (limited to 'test/sql/test_query.py')
| -rw-r--r-- | test/sql/test_query.py | 24 |
1 files changed, 14 insertions, 10 deletions
diff --git a/test/sql/test_query.py b/test/sql/test_query.py index 9f66a2ef5..7d05462ab 100644 --- a/test/sql/test_query.py +++ b/test/sql/test_query.py @@ -480,7 +480,7 @@ class QueryTest(fixtures.TestBase): for labels in False, True: a_eq( users.select( - order_by=[users.c.user_name.nullsfirst()], + order_by=[users.c.user_name.nulls_first()], use_labels=labels, ), [(1, None), (3, "a"), (2, "b")], @@ -488,14 +488,15 @@ class QueryTest(fixtures.TestBase): a_eq( users.select( - order_by=[users.c.user_name.nullslast()], use_labels=labels + order_by=[users.c.user_name.nulls_last()], + use_labels=labels, ), [(3, "a"), (2, "b"), (1, None)], ) a_eq( users.select( - order_by=[asc(users.c.user_name).nullsfirst()], + order_by=[asc(users.c.user_name).nulls_first()], use_labels=labels, ), [(1, None), (3, "a"), (2, "b")], @@ -503,7 +504,7 @@ class QueryTest(fixtures.TestBase): a_eq( users.select( - order_by=[asc(users.c.user_name).nullslast()], + order_by=[asc(users.c.user_name).nulls_last()], use_labels=labels, ), [(3, "a"), (2, "b"), (1, None)], @@ -511,7 +512,7 @@ class QueryTest(fixtures.TestBase): a_eq( users.select( - order_by=[users.c.user_name.desc().nullsfirst()], + order_by=[users.c.user_name.desc().nulls_first()], use_labels=labels, ), [(1, None), (2, "b"), (3, "a")], @@ -519,7 +520,7 @@ class QueryTest(fixtures.TestBase): a_eq( users.select( - order_by=[users.c.user_name.desc().nullslast()], + order_by=[users.c.user_name.desc().nulls_last()], use_labels=labels, ), [(2, "b"), (3, "a"), (1, None)], @@ -527,7 +528,7 @@ class QueryTest(fixtures.TestBase): a_eq( users.select( - order_by=[desc(users.c.user_name).nullsfirst()], + order_by=[desc(users.c.user_name).nulls_first()], use_labels=labels, ), [(1, None), (2, "b"), (3, "a")], @@ -535,7 +536,7 @@ class QueryTest(fixtures.TestBase): a_eq( users.select( - order_by=[desc(users.c.user_name).nullslast()], + order_by=[desc(users.c.user_name).nulls_last()], use_labels=labels, ), [(2, "b"), (3, "a"), (1, None)], @@ -543,7 +544,10 @@ class QueryTest(fixtures.TestBase): a_eq( users.select( - order_by=[users.c.user_name.nullsfirst(), users.c.user_id], + order_by=[ + users.c.user_name.nulls_first(), + users.c.user_id, + ], use_labels=labels, ), [(1, None), (3, "a"), (2, "b")], @@ -551,7 +555,7 @@ class QueryTest(fixtures.TestBase): a_eq( users.select( - order_by=[users.c.user_name.nullslast(), users.c.user_id], + order_by=[users.c.user_name.nulls_last(), users.c.user_id], use_labels=labels, ), [(3, "a"), (2, "b"), (1, None)], |