{"action":"created","issue":{"url":"https://api.github.com/repos/boundlessgeo/suite/issues/862","labels_url":"https://api.github.com/repos/boundlessgeo/suite/issues/862/labels{/name}","comments_url":"https://api.github.com/repos/boundlessgeo/suite/issues/862/comments","events_url":"https://api.github.com/repos/boundlessgeo/suite/issues/862/events","html_url":"https://github.com/boundlessgeo/suite/pull/862","id":55675207,"number":862,"title":"Modified DB import API to allow selection of tables","user":{"login":"tbarsballe","id":9271497,"avatar_url":"https://avatars.githubusercontent.com/u/9271497?v=3","gravatar_id":"","url":"https://api.github.com/users/tbarsballe","html_url":"https://github.com/tbarsballe","followers_url":"https://api.github.com/users/tbarsballe/followers","following_url":"https://api.github.com/users/tbarsballe/following{/other_user}","gists_url":"https://api.github.com/users/tbarsballe/gists{/gist_id}","starred_url":"https://api.github.com/users/tbarsballe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tbarsballe/subscriptions","organizations_url":"https://api.github.com/users/tbarsballe/orgs","repos_url":"https://api.github.com/users/tbarsballe/repos","events_url":"https://api.github.com/users/tbarsballe/events{/privacy}","received_events_url":"https://api.github.com/users/tbarsballe/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-27T21:13:18Z","updated_at":"2015-01-28T00:45:58Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/boundlessgeo/suite/pulls/862","html_url":"https://github.com/boundlessgeo/suite/pull/862","diff_url":"https://github.com/boundlessgeo/suite/pull/862.diff","patch_url":"https://github.com/boundlessgeo/suite/pull/862.patch"},"body":"DB import POST:\r\n\r\n  `POST /api/imports/<workspace> `\r\n  Request: JSON DB connection parameters:\r\n\r\n    {\"port\":\"5432\",\r\n    \"Connection timeout\":\"20\",\r\n    \"dbtype\":\"postgis\",\r\n    \"host\":\"localhost\",\r\n    \"password\":\"postgres\",\r\n    \"database\":\"postgres\",\r\n    \"schema\":\"public\",\r\n    \"user\":\"postgres\",\r\n    \"max connections\":\"10\",\r\n    \"min connections\":\"1\"}\r\n\r\nThis will initialize the import, and return the import id and lists of tasks. All database tables will be in a JSON array called \"preimport\". No data will actually be imported.\r\n\r\n  Note: The task description has been changed slightly. The attribute \"file\" has been changed to \"name\", and will now also display the table name in the case of a DB import. The attribute \"type\" has been added, and can be one of \"file\", \"table\", \"database\", or \"null\":\r\n\r\n    {\"id\":0,\r\n    \"preimport\":[\r\n        {\"task\":0,\"name\":\"cities\",\"type\":\"table\"},\r\n        {\"task\":1,\"name\":\"test\",\"type\":\"table\"}],\r\n    \"imported\":[],\r\n    \"pending\":[],\r\n    \"failed\":[],\r\n    \"ignored\":[]}\r\n\r\nContinue with the import using \r\n`PUT /api/imports/<workspace>/<importid>`\r\nRequest: JSON object containing either an array of task ids called \"tasks\" or a \"filter\". Currently the only filter defined is \"ALL\" which imports all the tasks/tables.\r\n`{ \"tasks\":[0] }`\r\nOr:\r\n`{ \"filter\":\"ALL\" }`\r\nAfter this point, the DB import behaves the same as a file import."},"comment":{"url":"https://api.github.com/repos/boundlessgeo/suite/issues/comments/71760454","html_url":"https://github.com/boundlessgeo/suite/pull/862#issuecomment-71760454","issue_url":"https://api.github.com/repos/boundlessgeo/suite/issues/862","id":71760454,"user":{"login":"jodygarnett","id":629681,"avatar_url":"https://avatars.githubusercontent.com/u/629681?v=3","gravatar_id":"","url":"https://api.github.com/users/jodygarnett","html_url":"https://github.com/jodygarnett","followers_url":"https://api.github.com/users/jodygarnett/followers","following_url":"https://api.github.com/users/jodygarnett/following{/other_user}","gists_url":"https://api.github.com/users/jodygarnett/gists{/gist_id}","starred_url":"https://api.github.com/users/jodygarnett/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jodygarnett/subscriptions","organizations_url":"https://api.github.com/users/jodygarnett/orgs","repos_url":"https://api.github.com/users/jodygarnett/repos","events_url":"https://api.github.com/users/jodygarnett/events{/privacy}","received_events_url":"https://api.github.com/users/jodygarnett/received_events","type":"User","site_admin":false},"created_at":"2015-01-28T00:45:58Z","updated_at":"2015-01-28T00:45:58Z","body":"Thanks for the fixes, I have had my review merge when ready"}}