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}')"