Converting from 2.10.4 to 2.11.0 where you use sites as rooms

[DanSheps]

Howdy all,

I just had to do this and figured I would provide everyone else a snippet for nbshell to do this as well.

If you use sites for anything other then sites, and you need to convert to the new locations, the script down below is going to be what you want.

First, what will this do?

1. Create a Site with a rooms parent region name
2. Create a Location with a rooms name
3. Copy over the description from that room (site) to the location
4. Move over only devices, racks, rack groups

What will this not do?

1. Not copy over custom fields (but you can edit it)
2. Not copy over any description from the parent regions to the new Site
3. Not copy over any contact, address or location information from the Site to the Location
4. Not move over power panels (do this manually first or modify to handle this)
5. Not modify Virtualization clusters (do this manually first or modify to handle this)
6. Not modify circuits (could be altered to handle this)
7. Not modify vlans (could be altered to handle this)
8. Not modify prefixes (could be altered to handle this)

What do you need to do?

1. Tag all your "room" sites as "Room"
2. Run the script
3. If you don't remove the exception at the end, remove the exception and run again if everything is clean
4. Cleanup the regions

sites = Site.objects.filter(tags__name="Room")
with transaction.atomic():
    for room in sites:
        name = f'Room: {room.name}'
        slug = f'room-{room.slug}'
        print(f'Creating: {name}|{room.slug}')
        if room.region is not None:
            try:
                region = Site.objects.get(name=room.region.name)
            except Site.DoesNotExist:
                if room.region.parent is not None:
                    parent = room.region.parent
                else:
                    parent = None
                region = Site(name=room.name, slug=room.slug, region=parent)
                new_site.save()
        location = Location(name=name, site=region, slug=slug, description=room.description)
        location.full_clean()
        location.save()
        print(f'\tCreated: {name}')
        print(f'Processing: {name}')
        for rackgroup in room.locations.all():
            print(f'\tMoving {rackgroup.name} to Site {location.site.name} and Location {location.name}')
            rackgroup.site = location.site
            rackgroup.location = location
            rackgroup.full_clean()
            rackgroup.save()
            print(f'\t\tMoved {rackgroup.name} to Site {location.site.name} and Location {location.name}')
        for rack in room.racks.all():
            print(f'\tMoving {rack.name} to Site {location.site.name} and Location {location.name}')
            rack.site = location.site
            if rack.location is None:
                rack.location = location
            rack.full_clean()
            rack.save()
            print(f'\t\tMoved {rack.name} to Site {location.site.name} and Location {location.name}')
        for device in room.devices.all():
            print(f'\tMoving {device.name} to Site {location.site.name} and Location {location.name}')
            device.site = location.site
            device.location = location
            if device.rack is None:
                device.face = ""
                device.position = None
            device.full_clean()
            device.save()
            print(f'\t\tMoved {device.name} to Site {location.site.name} and Location {location.name}')
        room.delete()
    raise Exception("Rolling Back")