{"action":"closed","number":33,"pull_request":{"url":"https://api.github.com/repos/cyverse-de/de-db/pulls/33","id":202424185,"node_id":"MDExOlB1bGxSZXF1ZXN0MjAyNDI0MTg1","html_url":"https://github.com/cyverse-de/de-db/pull/33","diff_url":"https://github.com/cyverse-de/de-db/pull/33.diff","patch_url":"https://github.com/cyverse-de/de-db/pull/33.patch","issue_url":"https://api.github.com/repos/cyverse-de/de-db/issues/33","number":33,"state":"closed","locked":false,"title":"CORE-4632: add tables to store validation rule argument type definitions.","user":{"login":"slr71","id":415143,"node_id":"MDQ6VXNlcjQxNTE0Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/415143?v=4","gravatar_id":"","url":"https://api.github.com/users/slr71","html_url":"https://github.com/slr71","followers_url":"https://api.github.com/users/slr71/followers","following_url":"https://api.github.com/users/slr71/following{/other_user}","gists_url":"https://api.github.com/users/slr71/gists{/gist_id}","starred_url":"https://api.github.com/users/slr71/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slr71/subscriptions","organizations_url":"https://api.github.com/users/slr71/orgs","repos_url":"https://api.github.com/users/slr71/repos","events_url":"https://api.github.com/users/slr71/events{/privacy}","received_events_url":"https://api.github.com/users/slr71/received_events","type":"User","site_admin":false},"body":"After either initializing or updating the database, the argument definitions should look like this:\r\n\r\n```\r\nde=> select rt.name, vrad.argument_index, vrad.name, vrad.description, vrat.name from rule_type rt join validation_rule_argument_definitions vrad on rt.id = vrad.rule_type_id join validation_rule_argument_types vrat on vrad.argument_type_id = vrat.id;\r\n      name      | argument_index |    name    |                description                |  name\r\n----------------+----------------+------------+-------------------------------------------+---------\r\n IntBelowField  |              0 | FieldRef   | The other field to compare to this field. | String\r\n IntAbove       |              0 | LowerLimit | The lower limit of this field.            | Integer\r\n IntRange       |              0 | LowerLimit | The lower limit of this field.            | Integer\r\n IntRange       |              1 | UpperLimit | The upper limit of this field.            | Integer\r\n IntAboveField  |              0 | FieldRef   | The other field to compare to this field. | String\r\n MustContain    |              0 | List       | The list of valid values for this field.  | String\r\n DoubleRange    |              0 | LowerLimit | The lower limit of this field.            | Double\r\n DoubleRange    |              1 | UpperLimit | The upper limit of this field.            | Double\r\n IntBelow       |              0 | UpperLimit | The upper limit of this field.            | Integer\r\n DoubleAbove    |              0 | LowerLimit | The lower limit of this field.            | Double\r\n DoubleBelow    |              0 | UpperLimit | The upper limit of this field.            | Double\r\n Regex          |              0 | Regex      | The regular expression.                   | String\r\n CharacterLimit |              0 | MaxLength  | The maximum length of the field.          | Integer\r\n(13 rows)\r\n```\r\n","created_at":"2018-07-19T01:47:33Z","updated_at":"2018-07-19T20:40:08Z","closed_at":"2018-07-19T20:40:08Z","merged_at":"2018-07-19T20:40:08Z","merge_commit_sha":"cd688c6cb1c0066b0c12b3b49f2fc83eda81fe3a","assignee":null,"assignees":[],"requested_reviewers":[{"login":"johnworth","id":49783,"node_id":"MDQ6VXNlcjQ5Nzgz","avatar_url":"https://avatars2.githubusercontent.com/u/49783?v=4","gravatar_id":"","url":"https://api.github.com/users/johnworth","html_url":"https://github.com/johnworth","followers_url":"https://api.github.com/users/johnworth/followers","following_url":"https://api.github.com/users/johnworth/following{/other_user}","gists_url":"https://api.github.com/users/johnworth/gists{/gist_id}","starred_url":"https://api.github.com/users/johnworth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johnworth/subscriptions","organizations_url":"https://api.github.com/users/johnworth/orgs","repos_url":"https://api.github.com/users/johnworth/repos","events_url":"https://api.github.com/users/johnworth/events{/privacy}","received_events_url":"https://api.github.com/users/johnworth/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/cyverse-de/de-db/pulls/33/commits","review_comments_url":"https://api.github.com/repos/cyverse-de/de-db/pulls/33/comments","review_comment_url":"https://api.github.com/repos/cyverse-de/de-db/pulls/comments{/number}","comments_url":"https://api.github.com/repos/cyverse-de/de-db/issues/33/comments","statuses_url":"https://api.github.com/repos/cyverse-de/de-db/statuses/7d6e7a937182674aad94cb68d8e92024f156120e","head":{"label":"slr71:master","ref":"master","sha":"7d6e7a937182674aad94cb68d8e92024f156120e","user":{"login":"slr71","id":415143,"node_id":"MDQ6VXNlcjQxNTE0Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/415143?v=4","gravatar_id":"","url":"https://api.github.com/users/slr71","html_url":"https://github.com/slr71","followers_url":"https://api.github.com/users/slr71/followers","following_url":"https://api.github.com/users/slr71/following{/other_user}","gists_url":"https://api.github.com/users/slr71/gists{/gist_id}","starred_url":"https://api.github.com/users/slr71/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slr71/subscriptions","organizations_url":"https://api.github.com/users/slr71/orgs","repos_url":"https://api.github.com/users/slr71/repos","events_url":"https://api.github.com/users/slr71/events{/privacy}","received_events_url":"https://api.github.com/users/slr71/received_events","type":"User","site_admin":false},"repo":{"id":69298096,"node_id":"MDEwOlJlcG9zaXRvcnk2OTI5ODA5Ng==","name":"de-db","full_name":"slr71/de-db","owner":{"login":"slr71","id":415143,"node_id":"MDQ6VXNlcjQxNTE0Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/415143?v=4","gravatar_id":"","url":"https://api.github.com/users/slr71","html_url":"https://github.com/slr71","followers_url":"https://api.github.com/users/slr71/followers","following_url":"https://api.github.com/users/slr71/following{/other_user}","gists_url":"https://api.github.com/users/slr71/gists{/gist_id}","starred_url":"https://api.github.com/users/slr71/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slr71/subscriptions","organizations_url":"https://api.github.com/users/slr71/orgs","repos_url":"https://api.github.com/users/slr71/repos","events_url":"https://api.github.com/users/slr71/events{/privacy}","received_events_url":"https://api.github.com/users/slr71/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/slr71/de-db","description":null,"fork":true,"url":"https://api.github.com/repos/slr71/de-db","forks_url":"https://api.github.com/repos/slr71/de-db/forks","keys_url":"https://api.github.com/repos/slr71/de-db/keys{/key_id}","collaborators_url":"https://api.github.com/repos/slr71/de-db/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/slr71/de-db/teams","hooks_url":"https://api.github.com/repos/slr71/de-db/hooks","issue_events_url":"https://api.github.com/repos/slr71/de-db/issues/events{/number}","events_url":"https://api.github.com/repos/slr71/de-db/events","assignees_url":"https://api.github.com/repos/slr71/de-db/assignees{/user}","branches_url":"https://api.github.com/repos/slr71/de-db/branches{/branch}","tags_url":"https://api.github.com/repos/slr71/de-db/tags","blobs_url":"https://api.github.com/repos/slr71/de-db/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/slr71/de-db/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/slr71/de-db/git/refs{/sha}","trees_url":"https://api.github.com/repos/slr71/de-db/git/trees{/sha}","statuses_url":"https://api.github.com/repos/slr71/de-db/statuses/{sha}","languages_url":"https://api.github.com/repos/slr71/de-db/languages","stargazers_url":"https://api.github.com/repos/slr71/de-db/stargazers","contributors_url":"https://api.github.com/repos/slr71/de-db/contributors","subscribers_url":"https://api.github.com/repos/slr71/de-db/subscribers","subscription_url":"https://api.github.com/repos/slr71/de-db/subscription","commits_url":"https://api.github.com/repos/slr71/de-db/commits{/sha}","git_commits_url":"https://api.github.com/repos/slr71/de-db/git/commits{/sha}","comments_url":"https://api.github.com/repos/slr71/de-db/comments{/number}","issue_comment_url":"https://api.github.com/repos/slr71/de-db/issues/comments{/number}","contents_url":"https://api.github.com/repos/slr71/de-db/contents/{+path}","compare_url":"https://api.github.com/repos/slr71/de-db/compare/{base}...{head}","merges_url":"https://api.github.com/repos/slr71/de-db/merges","archive_url":"https://api.github.com/repos/slr71/de-db/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/slr71/de-db/downloads","issues_url":"https://api.github.com/repos/slr71/de-db/issues{/number}","pulls_url":"https://api.github.com/repos/slr71/de-db/pulls{/number}","milestones_url":"https://api.github.com/repos/slr71/de-db/milestones{/number}","notifications_url":"https://api.github.com/repos/slr71/de-db/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/slr71/de-db/labels{/name}","releases_url":"https://api.github.com/repos/slr71/de-db/releases{/id}","deployments_url":"https://api.github.com/repos/slr71/de-db/deployments","created_at":"2016-09-26T22:28:59Z","updated_at":"2018-07-19T01:43:14Z","pushed_at":"2018-07-19T01:43:12Z","git_url":"git://github.com/slr71/de-db.git","ssh_url":"git@github.com:slr71/de-db.git","clone_url":"https://github.com/slr71/de-db.git","svn_url":"https://github.com/slr71/de-db","homepage":null,"size":537,"stargazers_count":0,"watchers_count":0,"language":"Clojure","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"cyverse-de:master","ref":"master","sha":"49b7e981d52a81b83fb63f3326bf07e92d44fbdd","user":{"login":"cyverse-de","id":20466326,"node_id":"MDEyOk9yZ2FuaXphdGlvbjIwNDY2MzI2","avatar_url":"https://avatars2.githubusercontent.com/u/20466326?v=4","gravatar_id":"","url":"https://api.github.com/users/cyverse-de","html_url":"https://github.com/cyverse-de","followers_url":"https://api.github.com/users/cyverse-de/followers","following_url":"https://api.github.com/users/cyverse-de/following{/other_user}","gists_url":"https://api.github.com/users/cyverse-de/gists{/gist_id}","starred_url":"https://api.github.com/users/cyverse-de/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cyverse-de/subscriptions","organizations_url":"https://api.github.com/users/cyverse-de/orgs","repos_url":"https://api.github.com/users/cyverse-de/repos","events_url":"https://api.github.com/users/cyverse-de/events{/privacy}","received_events_url":"https://api.github.com/users/cyverse-de/received_events","type":"Organization","site_admin":false},"repo":{"id":67054035,"node_id":"MDEwOlJlcG9zaXRvcnk2NzA1NDAzNQ==","name":"de-db","full_name":"cyverse-de/de-db","owner":{"login":"cyverse-de","id":20466326,"node_id":"MDEyOk9yZ2FuaXphdGlvbjIwNDY2MzI2","avatar_url":"https://avatars2.githubusercontent.com/u/20466326?v=4","gravatar_id":"","url":"https://api.github.com/users/cyverse-de","html_url":"https://github.com/cyverse-de","followers_url":"https://api.github.com/users/cyverse-de/followers","following_url":"https://api.github.com/users/cyverse-de/following{/other_user}","gists_url":"https://api.github.com/users/cyverse-de/gists{/gist_id}","starred_url":"https://api.github.com/users/cyverse-de/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cyverse-de/subscriptions","organizations_url":"https://api.github.com/users/cyverse-de/orgs","repos_url":"https://api.github.com/users/cyverse-de/repos","events_url":"https://api.github.com/users/cyverse-de/events{/privacy}","received_events_url":"https://api.github.com/users/cyverse-de/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/cyverse-de/de-db","description":null,"fork":false,"url":"https://api.github.com/repos/cyverse-de/de-db","forks_url":"https://api.github.com/repos/cyverse-de/de-db/forks","keys_url":"https://api.github.com/repos/cyverse-de/de-db/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cyverse-de/de-db/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cyverse-de/de-db/teams","hooks_url":"https://api.github.com/repos/cyverse-de/de-db/hooks","issue_events_url":"https://api.github.com/repos/cyverse-de/de-db/issues/events{/number}","events_url":"https://api.github.com/repos/cyverse-de/de-db/events","assignees_url":"https://api.github.com/repos/cyverse-de/de-db/assignees{/user}","branches_url":"https://api.github.com/repos/cyverse-de/de-db/branches{/branch}","tags_url":"https://api.github.com/repos/cyverse-de/de-db/tags","blobs_url":"https://api.github.com/repos/cyverse-de/de-db/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cyverse-de/de-db/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cyverse-de/de-db/git/refs{/sha}","trees_url":"https://api.github.com/repos/cyverse-de/de-db/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cyverse-de/de-db/statuses/{sha}","languages_url":"https://api.github.com/repos/cyverse-de/de-db/languages","stargazers_url":"https://api.github.com/repos/cyverse-de/de-db/stargazers","contributors_url":"https://api.github.com/repos/cyverse-de/de-db/contributors","subscribers_url":"https://api.github.com/repos/cyverse-de/de-db/subscribers","subscription_url":"https://api.github.com/repos/cyverse-de/de-db/subscription","commits_url":"https://api.github.com/repos/cyverse-de/de-db/commits{/sha}","git_commits_url":"https://api.github.com/repos/cyverse-de/de-db/git/commits{/sha}","comments_url":"https://api.github.com/repos/cyverse-de/de-db/comments{/number}","issue_comment_url":"https://api.github.com/repos/cyverse-de/de-db/issues/comments{/number}","contents_url":"https://api.github.com/repos/cyverse-de/de-db/contents/{+path}","compare_url":"https://api.github.com/repos/cyverse-de/de-db/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cyverse-de/de-db/merges","archive_url":"https://api.github.com/repos/cyverse-de/de-db/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cyverse-de/de-db/downloads","issues_url":"https://api.github.com/repos/cyverse-de/de-db/issues{/number}","pulls_url":"https://api.github.com/repos/cyverse-de/de-db/pulls{/number}","milestones_url":"https://api.github.com/repos/cyverse-de/de-db/milestones{/number}","notifications_url":"https://api.github.com/repos/cyverse-de/de-db/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cyverse-de/de-db/labels{/name}","releases_url":"https://api.github.com/repos/cyverse-de/de-db/releases{/id}","deployments_url":"https://api.github.com/repos/cyverse-de/de-db/deployments","created_at":"2016-08-31T16:17:56Z","updated_at":"2018-06-19T23:35:55Z","pushed_at":"2018-07-19T20:40:08Z","git_url":"git://github.com/cyverse-de/de-db.git","ssh_url":"git@github.com:cyverse-de/de-db.git","clone_url":"https://github.com/cyverse-de/de-db.git","svn_url":"https://github.com/cyverse-de/de-db","homepage":null,"size":528,"stargazers_count":0,"watchers_count":0,"language":"Clojure","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":5,"mirror_url":null,"archived":false,"open_issues_count":1,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":5,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/cyverse-de/de-db/pulls/33"},"html":{"href":"https://github.com/cyverse-de/de-db/pull/33"},"issue":{"href":"https://api.github.com/repos/cyverse-de/de-db/issues/33"},"comments":{"href":"https://api.github.com/repos/cyverse-de/de-db/issues/33/comments"},"review_comments":{"href":"https://api.github.com/repos/cyverse-de/de-db/pulls/33/comments"},"review_comment":{"href":"https://api.github.com/repos/cyverse-de/de-db/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/cyverse-de/de-db/pulls/33/commits"},"statuses":{"href":"https://api.github.com/repos/cyverse-de/de-db/statuses/7d6e7a937182674aad94cb68d8e92024f156120e"}},"author_association":"CONTRIBUTOR","merged":true,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":{"login":"slr71","id":415143,"node_id":"MDQ6VXNlcjQxNTE0Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/415143?v=4","gravatar_id":"","url":"https://api.github.com/users/slr71","html_url":"https://github.com/slr71","followers_url":"https://api.github.com/users/slr71/followers","following_url":"https://api.github.com/users/slr71/following{/other_user}","gists_url":"https://api.github.com/users/slr71/gists{/gist_id}","starred_url":"https://api.github.com/users/slr71/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slr71/subscriptions","organizations_url":"https://api.github.com/users/slr71/orgs","repos_url":"https://api.github.com/users/slr71/repos","events_url":"https://api.github.com/users/slr71/events{/privacy}","received_events_url":"https://api.github.com/users/slr71/received_events","type":"User","site_admin":false},"comments":1,"review_comments":0,"maintainer_can_modify":false,"commits":4,"additions":105,"deletions":0,"changed_files":9}}
{"actor":{"display_login":"slr71"}}