{"action":"created","comment":{"url":"https://api.github.com/repos/CESNET/perun/pulls/comments/51382200","id":51382200,"diff_hunk":"@@ -3,6 +3,30 @@\n -- Directly under version number should be version commands. They will be executed in the order they are written here.\n -- Comments are prefixed with -- and can be written only between version blocks, that means not in the lines with commands. They have to be at the start of the line.\n \n+3.1.35\n+alter table user add sponsored_acc char(1) default '0' not null;","path":"perun-core/src/main/resources/postgresChangelog.txt","position":5,"original_position":5,"commit_id":"711891f674888207546a613ca7d22193d149efa2","original_commit_id":"711891f674888207546a613ca7d22193d149efa2","user":{"login":"zlamalp","id":1336607,"avatar_url":"https://avatars.githubusercontent.com/u/1336607?v=3","gravatar_id":"","url":"https://api.github.com/users/zlamalp","html_url":"https://github.com/zlamalp","followers_url":"https://api.github.com/users/zlamalp/followers","following_url":"https://api.github.com/users/zlamalp/following{/other_user}","gists_url":"https://api.github.com/users/zlamalp/gists{/gist_id}","starred_url":"https://api.github.com/users/zlamalp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zlamalp/subscriptions","organizations_url":"https://api.github.com/users/zlamalp/orgs","repos_url":"https://api.github.com/users/zlamalp/repos","events_url":"https://api.github.com/users/zlamalp/events{/privacy}","received_events_url":"https://api.github.com/users/zlamalp/received_events","type":"User","site_admin":false},"body":"```sql\r\nalter table users add sponsored_acc char(1) default '0' not null;\r\n```\r\n(user -> users)","created_at":"2016-02-01T06:11:42Z","updated_at":"2016-02-01T06:11:42Z","html_url":"https://github.com/CESNET/perun/pull/1084#discussion_r51382200","pull_request_url":"https://api.github.com/repos/CESNET/perun/pulls/1084","_links":{"self":{"href":"https://api.github.com/repos/CESNET/perun/pulls/comments/51382200"},"html":{"href":"https://github.com/CESNET/perun/pull/1084#discussion_r51382200"},"pull_request":{"href":"https://api.github.com/repos/CESNET/perun/pulls/1084"}}},"pull_request":{"url":"https://api.github.com/repos/CESNET/perun/pulls/1084","id":57332373,"html_url":"https://github.com/CESNET/perun/pull/1084","diff_url":"https://github.com/CESNET/perun/pull/1084.diff","patch_url":"https://github.com/CESNET/perun/pull/1084.patch","issue_url":"https://api.github.com/repos/CESNET/perun/issues/1084","number":1084,"state":"open","locked":false,"title":"New sponsored user type","user":{"login":"stavamichal","id":5602147,"avatar_url":"https://avatars.githubusercontent.com/u/5602147?v=3","gravatar_id":"","url":"https://api.github.com/users/stavamichal","html_url":"https://github.com/stavamichal","followers_url":"https://api.github.com/users/stavamichal/followers","following_url":"https://api.github.com/users/stavamichal/following{/other_user}","gists_url":"https://api.github.com/users/stavamichal/gists{/gist_id}","starred_url":"https://api.github.com/users/stavamichal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stavamichal/subscriptions","organizations_url":"https://api.github.com/users/stavamichal/orgs","repos_url":"https://api.github.com/users/stavamichal/repos","events_url":"https://api.github.com/users/stavamichal/events{/privacy}","received_events_url":"https://api.github.com/users/stavamichal/received_events","type":"User","site_admin":false},"body":" - user can be normal, service or sponsored\r\n - need changes in database, add type column with 'service' or\r\n   'sponsored' info\r\n - all methods like 'getServiceUser' need to work with specificUser\r\n   instead so they are renamed to something like 'getSpecificUser'\r\n - rename existing exceptions from service to specific\r\n - add new enum object specificUserType with values normal, service and\r\n   specific to choose which type we want to use for user\r\n - add new role SPONSOR to define relationship between sponsor and his\r\n   sponsored users\r\n - modify row mappers in usersManager and authzResolverManager using new\r\n   database schema for this funcionality\r\n - add new attribute sponsoredUser to User object and also add all\r\n   needed methods for working with it\r\n - modify parsing of user in auditParser due to sponsoredUser attribute\r\n - add this behavior also to LDAP (attribute sponsoredUser) to recognize\r\n   who is sponsored, who is normal and who is service user in LDAP\r\n - add this behavior also to LDAP initializator to be able initialize\r\n   all information about user specification to LDAP\r\n - add new tests for testing work with sponsored users","created_at":"2016-01-27T09:19:59Z","updated_at":"2016-02-01T06:11:42Z","closed_at":null,"merged_at":null,"merge_commit_sha":"f03b1f81747b856b5f854e0f6a3943fb12e2aaf3","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/CESNET/perun/pulls/1084/commits","review_comments_url":"https://api.github.com/repos/CESNET/perun/pulls/1084/comments","review_comment_url":"https://api.github.com/repos/CESNET/perun/pulls/comments{/number}","comments_url":"https://api.github.com/repos/CESNET/perun/issues/1084/comments","statuses_url":"https://api.github.com/repos/CESNET/perun/statuses/711891f674888207546a613ca7d22193d149efa2","head":{"label":"stavamichal:useSpecificUserInsteadOfService","ref":"useSpecificUserInsteadOfService","sha":"711891f674888207546a613ca7d22193d149efa2","user":{"login":"stavamichal","id":5602147,"avatar_url":"https://avatars.githubusercontent.com/u/5602147?v=3","gravatar_id":"","url":"https://api.github.com/users/stavamichal","html_url":"https://github.com/stavamichal","followers_url":"https://api.github.com/users/stavamichal/followers","following_url":"https://api.github.com/users/stavamichal/following{/other_user}","gists_url":"https://api.github.com/users/stavamichal/gists{/gist_id}","starred_url":"https://api.github.com/users/stavamichal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stavamichal/subscriptions","organizations_url":"https://api.github.com/users/stavamichal/orgs","repos_url":"https://api.github.com/users/stavamichal/repos","events_url":"https://api.github.com/users/stavamichal/events{/privacy}","received_events_url":"https://api.github.com/users/stavamichal/received_events","type":"User","site_admin":false},"repo":{"id":13856179,"name":"perun","full_name":"stavamichal/perun","owner":{"login":"stavamichal","id":5602147,"avatar_url":"https://avatars.githubusercontent.com/u/5602147?v=3","gravatar_id":"","url":"https://api.github.com/users/stavamichal","html_url":"https://github.com/stavamichal","followers_url":"https://api.github.com/users/stavamichal/followers","following_url":"https://api.github.com/users/stavamichal/following{/other_user}","gists_url":"https://api.github.com/users/stavamichal/gists{/gist_id}","starred_url":"https://api.github.com/users/stavamichal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stavamichal/subscriptions","organizations_url":"https://api.github.com/users/stavamichal/orgs","repos_url":"https://api.github.com/users/stavamichal/repos","events_url":"https://api.github.com/users/stavamichal/events{/privacy}","received_events_url":"https://api.github.com/users/stavamichal/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/stavamichal/perun","description":"Users, Groups, Services and Resources Management System","fork":true,"url":"https://api.github.com/repos/stavamichal/perun","forks_url":"https://api.github.com/repos/stavamichal/perun/forks","keys_url":"https://api.github.com/repos/stavamichal/perun/keys{/key_id}","collaborators_url":"https://api.github.com/repos/stavamichal/perun/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/stavamichal/perun/teams","hooks_url":"https://api.github.com/repos/stavamichal/perun/hooks","issue_events_url":"https://api.github.com/repos/stavamichal/perun/issues/events{/number}","events_url":"https://api.github.com/repos/stavamichal/perun/events","assignees_url":"https://api.github.com/repos/stavamichal/perun/assignees{/user}","branches_url":"https://api.github.com/repos/stavamichal/perun/branches{/branch}","tags_url":"https://api.github.com/repos/stavamichal/perun/tags","blobs_url":"https://api.github.com/repos/stavamichal/perun/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/stavamichal/perun/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/stavamichal/perun/git/refs{/sha}","trees_url":"https://api.github.com/repos/stavamichal/perun/git/trees{/sha}","statuses_url":"https://api.github.com/repos/stavamichal/perun/statuses/{sha}","languages_url":"https://api.github.com/repos/stavamichal/perun/languages","stargazers_url":"https://api.github.com/repos/stavamichal/perun/stargazers","contributors_url":"https://api.github.com/repos/stavamichal/perun/contributors","subscribers_url":"https://api.github.com/repos/stavamichal/perun/subscribers","subscription_url":"https://api.github.com/repos/stavamichal/perun/subscription","commits_url":"https://api.github.com/repos/stavamichal/perun/commits{/sha}","git_commits_url":"https://api.github.com/repos/stavamichal/perun/git/commits{/sha}","comments_url":"https://api.github.com/repos/stavamichal/perun/comments{/number}","issue_comment_url":"https://api.github.com/repos/stavamichal/perun/issues/comments{/number}","contents_url":"https://api.github.com/repos/stavamichal/perun/contents/{+path}","compare_url":"https://api.github.com/repos/stavamichal/perun/compare/{base}...{head}","merges_url":"https://api.github.com/repos/stavamichal/perun/merges","archive_url":"https://api.github.com/repos/stavamichal/perun/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/stavamichal/perun/downloads","issues_url":"https://api.github.com/repos/stavamichal/perun/issues{/number}","pulls_url":"https://api.github.com/repos/stavamichal/perun/pulls{/number}","milestones_url":"https://api.github.com/repos/stavamichal/perun/milestones{/number}","notifications_url":"https://api.github.com/repos/stavamichal/perun/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/stavamichal/perun/labels{/name}","releases_url":"https://api.github.com/repos/stavamichal/perun/releases{/id}","deployments_url":"https://api.github.com/repos/stavamichal/perun/deployments","created_at":"2013-10-25T09:05:49Z","updated_at":"2015-04-27T10:27:24Z","pushed_at":"2016-01-27T09:18:57Z","git_url":"git://github.com/stavamichal/perun.git","ssh_url":"git@github.com:stavamichal/perun.git","clone_url":"https://github.com/stavamichal/perun.git","svn_url":"https://github.com/stavamichal/perun","homepage":null,"size":25819,"stargazers_count":0,"watchers_count":0,"language":"Java","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"CESNET:master","ref":"master","sha":"455845d76766719837d65e59bd8cf997d5375b28","user":{"login":"CESNET","id":1116469,"avatar_url":"https://avatars.githubusercontent.com/u/1116469?v=3","gravatar_id":"","url":"https://api.github.com/users/CESNET","html_url":"https://github.com/CESNET","followers_url":"https://api.github.com/users/CESNET/followers","following_url":"https://api.github.com/users/CESNET/following{/other_user}","gists_url":"https://api.github.com/users/CESNET/gists{/gist_id}","starred_url":"https://api.github.com/users/CESNET/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CESNET/subscriptions","organizations_url":"https://api.github.com/users/CESNET/orgs","repos_url":"https://api.github.com/users/CESNET/repos","events_url":"https://api.github.com/users/CESNET/events{/privacy}","received_events_url":"https://api.github.com/users/CESNET/received_events","type":"Organization","site_admin":false},"repo":{"id":4085998,"name":"perun","full_name":"CESNET/perun","owner":{"login":"CESNET","id":1116469,"avatar_url":"https://avatars.githubusercontent.com/u/1116469?v=3","gravatar_id":"","url":"https://api.github.com/users/CESNET","html_url":"https://github.com/CESNET","followers_url":"https://api.github.com/users/CESNET/followers","following_url":"https://api.github.com/users/CESNET/following{/other_user}","gists_url":"https://api.github.com/users/CESNET/gists{/gist_id}","starred_url":"https://api.github.com/users/CESNET/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CESNET/subscriptions","organizations_url":"https://api.github.com/users/CESNET/orgs","repos_url":"https://api.github.com/users/CESNET/repos","events_url":"https://api.github.com/users/CESNET/events{/privacy}","received_events_url":"https://api.github.com/users/CESNET/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/CESNET/perun","description":"Identity and Access Management System","fork":false,"url":"https://api.github.com/repos/CESNET/perun","forks_url":"https://api.github.com/repos/CESNET/perun/forks","keys_url":"https://api.github.com/repos/CESNET/perun/keys{/key_id}","collaborators_url":"https://api.github.com/repos/CESNET/perun/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/CESNET/perun/teams","hooks_url":"https://api.github.com/repos/CESNET/perun/hooks","issue_events_url":"https://api.github.com/repos/CESNET/perun/issues/events{/number}","events_url":"https://api.github.com/repos/CESNET/perun/events","assignees_url":"https://api.github.com/repos/CESNET/perun/assignees{/user}","branches_url":"https://api.github.com/repos/CESNET/perun/branches{/branch}","tags_url":"https://api.github.com/repos/CESNET/perun/tags","blobs_url":"https://api.github.com/repos/CESNET/perun/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/CESNET/perun/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/CESNET/perun/git/refs{/sha}","trees_url":"https://api.github.com/repos/CESNET/perun/git/trees{/sha}","statuses_url":"https://api.github.com/repos/CESNET/perun/statuses/{sha}","languages_url":"https://api.github.com/repos/CESNET/perun/languages","stargazers_url":"https://api.github.com/repos/CESNET/perun/stargazers","contributors_url":"https://api.github.com/repos/CESNET/perun/contributors","subscribers_url":"https://api.github.com/repos/CESNET/perun/subscribers","subscription_url":"https://api.github.com/repos/CESNET/perun/subscription","commits_url":"https://api.github.com/repos/CESNET/perun/commits{/sha}","git_commits_url":"https://api.github.com/repos/CESNET/perun/git/commits{/sha}","comments_url":"https://api.github.com/repos/CESNET/perun/comments{/number}","issue_comment_url":"https://api.github.com/repos/CESNET/perun/issues/comments{/number}","contents_url":"https://api.github.com/repos/CESNET/perun/contents/{+path}","compare_url":"https://api.github.com/repos/CESNET/perun/compare/{base}...{head}","merges_url":"https://api.github.com/repos/CESNET/perun/merges","archive_url":"https://api.github.com/repos/CESNET/perun/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/CESNET/perun/downloads","issues_url":"https://api.github.com/repos/CESNET/perun/issues{/number}","pulls_url":"https://api.github.com/repos/CESNET/perun/pulls{/number}","milestones_url":"https://api.github.com/repos/CESNET/perun/milestones{/number}","notifications_url":"https://api.github.com/repos/CESNET/perun/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/CESNET/perun/labels{/name}","releases_url":"https://api.github.com/repos/CESNET/perun/releases{/id}","deployments_url":"https://api.github.com/repos/CESNET/perun/deployments","created_at":"2012-04-20T11:55:38Z","updated_at":"2016-01-18T11:31:25Z","pushed_at":"2016-02-01T05:48:56Z","git_url":"git://github.com/CESNET/perun.git","ssh_url":"git@github.com:CESNET/perun.git","clone_url":"https://github.com/CESNET/perun.git","svn_url":"https://github.com/CESNET/perun","homepage":"http://perun.cesnet.cz","size":27173,"stargazers_count":13,"watchers_count":13,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":24,"mirror_url":null,"open_issues_count":8,"forks":24,"open_issues":8,"watchers":13,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/CESNET/perun/pulls/1084"},"html":{"href":"https://github.com/CESNET/perun/pull/1084"},"issue":{"href":"https://api.github.com/repos/CESNET/perun/issues/1084"},"comments":{"href":"https://api.github.com/repos/CESNET/perun/issues/1084/comments"},"review_comments":{"href":"https://api.github.com/repos/CESNET/perun/pulls/1084/comments"},"review_comment":{"href":"https://api.github.com/repos/CESNET/perun/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/CESNET/perun/pulls/1084/commits"},"statuses":{"href":"https://api.github.com/repos/CESNET/perun/statuses/711891f674888207546a613ca7d22193d149efa2"}}}}