Reduced invective

[BBands]

My fat-fingered alter ego typed
    delete from iv where date > '2006-01-01';
instead of
    delete from iv where date > '2006-12-01';
leaving me with 50 tables to reload. :(

estimated time to fix > several hours
estimated invective dispensed during fix = classified

Python to the rescue!

import os
import MySQLdb

files = os.listdir("d:\\hedge\\old data\\")

conn = MySQLdb.connect(host = 'host',
                       user = 'user',
                       passwd = 'pass',
                       db = 'db')
curs = conn.cursor()

for line in files:
    if line[-4:] == "2006":
        SQL = "LOAD DATA "
        SQL += "INFILE 'd:/hedge/old data/" + line
        SQL += "' INTO TABLE iv "
        SQL += "FIELDS TERMINATED BY ',' "
        SQL += "(symbol, date, iv, pv, cv);"
        curs.execute(SQL)

time to execute = 5 mins
invective dispensed while executing = 0

A hearty thank you and Happy Holidays to all in the Python community.

     jab