def get_ven_range(cls, ta_name):
if not ta_name or ta_name is None:
raise ValueError(cls.EX_TA_NAME.format(ta_name))
con = None
cursor = None
try:
con = DBResource.get_instance().get_connection()
cursor = con.cursor()
cursor.execute(cls.GET_VEN_RANGE, (ta_name, ))
if cursor is not None:
inn_range = cursor.fetchmany(5)
bat_avg_range = cursor.fetchmany(5)
bat_sr_range = cursor.fetchmany(5)
centuries_range = cursor.fetchmany(2)
fifties_range = cursor.fetchmany(2)
hs_range = cursor.fetchmany(5)
overs_range = cursor.fetchmany(5)
bowl_avg_range = cursor.fetchmany(5)
bowl_sr_range = cursor.fetchmany(5)
ff_range = cursor.fetchmany(2)
return [
inn_range, bat_avg_range, bat_sr_range, centuries_range,
fifties_range, hs_range, overs_range, bowl_avg_range,
bowl_sr_range, ff_range
]
except BaseException as be:
raise RuntimeError(cls.EX_VEN_RANGE.format(ta_name), be)
finally:
cursor.close()
con.close()
def get_grounds(cls):
grounds = []
con = None
cursor = None
try:
con = DBResource.get_instance().get_connection()
cursor = con.cursor()
cursor.execute(cls.GET_GROUNDS)
for row in cursor:
grounds.append(row[0])
return grounds
except BaseException as be:
raise RuntimeError(cls.EX_GROUNDS, be)
finally:
cursor.close()
con.close()
def get_player_role(cls, player_name):
if not player_name or player_name is None:
raise ValueError(cls.EX_INVALID_PLAYER_NAME.format(player_name))
con = None
cursor = None
try:
con = DBResource.get_instance().get_connection()
cursor = con.cursor()
cursor.execute(cls.GET_PLAYER_ROLE % player_name)
for row in cursor:
return row[0]
except BaseException as be:
raise RuntimeError(cls.EX_PLAYER_ROLE.format(player_name), be)
finally:
cursor.close()
con.close()
def get_teams(cls):
teams = []
con = None
cursor = None
try:
con = DBResource.get_instance().get_connection()
cursor = con.cursor()
# rs = cursor.execute(cls.GET_TEAMS)
cursor.execute(cls.GET_TEAMS)
for row in cursor:
teams.append(row[0])
return teams
except BaseException as be:
raise RuntimeError(cls.EX_TEAMS, be)
finally:
cursor.close()
con.close()
def get_team_id(cls, team_name):
if not team_name or team_name is None:
raise ValueError(cls.EX_TEAM_NAME.format(team_name))
con = None
cursor = None
try:
con = DBResource.get_instance().get_connection()
cursor = con.cursor()
cursor.execute(cls.GET_TEAM_ID, (team_name, ))
for row in cursor:
return row[0]
except BaseException as be:
raise RuntimeError(cls.EX_TEAM_ID.format(team_name), be)
finally:
cursor.close()
con.close()
def get_players(cls, team_name):
if not team_name or team_name is None:
raise ValueError(cls.EX_INVALID_TEAM_NAME.format(team_name))
players = []
con = None
cursor = None
try:
con = DBResource.get_instance().get_connection()
cursor = con.cursor()
cursor.execute(cls.GET_PLAYERS, (team_name, ))
for row in cursor:
players.append(row[0])
return players
except BaseException as be:
raise RuntimeError(cls.EX_PLAYERS.format(team_name), be)
finally:
cursor.close()
con.close()
def get_player_id(cls, players_list):
if not players_list or players_list is None:
raise ValueError(cls.EX_INVALID_PLAYERS.format(players_list))
p_list = []
con = None
cursor = None
try:
con = DBResource.get_instance().get_connection()
cursor = con.cursor()
cursor.execute(cls.GET_PLAYER_ID, (players_list, ))
for row in cursor:
p_list.append(row[0])
return p_list
except BaseException as be:
raise RuntimeError(cls.EX_PLAYER_ID.format(players_list), be)
finally:
cursor.close()
con.close()