Commit9b5d0e1

committed

add association query one to many support

1 parentd746fb2 commit9b5d0e1Copy full SHA for 9b5d0e1

File tree

+27

-0

lines changed

+27

-0

lines changed

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -122,6 +122,17 @@ def index():`
`122`	`122`	`"email$":"%local%"`
`123`	`123`	`}`
`124`	`124`	`}`
	`125`	`+}''',`
	`126`	`+ },`
	`127`	`+ {`
	`128`	`+"label":"Array query: association query one to many",`
	`129`	`+"value":'''{`
	`130`	`+ "moment": {},`
	`131`	`+ "[]": {`
	`132`	`+ "comment": {`
	`133`	`+ "moment_id@": "moment/id"`
	`134`	`+ }`
	`135`	`+ }`
`125`	`136`	`}''',`
`126`	`137`	`},`
`127`	`138`	`{`

Lines changed: 16 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -55,6 +55,8 @@ def get(self):`
`55`	`55`	`rsp=self._get_one(key)`
`56`	`56`	`ifrsp:returnrsp`
`57`	`57`	`self._apply_vars()`
	`58`	`+exceptUliwebErrorase:`
	`59`	`+returnjson({"code":400,"msg":str(e)})`
`58`	`60`	`exceptExceptionase:`
`59`	`61`	`err="exception when handling 'apijson get': %s"%(e)`
`60`	`62`	`log.error(err)`
`@@ -230,6 +232,20 @@ def _get_array(self,key):`
`230`	`232`
`231`	`233`	`model_expr=model_param.get("@expr")`
`232`	`234`
	`235`	`+#update reference`
	`236`	`+ref_fields= []`
	`237`	`+refs= {}`
	`238`	`+forninmodel_param:`
	`239`	`+ifn[-1]=="@":`
	`240`	`+ref_fields.append(n)`
	`241`	`+col_name=n[:-1]`
	`242`	`+path=model_param[n]`
	`243`	`+refs[col_name]=self._ref_get(path)`
	`244`	`+ifref_fields:`
	`245`	`+foriinref_fields:`
	`246`	`+delmodel_param[i]`
	`247`	`+model_param.update(refs)`
	`248`	`+`
`233`	`249`	`ifmodel_expr:`
`234`	`250`	`c=self._expr(model,model_param,model_expr)`
`235`	`251`	`q=q.filter(c)`

Comments

(0)