Update of /cvsroot/php-blog/serendipity/include/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27000/include/db
Modified Files:
mysql.inc.php mysqli.inc.php postgres.inc.php sqlite.inc.php
Log Message:
Transaction-Support in the DB-Layer
Index: mysqli.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/include/db/mysqli.inc.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- mysqli.inc.php 7 Jan 2005 19:30:55 -0000 1.7
+++ mysqli.inc.php 9 Jan 2005 10:32:36 -0000 1.8
@@ -1,5 +1,17 @@
<?php # $Id$
+function serendipity_db_begin_transaction(){
+ serendipity_db_query('start transaction');
+}
+
+function serendipity_db_end_transaction($commit){
+ if ($commit){
+ serendipity_db_query('commit');
+ }else{
+ serendipity_db_query('rollback');
+ }
+}
+
/* Issues a query to the underlying database;
* returns:
* false if there was an error,
Index: mysql.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/include/db/mysql.inc.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- mysql.inc.php 7 Jan 2005 19:30:55 -0000 1.7
+++ mysql.inc.php 9 Jan 2005 10:32:36 -0000 1.8
@@ -1,5 +1,17 @@
<?php # $Id$
+function serendipity_db_begin_transaction(){
+ serendipity_db_query('start transaction');
+}
+
+function serendipity_db_end_transaction($commit){
+ if ($commit){
+ serendipity_db_query('commit');
+ }else{
+ serendipity_db_query('rollback');
+ }
+}
+
/* Issues a query to the underlying database;
* returns:
* false if there was an error,
Index: postgres.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/include/db/postgres.inc.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- postgres.inc.php 7 Jan 2005 19:30:55 -0000 1.7
+++ postgres.inc.php 9 Jan 2005 10:32:36 -0000 1.8
@@ -1,5 +1,17 @@
<?php # $Id$
+function serendipity_db_begin_transaction(){
+ serendipity_db_query('begin work');
+}
+
+function serendipity_db_end_transaction($commit){
+ if ($commit){
+ serendipity_db_query('commit');
+ }else{
+ serendipity_db_query('rollback');
+ }
+}
+
function serendipity_db_connect() {
global $serendipity;
Index: sqlite.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/include/db/sqlite.inc.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- sqlite.inc.php 7 Jan 2005 19:30:55 -0000 1.7
+++ sqlite.inc.php 9 Jan 2005 10:32:36 -0000 1.8
@@ -5,6 +5,18 @@
@dl('sqlite.dll');
}
+function serendipity_db_begin_transaction(){
+ serendipity_db_query('begin transaction');
+}
+
+function serendipity_db_end_transaction($commit){
+ if ($commit){
+ serendipity_db_query('commit transaction');
+ }else{
+ serendipity_db_query('rollback transaction');
+ }
+}
+
function serendipity_db_connect()
{
global $serendipity;
|