class Entry(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100)) content = db.Column(db.Text) content_html = db.Column(db.Text) fragment = db.Column(db.Text) #内容片段, 用于主页显示 status = db.Column(db.Integer, default=1) #完成:1, 失败0, 草稿:-1 (暂时无用) create_time = db.Column(db.DateTime, index=True, default=datetime.now()) modified_time = db.Column(db.DateTime, default=datetime.now()) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) category = db.relationship('Category', backref=db.backref('entries', lazy='dynamic'), lazy='select') category_id = db.Column(db.Integer, db.ForeignKey('category.id')) tag = db.relationship('Tag', secondary=tag_entry, backref=db.backref('entries', lazy='dynamic')) view_count = db.Column(db.Integer, default=0) @staticmethod def on_changed_content(target, value, oldvalue, initator): if CONTENT_FORMAT == 'html': target.content_html = value else: target.content_html = md2html(text=value) def __repr__(self): return '<Entry %r>' % self.title def __unicode__(self): return self.title
class Followrelationship(db.Model): __tablename__ = 'follow' id = db.Column(db.Integer, primary_key=True, autoincrement=True) follower_id = db.Column(db.Integer, db.ForeignKey('customer.id')) followed_id = db.Column(db.Integer, db.ForeignKey('employee.id')) follower = db.relationship('Customer', backref=db.backref('follower')) followed = db.relationship('Employee', backref=db.backref('followed'))
class Comment(db.Model): __tablename__ = 'comment' id = db.Column(db.Integer, primary_key=True) information = db.Column(db.String(100)) blog_id = db.Column(db.Integer, db.ForeignKey('blog.id')) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) def __repr__(self): return '<Comment {}>'.format(self.information)
class AnswerQuestion(db.Model): __tablename__ = 'answer_question' id = db.Column(db.Integer, primary_key=True, autoincrement=True) content = db.Column(db.Text, nullable=False) create_time = db.Column(db.DateTime, default=datetime.now) author_id = db.Column(db.Integer, db.ForeignKey('employee.id')) answer_question_id = db.Column(db.Integer, db.ForeignKey('question.id')) author = db.relationship('Employee', backref=db.backref('realanswer')) question = db.relationship('Question', backref=db.backref('questionAnswer'))
class Appointment(db.Model): id = db.Column(db.Integer, primary_key=True) type = db.Column(db.String(64),index=True) date = db.Column(db.String(64), index=True) time = db.Column(db.String(64), index=True) city = db.Column(db.String(64), index=True) details = db.Column(db.String(120), index=True) status = db.Column(db.String(64), index=True, default='Submitted') customer_id = db.Column(db.Integer, db.ForeignKey('customer.id')) pet_id = db.Column(db.Integer, db.ForeignKey('pet.id')) def __repr__(self): return '{}'.format(str(self.date)[0:10])
class Post(SearchableMixin,db.Model): __searchable__ = ['body','title'] id = db.Column(db.Integer,primary_key=True) title = db.Column(db.String(80),nullable=False) body = db.Column(db.Text,nullable=False) body_html = db.Column(db.Text) summary = db.Column(db.Text) body_summary = db.Column(db.Text) timestamp = db.Column(db.DateTime,index=True,default=datetime.utcnow) html_body = db.Column(db.Text) user_id = db.Column(db.Integer,db.ForeignKey('user.id')) @staticmethod def delete(post=None,id=None): if post is None: post = Post.query.filter_by(id=id).first() db.session.delete(post) db.session.commit() @staticmethod def on_body_change(target,value,oldvalue,initiator): allowed_tags = ['a', 'abbr', 'acronym', 'b', 'blockquote', 'code','em', 'i', 'li', 'ol', 'pre', 'strong', 'ul','h1', 'h2', 'h3', 'p'] attrs = { '*':['class'],} target.body_html = bleach.linkify(bleach.clean(markdown(value), tags=allowed_tags, strip=True, attributes=attrs)) pattern = re.compile(r'<[^>]+>', re.S) summary = pattern.sub('', target.body_html) summary = (summary[0:40] + '...') if len(summary) >= 40 else summary target.body_summary = summary def __repr__(self): return '<Post {}>'.format(self.title)
class Suggesstion(db.Model): id = db.Column(db.Integer, primary_key=True) suggestion = db.Column(db.String(140)) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) def __repr__(self): return '<suggestion {}>'.format(self.suggestion)
class NewAppointment(db.Model): id = db.Column(db.Integer, primary_key=True) applicant = db.Column(db.String(20), index=True, nullable=False) date = db.Column(db.String(20), index=True, nullable=False) appoint_time = db.Column(db.Integer, index=True, nullable=False) petType = db.Column(db.Integer, index=True, nullable=False) petName = db.Column(db.String(20), index=True, nullable=False) doctor = db.Column(db.Integer, index=True, nullable=False) phoneNo = db.Column(db.String(20), index=True, nullable=False) comment = db.Column(db.String(20), default="") condition = db.Column(db.Integer, index=True, default=1, nullable=False) op_date = db.Column(db.String(20), index=True) op_time = db.Column(db.Integer, index=True) app_type = db.Column(db.Integer, index=True, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('customer.id')) cus_appoint = db.relationship('Customer', backref=db.backref('Customer')) def to_dict(self): result = {} for key in self.__mapper__.c.keys(): if getattr(self, key) is not None: result[key] = str(getattr(self, key)) else: result[key] = getattr(self, key) return result def to_json(all_vendors): v = [ven.to_dict() for ven in all_vendors] return v
class Question(db.Model): __tablename__ = 'question' id = db.Column(db.Integer, primary_key=True, autoincrement=True) question_title = db.Column(db.String(100), nullable=False) content = db.Column(db.Text, nullable=False) create_time = db.Column(db.DateTime, default=datetime.now) author_name = db.Column(db.String(64), db.ForeignKey('customer.username')) author = db.relationship('Customer', backref=db.backref('realquestions'))
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return 'Post %r' % self.title
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) body = db.Column(db.String(140)) timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) def __repr__(self): return '<Post {}>'.format(self.body)
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer,db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}','{self.date_posted}')"
class Entry(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100)) content = db.Column(db.Text) fragment = db.Column(db.Text) #内容片段, 用于主页显示 status = db.Column(db.Integer, default=1) #完成:1, 失败0, 草稿:-1 (暂时无用) create_time = db.Column(db.DateTime, index=True, default=datetime.now()) modified_time = db.Column(db.DateTime, default=datetime.now()) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) category = db.relationship('Category', backref=db.backref('entries', lazy='dynamic'), lazy='select') category_id = db.Column(db.Integer, db.ForeignKey('category.id')) tag = db.relationship('Tag', secondary=tag_entry, backref=db.backref('entries', lazy='dynamic')) view_count = db.Column(db.Integer, default=0) def __repr__(self): return '<Entry %r>' % self.title def __unicode__(self): return self.title
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) body = db.Column(db.String(140)) timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow) name = db.Column(db.String(140)) user_id = db.Column(db.Integer, db.ForeignKey('customer.id')) def __repr__(self): return '{}: {} --- <{}>'.format(self.name, self.body, str(self.timestamp)[0:16])
class BlogModel(db.Model): __tablename__ = 'blog' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True, nullable=False) creator_id = db.Column(db.Integer, db.ForeignKey('user.id')) date_of_creation = db.Column(db.DateTime, default=datetime.now) is_active = db.Column(db.Boolean, default=False) posts = db.relationship('PostModel', backref='blog', lazy=True) def __repr__(self): return f"Blog : {self.name}"
class Posts(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(64)) post_body = db.Column(db.String(1024)) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) user = db.relationship('User') create_date = db.Column(db.DateTime, default=datetime.utcnow) yn = db.Column(db.SmallInteger, default=1) def __repr__(self): "<post: {}>".format(self.title)
class Pet(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), index=True) type = db.Column(db.String(64), index=True) old = db.Column(db.Integer, index=True) gender = db.Column(db.String(64), index=True) customer_id = db.Column(db.Integer, db.ForeignKey('customer.id')) appointments = db.relationship('Appointment', backref='pet', lazy='dynamic') def __repr__(self): return '<Pet {}>'.format(self.name)
class PostModel(db.Model): __tablename__ = 'post' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(50), nullable=False) content = db.Column(db.Text, nullable=False) created_on = db.Column(db.DateTime, default=datetime.now) blog_id = db.Column(db.Integer, db.ForeignKey('blog.id')) def __repr__(self): return f"post : {self.title}"
class NewAppointment(db.Model): id = db.Column(db.Integer, primary_key=True) applicant = db.Column(db.String(20), index=True, nullable=False) date = db.Column(db.DateTime, index=True, nullable=False) petType = db.Column(db.Integer, index=True, nullable=False) doctor = db.Column(db.Integer, index=True, nullable=False) phoneNo = db.Column(db.String(20), index=True, nullable=False) comment = db.Column(db.String, default="") user_id = db.Column(db.Integer, db.ForeignKey('customer.id')) cus_appoint = db.relationship('Customer', backref=db.backref('Customer')) def __repr__(self): return '<User {}>'.format(self.username)
class BlogPost(db.Model): users = db.relationship(User) id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) title = db.Column(db.String(140), nullable=False) text = db.Column(db.Text, nullable=False) def __init__(self, title, text, user_id): self.title = title self.text = text self.user_id =user_id def __repr__(self): return f"Post Id: {self.id} --- Date: {self.date} --- Title: {self.title}"
return '<Category %r>' % self.name def __unicode__(self): return self.name # 标签 class Tag(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), unique=True) def __repr__(self): return '<Tag %r>' % self.name tag_entry = db.Table('tags', db.Column('tag_id', db.Integer, db.ForeignKey('tag.id')), db.Column('entry_id', db.Integer, db.ForeignKey('entry.id')) ) # 文章 class Entry(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100)) content = db.Column(db.Text) fragment = db.Column(db.Text) #内容片段, 用于主页显示 status = db.Column(db.Integer, default=1) #完成:1, 失败0, 草稿:-1 (暂时无用) create_time = db.Column(db.DateTime, index=True, default=datetime.now()) modified_time = db.Column(db.DateTime, default=datetime.now()) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) category = db.relationship('Category', backref=db.backref('entries', lazy='dynamic'), lazy='select')
from datetime import datetime from time import time import jwt from blogapp import db, login, app from werkzeug.security import generate_password_hash, check_password_hash from flask_login import UserMixin from hashlib import md5 @login.user_loader def load_user(id): return User.query.get(int(id)) 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(db.Model, UserMixin): 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' )