def logs_import_sql(cls,logs_path):
# logs_path = '/home/op/test/www_access_20140823.log'
# logs_path = '/home/jcui/files/www_access_20140823.log'
log_list = cls.log_anslysis(logs_path)
_sql = 'insert into access_logs(ip,url,code,nums) values(%s,%s,%s,%s)'
if SQL.excute_log_sql(_sql, log_list):
return True
return False
_rt = get_city(ip)
if _rt[0]:
city, lat, lng = _rt[1], _rt[2], _rt[3]
if city == '':
print 'city is null:%s' % ip
continue
else:
print 'city is null:%s' % ip
continue
else:
lat = response.location.latitude
lng = response.location.longitude
#lng 经度
#lat 纬度
except BaseException as e:
print ip
_rt = get_city(ip)
if _rt[0]:
city, lat, lng = _rt[1], _rt[2], _rt[3]
if city == '':
print 'city is null:%s' % ip
continue
else:
print 'geo ip not found ip:%s' % ip
rt_list.append((logtime, ip, url, status, lat, lng, city))
log_files.close()
_sql = 'insert into access_logs2(logtime,ip,url,status,lat,lng,city) values(%s,%s,%s,%s,%s,%s,%s)'
SQL.excute_log_sql(_sql, rt_list)