OLD | NEW |
| (Empty) |
1 /* | |
2 ** 2014-09-21 | |
3 ** | |
4 ** The author disclaims copyright to this source code. In place of | |
5 ** a legal notice, here is a blessing: | |
6 ** | |
7 ** May you do good and not evil. | |
8 ** May you find forgiveness for yourself and forgive others. | |
9 ** May you share freely, never taking more than you give. | |
10 ** | |
11 ****************************************************************************** | |
12 ** | |
13 ** This SQLite extension adds a debug "authorizer" callback to the database | |
14 ** connection. The callback merely writes the authorization request to | |
15 ** standard output and returns SQLITE_OK. | |
16 ** | |
17 ** This extension can be used (for example) in the command-line shell to | |
18 ** trace the operation of the authorizer. | |
19 */ | |
20 #include "sqlite3ext.h" | |
21 SQLITE_EXTENSION_INIT1 | |
22 #include <stdio.h> | |
23 | |
24 /* | |
25 ** Display the authorization request | |
26 */ | |
27 static int authCallback( | |
28 void *pClientData, | |
29 int op, | |
30 const char *z1, | |
31 const char *z2, | |
32 const char *z3, | |
33 const char *z4 | |
34 ){ | |
35 const char *zOp; | |
36 char zOpSpace[50]; | |
37 switch( op ){ | |
38 case SQLITE_CREATE_INDEX: zOp = "CREATE_INDEX"; break; | |
39 case SQLITE_CREATE_TABLE: zOp = "CREATE_TABLE"; break; | |
40 case SQLITE_CREATE_TEMP_INDEX: zOp = "CREATE_TEMP_INDEX"; break; | |
41 case SQLITE_CREATE_TEMP_TABLE: zOp = "CREATE_TEMP_TABLE"; break; | |
42 case SQLITE_CREATE_TEMP_TRIGGER: zOp = "CREATE_TEMP_TRIGGER"; break; | |
43 case SQLITE_CREATE_TEMP_VIEW: zOp = "CREATE_TEMP_VIEW"; break; | |
44 case SQLITE_CREATE_TRIGGER: zOp = "CREATE_TRIGGER"; break; | |
45 case SQLITE_CREATE_VIEW: zOp = "CREATE_VIEW"; break; | |
46 case SQLITE_DELETE: zOp = "DELETE"; break; | |
47 case SQLITE_DROP_INDEX: zOp = "DROP_INDEX"; break; | |
48 case SQLITE_DROP_TABLE: zOp = "DROP_TABLE"; break; | |
49 case SQLITE_DROP_TEMP_INDEX: zOp = "DROP_TEMP_INDEX"; break; | |
50 case SQLITE_DROP_TEMP_TABLE: zOp = "DROP_TEMP_TABLE"; break; | |
51 case SQLITE_DROP_TEMP_TRIGGER: zOp = "DROP_TEMP_TRIGGER"; break; | |
52 case SQLITE_DROP_TEMP_VIEW: zOp = "DROP_TEMP_VIEW"; break; | |
53 case SQLITE_DROP_TRIGGER: zOp = "DROP_TRIGGER"; break; | |
54 case SQLITE_DROP_VIEW: zOp = "DROP_VIEW"; break; | |
55 case SQLITE_INSERT: zOp = "INSERT"; break; | |
56 case SQLITE_PRAGMA: zOp = "PRAGMA"; break; | |
57 case SQLITE_READ: zOp = "READ"; break; | |
58 case SQLITE_SELECT: zOp = "SELECT"; break; | |
59 case SQLITE_TRANSACTION: zOp = "TRANSACTION"; break; | |
60 case SQLITE_UPDATE: zOp = "UPDATE"; break; | |
61 case SQLITE_ATTACH: zOp = "ATTACH"; break; | |
62 case SQLITE_DETACH: zOp = "DETACH"; break; | |
63 case SQLITE_ALTER_TABLE: zOp = "ALTER_TABLE"; break; | |
64 case SQLITE_REINDEX: zOp = "REINDEX"; break; | |
65 case SQLITE_ANALYZE: zOp = "ANALYZE"; break; | |
66 case SQLITE_CREATE_VTABLE: zOp = "CREATE_VTABLE"; break; | |
67 case SQLITE_DROP_VTABLE: zOp = "DROP_VTABLE"; break; | |
68 case SQLITE_FUNCTION: zOp = "FUNCTION"; break; | |
69 case SQLITE_SAVEPOINT: zOp = "SAVEPOINT"; break; | |
70 case SQLITE_COPY: zOp = "COPY"; break; | |
71 case SQLITE_RECURSIVE: zOp = "RECURSIVE"; break; | |
72 | |
73 | |
74 default: { | |
75 sqlite3_snprintf(sizeof(zOpSpace), zOpSpace, "%d", op); | |
76 zOp = zOpSpace; | |
77 break; | |
78 } | |
79 } | |
80 if( z1==0 ) z1 = "NULL"; | |
81 if( z2==0 ) z2 = "NULL"; | |
82 if( z3==0 ) z3 = "NULL"; | |
83 if( z4==0 ) z4 = "NULL"; | |
84 printf("AUTH: %s,%s,%s,%s,%s\n", zOp, z1, z2, z3, z4); | |
85 return SQLITE_OK; | |
86 } | |
87 | |
88 | |
89 | |
90 #ifdef _WIN32 | |
91 __declspec(dllexport) | |
92 #endif | |
93 int sqlite3_showauth_init( | |
94 sqlite3 *db, | |
95 char **pzErrMsg, | |
96 const sqlite3_api_routines *pApi | |
97 ){ | |
98 int rc = SQLITE_OK; | |
99 SQLITE_EXTENSION_INIT2(pApi); | |
100 (void)pzErrMsg; /* Unused parameter */ | |
101 rc = sqlite3_set_authorizer(db, authCallback, 0); | |
102 return rc; | |
103 } | |
OLD | NEW |