Using Phing's dbdeploy task with transactions

Posted by Gordon on Stack Overflow See other posts from Stack Overflow or by Gordon
Published on 2010-03-16T11:27:28Z Indexed on 2010/03/16 11:36 UTC
Read the original article Hit count: 576

Filed under:

php

|

phing

|

dbdeploy

I am using Phing's dbdeploy task to manage my database schema. This is working fine, as long as there is no errors in my delta file.

However, if there is an error, dbdeploy will just run the delta files up to the query with the error and then abort. This causes me some frustration, because I have to manually rollback the entry in the changelog table then. If I don't, dbdeploy will assume the migration was successful on a subsequent try.

So the question is, there any way to get dbdeploy use transactions?

© Stack Overflow or respective owner

Related posts about php

Magento, NGINX, PHP-FPM, APC, MEMCACHED, 16gb Ram CentOS, Spiking PHP-FPM to 100% CPU

as seen on Server Fault - Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to: pm = ondemand pm.max_children = 12 pm.start_servers = 2 pm.min_spare_servers = 2 pm.max_spare_servers = 10 pm.max_requests = 500 php_admin_value[memory_limit] = 128M Problem… >>> More
PHP Pear Installation on CentOS

as seen on Server Fault - Search for 'Server Fault'
[root@ip ~]# yum install php-pear* Reducing CentOS-5 Testing to included packages only Finished Setting up Install Process Package 1:php-pear-1.8.1-2.el5.centos.noarch already installed and latest versio … >>> More
Apache configurations for php "AddType text/html php" or "AddType application/x-httpd-php php .php"

as seen on Server Fault - Search for 'Server Fault'
I am taking over an application server and discover that it contain the following settings: AddType text/html php Although it works, but my understanding is that it should set as following: AddType application/x-httpd-php php .php What are the key differences between the two settings?… >>> More
mod_rewrite settings causes server to throw HTTP 500 errors instead of 404

as seen on Server Fault - Search for 'Server Fault'
Hello. I have a server with VBulletin forum (working under Apache 2.2, CentOS). The default settings for it in .htaccess are as follows: RewriteEngine on RewriteCond %{HTTP_HOST} ^gsmforum\.ru RewriteRule (.*) http://www.gsmforum.ru/$1 [R=301,L] # If you are having problems or are using VirtualDocumentRoot… >>> More
Problems installing Memcache (PECL extension)

as seen on Server Fault - Search for 'Server Fault'
I have installed memcached fine, and now I will need to install PECL extension memcache. Im running RedHat x86_64 es5. The installation gives me this: downloading memcache-2.2.6.tgz ... Starting to download memcache-2.2.6.tgz (35,957 bytes) ..........done: 35,957 bytes 11 source files, building running:… >>> More

Related posts about phing

how to upgrade phing 'stable' to phing 'trunk' to use SSHTask

as seen on Stack Overflow - Search for 'Stack Overflow'
phing 2.4.1 (current stable version) doesn't have an SSH Task to do remote scripting. In the current trunk version, there is a SSH Task that we would like to use. How can I upgrade my current phing installation (2.4.1) to the latest build? Can I use pear for that without breaking my current phing… >>> More
phing: get last commit ID (revision) and use it as a phing attribute

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to get the latest revision ID from my SVN project using Phing. What I'm trying to do is the following: get latest revision/commit number from svn store this revision number as an attribute (so that I can use this to append it to the archive I'm already creating using phing) I… >>> More
Getting Phing's dbdeploy task to automatically rollback on delta error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using Phing's dbdeploy task to manage my database schema. This is working fine, as long as there is no errors in the queries of my delta files. However, if there is an error, dbdeploy will just run the delta files up to the query with the error and then abort. This causes me some frustration… >>> More
Can I redistribute Phing with non-free software?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having trouble understanding the terms of the LGPL in light of a program that is not written in C or C++. They speak of libraries being linked and 'derivitive' works. If I were to package a php program and sell it, but within the program the deployment mechanism used the phing package (full… >>> More
Using Phing's dbdeploy task with transactions

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using Phing's dbdeploy task to manage my database schema. This is working fine, as long as there is no errors in my delta file. However, if there is an error, dbdeploy will just run the delta files up to the query with the error and then abort. This causes me some frustration, because I have… >>> More