phantom42 · December 14, 2015 02:49 · phantom42 · Dec 6, 2013
diff --git a/__useful regular expressions.txt b/__useful regular expressions.txt
 -- collection of useful regular expressions
diff --git a/camelCase to word conversion- coldfusion.cfm b/camelCase to word conversion- coldfusion.cfm
 <!--- this converts camelSpaceNamedVars to split words with spaces --->
 #rereplace(rereplace("camelCaseString","(^[a-z])","\u\1"),"([A-Z])"," \1","all")#
diff --git a/select from.txt b/select from.txt
 // searches for select statements
 select[\s\w=,<>!\(\)'\-|\.\*\d]*from\s+?WF_QUEUE_TYPE

 // search for complex select statements
 select[\s\w=,<>!\(\)'\-|\.\*\d]*from\s+?[\s\w=,<>!\(\)'\-|\.\*\d]*psb_users
diff --git a/sql insert statements.txt b/sql insert statements.txt
 //searches for inserts to a specific column in a specific table
 //replace "update" "personnel" "eligible_epass" as necessary
 // no need for a separate/additional version for table aliasing 

 insert\s+?into\s+?personnel\s+?[\s\w=,<>!\(\)'\-]*eligible_epass
diff --git a/sql update statement search.txt b/sql update statement search.txt
 //searches for updates to a specific column in a specific table
 //replace "update" "personnel" "eligible_epass" as necessary

 update\s+?personnel\s+?set[\s\w=,<>!\(\)'\-\+\*\%]*eligible_epass

 // searches for updates to a specific column in a specific table with optional table alias
 update\s+?personnel\s+?[\w\s]*?set[\s\w=,<>!\(\)'\-\+\*\%]*eligible_epass
	<!--- this converts camelSpaceNamedVars to split words with spaces --->
	#rereplace(rereplace("camelCaseString","(^[a-z])","\u\1"),"([A-Z])"," \1","all")#
	// searches for select statements
	select[\s\w=,<>!\(\)'\-\|\.\\d]from\s+?WF_QUEUE_TYPE

	// search for complex select statements
	select[\s\w=,<>!\(\)'\-\|\.\\d]from\s+?[\s\w=,<>!\(\)'\-\|\.\\d]psb_users
	//searches for updates to a specific column in a specific table
	//replace "update" "personnel" "eligible_epass" as necessary

	update\s+?personnel\s+?set[\s\w=,<>!\(\)'\-\+\\%]eligible_epass

	// searches for updates to a specific column in a specific table with optional table alias
	update\s+?personnel\s+?[\w\s]?set[\s\w=,<>!\(\)'\-\+\\%]*eligible_epass