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",
