def resolveEntity(self, qctx, entity):
if "send" == entity: # 关联到接收者.
qctx.addJoinEntity("msg", "msg.sender", "send", "LEFT JOIN")
elif "recv" == entity: # 关联到发送者.
qctx.addJoinEntity("msg", "msg.receiver", "recv", "LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "t.userId = u.userId")
elif "g" == entity:
qctx.addEntity("Group", "g", "t.groupId = g.groupId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "pct" == entity:
qctx.addEntity(
"PrepareCourseTopic", "pct",
"pct.prepareCourseTopicId = pctr.prepareCourseTopicId")
else:
BaseQuery.resolveEntity(qctx, entity)
def resolveEntity(self, qctx, entity):
if "user" == entity:
qctx.addJoinEntity("cu", "cu.user", "user", "LEFT JOIN")
elif "channel" == entity:
qctx.addJoinEntity("cu", "cu.channel", "channel", "LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity);
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "actr.userId = u.userId")
elif "act" == entity:
qctx.addEntity("Action", "act", "act.actionId = actr.actionId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "pcs" == entity:
qctx.addEntity(
"PrepareCourseStage", "pcs",
"pct.prepareCourseStageId = pcs.prepareCourseStageId")
else:
BaseQuery.resolveEntity(qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "pc.createUserId = u.userId") #备课发起人
elif "ul" == entity:
qctx.addEntity("User", "ul", "pc.leaderId = ul.userId") #备课主备人
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "subj" == entity:
qctx.addJoinEntity("ev", "ev.metaSubject", "subj", "LEFT JOIN")
elif ("grad" == entity):
qctx.addJoinEntity("ev", "ev.grade", "grad", "LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "msubj" == entity:
qctx.addEntity("MetaSubject", "msubj",
"subj.subjectId = msubj.msubjId")
elif ("grad" == entity):
qctx.addJoinEntity("subj", "subj.gradeId", "grad", "LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "pcpc.commentedUserId = u.userId")
elif "pc" == entity:
qctx.addEntity("PrepareCourse", "pc",
"pcpc.prepareCourseId = pc.prepareCourseId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "p.userId = u.userId")
elif "stap" == entity:
qctx.addJoinEntity("p", "p.staple", "stap", "LEFT JOIN")
elif "sc" == entity:
qctx.addJoinEntity("p", "p.sysCate", "sc", "LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if entity == "photo":
qctx.addJoinEntity("cp", "cp.photo", "photo","LEFT JOIN")
elif "user" == entity:
qctx.addJoinEntity("cp", "cp.user", "user","LEFT JOIN")
elif "unit" == entity:
qctx.addJoinEntity("cp", "cp.unit", "unit","LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity);
def resolveEntity(self, qctx, entity):
if entity == "resource":
qctx.addJoinEntity("cr", "cr.resource", "resource","LEFT JOIN")
elif "user" == entity:
qctx.addJoinEntity("cr", "cr.user", "user","LEFT JOIN")
elif "unit" == entity:
qctx.addJoinEntity("cr", "cr.unit", "unit","LEFT JOIN")
else:
BaseQuery.resolveEntity(self,qctx, entity)
def resolveEntity(self, qctx, entity):
if entity == "video":
qctx.addJoinEntity("cv", "cv.video", "video","LEFT JOIN")
elif "user" == entity:
qctx.addJoinEntity("cv", "cv.user", "user","LEFT JOIN")
elif "unit" == entity:
qctx.addJoinEntity("cv", "cv.unit", "unit","LEFT JOIN")
else:
BaseQuery.resolveEntity(self,qctx, entity)
def resolveEntity(self, qctx, entity):
if "subj" == entity:
qctx.addJoinEntity("ec", "ec.metaSubject", "subj", "LEFT JOIN")
elif ("grad" == entity):
qctx.addJoinEntity("ec", "ec.grade", "grad", "LEFT JOIN")
##if "u" == entity:
# qctx.addEntity("User", "u", "ev.userId = u.userId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "pcv.userId = u.userId")
elif "pc" == entity:
qctx.addEntity("PrepareCourse", "pc",
"pcv.prepareCourseId = pc.prepareCourseId")
elif "v" == entity:
qctx.addEntity("Video", "v", "pcv.videoId = v.videoId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if entity == "subj":
qctx.addJoinEntity("u", "u.subject", "subj", "LEFT JOIN")
elif entity == "grad":
qctx.addJoinEntity("u", "u.grade", "grad", "LEFT JOIN")
elif entity == "unit":
qctx.addJoinEntity("u", "u.unit", "unit", "LEFT JOIN")
elif entity == "sc":
qctx.addJoinEntity("u", "u.sysCate", "sc", "LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if entity == "u":
qctx.addEntity("User", "u", "g.createUserId = u.userId")
#elif ("msubj" == entity):
# qctx.addEntity("MetaSubject", "msubj", "g.subjectId = msubj.msubjId")
elif entity == "subj":
qctx.addJoinEntity("g", "g.subject", "subj", "LEFT JOIN")
elif entity == "sc":
qctx.addJoinEntity("g", "g.sysCate", "sc", "LEFT JOIN")
elif ("grad" == entity):
qctx.addJoinEntity("g", "g.grade", "grad", "LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "a.userId = u.userId")
elif "subj" == entity:
qctx.addJoinEntity("a", "a.subject", "subj", "LEFT JOIN")
elif ("grad" == entity):
qctx.addJoinEntity("a", "a.grade", "grad", "LEFT JOIN")
elif ("sc" == entity):
qctx.addJoinEntity("a", "a.sysCate", "sc", "LEFT JOIN")
elif ("uc" == entity):
qctx.addJoinEntity("a", "a.userCate", "uc", "LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
if self.commentType == "aboutUser":
qctx.addEntity("User", "u", "cmt.aboutUserId = u.userId")
else:
qctx.addEntity("User", "u", "cmt.userId = u.userId")
elif "r" == entity:
qctx.addEntity("Resource", "r", "cmt.objId = r.resourceId")
elif "a" == entity:
qctx.addEntity("Article", "a", "cmt.objId = a.articleId")
elif "p" == entity:
qctx.addEntity("Photo", "p", "cmt.objId = p.photoId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "pcm.userId = u.userId")
elif "pc" == entity:
qctx.addEntity("PrepareCourse", "pc",
"pcm.prepareCourseId = pc.prepareCourseId")
elif entity == "subj":
qctx.addJoinEntity("u", "u.subject", "subj", "LEFT JOIN")
elif entity == "grad":
qctx.addJoinEntity("u", "u.grade", "grad", "LEFT JOIN")
elif entity == "unit":
qctx.addJoinEntity("u", "u.unit", "unit", "LEFT JOIN")
elif entity == "sc":
qctx.addJoinEntity("u", "u.sysCate", "sc", "LEFT JOIN")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "r.userId = u.userId")
elif ("msubj" == entity):
qctx.addEntity("MetaSubject", "msubj", "r.subjectId=msubj.msubjId")
elif "subj" == entity:
qctx.addJoinEntity("r", "r.subject", "subj", "LEFT JOIN")
elif ("grad" == entity):
qctx.addJoinEntity("r", "r.grade", "grad", "LEFT JOIN")
elif ("rt" == entity):
qctx.addJoinEntity("r", "r.resType", "rt", "LEFT JOIN")
elif ("sc" == entity):
qctx.addJoinEntity("r", "r.sysCate", "sc", "LEFT JOIN")
elif ("uc" == entity):
qctx.addJoinEntity("r", "r.userCate", "uc", "LEFT JOIN")
elif ("vc" == entity):
qctx.addEntity("ViewCount", "vc", "r.objectUuid = vc.objGUID")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "p" == entity:
qctx.addEntity("Photo", "p", "p.photoId = tr.objectId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "user" == entity:
qctx.addEntity("Group", "g", "gnews.groupId = g.groupId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "a" == entity:
qctx.addEntity("Article", "a", "a.articleId = tr.objectId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
##if "u" == entity:
# qctx.addEntity("User", "u", "ev.userId = u.userId")
#else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "vote" == entity:
qctx.addEntity("Vote", "vote", "vote.voteId = vu.voteId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
BaseQuery.resolveEntity(qctx, entity)
def resolveEntity(self, qctx, entity):
if "u" == entity:
qctx.addEntity("User", "u", "ac.userId = u.userId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
def resolveEntity(self, qctx, entity):
if "cs" == entity:
qctx.addEntity("ContentSpace", "cs",
"csa.contentSpaceId = cs.contentSpaceId")
else:
BaseQuery.resolveEntity(self, qctx, entity)
