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)