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)
#This table will bring these fields below
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
class Posts(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date_posted = db.Column(db.DateTime,
unique=True,
nullable=False,
default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
def __repr__(self):
return f"User('{self.title}', '{self.date_posted}')"
class Restaurants(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
latitude = db.Column(db.Integer, nullable=False)
longitude = db.Column(db.Integer, 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)
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 "Post(title='{}', date_posted='{}', user_id='{}')".format(
self.title, self.date_posted, self.user_id)
class ProductSellableUnit(db.Model):
__tablename__ = "product_sellable_unit"
id = db.Column(db.Integer, primary_key=True)
product_id = db.Column(db.Integer, db.ForeignKey('product.id'))
product_identifiers = db.relationship('ProductIdentifiers', backref='product', lazy=True, uselist=False) #only one allowed)
product_type_id = db.Column(db.Integer, db.ForeignKey('product_type.id'), nullable=True, default = 1) #default is set to 'physical'
cart_lines_using = db.relationship('CartLineItem', backref='ProductSellableUnit', lazy=True)
shipping_attributes_id = db.Column(db.Integer, db.ForeignKey('shipping_attributes.id'), nullable=True)
reference = db.Column(db.String(80)) #Article number, SKU or similar.
quantity_unit = db.Column(db.String(8), default="pcs")
delta_unit_price = db.Column(db.Integer, nullable=False, default = 0)
delta_discount = db.Column(db.Integer, nullable=False, default = 0)
merchant_data = db.Column(db.String(255))#Pass through field. (max 255 characters)
@property
def is_available(self):
return True #Not yet implemented, placeholder
@property
def type(self):
return ProductType.query.get(self.product_type_id).name
@property
def unit_price(self):
return self.Product.base_unit_price + self.delta_unit_price
@property
def unit_discount(self):
return self.Product.base_discount + self.delta_discount
@property
def special_price(self):
if self.unit_discount > 0:
return (1-(self.unit_discount/100)) * self.unit_price #percentage
else:
return None
class Comment(db.Model):
__tablename__ = 'comments'
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.Text)
body_html = db.Column(db.Text)
date_comment = db.Column(db.DateTime, index=True, default=datetime.utcnow)
disabled = db.Column(db.Boolean)
author_id = db.Column(db.Integer, db.ForeignKey('users.id'))
post_id = db.Column(db.Integer, db.ForeignKey('posts.id'))
@staticmethod
def on_changed_body(target, value, oldvalue, initiator):
allowed_tags = [
'a', 'abbr', 'acronym', 'b', 'code', 'em', 'i', 'strong'
]
target.body_html = bleach.linkify(
bleach.clean(markdown(value, output_format='html'),
tags=allowed_tags,
strip=True))
def to_json(self):
json_comment = {
'url': url_for('api.get_comment', id=self.id),
'post_url': url_for('api.get_post', id=self.post_id),
'body': self.body,
'body_html': self.body_html,
'timestamp': self.date_comment,
'author_url': url_for('api.get_user', id=self.author_id),
}
return json_comment
@staticmethod
def from_json(json_comment):
body = json_comment.get('body')
if body is None or body == '':
raise ValidationError('comment does not have a body')
return Comment(body=body)
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
class DysfunctionalAttitudeScale(db.Model):
__tablename__ = 'dysfunctional_attitude_scales'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
date_created = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
approval_score = db.Column(db.Integer, nullable=False)
love_score = db.Column(db.Integer, nullable=False)
achievement_score = db.Column(db.Integer, nullable=False)
perfectionism_score = db.Column(db.Integer, nullable=False)
entitlement_score = db.Column(db.Integer, nullable=False)
omnipotence_score = db.Column(db.Integer, nullable=False)
autonomy_score = db.Column(db.Integer, nullable=False)
question_0 = db.Column(db.Integer, nullable=False)
question_1 = db.Column(db.Integer, nullable=False)
question_2 = db.Column(db.Integer, nullable=False)
question_3 = db.Column(db.Integer, nullable=False)
question_4 = db.Column(db.Integer, nullable=False)
question_5 = db.Column(db.Integer, nullable=False)
question_6 = db.Column(db.Integer, nullable=False)
question_7 = db.Column(db.Integer, nullable=False)
question_8 = db.Column(db.Integer, nullable=False)
question_9 = db.Column(db.Integer, nullable=False)
question_10 = db.Column(db.Integer, nullable=False)
question_11 = db.Column(db.Integer, nullable=False)
question_12 = db.Column(db.Integer, nullable=False)
question_13 = db.Column(db.Integer, nullable=False)
question_14 = db.Column(db.Integer, nullable=False)
question_15 = db.Column(db.Integer, nullable=False)
question_16 = db.Column(db.Integer, nullable=False)
question_17 = db.Column(db.Integer, nullable=False)
question_18 = db.Column(db.Integer, nullable=False)
question_19 = db.Column(db.Integer, nullable=False)
question_20 = db.Column(db.Integer, nullable=False)
question_21 = db.Column(db.Integer, nullable=False)
question_22 = db.Column(db.Integer, nullable=False)
question_23 = db.Column(db.Integer, nullable=False)
question_24 = db.Column(db.Integer, nullable=False)
question_25 = db.Column(db.Integer, nullable=False)
question_26 = db.Column(db.Integer, nullable=False)
question_27 = db.Column(db.Integer, nullable=False)
question_28 = db.Column(db.Integer, nullable=False)
question_29 = db.Column(db.Integer, nullable=False)
question_30 = db.Column(db.Integer, nullable=False)
question_31 = db.Column(db.Integer, nullable=False)
question_32 = db.Column(db.Integer, nullable=False)
question_33 = db.Column(db.Integer, nullable=False)
question_34 = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"DysfunctionalAttitudeScale('{self.id}', '{self.date_created}')"
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)
users = db.relationship(User, backref='post', lazy=True)
comments = db.relationship("Comment", 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)
traffic_datetime = db.Column(db.DateTime, nullable=False)
traffic_temp = db.Column(db.Integer, nullable=False)
traffic_weather = db.Column(db.Text, nullable=False)
traffic_pred = db.Column(db.Integer, 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)
def __repr__(self):
return f"Predicted traffic on Post('{self.traffic_datetime}', '{self.traffic_pred}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(20), nullable=False)
# slug = db.Column(db.String(50), unique=True, nullable=False)
image = db.Column(db.String(50), nullable=True, default='default.jpg')
content = db.Column(db.String(100*100), nullable=False)
created_at = db.Column(db.DateTime, nullable=False,
default=datetime.utcnow)
likes = db.Column(db.Integer, nullable=False, default=0)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"{self.title}, {self.content}, {self.created_at}"
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.Text)
body_html = db.Column(db.Text)
timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow)
disabled = db.Column(db.Boolean)
author_id = db.Column(db.Integer, db.ForeignKey('user.id'))
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
@staticmethod
def on_changed_body(target, value, oldvalue, initiator):
allowed_tags = [
'a', 'abbr', 'acronym', 'b', 'blockquote', 'code', 'em', 'i', 'li',
'ol', 'strong', 'ul', 's', 'pre', 'p'
]
target.body_html = bleach.linkify(
bleach.clean(markdown(value, output_format='html'),
tags=allowed_tags,
strip=True))
def __repr__(self):
return f"Comment('{self.body}', '{self.timestamp}')"
class LeaveApplication(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('staff_member.id'), nullable=False)
category = db.Column(db.Enum(LeaveType), nullable=False)
pre_authorisation = db.Column(db.Boolean, nullable=False, default=False)
personal_message = db.Column(db.Text, nullable=False)
leave_date_from = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
leave_date_to = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
approved = db.Column(db.Boolean, nullable=False, default=False)
def __str__(self):
return f"{self.category} ---- {self.leave_date_from} - {self.leave_date_to}"
class Post(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(10), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
tag = db.Column(db.String(), default="#hello")
post_pic = db.Column(db.String())
def __repr__(self):
return f"Post('{self.date_posted}')"
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)
# relationships
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return 'User(%s, %s)' % (self.title, self.date_posted)
class Menu(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)
breakfast = db.Column(db.Text, nullable=False)
lunch = db.Column(db.Text, nullable=False)
dinner = db.Column(db.Text, 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 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)
# identifica o post ao seu respectivo user
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)
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)
category_id = db.Column(db.Integer,
db.ForeignKey('category.id'),
nullable=False)
# admin = db.Column(db.Boolean())
def __init__(self, title, content, user_id, category_id):
self.title = title
self.content = content
self.user_id = user_id
self.category_id = category_id
def __repr__(self):
return "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)
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)
#the reasone of 'user' in foreignkey is lowercase is because we actually refrencing the table name and column name
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
class Post(db.Model):
"""docstring for Post"""
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)
# bg = db.Column(db.String(20),nullable = False, default = "defaultBG.png" )
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)
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)
#image_file_xray = db.Column(db.String(20), nullable=False, default='default.jpg')
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
class Gratitude(db.Model):
__tablename__ = 'gratitudes'
id = db.Column(db.Integer, primary_key=True)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
first_gratitude = db.Column(db.Text, nullable=False)
second_gratitude = db.Column(db.Text, nullable=False)
third_gratitude = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
def __repr__(self):
return f"Gratitude('{self.date_posted}', '{self.first_gratitude}', '{self.second_gratitude}', '{self.third_gratitude}')"
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)
#Lower case for user because SQLAlchemy writes table name in smaller case
def __repr__(self):
return f"User('{self.title}', '{self.date_posted}')"
class Message(db.Model):
id = db.Column(db.Integer, primary_key=True)
messageContent = db.Column(db.String(500), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
image_file = db.Column(db.String(20),
nullable=False,
default='default.jpg')
def __repr__(self):
return f"Message('{self.messageContent}','{self.date_posted}')"
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) # user : table(lowercase of class), id : column
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)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
# user_id = id for the user who made this specific post
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
# Defines the default manner in which our object will be printed out
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)
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)
programming_language = db.Column(db.String(100))
category = db.Column(db.String(100))
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
class Post(db.Model):
""" Tablename will be automatically set to post """
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):
""" How our object is printed out when using the print method."""
return f"Post('{self.title}', '{self.date_posted}')"
class Pharmcy(db.Model, UserMixin):
medicine_id = db.Column(db.Integer, primary_key=True)
medicine = db.Column(db.String(20), unique=True, nullable=False)
quantity = db.Column(db.Integer)
rate = db.Column(db.Integer)
amount = db.Column(db.Integer)
pharmcy_id = db.Column(db.Integer,
db.ForeignKey('patient.patient_id'),
nullable=False)
posts1 = db.relationship('Diagnostics', backref='pharmcy', lazy=True)
def __repr__(self):
return f"Pharmcy('{self.medicine}','{self.quantity}','{self.rate}','{self.amount}','{self.pharmcy_id}')"
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)
#author_id = db.Column(db.Integer, db.ForeignKey('user.id'))
likes = db.relationship('PostLike', lazy='dynamic')
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
class Post(db.Model, UserMixin):
# __table_name__ = ""
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}')"
