1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
# -*- coding: utf-8 -*-
from bs4 import BeautifulSoup as bs
import bs4
import re
import sys
input_file = sys.argv[1]
rnd = int(sys.argv[2])
segment = int(sys.argv[3])
board = int(sys.argv[4])
content = bs(file(input_file), 'lxml')
rows = content.select('tr')
scores = {}
current_table_no = None
current_table = []
for row in rows:
table_link = row.select('a[target="polew"]')
if table_link:
if current_table_no:
scores[current_table_no] = current_table
current_table_no = int(table_link[0].text)
current_table = []
cells = row.select('td.bdc')
if len(cells) > 0:
score = ''
cells = cells[0:-1]
for cell in cells:
for element in cell.contents:
if type(element) is bs4.element.Tag:
score += element['alt']
else:
score += element.replace('×'.decode('utf8'), 'x')
point_cells = row.select('td.zno') + row.select('td.zeo')
current_table.append({
'score': score,
'points': (point_cells)[0].text if len(point_cells) > 0 else '0'
})
scores[current_table_no] = current_table
score_regex = re.compile(r'^([1-7])([cdhns])(x?)([ENSW])([cdhs]([AKQJ2-9]|10))(=|(-|\+)[1-7])')
for room in [1, 2]:
for tabl in scores.keys():
score = scores[tabl][room - 1]['score']
point_result = scores[tabl][room - 1]['points']
parsed_score = re.match(score_regex, score)
if parsed_score:
contract = ('%s %s %s' % (
parsed_score.group(1),
parsed_score.group(2).replace('n', 'nt').upper(),
parsed_score.group(3)
)).strip()
declarer = parsed_score.group(4)
lead = parsed_score.group(5).upper()
result = parsed_score.group(7)
result = 0 if result == '=' else int(result)
print ('UPDATE scores SET ' \
+ 'declarer = "' + declarer + '", ' \
+ 'contract = "' + contract + '", ' \
+ 'result = ' + str(result) + ', ' \
+ 'score = ' + point_result + ', ' \
+ 'lead = "' + lead + '" WHERE ' \
+ 'rnd = ' + str(rnd) + ' AND ' \
+ 'segment = ' + str(segment) + ' AND ' \
+ 'room = ' + str(room) + ' AND ' \
+ 'tabl = ' + str(tabl) + ' AND ' \
+ 'board = ' + str(board) + ';').encode('utf8')
elif score[0:3] == 'PAS':
print ('UPDATE scores SET ' \
+ 'declarer = NULL, ' \
+ 'contract = "PASS", ' \
+ 'result = NULL, ' \
+ 'score = 0, ' \
+ 'lead = NULL WHERE ' \
+ 'rnd = ' + str(rnd) + ' AND ' \
+ 'segment = ' + str(segment) + ' AND ' \
+ 'room = ' + str(room) + ' AND ' \
+ 'tabl = ' + str(tabl) + ' AND ' \
+ 'board = ' + str(board) + ';').encode('utf8')
else:
print '-- ->' + score.encode('utf8')
|
