def resolve(self, query, **kwargs):
if self._key != "fv" and self._key != "av":
return query
if self._key == 'av':
is_affected = True
else:
is_affected = False
alias = query.get_model_alias(TaskVersion.get_modelname())
if alias is None:
query.model(TaskVersion.get_modelname(), alias="b", join="inner", on="a.uid=b.task_id")
query.filter("b.is_affected =", is_affected)
query.filter("b.version_id =", self._value)
return query
def delete_taskversions(self, modifier_id, task_id=None, version_id=None, is_affected=None):
if task_id is None and version_id is None:
raise CoreError("the task_id and version_id can't be None at the same time.")
query = TaskVersion.all()
if task_id is not None:
query.filter("task_id =", task_id)
if version_id is not None:
query.filter("version_id =", version_id)
if is_affected != None:
query.filter("is_affected =", is_affected)
return query.delete(modifier_id)
def fetch_taskversions(self, task_id, is_affected):
query = TaskVersion.all()
query.filter("task_id =", task_id)
query.filter("is_affected =", is_affected)
return query.fetch()
def has_taskversion(self, task_id, version_id, is_affected):
query = TaskVersion.all()
query.filter("task_id =", task_id)
query.filter("version_id =", version_id)
query.filter("is_affected =", is_affected)
return query.count() > 0
def delete_taskversion(self, task_id, version_id, is_affected, modifier_id):
query = TaskVersion.all()
query.filter("task_id =", task_id)
query.filter("version_id =", version_id)
query.filter("is_affected =", is_affected)
return query.delete(modifier_id)
