Is it possible to desactivate the audit for some SQL statement called in python script.
I use some script to import file in a database in BLOB with code like in the ignition doc :
This code would prompt the user to choose a file. If the user chooses a file, it would then read that file and upload it to a database table called Files into a BLOB column called file_data.
path = system.file.openFile()
if path != None:
bytes = system.file.readFileAsBytes(filename)
system.db.runPrepUpdate("INSERT INTO Files (file_data) VALUES (?)", (bytes))
The binarie code of the file is logged in the audit database and trigger an error because the action code is a varchar(255) in the audit table. I don’t want to log these kind of sql request. Is there a way to desactivate the audit for these request ???