/wheels/tests/model/crud/from.cfc
ColdFusion CFScript | 25 lines | 21 code | 4 blank | 0 comment | 0 complexity | 1571bc445039e1e9e83c57fb493cf35c MD5 | raw file
Possible License(s): Apache-2.0, CPL-1.0
1<cfcomponent extends="wheelsMapping.Test"> 2 3 <cffunction name="test_from_clause"> 4 <cfset loc.result = model("author").$fromClause(include="")> 5 <cfset assert("loc.result IS 'FROM authors'")> 6 </cffunction> 7 8 <cffunction name="test_from_clause_with_mapped_table"> 9 <cfset model("author").table("tbl_authors")> 10 <cfset loc.result = model("author").$fromClause(include="")> 11 <cfset model("author").table("authors")> 12 <cfset assert("loc.result IS 'FROM tbl_authors'")> 13 </cffunction> 14<!--- 15 <cffunction name="test_from_clause_with_include"> 16 <cfset loc.result = model("author").$fromClause(include="posts")> 17 <cfset assert("loc.result IS 'FROM authors LEFT OUTER JOIN posts ON authors.id = posts.authorid'")> 18 </cffunction>---> 19 20<!---test: 21inner/outer join 22composite keys joining 23mapped pkeys---> 24 25</cfcomponent>