[sqlalchemy] Re: Joined Table Inheritance

2008-02-18 Thread Michael Bayer
On Feb 18, 2008, at 10:34 AM, Julien Cigar wrote: My question is: can I have a select() object which return a scalar for the polymorphic_identity parameters ? I guess it should be possible to put anything else than the FK value ? theres no reason you cant map to select([content,

[sqlalchemy] Re: executing stored procedure which returns rows

2008-02-18 Thread John Keith Hohm
select * from (procedure_foo) That would be lovely, but I can find no way to wrap a procedure in a select. If it were possible I could have just rewritten the procedure call as a select and matched the existing regexp. you can do that as

[sqlalchemy] Re: How to load a complex data set into an SA aware object?

2008-02-18 Thread jason kirtland
Jorge Vargas wrote: On Feb 14, 2008 10:51 AM, jason kirtland [EMAIL PROTECTED] wrote: Jorge Vargas wrote: Hi, I'm working on a project where I got several read only tables that are dependent on a third-party, I got several vainlla SQL queries to get the data I need of them and I was

[sqlalchemy] Re: How to load a complex data set into an SA aware object?

2008-02-18 Thread Michael Bayer
On Feb 18, 2008, at 12:20 PM, jason kirtland wrote: To my knowledge you can't define a primary mapper against a free-form text SQL statement- without knowing what the columns will be, the mapper can't set up the attribute mappings in the target class. There are probably other ways to set

[sqlalchemy] Re: executing stored procedure which returns rows

2008-02-18 Thread Rick Morrison
happily, though, I realized I can create a table-valued function that executes the procedure, and I can select from the table-valued function in this way. Right, table-valued functions were added in MSSQL2000, but they do have some limitations compared to regular stored procedures - notably,

[sqlalchemy] I am having a problem inserting records and getting a exception

2008-02-18 Thread Mike Bernson
I have attached the code doing the write to the database and a traceback with local variable being display for each frame. I am also attaching a run with nothing catching the error so you can see the simple traceback with the exception. Here is output from mysql show this has gone a long way

[sqlalchemy] Re: I am having a problem inserting records and getting a exception

2008-02-18 Thread jason kirtland
Mike Bernson wrote: I have attached the code doing the write to the database and a traceback with local variable being display for each frame. I am also attaching a run with nothing catching the error so you can see the simple traceback with the exception. Here is output from mysql show

[sqlalchemy] Re: I am having a problem inserting records and getting a exception

2008-02-18 Thread Mike Bernson
You are correct. Sorry I some how skipped over the last entry. Thanks jason kirtland wrote: Mike Bernson wrote: I have attached the code doing the write to the database and a traceback with local variable being display for each frame. I am also attaching a run with nothing catching the