Feedworm: Mapping.py annotate

annotate Mapping.py @ 30:ee1432a91141

map the potentially long columns as Text (CLOB) not as String (VARCHAR)

author	Dirk Olmes <dirk@xanthippe.ping.de>
date	Thu, 29 Apr 2010 16:49:45 +0200
parents	74481aa49974
children	5813e3c10f14

rev	line source
2 8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	1
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	2 from Feed import Feed
4 e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	3 from FeedEntry import FeedEntry
2 8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	4 from sqlalchemy import Column
5 bfd47f55d85b add the updated date of the feed Dirk Olmes <dirk@xanthippe.ping.de> parents: 4 diff changeset	5 from sqlalchemy import DateTime
4 e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	6 from sqlalchemy import ForeignKey
2 8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	7 from sqlalchemy import Integer
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	8 from sqlalchemy import MetaData
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	9 from sqlalchemy import String
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	10 from sqlalchemy import Table
30 ee1432a91141 map the potentially long columns as Text (CLOB) not as String (VARCHAR) Dirk Olmes <dirk@xanthippe.ping.de> parents: 29 diff changeset	11 from sqlalchemy import Text
2 8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	12 from sqlalchemy.orm import mapper
4 e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	13 from sqlalchemy.orm import relation
2 8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	14
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	15 def createMapping(engine):
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	16 metadata = MetaData(engine)
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	17
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	18 feedTable = Table("feed", metadata,
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	19 Column("pk", Integer, primary_key=True),
7 215c34f61e95 Feed.url -> Feed.rss_url Dirk Olmes <dirk@xanthippe.ping.de> parents: 6 diff changeset	20 Column("title", String(255), nullable=False),
215c34f61e95 Feed.url -> Feed.rss_url Dirk Olmes <dirk@xanthippe.ping.de> parents: 6 diff changeset	21 Column("rss_url", String(255), nullable=False)
2 8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	22 )
4 e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	23
e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	24 feedEntryTable = Table("feed_entry", metadata,
e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	25 Column("pk", Integer, primary_key=True),
6 87317ba41816 add a creation date for the feed entry Dirk Olmes <dirk@xanthippe.ping.de> parents: 5 diff changeset	26 Column("create_timestamp", DateTime, nullable=False),
29 74481aa49974 add a read flag for feed entries so they can be marked read Dirk Olmes <dirk@xanthippe.ping.de> parents: 7 diff changeset	27 Column("read", Integer, nullable=False),
6 87317ba41816 add a creation date for the feed entry Dirk Olmes <dirk@xanthippe.ping.de> parents: 5 diff changeset	28
4 e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	29 Column("id", String(255), nullable=False),
5 bfd47f55d85b add the updated date of the feed Dirk Olmes <dirk@xanthippe.ping.de> parents: 4 diff changeset	30 Column("link", String(255), nullable=False),
30 ee1432a91141 map the potentially long columns as Text (CLOB) not as String (VARCHAR) Dirk Olmes <dirk@xanthippe.ping.de> parents: 29 diff changeset	31 Column("title", Text, nullable=False),
ee1432a91141 map the potentially long columns as Text (CLOB) not as String (VARCHAR) Dirk Olmes <dirk@xanthippe.ping.de> parents: 29 diff changeset	32 Column("summary", Text, nullable=False),
5 bfd47f55d85b add the updated date of the feed Dirk Olmes <dirk@xanthippe.ping.de> parents: 4 diff changeset	33 Column("updated", DateTime),
4 e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	34 Column("feed_id", Integer, ForeignKey("feed.pk"))
e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	35 )
2 8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	36
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	37 metadata.create_all()
8a624ee48a74 First skeleton for sqlalchemy: define the mapping and create the first feed Dirk Olmes <dirk@xanthippe.ping.de> parents: diff changeset	38
4 e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	39 mapper(FeedEntry, feedEntryTable)
e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	40 mapper(Feed, feedTable,
e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	41 properties = {
e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	42 "entries" : relation(FeedEntry, backref = "feed")
e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	43 }
e0199f383442 retrieve a feed for the given URL, store entries as feed_entry rows into the database Dirk Olmes <dirk@xanthippe.ping.de> parents: 2 diff changeset	44 )

Mercurial > hg > Feedworm

annotate Mapping.py @ 30:ee1432a91141