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