How to protect a table from creating duplicates?

Question

Python

With this function I enter data into a table

def init_user_db(con, users):
    cursorObj = con.cursor()
    
    for x in users:
        limits_values = (x, 0)
        cursorObj.execute('INSERT INTO limits(id, count) VALUES(?, ?) ON CONFLICT DO NOTHING', limits_values)
    
    con.commit()

Through this function I look up the values

def sql_counts_checker(con, message):
    cursorObj = con.cursor()    
    cursorObj.execute(f'SELECT count FROM limits WHERE id = {message.chat.id}')
    
    rows = cursorObj.fetchall()
    print(rows)
    count = rows[0][0]

    con.commit()

    return count

When I execute the function init_user_dbseveral times, then in the output ( print(rows)) I will get duplicates , [(2,), (0,), (0,), (0,), (0,), (0,), (0,)]although I indicated ON CONFLICT DO NOTHINGwhy duplicates are created anyway? How to fix it (with code examples please)

Answer 1

so there is no conflict)) you did not specify unique

Answer 2

https://www.sqlite.org/lang_UPSERT.html