class Link(db.Model): __tablename__ = 'link' __bind_key__ = 'blog2' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100)) link = db.Column(db.String(100)) description = db.Column(db.String(200)) order_id = db.Column(db.Integer) def __repr__(self): return '<link %r>' % self.name
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) # 主键 name = db.Column(db.String(20)) username = db.Column(db.String(20)) # 用户名 password_hash = db.Column(db.String(128)) # 密码散列值 def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password)
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 Post(db.Model): __tablename__ = "post" id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date = db.Column(db.DateTime, nullable=False, default=datetime.now) content = db.Column(db.Text, nullable=False) # connect used_id to id col from user table user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post({self.title}, {self.date})"
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.String(10), nullable=False, default=datetime.utcnow().date()) content = db.Column(db.Text, nullable=False) u_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): #how objects are printed return ("User('{}','{}')".format(self.title, self.date_posted))
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) img_file = db.Column(db.String(20), nullable=False, default='default.png') password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='author', lazy=True) def __repr__(self): return "User('{}','{}','{}')".format(self.username, self.email, self.img_file)
class Comments(db.Model): id = db.Column(db.Integer(), primary_key=True) post_id = db.Column(db.Integer(), db.ForeignKey('post.id'), nullable=False) author_id = db.Column(db.Integer(), db.ForeignKey('user.id'), nullable=False) content = db.Column(db.Text, nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.now) def __repr__(self): return f"Comments('{self.id}', '{self.post_id}', '{self.author_id}')"
class Page(db.Model): """ Class for highest level web page. """ path_name = db.Column(db.String(30), primary_key=True) page_name = db.Column(db.TEXT, nullable=False) author_id = db.Column(db.ForeignKey(User.uid), nullable=False) created_at = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) author = db.relationship(User, lazy="joined", backref="page")
class User(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) neckname = db.Column(db.String(50), index=True, unique=True, nullable=False) email = db.Column(db.String(100), index=True, unique=True) role = db.Column(db.SmallInteger, default=ROLE_ADMIN) posts = db.relationship('Post', backref='user', lazy='dynamic') def __repr__(self): return '<User %s>' % self.neckname
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 is lowercase as we refer to the user tablename and id column name user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"User('{self.title}','{self.date_posted}')"
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) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) comments = db.relationship('Comment', backref='original_post', lazy=True) def __repr__(self): return f"Post('{self.Title}','{self.date_posted}')"
class Tag(db.Model): __tablename__ = 'tag' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64)) slug = db.Column(db.String(64), unique=True) def __init__(self, *args, **kwargs): super(Tag, self).__init__(*args, **kwargs) self.slug = slugify(self.name) def __repr__(self): return '<Tag: %s>' % self.name
class Tag(db.Model): __tablename__ = 'tag' __bind_key__ = 'blog2' id = db.Column(db.Integer, primary_key=True) tag = db.Column(db.String(30)) articles = db.relationship('Article', secondary=articles_tags, backref='articles') def __repr__(self): return '<tag %r>' % self.tag
class Plan(db.Model): # __tablename__ = 'plans' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date_start = db.Column(db.Date, nullable=False, default=date.today()) date_end = db.Column(db.Date, nullable=False, default=date.today().replace(year=date.today().year + 1)) content = db.Column(db.Text, nullable=False) candidates = db.relationship('Candidate', backref='plan', lazy=True)
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) profileImage = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='author', lazy=True) def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}')"
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) #Here using lower case User because this refers to the table name def __repr__(self): return f"Post('{self.title}','{self.date_posted}')"
class Comment(db.Model): __tablename__ = 'comment' id = db.Column(db.Integer, primary_key=True) author = db.Column(db.String(50)) post_id = db.Column(db.Integer, db.ForeignKey('post.id')) date_posted = db.Column(db.DateTime(), nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) def __repr__(self): return f"Comment('{self.content}', '{self.date_posted}', '{self.author}')"
class Post(SearchableMixin, db.Model): """Defines the various fields and methods for the Post database table""" id = db.Column(db.Integer, primary_key=True) body = db.Column(db.String(140)) timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) language = db.Column(db.String(5)) __searchable__ = ['body'] def __repr__(self): """Defines how new post instance is represented for debugging""" return '<Post {}>'.format(self.body)
class Post(db.Model): id = db.Column(db.Integer(), primary_key=True) title = db.Column(db.String(32)) content = db.Column(db.Text()) date = db.Column(db.DateTime(), default=datetime.datetime.now()) author_id = db.Column(db.Integer(), db.ForeignKey('user.id')) def __repr__(self): return "<Post {}>".format(self.title)
class Category(db.Model): __tablename__ = 'category' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(32), nullable=False) def __init__(self, name): self.name = name def __repr__(self): print(f'Category: {self.name}')
class User(db.Model, UserMixin): __tablename__ = 'b_user' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(10), unique=True) password = db.Column(db.String(16)) def __init__(self, username, password): self.username = username self.password = password def __repr__(self): return '<User %r>' % self.username
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(30), unique=True, nullable=False) password = db.Column(db.String(30), unique=True, nullable=False) email = db.Column(db.Text(50), unique=True, nullable=False) posts = db.relationship('Post', backref='author', lazy=True) def __repr__(self): return f'{self.__class__.__name__}({self.username}-{self.email})' def __str__(self): return self.username
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.Text(30), nullable=False, unique=True) content = db.Column(db.Text(900), nullable=False) date = db.Column(db.DateTime, default=datetime.datetime.now) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f'{self.__class__.__name__}({self.id}-{self.title}-{self.date})' def __str__(self): return self.content[:40]
class Category(db.Model): __tablename__ = 'b_category' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(20), unique=True) content = db.Column(db.String(100)) def __init__(self, title, content): self.title = title self.content = content def __repr__(self): return '<Category %r>' % self.title
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) post = db.Column(db.String(200), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) comments = db.relationship('Comment', backref='commenter', lazy=True) def __repr__(self): return f"Pitch('{self.pitch}, {self.date_posted}')"
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) profile_pic = db.Column(db.String(20), default="default.jpg") password = db.Column(db.String(60), nullable=False) # A relationship is not a column, # creates additional query to get posts from table "post" posts = db.relationship("Post", backref="author", lazy=True) def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.profile_pic}')"
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) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow()) # The User class is "user" table in db, so lowercase user.id below user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False) def __repr__(self): return f"User('{self.title}', '{self.date_posted}')"
class Post(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(160), nullable=False) date_posted = db.Column( db.DateTime, nullable=False, default=datetime.utcnow ) # datetime.utcnow is actually a function. we are passing in a function as our default content = db.Column(db.Text, nullable=False) user_id = db.Column( db.Integer, db.ForeignKey('user.id'), nullable=False ) # when we link to foreignkey, we refer to the table name 'user' which is in lower case, id is the column def __repr__(self): return "Post('{}', '{}')".format(self.title, self.date_posted)
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) datePosted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) #Here, user.id references the user table and the id column. userID = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False) #Post is represented as Post(Title, DatePosted) def __repr__(self): return f"Post('{self.title}', '{self.datePosted}')"
class Follow(db.Model): __tablename__ = 'follows' follower_id = db.Column(db.Integer, db.ForeignKey('users.id'), primary_key=True) followed_id = db.Column(db.Integer, db.ForeignKey('users.id'), primary_key=True) timestamp = db.Column(db.DateTime, default=datetime.utcnow)