I am using the PhpOrient driver and am trying to setup transactions. I have everything working fine, until I try to attach a sql command to the transaction.
I am not sure if this is a limitation of the PhpDriver or of Orient itself, or the binary protocol the driver is built upon.
I have also come across SQL Batch, and am not sure the difference between batch and transactions.
Is it possible to attach sql commands to transactions?
My code:
//get the transaction and start it
$tx = $client->getTransactionStatement();
//BEGIN THE TRANSACTION
$tx = $tx->begin()
$create = $client->command("INSERT INTO V set test = 'a'");
$tx->attach($create);
$result = $tx->commit();