--- 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()