Advertisement
Guest User

Untitled

a guest
Jul 18th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <cffunction name="shouldVolunteerSearchGetOnlyVolunteers" mxunit:transaction="rollback" access="public" returntype="void" output="no"
  2.             hint="A search for Volunteers should get only Volunteers.">
  3.    
  4.     <cfset var qVolunteers = 0>
  5.     <cfset var qApplicants = 0>
  6.     <cfset var qResponseVolunteers = 0>
  7.     <cfset var sData = StructNew()>
  8.     <cfset var TestID = 0>
  9.  
  10.     <!--- First get some volunteers so we can create test response data --->
  11.     <cfquery name="qVolunteers" datasource="#variables.DataMgr.getDatasource()#">
  12.     SELECT  TOP 5 VolunteerID
  13.     FROM    volVolunteers
  14.     WHERE   1 = 1  
  15.         AND isApproved = 1
  16.         AND (isDeleted = 0 OR isDeleted IS NULL)
  17.     </cfquery>
  18.  
  19.     <!--- Now get some applicants to corrupt the data for testing --->
  20.     <cfquery name="qApplicants" datasource="#variables.DataMgr.getDatasource()#">
  21.     SELECT  TOP 5 VolunteerID
  22.     FROM    volVolunteers
  23.     WHERE   1 = 1  
  24.         AND isApproved IS NULL
  25.         AND (isDeleted = 0 OR isDeleted IS NULL)
  26.     </cfquery>
  27.     <cfset debug(qVolunteers)>
  28.     <cfset debug(qApplicants)>
  29.     <!--- Create some test records --->
  30.     <cfset sData["ResponseID"] = saveTestRecord(variables.DisasterOpportunities)>
  31.     <cfset sData["VolunteerID"] = "">
  32.     <cfoutput query="qVolunteers">
  33.     <cfset debug(VolunteerID)>
  34.         <!--- <cfset sData["VolunteerID"] = VolunteerID> --->
  35.         <cfset StructUpdate(sData,"VolunteerID",VolunteerID)>
  36.         <cfset debug(sData)>
  37.         <cfset TestID = saveTestRecord(variables.DisasterPrep,sData)>
  38.     </cfoutput>
  39.     <cfoutput query="qApplicants">
  40.     <cfset debug(VolunteerID)>
  41.         <!--- <cfset sData["VolunteerID"] = VolunteerID> --->
  42.         <cfset StructUpdate(sData,"VolunteerID",VolunteerID)>
  43.         <cfset debug(sData)>
  44.         <cfset TestID = saveTestRecord(variables.DisasterPrep,sData)>
  45.     </cfoutput>
  46.    
  47.     <cfset qResponseVolunteers = variables.DisasterPrep.getVolunteers(Responses="#sData['ResponseID']#",Status="Volunteer")>
  48.     <cfset assertTrue(qResponseVolunteers.RecordCount,"No responses were retrieved.")>
  49.    
  50.     <!--- None of our results should have isApproved equal to anything but 1 --->
  51.     <cfoutput query="qResponseVolunteers">
  52.         <cfset assertTrue(isapproved EQ 1,"Not all responses were for volunteers.")>
  53.     </cfoutput>
  54.    
  55. </cffunction>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement