{"action":"created","issue":{"url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/issues/88","repository_url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler","labels_url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/issues/88/labels{/name}","comments_url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/issues/88/comments","events_url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/issues/88/events","html_url":"https://github.com/strongloop/loopback-datasource-juggler/issues/88","id":29914242,"number":88,"title":"Indexes and cascade behaviours TBD","user":{"login":"pandaiolo","id":1933404,"avatar_url":"https://avatars.githubusercontent.com/u/1933404?v=3","gravatar_id":"","url":"https://api.github.com/users/pandaiolo","html_url":"https://github.com/pandaiolo","followers_url":"https://api.github.com/users/pandaiolo/followers","following_url":"https://api.github.com/users/pandaiolo/following{/other_user}","gists_url":"https://api.github.com/users/pandaiolo/gists{/gist_id}","starred_url":"https://api.github.com/users/pandaiolo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pandaiolo/subscriptions","organizations_url":"https://api.github.com/users/pandaiolo/orgs","repos_url":"https://api.github.com/users/pandaiolo/repos","events_url":"https://api.github.com/users/pandaiolo/events{/privacy}","received_events_url":"https://api.github.com/users/pandaiolo/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/labels/connectors-nosql","name":"connectors-nosql","color":"eeeeee"},{"url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/labels/connectors-sql","name":"connectors-sql","color":"eeeeee"},{"url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/labels/ease-of-use","name":"ease-of-use","color":"eeeeee"},{"url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/labels/juggler-DAO","name":"juggler-DAO","color":"eeeeee"}],"state":"open","locked":false,"assignee":{"login":"raymondfeng","id":540892,"avatar_url":"https://avatars.githubusercontent.com/u/540892?v=3","gravatar_id":"","url":"https://api.github.com/users/raymondfeng","html_url":"https://github.com/raymondfeng","followers_url":"https://api.github.com/users/raymondfeng/followers","following_url":"https://api.github.com/users/raymondfeng/following{/other_user}","gists_url":"https://api.github.com/users/raymondfeng/gists{/gist_id}","starred_url":"https://api.github.com/users/raymondfeng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raymondfeng/subscriptions","organizations_url":"https://api.github.com/users/raymondfeng/orgs","repos_url":"https://api.github.com/users/raymondfeng/repos","events_url":"https://api.github.com/users/raymondfeng/events{/privacy}","received_events_url":"https://api.github.com/users/raymondfeng/received_events","type":"User","site_admin":false},"assignees":[{"login":"raymondfeng","id":540892,"avatar_url":"https://avatars.githubusercontent.com/u/540892?v=3","gravatar_id":"","url":"https://api.github.com/users/raymondfeng","html_url":"https://github.com/raymondfeng","followers_url":"https://api.github.com/users/raymondfeng/followers","following_url":"https://api.github.com/users/raymondfeng/following{/other_user}","gists_url":"https://api.github.com/users/raymondfeng/gists{/gist_id}","starred_url":"https://api.github.com/users/raymondfeng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raymondfeng/subscriptions","organizations_url":"https://api.github.com/users/raymondfeng/orgs","repos_url":"https://api.github.com/users/raymondfeng/repos","events_url":"https://api.github.com/users/raymondfeng/events{/privacy}","received_events_url":"https://api.github.com/users/raymondfeng/received_events","type":"User","site_admin":false}],"milestone":null,"comments":27,"created_at":"2014-03-21T16:28:03Z","updated_at":"2016-08-18T00:45:54Z","closed_at":null,"body":"As discussed in https://groups.google.com/forum/#!topic/loopbackjs/z7bW9UFJzCU\r\n\r\nI recently noticed some issues or sub-optimal behaviour with loopback models storage in the database : \r\n\r\n * How index are created (for exampe: mongodb foreign key are not indexed, at least for many-to-many)\r\n\r\n * How interface tables items are dealt with, for example deleting links when a parent object is deleted (cascade)\r\n\r\n**Example** : when i remove items in table *Product* and/or *Category*, via loopback API, items in `product` and `category` collection are deleted, but not `productcategory` collection\r\n\r\nIn a RDBMS, I suspect the best practice is to define FK and cascade behaviour in the DB engine, but in noSQL like mongodb, should not this be taken care of by Loopback ?\r\n"},"comment":{"url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/issues/comments/240592670","html_url":"https://github.com/strongloop/loopback-datasource-juggler/issues/88#issuecomment-240592670","issue_url":"https://api.github.com/repos/strongloop/loopback-datasource-juggler/issues/88","id":240592670,"user":{"login":"dancingshell","id":6993945,"avatar_url":"https://avatars.githubusercontent.com/u/6993945?v=3","gravatar_id":"","url":"https://api.github.com/users/dancingshell","html_url":"https://github.com/dancingshell","followers_url":"https://api.github.com/users/dancingshell/followers","following_url":"https://api.github.com/users/dancingshell/following{/other_user}","gists_url":"https://api.github.com/users/dancingshell/gists{/gist_id}","starred_url":"https://api.github.com/users/dancingshell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dancingshell/subscriptions","organizations_url":"https://api.github.com/users/dancingshell/orgs","repos_url":"https://api.github.com/users/dancingshell/repos","events_url":"https://api.github.com/users/dancingshell/events{/privacy}","received_events_url":"https://api.github.com/users/dancingshell/received_events","type":"User","site_admin":false},"created_at":"2016-08-18T00:45:53Z","updated_at":"2016-08-18T00:45:53Z","body":"@raymondfeng it seems like foreign key indexes are still not being created, did that ever get merged in? Thanks!"}}
{"actor":{"display_login":"dancingshell"}}