misc/scripts/drop_external_entities.py
author Aurelien Campeas <aurelien.campeas@logilab.fr>
Thu, 14 Nov 2013 17:17:02 +0100
changeset 9361 0542a85fe667
parent 8900 010a59e12d89
permissions -rw-r--r--
symmetric relations: replace bogus rql2sql translation by a hook The hook ensures X r Y => Y r X iff r is symmetric. The rql-no-hook data importer receives a small amendment but note that: * there exist no test for it * its actual semantics are undefined Hence we cannot prove this hunk breaks nothing, because we cannot prove anything. Closes #3259713.

from cubicweb import UnknownEid
source, = __args__

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

ecnx = session.cnxset.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.cw_etype, e.eid, meta
        continue
    if suri != 'system':
        try:
            print 'deleting', e.cw_etype, e.eid, suri, e.dc_title().encode('utf8')
            repo.delete_info(session, e, suri, scleanup=e.eid)
        except UnknownEid:
            print '  cant delete', e.cw_etype, e.eid, meta


commit()