| author | Sylvain Thénault <sylvain.thenault@logilab.fr> |
| Thu, 19 May 2011 10:53:11 +0200 | |
| changeset 7398 | 26695dd703d8 |
| parent 6636 | dbc9cce53c11 |
| child 7884 | 35d2e2f4e10a |
| permissions | -rw-r--r-- |
|
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() |