Python Table示例

示例#1

文件： campaign.py 项目： Piiiiiii/SQLAlchemy-Flask-Swagger

from sqlalchemy import Column, Integer, String, ForeignKey, Enum, Date, Float
from sqlalchemy.dialects.postgresql import UUID
from datetime import datetime
import re

from app.models.base import Base, db
from app.models.user import User

campaign_editorial_topic = db.Table(
    'campaign_editorial_topic',
    Column('campaign_id', Integer, ForeignKey('campaign.campaign_id')),
    Column('editorial_topic_id', Integer,
           ForeignKey('editorial_topic.editorial_topic_id')),
)


class Campaign(Base):
    __tablename__ = 'campaign'
    index = Column(Integer, primary_key=True, autoincrement=True)
    # TODO: list campaign table schema here
    # user_id = Column(UUID)
    # token = Column(String)
    campaign_id = Column(Integer, unique=True)
    campaign_name = Column(String)
    campaign_obj_type = Column(
        Enum('私域促活/留存', '私域拉新', '裂变', name='campaign objective type'))
    campaign_time_start = Column(Date)
    campaign_time_end = Column(Date)
    campaign_core_metric_type = Column(String)
    campaign_core_metric_value = Column(Float)
    editorial_topics = db.relationship('Editorial_topic',

示例#2

文件： models.py 项目： buppter/article_review

from app import login_manager
from app.models.base import Base, db

_Author_ = 'BUPPT'


class Permission:
    AUTHOR = 2
    REVIEWER = 4
    EDITOR = 8
    ADMIN = 16


user_roles = db.Table(
    'user_roles', db.Column('user_id', db.Integer, db.ForeignKey("users.id")),
    db.Column('role_id', db.Integer, db.ForeignKey("roles.id")))


class Role(db.Model):
    __tablename__ = 'roles'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(64), unique=True)
    default = db.Column(db.Boolean, default=False, index=True)
    permissions = db.Column(db.Integer)

    def __repr__(self):
        return '<Role id={0}, name={1}>'.format(self.id, self.name)

    def __init__(self, **kwargs):
        super(Role, self).__init__(**kwargs)

示例#3

from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.dialects.postgresql import UUID

from app.models.base import Base, db
from app.models.campaign import Campaign

# If a table exists, create_all will not update the changed table. So you should delete this table first.

editorial_topic_tag = db.Table(
    'editorial_topic_tag',
    Column('editorial_topic_id', Integer,
           ForeignKey('editorial_topic.editorial_topic_id')),
    Column('tag_index', Integer, ForeignKey('tag.index')),
)

editorial_topic_article = db.Table(
    'editorial_topic_article',
    Column('editorial_topic_id', Integer,
           ForeignKey('editorial_topic.editorial_topic_id')),
    Column('article_id', Integer, ForeignKey('article.article_id')),
)


# user is a keyword for pqsql
class Editorial_topic(Base):
    __tablename__ = 'editorial_topic'
    index = Column(Integer, primary_key=True, autoincrement=True)
    # TODO: list campaign table schema here
    editorial_topic_id = Column(Integer, unique=True)
    editorial_topic_name = Column(String)
    editorial_topic_description = Column(String)

示例#4

文件： user.py 项目： Piiiiiii/SQLAlchemy-Flask-Swagger

from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.dialects.postgresql import UUID

from app.models.base import Base, db
# from app.models.campaign import Campaign

# If a table exists, create_all will not update the changed table. So you should delete this table first.

user_campaign = db.Table(
    'user_campaign',
    Column('user_id', Integer, ForeignKey('user_table.user_id')),
    Column('campaign_id', Integer, ForeignKey('campaign.campaign_id')),
)


# user is a keyword for pqsql
class User(Base):
    __tablename__ = 'user_table'
    index = Column(Integer, primary_key=True, autoincrement=True)
    # TODO: list campaign table schema here
    user_id = Column(Integer, unique=True)
    campaigns = db.relationship('Campaign',
                                secondary=user_campaign,
                                backref=db.backref('users', lazy='dynamic'))

    def keys(self):
        self.hide('index')
        return self.fields

    @staticmethod
    def create_user(user_id):

示例#5

文件： article.py 项目： Piiiiiii/SQLAlchemy-Flask-Swagger

from sqlalchemy import Column, Integer, String, ForeignKey, Float, Text, Date
from sqlalchemy.dialects.postgresql import UUID

from app.models.base import Base, db
from app.models.editorial_topic import Editorial_topic

# If a table exists, create_all will not update the changed table. So you should delete this table first.

article_tag = db.Table(
    'article_tag',
    Column('article_id', Integer, ForeignKey('article.article_id')),
    Column('tag_index', Integer, ForeignKey('tag.index')),
)


# user is a keyword for pqsql
class Article(Base):
    __tablename__ = 'article'
    index = Column(Integer, primary_key=True, autoincrement=True)
    # TODO: list campaign table schema here
    article_id = Column(Integer, unique=True)
    article_importance = Column(Float)
    author = Column(String)
    source = Column(String)
    title = Column(String)
    url = Column(Text)
    time_created = Column(Date)
    thumbnail_url = Column(Text)
    abstract = Column(Text)
    tags = db.relationship('Tag',
                           secondary=article_tag,