def get_magical_beasts_of_player(self, player):
self.connect_db()
magical_beasts = db_get_data_by_id(
self.db, db_magical_beasts_table,
[(db_magical_beasts_table_player_id_field_name, player.id)], ["*"])
if magical_beasts is ():
magical_beasts = []
return magical_beasts
def get_guild_data(self, guild):
self.connect_db()
guild_data = db_get_data_by_id(
self.db, db_guilds_data_table,
[(db_guilds_data_table_guild_id_field_name, guild.id)], ["*"])
if guild_data is not None:
guild_data = guild_data[0]
return guild_data
def get_buildings_of_player(self, player):
self.connect_db()
player_buildings = db_get_data_by_id(
self.db, db_buildings_table,
[(db_buildings_table_player_id_field_name, player.id)], ["*"])
if player_buildings is None:
player_buildings = []
return player_buildings
def get_player_data(self, player):
self.connect_db()
player_data = db_get_data_by_id(
self.db, db_player_table,
[(db_player_table_player_id_field_name, str(player.id))], ["*"])
if player_data is ():
player_data = None
else:
player_data = player_data[0]
return player_data
def get_data_from_db(self, table: str, where_fields_name_and_values: list,
fields: list):
self.connect_db()
return db_get_data_by_id(self.db, table, where_fields_name_and_values,
fields)
def get_player_buildings(self, player):
self.connect_db()
return db_get_data_by_id(
self.db, db_buildings_table,
[(db_buildings_table_player_id_field_name, str(player.id))], ["*"])