def get_verify_token(token): s = Serializer(app.config['SECRET_KEY']) try: user_id = s.loads(token)['user_id'] except itsdangerous.SignatureExpired: return None return Student.query.get(user_id) class Event(db.Model): id = db.Column(db.Integer,primary_key=True) title = db.Column(db.String(15),nullable=False,unique=True) des1 = db.Column(db.String(300),nullable=False) des2 = db.Column(db.String(300)) event_place = db.Column(db.String(20)) event_date = db.Column(db.Date) event_time = db.Column(db.String(10),nullable=False,default='10:00') image_file = db.Column(db.String(64),default='rahul.jpg') likes = db.Column(db.Integer,default=0) def __repr__(self): return '<Event %r>' % self.title db.Table('student_events', db.Column('student_id',db.Integer,db.ForeignKey('student.id')), db.Column('event_id',db.Integer,db.ForeignKey('event.id')), db.Column('liked_by_id',db.Boolean) )
from datetime import datetime from hashlib import md5 from time import time from flask_login import UserMixin from werkzeug.security import generate_password_hash, check_password_hash import jwt from myapp import app, db, login 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): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(64), index=True, unique=True) email = db.Column(db.String(120), index=True, unique=True) password_hash = db.Column(db.String(128)) posts = db.relationship('Post', backref='author', lazy='dynamic') about_me = db.Column(db.String(140)) last_seen = db.Column(db.DateTime, default=datetime.utcnow) followed = db.relationship('User', secondary=followers, primaryjoin=(followers.c.follower_id == id), secondaryjoin=(followers.c.followed_id == id), backref=db.backref('followers', lazy='dynamic'), lazy='dynamic') def __repr__(self): return '<User {}>'.format(self.username)
# vim:fileencoding=utf8 from myapp import db class Projects(db.Model): def __init__(self, title, description): self.title = title self.description = description # テーブル自動読み込み&Projectsクラスにマッピング # スキーマはSQLファイルにて定義 db.mapper(Projects, db.Table('projects', db.metadata, autoload=True))
# -*- coding:utf8 -*- # 2014.12.29 __author__ = 'skyway' from myapp import db import datetime # 关注/粉丝表 followers = db.Table( 'followers', db.Column('follower_id', db.Integer, db.ForeignKey('user.id')), db.Column('followed_id', db.Integer, db.ForeignKey('user.id')), db.Column('timestamp', db.DateTime, default=datetime.datetime.now)) # 用户信息表 class User(db.Model): __tablename__ = 'user' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.BigInteger) # by skyway@14-11-22 随机6位数字+id,防止爬虫 qq = db.Column(db.String(15), unique=True) # 是否加密 password = db.Column(db.String(50)) nickname = db.Column(db.String(20)) sex = db.Column(db.String(5)) age = db.Column(db.SmallInteger) height = db.Column(db.SmallInteger, default=0) degree = db.Column(db.String(10)) condition = db.Column(db.String(10)) department = db.Column(db.String(20)) income = db.Column(db.String(10))
def __repr__(self): return "<Client %r>" % (self.fname+" "+self.lname) def full_name(self): return self.fname+" "+self.lname @classmethod def get_client_by_email(cls, email): return Client.query.filter_by(email=email).first() # To save services which are booked in booking service_booked = db.Table( 'service_booked', db.Column('booking_id', db.Integer, db.ForeignKey('booking.id')), db.Column('service_id', db.Integer, db.ForeignKey('service.id')) ) # To save services which are provided in booking service_provided = db.Table( 'service_provided', db.Column('booking_id', db.Integer, db.ForeignKey('booking.id')), db.Column('service_id', db.Integer, db.ForeignKey('service.id')) ) class Booking(db.Model): __tablename__ = 'booking' id = db.Column(db.Integer, primary_key=True) is_cancel = db.Column(db.Boolean, default=False)
from myapp import db class Factura(db.Model): def __init__(self, numeroFactura, fechaEmision, fechaRadicacion, fechaVencimiento, fechaPago, valorBruto, descuento, iva, retencionIva, retencionFuente, retencionICA, otrasRetenciones): self.numeroFactura = numeroFactura self.fechaEmision = fechaEmision self.fechaRadicacion = fechaRadicacion self.fechaVencimiento = fechaVencimiento self.fechaPago = fechaPago self.valorBruto = valorBruto self.descuento = descuento self.iva = iva self.retencionIva = retencionIva self.retencionFuente = retencionFuente self.retencionICA = retencionICA self.otrasRetenciones = otrasRetenciones db.mapper(Factura, db.Table('factura', db.metadata, autoload=True))
from myapp import db from datetime import datetime user_course_table = db.Table( 'user_course', db.Column('user_id', db.Integer, db.ForeignKey('users.id')), db.Column('course_id', db.Integer, db.ForeignKey('courses.id'))) user_module_table = db.Table( 'user_module', db.Column('user_id', db.Integer, db.ForeignKey('users.id')), db.Column('module_id', db.Integer, db.ForeignKey('modules.id'))) class User(db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) avatar = db.Column(db.String(255)) sex = db.Column(db.String(10)) age = db.Column(db.Integer) account = db.Column(db.String(100), unique=True, nullable=False) password = db.Column(db.String(255), nullable=False) describe = db.Column(db.Text) created_at = db.Column(db.DateTime, default=datetime.now()) courses = db.relationship("Course", secondary=user_course_table) modules = db.relationship("Module", secondary=user_module_table) def to_json(self): return { "id": self.id, "account": self.account, "name": self.name,