python通用文件入库脚本

 

#!/usr/bin/python
import dmPython

table = 'TB FACE_BASE64 CK'
fields = 'PERSON, IMAGE"
separator ='|++|'
file_dir ='/dmdata/photo/image_encodeings.txt'
commit num = 300

question_mask=','.join('?'*fields.count(',')+'?')
insert_ sql = "insert into {} ({}) values({})".format(table, fields, question mask)
print("insert sql is:' + insert_sql)

conn = dmPython.connect(user='test' , password =‘123456' , server ='12.0.0.1', port=15236)
cursor = conn.cursor()
with open(file_dir, 'r') as f:
  while True:
    lines = f.readlines(commit_num)
      if not lines:
        break
      linelist = [i.split(separator) for i in lines]
      cursor.executemany(insert sql, linelist)
      conn.commit()

cursor.close()
conn.close()