Re: Does cakephp support transaction now?
And for 1.1 you need to use MySQL innoDB, set var $transactional to
true in the appropriate models. In your controller you can then do
something like (code excerpt from one of my applications):
$error_flag = false;
$this-{$this-modelClass}-execute( 'START TRANSACTION' );
// update the offline record with the paid_by method
$this-{$this-modelClass}-OfflineRecord-id = $this-{$this-
modelClass}-OfflineRecord-field('id',
aa('OfflineRecord.payment_id', $id));
if(!$this-{$this-modelClass}-OfflineRecord-saveField('paid_by',
Sanitize::paranoid($this-data['OfflineRecord']['paid_by'])))
{
$this-Logr-error('#8827 - update of Offline field failed in
payment/receive for user ' . $this-Common-getUserVar('id') . ' and
payment code ' . $payment_code);
$error_flag = true;
}
if(!$this-{$this-modelClass}-setPaymentStatus($id, 'complete'))
{
$this-Logr-error('#8827 - setPaymentStatus failed in payment/
receive for user ' . $this-Common-getUserVar('id') . ' and payment
code ' . $payment_code);
$error_flag = true;
}
if(!$error_flag)
{
$this-{$this-modelClass}-execute( 'COMMIT' );
$this-Message-flash('Payment and associated bookings have been
successfully marked as received');
}
else
{
$this-{$this-modelClass}-execute( 'ROLLBACK' );
$this-Message-flash('Error #8827; Payment and associated
bookings were not marked as recieved due to a database error',
'error');
}
Does that make sense? Ianh
On Jul 8, 8:07 pm, Christian \Jippi\ Winther [EMAIL PROTECTED]
wrote:
Hello
For CakePHP 1.2 you can use my model
behaviorhttp://bakery.cakephp.org/articles/view/transaction-behavior(Should
work
with most databases, though it was developed for MySQL innodb)
If you do not wish to use it (Might be overkill for some people), you
should be able to do just
$this-ModelName-begin();
$this-ModelName-commit();
$this-ModelName-rollback();
Since the overloaded php4/5 model base class is using the magic method
__call that just pass unknown commands for the model directly to the SQL
server as a command
---
Christian Jippi Winther
http://docs.cakephp.nu(Unofficial CakePHP API)
http://logs.cakephp.nu(Unofficial CakePHP IRC log)
From: cake-php@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Larry E. Masters aka PhpNut
Sent: 8. juli 2007 18:37
To: cake-php@googlegroups.com
Subject: Re: Does cakephp support transaction now?
On 7/8/07, sTb [EMAIL PROTECTED] wrote:
Read the fucking manuall!
if you want to use more models in your application
readhttp://manual.cakephp.org/chapter/models
This will be the first and only warning, let it happen again and I will ban
you.
There is no reason to use this language in the group.
--
/**
* @author Larry E. Masters
* @var string $userName
* @param string $realName
* @returns string aka PhpNut
* @access public
*/
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Does cakephp support transaction now?
Read the fucking manuall! if you want to use more models in your application read http://manual.cakephp.org/chapter/models On 8 Jul., 11:29, hi and hello [EMAIL PROTECTED] wrote: In my application I sometimes have more than one database actions in an action, but when read the cakephp's docs I found little about this? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Does cakephp support transaction now?
On 7/8/07, sTb [EMAIL PROTECTED] wrote: Read the fucking manuall! Wow what a word ! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Does cakephp support transaction now?
On 7/8/07, sTb [EMAIL PROTECTED] wrote: Read the fucking manuall! if you want to use more models in your application read http://manual.cakephp.org/chapter/models I don't think it was the most polite way of replying to the original poster, and besides you didn't understand his question. He asked how to handle atomic database transactions in CakePHP (for which I don't know the answer to), not how to use more than one model. - Gonzalo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Does cakephp support transaction now?
On 7/8/07, sTb [EMAIL PROTECTED] wrote: Read the fucking manuall! if you want to use more models in your application read http://manual.cakephp.org/chapter/models This will be the first and only warning, let it happen again and I will ban you. There is no reason to use this language in the group. -- /** * @author Larry E. Masters * @var string $userName * @param string $realName * @returns string aka PhpNut * @access public */ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
RE: Does cakephp support transaction now?
Hello For CakePHP 1.2 you can use my model behavior http://bakery.cakephp.org/articles/view/transaction-behavior (Should work with most databases, though it was developed for MySQL innodb) If you do not wish to use it (Might be overkill for some people), you should be able to do just $this-ModelName-begin(); $this-ModelName-commit(); $this-ModelName-rollback(); Since the overloaded php4/5 model base class is using the magic method __call that just pass unknown commands for the model directly to the SQL server as a command --- Christian Jippi Winther http://docs.cakephp.nu (Unofficial CakePHP API) http://logs.cakephp.nu (Unofficial CakePHP IRC log) From: cake-php@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Larry E. Masters aka PhpNut Sent: 8. juli 2007 18:37 To: cake-php@googlegroups.com Subject: Re: Does cakephp support transaction now? On 7/8/07, sTb [EMAIL PROTECTED] wrote: Read the fucking manuall! if you want to use more models in your application read http://manual.cakephp.org/chapter/models This will be the first and only warning, let it happen again and I will ban you. There is no reason to use this language in the group. -- /** * @author Larry E. Masters * @var string $userName * @param string $realName * @returns string aka PhpNut * @access public */ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
