{"action":"created","issue":{"url":"https://api.github.com/repos/mlipscombe/postgraphile-plugin-nested-mutations/issues/9","repository_url":"https://api.github.com/repos/mlipscombe/postgraphile-plugin-nested-mutations","labels_url":"https://api.github.com/repos/mlipscombe/postgraphile-plugin-nested-mutations/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/mlipscombe/postgraphile-plugin-nested-mutations/issues/9/comments","events_url":"https://api.github.com/repos/mlipscombe/postgraphile-plugin-nested-mutations/issues/9/events","html_url":"https://github.com/mlipscombe/postgraphile-plugin-nested-mutations/issues/9","id":388485478,"node_id":"MDU6SXNzdWUzODg0ODU0Nzg=","number":9,"title":"Missing relationships from tables with multiple foreign-keys to the same related table","user":{"login":"furious-luke","id":561722,"node_id":"MDQ6VXNlcjU2MTcyMg==","avatar_url":"https://avatars2.githubusercontent.com/u/561722?v=4","gravatar_id":"","url":"https://api.github.com/users/furious-luke","html_url":"https://github.com/furious-luke","followers_url":"https://api.github.com/users/furious-luke/followers","following_url":"https://api.github.com/users/furious-luke/following{/other_user}","gists_url":"https://api.github.com/users/furious-luke/gists{/gist_id}","starred_url":"https://api.github.com/users/furious-luke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/furious-luke/subscriptions","organizations_url":"https://api.github.com/users/furious-luke/orgs","repos_url":"https://api.github.com/users/furious-luke/repos","events_url":"https://api.github.com/users/furious-luke/events{/privacy}","received_events_url":"https://api.github.com/users/furious-luke/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-12-07T02:57:07Z","updated_at":"2018-12-31T01:35:54Z","closed_at":"2018-12-31T01:35:54Z","author_association":"NONE","body":"Hi there, thanks for making a great plugin for PostGraphile, it's very useful.\r\n\r\nI've noticed that when I use the plugin for tables that contain multiple connections to the same related table, only one of the reverse connections appears as a possible input to the mutation. As an example consider the following tables that might be used to represent a job and a relationship between jobs:\r\n\r\n```sql\r\ncreate table job (\r\n  id serial primary key,\r\n);\r\n\r\ncreate table job_relationship (\r\n  type text,\r\n  from_job_id integer references job(id),\r\n  to_job_id integer references job(id)\r\n);\r\n```\r\n\r\nIn this scenario, the GraphQL type produced for creating a \"job\" would include the reverse input for the \"to_job_id\" relationship only; the \"from_job_id\" input is not available."},"comment":{"url":"https://api.github.com/repos/mlipscombe/postgraphile-plugin-nested-mutations/issues/comments/450599931","html_url":"https://github.com/mlipscombe/postgraphile-plugin-nested-mutations/issues/9#issuecomment-450599931","issue_url":"https://api.github.com/repos/mlipscombe/postgraphile-plugin-nested-mutations/issues/9","id":450599931,"node_id":"MDEyOklzc3VlQ29tbWVudDQ1MDU5OTkzMQ==","user":{"login":"mlipscombe","id":88502,"node_id":"MDQ6VXNlcjg4NTAy","avatar_url":"https://avatars0.githubusercontent.com/u/88502?v=4","gravatar_id":"","url":"https://api.github.com/users/mlipscombe","html_url":"https://github.com/mlipscombe","followers_url":"https://api.github.com/users/mlipscombe/followers","following_url":"https://api.github.com/users/mlipscombe/following{/other_user}","gists_url":"https://api.github.com/users/mlipscombe/gists{/gist_id}","starred_url":"https://api.github.com/users/mlipscombe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mlipscombe/subscriptions","organizations_url":"https://api.github.com/users/mlipscombe/orgs","repos_url":"https://api.github.com/users/mlipscombe/repos","events_url":"https://api.github.com/users/mlipscombe/events{/privacy}","received_events_url":"https://api.github.com/users/mlipscombe/received_events","type":"User","site_admin":false},"created_at":"2018-12-31T01:35:54Z","updated_at":"2018-12-31T01:35:54Z","author_association":"OWNER","body":"This should be fixed in the latest version.  Tables that have multiple FKs between them should now generate field names that include the key fields.  Feel free to reopen if anything isn't working right."}}
{"actor":{"display_login":"mlipscombe"}}