import_db

import_db.py

import MySQLdb, re

conn = MySQLdb.connect(host = "localhost", user = "testuser", passwd = "testpass", db = "test")
cursor = db.cursor()

datafile = open('taxes.txt')
line = ''

while(line = datafile.readline()):
  fields = re.split(r'\|+', line)
  cursor.execute("insert into rates (Post_Office,Zip_Code,County,Rate) values('%s','%s','%s','%s');" % (fields[0], fields[1], fields[2], fields[3]))

cursor.close()
conn.close()