InventoryImportPython

import csv
import MySQLdb
import datetime

mydb = MySQLdb.connect(
    host="localhost",
    user="root",
    passwd="somepassword",
    db="autoinventory"
)

cursor = mydb.cursor()
rowOne = 0

csv_data = csv.reader(file("autoinventory.csv"))
for row in csv_data:
    if rowOne == 1:
        carDataSql = (
            "INSERT INTO CarDetail ( "
                "  StockNumber"
                ", Make"
                ", Model"
                ", Year"
                ", VIN"
                ", Price"
                ", DateAquired"
            " ) "
            "VALUES( %s, %s, %s, %s, %s, %s, %s )"
        )

            carData = (
                  row[0]
                , row[1]
                , row[2]
                , int(row[3])
                , row[4]
                , float(row[5])
                , datetime.datetime.strptime(row[6], "%b %d %Y %I:%M%p").date()
            )

            cursor.execute( carDataSql, carData )

            carOptions = row[7].split(",")
            carImages = row[8].split(";")

            for option in carOptions:
                optionSql = (
                        "INSERT INTO CarOption ( StockNumber, OptionText ) "
                        "VALUES ( %s, %s )"
                )

                optionData = ( row[0], option )
                cursor.execute( optionSql, optionData )

            for image in carImages:
                imageSql = (
                        "INSERT INTO CarImage ( StockNumber, ImageURL ) "
                        "VALUES ( %s, %s )"
                )

                imageData = ( row[0], image )
                cursor.execute( imageSql, imageData )

    rowOne = 1
mydb.commit()
cursor.close()