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