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