class User(db.Model): __tablename__ = 'ods_p1_User' id = db.Column(db.Integer, primary_key=True) nickname = db.Column(db.String(64), index=True, unique=True) email = db.Column(db.String(120), index=True, unique=True) posts = db.relationship('Post', backref='author', lazy='dynamic') #db.relationship 字段。这并不是一个实际的数据库字段,因此是不会出现在上面的图中。对于一个一对多的关系,db.relationship 字段通常是定义在“一”这一边。在这种关系下 about_me = db.Column(db.String(140)) last_seen = db.Column(db.DateTime) 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') @property def is_authenticated(self): #is_authenticated 方法有一个具有迷惑性的名称。一般而言,这个方法应该只返回 True,除非表示用户的对象因为某些原因不允许被认证。 return True @property def is_active(self): #is_active 方法应该返回 True,除非是用户是无效的,比如因为他们的账号是被禁止。 return True @property def is_anonymous(self): #is_anonymous 方法应该返回 True,如果是匿名的用户不允许登录系统。 return False def get_id(self): #get_id 方法应该返回一个用户唯一的标识符 return str(self.id) def follow(self, user): if not self.is_following(user): self.followed.append(user) return self def unfollow(self, user): if self.is_following(user): self.followed.remove(user) return self def is_following(self, user): return self.followed.filter( followers.c.followed_id == user.id).count() > 0 def __repr__(self): #__repr__ 方法告诉 Python 如何打印这个类的对象。我们将用它来调试。 return '<User %r>' % (self.nickname)
class Tag(db.Model): """Represents Proected tags.""" __tablename__ = 'tags' id = db.Column(db.String(45), primary_key=True) name = db.Column(db.String(255)) add = db.Column(db.String(255)) add1 = db.Column(db.String(255)) def __init__(self, name): self.name = name def __repr__(self): return "<Model Tag `{}`>".format(self.name)
class Comment(db.Model): """Represents Proected comments.""" __tablename__ = 'comments' id = db.Column(db.String(45), primary_key=True) name = db.Column(db.String(255)) text = db.Column(db.Text()) date = db.Column(db.DateTime()) post_id = db.Column(db.String(45), db.ForeignKey('posts.id')) def __init__(self, name): self.name = name def __repr__(self): return '<Model Comment `{}`>'.format(self.name)
class Post(db.Model): __tablename__ = 'ods_p1_Post' id = db.Column(db.Integer, primary_key=True) body = db.Column(db.String(140)) timestamp = db.Column(db.DateTime) user_id = db.Column(db.Integer, db.ForeignKey('ods_p1_User.id')) def __repr__(self): #__repr__ 方法告诉 Python 如何打印这个类的对象。我们将用它来调试。 return '<Post %r>' % (self.body)
class User(db.Model): """Represents Proected users.""" # Set the name for table __tablename__ = 'users' id = db.Column(db.String(45), primary_key=True) username = db.Column(db.String(255)) password = db.Column(db.String(255)) posts = db.relationship('Post', backref='users', lazy='dynamic') def __init__(self, id, username, password): self.id = id self.username = username self.password = password def __repr__(self): """Define the string format for instance of User.""" return "<Model User `{}`>".format(self.username)
class Post(db.Model): """Represents Proected posts.""" __tablename__ = 'posts' id = db.Column(db.String(45), primary_key=True) title = db.Column(db.String(255)) text = db.Column(db.Text()) publish_date = db.Column(db.DateTime) # Set the foreign key for Post user_id = db.Column(db.String(45), db.ForeignKey('users.id')) # Establish contact with Comment's ForeignKey: post_id comments = db.relationship('Comment', backref='posts', lazy='dynamic') # many to many: posts <==> tags tags = db.relationship('Tag', secondary=posts_tags, backref=db.backref('posts', lazy='dynamic')) def __init__(self, title): self.title = title def __repr__(self): return "<Model Post `{}`>".format(self.title)
username = db.Column(db.String(255)) password = db.Column(db.String(255)) posts = db.relationship('Post', backref='users', lazy='dynamic') def __init__(self, id, username, password): self.id = id self.username = username self.password = password def __repr__(self): """Define the string format for instance of User.""" return "<Model User `{}`>".format(self.username) posts_tags = db.Table( 'posts_tags', db.Column('post_id', db.String(45), db.ForeignKey('posts.id')), db.Column('tag_id', db.String(45), db.ForeignKey('tags.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 Post(db.Model): """Represents Proected posts.""" __tablename__ = 'posts' id = db.Column(db.String(45), primary_key=True) title = db.Column(db.String(255)) text = db.Column(db.Text())