class Summoner(db.Model):
"""
A Summoner is the equivalent of a player in League of Legends, each Summoner has a pool of champions he or she much unlock to be able to player
A Summoner can play Ranked Matches in order to increase his Rank, declared as (tier, division, lp). In order to be promoted in division, and eventually tier,
he or she must earn League Points, or LP, by winning Matches.
Thus, win rate is important.
A Summoner can also join social circles called Teams, where teams have definitive rosters that can compete in Ranked matches as well.
A Summoner can earn Mastery Points with any corresponding unlocked Champion, where mastery points describes the relative skill the summoner has with the champion
"""
__tablename__ = 'summoner'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50))
rank = db.Column(db.Integer)
tier = db.Column(db.String(50))
division = db.Column(db.String(10))
lp = db.Column(db.Integer)
champions = db.relationship("SummonerChampionMastery", backref=db.backref("summoner"))
teams = db.relationship("Team", secondary=team_membership, backref=db.backref("summoners"))
total_games = db.Column(db.Integer)
win_percentage = db.Column(db.Float)
#search_vector = db.Column(TSVectorType('name', 'summoner_id', 'rank'))
def __init__(self, s_id, name, tier, division, lp, win_per, total_games):
self.id = s_id
self.name = name
self.rank = 0
if (tier.lower() == "bronze"):
self.rank += 100
elif (tier.lower() == "silver"):
self.rank += 200
elif (tier.lower() == "gold"):
self.rank += 300
elif (tier.lower() == "platinum"):
self.rank += 400
elif (tier.lower() == "diamond"):
self.rank += 500
elif (tier.lower() == "master"):
self.rank += 600
elif (tier.lower() == "challenger"):
self.rank += 700
if (division == "I"):
self.rank += 80
if (division == "II"):
self.rank += 60
if (division == "III"):
self.rank += 40
if (division == "IV"):
self.rank += 20
if (division == "V"):
self.rank += 0
self.tier = tier
self.division = division
self.lp = lp
self.win_percentage = win_per
self.total_games = total_games
class SummonerChampionMastery(db.Model):
"""
Maps the db.relationship between Summoners and Champions
A Summoner can have multiple Champions
A Champion can be unlocked by multiple Summoners
Each Summoner has respective Mastery Points with a corresponding Champion
This many-to-many db.relationship is represented thru an association table
"""
__tablename__ = 'summoner_champion_mastery'
summ_id = db.Column(db.Integer, db.ForeignKey('summoner.id'), primary_key=True)
champ_id = db.Column(db.Integer, db.ForeignKey('champion.id'), primary_key=True)
mastery_score = db.Column(db.Integer)
def __init__(self, score, pid, cid):
self.mastery_score = score
self.summ_id = pid
self.champ_id = cid
class Comic(db.Model):
__tablename__ = 'comic'
id = db.Column(db.Integer, primary_key=True)
thumbnail = db.Column(db.String(256))
title = db.Column(db.String(256))
issue_num = db.Column(db.Integer)
description = db.Column(db.String(3000))
page_count = db.Column(db.Integer)
series = db.Column(db.String(256))
number_of_creators = db.Column(db.Integer)
number_of_characters = db.Column(db.Integer)
number_of_stories = db.Column(db.Integer)
creators = db.relationship('Creator',
secondary="comic_creator",
backref="comics")
def __repr__(self):
id = self.id if self.id else None
return '<%s %s>' % (self.__class__.__name__, id)
class Creator(db.Model):
__tablename__ = 'creator'
id = db.Column(db.Integer, primary_key=True)
thumbnail = db.Column(db.String(256))
first_name = db.Column(db.String(256))
last_name = db.Column(db.String(256))
number_of_comics = db.Column(db.Integer)
number_of_stories = db.Column(db.Integer)
number_of_series = db.Column(db.Integer)
def __repr__(self):
id = self.id if self.id else None
return '<%s %s>' % (self.__class__.__name__, id)
class Character(db.Model):
__tablename__ = 'character'
id = db.Column(db.Integer, primary_key=True)
thumbnail = db.Column(db.String(256))
name = db.Column(db.String(256))
description = db.Column(db.String(3000))
number_of_comics = db.Column(db.Integer)
number_of_stories = db.Column(db.Integer)
number_of_series = db.Column(db.Integer)
comics = db.relationship('Comic',
secondary="comic_character",
backref="characters")
def __repr__(self):
id = self.id if self.id else None
return '<%s %s>' % (self.__class__.__name__, id)
class Champion(db.Model):
"""
Champions are the characters that Summoners can play in this game. Each Champion has unique abilities and personalized db.Model stats which change with level.
"""
__tablename__ = 'champion'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50))
title = db.Column(db.String(50))
hp = db.Column(db.Float)
mp = db.Column(db.Float)
movespeed = db.Column(db.Float)
spellblock = db.Column(db.Float)
portrait_url = db.Column(db.String(50))
summoners = db.relationship("SummonerChampionMastery", backref=db.backref("champion"))
def __init__(self, id, name, title, hp, mp, movespeed, spellblock, portrait_url):
self.id = id
self.name = name
self.title = title
self.hp = hp
self.mp = mp
self.movespeed = movespeed
self.spellblock = spellblock
self.portrait_url = portrait_url
class Team(db.Model):
"""
Teams are composed of Summoners, with the minimum of 1 Summoner per team. Each team name is unique. Each Team can play in a competitive setting in ranked matches
"""
__tablename__ = 'team'
id = db.Column(db.String(50), primary_key=True)
name = db.Column(db.String(255))
tag = db.Column(db.String(50))
status = db.Column(db.Boolean)
win_percentage = db.Column(db.Float)
total_games = db.Column(db.Integer)
most_recent_member_timestamp = db.Column(db.String(255))
def __init__(self, id, name, tag, status, win_p, total_games, most_recent_member_timestamp):
self.id = id
self.name = name
self.tag = tag
self.status = status
self.win_percentage = win_p
self.total_games = total_games
self.most_recent_member_timestamp = most_recent_member_timestamp
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship, backref
from tests import db
comic_character = db.Table(
'comic_character',
db.Column('comic_id',
db.Integer,
db.ForeignKey("comic.id"),
primary_key=True),
db.Column('character_id',
db.Integer,
db.ForeignKey("character.id"),
primary_key=True))
comic_creator = db.Table(
'comic_creator',
db.Column('comic_id',
db.Integer,
db.ForeignKey("comic.id"),
primary_key=True),
db.Column('creator_id',
db.Integer,
db.ForeignKey("creator.id"),
primary_key=True))
class Character(db.Model):
__tablename__ = 'character'
#!/usr/bin/env python3
"""
models.py
"""
import json
from flask.ext.sqlalchemy import SQLAlchemy
from tests import db
team_membership = db.Table('team_membership',
db.Column('summoner_id', db.Integer, db.ForeignKey('summoner.id')),
db.Column('team_id', db.String(50), db.ForeignKey('team.id'))
)
class Summoner(db.Model):
"""
A Summoner is the equivalent of a player in League of Legends, each Summoner has a pool of champions he or she much unlock to be able to player
A Summoner can play Ranked Matches in order to increase his Rank, declared as (tier, division, lp). In order to be promoted in division, and eventually tier,
he or she must earn League Points, or LP, by winning Matches.
Thus, win rate is important.
A Summoner can also join social circles called Teams, where teams have definitive rosters that can compete in Ranked matches as well.
A Summoner can earn Mastery Points with any corresponding unlocked Champion, where mastery points describes the relative skill the summoner has with the champion
"""
__tablename__ = 'summoner'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50))
rank = db.Column(db.Integer)
tier = db.Column(db.String(50))