37,719
社区成员
发帖
与我相关
我的任务
分享
db.getCursor()
while 1:
rows = db.getData(10000)
line = 0
for row in rows:
rowex = ''
for item in row:
if item == None:
item = ''
elif isinstance(item, datetime.datetime):
item = "{:%Y%m%d%H%M%S}".format(item)
else:
str(item).replace('\\','\\\\')
rowex = rowex + "\t{0}".format(item)
rowex += "\n"
self.write(rowex[1:])
self.flush()
line += 1
if not (line % 10000):
print (line)
if line < 10000:
break
self.flush()
db.finish()
for row in rows:
rowex = ''
for item in row:
if item == None:
item = ''
elif isinstance(item, datetime.datetime):
item = "{:%Y%m%d%H%M%S}".format(item)
else:
str(item).replace('\\','\\\\')
rowex = rowex + "\t{0}".format(item)
for row in rows:
rowex=''
str(item).replace('\\','\\\\')
>>> s = "abcd"
>>> str(s).replace('a', 'e')
0: 'ebcd'
>>> s
1: 'abcd'
>>>