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
