I begin a program by generating a URL object and passing it to create_engine. In a section of code far, far away I would like to find out what this engine is connected to, i.e. the connection URL.
Is there an easy way to do this? Using inspect I can only see how to get the driver type. I can understand if the password component of a connection string was no longer available, but I'm hoping everything else is still available.
Any ideas?
The Engine class has an attribute url. Although not documented, it is not 'underscore hidden' so I would assume safe to read.
__str__/__repr__ representation of engine.url will mask the password like 'postgresql://myuser:***@localhost/test'. If you need the full unmasked string without the password hidden, you should use engine.url.render_as_string(hide_password=False) (docs.sqlalchemy.org/en/20/core/…)Docs have improved over time: https://docs.sqlalchemy.org/en/20/core/engines.html#sqlalchemy.engine.URL
The database url (dialect+driver://username:password@host:port/database) can be viewed as a string via render_as_string(hide_password: bool = True), which also gives you control over whether or not to show the password in plain text. By default, the class' __repr__ calls return self.render_as_string(), so will mask out the password.
And if you wanted the dialect or its components, you can call get_dialect, get_backend_name i.e. the lhs of the +, and get_driver_name i.e. the rhs.
engine.urlreturns aURLobjectsqlalchemy.engine.url. As far as I can see, the Engine class (sqlalchemy.engine.Engine) has no property documented namedurl. The only thing I can see how to do is create an object when you already know the details of the connection. I'm trying to work out how to get that information back from anEngineinstance.Engineclass has aurlattribute (github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalchemy/engine/…) Looks like it's not documented