diff Mapping.py @ 2:8a624ee48a74

First skeleton for sqlalchemy: define the mapping and create the first feed
author Dirk Olmes <dirk@xanthippe.ping.de>
date Mon, 26 Apr 2010 17:40:55 +0200
parents
children e0199f383442
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Mapping.py	Mon Apr 26 17:40:55 2010 +0200
@@ -0,0 +1,21 @@
+
+from Feed import Feed
+from sqlalchemy import Column
+from sqlalchemy import Integer
+from sqlalchemy import MetaData
+from sqlalchemy import String
+from sqlalchemy import Table
+from sqlalchemy.orm import mapper
+
+def createMapping(engine):
+    metadata = MetaData(engine)
+    
+    feedTable = Table("feed", metadata,
+        Column("pk", Integer, primary_key=True),
+        Column("name", String(255), nullable=False),
+        Column("url", String(255), nullable=False)
+    )
+
+    metadata.create_all()
+
+    mapper(Feed, feedTable)