def _get_coaches(tablename):
debug = False
global coaches
coaches = {}
odb = db()
cursor = odb.get_cursor()
pf = []
wherestr = kf.general_kabuka_where(meigaras, startd, endd)
if debug:
strsql = "select code, date, fieldid from %s order by fieldid limit 1000;" % (tablename, wherestr)
else:
strsql = "select code, date, fieldid from %s %s order by fieldid;" % (tablename, wherestr)
cursor.execute(strsql)
old_fieldid = ""
for row in cursor:
i = iter(row)
code = next(i)
date = next(i)
fieldid = next(i)
pf.append([code, date])
if old_fieldid != "" and old_fieldid != fieldid:
_add_coach(old_fieldid, pf)
pf = []
old_fieldid = fieldid
_add_coach(fieldid, pf)
#print len(coaches)
cursor.close()
def _get_coaches(self, tablename, startd, endd):
debug = False
odb = db()
cursor = odb.get_cursor()
pf = []
endd = dtf.datestrsub(endd, self.expected_trade_period+1)
if endd <= startd:
return None
wherestr = kf.general_kabuka_where(self.meigaras, startd, endd)
if debug:
strsql = "select code, date, fieldid from %s order by fieldid limit 1000;" % (tablename, wherestr)
else:
strsql = "select code, date, fieldid from %s %s order by fieldid;" % (tablename, wherestr)
cursor.execute(strsql)
old_fieldid = ""
fieldid = ""
for row in cursor:
i = iter(row)
code = next(i)
date = next(i)
fieldid = next(i)
pf.append([code, date])
if old_fieldid != "" and old_fieldid != fieldid:
self._add_coach(old_fieldid, pf)
pf = []
old_fieldid = fieldid
if fieldid != "":
self._add_coach(fieldid, pf)
#print len(coaches)
cursor.close()
def _set_dicts(self):
odb = db()
cursor = odb.get_cursor()
#strsql = "select code, date, close, volsize, dow_sign from trade.dow "
strsql = "select code, date, close from trade.kabuka "
wherestr = kf.general_kabuka_where(self.meigaras, self.startd, self.endd)
strsql = strsql + wherestr
strsql = strsql + " order by code, date;"
try:
cursor.execute(strsql)
except MySQLdb.Error, e:
f.log(strsql)
raise Exception("SQL ERROR %d: %s" % (e.args[0], e.args[1]))
def _alloc_players_from_db():
odb = db()
cursor = odb.get_cursor()
strsql = "select fieldid, geneid, score, points, holding_days, life_len from %s \
where play_style = \'%s\'and trade_mode = \'%s\' order by fieldid;" % (tp_table, play_style, trade_mode)
cursor.execute(strsql)
for row in cursor:
i = iter(row)
fieldid = next(i)
geneid = next(i)
score = next(i)
points = next(i)
holding_days = next(i)
life_len = next(i)
coaches[fieldid].assign_player(player(geneid, play_style, tm, trade_mode, score, points, holding_days, life_len))
def _alloc_players_from_db(self):
odb = db()
cursor = odb.get_cursor()
strsql = "select fieldid, geneid, total_score, holding_days, life_len, n_plays, n_win, n_lose from %s \
order by fieldid;" % (self.tp_table)
cursor.execute(strsql)
for row in cursor:
i = iter(row)
fieldid = next(i)
geneid = next(i)
total_score = next(i)
holding_days = next(i)
life_len = next(i)
n_plays = next(i)
n_win = next(i)
n_lose = next(i)
if self.coaches.has_key(fieldid):
self.coaches[fieldid].assign_player(player(geneid, self.kls,
total_score, holding_days, life_len, n_plays, n_win, n_lose))
