[sqlalchemy] Re: Using psql commands (i.e. \d) through sqlalchemy.core

2016-10-31 Thread Lele Gaifax
Jonathan Vanasco writes: > I believe the answer is no. > > IIRC, those psql commands are shortcuts within psql... and the various > drivers (psycopg2, etc) don't support them. Right. Some of those commands are exposed by https://pypi.python.org/pypi/pgspecial, used for

[sqlalchemy] Re: Using psql commands (i.e. \d) through sqlalchemy.core

2016-10-31 Thread Jonathan Vanasco
I believe the answer is no. IIRC, those psql commands are shortcuts within psql... and the various drivers (psycopg2, etc) don't support them. A workaround is to use the underlying query against postgresql's tables

[sqlalchemy] Using psql commands (i.e. \d) through sqlalchemy.core

2016-10-31 Thread Ugo Di Girolamo
Is it possible to do \d and other psql commands through sqlalchemy.core? I've been trying to figure out whether it's possible to use the psql commands (i.e. http://www.postgresonline.com/downloads/special_feature/postgresql83_psql_cheatsheet.pdf) through sqlalchemy, and have not been able to

Re: [sqlalchemy] Handy package to debug flask+sqlalchemy+orm (flask_sqla_debug)

2016-10-31 Thread Simon King
Ah, that too looks very interesting, thanks for pointing it out. It looks like it provides the sort of split that I was talking about. I'll definitely investigate that one further. Thanks, Simon On Mon, Oct 31, 2016 at 11:17 AM, Thierry Florac wrote: > Hi, > > For Pyramid,

Re: [sqlalchemy] Handy package to debug flask+sqlalchemy+orm (flask_sqla_debug)

2016-10-31 Thread Thierry Florac
Hi, For Pyramid, another interesting package is SQLTap, which provides useful informations about execution of SQLAlchemy queries... Best regards, Thierry 2016-10-31 11:05 GMT+01:00 Simon King : > On Sun, Oct 30, 2016 at 9:36 PM, Alfred Perlstein >

Re: [sqlalchemy] Handy package to debug flask+sqlalchemy+orm (flask_sqla_debug)

2016-10-31 Thread Simon King
On Sun, Oct 30, 2016 at 9:36 PM, Alfred Perlstein wrote: > Hello, > > I wanted to start this out with a big thanks to the community, especially > Mike Bayer, Simon King, and Jonathan Vanasco. > > A few weeks ago I asked for help on debugging sqlalchemy and was able to