vendredi 4 mars 2016

How can I prevent users from updating records in SQLite?

I am using Python and sqlite3 to create and add records to a table in a database. Currently I can add, delete and update a record.

import sqlite3

sqlite_filename = "...."
conn = sqlite3.connect(sqlite_filename)
cursor = conn.cursor()

# Create table
cursor.execute("""CREATE TABLE IF NOT EXISTS Test_table(ID INTEGER PRIMARY KEY AUTOINCREMENT, Date TEXT, Time TEXT)""")
conn.commit()

My aim is after I update a record to somehow prevent this specific record from being updated and/or deleted.

Aucun commentaire:

Enregistrer un commentaire