summaryrefslogtreecommitdiff
path: root/scripts/2016-09-29-clean-dup-towns-pdl.py
diff options
context:
space:
mode:
authorÉtienne Loks <etienne.loks@iggdrasil.net>2020-11-12 10:16:22 +0100
committerÉtienne Loks <etienne.loks@iggdrasil.net>2021-02-28 12:15:21 +0100
commit7eff9126774f83272fcfefa3d91ab59018d1c018 (patch)
tree3fbdbb6b40497de72f8168f6863359f11bf23d29 /scripts/2016-09-29-clean-dup-towns-pdl.py
parent609a19d9e8a4210d96aab928bac9bcbd3fff5613 (diff)
downloadIshtar-7eff9126774f83272fcfefa3d91ab59018d1c018.tar.bz2
Ishtar-7eff9126774f83272fcfefa3d91ab59018d1c018.zip
Clean some old scripts
Diffstat (limited to 'scripts/2016-09-29-clean-dup-towns-pdl.py')
-rw-r--r--scripts/2016-09-29-clean-dup-towns-pdl.py51
1 files changed, 0 insertions, 51 deletions
diff --git a/scripts/2016-09-29-clean-dup-towns-pdl.py b/scripts/2016-09-29-clean-dup-towns-pdl.py
deleted file mode 100644
index ebacb2fdf..000000000
--- a/scripts/2016-09-29-clean-dup-towns-pdl.py
+++ /dev/null
@@ -1,51 +0,0 @@
-from ishtar_common.models import Town
-
-
-dup_nb = 0
-pdl = []
-DPTS = ('44', '49', '53', '72', '85')
-
-for dpt in DPTS:
- for town in Town.objects.filter(numero_insee__startswith=dpt):
- pdl.append(town.pk)
- for dup in Town.objects.filter(name=town.name).exclude(pk=town.pk):
- not_dup = False
- for d in DPTS:
- if dup.numero_insee.startswith(d):
- not_dup = True
- if not_dup:
- continue
- for item in dup.file_main.all():
- item.main_town = town
- p = item.save()
- for item in dup.parcels.all():
- item.main_town = town
- p = item.save()
- for item in dup.file.all():
- item.towns.remove(dup)
- item.towns.add(town)
- for item in dup.operations.all():
- item.towns.remove(dup)
- item.towns.add(town)
- dup_nb += 1
- dup.delete()
-
-
-print("{} items cleaned".format(dup_nb))
-
-strange = []
-for town in Town.objects.exclude(pk__in=pdl):
- if (town.file_main.count() or town.parcels.count() or town.file.count() or
- town.operations.count()):
- strange.append((town, town.file_main.count(), town.parcels.count(),
- town.file.count(), town.operations.count()))
- continue
- town.delete()
-
-
-print('* Problems with:')
-for t in strange:
- print("{}: \n\t* {} ville principale dossier\n\t* {} parcelles\n\t* {} "
- "villes pour"
- " dossier\n\t* {} ville pour operation".format(t[0], t[1], t[2],
- t[3], t[4]))