class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
blog_id = db.Column(db.Integer, db.ForeignKey('blog.id'))
author_id = db.Column(db.Integer, db.ForeignKey('author.id'))
title = db.Column(db.String(80))
body = db.Column(db.Text)
image = db.Column(db.String(255))
slug = db.Column(db.String(256), unique=True)
publish_date = db.Column(db.DateTime)
live = db.Column(db.Boolean)
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category',
backref=db.backref('posts', lazy='dynamic'))
@property
def imgsrc(self):
return uploaded_images.url(self.image)
def __init__(self, blog, author, title, body, category, image=None, slug=None, publish_date=None, live=True):
self.blog_id = blog.id
self.author_id = author.id
self.title = title
self.body = body
self.category = category
self.image = image
self.slug = slug
if publish_date is None:
self.publish_date = datetime.utcnow()
self.live = live
def __repr__(self):
return '<Post %r>' % self.title
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
blog_id = db.Column(db.Integer, db.ForeignKey('blog.id'))
author_id = db.Column(db.Integer, db.ForeignKey('author.id'))
title = db.Column(db.String(80))
body = db.Column(db.Text)
slug = db.Column(db.String(256), unique=True)
publish_date = db.Column(db.DateTime)
live = db.Column(db.Boolean)
category_id = db.Column(db.Integer, db.Foreign('category.id'))
def __init__(self,
blog,
author,
title,
body,
category,
slug=None,
publish_date=None,
live=True):
self.blog_id = blog.id
self.author_id = author.id
self.title = title
self.body = body
self.category = category
self.slug = slug
self.live = live
self.publish_date = publish_date if publish_date else datetime.utcnow()
def __repr__(self):
return f'<post {self.title}>'
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255))
body = db.Column(db.String(1000))
slug = db.Column(db.String(255))
publish_date = db.Column(db.Date)
blog_id = db.Column(db.Integer, db.ForeignKey("blog.id"))
author_id = db.Column(db.Integer, db.ForeignKey("author.id"))
category_id = db.Column(db.Integer, db.ForeignKey("category.id"))
is_live = db.Column(db.Boolean)
def __init__(self,
title,
body,
slug,
blog_id,
author_id,
category_id,
date,
is_live=1):
self.title = title
self.body = body
self.slug = slug
self.blog_id = blog_id
self.author_id = author_id
self.category_id = category_id
self.publish_date = date
self.is_live = is_live
def __repr__(self):
return "<Post %r>" % self.title
class PostComment(db.Model):
id = db.Column(db.Integer, primary_key=True)
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)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'), nullable=False)
def __repr__(self):
return f"PostComment('{self.content}', '{self.date_posted}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
blog_id = db.Column(db.Integer, db.ForeignKey('blog.id'))
author_id = db.Column(db.Integer, db.ForeignKey('author.id'))
title = db.Column(db.String(80))
body = db.Column(db.Text)
image = db.Column(db.String(255))
slug = db.Column(db.String(256), unique=True)
# so slug is a string composed of date blog is published and the page name.
# so slug kinda gives each blog post its own url
publish_date = db.Column(db.DateTime)
live = db.Column(db.Boolean)
# It is usally not a good practice to delete entries from DB
# so what we do is set live to false which means it will not be visible
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
category = db.relationship('Category',
backref=db.backref('posts', lazy='dynamic'))
# we are establishing a relationship between catergory and posts
@property
def imgsrc(self):
return uploaded_images.url(self.image)
def __init__(self,
blog,
author,
title,
body,
category,
image=None,
slug=None,
publish_date=None,
live=True):
self.blog_id = blog.id
self.author_id = author.id
self.category_id = category.id
self.image = image
self.title = title
self.body = body
self.slug = slug
if publish_date is None:
self.publish_date = datetime.utcnow()
else:
self.publish_date = publish_date
self.live = live
def __repr__(self):
return "<Post > {}".format(self.title)
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
author_id = db.Column(db.Integer, db.ForeignKey('author.id'))
body = db.Column(db.Text)
publish_date = db.Column(db.DateTime)
def __init__(self, post, author, body, publish_date=None):
self.post_id = post.id
self.author_id = author.id
self.body = body
if publish_date is None:
self.publish_date = datetime.utcnow()
def __repr__(self):
return '<Comment %r>' % self.body
class Orders(db.Model):
order_id = db.Column(db.Integer, primary_key=True)
order_number = db.Column(db.Integer, nullable=False)
date_order = db.Column(db.DateTime(timezone=True), default=func.now())
user_id = db.Column(db.Integer,
db.ForeignKey('user.user_id'),
nullable=False)
shipper_id = db.Column(db.Integer,
db.ForeignKey('shipper.shipper_id'),
nullable=False)
order_details = db.relationship('OrderDetails', backref='has', lazy=True)
user = db.relationship('User', backref='ordered', lazy=True)
shipper = db.relationship('Shipper', backref='managed', lazy=True)
def __repr__(self):
return f"Orders('order_id(PK): {self.order_id}, user_id(FK): {self.user_id}, shipper_id(FK):{self.shipper_id}, order_number: {self.order_number})"
class Comments(db.Model):
__tablename__ = "moviecomments"
comm_id = db.Column(db.Integer, primary_key=True)
movie_id = db.Column(db.Integer,
db.ForeignKey("movie.movie_id"),
nullable=False)
mcomment = db.Column(db.String, nullable=False)
mrating = db.Column(db.Integer, nullable=False)
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)
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) # function as argument, don't run it
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) # "u" lower case for table name
def __repr__(self):
return f"Post('{self.title}','{self.date_posted}')"
class Videos(db.Model):
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())
player = db.Column(db.String(40), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Videos('{self.title}','{self.date}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(120), nullable=False)
created_on = db.Column(db.DateTime, nullable=False, default=datetime.utcfromtimestamp)
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.created_on}')"
class Post(db.Model):
id = db.Column(db.Integer(), primary_key=True)
date_posted = db.Column(db.DateTime, default=datetime.utcnow)
title = db.Column(db.String(60), 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 f"Post('{self.title}', '{self.date_posted}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(30), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow())
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) # in the foreign key user is lower case as that is the table name that is by default named from he class User...
def __repr__(self):
return f'User({self.title}, {self.date}, {self.content})'
class OrderDetails(db.Model):
order_details_id = db.Column(db.Integer, primary_key=True)
quantity = db.Column(db.Integer, nullable=False, default=1)
price = db.Column(db.Float, nullable=False)
total = db.Column(db.Float, nullable=False)
user_id = db.Column(db.Integer, nullable=True)
order_id = db.Column(db.Integer,
db.ForeignKey('orders.order_id'),
nullable=True)
product_id = db.Column(db.Integer,
db.ForeignKey('products.product_id'),
nullable=False)
order = db.relationship('Orders', backref='fromorder', lazy=True)
product = db.relationship('Products', backref='includes', lazy=True)
def __repr__(self):
return f"OrderDetails('order_details_id(PK): {self.order_details_id}, product_id(FK): {self.product_id}, order_id(FK): {self.order_id}, quantity: {self.quantity}, price: {self.price}, total: {self.total}')"
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)
created_time = db.Column(db.DateTime,nullable=False,default=cn_timezone)
update_time = db.Column(db.DateTime,nullable=True)
post_image = db.Column(db.String(20),nullable=True,default='default.jpg')
author_id = db.Column(db.Integer,db.ForeignKey('user.id'),nullable=False)
def __repr__(self):
return f"Post('{self.title}','{self.author.username}','{self.created_time}')"
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)
comments = db.relationship('PostComment', backref='comment_post', lazy=True)
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
author_id = db.Column(db.ForeignKey(User.id), nullable=False)
title = db.Column(db.String(30), unique=True, nullable=False, server_default='Untitled')
author = db.relationship(User, lazy=True, backref='post')
created = db.Column(db.DateTime, nullable=False, server_default=db.func.current_timestamp())
body = db.Column(db.Text, nullable=False)
def __repr__(self):
return '<Post %r>' % self.title
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) -> str:
return f"Post ('{self.title}' posted on {self.date_posted})"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(20), unique=True, 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):
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,
default=datetime.utcnow,
nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return 'Post({}, {})'.format(self.title, self.date_posted)
class Blog(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80))
admin = db.Column(db.Integer, db.ForeignKey('author.id'))
def __init__(self, name, admin):
self.name = name
self.admin = admin
def __repr__(self):
return "<Blog %r>" % self.name
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
body_comment = db.Column(db.Text)
timestamp = db.Column(db.DateTime)
author_id = db.Column(db.Integer, db.ForeignKey('author.id'))
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
username = db.Column(db.String(50))
def __init__(self, post, author, body_comment, timestamp=None):
self.post_id = post.id
self.author_id = author.id
self.username = author.username
self.body_comment = body_comment
if timestamp is None:
self.timestamp = datetime.utcnow()
else:
timestamp = self.timestamp = timestamp
def __repr__(self):
return '<Post %r>' % self.body_comment
class Blog(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80))
admin = db.Column(db.Integer, db.ForeignKey('author.id'))
posts = db.relationship('Post', backref='blog', lazy='dynamic')
def __init__(self, name, admin):
self.name = name
self.admin = admin
def __repr__(self):
return '<Name %r>' % self.name
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.Text)
author_name = db.Column(db.String(80))
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
def __init__(self, text, author_name, post):
self.text = text
self.author_name = author_name
self.post_id = post.id
def __repr__(self):
return '<Comment %s>' % self.text
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)
#A foreign key that points to table.attribute. In this case, attribute id of table user
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self): #how our object is printed when we print it out
return f"Post('{self.title}','{self.date_posted}')"
class Account(db.Model):
id = db.Column(db.Integer,primary_key=True)
biography = db.Column(db.String(100))
location = db.Column(db.String(20))
phone = db.Column(db.String(11))
qq = db.Column(db.String(20))
# github = db.Column(db.String(100),default='github.com/zengzhengrong')
user_id = db.Column(db.Integer,db.ForeignKey('user.id'),nullable=False)
created_time = db.Column(db.DateTime,nullable=False,default=cn_timezone)
# viewable = db.Column(db.Boolean,default=True)
sex = db.Column(db.String(10),default=None)
def __repr__(self):
return f"UserAccount('{self.user.username}','{self.phone}','{self.created_time}')"
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
author_id = db.Column(db.Integer, db.ForeignKey('author.id'))
username = db.Column(db.String(50))
body = db.Column(db.Text)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
publish_date = db.Column(db.DateTime)
live = db.Column(db.Boolean)
def __init__(self, author, post, body, publish_date=None, live=True):
self.author_id = author.id
self.username = author.username
self.post_id = post.id
self.body = body
if publish_date is None:
self.publish_date = datetime.utcnow()
else:
self.publish_date = publish_date
self.live = live
def __repr__(self):
return '<Comment %r>' % 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)
# datetime.utcnow gives you current time
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
# here we are using Foreign key so referencing table name and column thats why user.id not User.id
#dunder method used for priting the objects
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
class Entry(db.Model):
__tablename__ = 'entries'
id = db.Column(db.Integer, primary_key=True)
users_id = db.Column(db.Integer, db.ForeignKey('users.id'))
title = db.Column(db.String(50), unique=True)
auther = db.Column(db.Text)
publisher = db.Column(db.Text)
def __init__(self, users_id=None, title=None, auther=None, publisher=None,):
self.users_id = users_id
self.title = title
self.auther = auther
self.publisher = publisher
