od.DonationTypeID = 1 pm = getsbpaymentmethod(row["paymentmethod"]) od.DonationPaymentID = 1 if pm.find("Check") != -1: od.DonationPaymentID = 2 if pm.find("Credit Card") != -1: od.DonationPaymentID = 3 if pm.find("Debit Card") != -1: od.DonationPaymentID = 4 od.Date = getdate(row["receiptdate"]) od.OwnerID = findowner(row["recnum"]).ID od.Donation = asm.get_currency(row["Amount"]) comments = "Check No: " + row["chequeno"] comments += "\nMethod: " + pm comments += "\n" + row["NotesToPrint"] od.Comments = comments print od # Now that everything else is done, output stored records print "DELETE FROM primarykey;" print "DELETE FROM configuration WHERE ItemName Like 'VariableAnimalDataUpdated';" for a in animals: print a for o in owners: print o for m in movements: print m asm.stderr_summary(animals=animals, owners=owners, movements=movements) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
for k, v in asm.locations.iteritems(): print v for a in animals: print a for am in animalmedicals: print am for at in animaltests: print at for av in animalvaccinations: print av for o in owners: print o for o in ownerdonations: print o for m in movements: print m for l in logs: print l asm.stderr_summary(animals=animals, animaltests=animaltests, animalmedicals=animalmedicals, animalvaccinations=animalvaccinations, logs=logs, owners=owners, ownerdonations=ownerdonations, movements=movements) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
elif d["Status"] == "Transferred Out": m = asm.Movement() m.AnimalID = a.ID m.OwnerID = uo.ID m.MovementType = 3 m.MovementDate = a.DateBroughtIn m.Comments = description a.Archived = 1 a.ActiveMovementDate = m.MovementDate a.ActiveMovementID = m.ID a.ActiveMovementType = 3 a.LastChangedDate = m.MovementDate movements.append(m) # Get the current image for this animal from PetFinder if it is on shelter if a.Archived == 0 and PETFINDER_ID != "" and pf != "": asm.petfinder_image(pf, a.ID, a.AnimalName) # Now that everything else is done, output stored records for a in animals: print(a) for o in owners: print(o) for m in movements: print(m) asm.stderr_summary(animals=animals, owners=owners, movements=movements) print("DELETE FROM configuration WHERE ItemName LIKE 'DBView%';") print("COMMIT;")
m = asm.Movement() m.AnimalID = a.ID m.OwnerID = uo.ID m.MovementType = 1 m.MovementDate = a.DateBroughtIn a.Archived = 1 a.ActiveMovementID = m.ID a.ActiveMovementDate = a.DateBroughtIn a.ActiveMovementType = 1 movements.append(m) # Now that everything else is done, output stored records for k, v in asm.locations.iteritems(): print v for a in animals: print a for av in animalvaccinations: print av for o in owners: print o for m in movements: print m asm.stderr_summary(animals=animals, animalvaccinations=animalvaccinations, owners=owners, movements=movements) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
print v if len(asm.jurisdictions.keys()) > 0: print "DELETE FROM jurisdiction;" for k, v in asm.jurisdictions.iteritems(): print v for a in animals: print a for at in animaltests: print at for av in animalvaccinations: print av for o in owners: print o for m in movements: print m for l in logs: print l for ac in animalcontrol: print ac asm.stderr_summary(animals=animals, animalcontrol=animalcontrol, animaltests=animaltests, animalvaccinations=animalvaccinations, logs=logs, owners=owners, movements=movements) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
comments = asm.nulltostr(c["BITEMEMO"]) comments += "\nReport By: %s" % c["REPORTBY"] comments += "\nOfficer: %s" % c["OFFICER"] comments += "\nSeverity: %s" % c["SEVERITY"] comments += "\nOwner Statement: %s" % c["OWNERSTMT"] if type(comments) == unicode: comments = comments.encode("ascii", "xmlcharrefreplace") ac.CallNotes = comments if c["ANIMALNO"] != "Unspecified" and ppa.has_key(c["ANIMALNO"]): animalcontrolanimal.append("INSERT INTO animalcontrolanimal (AnimalID, AnimalControlID) VALUES (%d, %d);" % (ppa[c["ANIMALNO"]].ID, ac.ID)) for a in animals: print a for o in owners: print o #for m in movements: # print m for od in ownerdonation: print od for ol in ownerlicence: print ol for ac in animalcontrol: print ac for aca in animalcontrolanimal: print aca asm.stderr_summary(animals=animals, owners=owners, animalcontrol=animalcontrol, ownerlicences=ownerlicence, ownerdonations=ownerdonation) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
if c["FOLLOW_UP"] != "": comments += "\nFollowup: %s" % c["FOLLOW_UP"] if c["OFFICER_ID"] != "": comments += "\nOfficer: %s" % c["OFFICER_ID"] if c["CITATION"] != "": comments += "\nCitation: %s" % c["CITATION"] if c["CMPL_TEXT"] != "": comments += "\nCompleted: %s" % c["CMPL_TEXT"] if type(comments) == unicode: comments = comments.encode("ascii", "xmlcharrefreplace") ac.CallNotes = comments for a in animals: print a for o in owners: print o for m in movements: print m for od in ownerdonations: print od for ol in ownerlicences: print ol for ac in animalcontrol: print ac asm.stderr_summary(animals=animals, owners=owners, movements=movements, ownerlicences=ownerlicences, ownerdonations=ownerdonations, animalcontrol=animalcontrol) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
if asm.getdate_yyyymmdd(row["LICENSEEFF"]) is None: continue ol = asm.OwnerLicence() ownerlicences.append(ol) ol.AnimalID = a.ID ol.OwnerID = o.ID ol.IssueDate = asm.getdate_yyyymmdd(row["LICENSEEFF"]) ol.ExpiryDate = asm.getdate_yyyymmdd(row["LICENSEEXP"]) ol.LicenceNumber = asm.fw(row["LICENSE"]) ol.LicenceTypeID = 2 # Unaltered dog if row["LICENSEFIX"] == "1": ol.LicenceTypeID = 1 # Altered dog # Now that everything else is done, output stored records for a in animals: print a for av in animalvaccinations: print av for o in owners: print o for m in movements: print m for ol in ownerlicences: print ol asm.stderr_summary(animals=animals, animalvaccinations=animalvaccinations, owners=owners, movements=movements, ownerlicences=ownerlicences) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
if arkspecies.has_key(c["C_SPECIES"]): ac.SpeciesID = arkspecies[c["C_SPECIES"]] ac.Sex = asm.getsex_mf(c["C_SEX"]) comments = "" comments = "Problem: %s" % c["PROBLEM"] if c["FOLLOW_UP"] != "": comments += "\nFollowup: %s" % c["FOLLOW_UP"] if c["OFFICER_ID"] != "": comments += "\nOfficer: %s" % c["OFFICER_ID"] if c["CITATION"] != "": comments += "\nCitation: %s" % c["CITATION"] if c["CMPL_TEXT"] != "": comments += "\nCompleted: %s" % c["CMPL_TEXT"] if type(comments) == unicode: comments = comments.encode("ascii", "xmlcharrefreplace") ac.CallNotes = comments for a in animals: print a for o in owners: print o for m in movements: print m for od in ownerdonations: print od for ol in ownerlicences: print ol for ac in animalcontrol: print ac asm.stderr_summary(animals=animals, owners=owners, movements=movements, ownerlicences=ownerlicences, ownerdonations=ownerdonations, animalcontrol=animalcontrol) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
od = asm.OwnerDonation() ownerdonations.append(od) od.OwnerID = o.ID od.Donation = int(d.donation_value * 100) od.Date = d.date_from od.DonationTypeID = 10 # RGT od.DonationPaymentID = 1 # Cash # Now that everything else is done, output stored records for k, v in asm.locations.iteritems(): print v for a in animals: print a for o in owners: print o for od in ownerdonations: print od for m in movements: print m for l in logs: print l asm.stderr_summary(animals=animals, logs=logs, ownerdonations=ownerdonations, owners=owners, movements=movements) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
ac.DispatchTown = d["City"] ac.DispatchCounty = d["State"] ac.DispatchPostcode = d["Zip Code"] ac.DispatchedACO = d["ACO Assigned"] comments = "Case Number: %s" % d["Case Number"] comments += "\nSubject: %s" % d["Subject of Call"] comments += "\nACO: %s" % d["ACO Assigned"] comments += "\nPriority: %s" % d["Priority"] comments += "\nEnding Status: %s" % d["Ending Status"] comments += "\nDispatcher: %s" % d["Dispatcher"] comments += "\nLocation Notes: %s" % d["Location Notes"] comments += "\nDispatch Notes: %s" % d["Dispatch Notes"] ac.CallNotes = comments for a in animals: print(a) for o in owners: print(o) for ol in ownerlicence: print(ol) for ac in animalcontrol: print(ac) asm.stderr_summary(animals=animals, owners=owners, animalcontrol=animalcontrol, ownerlicences=ownerlicence) print("DELETE FROM configuration WHERE ItemName LIKE 'DBView%';") print("COMMIT;")
for a in animals: print a for am in animalmedicals: print am for av in animalvaccinations: print av for l in logs: print l for o in owners: print o for m in movements: print m for ol in ownerlicences: print ol for ac in animalcontrol: print ac for ac in animalcontrolanimals: print ac asm.stderr_summary(animals=animals, animalmedicals=animalmedicals, animalvaccinations=animalvaccinations, logs=logs, owners=owners, movements=movements, ownerlicences=ownerlicences, animalcontrol=animalcontrol) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
if tperformed: at = asm.AnimalTest() animaltests.append(at) at.AnimalID = a.ID at.DateRequired = tperformed at.DateOfTest = tperformed at.TestTypeID = "COALESCE((SELECT ID FROM testtype WHERE TestName LIKE '%%%s%%' LIMIT 1), 1)" % ttype asmresult = 0 if tresult == "Negative": asmresult = 1 if tresult == "Positive": asmresult = 2 at.TestResultID = asmresult + 1 at.Comments = tcomments # Now that everything else is done, output stored records for a in animals: print a for at in animaltests: print at for av in animalvaccinations: print av for m in movements: print m asm.stderr_summary(animals=animals, animaltests=animaltests, animalvaccinations=animalvaccinations, movements=movements) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"
ol.OwnerID = o.ID ol.AnimalID = a.ID ol.LicenceTypeID = asm.licencetype_from_db(lt) licnum = "%s%s-%s" % (lt[0:3].upper(), lt[len(lt) - 2:], row["Licence Number"]) if numused.has_key(licnum): licnum = licnum + "-2" if numused.has_key(licnum) and licnum.endswith("-2"): licnum = licnum[0:len(licnum) - 2] + "-3" ol.LicenceNumber = licnum numused[licnum] = "X" ol.LicenceFee = asm.get_currency(row["Fee"]) ol.IssueDate = asm.getdate_ddmmyyyy(row["Issued"]) ol.ExpiryDate = asm.getdate_ddmmyyyy(row["Expired"]) if ol.IssueDate is None: ol.IssueDate = asm.today() if ol.ExpiryDate is None: ol.ExpiryDate = asm.today() ol.Comments = row["Comments"] # Now that everything else is done, output stored records for a in animals: print a for o in owners: print o for ol in ownerlicences: print ol asm.stderr_summary(animals=animals, ownerlicences=ownerlicences, owners=owners) print "DELETE FROM configuration WHERE ItemName LIKE 'DBView%';" print "COMMIT;"