def download():
from os import stat
from os.path import join
try:
if stat(join("applications", request.application, "databases", "geoip.db"))[6] <> 0L: redirect(URL(r=request, f="index"))
except: pass
from cStringIO import StringIO
from urllib import urlopen
from zipfile import ZipFile
from sqlite3 import connect
connection = connect(join("applications", request.application, "databases", "geoip.db"))
cursor = connection.cursor()
cursor.execute("create table geoip (id integer primary key autoincrement, begin_ip char(15), end_ip char(15), begin_num integer, end_num integer, code char(2), name char(32))")
data = ZipFile(StringIO(urlopen("http://www.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip").read()))
data = StringIO(data.read(data.namelist()[0]))
while True:
chunk = data.readline()
if not chunk: break
cursor.execute("insert into geoip (begin_ip, end_ip, begin_num, end_num, code, name) values (" + chunk + ")")
connection.commit()
cursor.close()
return dict()
def download():
from os import stat
from os.path import join
try:
if stat(
join("applications", request.application, "databases",
"geoip.db"))[6] <> 0L:
redirect(URL(r=request, f="index"))
except:
pass
from cStringIO import StringIO
from urllib import urlopen
from zipfile import ZipFile
from sqlite3 import connect
connection = connect(
join("applications", request.application, "databases", "geoip.db"))
cursor = connection.cursor()
cursor.execute(
"create table geoip (id integer primary key autoincrement, begin_ip char(15), end_ip char(15), begin_num integer, end_num integer, code char(2), name char(32))"
)
data = ZipFile(
StringIO(
urlopen(
"http://www.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip"
).read()))
data = StringIO(data.read(data.namelist()[0]))
while True:
chunk = data.readline()
if not chunk: break
cursor.execute(
"insert into geoip (begin_ip, end_ip, begin_num, end_num, code, name) values ("
+ chunk + ")")
connection.commit()
cursor.close()
return dict()
