#import cs50
#import csv, argv

#online edit
#import cs50
#added
#from cs50 import SQL
import cs50
import csv
from sys import argv

# must remember to check command line arguements with argv

#open("students.db","w").close()

studb = cs50.SQL("sqlite:///students.db")
#studb = SQL("sqlite:///students.db") # you don't need cs50 cause you've imported it?
with open("characters.csv", "r") as students:
#with open(argv[1], "r") as students: # name 'argv' is not defined
    #reader = csv.DictReader(students, delimiter = ",")
    reader = csv.DictReader(students, delimiter = ",")
    #forsplit = ""
    nmesplt = ""
    frstnme = ""
    mdlnme = ""
    lastnme = ""
    #id = 0
    for row in reader:
        index = 0
        nmesplt = row['name'].split(" ")

        if len(nmesplt) == 3:
            frstnme = nmesplt[0]
            mdlenme = nmesplt[1]
            lastnme = nmesplt[2]

            #id += 1

            #studb.execute("INSERT INTO students(id, first, middle, last, house, birth) VALUES(?, ?, ?, ?, ?, ?)", id, frstnme, mdlenme, lastnme, row['house'], row['birth'])
            studb.execute("INSERT INTO students(first, middle, last, house, birth) VALUES(?, ?, ?, ?, ?)", frstnme, mdlenme, lastnme, row['house'], row['birth'])
        if len(nmesplt) == 2:
            frstnme = nmesplt[0]
            mdlenme = ""
            lastnme = nmesplt[1]

            #id += 1
            #studb.execute("INSERT INTO students(id, first, middle, last, house, birth) VALUES(?, ?, ?, ?, ?, ?)", id, frstnme, mdlenme, lastnme, row['house'], row['birth'])
            studb.execute("INSERT INTO students(first, middle, last, house, birth) VALUES(?, ?, ?, ?, ?)", frstnme, mdlenme, lastnme, row['house'], int(row['birth']))

        index += 1

        #studb.execute("INSERT INTO students(id, first, middle, last, house, birth) VALUES(?, ?, ?, ?, ?, ?)", id, frstnme, mdlenme, lastnme, row['house'], row['birth'])