diff options
Diffstat (limited to 'scripts/2016-09-29-clean-dup-towns-pdl.py')
| -rw-r--r-- | scripts/2016-09-29-clean-dup-towns-pdl.py | 51 | 
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]))  | 
