[sqlalchemy] Re: Unexpected SessionTransaction behaviour

On Jun 14, 11:19 pm, Michael Bayer mike...@zzzcomputing.com wrote: the new SessionTransaction that occurs in close() does not request any connection resources, and is discarded immediately along with the session that is the subject of remove().    I don't see how it could be affected by any

[sqlalchemy] how do i take advantage of sqlite manifest typing / type affinity using sqlalchemy?

Not sure what the etiquette is re cross-posting to this list from stackoverflow? here's my question: http://stackoverflow.com/questions/3044518/how-do-i-take-advantage-of-sqlite-manifest-typing-type-affinity-using-sqlalchem I like the idea of sqlite's manifest typing / type affinity:

[sqlalchemy] order_by with func.count

Hello, I have this query: rsvp = session.query(Project.project, func.count(Reservation.project_id)).join(Reservation.project).group_by(Project.project, Project.id).order_by(Project.project) print rsvp SELECT project.project AS project_project, count(reservation.project_id) AS count_1 FROM

Re: [sqlalchemy] good IDE for SQLAlchemy and wxPython?

werner wrote: You should probably also look at some of the tools out there, e.g. - wxPythonPit lists a lot - http://wiki.wxpython.org/wxPythonPit%20Apps - WindIde - http://www.wingware.com/ - Ulipad - http://code.google.com/p/ulipad/ - Editra - http://editra.org/ Don't count on getting too

[sqlalchemy] Harder problem

Ok, two queries: rsvp = session.query(Project.project, func.count(Reservation.project_id)).join(Reservation.project).group_by(Project.project, Project.id).order_by(Project.project).all() h = session.query(Project.project,

RE: [sqlalchemy] Kerberos authentication with sybase

I think it you want to make it flexible there should be a dictionary or a two-dimensional list specifying which options should be set, so in case of kerberos it would have two elements. Unfortunatelly these options cannot be specified for the connect() function of python-sybase. the

[sqlalchemy] order_by with func.count

Hello, OK I figured this out: rsvp = session.query(Project.project, Project.id, func.count(Reservation.project_id)).join(Reservation.project).group_by(Project.project, Project.id).order_by(desc(func.count(Reservation.project_id))).all() I'm not normally a vaseline man, but this is amazing:

Re: [sqlalchemy] how do i take advantage of sqlite manifest typing / type affinity using sqlalchemy?

On Jun 15, 2010, at 7:14 AM, Harry Percival wrote: Not sure what the etiquette is re cross-posting to this list from stackoverflow? here's my question: http://stackoverflow.com/questions/3044518/how-do-i-take-advantage-of-sqlite-manifest-typing-type-affinity-using-sqlalchem AFAIK this

Re: [sqlalchemy] Kerberos authentication with sybase

On Jun 15, 2010, at 9:13 AM, Cserna, Zsolt wrote: I think it you want to make it flexible there should be a dictionary or a two-dimensional list specifying which options should be set, so in case of kerberos it would have two elements. Unfortunatelly these options cannot be specified

Re: [sqlalchemy] Re: Unexpected SessionTransaction behaviour

err, no, your test is incorrect. You are maintaining a reference to the SessionTransaction in tolist. Change the middle of the loop to read: assert len(tolist) == 1 del tolist so that you are not artificially holding onto the SessionTransaction, and additionally: for s in sessions:

Re: [sqlalchemy] how do i take advantage of sqlite manifest typing / type affinity using sqlalchemy?

Answered my own question: Define a custom column type, as per http://www.sqlalchemy.org/docs/reference/sqlalchemy/types.html#custom-types a combination of the documentation and some trial error have given me this: class MyDuckType(sqlalchemy.types.TypeDecorator): SQLALchemy custom

Re: [sqlalchemy] how do i take advantage of sqlite manifest typing / type affinity using sqlalchemy?

Thanks Michael - i've seen others complain about the arbitrary-precision numbers issue... I'm not so bothered by that, but i do like the ability to natively store integers and strings in the same column. On Tue, Jun 15, 2010 at 4:40 PM, Harry Percival harry.perci...@gmail.comwrote: Answered my

[sqlalchemy] Re: Unexpected SessionTransaction behaviour

On Jun 15, 4:30 pm, Michael Bayer mike...@zzzcomputing.com wrote: err, no, your test is incorrect.  You are maintaining a reference to the SessionTransaction in tolist. Whoops, you're right. However, should I really have to do a gc.collect() after the session.remove() calls? Without it, I

Re: [sqlalchemy] Re: Unexpected SessionTransaction behaviour

On Jun 15, 2010, at 12:59 PM, Vinay Sajip wrote: On Jun 15, 4:30 pm, Michael Bayer mike...@zzzcomputing.com wrote: err, no, your test is incorrect. You are maintaining a reference to the SessionTransaction in tolist. Whoops, you're right. However, should I really have to do a

[sqlalchemy] Using update()

Hi there, Can someone give me an example of using update()? Thanks. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to