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) firstq = db.Column(db.Text, nullable=False) secondq = db.Column(db.Text, nullable=False) thirdq = db.Column(db.Text, nullable=False) forthq = db.Column(db.Text, nullable=False) fifthq = 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, nullable=False, default=datetime.utcnow) like_count = db.Column(db.Integer, nullable=False, default=0) category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) comments = db.relationship('Comment', backref='comment', lazy=True) def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')"
class FoodDB(db.Model): #from food API __tablename__ = 'FoodDB' food_id = db.Column(db.Integer, primary_key=True) food_name = db.Column(db.String(50), nullable=False) food_calories = db.Column(db.Float, nullable=False) food_protein = db.Column(db.Float, nullable=False) food_carb = db.Column(db.Float, nullable=False) food_fat = db.Column(db.Float, nullable=False) food_fibres = db.Column(db.Float, nullable=False) food_saturatedfat = db.Column(db.Float, nullable=False) food_sodium = db.Column(db.Float, nullable=False) serving_size = db.Column(db.Float, nullable=False) Food = db.relationship("Food", backref="FoodDB", cascade="all, delete, delete-orphan", passive_deletes=True)
class FoodRecord(db.Model): #a food record that user eat __tablename__ = 'FoodRecord' foodrecord_id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('User.user_id', ondelete='CASCADE'), nullable=False) foodrecord_date = db.Column(db.DateTime, nullable=False, default=datetime.now()) foodrecord_meal = db.Column(db.String(20), nullable=False, default='Breakfast') Food = db.relationship("Food", backref="FoodRecord", cascade="all, delete, delete-orphan", passive_deletes=True)
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.DateTime, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) @hybrid_property def expiry(self): today = datetime.today() return self.content - today def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')"
class Post(db.Model): __table_name = 'post' __table_args__ = {'schema': 'rosarsa_crm'} 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 = db.relationship('User', backref='user') user_id = db.Column(db.Integer, db.ForeignKey('rosarsa_crm.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) published = db.Column(db.Boolean, default=False) comments = db.relationship('Comment', backref='post_comments', lazy=True) user_tag = db.Column(db.Text) likes = db.relationship('PostLike', backref='post', lazy='dynamic') theme = db.Column(db.Integer, default=1) def __repr__(self): return f"Post('{self.title}', '{self.date_posted}', '{self.published}', '{self.user_tag}', '{self.theme}')"
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 __init__(self,title,content,date_posted): # self.title=title # self.content=content # self.date_posted=date_posted def __repr__(self): return f"Post('{self.title}','{self.content}','{self.date_posted}')"
class Blog(db.Model): blog_id = db.Column(db.Integer, primary_key=True) subject = db.Column(db.String(100), nullable=False) date_blogged = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) description = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) # Blog can have many comments comment = db.relationship('Comment', backref='blog', lazy=True) # Blog can have many tags tag = db.relationship('Tag', backref='blog', lazy=True) def __repr__(self): return f"Post('{self.subject}', '{self.date_blogged}')"
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 is how our object is printed whenever we print it out def __repr__(self): #print Post Object, "f" is for concatenate return f"Post('{self.title}', '{self.date_posted}')"
class Post(db.Model): ''' - modelul de postare - contine campurile de completare a unei postari ''' 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): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) # we are passing utcnow as an argument and not as a function # utcnow() because we don't want to pass the # current date as an argument. The function will run after it's passed along date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) # Linking Post table to User table using FK user.id. Since we are referencing the User table # we are using lowercase "user" user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}' , '{self.date_posted}')"
class DeletedPost(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) date_edited = db.Column(db.DateTime, nullable=False) date_deleted = 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_history = db.relationship('DeletedPostHistory', backref='post', lazy=True) 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) location = db.Column(Geometry("POINT", srid=4326, dimension=2, management=True)) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) type_of_service = db.Column(db.Integer, nullable=False) category = db.Column(db.Integer, nullable=False) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def get_service_location_lat(self): point = to_shape(self.location) return point.x def get_service_location_lng(self): point = to_shape(self.location) return point.y def __repr__(self): return f"Post('{self.title}', '{self.date_posted}', '{self.location}', '{self.content}')" @staticmethod def point_representation(lat, lng): point = "POINT(%s %s)" % (lat, lng) wkb_element = WKTElement(point, srid=4326) return wkb_element def to_dict(self): return { "id": self.id, "username": self.profile.user.username, "title": self.title, "location": { "lat": self.get_service_location_lat(), "lng": self.get_service_location_lng(), }, "content": self.content, "service": self.service, } @staticmethod def get_services_within_radius(lat, lng, radius): """Return all service posts within a given radius (in meters)""" return Post.query.filter( func.PtDistWithin(Post.location, func.MakePoint(lat, lng, 4326), radius) ).all()
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) firstname = db.Column(db.String(20), nullable=False) lastname = db.Column(db.String(20), nullable=False) phone = db.Column(db.String(20), unique=True, nullable=False) roll = db.Column(db.String(20), unique=True, nullable=False) rank = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = 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) #role = db.Column(db.Integer, nullable=False, default=1) def __repr__(self): return f"User('{self.id}','{self.firstname}','{self.lastname}', '{self.email}', '{self.image_file}')"
class User(db.Model, UserMixin): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) first_name = db.Column(db.String(80), nullable=True) last_name = db.Column(db.String(80), nullable=True) gender = db.Column(db.String(20), nullable=True) username = db.Column(db.String(80), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(255), nullable=False) post = db.relationship('Post', backref='user', lazy='dynamic') roles = db.relationship('Role', secondary='user_roles', backref='usrroles')
class Post(db.Model): # (1)设置table相关属性 # __tablename__ = "Post" # 用于设置table的名字,table表名默认为类名Post id = db.Column(db.Integer, primary_key=True) # 定义为primary_key的属性会自动生成编号 title = db.Column(db.String(100), nullable=False) post_date = db.Column( db.DateTime, nullable=False, default=datetime.now) # 使用datetime模块中的datetime.utcnow方法获取当前时间 # 我们在alexnet模型代码中,写了:now_str = dt.datetime.now().strftime("%Y-%m-%d_%H%M%S") 使用datetime模块里的datetime.now()方法取得当前时间,并格式化 # content = db.Column(db.Text, nullable=False) # 【这里的user_id需要理解!】 db.ForeignKey的用法需要学习!!!!!!! user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False) # (2)定义了直接print(Post类对象)的输出内容 def __repr__(self): return f"博文信息< 文章标题:{self.title}, 发布时间:{self.post_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.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) # ForeignKey에 들어가는 attiribute가 소문자로 user임에 주의. # In the user model, we are referencing the actual post class, and in the foreign key we are actually referecing the table and the column name. # So it's a lower case. So the user model automatically has this table name set to lower case 'user', and the post model will have a table name # automatically set to lower case 'post'. If you want to set your own table names, then you can set a specific table name atttribute. # but since our models are pretty simple, we'll just leave those as the default lower case value. 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(20), nullable=False) def posttime(self): dt = str(datetime.now().date()) t = str(datetime.now().time().hour) + ':' + str( datetime.now().time().minute) return "Date - " + dt + " | Time - " + t + " Hrs" # print(posttime()) date_posted = db.Column(db.String, nullable=False, default=posttime) 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 ExerciseDB(db.Model): # from exercise API __tablename__ = 'ExerciseDB' exercise_id = db.Column(db.Integer, primary_key=True) exercise_desc = db.Column(db.String(1000000), nullable=False) exercise_caloriesburnt = db.Column(db.Float, nullable=False) Exercise = db.relationship("Exercise", backref="ExerciseDB", cascade="all, delete", passive_deletes=True) Set = db.relationship("Set", backref="ExerciseDB", cascade="all, delete, delete-orphan", passive_deletes=True) Rep = db.relationship("Rep", backref="ExerciseDB", cascade="all, delete, delete-orphan", passive_deletes=True)
class Post(db.Model): __tablename__ = 'post' id = db.Column(db.Integer, primary_key=True, autoincrement=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) # the User and Post model will have a one to many relationship, # because one user can have multiple posts, but a post can only have 1 author, # i.e. Post will be the child table 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 ) #default is taken beacuse if no date is specified then it will take the current time so we take datetime module 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}')" #this will be printed out as Post #we are not adding authors to post model because post model and user model will have a relationship, users will author post. #This is a one to many relationship, bcz one user can have multiple post but a post can ave only one author #Now by these 2 above database models we will create database by using command line
class Post(db.Model): __tablename__ = 'post' __searchable__ = ['date_posted', 'tags'] 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) tags = db.relationship('Tag', secondary=tags, lazy='subquery', backref=db.backref('pages', lazy=True)) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}', '{self.date_posted}', {self.tags})"
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) keywords = db.Column(db.Text, nullable=False) url = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) reviews = db.relationship('Review', backref='origin', lazy=True) graphs = db.relationship('Graph', backref='gg', lazy=True, cascade="save-update, merge, delete") def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')"
class Event(db.Model): id = db.Column(db.Integer, primary_key=True) date = db.Column(db.Date, nullable=False) time = db.Column(db.Time, nullable=False) cost = db.Column(db.Float, nullable=False, default='To be defined') np = db.Column(db.Integer, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) club_id = db.Column(db.Integer, db.ForeignKey('club.id'), nullable=False) sport_id = db.Column(db.Integer, db.ForeignKey('sport.id'), nullable=False) level = db.Column(db.String(60)) participant2 = db.relationship('Participant', foreign_keys=[Participant.e_id], backref='part', lazy=True) def __repr__(self): return '<Event %r %r %r>' % self.date % self.time % self.np
class Competancy_rec(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement="auto") mark = db.Column(db.Boolean, nullable=True) comp_id = db.Column(db.String, db.ForeignKey('comp.descrip'), nullable=False) comp_name = db.Column(db.String(100), nullable=False) clinician_id = db.Column(db.Integer, db.ForeignKey('user2.id'), nullable=False) student_id = db.Column(db.Integer, db.ForeignKey('student.id'), nullable=False) timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) def __repr__(self): return f"Comp_rec('{self.id}', '{self.mark}', '{self.comp_id}', '{self.clinician_id}', '{self.student_id}', '{self.timestamp}')"
class Notification(db.Model): id = db.Column(db.Integer, primary_key=True) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) notification_type = db.Column(db.String(30), nullable=False) has_been_read = db.Column(db.Boolean, nullable=False, default=False) post_id = db.Column(db.Integer, db.ForeignKey('post.id'), nullable=True) posts = db.relationship(Post, backref='notification', lazy=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) users = db.relationship(User, backref='notification', lazy=True) comment_id = db.Column(db.Integer, db.ForeignKey('comment.id'), nullable=True) comments = db.relationship(Comment, backref='notification', lazy=True) reply_id = db.Column(db.Integer, db.ForeignKey('reply.id'), nullable=True) replies = db.relationship(Reply, backref='notification', lazy=True)
class Course(db.Model): course_name = db.Column(db.String(100), primary_key=True) level = db.Column(db.String(100)) level_slug = db.Column(db.String(100)) age = db.Column(db.Integer) duration = db.Column(db.String(100)) slug = db.Column(db.String(100)) price_e_learning = db.Column(db.Integer) price_book_learning = db.Column(db.Integer) pool_dives = db.Column(db.Integer) ocean_dives = db.Column(db.Integer) min_dives = db.Column(db.String(100)) qualified_to = db.Column(db.String(255)) basic_info = db.Column(db.Text) schedule = db.Column(db.Text) image = db.Column(db.String(100), default='default_course.jpg') def __repr__(self): return f"Site('{self.course_name}', '{self.level}')"
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) Username = db.Column(db.String(50), nullable=False) Address = db.Column(db.String(100), nullable=True) PhoneNumber = db.Column(db.String(13), unique=True, nullable=False) PlotNumber = db.Column(db.String(10), unique=True, nullable=False) FlatNumber = db.Column(db.String(10), nullable=True) PaymentStatus = db.Column(db.String(10), nullable=False, default="False") Role = db.Column(db.String(10), nullable=False, default="User") Date_created = db.Column(db.DateTime, nullable=False, default=datetime.today()) payment = db.relationship('Payment', backref='author', lazy=True) def __repr__(self): return f"User('{self.Username}', '{self.PhoneNumber}', '{self.PlotNumber}','{self.PaymentStatus}','{self.Role}','{self.Date_created}')"
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, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) # referecing table/column name (lower case user name) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) # how object is printed def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')" def __init__(self, title, content, user_id): self.title = title self.content = content self.user_id = user_id