{"action":"created","issue":{"url":"https://api.github.com/repos/AnatolyUss/nmig/issues/32","repository_url":"https://api.github.com/repos/AnatolyUss/nmig","labels_url":"https://api.github.com/repos/AnatolyUss/nmig/issues/32/labels{/name}","comments_url":"https://api.github.com/repos/AnatolyUss/nmig/issues/32/comments","events_url":"https://api.github.com/repos/AnatolyUss/nmig/issues/32/events","html_url":"https://github.com/AnatolyUss/nmig/issues/32","id":179759784,"number":32,"title":"Migrating views","user":{"login":"acosonic","id":862015,"avatar_url":"https://avatars.githubusercontent.com/u/862015?v=3","gravatar_id":"","url":"https://api.github.com/users/acosonic","html_url":"https://github.com/acosonic","followers_url":"https://api.github.com/users/acosonic/followers","following_url":"https://api.github.com/users/acosonic/following{/other_user}","gists_url":"https://api.github.com/users/acosonic/gists{/gist_id}","starred_url":"https://api.github.com/users/acosonic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/acosonic/subscriptions","organizations_url":"https://api.github.com/users/acosonic/orgs","repos_url":"https://api.github.com/users/acosonic/repos","events_url":"https://api.github.com/users/acosonic/events{/privacy}","received_events_url":"https://api.github.com/users/acosonic/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-09-28T12:33:06Z","updated_at":"2016-10-08T18:51:56Z","closed_at":"2016-10-08T18:51:56Z","body":"Only one view was migrated which didn't have back-ticks \\` like standard mysql practice....\r\n\r\n\r\nFor example:\r\n\r\nselect \\`packages\\`.\\`shipment_id\\` AS \\`shipment_id\\`,group_concat(\\`packages\\`.\\`tracking_number\\` separator ', ') AS \\`tracking_numbers\\`,sum(\\`packages\\`.\\`insurance_amount\\`) AS \\`insurance_amount\\`,sum(\\`packages\\`.\\`weight\\`) AS \\`weight\\`,sum(\\`packages\\`.\\`cod_amount\\`) AS \\`cod_amount\\` from \\`packages\\` group by \\`packages\\`.\\`shipment_id\\`\r\n\r\nAlso notice the function replacement that needs to be done as well..."},"comment":{"url":"https://api.github.com/repos/AnatolyUss/nmig/issues/comments/252441637","html_url":"https://github.com/AnatolyUss/nmig/issues/32#issuecomment-252441637","issue_url":"https://api.github.com/repos/AnatolyUss/nmig/issues/32","id":252441637,"user":{"login":"AnatolyUss","id":13574071,"avatar_url":"https://avatars.githubusercontent.com/u/13574071?v=3","gravatar_id":"","url":"https://api.github.com/users/AnatolyUss","html_url":"https://github.com/AnatolyUss","followers_url":"https://api.github.com/users/AnatolyUss/followers","following_url":"https://api.github.com/users/AnatolyUss/following{/other_user}","gists_url":"https://api.github.com/users/AnatolyUss/gists{/gist_id}","starred_url":"https://api.github.com/users/AnatolyUss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AnatolyUss/subscriptions","organizations_url":"https://api.github.com/users/AnatolyUss/orgs","repos_url":"https://api.github.com/users/AnatolyUss/repos","events_url":"https://api.github.com/users/AnatolyUss/events{/privacy}","received_events_url":"https://api.github.com/users/AnatolyUss/received_events","type":"User","site_admin":false},"created_at":"2016-10-08T18:51:56Z","updated_at":"2016-10-08T18:51:56Z","body":"Hello and sorry for the late response,\r\nViews migration is supported at basic level only.\r\nAll views (the SQL script, that was rejected by PostgreSQL), that were not migrated can be found under <code>/nmig/logs_directory/not_created_views</code>.\r\nYou will see each SQL (view) script in separate file.\r\nProbably, you will need to fix those scripts manually...\r\nSupporting <b>precise</b> migration of views may require implementing a full SQL parser.\r\nWhile it is possible, currently I don't have enough spare time for such an improvement.\r\n\r\nThank you for your feedback!"}}
{"actor":{"display_login":"AnatolyUss"}}