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)