Mercurial > hg > Feedworm
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)