def descending_query(order):
result = es.CaseES().domain(domain).sort(
'server_modified_on', desc=order).size(1).run().raw_hits
if len(result) == 0:
return None
else:
return dateutil.parser.parse(result[0]['_source']['server_modified_on'])
def _compare_cases(domain, doc_type):
sql_ids = set()
for db_alias in get_sql_db_aliases_in_use():
queryset = CommCareCaseSQL.objects.using(db_alias) \
.filter(domain=domain, deleted=False).values_list('case_id', flat=True)
sql_ids.update(list(queryset))
es_ids = set(es.CaseES().remove_default_filters().filter(
es.filters.term('domain', domain)).get_ids())
return sql_ids - es_ids