summaryrefslogtreecommitdiff
path: root/tests
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2011-11-29 19:37:45 -0500
committerMike Bayer <mike_mp@zzzcomputing.com>2011-11-29 19:37:45 -0500
commit4dbb340fe9ff23da33506ff77d531a18a505f939 (patch)
tree94fa183775b0f7b8b8ca380a4849e6b1aa26304d /tests
parent2f55f3a54319ab144a0d98287bf8b7755d7282a4 (diff)
downloadalembic-4dbb340fe9ff23da33506ff77d531a18a505f939.tar.gz
dont need the const thing now that the batch separator is in use
Diffstat (limited to 'tests')
-rw-r--r--tests/test_mssql.py15
1 files changed, 4 insertions, 11 deletions
diff --git a/tests/test_mssql.py b/tests/test_mssql.py
index bdf8272..dbdb0ba 100644
--- a/tests/test_mssql.py
+++ b/tests/test_mssql.py
@@ -62,24 +62,17 @@ class OpTest(TestCase):
context = op_fixture('mssql')
op.drop_column('t1', 'c1', mssql_drop_default=True)
op.drop_column('t1', 'c2', mssql_drop_default=True)
- context.assert_contains("exec('alter table t1 drop constraint ' + @const_name_1)")
+ context.assert_contains("exec('alter table t1 drop constraint ' + @const_name)")
context.assert_contains("ALTER TABLE t1 DROP COLUMN c1")
- # counter increments
- context.assert_contains("exec('alter table t1 drop constraint ' + @const_name_2)")
- context.assert_contains("ALTER TABLE t1 DROP COLUMN c2")
def test_drop_column_w_check(self):
context = op_fixture('mssql')
op.drop_column('t1', 'c1', mssql_drop_check=True)
op.drop_column('t1', 'c2', mssql_drop_check=True)
- context.assert_contains("exec('alter table t1 drop constraint ' + @const_name_1)")
+ context.assert_contains("exec('alter table t1 drop constraint ' + @const_name)")
context.assert_contains("ALTER TABLE t1 DROP COLUMN c1")
- # counter increments
- context.assert_contains("exec('alter table t1 drop constraint ' + @const_name_2)")
- context.assert_contains("ALTER TABLE t1 DROP COLUMN c2")
-
def test_alter_column_nullable_w_existing_type(self):
context = op_fixture('mssql')
op.alter_column("t", "c", nullable=True, existing_type=Integer)
@@ -128,7 +121,7 @@ class OpTest(TestCase):
def test_alter_replace_server_default(self):
context = op_fixture('mssql')
op.alter_column("t", "c", server_default="5", existing_server_default="6")
- context.assert_contains("exec('alter table t drop constraint ' + @const_name_1)")
+ context.assert_contains("exec('alter table t drop constraint ' + @const_name)")
context.assert_contains(
"ALTER TABLE t ADD DEFAULT '5' FOR c"
)
@@ -136,7 +129,7 @@ class OpTest(TestCase):
def test_alter_remove_server_default(self):
context = op_fixture('mssql')
op.alter_column("t", "c", server_default=None)
- context.assert_contains("exec('alter table t drop constraint ' + @const_name_1)")
+ context.assert_contains("exec('alter table t drop constraint ' + @const_name)")
def test_alter_do_everything(self):
context = op_fixture('mssql')