{"action":"created","issue":{"url":"https://api.github.com/repos/syxolk/euro2016/issues/14","repository_url":"https://api.github.com/repos/syxolk/euro2016","labels_url":"https://api.github.com/repos/syxolk/euro2016/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/syxolk/euro2016/issues/14/comments","events_url":"https://api.github.com/repos/syxolk/euro2016/issues/14/events","html_url":"https://github.com/syxolk/euro2016/issues/14","id":158843907,"number":14,"title":"Unhandled rejection SequelizeDatabaseError: relation \"score_table\" does not exist","user":{"login":"lsv","id":20708,"avatar_url":"https://avatars.githubusercontent.com/u/20708?v=3","gravatar_id":"","url":"https://api.github.com/users/lsv","html_url":"https://github.com/lsv","followers_url":"https://api.github.com/users/lsv/followers","following_url":"https://api.github.com/users/lsv/following{/other_user}","gists_url":"https://api.github.com/users/lsv/gists{/gist_id}","starred_url":"https://api.github.com/users/lsv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lsv/subscriptions","organizations_url":"https://api.github.com/users/lsv/orgs","repos_url":"https://api.github.com/users/lsv/repos","events_url":"https://api.github.com/users/lsv/events{/privacy}","received_events_url":"https://api.github.com/users/lsv/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-06-07T05:48:39Z","updated_at":"2016-06-10T23:08:36Z","closed_at":"2016-06-10T23:08:36Z","body":"Trying to get this installed\r\n- npm install working fine\r\n- populating working fine\r\n- creating views, seems to be working fine\r\n- But then I get a `score_table` relation that apparently does not exists\r\n\r\nLog - some lines removed\r\n\r\n```\r\n-> % npm install\r\n....\r\n-> % node tools/populate.js tools/euro2016.json\r\nExecuting (default): INSERT INTO \"Team\" (\"id\",\"name\",\"code\") VALUES (DEFAULT,'France','FRA'),(DEFAULT,'Romania','ROU'),(DEFAULT,'Albania','ALB'),(DEFAULT,'Switzerland','SUI'),(DEFAULT,'England','ENG'),(DEFAULT,'Russia','RUS'),(DEFAULT,'Wales','WAL'),(DEFAULT,'Slovakia','SVK'),(DEFAULT,'Germany','GER'),(DEFAULT,'Ukraine','UKR'),(DEFAULT,'Poland','POL'),(DEFAULT,'Northern Ireland','NIR'),(DEFAULT,'Spain','ESP'),(DEFAULT,'Czech Republic','CZE'),(DEFAULT,'Turkey','TUR'),(DEFAULT,'Croatia','CRO'),(DEFAULT,'Belgium','BEL'),(DEFAULT,'Italy','ITA'),(DEFAULT,'Republic of Ireland','IRL'),(DEFAULT,'Sweden','SWE'),(DEFAULT,'Portugal','POR'),(DEFAULT,'Iceland','ISL'),(DEFAULT,'Austria','AUT'),(DEFAULT,'Hungary','HUN');\r\nExecuting (default): INSERT INTO \"MatchType\" (\"id\",\"code\",\"name\") VALUES (DEFAULT,'A','Group A'),(DEFAULT,'B','Group B'),(DEFAULT,'C','Group C'),(DEFAULT,'D','Group D'),(DEFAULT,'E','Group E'),(DEFAULT,'F','Group F'),(DEFAULT,'R16','Round of 16'),(DEFAULT,'QF','Quarter-final'),(DEFAULT,'SF','Semi-final'),(DEFAULT,'F','Final');\r\nExecuting (default): SELECT \"id\", \"name\", \"code\" FROM \"Team\" AS \"Team\";\r\nExecuting (default): SELECT \"id\", \"code\", \"name\" FROM \"MatchType\" AS \"MatchType\";\r\nExecuting (default): INSERT INTO \"Match\" (\"id\",\"when\",\"createdAt\",\"updatedAt\",\"HomeTeamId\",\"AwayTeamId\",\"MatchTypeId\") VALUES (DEFAULT,'2016-06-10 19:00:00.000 +00:00','2016-06-07 05:42:41.233 +00:00','2016-06-07 05:42:41.233 +00:00',1,2,1) RETURNING *;\r\n....\r\n-> % node index.js\r\nExecuting (default): CREATE OR REPLACE FUNCTION calc_score(integer, integer, integer, integer) RETURNS integer AS\r\n$$\r\n....\r\nCREATE OR REPLACE VIEW score_table\r\nAS WITH bets AS (\r\nSELECT b.\"UserId\" as id,\r\nsum(calc_score(m.\"goalsHome\", m.\"goalsAway\", b.\"goalsHome\", b.\"goalsAway\")) as score,\r\n....\r\n\r\nUnhandled rejection SequelizeDatabaseError: relation \"score_table\" does not exist\r\n  at [object Object].Query.formatError (/home/lsv/Projects/euro2016/node_modules/sequelize/lib/dialects/postgres/query.js:357:14)\r\n  at [object Object].<anonymous> (/home/lsv/Projects/euro2016/node_modules/sequelize/lib/dialects/postgres/query.js:88:19)\r\n  at emitOne (events.js:90:13)\r\n  at [object Object].emit (events.js:182:7)\r\n  at [object Object].Query.handleError (/home/lsv/Projects/euro2016/node_modules/pg/lib/query.js:108:8)\r\n  at [object Object].<anonymous> (/home/lsv/Projects/euro2016/node_modules/pg/lib/client.js:171:26)\r\n  at emitOne (events.js:90:13)\r\n  at [object Object].emit (events.js:182:7)\r\n  at Socket.<anonymous> (/home/lsv/Projects/euro2016/node_modules/pg/lib/connection.js:109:12)\r\n  at emitOne (events.js:90:13)\r\n  at Socket.emit (events.js:182:7)\r\n  at readableAddChunk (_stream_readable.js:153:18)\r\n  at Socket.Readable.push (_stream_readable.js:111:10)\r\n  at TCP.onread (net.js:534:20)\r\n```"},"comment":{"url":"https://api.github.com/repos/syxolk/euro2016/issues/comments/225316675","html_url":"https://github.com/syxolk/euro2016/issues/14#issuecomment-225316675","issue_url":"https://api.github.com/repos/syxolk/euro2016/issues/14","id":225316675,"user":{"login":"syxolk","id":6666063,"avatar_url":"https://avatars.githubusercontent.com/u/6666063?v=3","gravatar_id":"","url":"https://api.github.com/users/syxolk","html_url":"https://github.com/syxolk","followers_url":"https://api.github.com/users/syxolk/followers","following_url":"https://api.github.com/users/syxolk/following{/other_user}","gists_url":"https://api.github.com/users/syxolk/gists{/gist_id}","starred_url":"https://api.github.com/users/syxolk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/syxolk/subscriptions","organizations_url":"https://api.github.com/users/syxolk/orgs","repos_url":"https://api.github.com/users/syxolk/repos","events_url":"https://api.github.com/users/syxolk/events{/privacy}","received_events_url":"https://api.github.com/users/syxolk/received_events","type":"User","site_admin":false},"created_at":"2016-06-10T23:08:36Z","updated_at":"2016-06-10T23:08:36Z","body":"I've never expected so many people to be interested :D"}}
{"actor":{"display_login":"syxolk"}}