Jan-14-2018, 12:16 AM
#sqlnuff0.py import sqlite3, time, datetime, random words = ['foo','bar','moo','soo','noo','boo','fee'] conn = sqlite3.connect('yes.db') c = conn.cursor() def create_db(): c.execute('CREATE TABLE IF NOT EXISTS foobar(unix REAL, datestamp TEXT, value TEXT)') def data_entry(): c.execute("INSERT INTO foobar VALUES(12345,'1-2-2',words)")#my list here should be enough... conn.commit() c.close() conn.close() def dynamic_data_entry(): unix = time.time() date = str(datetime.datetime.fromtimestamp(unix).strftime('%m-%d')) value = random.randrange(0,len(words)) c.execute("INSERT INTO foobar (unix,datestamp,value) VALUES(?,?,?)", (unix, date, value)) conn.commit() create_db() for i in range(10): dynamic_data_entry() c.close() conn.close()But I am unable to insert my list into the values column...I am getting a range of numbers, possibly the index values of my elements?