20 Ekim 2010 10:38 tarihinde Aydın ŞEN <adigeay...@gmail.com> yazdı:
> * > * > *myDict = {"title": "newTitle", "content": "newContent"}* > * > * > myDict values are arbitrary so i want to update MyTable with only keys and > values in myDict (not write one by one table fields). What is the elegant > way to do this? > > > This is my way to achieve first issues: #myDict has some arbitrary update values as a dict obj = session.query(MyTable).filter(MyTable.id == myDict.id).one() for k in MyTable.__table__.columns.keys(): if myDict.has_key(k): setattr(obj, k, myDict[k]) session.add(obj) session.commit() I wonder that this is the elegant way to do this. Second one is still a problem for me. How can i update relations when i update related object? -- Aydın Şen -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.