SQLite database not updating with using Python

Question

I think I'm updating my database wrong? It's not giving me a error, so it's probably something that I forgot to do or didn't notice. Anyways, I'm super stumped and the tutorial I was watching didn't have this problem.

Thanks for all the help in advance!

@bot.command(aliases = ['gen' , 'newacc'])
async def open_account(tendant):

    db = sqlite3.connect('leveling.sqlite')
    cursor = db.cursor()

    sqlupdate = (f'INSERT INTO leveling(user_id,xp, local_xp) VALUES(?,?,?)')

    val = (tendant.author.id, 0, 0)

    result = cursor.fetchall()
    await tendant.channel.send(result)
    cursor.execute(sqlupdate, val)
    db.close()

bot.run(token)

I think, you did not commit the changes. Try: db.commit() Add this above the db.close() — Bhavyadeep Yadav
– Bhavyadeep Yadav, Commented May 5, 2021 at 3:52

Tomalak · Accepted Answer · 2021-05-05 07:49:32Z

4

You need to commit your changes:

async def open_account(tendant):
    db = sqlite3.connect('leveling.sqlite')
    cursor = db.cursor()

    val = (tendant.author.id, 0, 0)
    cursor.execute('INSERT INTO leveling (user_id, xp, local_xp) VALUES(?, ?, ?)', val)
    
    # Save (commit) the changes
    db.commit()
    
    # We can close the connection if we are done with it.
    # Just be sure any changes have been committed or they will be lost.
    db.close()

See: https://docs.python.org/3/library/sqlite3.html

edited May 5, 2021 at 7:49

Tomalak

340k68 gold badges547 silver badges635 bronze badges

answered May 5, 2021 at 5:47

user15773347

Sign up to request clarification or add additional context in comments.

1 Comment

Sora Over a year ago

Hey man, thanks! I tried to find docs on this but for some reason I haven't been able to find them. So thank you for the answer and thanks for the link to the docs!

Collectives™ on Stack Overflow

SQLite database not updating with using Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related