Shulou(Shulou.com)06/01 Report--

This article is mainly related to the registration authorization callback function: for more information on how to call sqlite3_set_authorizer, please refer to other chapters!

Extracted from: https://www.sqlite.org/c3ref/c_alter_table.html

/ * 3rd * 4th * /

# define SQLITE_CREATE_INDEX 1 / * Index Name Table Name * /

# define SQLITE_CREATE_TABLE 2 / * Table Name NULL * /

# define SQLITE_CREATE_TEMP_INDEX 3 / * Index Name Table Name * /

# define SQLITE_CREATE_TEMP_TABLE 4 / * Table Name NULL * /

# define SQLITE_CREATE_TEMP_TRIGGER 5 / * Trigger Name Table Name * /

# define SQLITE_CREATE_TEMP_VIEW 6 / * View Name NULL * /

# define SQLITE_CREATE_TRIGGER 7 / * Trigger Name Table Name * /

# define SQLITE_CREATE_VIEW 8 / * View Name NULL * /

# define SQLITE_DELETE 9 / * Table Name NULL * /

# define SQLITE_DROP_INDEX 10 / * Index Name Table Name * /

# define SQLITE_DROP_TABLE 11 / * Table Name NULL * /

# define SQLITE_DROP_TEMP_INDEX 12 / * Index Name Table Name * /

# define SQLITE_DROP_TEMP_TABLE 13 / * Table Name NULL * /

# define SQLITE_DROP_TEMP_TRIGGER 14 / * Trigger Name Table Name * /

# define SQLITE_DROP_TEMP_VIEW 15 / * View Name NULL * /

# define SQLITE_DROP_TRIGGER 16 / * Trigger Name Table Name * /

# define SQLITE_DROP_VIEW 17 / * View Name NULL * /

# define SQLITE_INSERT 18 / * Table Name NULL * /

# define SQLITE_PRAGMA 19 / * Pragma Name 1st arg or NULL * /

# define SQLITE_READ 20 / * Table Name Column Name * /

# define SQLITE_SELECT 21 / * NULL NULL * /

# define SQLITE_TRANSACTION 22 / * Operation NULL * /

# define SQLITE_UPDATE 23 / * Table Name Column Name * /

# define SQLITE_ATTACH 24 / * Filename NULL * /

# define SQLITE_DETACH 25 / * Database Name NULL * /

# define SQLITE_ALTER_TABLE 26 / * Database Name Table Name * /

# define SQLITE_REINDEX 27 / * Index Name NULL * /

# define SQLITE_ANALYZE 28 / * Table Name NULL * /

# define SQLITE_CREATE_VTABLE 29 / * Table Name ModuleName * /

# define SQLITE_DROP_VTABLE 30 / * Table Name ModuleName * /

# define SQLITE_FUNCTION 31 / * NULL Function Name * /

# define SQLITE_SAVEPOINT 32 / * Operation SavepointName * /

# define SQLITE_COPY 0 / * No longer used * /

# define SQLITE_RECURSIVE 33 / * NULL NULL * /

The sqlite3_set_authorizer interface registers a callback function that will be called to authorize the execution of the SQL statement. The second argument to the callback function is an integer that specifies which operations are authorized, and the action encoding (integer action codes) of these integers can be passed by the callback function.

These action number values specify which actions are allowed. Whether the third and fourth parameters are NULL, or other parameters, depends entirely on the setting of the second parameter, the fifth parameter is the name of the database (main,temp, or other) if applicable. The sixth parameter attempts to access the built-in trigger or view, of course, if NULL, indicates that the attempt comes from the most advanced SQL encoding (The 6th parameter to the authorizer callback is the nameof the inner-most trigger or view that is responsible for the access attempt orNULL if this access attempt is directly from top-level SQL code).

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.