cubicweb/misc/scripts/ldap_change_base_dn.py
changeset 11774 51c160677afe
parent 11057 0b59724cb3f2
child 12146 d540defa0591
--- a/cubicweb/misc/scripts/ldap_change_base_dn.py	Fri Sep 30 17:38:12 2016 +0200
+++ b/cubicweb/misc/scripts/ldap_change_base_dn.py	Wed Oct 05 15:30:10 2016 +0200
@@ -14,12 +14,12 @@
 
 raw_input("Ensure you've stopped the instance, type enter when done.")
 
-for eid, extid in sql("SELECT eid, extid FROM entities WHERE source='%s'" % uri):
-    olduserdn = b64decode(extid)
+for eid, olduserdn in rql("Any X, XURI WHERE X cwuri XURI, X cw_source S, S name %(name)s",
+                          {'name': uri}):
     newuserdn = olduserdn.replace(olddn, newdn)
     if newuserdn != olduserdn:
         print(olduserdn, '->', newuserdn)
-        sql("UPDATE entities SET extid='%s' WHERE eid=%s" % (b64encode(newuserdn), eid))
+        sql("UPDATE cw_cwuser SET cw_cwuri='%s' WHERE cw_eid=%s" % (newuserdn, eid))
 
 commit()