{"action":"created","issue":{"url":"https://api.github.com/repos/Deepwalker/aldjemy/issues/20","labels_url":"https://api.github.com/repos/Deepwalker/aldjemy/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/Deepwalker/aldjemy/issues/20/comments","events_url":"https://api.github.com/repos/Deepwalker/aldjemy/issues/20/events","html_url":"https://github.com/Deepwalker/aldjemy/pull/20","id":53324136,"number":20,"title":"Fix HSTORE support and save some keystrokes.","user":{"login":"yihuang","id":236070,"avatar_url":"https://avatars.githubusercontent.com/u/236070?v=3","gravatar_id":"","url":"https://api.github.com/users/yihuang","html_url":"https://github.com/yihuang","followers_url":"https://api.github.com/users/yihuang/followers","following_url":"https://api.github.com/users/yihuang/following{/other_user}","gists_url":"https://api.github.com/users/yihuang/gists{/gist_id}","starred_url":"https://api.github.com/users/yihuang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yihuang/subscriptions","organizations_url":"https://api.github.com/users/yihuang/orgs","repos_url":"https://api.github.com/users/yihuang/repos","events_url":"https://api.github.com/users/yihuang/events{/privacy}","received_events_url":"https://api.github.com/users/yihuang/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-01-04T03:43:40Z","updated_at":"2015-01-14T03:49:59Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Deepwalker/aldjemy/pulls/20","html_url":"https://github.com/Deepwalker/aldjemy/pull/20","diff_url":"https://github.com/Deepwalker/aldjemy/pull/20.diff","patch_url":"https://github.com/Deepwalker/aldjemy/pull/20.patch"},"body":"Since building complex queries using sqlalchemy's expression api involves lots of tokens like `Model.sa.table` and `Model.sa.table.fieldname`, so i'd like to shorten them to `Model.t` and `Model.c.fieldname`.\r\nAlso i add a `bind` method to execute an arbitrary `selectable` object."},"comment":{"url":"https://api.github.com/repos/Deepwalker/aldjemy/issues/comments/69865334","html_url":"https://github.com/Deepwalker/aldjemy/pull/20#issuecomment-69865334","issue_url":"https://api.github.com/repos/Deepwalker/aldjemy/issues/20","id":69865334,"user":{"login":"yihuang","id":236070,"avatar_url":"https://avatars.githubusercontent.com/u/236070?v=3","gravatar_id":"","url":"https://api.github.com/users/yihuang","html_url":"https://github.com/yihuang","followers_url":"https://api.github.com/users/yihuang/followers","following_url":"https://api.github.com/users/yihuang/following{/other_user}","gists_url":"https://api.github.com/users/yihuang/gists{/gist_id}","starred_url":"https://api.github.com/users/yihuang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yihuang/subscriptions","organizations_url":"https://api.github.com/users/yihuang/orgs","repos_url":"https://api.github.com/users/yihuang/repos","events_url":"https://api.github.com/users/yihuang/events{/privacy}","received_events_url":"https://api.github.com/users/yihuang/received_events","type":"User","site_admin":false},"created_at":"2015-01-14T03:49:59Z","updated_at":"2015-01-14T03:49:59Z","body":"https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalchemy/engine/strategies.py#L157\r\n\r\nAs you can see here, `Engine` listens to `first_connect` event call `dialect.initialize()`.\r\n\r\nhttps://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalchemy/dialects/postgresql/psycopg2.py#L500\r\n\r\nAnd in psycopg2 dialect, `initialize` is where `_has_native_hstore` get initialized, which is critical for using `HSTORE` field type."}}