summaryrefslogtreecommitdiff
path: root/examples/plnt/database.py
diff options
context:
space:
mode:
Diffstat (limited to 'examples/plnt/database.py')
-rw-r--r--examples/plnt/database.py67
1 files changed, 39 insertions, 28 deletions
diff --git a/examples/plnt/database.py b/examples/plnt/database.py
index c74abb84..78e4ab6a 100644
--- a/examples/plnt/database.py
+++ b/examples/plnt/database.py
@@ -8,62 +8,73 @@
:copyright: 2007 Pallets
:license: BSD-3-Clause
"""
-from sqlalchemy import MetaData, Table, Column, ForeignKey, \
- Integer, String, DateTime
-from sqlalchemy.orm import dynamic_loader, scoped_session, create_session, \
- mapper
-from plnt.utils import application, local_manager
+from sqlalchemy import Column
+from sqlalchemy import DateTime
+from sqlalchemy import ForeignKey
+from sqlalchemy import Integer
+from sqlalchemy import MetaData
+from sqlalchemy import String
+from sqlalchemy import Table
+from sqlalchemy.orm import create_session
+from sqlalchemy.orm import dynamic_loader
+from sqlalchemy.orm import mapper
+from sqlalchemy.orm import scoped_session
+
+from .utils import application
+from .utils import local_manager
def new_db_session():
- return create_session(application.database_engine, autoflush=True,
- autocommit=False)
+ return create_session(application.database_engine, autoflush=True, autocommit=False)
+
metadata = MetaData()
session = scoped_session(new_db_session, local_manager.get_ident)
-blog_table = Table('blogs', metadata,
- Column('id', Integer, primary_key=True),
- Column('name', String(120)),
- Column('description', String),
- Column('url', String(200)),
- Column('feed_url', String(250))
+blog_table = Table(
+ "blogs",
+ metadata,
+ Column("id", Integer, primary_key=True),
+ Column("name", String(120)),
+ Column("description", String),
+ Column("url", String(200)),
+ Column("feed_url", String(250)),
)
-entry_table = Table('entries', metadata,
- Column('id', Integer, primary_key=True),
- Column('blog_id', Integer, ForeignKey('blogs.id')),
- Column('guid', String(200), unique=True),
- Column('title', String(140)),
- Column('url', String(200)),
- Column('text', String),
- Column('pub_date', DateTime),
- Column('last_update', DateTime)
+entry_table = Table(
+ "entries",
+ metadata,
+ Column("id", Integer, primary_key=True),
+ Column("blog_id", Integer, ForeignKey("blogs.id")),
+ Column("guid", String(200), unique=True),
+ Column("title", String(140)),
+ Column("url", String(200)),
+ Column("text", String),
+ Column("pub_date", DateTime),
+ Column("last_update", DateTime),
)
class Blog(object):
query = session.query_property()
- def __init__(self, name, url, feed_url, description=u''):
+ def __init__(self, name, url, feed_url, description=u""):
self.name = name
self.url = url
self.feed_url = feed_url
self.description = description
def __repr__(self):
- return '<%s %r>' % (self.__class__.__name__, self.url)
+ return "<%s %r>" % (self.__class__.__name__, self.url)
class Entry(object):
query = session.query_property()
def __repr__(self):
- return '<%s %r>' % (self.__class__.__name__, self.guid)
+ return "<%s %r>" % (self.__class__.__name__, self.guid)
mapper(Entry, entry_table)
-mapper(Blog, blog_table, properties=dict(
- entries=dynamic_loader(Entry, backref='blog')
-))
+mapper(Blog, blog_table, properties=dict(entries=dynamic_loader(Entry, backref="blog")))