{"action":"closed","issue":{"url":"https://api.github.com/repos/rl-institut/WAM/issues/1","repository_url":"https://api.github.com/repos/rl-institut/WAM","labels_url":"https://api.github.com/repos/rl-institut/WAM/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/rl-institut/WAM/issues/1/comments","events_url":"https://api.github.com/repos/rl-institut/WAM/issues/1/events","html_url":"https://github.com/rl-institut/WAM/issues/1","id":383749783,"node_id":"MDU6SXNzdWUzODM3NDk3ODM=","number":1,"title":"Defining databases in WAM","user":{"login":"henhuy","id":17476051,"node_id":"MDQ6VXNlcjE3NDc2MDUx","avatar_url":"https://avatars3.githubusercontent.com/u/17476051?v=4","gravatar_id":"","url":"https://api.github.com/users/henhuy","html_url":"https://github.com/henhuy","followers_url":"https://api.github.com/users/henhuy/followers","following_url":"https://api.github.com/users/henhuy/following{/other_user}","gists_url":"https://api.github.com/users/henhuy/gists{/gist_id}","starred_url":"https://api.github.com/users/henhuy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/henhuy/subscriptions","organizations_url":"https://api.github.com/users/henhuy/orgs","repos_url":"https://api.github.com/users/henhuy/repos","events_url":"https://api.github.com/users/henhuy/events{/privacy}","received_events_url":"https://api.github.com/users/henhuy/received_events","type":"User","site_admin":false},"labels":[{"id":1137555322,"node_id":"MDU6TGFiZWwxMTM3NTU1MzIy","url":"https://api.github.com/repos/rl-institut/WAM/labels/Feedback","name":"Feedback","color":"47ffb8","default":false},{"id":1119398679,"node_id":"MDU6TGFiZWwxMTE5Mzk4Njc5","url":"https://api.github.com/repos/rl-institut/WAM/labels/enhancement","name":"enhancement","color":"a2eeef","default":true}],"state":"closed","locked":false,"assignee":{"login":"Ludee","id":14353512,"node_id":"MDQ6VXNlcjE0MzUzNTEy","avatar_url":"https://avatars0.githubusercontent.com/u/14353512?v=4","gravatar_id":"","url":"https://api.github.com/users/Ludee","html_url":"https://github.com/Ludee","followers_url":"https://api.github.com/users/Ludee/followers","following_url":"https://api.github.com/users/Ludee/following{/other_user}","gists_url":"https://api.github.com/users/Ludee/gists{/gist_id}","starred_url":"https://api.github.com/users/Ludee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ludee/subscriptions","organizations_url":"https://api.github.com/users/Ludee/orgs","repos_url":"https://api.github.com/users/Ludee/repos","events_url":"https://api.github.com/users/Ludee/events{/privacy}","received_events_url":"https://api.github.com/users/Ludee/received_events","type":"User","site_admin":false},"assignees":[{"login":"Ludee","id":14353512,"node_id":"MDQ6VXNlcjE0MzUzNTEy","avatar_url":"https://avatars0.githubusercontent.com/u/14353512?v=4","gravatar_id":"","url":"https://api.github.com/users/Ludee","html_url":"https://github.com/Ludee","followers_url":"https://api.github.com/users/Ludee/followers","following_url":"https://api.github.com/users/Ludee/following{/other_user}","gists_url":"https://api.github.com/users/Ludee/gists{/gist_id}","starred_url":"https://api.github.com/users/Ludee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ludee/subscriptions","organizations_url":"https://api.github.com/users/Ludee/orgs","repos_url":"https://api.github.com/users/Ludee/repos","events_url":"https://api.github.com/users/Ludee/events{/privacy}","received_events_url":"https://api.github.com/users/Ludee/received_events","type":"User","site_admin":false},{"login":"nesnoj","id":15910173,"node_id":"MDQ6VXNlcjE1OTEwMTcz","avatar_url":"https://avatars0.githubusercontent.com/u/15910173?v=4","gravatar_id":"","url":"https://api.github.com/users/nesnoj","html_url":"https://github.com/nesnoj","followers_url":"https://api.github.com/users/nesnoj/followers","following_url":"https://api.github.com/users/nesnoj/following{/other_user}","gists_url":"https://api.github.com/users/nesnoj/gists{/gist_id}","starred_url":"https://api.github.com/users/nesnoj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nesnoj/subscriptions","organizations_url":"https://api.github.com/users/nesnoj/orgs","repos_url":"https://api.github.com/users/nesnoj/repos","events_url":"https://api.github.com/users/nesnoj/events{/privacy}","received_events_url":"https://api.github.com/users/nesnoj/received_events","type":"User","site_admin":false},{"login":"henhuy","id":17476051,"node_id":"MDQ6VXNlcjE3NDc2MDUx","avatar_url":"https://avatars3.githubusercontent.com/u/17476051?v=4","gravatar_id":"","url":"https://api.github.com/users/henhuy","html_url":"https://github.com/henhuy","followers_url":"https://api.github.com/users/henhuy/followers","following_url":"https://api.github.com/users/henhuy/following{/other_user}","gists_url":"https://api.github.com/users/henhuy/gists{/gist_id}","starred_url":"https://api.github.com/users/henhuy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/henhuy/subscriptions","organizations_url":"https://api.github.com/users/henhuy/orgs","repos_url":"https://api.github.com/users/henhuy/repos","events_url":"https://api.github.com/users/henhuy/events{/privacy}","received_events_url":"https://api.github.com/users/henhuy/received_events","type":"User","site_admin":false},{"login":"jh-RLI","id":38939526,"node_id":"MDQ6VXNlcjM4OTM5NTI2","avatar_url":"https://avatars1.githubusercontent.com/u/38939526?v=4","gravatar_id":"","url":"https://api.github.com/users/jh-RLI","html_url":"https://github.com/jh-RLI","followers_url":"https://api.github.com/users/jh-RLI/followers","following_url":"https://api.github.com/users/jh-RLI/following{/other_user}","gists_url":"https://api.github.com/users/jh-RLI/gists{/gist_id}","starred_url":"https://api.github.com/users/jh-RLI/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jh-RLI/subscriptions","organizations_url":"https://api.github.com/users/jh-RLI/orgs","repos_url":"https://api.github.com/users/jh-RLI/repos","events_url":"https://api.github.com/users/jh-RLI/events{/privacy}","received_events_url":"https://api.github.com/users/jh-RLI/received_events","type":"User","site_admin":false}],"milestone":null,"comments":4,"created_at":"2018-11-23T09:21:37Z","updated_at":"2018-11-30T09:45:18Z","closed_at":"2018-11-30T09:45:18Z","author_association":"CONTRIBUTOR","body":"Within this issue, I want to discuss multiple minor ideas about database integration in the WAM.\r\n\r\n1. Engine Name:\r\nRight now,WAM  _settings.py_ loads `DEFAULT` database config from `CONFIG_PATH` `[DATABASES]` section. Afterwards, `'django.db.backends.'` is added in front of `ENGINE` name. The idea behind that, was to allow one setup for both Django ORM and SQLAlchemy (I connect to same db from both ORMs), as SQLAlchemy requires engine as _posstgresql_ and django as _django.db.backends.postgresql_. Maybe we should change that to full engine name, to avoid \"magic\" string manipulation within code.\r\n\r\n2. WAM-default database:\r\nMy app only needs _django.db.backends.postgresql_ engine. But stemp_abw app for example needs _django.contrib.gis.db.backends.postgis_. As the latter one works for both cases, I would set up this engine as our default engine. Okay?\r\n\r\n3. Multiple databases simultaneously:\r\nIn django, it is also possible to run multiple dbs in parallel. Therefore, database routers have to be set up, which map models to specific databases (see https://docs.djangoproject.com/en/2.1/topics/db/multi-db/). But using this technic, could get us into some pitfalls, as database migration has to be performed on all databases and cross-relations are difficult. So maybe we should avoid it until it's deeply necessary. D'accord?"}}
{"actor":{"display_login":"henhuy"}}