class Jogador(db.Model):
id = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.String(100))
nickName = db.Column(db.String(100))
nomeDoTime = db.Column(db.String(100))
role = db.Column(db.String(100))
totalDeAbatimentos = db.Column(db.Integer)
totalDeAssistencias = db.Column(db.Integer)
totalDeMortes = db.Column(db.Integer)
totalDePartidasJogadas = db.Column(db.Integer)
totalDeVitorias = db.Column(db.Integer)
kda = db.Column(db.Float(asdecimal=True))
porcentagemVitorias = (db.Float(asdecimal=True))
def __init__(self, nome, nickName, nomeDoTime, role, totalDeAbatimentos,
totalDeAssistencias, totalDeMortes, totalDePartidasJogadas,
totalDeVitorias, kda, porcentagemVitorias):
self.nome = nome
self.nickName = nickName
self.nomeDoTime = nomeDoTime
self.role = role
self.totalDeAbatimentos = totalDeAbatimentos
self.totalDeAssistencias = totalDeAssistencias
self.totalDeMortes = totalDeMortes
self.totalDePartidasJogadas = totalDePartidasJogadas
self.totalDeVitorias = totalDeVitorias
self.kda = kda
self.porcentagemVitorias = porcentagemVitorias
def __repr__(self):
return 'Jogador {0}'.format(self.id)
class Coleta(db.Model):
id = db.Column(db.Integer, primary_key=True)
temperatura = db.Column(db.Float(asdecimal=True))
umidade = db.Column(db.Float(asdecimal=True))
def __init__(self, temperatura, umidade):
self.temperatura = temperatura
self.umidade = umidade
def __repr__(self):
return '<Coleta %d>' % self.id
class ProjectEmployeeRole(db.Model):
__tablename__ = 'Project_employee_role'
rate = db.Column(db.Float(asdecimal=True), nullable=False)
employee_id = db.Column(db.ForeignKey('Employee.id'),
primary_key=True,
nullable=False,
index=True)
project_id = db.Column(db.ForeignKey('Project.id'),
primary_key=True,
nullable=False,
index=True)
employee_role_id = db.Column(db.ForeignKey('Employee_role.id'),
nullable=False,
index=True)
employee = db.relationship('Employee', lazy=True)
employee_role = db.relationship('EmployeeRole', lazy=True)
project = db.relationship('Project', lazy=True)
def __init__(self, project_id, employee_id, employee_role_id, rate):
self.project_id = project_id
self.employee_id = employee_id
self.employee_role_id = employee_role_id
self.rate = rate
class GasStation(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
place_id = db.Column(db.Integer)
name = db.Column(db.String(255))
latitude = db.Column(db.Float(asdecimal=True))
longitude = db.Column(db.Float(asdecimal=True))
rating = db.Column(db.Float(asdecimal=True))
vicinity = db.Column(db.String(255))
def __init__(self, place_id, name, latitude, longitude, rating, vicinity):
self.place_id = place_id
self.name = name
self.latitude = latitude
self.longitude = longitude
self.rating = rating
self.vicinity = vicinity
def __repr__(self):
return '<Product %d>' % self.id
class Product(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
price = db.Column(db.Float())
def __init__(self, name, price):
self.name = name
self.price = price
def __repr__(self):
return '<Product %d>' % self.id
class Console(db.Model):
id = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.String(100))
nick = db.Column(db.String(100))
time = db.Column(db.String(100))
role = db.Column(db.String(100))
abatimentos = db.Column(db.String(100))
assistencias = db.Column(db.Float(asdecimal=True))
mortes = db.Column(db.Float(asdecimal=True))
partidas = db.Column(db.Float(asdecimal=True))
vitorias = db.Column(db.Float(asdecimal=True))
kda = db.Column(db.Float(asdecimal=True))
vd = db.Column(db.Float(asdecimal=True))
def __init__(self, nome, nick, time, role, abatimentos, assistencias,
mortes, partidas, vitorias):
self.nome = nome
self.nick = nick
self.time = time
self.role = role
self.abatimentos = abatimentos
self.assistencias = assistencias
self.mortes = mortes
self.partidas = partidas
self.vitorias = vitorias
if mortes == 0:
self.kda = abatimentos + assistencias
else:
self.kda = (abatimentos + assistencias) / mortes
self.vd = (vitorias / partidas) * 100
def __repr__(self):
return 'Serie {0}'.format(self.id)
class Project(db.Model):
__tablename__ = 'Project'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(45), nullable=False)
description = db.Column(db.Text, nullable=False)
budget = db.Column(db.Float(asdecimal=True), nullable=False)
start_time = db.Column(
db.DateTime,
nullable=False,
server_default=db.text(
"CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"))
finish_time = db.Column(db.DateTime)
class Restaurant(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
category = db.Column(db.String(255))
michellin_stars = db.Column(db.Float(asdecimal=True))
def __init__(self, name, category, michellin_stars):
self.name = name
self.category = category
self.michellin_stars = michellin_stars
def __repr__(self):
return '<Product %d>' % self.id
class Console(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
year = db.Column(db.Integer)
price = db.Column(db.Float(asdecimal=True))
def __init__(self, name, year, price):
self.name = name
self.year = year
self.price = price
def __repr__(self):
return 'Console {0}'.format(self.id)
class Esports(db.Model):
id = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.String(100))
nick = db.Column(db.String(100))
time = db.Column(db.String(100))
posicao = db.Column(db.String(100))
abatimentos = db.Column(db.Integer)
assists = db.Column(db.Integer)
mortes = db.Column(db.Integer)
partidas = db.Column(db.Integer)
vitorias = db.Column(db.Integer)
propKDA = db.Column(db.Float(precision=3.2, asdecimal=False))
porcentVitorias = db.Column(db.Float(precision=3.2, asdecimal=False))
def calcularProporcao(self):
if (self.mortes != 0):
self.propKDA = round(
(self.assists + self.abatimentos) / self.mortes, 2)
else:
self.propKDA = round(self.assists + self.abatimentos, 2)
self.porcentVitorias = round((self.vitorias / self.partidas) * 100, 2)
def __init__(self, nome, nick, time, posicao, abatimentos, assists, mortes,
partidas, vitorias):
self.nome = nome
self.nick = nick
self.time = time
self.posicao = posicao
self.abatimentos = abatimentos
self.assists = assists
self.mortes = mortes
self.partidas = partidas
self.vitorias = vitorias
self.calcularProporcao()
def __repr__(self):
return 'Jogador: {0}'.format(self.id)
class Product(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
description = db.Column(db.String(255))
price = db.Column(db.Float(asdecimal=True))
image = db.Column(db.Column(db.LargeBinary))
def __init__(self, name, description, price, image):
self.name = name
self.description = description
self.price = price
self.image = image
def __repr__(self):
return '<Product %d>' % self.id
class Product(db.Model):
__tablename__ = "tb_product"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
price = db.Column(db.Float(asdecimal=True))
description = db.Column(db.String(255))
owner_id = db.Column(db.Integer)
def __init__(self, name, price, description, owner_id):
self.name = name
self.price = price
self.description = description
self.owner_id = owner_id
def __repr__(self):
return '<Product %d>' % self.id
class Serie(db.Model):
id = db.Column(db.Integer, primary_key=True)
titulo = db.Column(db.String(100))
genero = db.Column(db.String(50))
temporadas = db.Column(db.Integer)
mediaIMDB = db.Column(db.Float(asdecimal=True))
ativa = db.Column(db.Boolean)
def __init__(self, titulo, genero, temporadas, mediaIMDB, ativa):
self.titulo = titulo
self.genero = genero
self.temporadas = temporadas
self.mediaIMDB = mediaIMDB
self.ativa = ativa
def __repr__(self):
return 'Serie: {0}'.format(self.id)
class Company(db.Model): id = db.Column(db.Integer,primary_key = True) join_time = db.Column(db.DateTime, default=datetime.datetime.now) gstin = db.Column(db.String(15)) company_name = db.Column(db.String()) username = db.Column(db.String()) pwdhash = db.Column(db.String()) email_id = db.Column(db.String()) mobile_no = db.Column(db.String(10)) #Further we can change the string length to 13 (+91,etc) for different countries address = db.Column(db.String()) rating = db.Column(db.Float()) deals_in = db.Column(db.String()) no_of_reviews = db.Column(db.Integer) def __init__(self, gstin, company_name, username, password, email_id, mobile_no, address, deals_in): self.gstin = gstin self.company_name = company_name self.username = username self.pwdhash = generate_password_hash(password) self.email_id = email_id self.mobile_no = mobile_no self.address = address self.rating = None self.deals_in = deals_in self.no_of_reviews = 0 def __repr__(self): return '<%s>' % self.company_name def check_user_password(self,password): return check_password_hash(self.pwdhash,password) def is_authenticated(self): return True def is_admin(self): return False def is_anonymous(self): return False def is_active(self): return True def get_id(self): return self.id
class Console(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
year = db.Column(db.Integer)
price = db.Column(db.Float(asdecimal=True))
active = db.Column(db.Boolean)
qtdGames = db.Column(db.Integer)
def __init__(self, name, year, price, active, qtdGames):
self.name = name
self.year = year
self.price = price
self.active = active
self.qtdGames = qtdGames
def __repr__(self):
return 'Console {0}'.format(self.id)
class Console(db.Model):
id = db.Column(db.Integer, primary_key=True)
titulo = db.Column(db.String(100))
genero = db.Column(db.String(100))
temporadas = db.Column(db.Integer)
media = db.Column(db.Float(asdecimal=True))
finalizada = db.Column(db.String(100))
def __init__(self, titulo, genero, temporadas, media, finalizada):
self.titulo = titulo
self.genero = genero
self.temporadas = temporadas
self.media = media
self.finalizada = finalizada
def __repr__(self):
return 'Serie {0}'.format(self.id)
class Series(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100))
genre = db.Column(db.String(100))
seasons = db.Column(db.Integer)
score = db.Column(db.Float(asdecimal=True))
is_active = db.Column(db.Boolean)
def __init__(self, title, genre, seasons, score, is_active):
self.title = title
self.genre = genre
self.seasons = seasons
self.score = score
self.is_active = is_active
def __repr__(self):
return 'Series {0}'.format(self.id)
class Serie(db.Model):
id = db.Column(db.Integer, primary_key=True)
serie_title = db.Column(db.String(100))
gender = db.Column(db.String(100))
total_seasons = db.Column(db.Integer)
avg_imdb = db.Column(db.Float(asdecimal=True))
status = db.Column(db.String(8))
def __init__(self, serie_title, gender, total_seasons, avg_imdb, status):
self.serie_title = serie_title
self.gender = gender
self.total_seasons = total_seasons
self.avg_imdb = avg_imdb
self.status = status
def __repr__(self):
return 'Serie {0}'.format(self.id)
class Console(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
year = db.Column(db.Integer)
price = db.Column(db.Float(asdecimal=True))
active = db.Column(db.Boolean, unique=False, default=True)
quantity = db.Column(db.Integer)
def __init__(self, name, year, price, active, quantity):
self.name = name
self.year = year
self.price = price
self.active = active
self.quantity = quantity
def __repr__(self):
return 'Console {0}'.format(self.id)
class Summarize(db.Model):
__tablename__ = 'Summarize'
employee_id = db.Column(db.ForeignKey('Employee.id'),
primary_key=True,
nullable=False)
month = db.Column(db.Integer, primary_key=True, nullable=False)
year = db.Column(db.Integer, primary_key=True, nullable=False)
salary = db.Column(db.Float(asdecimal=True), nullable=False)
employee = db.relationship('Employee')
def __init__(self, employee_id, month, year, salary):
self.employee_id = employee_id
self.month = month
self.year = year
self.salary = salary
class Serie(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255))
genre = db.Column(db.String(255))
seasons = db.Column(db.Integer)
imdbRating = db.Column(db.Float(asdecimal=True))
isActive = db.Column(db.Boolean())
def __init__(self, title, genre, seasons, imdbRating, isActive):
self.title = title
self.genre = genre
self.seasons = seasons
self.imdbRating = imdbRating
self.isActive = isActive
def __repr_(self):
return 'Serie {0}'.format(self.id)
class Console(db.Model):
id = db.Column(db.Integer, primary_key=True)
titulo = db.Column(db.String(100))
genero = db.Column(db.String(100))
temporadas = db.Integer(db.Integer)
media = db.Float(db.Float)
active = db.Integer(db.Integer)
def __init__(self, titulo, genero, temporadas, media, active):
self.titulo = titulo
self.genero = genero
self.temporadas = temporadas
self.media = media
self.active = active
def __repr__(self):
return 'Console {0}'.format(self.id)
class Serie(db.Model):
id = db.Column(db.Integer, primary_key=True)
titulo = db.Column(db.String(100))
genero = db.Column(db.String(100))
ativa = db.Column(db.Boolean) # vira um tinyint(1)
media_no_imdb = db.Column(db.Float(asdecimal=True))
total_de_temporadas = db.Column(db.Integer)
def __init__(self, titulo, genero, ativa, media_no_imdb,
total_de_temporadas):
self.titulo = titulo
self.genero = genero
self.ativa = ativa
self.media_no_imdb = media_no_imdb
self.total_de_temporadas = total_de_temporadas
def __repr__(self):
return 'Série {0}'.format(self.id)
class Serie(db.Model):
id = db.Column(db.Integer, primary_key=True)
titulo = db.Column(db.String(100))
genero = db.Column(db.String(100))
totalDeTemporadas = db.Column(db.Integer)
mediaNoIMDB = db.Column(db.Float(asdecimal=True))
situacao = db.Column(db.String(100))
def __init__(self,titulo,genero,totalDeTemporadas,mediaNoIMDB,situacao):
self.titulo = titulo
self.genero = genero
self.totalDeTemporadas = totalDeTemporadas
self.mediaNoIMDB = mediaNoIMDB
self.situacao = situacao
def __repr__(self):
return 'Serie {0}'.format(self.id)
class Console(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
year = db.Column(db.Integer)
price = db.Column(db.Float(asdecimal=True))
total_games = db.Column(db.Integer)
is_active = db.Column(db.Boolean)
def __init__(self, name, year, price, total_games, is_active):
self.name = name
self.year = year
self.price = price
self.total_games = total_games
self.is_active = is_active
# Return the console ID
def __repr__(self):
return 'Console {0}'.format(self.id)
