def test_render_add_index_pg_where(self):
autogen_context = self.autogen_context
m = MetaData()
t = Table('t', m, Column('x', String), Column('y', String))
idx = Index('foo_idx',
t.c.x,
t.c.y,
postgresql_where=(t.c.y == 'something'))
op_obj = ops.CreateIndexOp.from_index(idx)
if compat.sqla_08:
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"""op.create_index('foo_idx', 't', \
['x', 'y'], unique=False, """
"""postgresql_where=sa.text(!U"y = 'something'"))""")
else:
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"""op.create_index('foo_idx', 't', ['x', 'y'], \
unique=False, """
"""postgresql_where=sa.text(!U't.y = %(y_1)s'))""")
def test_render_add_index_pg_where(self):
autogen_context = self.autogen_context
m = MetaData()
t = Table('t', m,
Column('x', String),
Column('y', String)
)
idx = Index('foo_idx', t.c.x, t.c.y,
postgresql_where=(t.c.y == 'something'))
op_obj = ops.CreateIndexOp.from_index(idx)
if util.sqla_08:
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"""op.create_index('foo_idx', 't', \
['x', 'y'], unique=False, """
"""postgresql_where=sa.text(!U"y = 'something'"))"""
)
else:
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"""op.create_index('foo_idx', 't', ['x', 'y'], \
unique=False, """
"""postgresql_where=sa.text(!U't.y = %(y_1)s'))"""
)
def test_inline_exclude_constraint_case_sensitive(self):
from sqlalchemy.dialects.postgresql import ExcludeConstraint
autogen_context = self.autogen_context
m = MetaData()
t = Table(
"TTable", m, Column("XColumn", String), Column("YColumn", String)
)
ExcludeConstraint(
(t.c.XColumn, ">"),
using="gist",
where='"XColumn" != 2',
name="TExclX",
)
op_obj = ops.CreateTableOp.from_table(t)
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"op.create_table('TTable',sa.Column('XColumn', sa.String(), "
"nullable=True),"
"sa.Column('YColumn', sa.String(), nullable=True),"
"postgresql.ExcludeConstraint((sa.column('XColumn'), '>'), "
"where=sa.text(!U'\"XColumn\" != 2'), using='gist', "
"name='TExclX'))",
)
def test_inline_exclude_constraint(self):
from sqlalchemy.dialects.postgresql import ExcludeConstraint
autogen_context = self.autogen_context
m = MetaData()
t = Table(
"t",
m,
Column("x", String),
Column("y", String),
ExcludeConstraint(
(column("x"), ">"),
using="gist",
where="x != 2",
name="t_excl_x",
),
)
op_obj = ops.CreateTableOp.from_table(t)
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"op.create_table('t',sa.Column('x', sa.String(), nullable=True),"
"sa.Column('y', sa.String(), nullable=True),"
"postgresql.ExcludeConstraint((sa.column('x'), '>'), "
"where=sa.text(!U'x != 2'), using='gist', name='t_excl_x')"
")",
)
def test_add_exclude_constraint_case_sensitive(self):
from sqlalchemy.dialects.postgresql import ExcludeConstraint
autogen_context = self.autogen_context
m = MetaData()
t = Table(
"TTAble", m, Column("XColumn", String), Column("YColumn", String)
)
op_obj = ops.AddConstraintOp.from_constraint(
ExcludeConstraint(
(t.c.XColumn, ">"),
where=t.c.XColumn != 2,
using="gist",
name="t_excl_x",
)
)
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"op.create_exclude_constraint('t_excl_x', 'TTAble', "
"(sa.column('XColumn'), '>'), "
"where=sa.text(!U'\"XColumn\" != 2'), using='gist')",
)
def test_inline_exclude_constraint(self):
from sqlalchemy.dialects.postgresql import ExcludeConstraint
autogen_context = self.autogen_context
m = MetaData()
t = Table(
't', m,
Column('x', String),
Column('y', String),
ExcludeConstraint(
('x', ">"),
using="gist",
where='x != 2',
name="t_excl_x"
)
)
op_obj = ops.CreateTableOp.from_table(t)
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"op.create_table('t',sa.Column('x', sa.String(), nullable=True),"
"sa.Column('y', sa.String(), nullable=True),"
"postgresql.ExcludeConstraint((!U'x', '>'), "
"where=sa.text(!U'x != 2'), using='gist', name='t_excl_x')"
")"
)
def test_inline_exclude_constraint_case_sensitive(self):
from sqlalchemy.dialects.postgresql import ExcludeConstraint
autogen_context = self.autogen_context
m = MetaData()
t = Table(
"TTable", m, Column("XColumn", String), Column("YColumn", String)
)
ExcludeConstraint(
(t.c.XColumn, ">"),
using="gist",
where='"XColumn" != 2',
name="TExclX",
)
op_obj = ops.CreateTableOp.from_table(t)
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"op.create_table('TTable',sa.Column('XColumn', sa.String(), "
"nullable=True),"
"sa.Column('YColumn', sa.String(), nullable=True),"
"postgresql.ExcludeConstraint((sa.column('XColumn'), '>'), "
"where=sa.text(!U'\"XColumn\" != 2'), using='gist', "
"name='TExclX'))",
)
def test_add_exclude_constraint_case_sensitive(self):
from sqlalchemy.dialects.postgresql import ExcludeConstraint
autogen_context = self.autogen_context
m = MetaData()
t = Table(
"TTAble", m, Column("XColumn", String), Column("YColumn", String)
)
op_obj = ops.AddConstraintOp.from_constraint(
ExcludeConstraint(
(t.c.XColumn, ">"),
where=t.c.XColumn != 2,
using="gist",
name="t_excl_x",
)
)
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"op.create_exclude_constraint('t_excl_x', 'TTAble', "
"(sa.column('XColumn'), '>'), "
"where=sa.text(!U'\"XColumn\" != 2'), using='gist')",
)
def test_render_add_index_pg_where(self):
autogen_context = self.autogen_context
m = MetaData()
t = Table("t", m, Column("x", String), Column("y", String))
idx = Index(
"foo_idx", t.c.x, t.c.y, postgresql_where=(t.c.y == "something")
)
op_obj = ops.CreateIndexOp.from_index(idx)
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"""op.create_index('foo_idx', 't', \
['x', 'y'], unique=False, """
"""postgresql_where=sa.text(!U"y = 'something'"))""",
)
def test_add_exclude_constraint(self):
from sqlalchemy.dialects.postgresql import ExcludeConstraint
autogen_context = self.autogen_context
m = MetaData()
t = Table('t', m, Column('x', String), Column('y', String))
op_obj = ops.AddConstraintOp.from_constraint(
ExcludeConstraint((t.c.x, ">"),
where=t.c.x != 2,
using="gist",
name="t_excl_x"))
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"op.create_exclude_constraint('t_excl_x', 't', (sa.column('x'), '>'), "
"where=sa.text(!U'x != 2'), using='gist')")
def test_render_add_index_pg_where(self):
autogen_context = self.autogen_context
m = MetaData()
t = Table("t", m, Column("x", String), Column("y", String))
idx = Index(
"foo_idx", t.c.x, t.c.y, postgresql_where=(t.c.y == "something")
)
op_obj = ops.CreateIndexOp.from_index(idx)
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"""op.create_index('foo_idx', 't', \
['x', 'y'], unique=False, """
"""postgresql_where=sa.text(!U"y = 'something'"))""",
)
def test_add_exclude_constraint(self):
from sqlalchemy.dialects.postgresql import ExcludeConstraint
autogen_context = self.autogen_context
m = MetaData()
t = Table("t", m, Column("x", String), Column("y", String))
op_obj = ops.AddConstraintOp.from_constraint(
ExcludeConstraint(
(t.c.x, ">"), where=t.c.x != 2, using="gist", name="t_excl_x"
)
)
eq_ignore_whitespace(
autogenerate.render_op_text(autogen_context, op_obj),
"op.create_exclude_constraint('t_excl_x', "
"'t', (sa.column('x'), '>'), "
"where=sa.text(!U'x != 2'), using='gist')",
)
