Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cffunction name="shouldVolunteerSearchGetOnlyVolunteers" mxunit:transaction="rollback" access="public" returntype="void" output="no"
- hint="A search for Volunteers should get only Volunteers.">
- <cfset var qVolunteers = 0>
- <cfset var qApplicants = 0>
- <cfset var qResponseVolunteers = 0>
- <cfset var sData = StructNew()>
- <cfset var TestID = 0>
- <!--- First get some volunteers so we can create test response data --->
- <cfquery name="qVolunteers" datasource="#variables.DataMgr.getDatasource()#">
- SELECT TOP 5 VolunteerID
- FROM volVolunteers
- WHERE 1 = 1
- AND isApproved = 1
- AND (isDeleted = 0 OR isDeleted IS NULL)
- </cfquery>
- <!--- Now get some applicants to corrupt the data for testing --->
- <cfquery name="qApplicants" datasource="#variables.DataMgr.getDatasource()#">
- SELECT TOP 5 VolunteerID
- FROM volVolunteers
- WHERE 1 = 1
- AND isApproved IS NULL
- AND (isDeleted = 0 OR isDeleted IS NULL)
- </cfquery>
- <cfset debug(qVolunteers)>
- <cfset debug(qApplicants)>
- <!--- Create some test records --->
- <cfset sData["ResponseID"] = saveTestRecord(variables.DisasterOpportunities)>
- <cfset sData["VolunteerID"] = "">
- <cfoutput query="qVolunteers">
- <cfset debug(VolunteerID)>
- <!--- <cfset sData["VolunteerID"] = VolunteerID> --->
- <cfset StructUpdate(sData,"VolunteerID",VolunteerID)>
- <cfset debug(sData)>
- <cfset TestID = saveTestRecord(variables.DisasterPrep,sData)>
- </cfoutput>
- <cfoutput query="qApplicants">
- <cfset debug(VolunteerID)>
- <!--- <cfset sData["VolunteerID"] = VolunteerID> --->
- <cfset StructUpdate(sData,"VolunteerID",VolunteerID)>
- <cfset debug(sData)>
- <cfset TestID = saveTestRecord(variables.DisasterPrep,sData)>
- </cfoutput>
- <cfset qResponseVolunteers = variables.DisasterPrep.getVolunteers(Responses="#sData['ResponseID']#",Status="Volunteer")>
- <cfset assertTrue(qResponseVolunteers.RecordCount,"No responses were retrieved.")>
- <!--- None of our results should have isApproved equal to anything but 1 --->
- <cfoutput query="qResponseVolunteers">
- <cfset assertTrue(isapproved EQ 1,"Not all responses were for volunteers.")>
- </cfoutput>
- </cffunction>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement