python批量导入文件_python 批量导入

!/usr/bin/envpythoncoding:utf-8importMySQLdbdefdb_execute(sql):dbs=MySQLdb.connect(host='localhost',user='root',passwd='root',db='db',port=3306)cursor=dbs.cursor()cursor....

!/usr/bin/env python

coding: utf-8

import MySQLdb

def db_execute(sql):

dbs = MySQLdb.connect(host='localhost', user='root', passwd='root', db='db', port=3306)

cursor = dbs.cursor()

cursor.execute(sql)

cursor.close()

def read_file(file_path):

sql_lines = []

with open(file_path, 'r') as file:

for line in file.readlines():

sql = 'insert into ips (ip,ipint,city) values("{0}",inet_aton("{0}")," ");'.format(line)

sql_lines.append(sql)

return '\r\n'.join(sql_lines)

sql_lines = read_file('c:\a.txt')

db_execute(sql_lines)

排除存在问题步骤如下:

第一:引入的import MySQLdb 没有报错.同时使用如下代码测试正常:

第二:生成的insert into 语句在mysql数据库可以正常插入,但是目前提示错误信息如下:

insert into ips (ip,ipint,city) values("113.236.197.57",inet_aton("113.236.197.5

7")," ");

Traceback (most recent call last):

File "new044.py", line 24, in

db_execute(sql_lines)

File "new044.py", line 7, in db_execute

cursor.execute(sql)

File "C:Python27libsite-packagesMySQLdbcursors.py", line 202, in execute

self.errorhandler(self, exc, value)

File "C:Python27libsite-packagesMySQLdbconnections.py", line 36, in defau

lterrorhandler

raise errorclass, errorvalue

_mysql_exceptions.OperationalError: (1048, "Column 'ipint' cannot be null")

展开