Hi,
I have a statement to insert a few entries in a table of the plex database. Iam getting no errror but they make no entries. Please help me.
dBConn = sqlite3.connect(database)
message = ‘nope’
try:
dBConn.cursor().execute(
'INSERT INTO ’ + name.lower() + ’ (id) SELECT id FROM metadata_items WHERE metadata_type IN (SELECT section_type FROM library_sections) AND metadata_items.id NOT IN (SELECT id FROM ’ + name.lower() + ‘)’)
message = ‘refresh success’
except:
message = ‘error’
pass
oc = ObjectContainer(header="Empty", message=message)
dBConn.close()
dBConn = None
return oc