a.LastChangedDate = a.DateBroughtIn a.ShortCode = d["File"] a.ShelterCode = str(a.ID) + " " + d["File"] a.BreedID = asm.breed_id_for_name(d["Breed"].replace(" mix", "")) a.BreedName = asm.breed_name_for_id(a.BreedID) if d["Breed"].find("mix") != -1: a.CrossBreed = 1 a.Breed2ID = 442 a.BreedName = asm.breed_name(a.BreedID, a.Breed2ID) a.BaseColourID = asm.colour_id_for_name(d["Color"]) a.Sex = asm.getsex_mf(d["Male Female"]) a.Weight = asm.cint(d["Weight"].replace("lbs", "").strip()) if a.Weight > 0: l = asm.Log() logs.append(l) l.LogTypeID = 4 # Weight l.LinkID = a.ID l.LinkType = 0 l.Date = a.DateBroughtIn l.Comments = d["Weight"] a.NeuteredDate = getdate(d["Spay Neuter Date"]) if a.NeuteredDate is not None: a.Neutered = 1 a.HealthProblems = d["Medical Notes"] create_vacc("Rabies", d["Rabies Date"], d["Rabies Renewal"]) create_vacc("Distemper", d["Distemper Parvo Date"], d["Distemper Parvo Renewal"]) create_vacc("Lepto", d["Lepto Date"], d["Lepto Renewal"])
"19": "44 - None", "20": "45 - Permanent" } print "DELETE FROM logtype WHERE ID >= 100;" for k, v in treatments.iteritems(): print "INSERT INTO logtype (ID, LOGTYPENAME, LOGTYPEDESCRIPTION) VALUES ( %s, '%s', '');" % ( int(k) + 100, v) reader = csv.reader(open("data/noah/tblAnimalTreatment-csv.csv", "r"), dialect="excel") for row in reader: # Skip the header if row[LNGANIMALID] == "lngAnimalID": continue a = findanimal(row[LNGANIMALID]) if a is None: continue l = asm.Log(nextlogid) logs.append(l) nextlogid += 1 l.LogTypeID = int(row[LNGTREATMENTTYPEID]) + 100 l.LinkID = a.ID l.LinkType = 0 l.Date = a.DateBroughtIn LNGINJURYID = 0 LNGANIMALID = 1 LNGINJURYTYPEID = 2 injuries = { "1": "1 - Hit by a vehicle", "2": "2 - Internal injuries", "3": "3 - Head injuries",