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

woken-ml/woken-db-setup

 
 

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).

About

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

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Shell 77.7%
  • Dockerfile 14.3%
  • PLpgSQL 8.0%