Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Jay A. Kreibich
On Tue, Jun 26, 2012 at 02:52:43PM +0200, Ralf Junker scratched on the wall: > On 26.06.2012 14:33, Vivien Malerba wrote: > > > The code is some SQL entered by the user, I have no control over it. There > > is effectively the possibility to parse the SQL entered, detect the CREATE > > table

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Vivien Malerba
On 26 June 2012 15:31, Black, Michael (IS) wrote: > If you have sqlite3.c in your project you can just add your own hook. > > > > Take a look at sqlite3TwoPartName if you want to see if before it's > created. > > > > Or look at sqlite3StartTable (end of the function) if

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Vivien Malerba
On 26 June 2012 15:00, kyan wrote: > > Is there any possibility to be notified when a table is created (when a > > "CREATE TABLE XXX" is executed)? > > You could try installing a profile callback using sqlite3_profile() > (see http://www.sqlite.org/c3ref/profile.html). Of

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Vivien Malerba
On 26 June 2012 14:55, Simon Slavin wrote: > > On 26 Jun 2012, at 1:33pm, Vivien Malerba wrote: > > > The code is some SQL entered by the user, I have no control over it. > There > > is effectively the possibility to parse the SQL entered, detect the >

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Black, Michael (IS)
: Tuesday, June 26, 2012 7:33 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Detecting when a table is created On 26 June 2012 14:21, Igor Tandetnik <itandet...@mvps.org> wrote: > Vivien Malerba <vmale...@gmail.com> wrote: > > Is there any possibilit

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread kyan
> Is there any possibility to be notified when a table is created (when a > "CREATE TABLE XXX" is executed)? You could try installing a profile callback using sqlite3_profile() (see http://www.sqlite.org/c3ref/profile.html). Of course this callback will be called for any kind of SQL or DDL

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Simon Slavin
On 26 Jun 2012, at 1:33pm, Vivien Malerba wrote: > The code is some SQL entered by the user, I have no control over it. There > is effectively the possibility to parse the SQL entered, detect the CREATE > table statement and act accordingly, but I would like to see if SQLite

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Ralf Junker
On 26.06.2012 14:33, Vivien Malerba wrote: > The code is some SQL entered by the user, I have no control over it. There > is effectively the possibility to parse the SQL entered, detect the CREATE > table statement and act accordingly, but I would like to see if SQLite has > some kind of builtin

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Vivien Malerba
On 26 June 2012 14:21, Igor Tandetnik wrote: > Vivien Malerba wrote: > > Is there any possibility to be notified when a table is created (when a > > "CREATE TABLE XXX" is executed)? > > How is it executed? Isn't it your program that executes the

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Igor Tandetnik
Vivien Malerba wrote: > Is there any possibility to be notified when a table is created (when a > "CREATE TABLE XXX" is executed)? How is it executed? Isn't it your program that executes the statement? How come you don't know when that happens? -- Igor Tandetnik

[sqlite] Detecting when a table is created

2012-06-26 Thread Vivien Malerba
Hi! Is there any possibility to be notified when a table is created (when a "CREATE TABLE XXX" is executed)? The context here is that I have an SQLite connection with only virtual tables and when the user manually creates a table, the table is created either in memory or in the temporary file