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" <[email protected]> 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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
