def load_US_tax_table():
""" Load a simple sales tax table for the US """
from product.models import TaxClass
from tax.modules.area.models import TaxRate
from l10n.models import AdminArea, Country
us = Country.objects.get(iso2_code="US")
defaultTax, created = TaxClass.objects.get_or_create(description="Default",
title="Default")
if created:
defaultTax.save()
dataFile = "tax-table.csv"
dataDir = os.path.join(settings.DIRNAME, "tax/data")
reader = csv.reader(open(os.path.join(dataDir, dataFile), "rb"))
reader.next() #Skip the header row
for row in reader:
state = AdminArea.objects.get(country=us, abbrev=row[0])
stateTax = TaxRate(taxClass=defaultTax,
taxZone=state,
percentage=row[1])
stateTax.save()
