class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(200)) content = db.Column(db.String(300)) date_created = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class Post(db.Model): id = db.Column(db.Integer, primary_key = True) title = db.Column(db.String(200)) content = db.Column(db.String(300)) Date_created = db.Column(db.DateTime , nullable = False, default = datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable = False) def __repr__(self): return "The Title is {} and the user is {}".format(self.title,self.user_id)
class Post(db.Model): id = db.Column(db.Integer, primary_key = True) title = db.Column(db.String(200)) content = db.Column(db.String(300)) date_created = db.Column(db.DateTime, nullable = False, default = datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable = False) # Because of the relationship based on the user model; we're saying we have a relationship with the Post Class and User Class showing us which post was made by which user. # Relationship between user and post: user can make many posts but a post is associated with only user # USER_ID => 1 # POST_ID: 23 => Created by USER_ID: 1 def __repr__(self): return "The Title is {} and the user is {}".format(self.title,self.user_id) # Printing something out to the console everytime a new post is created
class User(db.Model,UserMixin): id = db.Column(db.Integer, primary_key = True) username = db.Column(db.String(150), nullable = False) email = db.Column(db.String(150), unique = True, nullable = False) password = db.Column(db.String(256), nullable = False) post = db.relationship('Post', backref = 'author', lazy = True) def __init__(self,username,email,password): self.username = username self.email = email self.password = self.set_password(password) def __repr__(self): return '{} has been created'.format(self.username) def set_password(self,password): self.pw_hash = generate_password_hash(password) return self.pw_hash
class User(db.Model,UserMixin): id = db.Column(db.Integer, primary_key = True) # main identifier for our user table username = db.Column(db.String(150), nullable = False) # Telling our database that this CANNOT be empty when we say nullable = False email = db.Column(db.String(150), unique = True, nullable = False) # Telling our database that this has to be different each time when we say unique = True and that this cannot be empty either password = db.Column(db.String(256), nullable = False) # Telling our database that this CANNOT be empty when we say nullable = False post = db.relationship('Post', backref = 'author', lazy = True) # Connects which user actually creates the specific post def __init__(self,username,email,password): self.username = username self.email = email self.password = self.set_password(password) def __repr__(self): return '{} has been created'.format(self.username) # Lets us see what is being created def set_password(self,password): self.pw_hash = generate_password_hash(password) return self.pw_hash