[sqlalchemy] the columns retrieved in a recordset

2008-01-19 Thread alex bodnaru
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi friends, could i know the columns a select would retrieve, without examining the first record retrieved? or if no records matched the where. tia , alex -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with

[sqlalchemy] Re: msqsql and sqlalchemy on linux -was Re: mssql connection uri

2008-01-19 Thread Frank Wierzbicki
On Jan 17, 2008 4:35 PM, jason kirtland [EMAIL PROTECTED] wrote: I've got a local branch going to formalize the multi-driver support ease using SQLAlchemy on alternate VMs. Adding ODBC to a single-driver dialect in CPython was my step 1, next up is sqlite via JDBC for Jython, and then the

[sqlalchemy] Re: Problems connecting to Postgresql using collective.lead

2008-01-19 Thread Bernhard Mager
Alex Turner schrieb: I am getting an error connecting to Postgresql: ImportError: unknown database 'psycopg' The back story is that I am attempting to modify an example given in Martin Aspeli's Book: Professional Plone Development (Chapter 12 - page 274-. He recommends using SQLAlchemy,

[sqlalchemy] Re: Problems connecting to Postgresql using collective.lead

2008-01-19 Thread Andreas Jung
--On 18. Januar 2008 15:56:02 -0800 Alex Turner [EMAIL PROTECTED] wrote: I am getting an error connecting to Postgresql: ImportError: unknown database 'psycopg' The canonical driver name for Postgres databases is 'postgres'. Looks like a typo in Martin's book. psycopg(2) is name of the

[sqlalchemy] Re: Problems connecting to Postgresql using collective.lead

2008-01-19 Thread Alex Turner
Ahh - that is the thing - he doesn't say in the book about postgresql, that is sort of the problem! He uses MySQL (Ugh) in the book, so I was sort of guessing. Alex On Jan 19, 2008 11:23 AM, Andreas Jung [EMAIL PROTECTED] wrote: --On 18. Januar 2008 15:56:02 -0800 Alex Turner [EMAIL

[sqlalchemy] A General Thank You

2008-01-19 Thread Alex Turner
To all the people who have worked on SQL Alchemy's docs. A massive thank you! It is so refreshing to come to an open source project that has not just adequate documentation, but totally awesome docs. I can't believe how fast I was able to get SQL Alchemy working, the docs are fantastic!!! Alex

[sqlalchemy] Re: msqsql and sqlalchemy on linux -was Re: mssql connection uri

2008-01-19 Thread jason kirtland
Frank Wierzbicki wrote: On Jan 17, 2008 4:35 PM, jason kirtland [EMAIL PROTECTED] wrote: I've got a local branch going to formalize the multi-driver support ease using SQLAlchemy on alternate VMs. Adding ODBC to a single-driver dialect in CPython was my step 1, next up is sqlite via JDBC

[sqlalchemy] Re: the columns retrieved in a recordset

2008-01-19 Thread sdobrev
theoreticaly, looking at the sql.expression.py/Select, try for a in yourselect.inner_columns: print a it's a yielding property. alex bodnaru wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi friends, could i know the columns a select would retrieve, without examining the

[sqlalchemy] Re: the columns retrieved in a recordset

2008-01-19 Thread alex bodnaru
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 thanks for your answer. i just wonder whether the * (all columns) is being expanded there. alex [EMAIL PROTECTED] wrote: theoreticaly, looking at the sql.expression.py/Select, try for a in yourselect.inner_columns: print a it's a yielding

[sqlalchemy] Re: the columns retrieved in a recordset

2008-01-19 Thread sdobrev
i just wonder whether the * (all columns) is being expanded there. try? [EMAIL PROTECTED] wrote: theoreticaly, looking at the sql.expression.py/Select, try for a in yourselect.inner_columns: print a it's a yielding property. alex bodnaru wrote: could i know the columns a select would

[sqlalchemy] Re: msqsql and sqlalchemy on linux -was Re: mssql connection uri

2008-01-19 Thread Frank Wierzbicki
On Jan 19, 2008 1:00 PM, jason kirtland [EMAIL PROTECTED] wrote: Frank Wierzbicki wrote: I'm not too far yet with Jython- still working on CPython issues. This weekend I plan to check in a tool that converts the test suite source into 2.3-compatible syntax, enabling testing with the Jython

[sqlalchemy] Re: the columns retrieved in a recordset

2008-01-19 Thread Michael Bayer
On Jan 19, 2008, at 7:49 AM, alex bodnaru wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi friends, could i know the columns a select would retrieve, without examining the first record retrieved? or if no records matched the where. result.keys() this returns you string

[sqlalchemy] Re: the columns retrieved in a recordset

2008-01-19 Thread Michael Bayer
On Jan 19, 2008, at 4:50 PM, Michael Bayer wrote: result.keys() oh its a propresult.keys --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: the columns retrieved in a recordset

2008-01-19 Thread alex bodnaru
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 thanks a lot, mike and sdobrev :) Michael Bayer wrote: On Jan 19, 2008, at 4:50 PM, Michael Bayer wrote: result.keys() oh its a propresult.keys -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG

[sqlalchemy] Re: A General Thank You

2008-01-19 Thread Michael Bayer
youre very welcome ! glad you've had a positive experience. On Jan 19, 2008, at 12:28 PM, Alex Turner wrote: To all the people who have worked on SQL Alchemy's docs. A massive thank you! It is so refreshing to come to an open source project that has not just adequate documentation,

[sqlalchemy] Re: msqsql and sqlalchemy on linux -was Re: mssql connection uri

2008-01-19 Thread jason kirtland
Frank Wierzbicki wrote: On Jan 19, 2008 1:00 PM, jason kirtland [EMAIL PROTECTED] wrote: Frank Wierzbicki wrote: I'm not too far yet with Jython- still working on CPython issues. This weekend I plan to check in a tool that converts the test suite source into 2.3-compatible syntax, enabling