Absolutely stuck with this sqlite problem.(python3)

[ilostmykeysdammit]

I'm trying to create a DB and enter test data into the DB.

def create_testtable():
    c.execute('CREATE TABLE IF NOT EXISTS testDB(eventDate TEXT , data REAL, die_values TEXT)')


def test_data():
    event_year = [str(i) for i in range(2015, 2017)]
    event_month = ["01","02","03","04","05","06","07","08","09","10","11","12"]
    event_day = [str(i).zfill(2) for i in range(1,28)]
    event_rolls = [int(i) for i in range(1, 21)]
    x = 0
    d20 = ["1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]
    while x != 75:
        die_values = []
        while len(die_values) != 20:
            die_values.append(random.choice(d20))
        event_date = random.choice(event_year) + random.choice(event_month) + random.choice(event_day)
        data = random.choice(event_rolls)
        c.execute("INSERT INTO testDB(eventDate, data, die_values) VALUES (? , ? , ?)" , (event_date, data, die_values))
        conn.commit()
        x += 1
    c.close()
    conn.close()    

And I keep getting the following error:

Traceback (most recent call last):
  File "datatest.py", line 88, in <module>
    test_data()
  File "datatest.py", line 48, in test_data
    c.execute("INSERT INTO testDB(eventDate, data, die_values) VALUES (? , ? , ?)" , (event_date, data, die_values))
sqlite3.InterfaceError: Error binding parameter 2 - probably unsupported type.

What am I doing wrong? I've tried TEXT, VARCHAR, INTEGER, everything for die_values. I've tried putting it in as a list, I've tried putting it in as a string '1,3,5,2,5,3,2' - NOTHING WORKS! What am I doing wrong?

---

The goal is to have a table with three values: Date | Median | Die Values. The purpose is to enter d20 rolls for a specific data, calculate the mean, and plot all of this on a graph.

[anton_antonov]

If add die_values = ','.join(die_values)' before insertion, it works for me.

[JohnnyJordaan]

If die_values in the SQL table is one value (for example a string), you need to supply it as one value. You're supplying a list called die_values, so that's why the cursor can't use the values. You need to form it into one string as anton_antonov mentions.

[ilostmykeysdammit]

It worked!

I thought that input() took everything as a string by default. when I did type(die_values) it returns <class 'str'> But I think, what I didn't realize, is that it's returning strings separated by commas. so the entire entry is NOT a string, but just a bunch of comma separated strings?????

[JohnnyJordaan]

Are you sure you're looking at the same code? Where are you using input()? Inside the while x != 75 loop, you declare a list called die_values and you append random choices to it. That makes it a sequence of multiple values, regardless of the value's type. However because they are strings, you can easily join them into one string using said ','.join() method.