From f846a2487c3d7c14f07e7f9b3d5aa0d803733ed9 Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Sat, 8 Mar 2014 17:26:53 +0100 Subject: get rid of lastrowid usage On psycopg2 the lastrowid attribute is always 0. The documentation advises to use inserted_primary_key instead, but in order to use that, the sqlalchemy expression language must be used. --- dedup/schema.py | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 dedup/schema.py (limited to 'dedup') diff --git a/dedup/schema.py b/dedup/schema.py new file mode 100644 index 0000000..569408f --- /dev/null +++ b/dedup/schema.py @@ -0,0 +1,16 @@ +import sqlalchemy + +metadata = sqlalchemy.MetaData() + +package = sqlalchemy.Table("package", metadata, + sqlalchemy.Column('id', sqlalchemy.Integer, primary_key=True), + sqlalchemy.Column('name', sqlalchemy.Text, unique=True), + sqlalchemy.Column('version', sqlalchemy.Text), + sqlalchemy.Column('architecture', sqlalchemy.Text), + sqlalchemy.Column('source', sqlalchemy.Text)) + +content = sqlalchemy.Table("content", metadata, + sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True), + sqlalchemy.Column("pid", None, sqlalchemy.ForeignKey("package.id")), + sqlalchemy.Column("filename", sqlalchemy.Text), + sqlalchemy.Column("size", sqlalchemy.Integer)) -- cgit v1.2.3