| Paste number 66069: | unicode oddness |
| Pasted by: | desmaj |
| 3 months, 2 days ago | |
| None | |
| Paste contents: |
| 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()) |
This paste has no annotations.