On Sat, 30 May 2009 17:50:36 +0530, <souvik.da...@wipro.com>
wrote:
>
>Yes , I understand that. Infact I was doing that
>through a script during system startup. I wanted
>to know whether SQLite provides any API to do the same.
No, it doesn't. You could write it yourself:
foreach $name in \
sql(SELECT name FROM sqlite_master WHERE type='table';)
do
sql(DELETE FROM $name;)
done
If you use a startup script, there is no need for the C API,
you might as well do something like:
sqlite3 dbfile .schema|sqlite3 dbfile.new
or (if the database is not overly large)
sqlite3 dbfile .dump|grep - v INSERT|sqlite3 dbfile.new
You may want to add a few initialization PRAGMA's to the
pipe.
>Thanks and Regards,
>Souvik
>-----Original Message-----
>From: sqlite-users-boun...@sqlite.org on behalf of John Stanton
>Sent: Sat 5/30/2009 5:30 PM
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] Deleting database content : SQLite3 API
>
>An Sqlite database is just a file. Delete the file when you start
>your program and when you open the database Sqlite will create a fresh
>dne, a very low overhead process..
>.
>souvik.da...@wipro.com wrote:
>> Hello,
>>
>> Please let me know if we have an API in SQLite3 which allows me to
>> retain the database but delete it's content at runtime. The problem I am
>> facing is that : Every time I restart my system , I need to create the
>> database. If the database exits already it's contents need to be
>> deleted. The issue is that the contents of the database varies during
>> one power ON - Power OFF cycle . As a result , after finding that the
>> database already exits at the system startup, I cannot just drop the
>> tables. ( As the table which are present in the existing data base is
>> not known. )
>>
>> I am using sqlite3wrapped C++ library APIs.
>>
>> Thanks and Regards,
>> Souvik
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
