def test_drop_unique_constraint_change_name(self): schema_obj = schemaobj.SchemaObjects() const = schema_obj.unique_constraint("x", "foobar", ["a"]) op = ops.DropConstraintOp.from_constraint(const) op.constraint_name = "my_name" eq_(op.to_constraint().name, "my_name") eq_(op.reverse().to_constraint().name, "my_name")
def test_create_table_add_kw(self): schema_obj = schemaobj.SchemaObjects() table = schema_obj.table("x", Column("q", Integer)) op = ops.CreateTableOp.from_table(table) op.kw["postgresql_partition_by"] = "x" eq_(op.to_table().dialect_kwargs["postgresql_partition_by"], "x") eq_( op.reverse().to_table().dialect_kwargs["postgresql_partition_by"], "x", )
def test_create_index_add_kw(self): schema_obj = schemaobj.SchemaObjects() idx = schema_obj.index("x", "y", ["z"]) op = ops.CreateIndexOp.from_index(idx) op.kw["postgresql_concurrently"] = True eq_(op.to_index().dialect_kwargs["postgresql_concurrently"], True) eq_( op.reverse().to_index().dialect_kwargs["postgresql_concurrently"], True, )
def test_create_unique_constraint_add_kw(self): schema_obj = schemaobj.SchemaObjects() const = schema_obj.unique_constraint("x", "foobar", ["a"]) op = ops.AddConstraintOp.from_constraint(const) is_not_(op.to_constraint(), const) op.kw["sqlite_on_conflict"] = "IGNORE" eq_(op.to_constraint().dialect_kwargs["sqlite_on_conflict"], "IGNORE") eq_( op.reverse().to_constraint().dialect_kwargs["sqlite_on_conflict"], "IGNORE", )