def run(b, c): b.convictions += 1 insert.row(b.cur, 'ConvictionRecord', ( b.convictions, b.subjects, get.text(c, 'ActivityDate'), get.text(c, 'ConvictionCourt/OrganizationName'), get.text(c, 'ConvictionCourt/OrganizationORIID/ID'), get.text(c, 'ControllingAgency/OrganizationName'), get.text(c, 'ControllingAgency/OrganizationORIID/ID'), get.text(c, 'ControllingAgency/OriginatingAgencyCaseNumber/ID'), get.text(c, 'AssignedCustodialAgency/OrganizationName'), get.text(c, 'AssignedProbationAgency/OrganizationName'), get.text(c, 'StatementOfDisagreement'), get.text(c, 'ConvictionCharge/ChargeClassification/ChargeApplicabilityText'), get.text(c, 'ConvictionCharge/ChargeStatute/StatuteCodeID/ID'), get.text(c, 'ConvictionCharge/ChargeStatute/StatuteDescriptionText'), get.text(c, 'ConvictionCharge/ConvictionCourtCase/CaseTrackingID/ID'), get.text(c, 'ConvictionCharge/ChargeDisposition/ChargeDispositionVerdict/VerdictDescriptionText'), get.text(c, 'ConvictionCharge/ChargeDisposition/PronouncedFine/ObligationAmount'), get.text(c, 'ConvictionCharge/ChargeDisposition/AssessmentFee/ObligationAmount'), get.text(c, 'ConvictionCharge/ChargeDisposition/StayedFine/ObligationAmount'), get.text(c, 'ConvictionCharge/ChargeDisposition/Restitution/ObligationAmount'), get.text(c, 'ConvictionCharge/ChargeDisposition/PronouncedSentence/TermDuration'), get.text(c, 'ConvictionCharge/ChargeDisposition/ProbationalSentence/TermDuration'), get.text(c, 'ConvictionCharge/ChargeDisposition/ConditionalConfinement/TermDuration'), get.text(c, 'ConvictionCharge/ConvictionLevel')))
def run(b, Alias): b.subjects += 1 for Name in Alias.findall('PersonName'): insert.row(b.cur, 'SubjectName', (b.subjects, get.text(Name, 'PersonGivenName'), get.text(Name, 'PersonMiddleName'), get.text(Name, 'PersonSurName'))) for BDate in Alias.findall('PersonBirthDate'): insert.row(b.cur, 'SubjectBirthDate', (b.subjects, get.text(BDate)))
def run(b, c): b.convictions += 1 insert.row(b.cur, 'ConvictionRecord', ( b.convictions, b.subjects, get.text(c, 'ActivityDate'), get.text(c, 'ConvictionCourt/OrganizationName'), get.text(c, 'ConvictionCourt/OrganizationORIID/ID'), get.text(c, 'ControllingAgency/OrganizationName'), get.text(c, 'ControllingAgency/OrganizationORIID/ID'), get.text(c, 'ControllingAgency/OriginatingAgencyCaseNumber/ID'), get.text(c, 'AssignedCustodialAgency/OrganizationName'), get.text(c, 'AssignedProbationAgency/OrganizationName'), get.text(c, 'StatementOfDisagreement'), get.text( c, 'ConvictionCharge/ChargeClassification/ChargeApplicabilityText'), get.text(c, 'ConvictionCharge/ChargeStatute/StatuteCodeID/ID'), get.text(c, 'ConvictionCharge/ChargeStatute/StatuteDescriptionText'), get.text(c, 'ConvictionCharge/ConvictionCourtCase/CaseTrackingID/ID'), get.text( c, 'ConvictionCharge/ChargeDisposition/ChargeDispositionVerdict/VerdictDescriptionText' ), get.text( c, 'ConvictionCharge/ChargeDisposition/PronouncedFine/ObligationAmount' ), get.text( c, 'ConvictionCharge/ChargeDisposition/AssessmentFee/ObligationAmount' ), get.text( c, 'ConvictionCharge/ChargeDisposition/StayedFine/ObligationAmount'), get.text( c, 'ConvictionCharge/ChargeDisposition/Restitution/ObligationAmount'), get.text( c, 'ConvictionCharge/ChargeDisposition/PronouncedSentence/TermDuration' ), get.text( c, 'ConvictionCharge/ChargeDisposition/ProbationalSentence/TermDuration' ), get.text( c, 'ConvictionCharge/ChargeDisposition/ConditionalConfinement/TermDuration' ), get.text(c, 'ConvictionCharge/ConvictionLevel')))
def run(b, s): b.supervisions += 1 insert.row(b.cur, 'SupervisionRecord', (b.supervisions, b.subjects, get.text(s, 'ActivityDate'), get.text(s, 'SupervisionAgency/OrganizationName'), get.text(s, 'SupervisionAgency/OrganizationORIID/ID'), get.text(s, 'SupervisionChargeDisposition/StatusDescriptionText'), get.text(s, 'SupervisionConvictionCharge/ChargeClassification'), get.text(s, 'SupervisionConvictionCharge/ChargeStatute/StatuteCodeID/ID'), get.text(s, 'SupervisionConvictionCharge/ChargeStatute/StatuteDescriptionText'), get.text(s, 'SupervisionConvictionCharge/OriginatingAgencyCaseNumber/ID'), '/n'.join(get.Alltext(s, 'SupervisionConvictionCharge/Comment'))))