[RESOLVED] how to get back the name of sqlite database file ?

madrazel

$pdo = new PDO('sqlite:mydatabase.DB3');

and now I want to get this "mydatabase.DB3" to check if I'm writing into correct DB

something like: $pdo->getDatabaseFilename();

laserlight

I do not think it is possible, but why do you need "to check if I'm writing into correct DB"? You are likely to have only one database connection, and if you need to access another SQLite database, you can just attach it to the current connection.

madrazel

Maybe as a query to the database itself ?

laserlight

You still have not explained why you think this really is necessary.

What you can do is to derive from the PDO class and add this desired method, but frankly, I think you are trying to do something that you should not be doing.
EDIT:
Actually, it is not quite so simple to implement this because of hard and soft linking of files, and then even without such aliasing, the same file path might be expressed in different ways, so a naive comparison of file paths could result in false negatives.

madrazel

I'm passing $pdo object to a function using global keyword, but in the function I need to check if passed object refers to a correct DB

--edit--

The solution is to query the database itself:

PRAGMA database_list

laserlight

madrazel wrote:
I'm passing $pdo object to a function using global keyword, but in the function I need to check if passed object refers to a correct DB

You don't need to "need to check if passed object refers to a correct DB" file path. You might want to do things like check if an expected table exists with the required columns (use the table_info pragma), but that has nothing to do with the database file path.

EDIT:

madrazel wrote:
The solution is to query the database itself:

PRAGMA database_list

No, that will give you one row for the main database, possibly another row for a temporary database, and then more rows for attached databases, if any. The main database will be named main, so it will not provide you with any information concerning the database file. Typically, you would use that pragma to find out what are the attached databases.

EDIT #2:
Oh wait, looks like I am wrong: it is not documented, but the file name is provided, so yes, that will be a solution, if you can get around the problems with file paths that I described earlier.

But, the fact remains: using the database file path is not the right thing to do. What you should be doing, if you really think it necessary, is to check for the table.