{"action":"created","issue":{"url":"https://api.github.com/repos/pietermartin/sqlg/issues/50","repository_url":"https://api.github.com/repos/pietermartin/sqlg","labels_url":"https://api.github.com/repos/pietermartin/sqlg/issues/50/labels{/name}","comments_url":"https://api.github.com/repos/pietermartin/sqlg/issues/50/comments","events_url":"https://api.github.com/repos/pietermartin/sqlg/issues/50/events","html_url":"https://github.com/pietermartin/sqlg/issues/50","id":157549102,"number":50,"title":"Refactor schema maps to reflect the topology","user":{"login":"pietermartin","id":439356,"avatar_url":"https://avatars.githubusercontent.com/u/439356?v=3","gravatar_id":"","url":"https://api.github.com/users/pietermartin","html_url":"https://github.com/pietermartin","followers_url":"https://api.github.com/users/pietermartin/followers","following_url":"https://api.github.com/users/pietermartin/following{/other_user}","gists_url":"https://api.github.com/users/pietermartin/gists{/gist_id}","starred_url":"https://api.github.com/users/pietermartin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pietermartin/subscriptions","organizations_url":"https://api.github.com/users/pietermartin/orgs","repos_url":"https://api.github.com/users/pietermartin/repos","events_url":"https://api.github.com/users/pietermartin/events{/privacy}","received_events_url":"https://api.github.com/users/pietermartin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-05-30T19:42:44Z","updated_at":"2016-09-22T11:56:12Z","closed_at":null,"body":"Now that the topology is in the db capture the topology in maps that reflect the graph property map schema rather than the rdbms mapping.\r\n\r\nCurrently unnecessary sql is executed because the edge table foreign keys do not know the opposite side.\r\n\r\n        Vertex a1 = this.sqlgGraph.addVertex(T.label, \"A\");\r\n        Vertex b1 = this.sqlgGraph.addVertex(T.label, \"B\");\r\n        Vertex b2 = this.sqlgGraph.addVertex(T.label, \"B\");\r\n        Vertex bb1 = this.sqlgGraph.addVertex(T.label, \"BB\");\r\n        Vertex bb2 = this.sqlgGraph.addVertex(T.label, \"BB\");\r\n        a1.addEdge(\"ab\", b1);\r\n        a1.addEdge(\"ab\", b2);\r\n        bb1.addEdge(\"ab\", a1);\r\n        bb2.addEdge(\"ab\", a1);\r\n        this.sqlgGraph.tx().commit();\r\n\r\n        List<Vertex> vertices = this.sqlgGraph.traversal().V(a1).out(\"ab\").toList();\r\n\r\nThis will execute one unnecessary sql statement. It still works though as the query returns nothing."},"comment":{"url":"https://api.github.com/repos/pietermartin/sqlg/issues/comments/248882635","html_url":"https://github.com/pietermartin/sqlg/issues/50#issuecomment-248882635","issue_url":"https://api.github.com/repos/pietermartin/sqlg/issues/50","id":248882635,"user":{"login":"pietermartin","id":439356,"avatar_url":"https://avatars.githubusercontent.com/u/439356?v=3","gravatar_id":"","url":"https://api.github.com/users/pietermartin","html_url":"https://github.com/pietermartin","followers_url":"https://api.github.com/users/pietermartin/followers","following_url":"https://api.github.com/users/pietermartin/following{/other_user}","gists_url":"https://api.github.com/users/pietermartin/gists{/gist_id}","starred_url":"https://api.github.com/users/pietermartin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pietermartin/subscriptions","organizations_url":"https://api.github.com/users/pietermartin/orgs","repos_url":"https://api.github.com/users/pietermartin/repos","events_url":"https://api.github.com/users/pietermartin/events{/privacy}","received_events_url":"https://api.github.com/users/pietermartin/received_events","type":"User","site_admin":false},"created_at":"2016-09-22T11:56:12Z","updated_at":"2016-09-22T11:56:12Z","body":"This is being done as part of #58 "}}
{"actor":{"display_login":"pietermartin"}}