[odb-users] Opening an already existing database (SQLite) and appending

[Boris Kolpackov]

Hi Thomas,

Szumowski, Thomas <thomas.szumowski at lmco.com> writes:

> But when I look at xyz.sql again, it only shows Jane, and not both 
> John and Jane.

Ok, I've figured it out: the create_database() function re-creates
the database schema every time it is called, regardless of whether
the database already exists or not. Part of this process is dropping
all the existing tables which also deleted all the entries.

The 'schema/embedded' example has a piece of code that shows how to
detect whether the schema already exists.

Boris