def test_get_form_ids_in_domain(self):
form1 = create_form_for_test(DOMAIN)
form2 = create_form_for_test(DOMAIN)
create_form_for_test('bad-domain')
# basic check
form_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(
DOMAIN, 'XFormInstance')
self.assertEqual(2, len(form_ids))
self.assertEqual({form1.form_id, form2.form_id}, set(form_ids))
# change state of form1
self.archive_form(form1, 'user1')
# check filtering by state
form_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(
DOMAIN, 'XFormArchived')
self.assertEqual(1, len(form_ids))
self.assertEqual(form1.form_id, form_ids[0])
form_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(
DOMAIN, 'XFormInstance')
self.assertEqual(1, len(form_ids))
self.assertEqual(form2.form_id, form_ids[0])
def _get_form_ids(self, domain):
if should_use_sql_backend(domain):
problem_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(
domain, 'XFormError')
else:
problem_ids = get_form_ids_by_type(domain, 'XFormError')
return problem_ids
def test_error_saving_case_during_edit(self):
form_id = uuid.uuid4().hex
case_id = uuid.uuid4().hex
submit_case_blocks([
CaseBlock.deprecated_init(case_id=case_id, update={
'a': "1"
}).as_text()
],
self.domain,
form_id=form_id)
with patch(
'corehq.form_processor.backends.sql.dbaccessors.CaseAccessorSQL.save_case',
side_effect=IntegrityError), self.assertRaises(IntegrityError):
submit_case_blocks([
CaseBlock.deprecated_init(case_id=case_id, update={
'a': "2"
}).as_text()
],
self.domain,
form_id=form_id)
[error_form_id] = FormAccessorSQL.get_form_ids_in_domain_by_type(
self.domain, 'XFormError')
self.assertNotEqual(error_form_id, form_id)
form = FormAccessorSQL.get_form(error_form_id)
self.assertTrue(form.is_error)
self.assertIsNotNone(form.get_xml())
def print_stats(self, domain, short=True, diffs_only=False):
status = get_couch_sql_migration_status(domain)
print("Couch to SQL migration status for {}: {}".format(domain, status))
db = get_diff_db(domain)
try:
diff_stats = db.get_diff_stats()
except OperationalError:
diff_stats = {}
has_diffs = False
for doc_type in doc_types():
form_ids_in_couch = set(get_form_ids_by_type(domain, doc_type))
form_ids_in_sql = set(FormAccessorSQL.get_form_ids_in_domain_by_type(domain, doc_type))
diff_count, num_docs_with_diffs = diff_stats.pop(doc_type, (0, 0))
has_diffs |= self._print_status(
doc_type, form_ids_in_couch, form_ids_in_sql, diff_count, num_docs_with_diffs, short, diffs_only
)
form_ids_in_couch = set(get_doc_ids_in_domain_by_type(
domain, "XFormInstance-Deleted", XFormInstance.get_db())
)
form_ids_in_sql = set(FormAccessorSQL.get_deleted_form_ids_in_domain(domain))
diff_count, num_docs_with_diffs = diff_stats.pop("XFormInstance-Deleted", (0, 0))
has_diffs |= self._print_status(
"XFormInstance-Deleted", form_ids_in_couch, form_ids_in_sql,
diff_count, num_docs_with_diffs, short, diffs_only
)
case_ids_in_couch = set(get_case_ids_in_domain(domain))
case_ids_in_sql = set(CaseAccessorSQL.get_case_ids_in_domain(domain))
diff_count, num_docs_with_diffs = diff_stats.pop("CommCareCase", (0, 0))
has_diffs |= self._print_status(
'CommCareCase', case_ids_in_couch, case_ids_in_sql, diff_count, num_docs_with_diffs, short, diffs_only
)
case_ids_in_couch = set(get_doc_ids_in_domain_by_type(
domain, "CommCareCase-Deleted", XFormInstance.get_db())
)
case_ids_in_sql = set(CaseAccessorSQL.get_deleted_case_ids_in_domain(domain))
diff_count, num_docs_with_diffs = diff_stats.pop("CommCareCase-Deleted", (0, 0))
has_diffs |= self._print_status(
'CommCareCase-Deleted', case_ids_in_couch, case_ids_in_sql,
diff_count, num_docs_with_diffs, short, diffs_only
)
if diff_stats:
for key, counts in diff_stats.items():
diff_count, num_docs_with_diffs = counts
has_diffs |= self._print_status(
key, set(), set(), diff_count, num_docs_with_diffs, short, diffs_only
)
if diffs_only and not has_diffs:
print(shell_green("No differences found between old and new docs!"))
return has_diffs
def print_stats(self, domain, short=True, diffs_only=False):
status = get_couch_sql_migration_status(domain)
print("Couch to SQL migration status for {}: {}".format(domain, status))
db = get_diff_db(domain)
try:
diff_stats = db.get_diff_stats()
except OperationalError:
diff_stats = {}
has_diffs = False
for doc_type in doc_types():
form_ids_in_couch = set(get_form_ids_by_type(domain, doc_type))
form_ids_in_sql = set(FormAccessorSQL.get_form_ids_in_domain_by_type(domain, doc_type))
diff_count, num_docs_with_diffs = diff_stats.pop(doc_type, (0, 0))
has_diffs |= self._print_status(
doc_type, form_ids_in_couch, form_ids_in_sql, diff_count, num_docs_with_diffs, short, diffs_only
)
form_ids_in_couch = set(get_doc_ids_in_domain_by_type(
domain, "XFormInstance-Deleted", XFormInstance.get_db())
)
form_ids_in_sql = set(FormAccessorSQL.get_deleted_form_ids_in_domain(domain))
diff_count, num_docs_with_diffs = diff_stats.pop("XFormInstance-Deleted", (0, 0))
has_diffs |= self._print_status(
"XFormInstance-Deleted", form_ids_in_couch, form_ids_in_sql,
diff_count, num_docs_with_diffs, short, diffs_only
)
case_ids_in_couch = set(get_case_ids_in_domain(domain))
case_ids_in_sql = set(CaseAccessorSQL.get_case_ids_in_domain(domain))
diff_count, num_docs_with_diffs = diff_stats.pop("CommCareCase", (0, 0))
has_diffs |= self._print_status(
'CommCareCase', case_ids_in_couch, case_ids_in_sql, diff_count, num_docs_with_diffs, short, diffs_only
)
case_ids_in_couch = set(get_doc_ids_in_domain_by_type(
domain, "CommCareCase-Deleted", XFormInstance.get_db())
)
case_ids_in_sql = set(CaseAccessorSQL.get_deleted_case_ids_in_domain(domain))
diff_count, num_docs_with_diffs = diff_stats.pop("CommCareCase-Deleted", (0, 0))
has_diffs |= self._print_status(
'CommCareCase-Deleted', case_ids_in_couch, case_ids_in_sql,
diff_count, num_docs_with_diffs, short, diffs_only
)
if diff_stats:
for key, counts in diff_stats.items():
diff_count, num_docs_with_diffs = counts
has_diffs |= self._print_status(
key, set(), set(), diff_count, num_docs_with_diffs, short, diffs_only
)
if diffs_only and not has_diffs:
print(shell_green("No differences found between old and new docs!"))
return has_diffs
def get_diff_stats(self, domain):
db = get_diff_db(domain)
diff_stats = db.get_diff_stats()
stats = {}
def _update_stats(doc_type, couch_count, sql_count):
diff_count, num_docs_with_diffs = diff_stats.pop(doc_type, (0, 0))
if diff_count or couch_count != sql_count:
stats[doc_type] = (couch_count, sql_count, diff_count,
num_docs_with_diffs)
for doc_type in doc_types():
form_ids_in_couch = len(set(get_form_ids_by_type(domain,
doc_type)))
form_ids_in_sql = len(
set(
FormAccessorSQL.get_form_ids_in_domain_by_type(
domain, doc_type)))
_update_stats(doc_type, form_ids_in_couch, form_ids_in_sql)
form_ids_in_couch = len(
set(
get_doc_ids_in_domain_by_type(domain, "XFormInstance-Deleted",
XFormInstance.get_db())))
form_ids_in_sql = len(
set(FormAccessorSQL.get_deleted_form_ids_in_domain(domain)))
_update_stats("XFormInstance-Deleted", form_ids_in_couch,
form_ids_in_sql)
case_ids_in_couch = len(set(get_case_ids_in_domain(domain)))
case_ids_in_sql = len(
set(CaseAccessorSQL.get_case_ids_in_domain(domain)))
_update_stats("CommCareCase", case_ids_in_couch, case_ids_in_sql)
if self.strict:
# only care about these in strict mode
case_ids_in_couch = len(
set(
get_doc_ids_in_domain_by_type(domain,
"CommCareCase-Deleted",
XFormInstance.get_db())))
case_ids_in_sql = len(
set(CaseAccessorSQL.get_deleted_case_ids_in_domain(domain)))
_update_stats("CommCareCase-Deleted", case_ids_in_couch,
case_ids_in_sql)
if diff_stats:
for key in diff_stats.keys():
_update_stats(key, 0, 0)
return stats
def test_get_form_ids_in_domain(self):
form1 = create_form_for_test(DOMAIN)
form2 = create_form_for_test(DOMAIN)
create_form_for_test('bad-domain')
# basic check
form_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(DOMAIN, 'XFormInstance')
self.assertEqual(2, len(form_ids))
self.assertEqual({form1.form_id, form2.form_id}, set(form_ids))
# change state of form1
FormAccessorSQL.archive_form(form1, 'user1')
# check filtering by state
form_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(DOMAIN, 'XFormArchived')
self.assertEqual(1, len(form_ids))
self.assertEqual(form1.form_id, form_ids[0])
form_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(DOMAIN, 'XFormInstance')
self.assertEqual(1, len(form_ids))
self.assertEqual(form2.form_id, form_ids[0])
def check_for_sql_forms_without_existing_domain():
missing_domains_with_forms = set()
for domain in set(
_get_all_domains_that_have_ever_had_subscriptions()) - set(
Domain.get_all_names()):
for doc_type in doc_type_to_state:
if FormAccessorSQL.get_form_ids_in_domain_by_type(
domain, doc_type):
missing_domains_with_forms |= {domain}
if missing_domains_with_forms:
mail_admins_async.delay(
'There exist SQL forms belonging to a missing domain',
six.text_type(missing_domains_with_forms))
elif _is_monday():
mail_admins_async.delay('All SQL forms belong to valid domains', '')
def _blow_away_migration(domain):
assert not should_use_sql_backend(domain)
delete_diff_db(domain)
for doc_type in doc_types():
sql_form_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(domain, doc_type)
FormAccessorSQL.hard_delete_forms(domain, sql_form_ids, delete_attachments=False)
sql_form_ids = FormAccessorSQL.get_deleted_form_ids_in_domain(domain)
FormAccessorSQL.hard_delete_forms(domain, sql_form_ids, delete_attachments=False)
sql_case_ids = CaseAccessorSQL.get_case_ids_in_domain(domain)
CaseAccessorSQL.hard_delete_cases(domain, sql_case_ids)
sql_case_ids = CaseAccessorSQL.get_deleted_case_ids_in_domain(domain)
CaseAccessorSQL.hard_delete_cases(domain, sql_case_ids)
def check_for_sql_forms_without_existing_domain():
missing_domains_with_forms = set()
for domain in set(_get_all_domains_that_have_ever_had_subscriptions()) - set(Domain.get_all_names()):
for doc_type in doc_type_to_state:
if FormAccessorSQL.get_form_ids_in_domain_by_type(domain, doc_type):
missing_domains_with_forms |= {domain}
if missing_domains_with_forms:
mail_admins_async.delay(
'There exist SQL forms belonging to a missing domain',
six.text_type(missing_domains_with_forms)
)
elif _is_monday():
mail_admins_async.delay(
'All SQL forms belong to valid domains', ''
)
def _blow_away_migration(domain):
assert not should_use_sql_backend(domain)
delete_diff_db(domain)
for doc_type in doc_types():
sql_form_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(domain, doc_type)
FormAccessorSQL.hard_delete_forms(domain, sql_form_ids, delete_attachments=False)
sql_form_ids = FormAccessorSQL.get_deleted_form_ids_in_domain(domain)
FormAccessorSQL.hard_delete_forms(domain, sql_form_ids, delete_attachments=False)
sql_case_ids = CaseAccessorSQL.get_case_ids_in_domain(domain)
CaseAccessorSQL.hard_delete_cases(domain, sql_case_ids)
sql_case_ids = CaseAccessorSQL.get_deleted_case_ids_in_domain(domain)
CaseAccessorSQL.hard_delete_cases(domain, sql_case_ids)
def get_diff_stats(self, domain):
db = get_diff_db(domain)
diff_stats = db.get_diff_stats()
stats = {}
def _update_stats(doc_type, couch_count, sql_count):
diff_count, num_docs_with_diffs = diff_stats.pop(doc_type, (0, 0))
if diff_count or couch_count != sql_count:
stats[doc_type] = (couch_count, sql_count, diff_count, num_docs_with_diffs)
for doc_type in doc_types():
form_ids_in_couch = len(set(get_form_ids_by_type(domain, doc_type)))
form_ids_in_sql = len(set(FormAccessorSQL.get_form_ids_in_domain_by_type(domain, doc_type)))
_update_stats(doc_type, form_ids_in_couch, form_ids_in_sql)
form_ids_in_couch = len(set(get_doc_ids_in_domain_by_type(
domain, "XFormInstance-Deleted", XFormInstance.get_db())
))
form_ids_in_sql = len(set(FormAccessorSQL.get_deleted_form_ids_in_domain(domain)))
_update_stats("XFormInstance-Deleted", form_ids_in_couch, form_ids_in_sql)
case_ids_in_couch = len(set(get_case_ids_in_domain(domain)))
case_ids_in_sql = len(set(CaseAccessorSQL.get_case_ids_in_domain(domain)))
_update_stats("CommCareCase", case_ids_in_couch, case_ids_in_sql)
if self.strict:
# only care about these in strict mode
case_ids_in_couch = len(set(get_doc_ids_in_domain_by_type(
domain, "CommCareCase-Deleted", XFormInstance.get_db())
))
case_ids_in_sql = len(set(CaseAccessorSQL.get_deleted_case_ids_in_domain(domain)))
_update_stats("CommCareCase-Deleted", case_ids_in_couch, case_ids_in_sql)
if diff_stats:
for key in diff_stats.keys():
_update_stats(key, 0, 0)
return stats
def print_stats(self, domain, short=True, diffs_only=False):
status = get_couch_sql_migration_status(domain)
print("Couch to SQL migration status for {}: {}".format(
domain, status))
db = open_state_db(domain, self.state_dir)
try:
diff_stats = db.get_diff_stats()
except OperationalError:
diff_stats = {}
has_diffs = False
for doc_type in doc_types():
form_ids_in_couch = set(get_form_ids_by_type(domain, doc_type))
if doc_type == "XFormInstance":
form_ids_in_couch.update(
get_doc_ids_in_domain_by_type(domain, "HQSubmission",
XFormInstance.get_db()))
form_ids_in_sql = set(
FormAccessorSQL.get_form_ids_in_domain_by_type(
domain, doc_type))
diff_count, num_docs_with_diffs = diff_stats.pop(doc_type, (0, 0))
has_diffs |= self._print_status(doc_type, form_ids_in_couch,
form_ids_in_sql, diff_count,
num_docs_with_diffs, short,
diffs_only)
form_ids_in_couch = set(
get_doc_ids_in_domain_by_type(domain, "XFormInstance-Deleted",
XFormInstance.get_db()))
form_ids_in_sql = set(
FormAccessorSQL.get_deleted_form_ids_in_domain(domain))
diff_count, num_docs_with_diffs = diff_stats.pop(
"XFormInstance-Deleted", (0, 0))
has_diffs |= self._print_status("XFormInstance-Deleted",
form_ids_in_couch, form_ids_in_sql,
diff_count, num_docs_with_diffs, short,
diffs_only)
ZERO = Counts(0, 0)
if db.has_doc_counts():
doc_counts = db.get_doc_counts()
couch_missing_cases = doc_counts.get("CommCareCase-couch",
ZERO).missing
else:
doc_counts = None
couch_missing_cases = 0
for doc_type in CASE_DOC_TYPES:
if doc_counts is not None:
counts = doc_counts.get(doc_type, ZERO)
case_ids_in_couch = db.get_missing_doc_ids(
doc_type) if counts.missing else set()
case_ids_in_sql = counts
elif doc_type == "CommCareCase":
case_ids_in_couch = set(get_case_ids_in_domain(domain))
case_ids_in_sql = set(
CaseAccessorSQL.get_case_ids_in_domain(domain))
elif doc_type == "CommCareCase-Deleted":
case_ids_in_couch = set(
get_doc_ids_in_domain_by_type(domain,
"CommCareCase-Deleted",
XFormInstance.get_db()))
case_ids_in_sql = set(
CaseAccessorSQL.get_deleted_case_ids_in_domain(domain))
else:
raise NotImplementedError(doc_type)
diff_count, num_docs_with_diffs = diff_stats.pop(doc_type, (0, 0))
has_diffs |= self._print_status(
doc_type,
case_ids_in_couch,
case_ids_in_sql,
diff_count,
num_docs_with_diffs,
short,
diffs_only,
)
if doc_type == "CommCareCase" and couch_missing_cases:
has_diffs = True
print(
shell_red("%s cases could not be loaded from Couch" %
couch_missing_cases))
if not short:
for case_id in db.get_missing_doc_ids(
"CommCareCase-couch"):
print(case_id)
if diff_stats:
for key, counts in diff_stats.items():
diff_count, num_docs_with_diffs = counts
has_diffs |= self._print_status(key, set(), set(), diff_count,
num_docs_with_diffs, short,
diffs_only)
if diffs_only and not has_diffs:
print(
shell_green("No differences found between old and new docs!"))
return has_diffs
def _get_form_ids(self, domain):
if should_use_sql_backend(domain):
problem_ids = FormAccessorSQL.get_form_ids_in_domain_by_type(domain, 'XFormError')
else:
problem_ids = get_form_ids_by_type(domain, 'XFormError')
return problem_ids
