import csv
import sys
import sqlite3 as sql3

csvReader = csv.reader(open(sys.argv[1],'rb'))

con = sql3.connect('stocksymbols.db')

with con:
    cur = con.cursor()
    try:
        cur.execute("CREATE TABLE Symbols(Symbol TEXT Primary Key,Naming TEXT,LNaming TEXT)")
    except Exception:
        print "Error Create Table!"
        pass

    for row in csvReader:
        symbol = row[0].replace('"','')
        naming = row[1].replace('"','')
        lnaming = row[1].replace('"','').lower()
        try:
            cur.execute("INSERT INTO Symbols VALUES ('"+symbol+"','"+naming+"','"+lnaming+"')")
        except Exception:
            print "Errore insert value" + symbol
        pass
con.close()