[sqlalchemy] Re: Can I remove a Column from the select() result set

2007-11-17 Thread Matt Culbreth
, Matt Culbreth wrote: Howdy Group, Let's say I have a very simple query: select person.id, person.name, person.age from person Can I remove one of the columns, say person.age, from this result set and still use the list as a RowProxy? I'm trying to do it now and it's not working

[sqlalchemy] Can I remove a Column from the select() result set

2007-11-16 Thread Matt Culbreth
Howdy Group, Let's say I have a very simple query: select person.id, person.name, person.age from person Can I remove one of the columns, say person.age, from this result set and still use the list as a RowProxy? I'm trying to do it now and it's not working. I'm creating a new list and

[sqlalchemy] Anybody seen--Exception: invalid byte sequence for encoding UTF8?

2007-06-02 Thread Matt Culbreth
Howdy All, I've got some existing code that I'm trying on a new server. The code was formerly running with Python 2.4 and SA 0.36, but this new server is running Python 2.5 and SA 0.37. Anyway, I've got a small program which is loading a PostgreSQL 8.2 db from a CSV file, and I'm getting this

[sqlalchemy] Re: Anybody seen--Exception: invalid byte sequence for encoding UTF8?

2007-06-02 Thread Matt Culbreth
, Matt Culbreth wrote: Howdy All, I've got some existing code that I'm trying on a new server. The code was formerly running with Python 2.4 and SA 0.36, but this new server is running Python 2.5 and SA 0.37. Anyway, I've got a small program which is loading a PostgreSQL 8.2 db from

[sqlalchemy] Asynchronous SQLAlchemy--Anybody using Twisted, sAsync?

2007-02-19 Thread Matt Culbreth
Howdy Group, I'm playing out with a few things now and I wanted to see if anyone else has used SQLAlchemy in an asynchronous manner? For example, you could create a service which responded to asynchronous requests for data, and could be used by a web client, desktop client, other types of

[sqlalchemy] How to determine if an instance has been populated?

2007-02-12 Thread Matt Culbreth
Hello Friends, I'm working with the latest version of SQLAlchemy now and I have a question: how do I determine if a particular mapped object instance has been populated by the database? The question originates because I have defined a __repr__() method on one of my mapped objects. It works

[sqlalchemy] Re: How to determine if an instance has been populated?

2007-02-12 Thread Matt Culbreth
That got it, thanks. On Feb 12, 3:57 pm, Michael Bayer [EMAIL PROTECTED] wrote: check for an _instance_key attribute. On Feb 12, 1:52 pm, Matt Culbreth [EMAIL PROTECTED] wrote: Hello Friends, I'm working with the latest version of SQLAlchemy now and I have a question: how do I