this has been fixed as of 1184.

On Mar 22, 2006, at 10:48 AM, Florian Boesch wrote:

Though selectfirst does not work with inheritance (probably oracle specific).

see http://www.sqlalchemy.org/trac/attachment/ticket/122/ selectfirst.py

Quoting Michael Bayer <[EMAIL PROTECTED]>:

May I all direct your attention to our own...Jonathan Ellis who
contributed this change !

While I havent documented yet (surprise !), you can also say
selectfirst() which works the old way.


On Mar 22, 2006, at 3:57 AM, Robert Leftwich wrote:

Florian Boesch wrote:
selectone of a mapper does not work anymore.

I think you'll find it is still working, it is just throwing an
exception when 0 *or* > 1 rows are returned, i.e. add one f = Foo()
and an objectstore.commit() and the exception goes away, add a
second g = Foo() and the exception is thrown again as more than 1
row has been returned.

When I saw this over the weekend my first reaction was to think it
was a problem, but the function is called selectone and the new
behaviour does meet that contract, i.e give me one and only one
row. However, there is now no way to tell if the error was thrown
because there were no rows or more than one row, which is often a
useful piece of information :-).

So, what do people think- should the current behaviour remain or
should it be changed? If the latter should it revert to the
original behaviour, return None when no rows are returned and throw
the exception if > 1 are returned or something else?

Robert



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the
live webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?
cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users






-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel? cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to