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)
rd = ReadData() rd.gbktoutf8("深沪A股.TXT") file_name = ymd + "." + "txt" f = open(file_name) title = f.readline() #read the title print title while True: line = f.readline() print line if not line: #EOF break if not re.search(r"\d", line): continue data = rd.splitItem(line) for w in data: print w, print '' #yesterday = date.today() - timedelta(1) #create_time = yesterday.strftime('%Y-%m-%d %H:%M:%S') create_time = time.strftime('%Y-%m-%d %H:%M:%S') sql = "INSERT INTO " + 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,\ 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] +","\