Python ForeignKey示例

示例#1

class Posts(db.Model):
    __tablename__ = 'posts'
    id = db.Column(db.Integer, primary_key=True)
    content = db.Column(db.Text)
    pid = db.Column(db.Integer, default=0)
    path = db.Column(db.String(255), default='0,')
    #记录时间的
    timestamp = db.Column(db.DateTime, default=datetime.utcnow)
    #user的外键
    uid = db.Column(db.Integer, db.ForeignKey('user.id'))

示例#2

文件： posts.py 项目： johnwang1996/myDemo

class Posts(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    content = db.Column(db.Text)
    title = db.Column(db.String(50), default='电影名称')
    pid = db.Column(db.Integer, default=0)
    image = db.Column(db.String(255), default='defaultImage,')
    timestamp = db.Column(db.DateTime, default=datetime.utcnow)
    uid = db.Column(db.Integer, db.ForeignKey('user.id'))
    characters = db.Column(db.String(255), default='暂无详细演员信息')  #演员名称
    director = db.Column(db.String(255), default="暂无详细导演信息")
    selfread = db.Column(db.Text, default="暂无作者观后感")

示例#3

文件： posts.py 项目： yuxuemin247/note

class Posts(DB_Base, db.Model):
    __tablename__ = 'posts'
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(20), index=True)  # 博客标题
    article = db.Column(db.Text)  # 博客的内容
    pid = db.Column(db.Integer, default=0)  # 父id
    path = db.Column(db.Text, default='0,')  # 路径
    visit = db.Column(db.Integer, default=0)  # 访问量
    timestamp = db.Column(db.DateTime, default=datetime.utcnow)  # 发表时间
    # 设置一对多外键
    uid = db.Column(db.Integer, db.ForeignKey('user.id'))  # 设置外键 关联主表user的自增id
    state = db.Column(db.Integer, default=0)  # 是否所有人可见

示例#4

文件： posts.py 项目： Darricklin/blog

class Posts(Base, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(23), index=True)
    article = db.Column(db.Text)
    pid = db.Column(db.Integer, default=0)
    path = db.Column(db.Text, default='0,')
    fabulous = db.Column(db.Integer, default=0)
    times = db.Column(db.Integer, default=0)
    timestamp = db.Column(db.DateTime, default=datetime.utcnow)
    #使用ForeignKey 来创建表的外键 作用是 和数据库中的user表(用户信息表)进行关联查询 表迁移以后 表中救会有一个 uid的字段  一对多 关系 一个用户 发表多个帖子 多的表使用ForeignKey 来关联1的一方
    #uid是模型Posts下的posts表单中的外键，关联的是User模型下的user表单中的id值，通过id值就可以找到对应的用户名，知道文章或评论是谁发的。
    uid = db.Column(db.Integer, db.ForeignKey('user.id'))

示例#5

文件： posts.py 项目： caoluyang8/blog

class Posts(Base,db.Model):
    __tablename__ = 'posts'
    id = db.Column(db.Integer,primary_key=True)
    title = db.Column(db.String(20)) #标题
    content = db.Column(db.Text) #博客内容
    pid = db.Column(db.Integer,default=0) #pid为0则为博客 否则为评论和回复
    path = db.Column(db.Text,default='0,') #路径path
    visit = db.Column(db.Integer,default=0) #访问量
    timestamp = db.Column(db.DateTime,default=datetime.utcnow) #发表的时间
    state = db.Column(db.Boolean,default=True) #默认所有人可见
    uid = db.Column(db.Integer,db.ForeignKey('user.id'))
    def __str__(self):
        return self.title

示例#6

class Posts(db.Model, Base):
    __tablename__ = 'posts'
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(23), index=True)
    article = db.Column(db.Text)
    pid = db.Column(db.Integer, default=0)
    path = db.Column(db.Text, default='0,')
    fabulous = db.Column(db.Integer, default=0)
    times = db.Column(db.Integer, default=0)
    timestamp = db.Column(db.DateTime, default=datetime.utcnow())
    scan = db.Column(db.Integer, default=0)
    #外键，与user表主键id关联，进行关联查询
    #表迁移后 表中会有一个uid字段 一对多 一个用户发表多个帖子
    uid = db.Column(db.Integer, db.ForeignKey('user.id'))

示例#7

文件： relationModel.py 项目： liuyu999/Second

class Email(db.Model):
    __tablename__ = 'emails'
    id = db.Column(db.Integer(), primary_key=True)
    email = db.Column(db.String(64))

    # 一对多
    # 声明外键 一般放在多的一方
    # db.ForeignKey(表名.主键)
    t_id = db.Column(db.Integer, db.ForeignKey('teachers.id'))

    # Teacher.mail << ==== >>Email.teacher 双向关系
    # 反向查询
    teacher = db.relationship('Teacher', backref='mail')

    def __repr__(self):
        return self.email

示例#8

class Posts(DB_Base, db.Model):
    __tablename__ = 'posts'
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(20), index=True)  # 标题
    article = db.Column(db.Text)  # md格式正文
    pid = db.Column(db.Integer, default=0)  # 父id
    path = db.Column(db.Text, default='0,')  # 路径
    visit = db.Column(db.Integer, default=0)  # 文章访问量
    timestamp = db.Column(db.DateTime, default=datetime.utcnow)  # 发表时间
    state = db.Column(db.Integer, default=0)  # 是否所有人可见
    img = db.Column(db.String(70))  # 图片

    tags = db.relationship('Categorys',
                           secondary=posts_categorys,
                           backref=db.backref('posts'))

    u_id = db.Column(db.Integer, db.ForeignKey('user.id'))  # 关联主表user的自增id

示例#9

文件： __init__.py 项目： xin17863935225/MyPythonProject

from .user import User
from .posts import Posts
from App.extensions import db

# 创建多对多中间表 存储多对多的id
collections = db.Table(
    'collections',
    db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
    db.Column('posts_id', db.Integer, db.ForeignKey('posts.id')),
)

示例#10

from App.extensions import db
from .db_base import DB_Base
from datetime import datetime

posts_categorys = db.Table(
    'posts_categorys',
    db.Column('posts_id',
              db.Integer,
              db.ForeignKey('posts.id'),
              primary_key=True),
    db.Column('categorys_id',
              db.Integer,
              db.ForeignKey('categorys.id'),
              primary_key=True))


# 博客模型
class Posts(DB_Base, db.Model):
    __tablename__ = 'posts'
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(20), index=True)  # 标题
    article = db.Column(db.Text)  # md格式正文
    pid = db.Column(db.Integer, default=0)  # 父id
    path = db.Column(db.Text, default='0,')  # 路径
    visit = db.Column(db.Integer, default=0)  # 文章访问量
    timestamp = db.Column(db.DateTime, default=datetime.utcnow)  # 发表时间
    state = db.Column(db.Integer, default=0)  # 是否所有人可见
    img = db.Column(db.String(70))  # 图片

    tags = db.relationship('Categorys',
                           secondary=posts_categorys,

示例#11

文件： relationModel.py 项目： liuyu999/Second

    t_id = db.Column(db.Integer, db.ForeignKey('teachers.id'))

    # Teacher.mail << ==== >>Email.teacher 双向关系
    # 反向查询
    teacher = db.relationship('Teacher', backref='mail')

    def __repr__(self):
        return self.email


# 使用中间表关联 多对对
article_tag = db.Table(
    'article_tag',  # 表名
    db.Column('article_id',
              db.Integer(),
              db.ForeignKey('article.id'),
              primary_key=True),
    db.Column('tag_id',
              db.Integer(),
              db.ForeignKey('tag.id'),
              primary_key=True))


# 文章
class Article(db.Model):
    __tablename__ = 'article'
    id = db.Column(db.Integer(), primary_key=True)
    # 书名
    title = db.Column(db.String(32), nullable=False)

    # 双向关系

示例#12

from .user import User
from .posts import Posts
from .course import Course
from App.extensions import db

#收藏帖子表，user和posts共用的中间表，在init中创建
collections = db.Table('collections',db.Column('user_id',db.Integer,db.ForeignKey('user.id')),db.Column('posts_id',db.Integer,db.ForeignKey('posts.id')))

示例#13

from .user import User
from .movie import Movie
from App.extensions import db


collections = db.Table('collections',
    db.Column('user_id',db.Integer,db.ForeignKey('user.id')),
    db.Column('movie_id',db.Integer,db.ForeignKey('movie.id')),
)