def create_wcag20(wcag20): print("wcag 2.0") for principle in wcag20: principle_url = 'http://www.w3.org/TR/WCAG20/#' + principle[2] try: wcag20_principle = Principle.objects.get(num=principle[0]) print(" " + wcag20_principle.title + " (found)") wcag20_principle.title = principle[1] wcag20_principle.url = principle_url print(principle[1] + " (updated) " + principle[0]) except: wcag20_principle = Principle(num=principle[0], title=principle[1], url=principle_url) print(principle[1] + " (CREATED)") wcag20_principle.save() for guideline in principle[3]: guideline_url = 'http://www.w3.org/TR/WCAG20/#' + guideline[2] guideline_slug = 'p' + principle[0] + 'g' + str(guideline[0]) try: wcag20_guideline = Guideline.objects.get(principle=wcag20_principle, num=guideline[0]) print(" " + wcag20_guideline.title + " (found)") wcag20_guideline.title = guideline[1] wcag20_guideline.url = guideline_url wcag20_guideline.slug = guideline_slug print(" " + guideline[1] + " (updated)") except: wcag20_guideline = Guideline(principle=wcag20_principle, num=guideline[0], title=guideline[1], url=guideline_url, slug=guideline_slug) print(" " + guideline[1] + " (CREATED)") wcag20_guideline.save() for requirement in guideline[3]: requirement_url = 'http://www.w3.org/TR/WCAG20/#' + requirement[2] meet_url = 'http://www.w3.org/WAI/WCAG20/quickref/#qr-' + requirement[2] + '.html' understand_url = 'http://www.w3.org/TR/WCAG20/' + requirement[2] + '.html' requirement_slug = guideline_slug + 'sc' + str(requirement[0]) try: wcag20_requirement = SuccessCriterion.objects.get(guideline=wcag20_guideline, num=requirement[0]) print(" " + wcag20_requirement.title + " (found)") wcag20_requirement.title = requirement[1] wcag20_requirement.url = requirement_url wcag20_requirement.url_meet = meet_url wcag20_requirement.url_understand = understand_url wcag20_requirement.level = requirement[3] wcag20_requirement.slug = requirement_slug print(" " + requirement[1] + " (updated)") except: wcag20_requirement = SuccessCriterion(guideline=wcag20_guideline, num=requirement[0], title=requirement[1], url=requirement_url, url_meet=meet_url, url_understand=understand_url, level=requirement[3], slug=requirement_slug) print(" " + requirement[1] + " (CREATED)") wcag20_requirement.save()
# print(" Getting rule group: " + str(r['rule_group'])) group = RuleGroup.objects.get(rule_group_code=r['rule_group']) try: print(" Updating Rule: " + r['nls_rule_id']) rule = Rule.objects.get(rule_id=r['rule_id']) rule.scope=scope rule.category = RuleCategory.objects.get(rule_category_code=r['rule_category']) rule.group=group rule.language_dependancy=r['language_dependency'] rule.primary_property=r['primary_property'] rule.resource_properties=resource_properties rule.validation=r['validate'] rule.wcag_primary = SuccessCriterion.get_by_wcag_number(r['wcag_primary']) rule.updated_date=r['last_updated'] NodeResultMessage.objects.filter(rule=rule).delete() except ObjectDoesNotExist: print(" Creating Rule: " + r['nls_rule_id']) resource_properties = ",".join(r['resource_properties']) rule = Rule(rule_id=r['rule_id'],scope=scope,group=group,language_dependancy=r['language_dependency'],primary_property=r['primary_property'],resource_properties=resource_properties,validation=r['validate'],updated_date=r['last_updated']) rule.wcag_primary = SuccessCriterion.get_by_wcag_number(r['wcag_primary']) rule.category = RuleCategory.objects.get(rule_category_code=r['rule_category']) rule.slug = r['rule_id'].lower().replace('_', '') rule.save() rule.wcag_related.clear();
def create_wcag20(wcag20): print("wcag 2.0") for principle in wcag20: principle_url = 'http://www.w3.org/TR/WCAG20/#' + principle[2] try: wcag20_principle = Principle.objects.get(num=principle[0]) print(" " + wcag20_principle.title + " (found)") wcag20_principle.title = principle[1] wcag20_principle.url = principle_url print(principle[1] + " (updated) " + principle[0]) except: wcag20_principle = Principle(num=principle[0], title=principle[1], url=principle_url) print(principle[1] + " (CREATED)") wcag20_principle.save() for guideline in principle[3]: guideline_url = 'http://www.w3.org/TR/WCAG20/#' + guideline[2] guideline_slug = 'p' + principle[0] + 'g' + str(guideline[0]) try: wcag20_guideline = Guideline.objects.get( principle=wcag20_principle, num=guideline[0]) print(" " + wcag20_guideline.title + " (found)") wcag20_guideline.title = guideline[1] wcag20_guideline.url = guideline_url wcag20_guideline.slug = guideline_slug print(" " + guideline[1] + " (updated)") except: wcag20_guideline = Guideline(principle=wcag20_principle, num=guideline[0], title=guideline[1], url=guideline_url, slug=guideline_slug) print(" " + guideline[1] + " (CREATED)") wcag20_guideline.save() for requirement in guideline[3]: requirement_url = 'http://www.w3.org/TR/WCAG20/#' + requirement[ 2] meet_url = 'http://www.w3.org/WAI/WCAG20/quickref/#qr-' + requirement[ 2] + '.html' understand_url = 'http://www.w3.org/TR/WCAG20/' + requirement[ 2] + '.html' requirement_slug = guideline_slug + 'sc' + str(requirement[0]) try: wcag20_requirement = SuccessCriterion.objects.get( guideline=wcag20_guideline, num=requirement[0]) print(" " + wcag20_requirement.title + " (found)") wcag20_requirement.title = requirement[1] wcag20_requirement.url = requirement_url wcag20_requirement.url_meet = meet_url wcag20_requirement.url_understand = understand_url wcag20_requirement.level = requirement[3] wcag20_requirement.slug = requirement_slug print(" " + requirement[1] + " (updated)") except: wcag20_requirement = SuccessCriterion( guideline=wcag20_guideline, num=requirement[0], title=requirement[1], url=requirement_url, url_meet=meet_url, url_understand=understand_url, level=requirement[3], slug=requirement_slug) print(" " + requirement[1] + " (CREATED)") wcag20_requirement.save()
print(" Getting rule group: " + str(r['rule_group'])) group = RuleGroup.objects.get(rule_group_code=r['rule_group']) try: print(" Updating Rule: " + r['nls_rule_id']) rule = Rule.objects.get(rule_id=r['rule_id']) rule.scope=scope rule.category = RuleCategory.objects.get(rule_category_code=r['rule_category']) rule.group=group rule.language_dependancy=r['language_dependency'] rule.primary_property=r['primary_property'] rule.resource_properties=resource_properties rule.validation=r['validate'] rule.wcag_primary = SuccessCriterion.get_by_wcag_number(r['wcag_primary']) rule.updated_date=r['last_updated'] NodeResultMessage.objects.filter(rule=rule).delete() except ObjectDoesNotExist: print(" Creating Rule: " + r['nls_rule_id']) resource_properties = ",".join(r['resource_properties']) rule = Rule(rule_id=r['rule_id'],scope=scope,group=group,language_dependancy=r['language_dependency'],primary_property=r['primary_property'],resource_properties=resource_properties,validation=r['validate'],updated_date=r['last_updated']) rule.wcag_primary = SuccessCriterion.get_by_wcag_number(r['wcag_primary']) rule.category = RuleCategory.objects.get(rule_category_code=r['rule_category']) rule.slug = r['rule_id'].lower().replace('_', '') rule.save() rule.wcag_related.clear();