/wheels/tests/model/crud/from.cfc

http://cfwheels.googlecode.com/ · ColdFusion CFScript · 25 lines · 21 code · 4 blank · 0 comment · 0 complexity · 1571bc445039e1e9e83c57fb493cf35c MD5 · raw file

  1. <cfcomponent extends="wheelsMapping.Test">
  2. <cffunction name="test_from_clause">
  3. <cfset loc.result = model("author").$fromClause(include="")>
  4. <cfset assert("loc.result IS 'FROM authors'")>
  5. </cffunction>
  6. <cffunction name="test_from_clause_with_mapped_table">
  7. <cfset model("author").table("tbl_authors")>
  8. <cfset loc.result = model("author").$fromClause(include="")>
  9. <cfset model("author").table("authors")>
  10. <cfset assert("loc.result IS 'FROM tbl_authors'")>
  11. </cffunction>
  12. <!---
  13. <cffunction name="test_from_clause_with_include">
  14. <cfset loc.result = model("author").$fromClause(include="posts")>
  15. <cfset assert("loc.result IS 'FROM authors LEFT OUTER JOIN posts ON authors.id = posts.authorid'")>
  16. </cffunction>--->
  17. <!---test:
  18. inner/outer join
  19. composite keys joining
  20. mapped pkeys--->
  21. </cfcomponent>