class Publisher_App_Map(db.Model):
__tablename__ = 'PUBLISHER_APP_MAP'
id = db.Column(db.Integer,
index=True,
primary_key=True,
autoincrement=True)
publishers = db.Column(db.Unicode(200), index=True)
apps = db.Column(db.Unicode(20), index=True)
class Language_App_Map(db.Model):
__tablename__ = 'LANGUAGE_APP_MAP'
id = db.Column(db.Integer,
index=True,
primary_key=True,
autoincrement=True)
languages = db.Column(db.Unicode(200), index=True)
apps = db.Column(db.Unicode(20), index=True)
class Developer_App_Map(db.Model):
__tablename__ = 'DEVELOPER_APP_MAP'
id = db.Column(db.Integer,
index=True,
primary_key=True,
autoincrement=True)
developers = db.Column(db.Unicode(200), index=True)
apps = db.Column(db.Unicode(20), index=True)
class Genre_App_Map(db.Model):
__tablename__ = 'GENRE_APP_MAP'
id = db.Column(db.Integer,
index=True,
primary_key=True,
autoincrement=True)
genres = db.Column(db.Unicode(200), index=True)
apps = db.Column(db.Unicode(20), index=True)
class DLC_id_App_Map(db.Model):
__tablename__ = 'DLC_ID_APP_MAP'
id = db.Column(db.Integer,
index=True,
primary_key=True,
autoincrement=True)
dlc_ids = db.Column(db.Unicode(200), index=True)
apps = db.Column(db.Unicode(20), index=True)
class Time_To_Beat(db.Model):
__tablename__ = 'TIME_TO_BEAT'
app_id = db.Column(db.Unicode(20), index=True, primary_key=True)
data_imputed_completionist = db.Column(db.Boolean)
data_imputed_extras = db.Column(db.Boolean)
data_imputed_main_game = db.Column(db.Boolean)
hltb_id = db.Column(db.Unicode(20))
minutes_to_beat_completionist = db.Column(db.Integer)
minutes_to_beat_extras = db.Column(db.Integer)
minutes_to_beat_main_game = db.Column(db.Integer)
timetobeat_api_raw = db.Column(db.Text)
class App(db.Model):
__tablename__ = 'APPS'
achievements_enabled = db.Column(db.Boolean)
app_id = db.Column(db.Unicode(20), primary_key=True)
app_type = db.Column(db.UnicodeText)
app_website = db.Column(db.UnicodeText)
big_logo = db.Column(db.UnicodeText)
captions = db.Column(db.Boolean)
commentary = db.Column(db.Boolean)
controller_support = db.Column(db.UnicodeText)
hdr = db.Column(db.Boolean)
hours_played = db.Column(db.Float)
last_updated = db.Column(db.DateTime)
leaderboards_enabled = db.Column(db.Boolean)
metascore = db.Column(db.UnicodeText)
metascore_link = db.Column(db.UnicodeText)
minutes_played = db.Column(db.Integer)
multiplayer = db.Column(db.Boolean)
os_linux = db.Column(db.Boolean)
os_mac = db.Column(db.Boolean)
os_windows = db.Column(db.Boolean)
release_date = db.Column(db.UnicodeText)
required_age = db.Column(db.Integer)
singleplayer = db.Column(db.Boolean)
size_mb = db.Column(db.Float)
source_sdk_included = db.Column(db.Boolean)
stats_enabled = db.Column(db.Boolean)
steamcloud_enabled = db.Column(db.Boolean)
store_price_default_usd = db.Column(db.Float)
tradingcards_enabled = db.Column(db.Boolean)
VAC_enabled = db.Column(db.Boolean)
workshop_enabled = db.Column(db.Boolean)
def __repr__(self):
return '<App %s - "Name No Longer Stored" (%s%s) | Type: %s | Multi: %s | Price: $%s | Windows: %s | Mac: %s | Linux: %s | Joy: %s | Metacritic: %s | %s>' % (
self.app_id, self.size_mb, ' MB', self.app_type, self.multiplayer,
self.store_price_default_usd, self.os_windows, self.os_mac,
self.os_linux, self.controller_support, self.metascore,
self.big_logo)