Devops data hub.
Ruby Java HTML SQLPL Shell
Latest commit 9e5a714 Jul 15, 2016 @williewheeler williewheeler committed on GitHub Merge pull request #249 from ExpediaDotCom/update/collapsesql
collapse sql patch files
Failed to load latest commit information.
chef Fix for issue #138 Jul 1, 2015
conf-sample Minor sample config change Apr 19, 2016
gradle/wrapper cleanup and lint Jul 15, 2016
src collapse sql patch files Jul 15, 2016
.gitignore Updated gitignore Jan 18, 2016
.travis.yml Added 0.3.0 changelog Mar 9, 2015
LICENSE Initial commit Nov 8, 2014 Trivial edit to make branch show up in GitHub Jan 28, 2016
Vagrantfile vm box source update Sep 1, 2015
build.gradle Version bump Mar 1, 2016 Initial source commit Nov 18, 2014
gradlew Gradle version bump Nov 30, 2015
gradlew.bat Initial source commit Nov 18, 2014 Initial source commit Nov 18, 2014
settings.gradle Initial source commit Nov 18, 2014
vagrant.yml Config updates Sep 18, 2015


Build Status

Devops data integration repository.

Please see the for project information and documentation.

Dev setup

There are two options available here. The first is a manual setup, where you install Java, MySQL, RabbitMQ and the app yourself. The other is via Vagrant.

Approach #1: Manual setup

Installation. You'll need to install the following:

  • Java 8
  • MySQL 5.6.x (recommend using Homebrew)
    • Create the Seiso database: create database seiso;
    • Create a seiso user. It needs at least select, update and delete permissions on the seiso database. For a dev setup: create user 'seiso'@'localhost' identified by 'password'; grant select, update, delete, insert on sesio.* to 'seiso'@'localhost';
    • Create the tables by running src/main/sql/create-tables.sql.
    • Insert the reference data by running src/main/sql/insert-reference-data.sql.
    • If you like, insert the sample data by running src/main/sql/insert-sample-data.sql.
  • RabbitMQ
    • For visibility we recommend installing the RabbitMQ management plugin.

Approach #2: Vagrant setup

You can use Vagrant to set up your development environment, which consists of a MySQL database and a RabbitMQ message bus.

As a preliminary, you will need to install the Omnibus plugin, which will install the Chef provisioner on your VMs, then do

$ vagrant up

to create your VMs. With respect to the database VM, this creates the database and sample user automatically, and it also inserts the reference and sample data automatically.

Note that it takes a little while to create VMs, so if you want to speed things up, you can open two terminal windows and do

$ vagrant up db

in one and

$ vagrant up bus

in the other, just to parallelize the work.

Common Configuration

Create a copy of conf-sample/application.yml and modify it as appropriate.

To run Seiso in development mode, you can place it directly in src/main/resources. The file is for the vagrant setup, so if you installed without it you'll probably want to change the mysql port to 3306 and the Rabbit port to 5672.

Patch the Database

  • Connect to localhost:3306 and db seiso as root user
  • Run any patch files. Currently these two:
    • Run src/main/sql/archives/schema-p1.sql
    • Run src/main/sql/schema-p2.sql
  • Follow the instructions in that patch sql file (e.g. Run query: update person set source='ldap-corp')

Build Seiso

$ ./gradlew clean build

Run Seiso

$ ./gradlew bootRun

Point your HTML5-enabled browser to https://localhost:8080 or whatever scheme/port combo you chose during configuration in the application.yml for base-uri. You should see a home page with a list of services. To login, look at the file in src/main/sql/ which has the sample data usernames and passwords.