Hi,
This question is specific to Pylons and SQLAlchemy.
Hi all,
I have a mapped class (I am using SQLAlchemy's ORM), called Person. I
have a method on a pylons controller to delete a Person record from
the table that the Person class is mapped to. I am using the "id"
column (int, primary key) of the person table to delete this person
record.
I find myself doing something like this:
def deletePerson(self):
person_id = int(request.GET["personId"])
p = Session.query(Person).filter_by(id=person_id).first()
if p:
Session.delete(p)
Session.commit()
return redirect_to(action="list")
Is it normal, when using sqlalchemy, to have to select the Person
object first, then delete it? I would rather not hit the database for
the select, and then again for the delete. I realize I could probably
do this if I bypassed SQLAlchemy's ORM and used it's SQL expression
language, but I would rather not.
Thanks,
goon12
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
