add new helper script for the rpki workshop to create web user accounts for each labuser* resource holder

svn path=/trunk/; revision=5141

1 files changed, 14 insertions, 0 deletions

diff --git a/rpkid/portal-gui/scripts/rpkigui-sync-users.py b/rpkid/portal-gui/scripts/rpkigui-sync-users.py
new file mode 100644
index 00000000..579c075b
--- /dev/null
+++ b/rpkid/portal-gui/scripts/rpkigui-sync-users.py
@@ -0,0 +1,14 @@
+"""
+Ensure that a web login exists for labuser* resource holder
+"""
+
+from django.contrib.auth.models import User
+from rpki.gui.app.models import Conf, ConfACL
+
+# mysql> select * from irdb_resourceholderca left outer join auth_user on irdb_resourceholderca.handle = auth_user.username where username=NULL;
+
+for conf in Conf.objects.filter(handle__startswith='labuser'):
+    if not User.objects.filter(username=conf.handle).exists():
+        print 'creating matching user for ' + conf.handle
+        user = User.objects.create_user(conf.handle, password='fnord')
+        ConfACL.objects.create(conf=conf, user=user)