diff options
Diffstat (limited to 'test/dialect/mysql/test_compiler.py')
| -rw-r--r-- | test/dialect/mysql/test_compiler.py | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/test/dialect/mysql/test_compiler.py b/test/dialect/mysql/test_compiler.py index 54767a913..60e11ca29 100644 --- a/test/dialect/mysql/test_compiler.py +++ b/test/dialect/mysql/test_compiler.py @@ -5,6 +5,7 @@ from sqlalchemy import BOOLEAN from sqlalchemy import Boolean from sqlalchemy import cast from sqlalchemy import CHAR +from sqlalchemy import CheckConstraint from sqlalchemy import CLOB from sqlalchemy import Column from sqlalchemy import DATE @@ -128,6 +129,35 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): "CREATE INDEX test_idx2 ON testtbl (data(5))", ) + def test_drop_constraint_mysql(self): + m = MetaData() + table_name = "testtbl" + constraint_name = "constraint" + constraint = CheckConstraint("data IS NOT NULL", name=constraint_name) + tbl = Table(table_name, m, Column("data", String(255)), constraint) + dialect = mysql.dialect() + self.assert_compile( + schema.DropConstraint(constraint), + "ALTER TABLE %s DROP CHECK `%s`" + % (table_name, constraint_name), + dialect=dialect + ) + + def test_drop_constraint_mariadb(self): + m = MetaData() + table_name = "testtbl" + constraint_name = "constraint" + constraint = CheckConstraint("data IS NOT NULL", name=constraint_name) + tbl = Table(table_name, m, Column("data", String(255)), constraint) + dialect = mysql.dialect() + dialect.server_version_info = (10, 1, 1, "MariaDB") + self.assert_compile( + schema.DropConstraint(constraint), + "ALTER TABLE %s DROP CONSTRAINT `%s`" + % (table_name, constraint_name), + dialect=dialect + ) + def test_create_index_with_length_quoted(self): m = MetaData() tbl = Table( |