Hi Michael, Thanks for the feedback, much appreciated.
Seems I had to do some fancy foodwork using the Python SQLite3 library.....and using the "ATTACH DATABASE"....seems to work of for what I need.... Thanks conn = sqlite3.connect('db_1.db') c = conn.cursor() result = c.execute("ATTACH DATABASE 'db_2.db' AS 'DB_2';") error = False result = c.execute("DELETE FROM DB_1 WHERE IDX = 3;") result = c.execute("DELETE FROM DB_2 WHERE IDX = 1;") #Check for errors #conn.rollback() conn.commit() On Apr 22, 5:02 pm, "Michael Bayer" <mike...@zzzcomputing.com> wrote: > Lynton Grice wrote: > > Hi there, > > > I have seen some basic examples online showing that SQLAlchemy > > supports "twophase = True" for some databases. > > > My question is I am needing to use this sort of functionality with 2 > > SQLite databases, does SQLAlchemy support SQLite two phase commits? > > SQLite does not support two phase commit. > > -- > 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 > athttp://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.