database - Python distributed transactions like Java Transaction API (JTA) -

-

is there solution distributed transactions in python or mysqldb java transaction api (jta)?

i got problem when processing data on multiple databases (maybe different kinds of databases).

how can ensure data consistency?

i know there's java transaction api (jta) in java.

how can python?

you use sql statements xa transaction. not pretty real api, works. don't know if there tm's (transaction managers) available python, write own.

also note in java not required use application server when using xa. example: http://bugs.mysql.com/file.php?id=22190&bug_id=75316

in [1]: import mysql.connector  in [2]: c = mysql.connector.connect(host='127.0.0.1',port=5705,user='msandbox',password='msandbox');  in [3]: cur = c.cursor();  in [4]: cur.execute("xa start 'py-xa-001'");  in [5]: cur.execute("insert test.t1 values(1)");  in [6]: cur.execute("xa recover");  in [7]: print(cur.fetchone()); none  in [8]: cur.execute("xa end 'py-xa-001'");  in [9]: cur.execute("xa prepare 'py-xa-001'");  in [10]: cur.execute("xa recover");  in [11]: print(cur.fetchone()); (1, 9, 0, u'py-xa-001')  in [12]: cur.execute("xa rollback 'py-xa-001'");  in [13]: cur.close() out[13]: true  in [14]: c.disconnect()

Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more