there's no problem at all. If you are working with the ORM and SQL in one transaction, you might need to expire your objects to get a hold of the changes you issue via SQL, until you commit() the transaction which expires everything (or start a new session).
On Oct 20, 2010, at 3:16 PM, palmprefan wrote: > Hi, > > I am a sqlalchemy newbie and wonder if it is safe to do this in my > code (for read only): > > conn = connection.engine.connect() > conn.execute(select[t1.amount]) > > while at the same time in another thread querying/updating t1 via an > object mapped to the table. > > Please let me know if this would cause potential problems. > > Thanks in advance. > > -- > 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. > -- 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.