{"action":"created","issue":{"url":"https://api.github.com/repos/OpenWiseSolutions/openhub-framework/issues/40","repository_url":"https://api.github.com/repos/OpenWiseSolutions/openhub-framework","labels_url":"https://api.github.com/repos/OpenWiseSolutions/openhub-framework/issues/40/labels{/name}","comments_url":"https://api.github.com/repos/OpenWiseSolutions/openhub-framework/issues/40/comments","events_url":"https://api.github.com/repos/OpenWiseSolutions/openhub-framework/issues/40/events","html_url":"https://github.com/OpenWiseSolutions/openhub-framework/pull/40","id":218759307,"number":40,"title":"OHFJIRA-10 Flyway db-migration","user":{"login":"kkovarik","id":13747830,"avatar_url":"https://avatars0.githubusercontent.com/u/13747830?v=3","gravatar_id":"","url":"https://api.github.com/users/kkovarik","html_url":"https://github.com/kkovarik","followers_url":"https://api.github.com/users/kkovarik/followers","following_url":"https://api.github.com/users/kkovarik/following{/other_user}","gists_url":"https://api.github.com/users/kkovarik/gists{/gist_id}","starred_url":"https://api.github.com/users/kkovarik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kkovarik/subscriptions","organizations_url":"https://api.github.com/users/kkovarik/orgs","repos_url":"https://api.github.com/users/kkovarik/repos","events_url":"https://api.github.com/users/kkovarik/events{/privacy}","received_events_url":"https://api.github.com/users/kkovarik/received_events","type":"User","site_admin":false},"labels":[{"id":521956806,"url":"https://api.github.com/repos/OpenWiseSolutions/openhub-framework/labels/task","name":"task","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2017-04-02T11:45:48Z","updated_at":"2017-05-20T13:47:51Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/OpenWiseSolutions/openhub-framework/pulls/40","html_url":"https://github.com/OpenWiseSolutions/openhub-framework/pull/40","diff_url":"https://github.com/OpenWiseSolutions/openhub-framework/pull/40.diff","patch_url":"https://github.com/OpenWiseSolutions/openhub-framework/pull/40.patch"},"body":"### INFO\r\n* openhub db schema migration handled by Flyway\r\n\r\n### CHANGES\r\n* flyway enabled:\r\n    * added sql scripts for H2 & PostgreSQL, all current db tests are passing\r\n    * spring JDBC initialization disabled\r\n    * hibernate switched to validation mode\r\n    * minor update in db_schema_postgreSql_archive script\r\n    * ~~fixed PartlyFailedMessagesPoolRouteTest (was not using h2 profile)~~\r\n* added new sequence for Node table\r\n* ~~added sample docker image for postgresql (as I used for testing of db migration)~~\r\n\r\n### RELATED JIRA\r\n* https://openhubframework.atlassian.net/browse/OHFJIRA-10\r\n\r\n### OPEN QUESTIONS\r\n* H2 was generated from entities by hibernate, now disabled and switched to Flyway to keep things consist, as side effect two SQL schemas (postgres & h2) needs to be maintaned, is it ok? \r\n* what with existing databases?\r\n* implementations of OpenHub, will there be some mechanism for their custom scripts? at least simple conventions like that OpenHub will use only defined versions, so implementations can add their own after them?\r\n* db migration tests against PostgreSQL database - using docker on Travis?"},"comment":{"url":"https://api.github.com/repos/OpenWiseSolutions/openhub-framework/issues/comments/302874283","html_url":"https://github.com/OpenWiseSolutions/openhub-framework/pull/40#issuecomment-302874283","issue_url":"https://api.github.com/repos/OpenWiseSolutions/openhub-framework/issues/40","id":302874283,"user":{"login":"coveralls","id":2354108,"avatar_url":"https://avatars2.githubusercontent.com/u/2354108?v=3","gravatar_id":"","url":"https://api.github.com/users/coveralls","html_url":"https://github.com/coveralls","followers_url":"https://api.github.com/users/coveralls/followers","following_url":"https://api.github.com/users/coveralls/following{/other_user}","gists_url":"https://api.github.com/users/coveralls/gists{/gist_id}","starred_url":"https://api.github.com/users/coveralls/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coveralls/subscriptions","organizations_url":"https://api.github.com/users/coveralls/orgs","repos_url":"https://api.github.com/users/coveralls/repos","events_url":"https://api.github.com/users/coveralls/events{/privacy}","received_events_url":"https://api.github.com/users/coveralls/received_events","type":"User","site_admin":false},"created_at":"2017-05-20T13:47:51Z","updated_at":"2017-05-20T13:47:51Z","body":"\n[![Coverage Status](https://coveralls.io/builds/11613816/badge)](https://coveralls.io/builds/11613816)\n\nCoverage increased (+0.2%) to 56.28% when pulling **287298c1460383b0e4308a949e4a8469b56d3308 on feature/OHFJIRA-10-flyway** into **40a8e64cc268cb74ddb0d2961d25af6b523d7512 on develop**.\n"}}
{"actor":{"display_login":"coveralls"}}