class PostgresqlInlineLiteralTest(TestBase):
__only_on__ = "postgresql"
__backend__ = True
@classmethod
def setup_class(cls):
cls.bind = config.db
with config.db.connect() as conn:
conn.execute(
text("""
create table tab (
col varchar(50)
)
"""))
conn.execute(
text("""
insert into tab (col) values
('old data 1'),
('old data 2.1'),
('old data 3')
"""))
@classmethod
def teardown_class(cls):
with cls.bind.connect() as conn:
conn.execute(text("drop table tab"))
def setUp(self):
self.conn = self.bind.connect()
ctx = MigrationContext.configure(self.conn)
self.op = Operations(ctx)
def tearDown(self):
self.conn.close()
def test_inline_percent(self):
# TODO: here's the issue, you need to escape this.
tab = table("tab", column("col"))
self.op.execute(
tab.update().where(tab.c.col.like(
self.op.inline_literal("%.%"))).values(
col=self.op.inline_literal("new data")),
execution_options={"no_parameters": True},
)
eq_(
self.conn.execute(
text(
"select count(*) from tab where col='new data'")).scalar(),
1,
)
class PostgresqlInlineLiteralTest(TestBase):
__only_on__ = "postgresql"
__backend__ = True
@classmethod
def setup_class(cls):
cls.bind = config.db
cls.bind.execute(
"""
create table tab (
col varchar(50)
)
"""
)
cls.bind.execute(
"""
insert into tab (col) values
('old data 1'),
('old data 2.1'),
('old data 3')
"""
)
@classmethod
def teardown_class(cls):
cls.bind.execute("drop table tab")
def setUp(self):
self.conn = self.bind.connect()
ctx = MigrationContext.configure(self.conn)
self.op = Operations(ctx)
def tearDown(self):
self.conn.close()
def test_inline_percent(self):
# TODO: here's the issue, you need to escape this.
tab = table("tab", column("col"))
self.op.execute(
tab.update()
.where(tab.c.col.like(self.op.inline_literal("%.%")))
.values(col=self.op.inline_literal("new data")),
execution_options={"no_parameters": True},
)
eq_(
self.conn.execute(
"select count(*) from tab where col='new data'"
).scalar(),
1,
)
class PostgresqlInlineLiteralTest(TestBase):
__only_on__ = 'postgresql'
@classmethod
def setup_class(cls):
cls.bind = config.db
cls.bind.execute("""
create table tab (
col varchar(50)
)
""")
cls.bind.execute("""
insert into tab (col) values
('old data 1'),
('old data 2.1'),
('old data 3')
""")
@classmethod
def teardown_class(cls):
cls.bind.execute("drop table tab")
def setUp(self):
self.conn = self.bind.connect()
ctx = MigrationContext.configure(self.conn)
self.op = Operations(ctx)
def tearDown(self):
self.conn.close()
def test_inline_percent(self):
# TODO: here's the issue, you need to escape this.
tab = table('tab', column('col'))
self.op.execute(
tab.update().where(
tab.c.col.like(self.op.inline_literal('%.%'))
).values(col=self.op.inline_literal('new data')),
execution_options={'no_parameters': True}
)
eq_(
self.conn.execute(
"select count(*) from tab where col='new data'").scalar(),
1,
)
class PostgresqlInlineLiteralTest(TestCase):
@classmethod
def setup_class(cls):
cls.bind = db_for_dialect("postgresql")
cls.bind.execute("""
create table tab (
col varchar(50)
)
""")
cls.bind.execute("""
insert into tab (col) values
('old data 1'),
('old data 2.1'),
('old data 3')
""")
@classmethod
def teardown_class(cls):
cls.bind.execute("drop table tab")
def setUp(self):
self.conn = self.bind.connect()
ctx = MigrationContext.configure(self.conn)
self.op = Operations(ctx)
def tearDown(self):
self.conn.close()
def test_inline_percent(self):
# TODO: here's the issue, you need to escape this.
tab = table('tab', column('col'))
self.op.execute(
tab.update().where(
tab.c.col.like(self.op.inline_literal('%.%'))
).values(col=self.op.inline_literal('new data')),
execution_options={'no_parameters': True}
)
eq_(
self.conn.execute(
"select count(*) from tab where col='new data'").scalar(),
1,
)
def create_indexes(engine):
conn = engine.connect()
ctx = MigrationContext.configure(conn)
op = Operations(ctx)
print("Creating indexes...")
op.execute(
"CREATE INDEX IF NOT EXISTS CityoftheProvider_idx ON mytable(CityoftheProvider)"
)
op.execute(
"CREATE INDEX IF NOT EXISTS ZipCodeoftheProvider_idx on mytable(ZipCodeoftheProvider)"
)
op.execute(
"CREATE INDEX IF NOT EXISTS StateCodeoftheProvider_idx on mytable(StateCodeoftheProvider)"
)
op.execute(
"CREATE INDEX IF NOT EXISTS CountryCodeoftheProvider_idx on mytable(CountryCodeoftheProvider)"
)
op.execute(
"CREATE INDEX IF NOT EXISTS ProviderType_idx on mytable(ProviderType)")
op.execute(
"CREATE INDEX IF NOT EXISTS HCPCSCode_idx on mytable(HCPCSCode)")
