{"action":"opened","number":3,"pull_request":{"url":"https://api.github.com/repos/dbalakov/zatanna/pulls/3","id":37637033,"html_url":"https://github.com/dbalakov/zatanna/pull/3","diff_url":"https://github.com/dbalakov/zatanna/pull/3.diff","patch_url":"https://github.com/dbalakov/zatanna/pull/3.patch","issue_url":"https://api.github.com/repos/dbalakov/zatanna/issues/3","number":3,"state":"open","locked":false,"title":"Filter out conditions with undefined values","user":{"login":"nDmitry","id":2134568,"avatar_url":"https://avatars.githubusercontent.com/u/2134568?v=3","gravatar_id":"","url":"https://api.github.com/users/nDmitry","html_url":"https://github.com/nDmitry","followers_url":"https://api.github.com/users/nDmitry/followers","following_url":"https://api.github.com/users/nDmitry/following{/other_user}","gists_url":"https://api.github.com/users/nDmitry/gists{/gist_id}","starred_url":"https://api.github.com/users/nDmitry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nDmitry/subscriptions","organizations_url":"https://api.github.com/users/nDmitry/orgs","repos_url":"https://api.github.com/users/nDmitry/repos","events_url":"https://api.github.com/users/nDmitry/events{/privacy}","received_events_url":"https://api.github.com/users/nDmitry/received_events","type":"User","site_admin":false},"body":"Filter out conditions with undefined values before pushing them into params array.\r\n\r\nThis PR adds a check for condition's value in addition to the check for resulting condition's SQL and makes it possible to skip conditions with undefined values for columns from a model (i.e. existing in a table). Also we will be able to skip such conditions without the need to manually return undefined or null from custom conditions functions.\r\n\r\n`null` is a ‘legal’ value though so we don't skip conditions with it.","created_at":"2015-06-14T06:29:36Z","updated_at":"2015-06-14T06:29:36Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/dbalakov/zatanna/pulls/3/commits","review_comments_url":"https://api.github.com/repos/dbalakov/zatanna/pulls/3/comments","review_comment_url":"https://api.github.com/repos/dbalakov/zatanna/pulls/comments{/number}","comments_url":"https://api.github.com/repos/dbalakov/zatanna/issues/3/comments","statuses_url":"https://api.github.com/repos/dbalakov/zatanna/statuses/7b754dbca9afce2d537056781c24530754b2ab95","head":{"label":"nDmitry:develop","ref":"develop","sha":"7b754dbca9afce2d537056781c24530754b2ab95","user":{"login":"nDmitry","id":2134568,"avatar_url":"https://avatars.githubusercontent.com/u/2134568?v=3","gravatar_id":"","url":"https://api.github.com/users/nDmitry","html_url":"https://github.com/nDmitry","followers_url":"https://api.github.com/users/nDmitry/followers","following_url":"https://api.github.com/users/nDmitry/following{/other_user}","gists_url":"https://api.github.com/users/nDmitry/gists{/gist_id}","starred_url":"https://api.github.com/users/nDmitry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nDmitry/subscriptions","organizations_url":"https://api.github.com/users/nDmitry/orgs","repos_url":"https://api.github.com/users/nDmitry/repos","events_url":"https://api.github.com/users/nDmitry/events{/privacy}","received_events_url":"https://api.github.com/users/nDmitry/received_events","type":"User","site_admin":false},"repo":{"id":37401198,"name":"zatanna","full_name":"nDmitry/zatanna","owner":{"login":"nDmitry","id":2134568,"avatar_url":"https://avatars.githubusercontent.com/u/2134568?v=3","gravatar_id":"","url":"https://api.github.com/users/nDmitry","html_url":"https://github.com/nDmitry","followers_url":"https://api.github.com/users/nDmitry/followers","following_url":"https://api.github.com/users/nDmitry/following{/other_user}","gists_url":"https://api.github.com/users/nDmitry/gists{/gist_id}","starred_url":"https://api.github.com/users/nDmitry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nDmitry/subscriptions","organizations_url":"https://api.github.com/users/nDmitry/orgs","repos_url":"https://api.github.com/users/nDmitry/repos","events_url":"https://api.github.com/users/nDmitry/events{/privacy}","received_events_url":"https://api.github.com/users/nDmitry/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/nDmitry/zatanna","description":"Nodejs postgresql DAO","fork":true,"url":"https://api.github.com/repos/nDmitry/zatanna","forks_url":"https://api.github.com/repos/nDmitry/zatanna/forks","keys_url":"https://api.github.com/repos/nDmitry/zatanna/keys{/key_id}","collaborators_url":"https://api.github.com/repos/nDmitry/zatanna/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/nDmitry/zatanna/teams","hooks_url":"https://api.github.com/repos/nDmitry/zatanna/hooks","issue_events_url":"https://api.github.com/repos/nDmitry/zatanna/issues/events{/number}","events_url":"https://api.github.com/repos/nDmitry/zatanna/events","assignees_url":"https://api.github.com/repos/nDmitry/zatanna/assignees{/user}","branches_url":"https://api.github.com/repos/nDmitry/zatanna/branches{/branch}","tags_url":"https://api.github.com/repos/nDmitry/zatanna/tags","blobs_url":"https://api.github.com/repos/nDmitry/zatanna/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/nDmitry/zatanna/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/nDmitry/zatanna/git/refs{/sha}","trees_url":"https://api.github.com/repos/nDmitry/zatanna/git/trees{/sha}","statuses_url":"https://api.github.com/repos/nDmitry/zatanna/statuses/{sha}","languages_url":"https://api.github.com/repos/nDmitry/zatanna/languages","stargazers_url":"https://api.github.com/repos/nDmitry/zatanna/stargazers","contributors_url":"https://api.github.com/repos/nDmitry/zatanna/contributors","subscribers_url":"https://api.github.com/repos/nDmitry/zatanna/subscribers","subscription_url":"https://api.github.com/repos/nDmitry/zatanna/subscription","commits_url":"https://api.github.com/repos/nDmitry/zatanna/commits{/sha}","git_commits_url":"https://api.github.com/repos/nDmitry/zatanna/git/commits{/sha}","comments_url":"https://api.github.com/repos/nDmitry/zatanna/comments{/number}","issue_comment_url":"https://api.github.com/repos/nDmitry/zatanna/issues/comments{/number}","contents_url":"https://api.github.com/repos/nDmitry/zatanna/contents/{+path}","compare_url":"https://api.github.com/repos/nDmitry/zatanna/compare/{base}...{head}","merges_url":"https://api.github.com/repos/nDmitry/zatanna/merges","archive_url":"https://api.github.com/repos/nDmitry/zatanna/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/nDmitry/zatanna/downloads","issues_url":"https://api.github.com/repos/nDmitry/zatanna/issues{/number}","pulls_url":"https://api.github.com/repos/nDmitry/zatanna/pulls{/number}","milestones_url":"https://api.github.com/repos/nDmitry/zatanna/milestones{/number}","notifications_url":"https://api.github.com/repos/nDmitry/zatanna/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/nDmitry/zatanna/labels{/name}","releases_url":"https://api.github.com/repos/nDmitry/zatanna/releases{/id}","created_at":"2015-06-14T06:00:22Z","updated_at":"2015-06-14T06:00:23Z","pushed_at":"2015-06-14T06:22:54Z","git_url":"git://github.com/nDmitry/zatanna.git","ssh_url":"git@github.com:nDmitry/zatanna.git","clone_url":"https://github.com/nDmitry/zatanna.git","svn_url":"https://github.com/nDmitry/zatanna","homepage":null,"size":108,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","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":"dbalakov:develop","ref":"develop","sha":"4149222191bab99c9c3cabfb855aa0fdc5fa7e8e","user":{"login":"dbalakov","id":1236172,"avatar_url":"https://avatars.githubusercontent.com/u/1236172?v=3","gravatar_id":"","url":"https://api.github.com/users/dbalakov","html_url":"https://github.com/dbalakov","followers_url":"https://api.github.com/users/dbalakov/followers","following_url":"https://api.github.com/users/dbalakov/following{/other_user}","gists_url":"https://api.github.com/users/dbalakov/gists{/gist_id}","starred_url":"https://api.github.com/users/dbalakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dbalakov/subscriptions","organizations_url":"https://api.github.com/users/dbalakov/orgs","repos_url":"https://api.github.com/users/dbalakov/repos","events_url":"https://api.github.com/users/dbalakov/events{/privacy}","received_events_url":"https://api.github.com/users/dbalakov/received_events","type":"User","site_admin":false},"repo":{"id":29353491,"name":"zatanna","full_name":"dbalakov/zatanna","owner":{"login":"dbalakov","id":1236172,"avatar_url":"https://avatars.githubusercontent.com/u/1236172?v=3","gravatar_id":"","url":"https://api.github.com/users/dbalakov","html_url":"https://github.com/dbalakov","followers_url":"https://api.github.com/users/dbalakov/followers","following_url":"https://api.github.com/users/dbalakov/following{/other_user}","gists_url":"https://api.github.com/users/dbalakov/gists{/gist_id}","starred_url":"https://api.github.com/users/dbalakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dbalakov/subscriptions","organizations_url":"https://api.github.com/users/dbalakov/orgs","repos_url":"https://api.github.com/users/dbalakov/repos","events_url":"https://api.github.com/users/dbalakov/events{/privacy}","received_events_url":"https://api.github.com/users/dbalakov/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/dbalakov/zatanna","description":"Nodejs postgresql DAO","fork":false,"url":"https://api.github.com/repos/dbalakov/zatanna","forks_url":"https://api.github.com/repos/dbalakov/zatanna/forks","keys_url":"https://api.github.com/repos/dbalakov/zatanna/keys{/key_id}","collaborators_url":"https://api.github.com/repos/dbalakov/zatanna/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/dbalakov/zatanna/teams","hooks_url":"https://api.github.com/repos/dbalakov/zatanna/hooks","issue_events_url":"https://api.github.com/repos/dbalakov/zatanna/issues/events{/number}","events_url":"https://api.github.com/repos/dbalakov/zatanna/events","assignees_url":"https://api.github.com/repos/dbalakov/zatanna/assignees{/user}","branches_url":"https://api.github.com/repos/dbalakov/zatanna/branches{/branch}","tags_url":"https://api.github.com/repos/dbalakov/zatanna/tags","blobs_url":"https://api.github.com/repos/dbalakov/zatanna/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/dbalakov/zatanna/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/dbalakov/zatanna/git/refs{/sha}","trees_url":"https://api.github.com/repos/dbalakov/zatanna/git/trees{/sha}","statuses_url":"https://api.github.com/repos/dbalakov/zatanna/statuses/{sha}","languages_url":"https://api.github.com/repos/dbalakov/zatanna/languages","stargazers_url":"https://api.github.com/repos/dbalakov/zatanna/stargazers","contributors_url":"https://api.github.com/repos/dbalakov/zatanna/contributors","subscribers_url":"https://api.github.com/repos/dbalakov/zatanna/subscribers","subscription_url":"https://api.github.com/repos/dbalakov/zatanna/subscription","commits_url":"https://api.github.com/repos/dbalakov/zatanna/commits{/sha}","git_commits_url":"https://api.github.com/repos/dbalakov/zatanna/git/commits{/sha}","comments_url":"https://api.github.com/repos/dbalakov/zatanna/comments{/number}","issue_comment_url":"https://api.github.com/repos/dbalakov/zatanna/issues/comments{/number}","contents_url":"https://api.github.com/repos/dbalakov/zatanna/contents/{+path}","compare_url":"https://api.github.com/repos/dbalakov/zatanna/compare/{base}...{head}","merges_url":"https://api.github.com/repos/dbalakov/zatanna/merges","archive_url":"https://api.github.com/repos/dbalakov/zatanna/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/dbalakov/zatanna/downloads","issues_url":"https://api.github.com/repos/dbalakov/zatanna/issues{/number}","pulls_url":"https://api.github.com/repos/dbalakov/zatanna/pulls{/number}","milestones_url":"https://api.github.com/repos/dbalakov/zatanna/milestones{/number}","notifications_url":"https://api.github.com/repos/dbalakov/zatanna/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/dbalakov/zatanna/labels{/name}","releases_url":"https://api.github.com/repos/dbalakov/zatanna/releases{/id}","created_at":"2015-01-16T15:13:25Z","updated_at":"2015-05-08T08:14:45Z","pushed_at":"2015-06-14T06:29:36Z","git_url":"git://github.com/dbalakov/zatanna.git","ssh_url":"git@github.com:dbalakov/zatanna.git","clone_url":"https://github.com/dbalakov/zatanna.git","svn_url":"https://github.com/dbalakov/zatanna","homepage":null,"size":177,"stargazers_count":2,"watchers_count":2,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":2,"mirror_url":null,"open_issues_count":1,"forks":2,"open_issues":1,"watchers":2,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/dbalakov/zatanna/pulls/3"},"html":{"href":"https://github.com/dbalakov/zatanna/pull/3"},"issue":{"href":"https://api.github.com/repos/dbalakov/zatanna/issues/3"},"comments":{"href":"https://api.github.com/repos/dbalakov/zatanna/issues/3/comments"},"review_comments":{"href":"https://api.github.com/repos/dbalakov/zatanna/pulls/3/comments"},"review_comment":{"href":"https://api.github.com/repos/dbalakov/zatanna/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/dbalakov/zatanna/pulls/3/commits"},"statuses":{"href":"https://api.github.com/repos/dbalakov/zatanna/statuses/7b754dbca9afce2d537056781c24530754b2ab95"}},"merged":false,"mergeable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"commits":1,"additions":11,"deletions":1,"changed_files":2}}