sqlite3_open - problems checking if a file is a sqlite3 database

Question

Hey,

I'm working with sqlite3 for the first time, and cannot get it to properly check a file before it opens it. So far, sqlite always returns OK on any file.

Also, the file name is a variable returned from the GTK file chooser. It returns an absolute path, I'm guessing this is not a problem.

Thanks for any help.

This is a snippet of the code:

int rc;
char *filename;
sqlite3 *db;

filename = gtk_file_chooser_get_filename(etc.);

if(SQLITE_OK == rc = sqlite3_open(filename,&db))
{  etc. }

Answer 1

Does your code compile?
I believe this is an error

if (SQLITE_OK == rc = sqlite3_open(filename,&db)) { /* ... */ }

it's the same as

if ((SQLITE_OK == rc) = sqlite3_open(filename,&db)) { /* ... */ }

and you cannot assign something (the result of the sqlite3_open() call) to (SQLITE_OK == rc).

Try this:

if ((rc = sqlite3_open(filename,&db)) == SQLITE_OK) { /* ... */ }
/* or, if you really want the constant on the left side of the comparison */
if (SQLITE_OK == (rc = sqlite3_open(filename,&db))) { /* ... */ }

Answer 2

sqlite3_open doesn't actually read the file until the first non-pragma statement is prepared.

sqlite3_open_v2 provides other options.