diff options
| -rw-r--r-- | tools/scripts/ig-hotfix/scenarios/test4.py | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/tools/scripts/ig-hotfix/scenarios/test4.py b/tools/scripts/ig-hotfix/scenarios/test4.py new file mode 100644 index 0000000000..9198ac94f3 --- /dev/null +++ b/tools/scripts/ig-hotfix/scenarios/test4.py @@ -0,0 +1,26 @@ +from django.db import connection +from awx.main.models import InstanceGroup + +InstanceGroup.objects.filter(name__in=('green', 'yellow', 'red')).delete() + +green = InstanceGroup.objects.create(name='green') +red = InstanceGroup.objects.create(name='red') +yellow = InstanceGroup.objects.create(name='yellow') + +for ig in InstanceGroup.objects.all(): + print((ig.id, ig.name, ig.use_role_id)) + +with connection.cursor() as cursor: + cursor.execute("UPDATE main_instancegroup SET use_role_id = NULL WHERE name = 'red'") + cursor.execute(f"UPDATE main_instancegroup SET use_role_id = {green.use_role_id} WHERE name = 'yellow'") + +green.refresh_from_db() +red.refresh_from_db() +yellow.refresh_from_db() +green.save() +red.save() +yellow.save() + +print("=====================================") +for ig in InstanceGroup.objects.all(): + print((ig.id, ig.name, ig.use_role_id)) |