def main(): obj = Fetcher() #初始化数据,比如 分类表 # obj.initData() # 取出117 chuancai 保存mysql # datalist1 = obj.fromAccessToList(1) # for data in datalist1: # print data[0] # obj.insertDataToMySQL(data) # 取出118 yuecai # datalist2 = obj.fromAccessToList(2) # for data in datalist2: # obj.insertDataToMySQL(data) # 取出119 xiangcai # datalist3 = obj.fromAccessToList(3) # for data in datalist3: # obj.insertDataToMySQL(data) # # # 取出 120 jingcai # datalist4 = obj.fromAccessToList(4) # for data in datalist4: # obj.insertDataToMySQL(data) # 取出 121 lucai # datalist5 = obj.fromAccessToList(5) # for data in datalist5: # obj.insertDataToMySQL(data) #取出 122 mincai # datalist6 = obj.fromAccessToList(6) # for data in datalist6: # obj.insertDataToMySQL(data) # #取出 123 huicai # datalist7 = obj.fromAccessToList(7) # for data in datalist7: # obj.insertDataToMySQL(data) # # #取出 124 zhecai # datalist8 = obj.fromAccessToList(8) # for data in datalist8: # obj.insertDataToMySQL(data) # #取出 125 shucai datalist9 = obj.fromAccessToList(9) for data in datalist9: obj.insertDataToMySQL(data) #取出 126 ecai datalist10 = obj.fromAccessToList(10) for data in datalist10: obj.insertDataToMySQL(data) #取出 127 diancai datalist11 = obj.fromAccessToList(11) for data in datalist11: obj.insertDataToMySQL(data) #取出 128 liaocai datalist12 = obj.fromAccessToList(12) for data in datalist12: obj.insertDataToMySQL(data) #取出 129 sifangcai datalist13 = obj.fromAccessToList(13) for data in datalist13: obj.insertDataToMySQL(data) print "save ok"
def run(self): for data in self.data_list: obj = Fetcher() obj.insertDataToMySQL(data) time.sleep(self.interval)