def test_render_fk_constraint_kwarg(self):
m = MetaData()
t1 = Table('t', m, Column('c', Integer))
t2 = Table('t2', m, Column('c_rem', Integer))
fk = ForeignKeyConstraint([t1.c.c], [t2.c.c_rem], onupdate="CASCADE")
if not util.sqla_08:
t1.append_constraint(fk)
eq_ignore_whitespace(
autogenerate._render_constraint(fk, self.autogen_context),
"sa.ForeignKeyConstraint(['c'], ['t2.c_rem'], onupdate='CASCADE')")
fk = ForeignKeyConstraint([t1.c.c], [t2.c.c_rem], ondelete="CASCADE")
if not util.sqla_08:
t1.append_constraint(fk)
eq_ignore_whitespace(
autogenerate._render_constraint(fk, self.autogen_context),
"sa.ForeignKeyConstraint(['c'], ['t2.c_rem'], ondelete='CASCADE')")
fk = ForeignKeyConstraint([t1.c.c], [t2.c.c_rem], deferrable=True)
if not util.sqla_08:
t1.append_constraint(fk)
eq_ignore_whitespace(
autogenerate._render_constraint(fk, self.autogen_context),
"sa.ForeignKeyConstraint(['c'], ['t2.c_rem'], deferrable=True)")
fk = ForeignKeyConstraint([t1.c.c], [t2.c.c_rem], initially="XYZ")
if not util.sqla_08:
t1.append_constraint(fk)
eq_ignore_whitespace(
autogenerate._render_constraint(fk, self.autogen_context),
"sa.ForeignKeyConstraint(['c'], ['t2.c_rem'], initially='XYZ')")
def test_render_fk_constraint_use_alter(self):
m = MetaData()
Table('t', m, Column('c', Integer))
t2 = Table('t2', m, Column('c_rem', Integer,
ForeignKey('t.c', name="fk1", use_alter=True)))
const = list(t2.foreign_keys)[0].constraint
eq_ignore_whitespace(
autogenerate._render_constraint(const, self.autogen_context),
"sa.ForeignKeyConstraint(['c_rem'], ['t.c'], "
"name='fk1', use_alter=True)"
)
def test_render_fk_constraint_use_alter(self):
m = MetaData()
Table('t', m, Column('c', Integer))
t2 = Table('t2', m, Column('c_rem', Integer,
ForeignKey('t.c', name="fk1", use_alter=True)))
const = list(t2.foreign_keys)[0].constraint
eq_ignore_whitespace(
autogenerate._render_constraint(const, self.autogen_context),
"sa.ForeignKeyConstraint(['c_rem'], ['t.c'], "
"name='fk1', use_alter=True)"
)
def test_render_fk_constraint_kwarg(self):
m = MetaData()
t1 = Table('t', m, Column('c', Integer))
t2 = Table('t2', m, Column('c_rem', Integer))
fk = ForeignKeyConstraint([t1.c.c], [t2.c.c_rem], onupdate="CASCADE")
if not util.sqla_08:
t1.append_constraint(fk)
eq_ignore_whitespace(
autogenerate._render_constraint(fk, self.autogen_context),
"sa.ForeignKeyConstraint(['c'], ['t2.c_rem'], onupdate='CASCADE')"
)
fk = ForeignKeyConstraint([t1.c.c], [t2.c.c_rem], ondelete="CASCADE")
if not util.sqla_08:
t1.append_constraint(fk)
eq_ignore_whitespace(
autogenerate._render_constraint(fk, self.autogen_context),
"sa.ForeignKeyConstraint(['c'], ['t2.c_rem'], ondelete='CASCADE')"
)
fk = ForeignKeyConstraint([t1.c.c], [t2.c.c_rem], deferrable=True)
if not util.sqla_08:
t1.append_constraint(fk)
eq_ignore_whitespace(
autogenerate._render_constraint(fk, self.autogen_context),
"sa.ForeignKeyConstraint(['c'], ['t2.c_rem'], deferrable=True)"
)
fk = ForeignKeyConstraint([t1.c.c], [t2.c.c_rem], initially="XYZ")
if not util.sqla_08:
t1.append_constraint(fk)
eq_ignore_whitespace(
autogenerate._render_constraint(fk, self.autogen_context),
"sa.ForeignKeyConstraint(['c'], ['t2.c_rem'], initially='XYZ')"
)
