misc/scripts/drop_external_entities.py
author Pierre-Yves David <pierre-yves.david@logilab.fr>
Fri, 01 Jul 2011 11:27:20 +0200
branchstable
changeset 7594 d177c0755b10
parent 6636 dbc9cce53c11
child 7398 26695dd703d8
permissions -rw-r--r--
[cwc shell] add ``--password`` option to ``reset-admin-pwd`` (close #1794866) This will help batch. The help warn it's not very secure.

from cubicweb import UnknownEid
source, = __args__

sql("DELETE FROM entities WHERE type='Int'")

ecnx = session.pool.connection(source)
for e in rql('Any X WHERE X cw_source S, S name %(name)s', {'name': source}).entities():
    meta = e.cw_metainformation()
    assert meta['source']['uri'] == source
    try:
        suri = ecnx.describe(meta['extid'])[1]
    except UnknownEid:
        print 'cant describe', e.__regid__, e.eid, meta
        continue
    if suri != 'system':
        try:
            print 'deleting', e.__regid__, e.eid, suri, e.dc_title().encode('utf8')
            repo.delete_info(session, e, suri, meta['extid'], scleanup=True)
        except UnknownEid:
            print '  cant delete', e.__regid__, e.eid, meta


commit()