Skip to content

Creation and control scripts for the Postgres database used to store analytics results in the MIP

License

Notifications You must be signed in to change notification settings

LREN-CHUV/woken-db-setup

Folders and files

NameName
Last commit message
Last commit date

Latest commit

845ef2c · May 10, 2019

History

95 Commits
May 10, 2019
Feb 7, 2019
May 10, 2019
Oct 11, 2017
Feb 7, 2019
Oct 10, 2017
Mar 12, 2019
Sep 13, 2017
Mar 28, 2019
Mar 28, 2019
Apr 24, 2017
Feb 8, 2019
Oct 10, 2017
Oct 10, 2017
Mar 12, 2019
Feb 7, 2019
Mar 12, 2019
Oct 10, 2017

Repository files navigation

CHUV License Codacy Badge CircleCI

Setup for database 'woken-db'

Introduction

This project uses Flyway to manage the database migration scripts for the 'woken-db' database used by Woken.

Usage

Run:

$ docker run -i -t --rm -e FLYWAY_DBMS=postgres -e FLYWAY_HOST=`hostname` hbpmip/woken-db-setup:1.3.3 migrate

where the environment variables are:

  • FLYWAY_DBMS: [required] Type of the database (oracle, postgres...).
  • FLYWAY_HOST: [required] database host.
  • FLYWAY_PORT: database port.
  • FLYWAY_DATABASE_NAME: name of the database or schema
  • FLYWAY_URL: JDBC url to the database, constructed by default from FLYWAY_DBMS, FLYWAY_HOST, FLYWAY_PORT and FLYWAY_DATABASE_NAME
  • FLYWAY_DRIVER: Fully qualified classname of the jdbc driver (autodetected by default based on flyway.url)
  • FLYWAY_USER: database user.
  • FLYWAY_PASSWORD: database password.
  • FLYWAY_SCHEMAS: Comma-separated list of schemas managed by Flyway
  • FLYWAY_TABLE: Name of Flyway's metadata table (default: schema_version)

Build

Run: ./build.sh

Publish on Docker Hub

Run: ./publish.sh

License

Woken-db-setup

(this project)

Copyright (C) 2017-2019 LREN CHUV

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Flyway

Copyright (C) 2016-2017 Boxfuse GmbH

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Trademark

Flyway is a registered trademark of Boxfuse GmbH.

Acknowledgements

This work has been funded by the European Union Seventh Framework Program (FP7/2007­2013) under grant agreement no. 604102 (HBP)

This work is part of SP8 of the Human Brain Project (SGA1).