{"action":"created","issue":{"url":"https://api.github.com/repos/orbeon/orbeon-forms/issues/3124","repository_url":"https://api.github.com/repos/orbeon/orbeon-forms","labels_url":"https://api.github.com/repos/orbeon/orbeon-forms/issues/3124/labels{/name}","comments_url":"https://api.github.com/repos/orbeon/orbeon-forms/issues/3124/comments","events_url":"https://api.github.com/repos/orbeon/orbeon-forms/issues/3124/events","html_url":"https://github.com/orbeon/orbeon-forms/issues/3124","id":207900404,"number":3124,"title":"Run database tests on Travis with Oracle, DB2, and SQL Server","user":{"login":"avernet","id":106961,"avatar_url":"https://avatars.githubusercontent.com/u/106961?v=3","gravatar_id":"","url":"https://api.github.com/users/avernet","html_url":"https://github.com/avernet","followers_url":"https://api.github.com/users/avernet/followers","following_url":"https://api.github.com/users/avernet/following{/other_user}","gists_url":"https://api.github.com/users/avernet/gists{/gist_id}","starred_url":"https://api.github.com/users/avernet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/avernet/subscriptions","organizations_url":"https://api.github.com/users/avernet/orgs","repos_url":"https://api.github.com/users/avernet/repos","events_url":"https://api.github.com/users/avernet/events{/privacy}","received_events_url":"https://api.github.com/users/avernet/received_events","type":"User","site_admin":false},"labels":[{"id":38643359,"url":"https://api.github.com/repos/orbeon/orbeon-forms/labels/Tests","name":"Tests","color":"0052cc","default":false}],"state":"open","locked":false,"assignee":{"login":"avernet","id":106961,"avatar_url":"https://avatars.githubusercontent.com/u/106961?v=3","gravatar_id":"","url":"https://api.github.com/users/avernet","html_url":"https://github.com/avernet","followers_url":"https://api.github.com/users/avernet/followers","following_url":"https://api.github.com/users/avernet/following{/other_user}","gists_url":"https://api.github.com/users/avernet/gists{/gist_id}","starred_url":"https://api.github.com/users/avernet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/avernet/subscriptions","organizations_url":"https://api.github.com/users/avernet/orgs","repos_url":"https://api.github.com/users/avernet/repos","events_url":"https://api.github.com/users/avernet/events{/privacy}","received_events_url":"https://api.github.com/users/avernet/received_events","type":"User","site_admin":false},"assignees":[{"login":"avernet","id":106961,"avatar_url":"https://avatars.githubusercontent.com/u/106961?v=3","gravatar_id":"","url":"https://api.github.com/users/avernet","html_url":"https://github.com/avernet","followers_url":"https://api.github.com/users/avernet/followers","following_url":"https://api.github.com/users/avernet/following{/other_user}","gists_url":"https://api.github.com/users/avernet/gists{/gist_id}","starred_url":"https://api.github.com/users/avernet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/avernet/subscriptions","organizations_url":"https://api.github.com/users/avernet/orgs","repos_url":"https://api.github.com/users/avernet/repos","events_url":"https://api.github.com/users/avernet/events{/privacy}","received_events_url":"https://api.github.com/users/avernet/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/orbeon/orbeon-forms/milestones/58","html_url":"https://github.com/orbeon/orbeon-forms/milestone/58","labels_url":"https://api.github.com/repos/orbeon/orbeon-forms/milestones/58/labels","id":2030078,"number":58,"title":"2017.1","description":"","creator":{"login":"ebruchez","id":105769,"avatar_url":"https://avatars.githubusercontent.com/u/105769?v=3","gravatar_id":"","url":"https://api.github.com/users/ebruchez","html_url":"https://github.com/ebruchez","followers_url":"https://api.github.com/users/ebruchez/followers","following_url":"https://api.github.com/users/ebruchez/following{/other_user}","gists_url":"https://api.github.com/users/ebruchez/gists{/gist_id}","starred_url":"https://api.github.com/users/ebruchez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ebruchez/subscriptions","organizations_url":"https://api.github.com/users/ebruchez/orgs","repos_url":"https://api.github.com/users/ebruchez/repos","events_url":"https://api.github.com/users/ebruchez/events{/privacy}","received_events_url":"https://api.github.com/users/ebruchez/received_events","type":"User","site_admin":false},"open_issues":38,"closed_issues":30,"state":"open","created_at":"2016-09-26T21:12:05Z","updated_at":"2017-02-22T17:52:02Z","due_on":"2017-04-30T07:00:00Z","closed_at":null},"comments":1,"created_at":"2017-02-15T19:16:43Z","updated_at":"2017-02-23T01:10:33Z","closed_at":null,"body":"This in addition to MySQL and PostgreSQL, which shouldn't be too hard leveraging Docker.\r\n\r\n- [ ] Oracle\r\n- [ ] DB2\r\n- [ ] SQL Server"},"comment":{"url":"https://api.github.com/repos/orbeon/orbeon-forms/issues/comments/281858016","html_url":"https://github.com/orbeon/orbeon-forms/issues/3124#issuecomment-281858016","issue_url":"https://api.github.com/repos/orbeon/orbeon-forms/issues/3124","id":281858016,"user":{"login":"avernet","id":106961,"avatar_url":"https://avatars.githubusercontent.com/u/106961?v=3","gravatar_id":"","url":"https://api.github.com/users/avernet","html_url":"https://github.com/avernet","followers_url":"https://api.github.com/users/avernet/followers","following_url":"https://api.github.com/users/avernet/following{/other_user}","gists_url":"https://api.github.com/users/avernet/gists{/gist_id}","starred_url":"https://api.github.com/users/avernet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/avernet/subscriptions","organizations_url":"https://api.github.com/users/avernet/orgs","repos_url":"https://api.github.com/users/avernet/repos","events_url":"https://api.github.com/users/avernet/events{/privacy}","received_events_url":"https://api.github.com/users/avernet/received_events","type":"User","site_admin":false},"created_at":"2017-02-23T01:10:33Z","updated_at":"2017-02-23T01:10:33Z","body":"The issue with starting a fresh Docker database container for every test is that an \"image\" isn't the same thing as a \"snapshot\": when starting, an image still needs to start the database, which on my iMac takes about 3 s for DB2 and 30 s for Oracle. In the future, Docker might support Checkpoint & Restore, through [CRIU](https://criu.org/Docker), but this is right now experimental, and not supported on macOS, which probably means we don't want to rely on it.\r\n\r\nSo this means that we probably will want to just run 1 container for each database, instead of running a container for every test. We've done this in the past for Oracle, but this poses a clean-up problem on DB2, where deleting a schema didn't delete objects inside that schema.\r\n\r\nNext:\r\n\r\n- [ ] Revert to running the Oracle container once (easier, as we already have cleanup code for Oracle).\r\n- [ ] On DB2, research way to remove object created in a schema."}}
{"actor":{"display_login":"avernet"}}