def _compare_default_roundtrip(self,
type_,
orig_default,
alternate=None,
diff_expected=None):
diff_expected = diff_expected \
if diff_expected is not None \
else alternate is not None
if alternate is None:
alternate = orig_default
t1 = Table("test", self.metadata,
Column("somecol", type_, server_default=orig_default))
t2 = Table("test", MetaData(),
Column("somecol", type_, server_default=alternate))
t1.create(self.bind)
insp = Inspector.from_engine(self.bind)
cols = insp.get_columns(t1.name)
insp_col = Column("somecol",
cols[0]['type'],
server_default=text(cols[0]['default']))
op = ops.AlterColumnOp("test", "somecol")
_compare_server_default(self.autogen_context, op, None, "test",
"somecol", insp_col, t2.c.somecol)
diffs = op.to_diff_tuple()
eq_(bool(diffs), diff_expected)
def _compare_default_roundtrip(
self, type_, orig_default, alternate=None, diff_expected=None):
diff_expected = diff_expected \
if diff_expected is not None \
else alternate is not None
if alternate is None:
alternate = orig_default
t1 = Table("test", self.metadata,
Column("somecol", type_, server_default=orig_default))
t2 = Table("test", MetaData(),
Column("somecol", type_, server_default=alternate))
t1.create(self.bind)
insp = Inspector.from_engine(self.bind)
cols = insp.get_columns(t1.name)
insp_col = Column("somecol", cols[0]['type'],
server_default=text(cols[0]['default']))
op = ops.AlterColumnOp("test", "somecol")
_compare_server_default(
self.autogen_context, op,
None, "test", "somecol", insp_col, t2.c.somecol)
diffs = op.to_diff_tuple()
eq_(bool(diffs), diff_expected)
