from pysqlite2 import dbapi2 as sqlite
import sqlalchemy as sa

sqlite_engine = sa.create_engine("sqlite:///test_engine.db")

metadata = sa.MetaData()
metadata.bind = sqlite_engine

test_table = sa.Table("testing", metadata,
                      sa.Column("test_column", sa.Unicode(60)))
try:
    test_table.drop()
except Exception, exc:
    pass
test_table.create()

con = sqlite.connect("test_engine.db")
cursor = con.cursor()
cursor.execute("insert into testing (test_column) values (:test_column)",
               {"test_column": u""})
cursor.close()
cursor = con.cursor()
cursor.execute("select test_column from testing")
rows = cursor.fetchall()
cursor.close()
for row in rows:
    assert u"" == row[0]
    assert "" == row[0]
cursor = con.cursor()
cursor.execute("delete from testing")
cursor.close()
con.commit()

sqlite_engine.execute(test_table.insert({"testing": u""}))
row = sqlite_engine.execute(test_table.select())
for row in row:
    assert u"" == row.test_column, repr(row.test_column)
sqlite_engine.execute(test_table.delete())