Python Table示例

示例#1

                                    uselist=False)

    def get_url(self):
        return url_for("www.path",
                       username=self.path_user.username,
                       path_slug=self.slug)


like_list_user_bridge = db.Table(
    "like_list_user_bridge",
    db.Column(
        "user_id",
        db.Integer,
        db.ForeignKey("users.id", ondelete="CASCADE"),
        primary_key=True,
    ),
    db.Column(
        "like_list_id",
        db.Integer,
        db.ForeignKey("like_lists.id", ondelete="CASCADE"),
        primary_key=True,
    ),
)


class LikeList(PkModel):

    __tablename__ = "like_lists"

    path_id = db.Column(db.Integer, db.ForeignKey("paths.id"), nullable=False)
    users = db.relationship(

示例#2

文件： models.py 项目： JacksonMetivier/SocialMediaWebsite

from flask_wtf import FlaskForm
from wtforms import StringField, PasswordField, BooleanField, SubmitField, TextAreaField
from flask_login import LoginManager, login_user, logout_user, login_required, UserMixin, current_user
from wtforms.validators import DataRequired, ValidationError, Email, EqualTo, Length
from werkzeug.security import generate_password_hash, check_password_hash
from datetime import datetime
from init import db

followers = db.Table(
    'followers', db.Column('follower_id', db.Integer,
                           db.ForeignKey('user.id')),
    db.Column('followed_id', db.Integer, db.ForeignKey('user.id')))


class User(UserMixin, db.Model):
    __tablename__ = 'user'
    id = db.Column(db.Integer, primary_key=True)
    first_name = db.Column(db.String(24), index=True)
    last_name = db.Column(db.String(24), index=True)
    where_from = db.Column(db.String(50), index=True)
    email = db.Column(db.String(72), index=True)
    password_hash = db.Column(db.String(128))
    posts = db.relationship('Post', backref='user', lazy='dynamic')
    profile_picture = db.relationship('Files', backref='user')
    phone = db.Column(db.Unicode(255))
    dob = db.Column(db.DateTime)
    about_me = db.Column(db.String(200))
    liked = db.relationship('PostLike',
                            foreign_keys='PostLike.user_id',
                            backref='user',
                            lazy='dynamic')

示例#3

import hashlib
from datetime import timedelta
from passlib.hash import bcrypt
from flask_security import Security, SQLAlchemyUserDatastore, UserMixin, RoleMixin
from flask_jwt_extended import create_access_token, create_refresh_token

from init import db, app


roles_users = db.Table(
    'roles_users',
    db.Column('user_id', db.Integer(), db.ForeignKey('user.id')),
    db.Column('role_id', db.Integer(), db.ForeignKey('role.id'))
)


class Role(RoleMixin, db.Model):
    """ роль пользователя """
    
    id = db.Column(db.Integer(), primary_key=True)
    name = db.Column(db.String(80), unique=True)
    description = db.Column(db.String(255))
  
    def __str__(self):
        return self.name


class User(UserMixin, db.Model):
    """ модель пользователя """
    
    id = db.Column(db.Integer, primary_key=True)

示例#4

文件： models.py 项目： Abdur-rahmaanJ/traveller

from itsdangerous import URLSafeTimedSerializer
from werkzeug.security import check_password_hash
from werkzeug.security import generate_password_hash
from flask import current_app

from init import db
from shopyo.api.models import PkModel

role_user_bridge = db.Table(
    "role_user_bridge",
    db.Column(
        "user_id",
        db.Integer,
        db.ForeignKey("users.id", ondelete="CASCADE"),
        primary_key=True,
    ),
    db.Column(
        "role_id",
        db.Integer,
        db.ForeignKey("roles.id", ondelete="CASCADE"),
        primary_key=True,
    ),
)


class AnonymousUser(AnonymousUserMixin):
    """ Anonymous user class """
    def __init__(self):
        self.username = "******"
        self.email = "<anonymous-user-no-email>"

示例#5

from werkzeug.security import generate_password_hash, check_password_hash
from itsdangerous import TimedJSONWebSignatureSerializer as Serializer
from datetime import datetime
from flask import current_app, request, url_for

from init import db, login_manager

#用户角色多对多关系表
from pyfw.util import JsonUtil

user_role_mapper = db.Table(
    'common_user_roles',
    db.Column('user_id',
              db.Integer,
              db.ForeignKey('common_user_info.id'),
              nullable=False,
              primary_key=True),
    db.Column('role_id',
              db.Integer,
              db.ForeignKey('common_role_info.id'),
              nullable=False,
              primary_key=True))

#用户组织多对多关系表
user_org_mapper = db.Table(
    'common_user_org',
    db.Column('user_id',
              db.Integer,
              db.ForeignKey('common_user_info.id'),
              nullable=False,
              primary_key=True),
    db.Column('org_id',

示例#6

                                    backref="reviewer_list_conf",
                                    lazy=True,
                                    uselist=False)

    def __repr__(self):
        return 'conf:{}'.format(self.year)


conf_list_user_bridge = db.Table(
    "conf_list_user_bridge",
    db.Column(
        "user_id",
        db.Integer,
        db.ForeignKey("users.id", ondelete="CASCADE"),
        primary_key=True,
    ),
    db.Column(
        "reviewer_list_id",
        db.Integer,
        db.ForeignKey("reviewer_lists.id", ondelete="CASCADE"),
        primary_key=True,
    ),
)


class ReviewerList(PkModel):

    __tablename__ = "reviewer_lists"

    conf_id = db.Column(db.Integer,
                        db.ForeignKey("conferences.id"),