class UserRoles(db.Model): __tablename__ = 'user_roles' id = db.Column(db.Integer(), primary_key=True) user_id = db.Column(db.Integer(), db.ForeignKey('users.id', ondelete='CASCADE')) role_id = db.Column(db.Integer(), db.ForeignKey('roles.id', ondelete='CASCADE'))
class Location(db.Model): id = db.Column(db.Integer, primary_key=True) locationName = db.Column(db.String(100), nullable=False) locationAddress = db.Column(db.String(200), nullable=False) def __repr__(self): return self.locationName
class ServiceProvider(User): __tablename__ = 'service_provider' id = db.Column(db.Integer, db.ForeignKey('user.id'), primary_key=True) projects = db.relationship('AssociationServiceProviderProject', back_populates='service_provider') proposals = db.relationship('AssociationServiceProviderProposal', back_populates='service_provider') skills = db.Column(db.String(100), nullable=False) curriculum = db.Column(db.String(1000), nullable=False) proposal_id = db.Column(db.Integer, db.ForeignKey('proposal.id')) cost_per_project = db.Column(db.Float, nullable=False) __mapper_args__ = { 'polymorphic_identity': 'service_provider', } def __init__(self, name, email, password, skills, curriculum, cost_per_project): User.__init__(self, name, email, password) self.skills = skills self.curriculum = curriculum self.cost_per_project = cost_per_project def __repr__(self): return "Service Provider('{}', '{}', '{}', '{}', '{}', '{}', '{}')".format( self.id, self.name, self.skills, self.type, self.projects, self.cost_per_project, self.proposals)
class User(db.Model): id = db.Column(db.Integer, primary_key=True) nickname = db.Column(db.String(120), index=True, unique=True) password = db.Column(db.String(255)) ## 1>n relationship to class File, allow file to backref user files = db.relationship('File',backref='user',lazy='dynamic') rank_id = db.Column(db.Integer, db.ForeignKey('rank.id')) mb_used = db.Column(db.Integer) ########## uses flask_login extension @property def is_authenticated(self): return True @property def is_active(self): return True @property def is_anonymous(self): return False def get_id(self): return str(self.id) def __repr__(self): return 'User %r' % (self.nickname)
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(60), unique=True, nullable=False) def __repr__(self): return f"User('{self.username}', '{self.email}')"
class NoteModel(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100)) content = db.Column(db.String(255)) def __init__(self, title, content): self.title = title self.content = content
class ToDoMsg(db.Model): __tablename__ = 'message' id = db.Column(db.Integer, primary_key=True) msg = db.Column(db.Text, index=True) finished = db.Column(db.Boolean, default=False) def __repr__(self): return '<message of %s>' % (self.msg, )
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 f"Post('{self.title}', '{self.date_posted}')"
class User(db.Model): """ Create user table""" id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True) password = db.Column(db.String(80)) def __init__(self, username, password): self.username = username self.password = password
class Category_model(db.Model): __tableName__ = 'category_model' id = db.Column(db.Integer, primary_key = True) routeName = db.Column(db.String(15)) title = db.Column(db.String(15)) def __repr__(self): return ' '.join([id,routeName,title])
class Chat(db.Model): __tablename__ = 'chats' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50), nullable=False) messages = db.relationship('Message', lazy=True, backref='chat') def __repr__(self): return f"<Chat {self.name}>"
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) body = db.Column(db.String(200)) timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow) ## this is part of the foreign ## part two add here ## thats why we need the foreign key ## and the name will be 'user' not 'User' user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
class User(db.Model): ## you must declare a primary key ## otherwise no foreigh key id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(100), index=True, unique=True) email = db.Column(db.String(100), index=True, unique=True) password_hash = db.Column(db.String(200)) ## add the foregin key ## part one here posts = db.relationship('Post', backref='author', lazy='dynamic')
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) password = db.Column(db.String(120), unique=True, nullable=False) posts = db.relationship('Post', backref='author', lazy=True) def save_to_db(self): db.session.add(self) db.session.commit() def __repr__(self): return '<User %r>' % self.username
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = 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) def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}')"
class Items_model(db.Model): __tableName__ = 'items_model' cate_id = db.Column(db.Integer) item_id = db.Column(db.Integer,primary_key = True) name = db.Column(db.String(40)) imageURL = db.Column(db.String(100)) price = db.Column(db.Integer) def __repr__(self): return ' '.join([cate_id,id,name,imageURL,price])
class Permission(db.Model): # type: ignore """ Table of available Permissions """ __tablename__ = "Permission" ID = db.Column(db.Integer, primary_key=True, nullable=False) name = db.Column(db.String(128), nullable=False) def __repr__(self): return f"Permission {self.name}"
class Users(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30)) password = db.Column(db.String(20)) nickname = db.Column(db.String(20)) status = db.Column(db.String(2)) def __init__(self, name, password, nickname): self.name = name self.password = password self.nickname = nickname self.status = 'A'
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) Judul = db.Column(db.String(99), nullable=False) Isi = db.Column(db.Text, nullable=False) Tanggal = 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"user('{self.Judul}', '{self.Tanggal}')"
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = 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) # The following posts column will be a backref which allows SQLAlchemy to link # a specific user (author) back to a bunch of different posts they wrote posts = db.relationship('Post', backref='author', lazy=True) # Defines the default manner in which our object will be printed out def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}')"
class Session(db.Model): __tablename__ = 'sessions' id = db.Column(db.Text, primary_key=True) user_id = db.Column(db.Text, db.ForeignKey('users.id'), nullable=False) def __init__(self, id, user_id): self.id = id self.user_id = user_id def __repr__(self): return '<id {}>'.format(self.id)
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True) email = db.Column(db.String(120), unique=True) def __init__(self, username, email): self.username = username self.email = email # rpr() şeklinde kulllanıyoruz. Burası rapor veya loglama için kullanılıyor # olmasada olur def __repr__(self): return '<User %r>' % self.username
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='author', lazy=True) # def __init__(self,email,password): # self.email = email # self.password = password def __repr__(self): return f"User('{self.username}', '{self.email}')"
class Project(Base): __tablename__ = 'project' id = db.Column(db.Integer, primary_key=True, nullable=False) cost = db.Column(db.Float, nullable=False) final_date = db.Column(db.Date, nullable=False) spending = db.Column(db.Float, nullable=False) tasks_completed = db.Column(db.Integer, nullable=True) finalized = db.Column(db.Boolean, unique=False, default=False) # Relationships client_id = db.Column(db.Integer, db.ForeignKey('client.id'), nullable=False) service_providers = db.relationship('AssociationServiceProviderProject', back_populates='project') demand_id = db.Column(db.Integer, db.ForeignKey('demand.id'), nullable=False) origin_demand = db.relationship('Demand', foreign_keys=[demand_id]) # team # demand = db.relationship('Demand', uselist=False) # problems_solved # tasks_completed def __repr__(self): return "Project('{}', '{}', '{}', '{}', '{}', '{}', '{}')".format( self.id, self.cost, self.final_date, self.spending, self.client_id, self.service_providers, self.origin_demand)
class UserInterestData(db.Model): __tablename__ = 'user_interest_data' uid_id = db.Column(db.Integer, primary_key=True) uid_ud_id = db.Column(db.Integer) uid_interest_type = db.Column(db.String(50)) uid_interest_weight = db.Column(db.Float(10)) uid_squared_weight = db.Column(db.Float(10)) def __init__(self, ud_id, interest_type, interest_weight): self.uid_ud_id = ud_id self.uid_interest_type = interest_type self.uid_interest_weight = interest_weight self.uid_squared_weight = interest_weight * interest_weight
class Flight(db.Model): __tablename__ = 'flight' flight_id = db.Column(db.Integer, primary_key=True) airline_Name = db.Column(db.String(80), nullable=False) from_location = db.Column(db.String(20), nullable=False) to_location = db.Column(db.String(120), nullable=False) departure_time = db.Column(db.String(120), nullable=False) arrival_time = db.Column(db.String(120), nullable=False) depart_date = db.Column(db.String(120), nullable=True) total_seats = db.Column(db.Integer, nullable=False) status = db.Column(db.String(20), nullable=True)
class Proposal(Base): __tablename__ = 'proposal' id = db.Column(db.Integer, primary_key=True, nullable=False) service_providers = db.relationship('AssociationServiceProviderProposal', back_populates='proposal') cost = db.Column(db.Float, nullable=False) final_date = db.Column(db.Date, nullable=False) client_approval = db.Column(db.Boolean, nullable=False) demand_id = db.Column(db.Integer, db.ForeignKey('demand.id'), nullable=False) def __repr__(self): return "Proposal('{}', '{}', '{}', '{}', '{}', '{}')".format( self.id, self.cost, self.final_date, self.client_approval, self.demand_id, self.service_providers)
class User(db.Model, UserMixin): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(25), unique=True, nullable=False) email = db.Column(db.String(255), unique=True, nullable=False) password = db.Column(db.String(60), nullable=False) messages = db.relationship('Message', lazy=True, backref='user') chats = db.relationship('Chat', secondary=chat_user, backref=db.backref('users')) def __repr__(self): return f"<User {self.username} {self.email}>"
class TwitterData(db.Model): __tablename__ = 'twitter_data' #columns: user_id, twitter_username, category, category score td_id = db.Column(db.Integer, primary_key=True) td_ud_id = db.Column(db.Integer) td_twitter_name = db.Column(db.String(15)) td_category = db.Column(db.String(20)) td_category_score = db.Column(db.Float(10)) def __init__(self, ud_id, twitter_name, category, category_score): self.td_ud_id = ud_id self.td_twitter_name = twitter_name self.td_category = category self.td_category_score = category_score