+
−"""turn a pyro source into a datafeed source
+
−
+
−Once this script is run, execute c-c db-check to cleanup relation tables.
+
−"""
+
−import sys
+
−from collections import defaultdict
+
−from logilab.common.shellutils import generate_password
+
−
+
−try:
+
−    source_name, = __args__
+
−    source = repo.sources_by_uri[source_name]
+
−except ValueError:
+
−    print('you should specify the source name as script argument (i.e. after --'
+
−          ' on the command line)')
+
−    sys.exit(1)
+
−except KeyError:
+
−    print '%s is not an active source' % source_name
+
−    sys.exit(1)
+
−
+
−# check source is reachable before doing anything
+
−if not source.get_connection().cnx:
+
−    print '%s is not reachable. Fix this before running this script' % source_name
+
−    sys.exit(1)
+
−
+
−raw_input('Ensure you have shutdown all instances of this application before continuing.'
+
−          ' Type enter when ready.')
+
−
+
−system_source = repo.system_source
+
−
+
−from datetime import datetime
+
−from cubicweb.server.edition import EditedEntity
+
−
+
−
+
−session.mode = 'write' # hold on the connections set
+
−
+
−print '******************** backport entity content ***************************'
+
−
+
−todelete = defaultdict(list)
+
−extids = set()
+
−duplicates = []
+
−for entity in rql('Any X WHERE X cw_source S, S eid %(s)s', {'s': source.eid}).entities():
+
−    etype = entity.cw_etype
+
−    if not source.support_entity(etype):
+
−        print "source doesn't support %s, delete %s" % (etype, entity.eid)
+
−        todelete[etype].append(entity)
+
−        continue
+
−    try:
+
−        entity.complete()
+
−    except Exception:
+
−        print '%s %s much probably deleted, delete it (extid %s)' % (
+
−            etype, entity.eid, entity.cw_metainformation()['extid'])
+
−        todelete[etype].append(entity)
+
−        continue
+
−    print 'get back', etype, entity.eid
+
−    entity.cw_edited = EditedEntity(entity, **entity.cw_attr_cache)
+
−    if not entity.creation_date:
+
−        entity.cw_edited['creation_date'] = datetime.now()
+
−    if not entity.modification_date:
+
−        entity.cw_edited['modification_date'] = datetime.now()
+
−    if not entity.upassword:
+
−        entity.cw_edited['upassword'] = generate_password()
+
−    extid = entity.cw_metainformation()['extid']
+
−    if not entity.cwuri:
+
−        entity.cw_edited['cwuri'] = '%s/?dn=%s' % (
+
−            source.urls[0], extid.decode('utf-8', 'ignore'))
+
−    print entity.cw_edited
+
−    if extid in extids:
+
−        duplicates.append(extid)
+
−        continue
+
−    extids.add(extid)
+
−    system_source.add_entity(session, entity)
+
−    sql("UPDATE entities SET source='system' "
+
−        "WHERE eid=%(eid)s", {'eid': entity.eid})
+
−
+
−# only cleanup entities table, remaining stuff should be cleaned by a c-c
+
−# db-check to be run after this script
+
−if duplicates:
+
−    print 'found %s duplicate entries' % len(duplicates)
+
−    from pprint import pprint
+
−    pprint(duplicates)
+
−
+
−print len(todelete), 'entities will be deleted'
+
−for etype, entities in todelete.iteritems():
+
−    print 'deleting', etype, [e.login for e in entities]
+
−    system_source.delete_info_multi(session, entities, source_name)
+
−
+
−
+
−
+
−source_ent = rql('CWSource S WHERE S eid %(s)s', {'s': source.eid}).get_entity(0, 0)
+
−source_ent.cw_set(type=u"ldapfeed", parser=u"ldapfeed")
+
−
+
−
+
−if raw_input('Commit?') in 'yY':
+
−    print 'committing'
+
−    commit()
+
−else:
+
−    rollback()
+
−    print 'rolled back'
+
−