sqlite3 get the connected database url

[midnio]

BPO	35272
Nosy	@berkerpeksag, @DamlaAltun, @midnio

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = None
closed_at = <Date 2019-03-31.15:05:43.902>
created_at = <Date 2018-11-18.13:36:06.772>
labels = ['type-feature', '3.8']
title = 'sqlite3 get the connected database url'
updated_at = <Date 2019-03-31.15:05:43.902>
user = 'https://github.com/midnio'

bugs.python.org fields:

activity = <Date 2019-03-31.15:05:43.902>
actor = 'berker.peksag'
assignee = 'none'
closed = True
closed_date = <Date 2019-03-31.15:05:43.902>
closer = 'berker.peksag'
components = []
creation = <Date 2018-11-18.13:36:06.772>
creator = 'midnio'
dependencies = []
files = []
hgrepos = []
issue_num = 35272
keywords = []
message_count = 4.0
messages = ['330047', '330048', '330049', '330050']
nosy_count = 4.0
nosy_names = ['ghaering', 'berker.peksag', 'DamlaAltun', 'midnio']
pr_nums = []
priority = 'normal'
resolution = 'rejected'
stage = 'resolved'
status = 'closed'
superseder = None
type = 'enhancement'
url = 'https://bugs.python.org/issue35272'
versions = ['Python 3.8']

[midnio]

A feature for to get the connected database path or URL from connection object (sqlite3.Connection).

[DamlaAltun]

Yeah, that would be great enhancement

[berkerpeksag]

Just to be sure, what do you want to do is

    import sqlite3

    conn = sqlite3.connect("foo.db")

assert conn.database_path == "foo.db"

right?

I don't think that's something worth to expose in the Connection object. What's your use case?

[midnio]

The use case could be

• Using it to check if you're connected to
  correct database (as you know the mutability could change the connection)

• Getting the name, helping the developers while debugging.

• No more reasons :P