afaik there is no such api.
You need to periodically check if something changed.
Run
pragma schema_version;
to get current schema version.
If it changes then run
select name from sqlite_master where type='table' and name not
like 'sqlite_%';
to get the list of table names and compare this list with one you've
got previously.
2018-06-19 20:42 GMT+02:00, Igor Korot <ikoro...@gmail.com>:
> Hi, Wout,
>
> On Tue, Jun 19, 2018 at 1:31 PM, Wout Mertens <wout.mert...@gmail.com>
> wrote:
>> you can query the table with
>> https://www.sqlite.org/pragma.html#pragma_table_info
>
> Let me give you a scenario:
>
> 1. My application connects to the database and performs some
> operations (using C API).
> 2. During the application run, someone started sqlite3, connects to
> the database and creates a
> brand new table.
> 3. My application will need to pick up the newly created table and continue.
>
> Is it easily possible?
>
> There is a sqlite3_*_hook() family of functions, but it looks like
> they won't help with sqlite_master.
>
> Is there a different way?
>
> Thank you.
>
>>
>> On Tue, Jun 19, 2018, 8:26 PM Igor Korot <ikoro...@gmail.com> wrote:
>>
>>> Hi,
>>> Is there a C API which checks if the new table has been created?
>>>
>>> Thank you.
>>> _______________________________________________
>>> 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
> _______________________________________________
> 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
