search

humlab-sead / sead_change_control

Sane SEAD change control using Sqitch.
1 stars 0 forks source link

20231211_DML_SUBMISSION_BUGS_20231219_COMMIT #162

Closed roger-mahler closed 7 months ago

roger-mahler commented 9 months ago

Full (inital) non-incremental import of BugsCEP data version 20230705.

Import log of BugsCEP data

Note the import system requires a JDK installation of Java and the maven build tool.

BugsCEP import has currently only been verified to work on Java JDK version 8.

Import of BugsCEP data from 2023-12.19

  1. Download latest version on BugsCEP data.
wget -O bugsdata/bugsdata_20231219.zip -d 
    --user-agent="Mozilla/5.0 (Windows NT x.y; rv:10.0) Gecko/20100101 Firefox/10.0" \
        https://www.bugscep.com/downloads/bugsdata.zip
unzip -p bugsdata/bugsdata_20231219.zip bugsdata.mdb > bugsdata/bugsdata_20231219.mdb
  1. Create target (temporary) database for BugsCEP import.:
bin/copy-database --source sead_staging_202212 --target sead_staging_bugs --force --sync-sequence
  1. Configure bugs-import:

Change database to sead_staging_bugs in file config/application.properties.

  1. Build the BugsCEP import application:
mvn -Dmaven.test.skip=true clean
mvn -Dmaven.test.skip=true package
  1. Run BugsCEP import system:
nohup java -jar target/bugs.import-0.1-SNAPSHOT.jar --file=./bugsdata/bugsdata_20231219.mdb
roger-mahler commented 7 months ago

Deployed to staging.