Mercurial Mercurial > pub > hg > cubicweb / annotate
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc/scripts/drop_external_entities.py
author Sylvain Thénault <sylvain.thenault@logilab.fr>
Fri, 23 Sep 2011 12:23:09 +0200
branchstable
changeset 7843 3b51806da60b
parent 7398 26695dd703d8
child 7884 35d2e2f4e10a
permissions -rw-r--r--
[rqlrewrite] if inlined relation has to be moved to a subquery, take care of the object of the relation (closes #1945725) As the object of the relation is moved to the subquery, all variables/relations representing some of its attributes or inlined relations should be moved there as well. This avoid error such as "BadRQLQuery: variable AF should be selected by the subquery" on security insertion.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
6636
dbc9cce53c11 [ms] script to drop external entities from an external source
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     1
 
from cubicweb import UnknownEid
dbc9cce53c11 [ms] script to drop external entities from an external source
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     2
 
source, = __args__
dbc9cce53c11 [ms] script to drop external entities from an external source
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset 
     3
 












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




     4


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












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




     5









7398






26695dd703d8
[repository api] definitly kill usage of word 'pool' to refer to connections set used by a session



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 
6636

diff
changeset




     6


ecnx = session.cnxset.connection(source)







6636






dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




     7


for e in rql('Any X WHERE X cw_source S, S name %(name)s', {'name': source}).entities():












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




     8


    meta = e.cw_metainformation()












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




     9


    assert meta['source']['uri'] == source












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    10


    try:












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    11


        suri = ecnx.describe(meta['extid'])[1]












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    12


    except UnknownEid:












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    13


        print 'cant describe', e.__regid__, e.eid, meta












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    14


        continue












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    15


    if suri != 'system':












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    16


        try:












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    17


            print 'deleting', e.__regid__, e.eid, suri, e.dc_title().encode('utf8')












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    18


            repo.delete_info(session, e, suri, meta['extid'], scleanup=True)












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    19


        except UnknownEid:












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    20


            print '  cant delete', e.__regid__, e.eid, meta












dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    21














dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    22














dbc9cce53c11
[ms] script to drop external entities from an external source



Sylvain Thénault <sylvain.thenault@logilab.fr>


parents: 

diff
changeset




    23


commit()














cubicweb