ColdFusion 10 - ColdFusion Query Of Queries vs. Functional Programming

<!---
	Build up a query manually so that we can explore the access and
	mutation of the query using query of queries.

	NOTE: I am not bothering with using JavaCast() for this demo.
	Ordinarilly, you'd want to JavaCast() *every* value that you
	manually put into a query object since the underlying technology
	relies on the comparison of Java values.
--->
<cfset friends = queryNew(
	"id, name, age",
	"cf_sql_integer, cf_sql_varchar, cf_sql_integer",
	[
		[ 1, "Sarah", 37 ],
		[ 2, "Tricia", 42 ],
		[ 3, "Kim", 25 ],
		[ 4, "Joanna", 31 ],
		[ 5, "Kit", 35 ]
	]
) />


<!---
	Now that we have our ColdFusion query object, let's demonstrate
	how to execute the following query Query-of-Query style
	programming:

	- Create
	- Read
	- Update
	- Delete
--->


<!---
	CREATE a record to the query. With ColdFusion 10's augmented
	queryAddRow() method, this is now a trivla exercise.
--->
<cfset queryAddRow(
	friends,
	[ 6, "Anna", 33 ]
) />


<!---
	DELETE a record from the query. With the ColdFusion query-of-
	queries, this is basically a SELECT that overrides the original
	value.
--->
<cfquery name="friends" dbtype="query">
	SELECT
		id,
		name,
		age
	FROM
		friends
	WHERE
		id != 3
</cfquery>


<!---
	UPDATE a record in the query. Since the ColdFusion query-of-query
	syntax does not support an UPDATE clause, we need to actually
	find the target row and then update it manually.
--->
<cfset targetRow = arrayFind( friends[ "id" ], 4 ) />

<!---
	Now that we have the target row, we can update the appropriate
	values with the row.
--->
<cfset friends[ "age" ][ targetRow ] = 40 />


<!--- READ a particular row given an name. --->
<cfquery name="anna" dbtype="query">
	SELECT
		id,
		name,
		age
	FROM
		friends
	WHERE
		name = 'Anna'
</cfquery>



<!--- ----------------------------------------------------- --->
<!--- ----------------------------------------------------- --->
<!--- ----------------------------------------------------- --->
<!--- ----------------------------------------------------- --->



<!---
	Let's now switch over to CFScript since function expressions
	and closures can not be defined when in a CFML tag context.
--->
<cfscript>


	// Build up our friends object. With the new ColdFusion 10
	// queryNew() enhancements, creating a query is basically the
	// same as creating collections of objects; except with an
	// object, the name-value pairs needs to be defined explicitly.
	friends = [
		{
			id: 1,
			name: "Sarah",
			age: 37
		},
		{
			id: 2,
			name: "Tricia",
			age: 42
		},
		{
			id: 3,
			name: "Kim",
			age: 25
		},
		{
			id: 4,
			name: "Joanna",
			age: 31
		},
		{
			id: 5,
			name: "Kit",
			age: 35
		}
	];


	// Now that we have our ColdFusion query object, let's
	// demonstrate how to execute the following query Query-of-Query
	// style programming:
	//
	// - Create
	// - Read
	// - Update
	// - Delete


	// CREATE a new entry in the collection. Here, we basically just
	// need to append a new object.
	arrayAppend(
		friends,
		{
			id: 6,
			name: "Anna",
			age: 33
		}
	);


	// DELETE a entry from the collection. For this, we can think of
	// the delete as being a filtering of the collection in which the
	// item we want to get rid of doesn't contian the target value.
	friends = arrayFilter(
		friends,
		function( friend ){

			// Return TRUE for all record that don't have ID = 3.
			return( friend.id != 3 );

		}
	);


	// UPDATE an entry in the collection. For this, we can use pretty
	// much the same approach since our query-of-query approach used
	// the query as an array (like our current context.)
	targetIndex = arrayFind(
		friends,
		function( friend ){

			// Return TRUE if the target ID is 4 - then we'll know
			// that we have the right index.
			return( friend.id == 4 );

		}
	);

	// Now that we have the target index, update the age value.
	friends[ targetIndex ].age = 40;


	// READ a particular entry given a name. For this, we'll have to
	// figure out which entry has the given value.
	targetIndex = arrayFind(
		friends,
		function( friend ){

			// Return TRUE if the target name is Anna.
			return( friend.name == "Anna" );

		}
	);

	// Now that we have the target index - get the entry.
	anna = friends[ targetIndex ];


</cfscript>