<?php

require_once('../application/bootstrap_cli.php');

$db = Objlib::get(Objlib::TYPE_DB);
$db->query("CREATE TABLE `test2` (`one` varchar(10) DEFAULT NULL) ENGINE=InnoDB");

echo "start transaction\n";
$db->query("START TRANSACTION");


//would need to reset warnings before this - couldn't see "RESET WARNINGS" or similar
echo "testing proper transaction\n";
$db->query("insert into test2 values ('7890')");
if ($db->query('SHOW WARNINGS')->numRows() > 0) { //SELECT @@warning_count; will also work (even better)
	echo "rolling back\n";
	$db->query("ROLLBACK");
} else {
	echo "committing transaction\n";
	$db->query("COMMIT");
}


//would need to reset warnings before this - couldn't see "RESET WARNINGS" or similar
echo "testing error transaction\n";
$db->query("insert into test2 values ('7892345234523523450')");
if ($db->query('SHOW WARNINGS')->numRows() > 0) { //SELECT @@warning_count; will also work (even better)
	echo "rolling back\n";
	$db->query("ROLLBACK");
} else {
	echo "committing transaction\n";
	$db->query("COMMIT");
}