Re: INNODB and DataObjects
| From: | Justin Patrin | Date: | Tue, 19 Apr 2005 16:29:10 +0000 |
| Subject: | Re: INNODB and DataObjects | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-18800@lists.php.net to get a copy of this message | ||
On 4/18/05, Dan Rossi <pear@electroteque.org> wrote:
> Me again, i think one of my issues is that the database on this one is
> using innodb transaction tables, i dont think the standard generator
> ran ok ? Should it be linking to the foreign keys ? Something is up ...
The DO generator doesn't handle foreign keys itself currently. This
would be a great feature to have for the DBs that support it...patches
welcome.
>
> I also need to know how to include all the commit and rollback stuff,
> ie if there is an error rollback, is that setup ?
>
Not sure what you mean here. DB_DO doesn't do transaction stuff
intrinsically. You can start / finish a transaction using
$do->query('BEGIN'); $do->query('ROLLBACK');
$do->query('COMMIT');
however (I know this is in the manual somewhere...).
--
Justin Patrin