import os
import sys
import pickle
import string
import re
import time
from datetime import date
from csv_timestamp_datetime import *
ip_region_list = pickle.load(open('ip_region_list.pickle','r'))
ip_region_list.sort(key=lambda x: x[0])
list_len = len(ip_region_list)
def find(key):
begin = 0
end = list_len - 1
while(begin <= end):
middle = (begin + end) / 2
if ip_region_list[middle][0] <= key and ip_region_list[middle][1] >= key:
return ip_region_list[middle][2]
else:
if ip_region_list[middle][0] >= key:
end = middle - 1
else:
begin = middle + 1
def ip2region():
of = open(sys.argv[1], 'r')
nf = open(sys.argv[2], 'w')
for line in of:
items = line.strip().split(',')
try:
x = time.localtime(long(items[0]))
ymdhms = time.strftime('%Y-%m-%d %H:%M:%S',x)
nf.write(','.join( [ ymdhms , items[1] , long2ip(long(items[2])) ]) + '\n')
except Exception as e:
print e
print line
if (__name__ == '__main__'):
ip2region()