Deleting from a database...

[ibreeden]

The above code is literally my first attempt to learn how python works that isn't just a "copy someone else" type deal.

Well done Mort! You are doing fine.

To get you through the problem at hand, remove where you say IF NOT EXISTS. You will then get an empty table.

This is in the category: "Want to remove a stain from your shirt? Use scissors!". Most often people using a database want to keep their data.

The way to solve this is for every row to be inserted, do a lookup to check if the row is already in the table. If it is: don't insert.
Professionally designed databases and the files providing data will have a primary key. This key will be indexed so the lookup can be very quick. But if you don't have a primary key then you need to check on all columns. Like this:

...
countrecs = "SELECT COUNT(*) FROM TokenTable WHERE ad1 = ? AND ad2 = ? AND ad3 = ?"
insertrecs = "INSERT INTO TokenTable VALUES (?,?,?)"

with open("LE.csv", "r") as file:
    no_records = 0
    for rawrow in file:
        row = rawrow.strip().split(",")
        # number already in database should be 0 or 1.
        nr_already = c.execute(countrecs, row).fetchone()[0]
        # if no rows already in database, insert the row
        if nr_already == 0:
            c.execute(insertrecs, row)
            conn.commit()
            no_records += 1
            print(f"Inserted: {row}")
        else:
            print(f"Already in database: {row}")

c.close()
conn.close()