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