AppGini Community Forums

Code: Select all

$result = sqlValue('BEGIN;');

Code: Select all

$result = sqlValue('COMMIT;');

Code: Select all

$result = sqlValue('ROLLBACK;');

Code: Select all

function templates_init(&$options, $memberInfo, &$args)
{
	// Please test this for yourself before using it in production environments.
	// I give no guarantee and I am not liable for loss of data.
	// Remember to make regular backups.

	$db = db_link();
	$db->autocommit(FALSE); // Important

	// do your SQL inserts/updates/deletes here
	$db->query("INSERT INTO templates(name) VALUES ('Test1')");

        // validate: number of templates named "Test1" should be 1 within transaction
	$count = sqlValue("SELECT count(*) FROM templates WHERE name='Test1'");
	assert($count == 1, "Number of records inside transaction");

	// commit transaction
	// $db->commit();
        // validate: number of templates named "Test1" should be 1 after commit
	// assert($count == 1, "Number of records after commit");
	
	// or

	// rollback transaction
	$db->rollback();
        // validate: number of templates named "Test1" should be 0 after rollback
	$count = sqlValue("SELECT count(*) FROM templates WHERE name='Test1'");
	assert($count == 0, "Number of records after rollback");

	$db->autocommit(TRUE); // Important!

	return TRUE;
}