Re: [sqlalchemy] Issuing Raw SQL and Returning a List of Objects

2023-11-02 Thread Mike Graziano
> result = conn.execute(text('select foo, bar from baz')).fetchall() # > fetchall() without mappings() returns a list of named tuple like objects > for row in results: > print(row.foo, row.bar) > print(row[0], row[1]) > > On Thursday, August 24, 2023 at 5:06:11 A

Re: [sqlalchemy] Issuing Raw SQL and Returning a List of Objects

2023-08-24 Thread Mike Graziano
atabase, meaning that I can run most of my tests using > SQLite despite using Postgres or MySQL in production. > > In summary: use the right tool for the job :-) > > Simon > > > On Mon, Aug 21, 2023 at 6:48 PM Mike Graziano wrote: > >> Hi Mike, >> >&

Re: [sqlalchemy] Issuing Raw SQL and Returning a List of Objects

2023-08-21 Thread Mike Graziano
-4 Mike Bayer wrote: > the raw SQL to ORM mapping pattern has a lot of limitations but it is > documented at > https://docs.sqlalchemy.org/en/20/orm/queryguide/select.html#getting-orm-results-from-textual-statements > > . > > > > On Thu, Aug 17, 2023, at 4:26 PM, Mike

[sqlalchemy] Issuing Raw SQL and Returning a List of Objects

2023-08-17 Thread Mike Graziano
To all, I am new to Python and SQLAlchemy. I was a Java developer who used the MyBatis ORM. I was using PONY ORM for a while, but was concerned that SQLAlchemy is the gold standard for ORMs and Python, but there is something about MyBatis that I can't seem to find in SQLAlchemy, but maybe I

[iText-questions] Can An Existing PDF-document Be Read And Output?

2006-08-10 Thread Mike Graziano
To all, I recently became aware of iText and have successfully used it to write PDF-documents from text. However, now I need to go the other way. I'd like to read an existing PDF-document and create output. The FAQ page answers the question Is it possible to parse an existing