def safecmp(x, y):
"""Calls the 'standard' safecmp function, which performs a comparison
similar to cmp, including iterating over lists, but two None values
are considered equal, and a TypeError is avoided when a None value
and a datetime are corresponding members of a list.
"""
return StandardNormalizer.safecmp(x, y)
def normalize(table, sql, num_digits=12):
"""Normalizes the result tuples of ORDER BY statements, sorting SQL NULL
(Python None) values as if they were the lowest values, i.e., first
when using ORDER BY col1 ASC, but last when using ORDER BY col1 DESC.
"""
return StandardNormalizer.normalize(table, sql, num_digits,
SortNulls.lowest)
def normalize(table, sql):
"""Normalizes results by rounding numbers, including those found in a
string (VARCHAR) column representing a GEOGRAPHY_POINT or GEOGRAPHY
(point or polygon) to the specified number of significant digits; the
result tuples of ORDER BY statements are not reordered.
"""
return StandardNormalizer.normalize(table, sql, SortNulls.never, 4)
def normalize(table, sql):
"""Normalizes results by rounding numbers, including those found in a
string (VARCHAR) column representing a GEOGRAPHY_POINT or GEOGRAPHY
(point or polygon) to the specified number of significant digits; the
result tuples of ORDER BY statements are not reordered.
"""
return StandardNormalizer.normalize(table, sql, SortNulls.never, 8)
def safecmp(x, y):
"""Calls the 'standard' safecmp function, which performs a comparison
similar to cmp, including iterating over lists, but two None values
are considered equal, and a TypeError is avoided when a None value
and a datetime are corresponding members of a list.
"""
return StandardNormalizer.safecmp(x,y)
def normalize(table, sql):
"""Normalizes the result tuples of ORDER BY statements in the default
manner, without sorting SQL NULL (Python None) values at all; in some
cases, this could lead to mismatches between HSqlDB, which always sorts
NULL values first, and VoltDB, which sorts NULL values as if they were
the lowest value (first with ORDER BY ASC, last with ORDER BY DESC), in
which case you could use a different normalizer, such as
nulls-lowest-normalizer.py.
"""
return StandardNormalizer.normalize(table, sql, SortNulls.never)
def normalize(table, sql):
"""Normalizes the result tuples of ORDER BY statements in the default
manner, without sorting SQL NULL (Python None) values at all; in some
cases, this could lead to mismatches between HSqlDB, which always sorts
NULL values first, and VoltDB, which sorts NULL values as if they were
the lowest value (first with ORDER BY ASC, last with ORDER BY DESC), in
which case you could use a different normalizer, such as
nulls-lowest-normalizer.py.
"""
return StandardNormalizer.normalize(table, sql, SortNulls.never)
def normalize(table, sql, num_digits=12, sort_nulls=SortNulls.never):
"""Normalizes the result tuples of ORDER BY statements in the default
manner, without sorting SQL NULL (Python None) values at all; in some
cases, this could lead to mismatches between HSqlDB, which always sorts
NULL values first, and VoltDB, which sorts NULL values as if they were
the lowest value (first with ORDER BY ASC, last with ORDER BY DESC), in
which case you could use a different normalizer, such as
nulls-lowest-normalizer.py. Also rounds numbers, including those found
in a string (VARCHAR) column representing a GEOGRAPHY_POINT or GEOGRAPHY
(point or polygon) to the specified number of significant digits; the
result tuples of ORDER BY statements are not reordered.
"""
return StandardNormalizer.normalize(table, sql, num_digits, sort_nulls)
def normalize(table, sql, num_digits=12, sort_nulls=SortNulls.never):
"""Normalizes the result tuples of ORDER BY statements in the default
manner, without sorting SQL NULL (Python None) values at all; in some
cases, this could lead to mismatches between HSqlDB, which always sorts
NULL values first, and VoltDB, which sorts NULL values as if they were
the lowest value (first with ORDER BY ASC, last with ORDER BY DESC), in
which case you could use a different normalizer, such as
nulls-lowest-normalizer.py. Also rounds numbers, including those found
in a string (VARCHAR) column representing a GEOGRAPHY_POINT or GEOGRAPHY
(point or polygon) to the specified number of significant digits; the
result tuples of ORDER BY statements are not reordered.
"""
return StandardNormalizer.normalize(table, sql, num_digits, sort_nulls)
def normalize(table, sql):
"""Normalizes the result tuples of ORDER BY statements, sorting SQL NULL
(Python None) values as if they were the lowest values, i.e., first
when using ORDER BY col1 ASC, but last when using ORDER BY col1 DESC.
"""
return StandardNormalizer.normalize(table, sql, SortNulls.lowest)
def normalize(table, sql):
"""Normalizes the result tuples of ORDER BY statements, sorting SQL NULL
(Python None) values last (whether using ORDER BY ASC or DESC).
"""
return StandardNormalizer.normalize(table, sql, SortNulls.last)
def normalize(table, sql):
"""Normalizes the result tuples of ORDER BY statements, sorting SQL NULL
(Python None) values first (whether using ORDER BY ASC or DESC).
"""
return StandardNormalizer.normalize(table, sql, SortNulls.first)
