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 _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 _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]))
