class Email(db.Model):
__table__ = db.Table('email',
db.metadata,
db.Column('id', db.Integer, primary_key=True),
db.Column('email', db.String),
db.Column('user_id', db.Integer),
schema='email')
class Tag(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
# Placeholders:
# pages is created automatically via the Page model
__tablename__ = 'tag'
__table_args__ = {'schema': 'public'}
class UserInfo(db.Model):
timezone_id = db.Column(db.Integer, db.ForeignKey('public.timezone.id'))
timezone = db.relationship('Timezone',
primaryjoin='Timezone.id==UserInfo.timezone_id')
user_id = db.Column(db.Integer, primary_key=True)
__tablename__ = 'user_info'
__table_args__ = {'schema': 'aaa'}
class Page(db.Model):
id = db.Column(db.Integer, primary_key=True)
url = db.Column(db.String)
tags = db.relationship('Tag',
secondary=PageTags,
backref=db.backref('pages', lazy='dynamic'))
__tablename__ = 'page'
__table_args__ = {'schema': 'public'}
def __init__(self, url=url):
self.url = url
class User(db.Model):
active = db.Column(db.Boolean)
default_ipv4_mask = db.Column(db.Integer)
default_ipv6_mask = db.Column(db.Integer)
max_concurrent_sessions = db.Column(db.Integer)
registration_utc = db.Column(db.DateTime(timezone=True))
timezone_id = db.Column(db.Integer, db.ForeignKey('public.timezone.id'))
timezone = db.relationship('Timezone', primaryjoin='Timezone.id==User.timezone_id')
user_id = db.Column(db.Integer, primary_key=True)
__tablename__ = 'user'
__table_args__ = {'schema':'aaa'}
from skeleton import db
PageTags = db.Table('page_tags', db.metadata,
db.Column('page_id', db.Integer, db.ForeignKey('public.page.id')),
db.Column('tag_id', db.Integer, db.ForeignKey('public.tag.id')),
schema='public'
)
class H2(db.Model):
__table__ = db.Table(
'h2', db.metadata,
db.Column('id', db.Integer, primary_key=True),
db.Column('val2', db.String),
schema='mod1')
class H3(db.Model):
id = db.Column(db.Integer, primary_key=True)
val2 = db.Column(db.String)
__table_args__ = {'schema': 'public'}
class Timezone(db.Model):
__table__ = db.Table('timezone',
db.metadata,
db.Column('id', db.Integer, primary_key=True),
db.Column('name', db.String),
schema='public')
