def test_year(self):
"""Exercise YEAR."""
year_table = Table(
"mysql_year",
self.metadata,
Column("y1", mysql.MSYear),
Column("y2", mysql.MSYear),
Column("y3", mysql.MSYear),
Column("y5", mysql.MSYear(4)),
)
for col in year_table.c:
self.assert_(repr(col))
year_table.create()
reflected = Table("mysql_year", MetaData(testing.db), autoload=True)
for table in year_table, reflected:
with testing.db.connect() as conn:
conn.execute(table.insert(["1950", "50", None, 1950]))
row = conn.execute(table.select()).first()
eq_(list(row), [1950, 2050, None, 1950])
conn.execute(table.delete())
self.assert_(colspec(table.c.y1).startswith("y1 YEAR"))
eq_(colspec(table.c.y5), "y5 YEAR(4)")
def test_year(self, metadata, connection):
"""Exercise YEAR."""
year_table = Table(
"mysql_year",
metadata,
Column("y1", mysql.MSYear),
Column("y2", mysql.MSYear),
Column("y3", mysql.MSYear),
Column("y5", mysql.MSYear(4)),
)
for col in year_table.c:
self.assert_(repr(col))
year_table.create(connection)
reflected = Table("mysql_year", MetaData(), autoload_with=connection)
for table in year_table, reflected:
connection.execute(
table.insert().values(["1950", "50", None, 1950])
)
row = connection.execute(table.select()).first()
eq_(list(row), [1950, 2050, None, 1950])
self.assert_(colspec(table.c.y1).startswith("y1 YEAR"))
eq_regex(colspec(table.c.y5), r"y5 YEAR(?:\(4\))?")
def test_year(self):
"""Exercise YEAR."""
year_table = Table('mysql_year', self.metadata,
Column('y1', mysql.MSYear),
Column('y2', mysql.MSYear),
Column('y3', mysql.MSYear),
Column('y5', mysql.MSYear(4)))
for col in year_table.c:
self.assert_(repr(col))
year_table.create()
reflected = Table('mysql_year', MetaData(testing.db), autoload=True)
for table in year_table, reflected:
table.insert(['1950', '50', None, 1950]).execute()
row = table.select().execute().first()
eq_(list(row), [1950, 2050, None, 1950])
table.delete().execute()
self.assert_(colspec(table.c.y1).startswith('y1 YEAR'))
eq_(colspec(table.c.y5), 'y5 YEAR(4)')
