teams_for_challenge = teams[sport_id][challenge_id]
match_id = 0
bets_id = 1
today = datetime.date.today()
today_format = today.strftime("%Y-%m-%d %H:%M:%S")
sql = "DELETE FROM matches, coefficients USING matches, coefficients WHERE matches.time < '%s' AND matches.id = coefficients.match_id" % today_format
cursor.execute(sql)
cursor.execute ("SELECT title FROM matches WHERE challenge_id = %s", (challenge_id))
data = cursor.fetchall()
for tables in doc.cssselect('table.foot-market > tbody tr.event-header'):
t1 = CParser.parser_team_from_str(tables.cssselect('tr.event-header > td.first > table > tr:nth-child(1) td.name span div')[0].text.encode('utf-8'), teams_for_challenge)
t2 = CParser.parser_team_from_str(tables.cssselect('tr.event-header > td.first > table > tr:nth-child(1) td.name span div')[1].text.encode('utf-8'), teams_for_challenge)
title = t1 + " - " + t2
time = CParser.time_conversion_for_marathon(tables.cssselect('tr.event-header > td.first > table > tr:nth-child(1) td.date')[0].text.encode('utf-8').strip(" \r\n"))
first = tables.cssselect('tr.event-header > td:nth-child(2) span')[0].text.encode('utf-8')
x = tables.cssselect('tr.event-header > td:nth-child(3) span')[0].text.encode('utf-8')
second = tables.cssselect('tr.event-header > td:nth-child(4) span')[0].text.encode('utf-8')
first_x = tables.cssselect('tr.event-header > td:nth-child(5) span')[0].text.encode('utf-8')
first_second = tables.cssselect('tr.event-header > td:nth-child(6) span')[0].text.encode('utf-8')
x_second = tables.cssselect('tr.event-header > td:nth-child(7) span')[0].text.encode('utf-8')
team1_coef = tables.cssselect('tr.event-header > td:nth-child(8) span')[0].text.encode('utf-8')
team2_coef = tables.cssselect('tr.event-header > td:nth-child(9) span')[0].text.encode('utf-8')
first = re.sub("\s*\n\s*", ' ', first.strip())
x = re.sub("\s*\n\s*", ' ', x.strip())
sql = "DELETE FROM matches, coefficients USING matches, coefficients WHERE matches.time < '%s' AND matches.id = coefficients.match_id" % today_format
cursor.execute(sql)
line_time = 0
match_id = 0
bets_id = 0
cursor.execute ("SELECT title FROM matches WHERE challenge_id = %s", (challenge_id))
data = cursor.fetchall()
for lines in doc.cssselect('tbody'):
if (lines.get('class') == "date"):
line_date = lines.cssselect('tr td')[0].text.encode("utf-8")
if (lines.get('id') == "line"):
t1 = CParser.parser_team_from_str(lines.cssselect('td:nth-child(2) b')[0].text.encode('utf-8'), teams_for_challenge)
t2 = CParser.parser_team_from_str(lines.cssselect('td:nth-child(5) b')[0].text.encode('utf-8'), teams_for_challenge)
line_time = CParser.time_conversion_for_betscity(line_date, lines.cssselect('td:nth-child(1)')[0].text.encode('utf-8'))
team1_coef = lines.cssselect('td:nth-child(4) a')[0].text.encode('utf-8')
team2_coef = lines.cssselect('td:nth-child(7) a')[0].text.encode('utf-8')
first = lines.cssselect('td:nth-child(8) a')[0].text.encode('utf-8')
x = lines.cssselect('td:nth-child(9) a')[0].text.encode('utf-8')
second = lines.cssselect('td:nth-child(10) a')[0].text.encode('utf-8')
first_x = lines.cssselect('td:nth-child(11) a')[0].text.encode('utf-8')
first_second = lines.cssselect('td:nth-child(12) a')[0].text.encode('utf-8')
x_second = lines.cssselect('td:nth-child(13) a')[0].text.encode('utf-8')
title = t1 + " - " + t2
occurrence = 1
