{"action":"closed","number":145,"pull_request":{"url":"https://api.github.com/repos/zzzeek/sqlalchemy/pulls/145","id":23290762,"html_url":"https://github.com/zzzeek/sqlalchemy/pull/145","diff_url":"https://github.com/zzzeek/sqlalchemy/pull/145.diff","patch_url":"https://github.com/zzzeek/sqlalchemy/pull/145.patch","issue_url":"https://api.github.com/repos/zzzeek/sqlalchemy/issues/145","number":145,"state":"closed","locked":false,"title":"Psycopg2 JSONB support.","user":{"login":"MSusik","id":6649290,"avatar_url":"https://avatars.githubusercontent.com/u/6649290?v=3","gravatar_id":"","url":"https://api.github.com/users/MSusik","html_url":"https://github.com/MSusik","followers_url":"https://api.github.com/users/MSusik/followers","following_url":"https://api.github.com/users/MSusik/following{/other_user}","gists_url":"https://api.github.com/users/MSusik/gists{/gist_id}","starred_url":"https://api.github.com/users/MSusik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MSusik/subscriptions","organizations_url":"https://api.github.com/users/MSusik/orgs","repos_url":"https://api.github.com/users/MSusik/repos","events_url":"https://api.github.com/users/MSusik/events{/privacy}","received_events_url":"https://api.github.com/users/MSusik/received_events","type":"User","site_admin":false},"body":"Hello!\r\n\r\nI had some problems with using JSONB field in my TypeDecorator. This fixes the issue. No tests attached.","created_at":"2014-10-24T11:34:03Z","updated_at":"2015-02-01T00:07:20Z","closed_at":"2015-02-01T00:07:20Z","merged_at":"2015-02-01T00:07:20Z","merge_commit_sha":"8ee6f453e0a24188997718c972b1582534406e4f","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/zzzeek/sqlalchemy/pulls/145/commits","review_comments_url":"https://api.github.com/repos/zzzeek/sqlalchemy/pulls/145/comments","review_comment_url":"https://api.github.com/repos/zzzeek/sqlalchemy/pulls/comments/{number}","comments_url":"https://api.github.com/repos/zzzeek/sqlalchemy/issues/145/comments","statuses_url":"https://api.github.com/repos/zzzeek/sqlalchemy/statuses/e7d61d594b8a89535696436a667a526bd2999fb2","head":{"label":"MSusik:master","ref":"master","sha":"e7d61d594b8a89535696436a667a526bd2999fb2","user":{"login":"MSusik","id":6649290,"avatar_url":"https://avatars.githubusercontent.com/u/6649290?v=3","gravatar_id":"","url":"https://api.github.com/users/MSusik","html_url":"https://github.com/MSusik","followers_url":"https://api.github.com/users/MSusik/followers","following_url":"https://api.github.com/users/MSusik/following{/other_user}","gists_url":"https://api.github.com/users/MSusik/gists{/gist_id}","starred_url":"https://api.github.com/users/MSusik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MSusik/subscriptions","organizations_url":"https://api.github.com/users/MSusik/orgs","repos_url":"https://api.github.com/users/MSusik/repos","events_url":"https://api.github.com/users/MSusik/events{/privacy}","received_events_url":"https://api.github.com/users/MSusik/received_events","type":"User","site_admin":false},"repo":{"id":25682201,"name":"sqlalchemy","full_name":"MSusik/sqlalchemy","owner":{"login":"MSusik","id":6649290,"avatar_url":"https://avatars.githubusercontent.com/u/6649290?v=3","gravatar_id":"","url":"https://api.github.com/users/MSusik","html_url":"https://github.com/MSusik","followers_url":"https://api.github.com/users/MSusik/followers","following_url":"https://api.github.com/users/MSusik/following{/other_user}","gists_url":"https://api.github.com/users/MSusik/gists{/gist_id}","starred_url":"https://api.github.com/users/MSusik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MSusik/subscriptions","organizations_url":"https://api.github.com/users/MSusik/orgs","repos_url":"https://api.github.com/users/MSusik/repos","events_url":"https://api.github.com/users/MSusik/events{/privacy}","received_events_url":"https://api.github.com/users/MSusik/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/MSusik/sqlalchemy","description":"Mirror of SQLAlchemy","fork":true,"url":"https://api.github.com/repos/MSusik/sqlalchemy","forks_url":"https://api.github.com/repos/MSusik/sqlalchemy/forks","keys_url":"https://api.github.com/repos/MSusik/sqlalchemy/keys{/key_id}","collaborators_url":"https://api.github.com/repos/MSusik/sqlalchemy/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/MSusik/sqlalchemy/teams","hooks_url":"https://api.github.com/repos/MSusik/sqlalchemy/hooks","issue_events_url":"https://api.github.com/repos/MSusik/sqlalchemy/issues/events{/number}","events_url":"https://api.github.com/repos/MSusik/sqlalchemy/events","assignees_url":"https://api.github.com/repos/MSusik/sqlalchemy/assignees{/user}","branches_url":"https://api.github.com/repos/MSusik/sqlalchemy/branches{/branch}","tags_url":"https://api.github.com/repos/MSusik/sqlalchemy/tags","blobs_url":"https://api.github.com/repos/MSusik/sqlalchemy/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/MSusik/sqlalchemy/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/MSusik/sqlalchemy/git/refs{/sha}","trees_url":"https://api.github.com/repos/MSusik/sqlalchemy/git/trees{/sha}","statuses_url":"https://api.github.com/repos/MSusik/sqlalchemy/statuses/{sha}","languages_url":"https://api.github.com/repos/MSusik/sqlalchemy/languages","stargazers_url":"https://api.github.com/repos/MSusik/sqlalchemy/stargazers","contributors_url":"https://api.github.com/repos/MSusik/sqlalchemy/contributors","subscribers_url":"https://api.github.com/repos/MSusik/sqlalchemy/subscribers","subscription_url":"https://api.github.com/repos/MSusik/sqlalchemy/subscription","commits_url":"https://api.github.com/repos/MSusik/sqlalchemy/commits{/sha}","git_commits_url":"https://api.github.com/repos/MSusik/sqlalchemy/git/commits{/sha}","comments_url":"https://api.github.com/repos/MSusik/sqlalchemy/comments{/number}","issue_comment_url":"https://api.github.com/repos/MSusik/sqlalchemy/issues/comments/{number}","contents_url":"https://api.github.com/repos/MSusik/sqlalchemy/contents/{+path}","compare_url":"https://api.github.com/repos/MSusik/sqlalchemy/compare/{base}...{head}","merges_url":"https://api.github.com/repos/MSusik/sqlalchemy/merges","archive_url":"https://api.github.com/repos/MSusik/sqlalchemy/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/MSusik/sqlalchemy/downloads","issues_url":"https://api.github.com/repos/MSusik/sqlalchemy/issues{/number}","pulls_url":"https://api.github.com/repos/MSusik/sqlalchemy/pulls{/number}","milestones_url":"https://api.github.com/repos/MSusik/sqlalchemy/milestones{/number}","notifications_url":"https://api.github.com/repos/MSusik/sqlalchemy/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/MSusik/sqlalchemy/labels{/name}","releases_url":"https://api.github.com/repos/MSusik/sqlalchemy/releases{/id}","created_at":"2014-10-24T09:55:43Z","updated_at":"2014-10-24T11:29:03Z","pushed_at":"2014-10-24T11:29:02Z","git_url":"git://github.com/MSusik/sqlalchemy.git","ssh_url":"git@github.com:MSusik/sqlalchemy.git","clone_url":"https://github.com/MSusik/sqlalchemy.git","svn_url":"https://github.com/MSusik/sqlalchemy","homepage":null,"size":34590,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":false,"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":"zzzeek:master","ref":"master","sha":"393470c7abf1b1e0c32f037e0ed1eb8e8ce82543","user":{"login":"zzzeek","id":128223,"avatar_url":"https://avatars.githubusercontent.com/u/128223?v=3","gravatar_id":"","url":"https://api.github.com/users/zzzeek","html_url":"https://github.com/zzzeek","followers_url":"https://api.github.com/users/zzzeek/followers","following_url":"https://api.github.com/users/zzzeek/following{/other_user}","gists_url":"https://api.github.com/users/zzzeek/gists{/gist_id}","starred_url":"https://api.github.com/users/zzzeek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zzzeek/subscriptions","organizations_url":"https://api.github.com/users/zzzeek/orgs","repos_url":"https://api.github.com/users/zzzeek/repos","events_url":"https://api.github.com/users/zzzeek/events{/privacy}","received_events_url":"https://api.github.com/users/zzzeek/received_events","type":"User","site_admin":false},"repo":{"id":10289171,"name":"sqlalchemy","full_name":"zzzeek/sqlalchemy","owner":{"login":"zzzeek","id":128223,"avatar_url":"https://avatars.githubusercontent.com/u/128223?v=3","gravatar_id":"","url":"https://api.github.com/users/zzzeek","html_url":"https://github.com/zzzeek","followers_url":"https://api.github.com/users/zzzeek/followers","following_url":"https://api.github.com/users/zzzeek/following{/other_user}","gists_url":"https://api.github.com/users/zzzeek/gists{/gist_id}","starred_url":"https://api.github.com/users/zzzeek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zzzeek/subscriptions","organizations_url":"https://api.github.com/users/zzzeek/orgs","repos_url":"https://api.github.com/users/zzzeek/repos","events_url":"https://api.github.com/users/zzzeek/events{/privacy}","received_events_url":"https://api.github.com/users/zzzeek/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/zzzeek/sqlalchemy","description":"Mirror of SQLAlchemy","fork":false,"url":"https://api.github.com/repos/zzzeek/sqlalchemy","forks_url":"https://api.github.com/repos/zzzeek/sqlalchemy/forks","keys_url":"https://api.github.com/repos/zzzeek/sqlalchemy/keys{/key_id}","collaborators_url":"https://api.github.com/repos/zzzeek/sqlalchemy/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/zzzeek/sqlalchemy/teams","hooks_url":"https://api.github.com/repos/zzzeek/sqlalchemy/hooks","issue_events_url":"https://api.github.com/repos/zzzeek/sqlalchemy/issues/events{/number}","events_url":"https://api.github.com/repos/zzzeek/sqlalchemy/events","assignees_url":"https://api.github.com/repos/zzzeek/sqlalchemy/assignees{/user}","branches_url":"https://api.github.com/repos/zzzeek/sqlalchemy/branches{/branch}","tags_url":"https://api.github.com/repos/zzzeek/sqlalchemy/tags","blobs_url":"https://api.github.com/repos/zzzeek/sqlalchemy/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/zzzeek/sqlalchemy/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/zzzeek/sqlalchemy/git/refs{/sha}","trees_url":"https://api.github.com/repos/zzzeek/sqlalchemy/git/trees{/sha}","statuses_url":"https://api.github.com/repos/zzzeek/sqlalchemy/statuses/{sha}","languages_url":"https://api.github.com/repos/zzzeek/sqlalchemy/languages","stargazers_url":"https://api.github.com/repos/zzzeek/sqlalchemy/stargazers","contributors_url":"https://api.github.com/repos/zzzeek/sqlalchemy/contributors","subscribers_url":"https://api.github.com/repos/zzzeek/sqlalchemy/subscribers","subscription_url":"https://api.github.com/repos/zzzeek/sqlalchemy/subscription","commits_url":"https://api.github.com/repos/zzzeek/sqlalchemy/commits{/sha}","git_commits_url":"https://api.github.com/repos/zzzeek/sqlalchemy/git/commits{/sha}","comments_url":"https://api.github.com/repos/zzzeek/sqlalchemy/comments{/number}","issue_comment_url":"https://api.github.com/repos/zzzeek/sqlalchemy/issues/comments/{number}","contents_url":"https://api.github.com/repos/zzzeek/sqlalchemy/contents/{+path}","compare_url":"https://api.github.com/repos/zzzeek/sqlalchemy/compare/{base}...{head}","merges_url":"https://api.github.com/repos/zzzeek/sqlalchemy/merges","archive_url":"https://api.github.com/repos/zzzeek/sqlalchemy/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/zzzeek/sqlalchemy/downloads","issues_url":"https://api.github.com/repos/zzzeek/sqlalchemy/issues{/number}","pulls_url":"https://api.github.com/repos/zzzeek/sqlalchemy/pulls{/number}","milestones_url":"https://api.github.com/repos/zzzeek/sqlalchemy/milestones{/number}","notifications_url":"https://api.github.com/repos/zzzeek/sqlalchemy/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/zzzeek/sqlalchemy/labels{/name}","releases_url":"https://api.github.com/repos/zzzeek/sqlalchemy/releases{/id}","created_at":"2013-05-25T20:05:42Z","updated_at":"2015-02-01T00:07:20Z","pushed_at":"2015-02-01T00:07:20Z","git_url":"git://github.com/zzzeek/sqlalchemy.git","ssh_url":"git@github.com:zzzeek/sqlalchemy.git","clone_url":"https://github.com/zzzeek/sqlalchemy.git","svn_url":"https://github.com/zzzeek/sqlalchemy","homepage":null,"size":48304,"stargazers_count":671,"watchers_count":671,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":224,"mirror_url":null,"open_issues_count":10,"forks":224,"open_issues":10,"watchers":671,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/zzzeek/sqlalchemy/pulls/145"},"html":{"href":"https://github.com/zzzeek/sqlalchemy/pull/145"},"issue":{"href":"https://api.github.com/repos/zzzeek/sqlalchemy/issues/145"},"comments":{"href":"https://api.github.com/repos/zzzeek/sqlalchemy/issues/145/comments"},"review_comments":{"href":"https://api.github.com/repos/zzzeek/sqlalchemy/pulls/145/comments"},"review_comment":{"href":"https://api.github.com/repos/zzzeek/sqlalchemy/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/zzzeek/sqlalchemy/pulls/145/commits"},"statuses":{"href":"https://api.github.com/repos/zzzeek/sqlalchemy/statuses/e7d61d594b8a89535696436a667a526bd2999fb2"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"zzzeek","id":128223,"avatar_url":"https://avatars.githubusercontent.com/u/128223?v=3","gravatar_id":"","url":"https://api.github.com/users/zzzeek","html_url":"https://github.com/zzzeek","followers_url":"https://api.github.com/users/zzzeek/followers","following_url":"https://api.github.com/users/zzzeek/following{/other_user}","gists_url":"https://api.github.com/users/zzzeek/gists{/gist_id}","starred_url":"https://api.github.com/users/zzzeek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zzzeek/subscriptions","organizations_url":"https://api.github.com/users/zzzeek/orgs","repos_url":"https://api.github.com/users/zzzeek/repos","events_url":"https://api.github.com/users/zzzeek/events{/privacy}","received_events_url":"https://api.github.com/users/zzzeek/received_events","type":"User","site_admin":false},"comments":4,"review_comments":1,"commits":1,"additions":14,"deletions":2,"changed_files":1}}