mirror of
https://github.com/ansible/awx.git
synced 2026-01-11 18:09:57 -03:30
27 lines
864 B
Python
27 lines
864 B
Python
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))
|