def write2DB(self):
from ReadData import ReadData
#rd = ReadData(self.morning)
ymd = str(self.date_time.year)+"-"+str(self.date_time.month)+"-"+str(self.date_time.day)+"-"+str(self.date_time.weekday())
if self.morning==True:
ymd = "m"+ymd
file_bak = "../daily/" + ymd + ".txt"
rd = ReadData(self.morning)
rd.gbk2utf8("深沪A股.TXT", file_bak)
f = open(file_bak)
try:
con = mdb.connect('localhost', 'root', '1', 'financedb', charset='utf8')
cur = con.cursor()
Regex1 = re.compile(r"\d")
while True:
line = f.readline()
if not line:
break
if not re.search(Regex1, line):
print line
continue
data = rd.splitItem(line)
for w in data: print w,
print ""
create_time = self.date_time.strftime('%Y-%m-%d %H:%M:%S')
sql = "INSERT INTO " + self.table_name + \
"(idx, name, rise_rate, cur_price, rise_price, buy,\
sale, total_stock, cur_stock, rise_v, exchange, day_begin,\
up, down, yesterday, profit, total_price, quantity_ratio,\
industry, area, amplitude, ave_price, inner_market,\
outer_market, inner_outer_ratio, buy_volume, sale_volume,\
currency_capital, market_cap, create_time)\
VALUES( \'" + data[0] +"\',\'"+ data[1] +"\',"+ data[2] +","\
+ data[3] +","+ data[4] +","+ data[5] +","+ data[6] +","\
+ data[7] +","+ data[8] +","+ data[9] +","+ data[10] +","\
+ data[11] +","+ data[12] +","+ data[13] +","+ data[14] +","\
+ data[15] +","+ data[16] +","+ data[17] +",\'"+ data[18] +"\',\'"\
+ data[19] +"\'," + data[20] +","+ data[21] +"," + data[22] +","\
+ data[23] +","+ data[24] +","+ data[25] +","+ data[26] +","\
+ data[27] +","+ data[28] +",\'"+ create_time + "\')"
print sql
cur.execute(sql)
except mdb.Error, e:
print "Error %d: %s" % (e.args[0], e.args[1])
sys.exit(1)
