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 Gwendal Roué > Le 28 oct. 2017 à 14:44, Shane Dev <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 > 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
