- refactor the migration operations out of context, which

mediates at a high level, into ddl/impl, which deals with DB stuff
- fix MSSQL add column, #2

1 files changed, 17 insertions, 0 deletions

diff --git a/tests/test_mssql.py b/tests/test_mssql.py
new file mode 100644
index 0000000..1cb7465
--- /dev/null
+++ b/tests/test_mssql.py
@@ -0,0 +1,17 @@
+"""Test op functions against MSSQL."""
+
+from tests import _op_fixture
+from alembic import op
+from sqlalchemy import Integer, Column, ForeignKey, \
+            UniqueConstraint, Table, MetaData, String
+from sqlalchemy.sql import table
+
+def test_add_column():
+    context = _op_fixture('mssql')
+    op.add_column('t1', Column('c1', Integer, nullable=False))
+    context.assert_("ALTER TABLE t1 ADD c1 INTEGER NOT NULL")
+
+def test_add_column_with_default():
+    context = _op_fixture("mssql")
+    op.add_column('t1', Column('c1', Integer, nullable=False, server_default="12"))
+    context.assert_("ALTER TABLE t1 ADD c1 INTEGER NOT NULL DEFAULT '12'")