diff feedupdate-main.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/feedupdate-main.py	Mon Apr 26 17:40:55 2010 +0200
@@ -0,0 +1,30 @@
+#!/usr/bin/env python
+
+from ConfigParser import ConfigParser
+from Feed import Feed
+import Mapping
+import socket
+from sqlalchemy import create_engine
+from sqlalchemy.orm import sessionmaker
+
+def loadDatabaseProperties():
+    hostname = socket.gethostname()
+    filename = "database-%s.ini" % hostname
+
+    parser = ConfigParser();
+    parser.read(filename)
+    return parser.get("database", "url")
+
+def createFeed(session):
+    newFeed = Feed("Joel on Software", "http://www.joelonsoftware.com/rss.xml")
+    session.add(newFeed)
+    session.commit()
+
+if __name__ == "__main__":
+    databaseUrl = loadDatabaseProperties()
+    engine = create_engine(databaseUrl,echo=True)
+    Mapping.createMapping(engine)
+    SessionMaker = sessionmaker(bind = engine)
+    session = SessionMaker()
+    
+    createFeed(session)