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