Apologies: I have to amend again my suggestion. The authorizer has to be attached to a "real" database that already has a definition for the involved tables, if you need to know about insertions, deletions, and updates.
Gwendal > Le 29 oct. 2017 à 15:37, Gwendal Roué <gwendal.r...@gmail.com> a écrit : > > I should have added that you can check for inserted/deleted/updated tables by > looking for more codes than SQLITE_CREATE_TABLE. The provided sample code > only checks for table creation. > > Gwendal > >> Le 29 oct. 2017 à 15:28, Gwendal Roué <gwendal.r...@gmail.com >> <mailto:gwendal.r...@gmail.com>> a écrit : >> >> Yes, there is a general way. >> >> To know if a statement creates a database table, >> >> 1. Open a private, in-memory, database connection >> 2. Register an authorizer with sqlite3_set_authorizer >> (https://sqlite.org/c3ref/set_authorizer.html >> <https://sqlite.org/c3ref/set_authorizer.html>). >> 3. Compile the statement with sqlite3_prepare_v2 >> (https://sqlite.org/c3ref/prepare.html >> <https://sqlite.org/c3ref/prepare.html>) >> 4. In the registered authorizer callback, check for SQLITE_CREATE_TABLE >> (https://www.sqlite.org/c3ref/c_alter_table.html >> <https://www.sqlite.org/c3ref/c_alter_table.html>). >> >> Find attached a C program that demonstrates the technique. >> >> $ cc -lsqlite3 created_table.c && ./a.out >> Create table foo: CREATE TABLE foo(a, b) >> No table creation: INSERT INTO bar (a) VALUES (1) >> No table creation: Some invalid SQL >> >> <created_table.c> >> >> Gwendal Roué >> >>> Le 28 oct. 2017 à 14:44, Shane Dev <devshan...@gmail.com >>> <mailto:devshan...@gmail.com>> a écrit : >>> >>> Hello, >>> >>> Let's say I have a table containing of SQL statements, for example >>> >>> sqlite> .schema sql >>> CREATE TABLE sql(statement text); >>> >>> sqlite> select * from sql; >>> insert into tab1 select 'example text'; >>> update tab2 set col2 = 123 where col2 = 1; >>> delete from tab3 where col1 = 2; >>> >>> For the first row, I could build a query using instr and substr functions >>> to extract the first word after INSERT INTO. That would work for most >>> simple INSERT statements, but it would fail if (for example) the statement >>> was prepended with a WITH clause which happened to contain the text "INSERT >>> INTO". Is there more generalized way of achieving this? >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@mailinglists.sqlite.org >>> <mailto:sqlite-users@mailinglists.sqlite.org> >>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >>> <http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users> >> > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
