How can I insert array elements into SQLite table by index?

Question

Seems like array element index isn't a type that SQLite INSERT will allow.

contact[0] = raw_input("Last Name: ")
contact[1] = raw_input("First Name: ")
contact[2] = raw_input("Street Address: ")
contact[3] = raw_input("City: ")
contact[4] = raw_input("State: ")
contact[5] = raw_input("Zip Code: ")
contact[6] = raw_input("Phone: ")
contact[7] = raw_input("Email: ")

cur.execute("INSERT INTO Contacts VALUES(contact[0], contact[1], contact[2], contact[3], contact[4], contact[5], contact[6], contact[7])")

Is there a way to do this? Thanks!

alecxe · Accepted Answer · 2015-10-12 19:57:05Z

1

How about making it a bit cleaner:

labels = [
    "Last Name: ", 
    "First Name: ", 
    "Street Address: ", 
    "City: ", 
    "State: ",
    "Zip Code: ",
    "Phone: ",
    "Email: "
]
contact = [raw_input(label) for label in labels]
cur.execute("INSERT INTO Contacts VALUES(?, ?, ?, ?, ?, ?, ?, ?)", contact)

where ? are placeholders for query parameters.

answered Oct 12, 2015 at 19:57

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I insert array elements into SQLite table by index?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related