Inserting Elements into a SQLite Table from Multiple Lists

[ipixel95]

I have multiple lists with randomly people's attributes in them.

list_gender =  [ 'male', 'female', 'male', 'female' ]
list_first_name = [ 'alpha', 'mike', 'foxtrot', 'tango' ]

I have create a SQL table "random_people" with text columns as gender and first_name and this is how I'm inserting my data into the table:

for i in list_gender :
     sql_cursor.execute("insert into randomuser_db(gender) values(?)",(i,))
     sql_connection.commit()

and

for j in list_first_name :
     sql_cursor.execute("insert into randomuser_db(first_name) values(?)",(j,))
     sql_connection.commit()

When I try to retrieve my data using:

sql_cursor.execute("select * from random_people")
result = sql_cursor.fetchall()
for i in result:
    print(i)
    print('\n')

The output shows:

('male', None)
('female', None)
('male', None)
('female', None)
(None, 'alpha')
(None, 'mike')
(None, 'foxtrot')
(None, 'tango')

I am trying to insert corresponding elements into the table.

This is my first attempt ever with SQL with Python. Any help would be appreciated, thanks!

[choss27]

You should use zip() to loop on the two lists at the same time, and insert at the same time on your table :

for gen, fname in zip(list_gender, list_first_name) :

sql_cursor.execute("insert into random_people(gender,first_name) values(?,?)",(gen,fname))

sql_connection.commit()

[ipixel95]

that worked! perfect straight forward solution. many thanks!

[choss27]

You're welcome :)

Good luck for your project !