{"action":"created","issue":{"url":"https://api.github.com/repos/kerdokullamae/test_issues2/issues/80","repository_url":"https://api.github.com/repos/kerdokullamae/test_issues2","labels_url":"https://api.github.com/repos/kerdokullamae/test_issues2/issues/80/labels{/name}","comments_url":"https://api.github.com/repos/kerdokullamae/test_issues2/issues/80/comments","events_url":"https://api.github.com/repos/kerdokullamae/test_issues2/issues/80/events","html_url":"https://github.com/kerdokullamae/test_issues2/issues/80","id":308580814,"number":80,"title":"Isikud ja organisatsioonid: PG/AIS -> PG import","user":{"login":"kerdokullamae","id":15349596,"avatar_url":"https://avatars2.githubusercontent.com/u/15349596?v=4","gravatar_id":"","url":"https://api.github.com/users/kerdokullamae","html_url":"https://github.com/kerdokullamae","followers_url":"https://api.github.com/users/kerdokullamae/followers","following_url":"https://api.github.com/users/kerdokullamae/following{/other_user}","gists_url":"https://api.github.com/users/kerdokullamae/gists{/gist_id}","starred_url":"https://api.github.com/users/kerdokullamae/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kerdokullamae/subscriptions","organizations_url":"https://api.github.com/users/kerdokullamae/orgs","repos_url":"https://api.github.com/users/kerdokullamae/repos","events_url":"https://api.github.com/users/kerdokullamae/events{/privacy}","received_events_url":"https://api.github.com/users/kerdokullamae/received_events","type":"User","site_admin":false},"labels":[{"id":879750873,"url":"https://api.github.com/repos/kerdokullamae/test_issues2/labels/P:%20highest","name":"P: highest","color":"aa8888","default":false},{"id":879750996,"url":"https://api.github.com/repos/kerdokullamae/test_issues2/labels/T:%20task","name":"T: task","color":"cccccc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":8,"created_at":"2018-03-26T13:50:36Z","updated_at":"2018-03-26T13:52:15Z","closed_at":null,"author_association":"OWNER","body":"**Reported by sven syld on 20 Jul 2012 11:48 UTC**\n'''Object'''\r\n Isikute ja organisatsioonide ja nende seotud andmed\r\n\r\n'''!ToDo'''\r\n Importida detailvaateks vajalikud andmed.\r\n \r\n Tegevusaegade ja dokumentide import teha eraldi, kuna nende andmebaasistruktuur vajab muutmist.\r\n\r\n Imporditavad loogilised blokid:\r\n 1) nimed - am_nimevorm -> person_name (vana tabel -> uus tabel)\r\n 2) tegevusaeg/eluaeg - tegevusaeg (vliik='AM'?) -> person_period?\r\n 3) asukoht/elukoht - ? -> contact_bundle+contact. Parim pakkumine imporditavaks tabeliks on \"postiaadress\", aga see on RA poolt märgitud mittevajalikuks. Kiri saadetud RA-le.\r\n 4) staatus/rahvus - am_staatus -> person_status\r\n 5) funktsioon/ametikohad - ? -> ?. Ei ole teada ei vana ega uus struktuur, kiri saadetud RA-le\r\n 6) struktuur/sugupuu - am_struktuur -> person_structure\r\n 7) ajalugu/elulugu - väljast person.history\r\n 8) publikatsioonid - dokument? -> file_bundle+file\r\n 9) setoud isikud - am_arhmoodustaja -> person_relation"},"comment":{"url":"https://api.github.com/repos/kerdokullamae/test_issues2/issues/comments/376173214","html_url":"https://github.com/kerdokullamae/test_issues2/issues/80#issuecomment-376173214","issue_url":"https://api.github.com/repos/kerdokullamae/test_issues2/issues/80","id":376173214,"user":{"login":"kerdokullamae","id":15349596,"avatar_url":"https://avatars2.githubusercontent.com/u/15349596?v=4","gravatar_id":"","url":"https://api.github.com/users/kerdokullamae","html_url":"https://github.com/kerdokullamae","followers_url":"https://api.github.com/users/kerdokullamae/followers","following_url":"https://api.github.com/users/kerdokullamae/following{/other_user}","gists_url":"https://api.github.com/users/kerdokullamae/gists{/gist_id}","starred_url":"https://api.github.com/users/kerdokullamae/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kerdokullamae/subscriptions","organizations_url":"https://api.github.com/users/kerdokullamae/orgs","repos_url":"https://api.github.com/users/kerdokullamae/repos","events_url":"https://api.github.com/users/kerdokullamae/events{/privacy}","received_events_url":"https://api.github.com/users/kerdokullamae/received_events","type":"User","site_admin":false},"created_at":"2018-03-26T13:52:15Z","updated_at":"2018-03-26T13:52:15Z","author_association":"OWNER","body":"**Comment by sven.syld on 23 Jul 2012 20:07 UTC**\n[83] andmetele vastavad muudatused andmemudelis\r\n\r\nAndmete importija asub endiselt Dropboxis, Projektide all. Tükeldasin importerid etappide järgi failidesse. Isikute impordiks tuleks diradb.teepub'is käima lasta (või kopida SQLid pgadmini):\r\n 1) 02-pgais-to-pg-importer-00-functions.sh\r\n 2) 02-pgais-to-pg-importer-20-person.sh"}}
{"actor":{"display_login":"kerdokullamae"}}