def verify_foyer(row):
com_found = False
for dep in depts:
try:
com = Commune.objects.get(maj=row[1], code_postal__startswith=dep)
com_found = True
logging.info(u"Commune \"%s\" trouvée dans le département %s" % (row[1], dep))
break
except:
logging.info(u"Commune \"%s\" non trouvée dans le département %s" % (row[1], dep))
pass
try:
com = Commune.objects.get(maj=row[1])
logging.info(u"Commune \"%s\" trouvée en France" % row[1])
com_found = True
except:
pass
if not com_found:
logging.info(u"Commune \"%s\" non trouvée en France" % row[1])
else:
annee = AnneeScolaire.objects.get(id=row[2])
f = Foyer.objects.filter(code_foyer=row[0])
if f.exists():
f[0].commune = com
f[0].annee_scolaire = annee
f[0].save()
# foyers_exi[f[0].code_foyer] = f[0]
logging.info(u"%s mis à jour" % unicode(f[0]))
else:
newf = Foyer(code_foyer=row[0], commune=com, annee_scolaire=annee)
newf.save()
# foyers_new[newf.code_foyer] = newf
logging.info(u"%s créé" % unicode(f[0]))
def cpfoyer():
for a in Adherent.objects.all():
f = Foyer( adr1=a.adr1, adr2=a.adr2, commune=a.commune,
adhesion_id=a.adhesion_id,
annee_scolaire=a.annee_scolaire,
code_foyer=a.cfoyer)
f.save()
a.foyer = f
a.save()
