def test_data_type_collation_sequence_is_not_applied_on_non_textual_data_types(
self, ):
for column_type in (
"BIGINT",
"BINARY",
"BIT",
"BLOB",
"BOOLEAN",
"DATE",
"DATETIME",
"DATETIME",
"DECIMAL",
"DOUBLE",
"FLOAT",
"INTEGER",
"INTEGER",
"LONGBLOB",
"MEDIUMBLOB",
"MEDIUMINT",
"NUMERIC",
"REAL",
"SMALLINT",
"TIME",
"TINYBLOB",
"TINYINT",
"VARBINARY",
"YEAR",
):
for collation in (
CollatingSequences.BINARY,
CollatingSequences.NOCASE,
CollatingSequences.RTRIM,
):
assert (MySQLtoSQLite._data_type_collation_sequence(
collation, column_type) == "")
def test_data_type_collation_sequence_is_applied_on_textual_data_types(
self,
collation,
resulting_column_collation,
column_type,
):
assert (MySQLtoSQLite._data_type_collation_sequence(
collation, column_type) == resulting_column_collation)