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,
