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.

1 files changed, 16 insertions, 0 deletions

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))