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

 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>