{"action":"opened","issue":{"url":"https://api.github.com/repos/wwevo/guildhome/issues/92","repository_url":"https://api.github.com/repos/wwevo/guildhome","labels_url":"https://api.github.com/repos/wwevo/guildhome/issues/92/labels{/name}","comments_url":"https://api.github.com/repos/wwevo/guildhome/issues/92/comments","events_url":"https://api.github.com/repos/wwevo/guildhome/issues/92/events","html_url":"https://github.com/wwevo/guildhome/issues/92","id":187559587,"number":92,"title":"Save API character data to database","user":{"login":"AniOnGit","id":20889890,"avatar_url":"https://avatars.githubusercontent.com/u/20889890?v=3","gravatar_id":"","url":"https://api.github.com/users/AniOnGit","html_url":"https://github.com/AniOnGit","followers_url":"https://api.github.com/users/AniOnGit/followers","following_url":"https://api.github.com/users/AniOnGit/following{/other_user}","gists_url":"https://api.github.com/users/AniOnGit/gists{/gist_id}","starred_url":"https://api.github.com/users/AniOnGit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AniOnGit/subscriptions","organizations_url":"https://api.github.com/users/AniOnGit/orgs","repos_url":"https://api.github.com/users/AniOnGit/repos","events_url":"https://api.github.com/users/AniOnGit/events{/privacy}","received_events_url":"https://api.github.com/users/AniOnGit/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/wwevo/guildhome/milestones/14","html_url":"https://github.com/wwevo/guildhome/milestones/GW2%20API","labels_url":"https://api.github.com/repos/wwevo/guildhome/milestones/14/labels","id":2117113,"number":14,"title":"GW2 API","description":"This milestone describes functions we need related to GW2 API communication, caching, updating and other stuff.","creator":{"login":"AniOnGit","id":20889890,"avatar_url":"https://avatars.githubusercontent.com/u/20889890?v=3","gravatar_id":"","url":"https://api.github.com/users/AniOnGit","html_url":"https://github.com/AniOnGit","followers_url":"https://api.github.com/users/AniOnGit/followers","following_url":"https://api.github.com/users/AniOnGit/following{/other_user}","gists_url":"https://api.github.com/users/AniOnGit/gists{/gist_id}","starred_url":"https://api.github.com/users/AniOnGit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AniOnGit/subscriptions","organizations_url":"https://api.github.com/users/AniOnGit/orgs","repos_url":"https://api.github.com/users/AniOnGit/repos","events_url":"https://api.github.com/users/AniOnGit/events{/privacy}","received_events_url":"https://api.github.com/users/AniOnGit/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":0,"state":"open","created_at":"2016-11-06T12:41:07Z","updated_at":"2016-11-06T12:47:22Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2016-11-06T12:47:22Z","updated_at":"2016-11-06T12:47:22Z","closed_at":null,"body":"As a first step in persisting the api data we save a users characters to our database. It would be nice if we could cache the following columns there:\r\nLvl,Name,Race,Class,Gender,Age,Created\r\n\r\nRegarding to the current 'characters table view' we need the class additionally. Birthday in column can be calculated on request (as it's an ever changing field we don't want to save to the db). About deaths, I am not sure if we need it, I would drop that column for now just because it's ever changing und would need to be re-requested from the api every time. Other ideas?\r\n\r\n**Steps to success:**\r\n1. Create database tables.\r\n2. Save data to the tables instead of one settings fields.\r\n3. Adjust query for receiving the character data.\r\n3. Request class value and integrate it in save and query routine."}}
{"actor":{"display_login":"AniOnGit"}}