Lucee SQL Transactions Examples

Application.cfc

component {
	this.datasources["employees"] = {
		  class: 'org.gjt.mm.mysql.Driver'
		, connectionString: 'jdbc:mysql://192.168.33.10:3306/employees?useUnicode=true&characterEncoding=UTF-8&useLegacyDatetimeCode=false'
		, username: 'employees'
		, password: "123456"
	};
	this.datasource="employees";


	function onRequestEnd(string targetPage) {
		setting showdebugoutput="true";
		
	}
}

basic_transaction.cfm

<cfscript>
transaction {
	query name='employeeCount' {
		echo("SELECT count(*) FROM employees");
	}
}
</cfscript>

basic_transaction.png

transaction_with_changes.cfm

<cfscript>
transaction {
	query name='employeeCount' {
		INSERT INTO employees
		SET 
	}
}
writeDump(employeeCount);
</cfscript>

transactionsTest.cfc

/**
* My xUnit Test
*/
component extends="testbox.system.BaseSpec"{
	
/*********************************** LIFE CYCLE Methods ***********************************/

	// executes before all test cases
	function beforeTests(){
	}

	// executes after all test cases
	function afterTests(){
	}

	// executes before every test case
	function setup( currentMethod ){
	}

	// executes after every test case
	function teardown( currentMethod ){
	}

/*********************************** TEST CASES BELOW ***********************************/
	
	function databaseTest(){
		query {
			echo("select count(*) from employees");
		}
	}

	function basicTransactionTest(){
		include template="basic_transaction.cfm";
	}
	
}