Project

General

Profile

Statistics
| Revision:

dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db @ 53133

Name Size Revision Age Author Comment
incrementalTransformation_migration.xqueries 2.06 KB 52390 over 5 years Alessia Bardi Updated instructions to migrate to incremental ...
materialised_views.sql 8.38 KB 53133 about 5 years Claudio Atzori updated materialised view update script. Adjust...
migrate_dsm.sql 8.26 KB 53133 about 5 years Claudio Atzori updated materialised view update script. Adjust...
patch-constraints.sql 2.93 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-fct.sql 2.43 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-fundingpaths.sql 1.36 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-identities.sql 5.1 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-jsonextrainfo.sql 66 Bytes 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-unidentifiedProjects.sql 646 Bytes 52973 about 5 years Alessia Bardi SQL INSERTs to add the unidentified project for...
patch.sql 19.2 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch_arc_and_ands.sql 2.45 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch_erc_pubsrepository.sql 1.27 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch_h2020.sql 3.16 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch_hostedbymap.sql 140 Bytes 49745 almost 6 years Alessia Bardi new patch db file for manually added hostedby e...
patch_pangaea_doaj.sql 6.92 KB 50489 over 5 years Michele Artini merged branch dsm into trunk
triggers.sql 1014 Bytes 51176 over 5 years Claudio Atzori utility file we can use to disable/enable the t...

Latest revisions

# Date Author Comment
53133 14/09/2018 05:53 PM Claudio Atzori

updated materialised view update script. Adjusted db mgration procedure.
52973 22/08/2018 12:24 PM Alessia Bardi

SQL INSERTs to add the unidentified project for MIUR, as suggested in #3683#note-19
52390 07/06/2018 06:30 PM Alessia Bardi

Updated instructions to migrate to incremental transformation
52367 05/06/2018 05:03 PM Alessia Bardi

Added provenanceactionclass for wt unidentified project
52338 04/06/2018 04:20 PM Alessia Bardi

take lastupdate in consideration for orgs and projects
52325 04/06/2018 02:47 PM Claudio Atzori

using dsm_datasources in sql expressions
52294 31/05/2018 11:22 AM Alessia Bardi

To support incremental update of projects in the database, useful functionality of IncrementalTransformationJobNode has been extracted to a superclass. Wf template for entity registries has been updated accordingly. Wf templates for other types of ds that were already in incremental mode have been updated for the new param name inherited from the superclass.
52191 24/05/2018 11:02 AM Claudio Atzori

distinct fundingpaths in projects_mv
52120 22/05/2018 10:09 AM Alessia Bardi

xqueries to turn all aggregation workflow with incremental transformation
51516 26/03/2018 06:19 PM Claudio Atzori

using dsm_datasources instead of datasources table, fixed datasource data migration rules for languages and od_contenttypes

View revisions

Also available in: Atom