app-gn-publicatie 1.2.2

Fixed

  • besluit publicatie service can now better handle somewhat incorrect publications. It will publish decisionlists (and agenda's) that don't have a consistent ordering, so the data can be added manually later on

deployment guide

  1. set up the maintenance frontend in docker-compose.override.yml (note that this should replace the identifier, as that is the entrypoint in this stack)

  2. optional: create a backup of the database with /data/useful-scripts/virtuoso-backup.sh ${name-of-container}

  3. bring down everything with docker-compose down

  4. bring up just the maintenance frontend with docker-compose up -d maintenance

  5. git fetch && git checkout v1.2.2

  6. on production create a migration with the following queries

    1. INSERT DATA {
      GRAPH <http://mu.semte.ch/graphs/public> {
      <http://data.lblod.info/published-resources/2d4d0bc0-019d-11ec-af11-6b6202118d54>	<http://mu.semte.ch/vocabularies/ext/besluit-publicatie-publish-service/number-of-retries>	"5"^^<http://www.w3.org/2001/XMLSchema#integer> .
      }};
      
      DELETE DATA {
      GRAPH <http://mu.semte.ch/graphs/public> {
      <http://data.lblod.info/published-resources/2d4d0bc0-019d-11ec-af11-6b6202118d54>	<http://mu.semte.ch/vocabularies/ext/besluit-publicatie-publish-service/number-of-retries>	"10"^^<http://www.w3.org/2001/XMLSchema#integer> .
      }};
      INSERT DATA {
      GRAPH <http://mu.semte.ch/graphs/public> {
      <http://data.lblod.info/published-resources/1a9df1f0-feb0-11eb-af11-6b6202118d54>	<http://mu.semte.ch/vocabularies/ext/besluit-publicatie-publish-service/number-of-retries>	"5"^^<http://www.w3.org/2001/XMLSchema#integer> .
      }};
      
      DELETE DATA {
      GRAPH <http://mu.semte.ch/graphs/public> {
      <http://data.lblod.info/published-resources/1a9df1f0-feb0-11eb-af11-6b6202118d54>	<http://mu.semte.ch/vocabularies/ext/besluit-publicatie-publish-service/number-of-retries>	"10"^^<http://www.w3.org/2001/XMLSchema#integer> .
      }};
      PREFIX behandeling: <http://data.lblod.info/id/behandelingen-van-agendapunten/>
      PREFIX schema: <http://schema.org/>
      INSERT DATA {
      GRAPH <http://mu.semte.ch/graphs/public> {
      behandeling:61111D5141D2E1000A00019D schema:position "0"^^xsd:integer.
      behandeling:61111D9041D2E1000A00019F schema:position "1"^^xsd:integer.
      behandeling:61111DC041D2E1000A0001A3 schema:position "2"^^xsd:integer.
      behandeling:61111DEA41D2E1000A0001A6 schema:position "3"^^xsd:integer.
      behandeling:61111E1B41D2E1000A0001AA schema:position "4"^^xsd:integer.
      behandeling:61111E4A41D2E1000A0001AD schema:position "5"^^xsd:integer.
      behandeling:61111E7641D2E1000A0001B0 schema:position "6"^^xsd:integer.
      behandeling:61111E9E41D2E1000A0001B2 schema:position "7"^^xsd:integer.
      behandeling:61111EC741D2E1000A0001B5 schema:position "8"^^xsd:integer.
      behandeling:61111F2141D2E1000A0001B9 schema:position "9"^^xsd:integer.
      behandeling:61111F5841D2E1000A0001BD schema:position "10"^^xsd:integer.
      behandeling:61111F8E41D2E1000A0001C2 schema:position "11"^^xsd:integer.
      behandeling:61111FF741D2E1000A0001C9 schema:position "12"^^xsd:integer.
      behandeling:6111202441D2E1000A0001CD schema:position "13"^^xsd:integer.
      behandeling:6111205641D2E1000A0001D1 schema:position "14"^^xsd:integer.
      behandeling:6111208C41D2E1000A0001D5 schema:position "15"^^xsd:integer.
      behandeling:611120BC41D2E1000A0001D9 schema:position "16"^^xsd:integer.
      behandeling:611120EA41D2E1000A0001DD schema:position "17"^^xsd:integer.
      behandeling:6111212141D2E1000A0001E0 schema:position "18"^^xsd:integer.
      behandeling:6111215541D2E1000A0001E4 schema:position "19"^^xsd:integer.
      behandeling:6111218F41D2E1000A0001E8 schema:position "20"^^xsd:integer.
      behandeling:611121C641D2E1000A0001EB schema:position "21"^^xsd:integer.
      behandeling:611121FE41D2E1000A0001EE schema:position "22"^^xsd:integer.
      behandeling:6111223141D2E1000A0001F0 schema:position "23"^^xsd:integer.
      behandeling:6111226F41D2E1000A0001F2 schema:position "24"^^xsd:integer.
      behandeling:611122A841D2E1000A0001F4 schema:position "25"^^xsd:integer.
      behandeling:611122E241D2E1000A0001F6 schema:position "26"^^xsd:integer.
      behandeling:6111231E41D2E1000A0001F8 schema:position "27"^^xsd:integer.
      behandeling:6111235741D2E1000A0001FA schema:position "28"^^xsd:integer.
      behandeling:6111239741D2E1000A0001FC schema:position "29"^^xsd:integer.
      behandeling:611123D341D2E1000A0001FE schema:position "30"^^xsd:integer.
      behandeling:6111240B41D2E1000A000200 schema:position "31"^^xsd:integer.
      behandeling:6111244B41D2E1000A000203 schema:position "32"^^xsd:integer.
      behandeling:6111248941D2E1000A000207 schema:position "33"^^xsd:integer.
      behandeling:611124ED41D2E1000A00020E schema:position "34"^^xsd:integer.
      behandeling:6111254241D2E1000A000212 schema:position "35"^^xsd:integer.
      behandeling:6111258041D2E1000A000216 schema:position "36"^^xsd:integer.
      behandeling:611125C241D2E1000A00021A schema:position "37"^^xsd:integer.
      behandeling:6111260141D2E1000A00021E schema:position "38"^^xsd:integer.
      behandeling:6111264E41D2E1000A000223 schema:position "39"^^xsd:integer.
      behandeling:6111269141D2E1000A000226 schema:position "40"^^xsd:integer.
      behandeling:611126D741D2E1000A00022A schema:position "41"^^xsd:integer.
      behandeling:6111272141D2E1000A00022E schema:position "42"^^xsd:integer.
      behandeling:6111277141D2E1000A000233 schema:position "43"^^xsd:integer.
      behandeling:611127B941D2E1000A000239 schema:position "44"^^xsd:integer.
      behandeling:611127FB41D2E1000A00023B schema:position "45"^^xsd:integer.
      behandeling:6111283841D2E1000A00023E schema:position "46"^^xsd:integer.
      behandeling:6111288841D2E1000A000240 schema:position "47"^^xsd:integer.
      behandeling:611128CB41D2E1000A000242 schema:position "48"^^xsd:integer.
      behandeling:6111291841D2E1000A000244 schema:position "49"^^xsd:integer.
      }}
      ;
      PREFIX behandeling: <http://data.lblod.info/id/behandelingen-van-agendapunten/>
      PREFIX schema: <http://schema.org/>
      INSERT DATA {
      GRAPH <http://mu.semte.ch/graphs/public> {
      behandeling:610819B241D2E10009000299 schema:position "0"^^xsd:integer.
      behandeling:610BA78A41D2E10009000A7C schema:position "1"^^xsd:integer.
      behandeling:610A659D41D2E10009000909 schema:position "2"^^xsd:integer.
      behandeling:6108E1B841D2E100090002B8 schema:position "3"^^xsd:integer.
      behandeling:610BC61841D2E10009000AFE schema:position "4"^^xsd:integer.
      behandeling:610BC64241D2E10009000B00 schema:position "5"^^xsd:integer.
      behandeling:610B88C941D2E10009000A3F schema:position "6"^^xsd:integer.
      behandeling:610BC6DA41D2E10009000B03 schema:position "7"^^xsd:integer.
      behandeling:610CF9CC41D2E1000A00002A schema:position "8"^^xsd:integer.
      behandeling:610CFA0A41D2E1000A00002C schema:position "9"^^xsd:integer.
      behandeling:610CFA5C41D2E1000A000030 schema:position "10"^^xsd:integer.
      behandeling:610CFA8041D2E1000A000032 schema:position "11"^^xsd:integer.
      behandeling:610BC73F41D2E10009000B05 schema:position "12"^^xsd:integer.
      behandeling:6107C78841D2E10009000121 schema:position "13"^^xsd:integer.
      behandeling:61081ADE41D2E100090002A2 schema:position "14"^^xsd:integer.
      behandeling:61081B6641D2E100090002A9 schema:position "15"^^xsd:integer.
      }}

  7. start virtuoso and the migrations service docker-compose up -d virtuoso migrations

  8. start the stack docker-compose up -d

  9. remove (comment out) maintenance frontend from docker-compose.override.yml

  10. start the stack docker-compose up -d --remove-orphans(remove orphans removes the maintenance frontend)

  11. verify it's up

Deployments

Last updated