[Gravity] add where/having/on null query builder functions

Review Request #385 — Created Sept. 1, 2015 and submitted

Information
tardypad
Lunr
tardypad:db_where_null
Reviewers
lunr 
Gravity: add where_null query builder functions
unit tests
pprkut
pprkut 
  1. Sorry, this doesn't belong in the normal dml query builder, since that use case is already covered by the normal where() method. For example like this:

$builder->where('left', 'IS NULL');
    1. Probably like this, since the operator needs to be overridden too:

$builder->where('left', 'NULL', 'IS');

or this:

$builder->where('left', 'IS NULL', '');
    2. This is why I added this function: to avoid having to check how to force the "where" function to be used in that case.
Plus there are already some other "where" functions in there like this ("where_like", "where_in", "where_between") whose functionality could have been used within the "where" function directly as well
    3. ok, fair enough. But if you add a new special function for where, you also have to add the corresponding ones for having and on.
  2. 
  
    
 
    

 
    
  


    
 
    
 
      

  

 
    


    

 
    

    3. 




  

 
















 



 

  

   




tardypad




   

   

  

 



 















 





 

  

   




pprkut




   

   







  

 



 

  


   

   

    
 
pprkut


    
   


  

  

  



    




  1. 
 
    
  
    
   
    Ship It!
    
  
    
 
    

 
    
  


    
 
    
 
      

  

 
    


    

 
    

    2. 















  2. 
 
    
  
    
   
    
  
    
 
    

 
    
  


    
 
    
 
      

  

 
    


    

 
    

    3. 




  

 
















 



 

  

   




tardypad




   

   

  

 



 

  


   

   

    
 Review request changed

    
   


  

  

  






 

  Status:
  

  Closed (submitted)

  
 




 
Change Summary:

 
Merged into master





 


 










  

 









     

    

   

  

  

   
   Loading...