How to get a SQLite database name in python

Question

Is there a way I can get a SQLite database name in Python.

I am using the following code to get the database name:

con=sqlite3.connect(":memory:")
cursor = con.cursor()
cursor.execute("PRAGMA database_list;")
curr_table = cursor.fetchall()

But the output I get is:

[(0, u'main', u'')]

When I should be getting something like

[(0,u'main',u'/Users/testdb.db'),                           
(2,u'test',u'/Users/testdb.db')]

what? ... I dont understand the question ... sqlite has a filename(or in :memory) as the database name ... do you mean get the table names? — Joran Beasley
– Joran Beasley, Commented Jun 30, 2016 at 23:05
I used this code con=sqlite3.connect(":memory:") cursor = con.cursor() cursor.execute("PRAGMA database_list;") But it's not listing the correct databases — anonymous
– anonymous, Commented Jun 30, 2016 at 23:07
what do you mean? what does it list and what do you expect? ... this is not a reproduceable example as it stands ... — Joran Beasley
– Joran Beasley, Commented Jun 30, 2016 at 23:10
Those databases are not associated with your connection that is using :memory: so you won't see them. Read the docs: sqlite.org/pragma.html#pragma_database_list — Nick
– Nick, Commented Jun 30, 2016 at 23:19

Nick · Accepted Answer · 2016-06-30 23:29:54Z

3

You should be connecting to the actual file - otherwise you cannot view the databases within it.

So, you just need to change your code to this:

con=sqlite3.connect('/Users/testdb.db')
cursor = con.cursor()
cursor.execute("PRAGMA database_list;")
curr_table = cursor.fetchall()

answered Jun 30, 2016 at 23:29

Nick

7,4912 gold badges25 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

anonymous Over a year ago

But this won't give all the databases it's just giving me the output as:[(0, u'main', u'/Users/testdb.db')]

Nick Over a year ago

@anonymous - You can only see the databases within the file that you are connected to. SQLite is a file-based database, so you aren't connecting to a server at all. Is your file testdb.db an actual SQLite database file?

Nick Over a year ago

If you only see one database, that is because there is only one.

Collectives™ on Stack Overflow

How to get a SQLite database name in python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related