Skip to content

Instantly share code, notes, and snippets.

@coleifer
Last active January 23, 2018 23:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save coleifer/864de812c1564668c5762c28e47a3ffc to your computer and use it in GitHub Desktop.
Save coleifer/864de812c1564668c5762c28e47a3ffc to your computer and use it in GitHub Desktop.
SQLite authorizer action constants and callback parameters
# Return values
SQLITE_OK = 0
SQLITE_DENY = 1
SQLITE_IGNORE = 2
# Actions and args
SQLITE_CREATE_INDEX = 1 # Index Name Table Name
SQLITE_CREATE_TABLE = 2 # Table Name NULL
SQLITE_CREATE_TEMP_INDEX = 3 # Index Name Table Name
SQLITE_CREATE_TEMP_TABLE = 4 # Table Name NULL
SQLITE_CREATE_TEMP_TRIGGER = 5 # Trigger Name Table Name
SQLITE_CREATE_TEMP_VIEW = 6 # View Name NULL
SQLITE_CREATE_TRIGGER = 7 # Trigger Name Table Name
SQLITE_CREATE_VIEW = 8 # View Name NULL
SQLITE_DELETE = 9 # Table Name NULL
SQLITE_DROP_INDEX = 10 # Index Name Table Name
SQLITE_DROP_TABLE = 11 # Table Name NULL
SQLITE_DROP_TEMP_INDEX = 12 # Index Name Table Name
SQLITE_DROP_TEMP_TABLE = 13 # Table Name NULL
SQLITE_DROP_TEMP_TRIGGER = 14 # Trigger Name Table Name
SQLITE_DROP_TEMP_VIEW = 15 # View Name NULL
SQLITE_DROP_TRIGGER = 16 # Trigger Name Table Name
SQLITE_DROP_VIEW = 17 # View Name NULL
SQLITE_INSERT = 18 # Table Name NULL
SQLITE_PRAGMA = 19 # Pragma Name 1st arg or NULL
SQLITE_READ = 20 # Table Name Column Name
SQLITE_SELECT = 21 # NULL NULL
SQLITE_TRANSACTION = 22 # Operation NULL
SQLITE_UPDATE = 23 # Table Name Column Name
SQLITE_ATTACH = 24 # Filename NULL
SQLITE_DETACH = 25 # Database Name NULL
SQLITE_ALTER_TABLE = 26 # Database Name Table Name
SQLITE_REINDEX = 27 # Index Name NULL
SQLITE_ANALYZE = 28 # Table Name NULL
SQLITE_CREATE_VTABLE = 29 # Table Name Module Name
SQLITE_DROP_VTABLE = 30 # Table Name Module Name
SQLITE_FUNCTION = 31 # NULL Function Name
SQLITE_SAVEPOINT = 32 # Operation Savepoint Name
SQLITE_RECURSIVE = 33 # NULL NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment