Revision 50489
Added by Michele Artini about 6 years ago
queryDatasourceOrganization.sql | ||
---|---|---|
1 | 1 |
SELECT |
2 | 2 |
dor.datasource AS datasource, |
3 | 3 |
dor.organization AS organization, |
4 |
dor.startdate AS startdate,
|
|
5 |
dor.enddate AS enddate,
|
|
6 |
dor.inferred AS inferred,
|
|
7 |
dor.deletedbyinference AS deletedbyinference,
|
|
8 |
dor.trust AS trust,
|
|
9 |
dor.inferenceprovenance AS inferenceprovenance,
|
|
4 |
NULL AS startdate,
|
|
5 |
NULL AS enddate,
|
|
6 |
false AS inferred,
|
|
7 |
false AS deletedbyinference,
|
|
8 |
0.9 AS trust,
|
|
9 |
NULL AS inferenceprovenance,
|
|
10 | 10 |
|
11 |
doc.code || '@@@' || doc.name || '@@@' || dos.code || '@@@' || dos.name AS semantics,
|
|
12 |
pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name AS provenanceaction
|
|
11 |
'providedBy@@@provided by@@@dnet:datasources_organizations_typologies@@@dnet:datasources_organizations_typologies' AS semantics,
|
|
12 |
d.provenanceaction || '@@@' || d.provenanceaction || '@@@dnet:provenanceActions@@@dnet:provenanceActions' AS provenanceaction
|
|
13 | 13 |
|
14 |
FROM datasource_organization dor |
|
14 |
FROM dsm_datasource_organization dor |
|
15 |
LEFT OUTER JOIN dsm_datasources d ON (dor.datasource = d.id) |
|
15 | 16 |
|
16 |
LEFT OUTER JOIN datasources d ON (dor.datasource = d.id) |
|
17 |
|
|
18 |
LEFT OUTER JOIN class pac ON (pac.code = d.provenanceactionclass) |
|
19 |
LEFT OUTER JOIN scheme pas ON (pas.code = d.provenanceactionscheme) |
|
20 |
|
|
21 |
LEFT OUTER JOIN class doc ON (doc.code = dor.semanticclass) |
|
22 |
LEFT OUTER JOIN scheme dos ON (dos.code = dor.semanticscheme) |
|
23 |
|
|
24 |
-- These clauses have been commented to allow the import of all the datasource on the index |
|
25 |
-- WHERE d.datasourceclass != 'entityregistry' |
|
26 |
-- AND d.openairecompatibilityclass IS NOT null |
|
27 |
-- AND d.openairecompatibilityclass != 'UNKNOWN' |
|
28 |
-- AND d.openairecompatibilityclass != 'notCompatible' |
Also available in: Unified diff
merged branch dsm into trunk