/ Published in: Python
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
type_str = type('str') type_datetime = type(datetime.datetime.now()) type_int = type(1) type_float = type(1.0) type_None = type(None) #todo: handle blob data type def convert2str(record): res = [] for item in record: if type(item)==type_None: res.append('NULL') elif type(item)==type_str: res.append('"'+item+'"') elif type(item)==type_datetime: res.append('"'+str(item)+'"') else: # for numeric values res.append(str(item)) return ','.join(res) def copy_table(tab_name, src_cursor, dst_cursor): sql = 'select * from %s'%tab_name src_cursor.execute(sql) res = src_cursor.fetchall() cnt = 0 for record in res: val_str = convert2str(record) try: sql = 'insert into %s values(%s)'%(tab_name, val_str) dst_cursor.execute(sql) cnt += 1 except: print cnt, val_str return cnt