{"action":"created","issue":{"url":"https://api.github.com/repos/reactiverse/reactive-pg-client/issues/152","repository_url":"https://api.github.com/repos/reactiverse/reactive-pg-client","labels_url":"https://api.github.com/repos/reactiverse/reactive-pg-client/issues/152/labels{/name}","comments_url":"https://api.github.com/repos/reactiverse/reactive-pg-client/issues/152/comments","events_url":"https://api.github.com/repos/reactiverse/reactive-pg-client/issues/152/events","html_url":"https://github.com/reactiverse/reactive-pg-client/issues/152","id":352591546,"node_id":"MDU6SXNzdWUzNTI1OTE1NDY=","number":152,"title":"PgPool.preparedBatch with no parameters","user":{"login":"yonigibbs","id":39593145,"node_id":"MDQ6VXNlcjM5NTkzMTQ1","avatar_url":"https://avatars3.githubusercontent.com/u/39593145?v=4","gravatar_id":"","url":"https://api.github.com/users/yonigibbs","html_url":"https://github.com/yonigibbs","followers_url":"https://api.github.com/users/yonigibbs/followers","following_url":"https://api.github.com/users/yonigibbs/following{/other_user}","gists_url":"https://api.github.com/users/yonigibbs/gists{/gist_id}","starred_url":"https://api.github.com/users/yonigibbs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yonigibbs/subscriptions","organizations_url":"https://api.github.com/users/yonigibbs/orgs","repos_url":"https://api.github.com/users/yonigibbs/repos","events_url":"https://api.github.com/users/yonigibbs/events{/privacy}","received_events_url":"https://api.github.com/users/yonigibbs/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2018-08-21T15:20:48Z","updated_at":"2018-08-21T15:54:24Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nWhen calling `PgPool.preparedBatch` with an SQL string with no parameters, I expected to be able to pass in an empty list of Tuples for the `batch` parameter.  However when I did this, no result was ever returned (the callback was never called).  I got round this by instead passing in a list with one entry in it: `Tuple.tuple()`\r\n\r\nIs this behaviour correct?  Is the `batch` parameter meant for passing in parameters to bind into the query?  If so, is it right that you need to pass in a list with one \"dummy\" value in order for it to work?\r\n\r\nCheers!"},"comment":{"url":"https://api.github.com/repos/reactiverse/reactive-pg-client/issues/comments/414725169","html_url":"https://github.com/reactiverse/reactive-pg-client/issues/152#issuecomment-414725169","issue_url":"https://api.github.com/repos/reactiverse/reactive-pg-client/issues/152","id":414725169,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNDcyNTE2OQ==","user":{"login":"yonigibbs","id":39593145,"node_id":"MDQ6VXNlcjM5NTkzMTQ1","avatar_url":"https://avatars3.githubusercontent.com/u/39593145?v=4","gravatar_id":"","url":"https://api.github.com/users/yonigibbs","html_url":"https://github.com/yonigibbs","followers_url":"https://api.github.com/users/yonigibbs/followers","following_url":"https://api.github.com/users/yonigibbs/following{/other_user}","gists_url":"https://api.github.com/users/yonigibbs/gists{/gist_id}","starred_url":"https://api.github.com/users/yonigibbs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yonigibbs/subscriptions","organizations_url":"https://api.github.com/users/yonigibbs/orgs","repos_url":"https://api.github.com/users/yonigibbs/repos","events_url":"https://api.github.com/users/yonigibbs/events{/privacy}","received_events_url":"https://api.github.com/users/yonigibbs/received_events","type":"User","site_admin":false},"created_at":"2018-08-21T15:54:24Z","updated_at":"2018-08-21T15:54:24Z","author_association":"NONE","body":"Ah, great, thanks @vietj.  So if I want to run two separate queries, there's no point using a batch, because I can just issue two separate query requests using `preparedQuery'?  Presumably that same holds true for the `query` method itself, i.e. when I don't prepare the query?\r\n\r\nAnd, if I do want to use a batch (e.g. if I want to run the same query X times, but with different bind values), then I should do what you suggest about replacing the placeholders.\r\n\r\nI'll look at @jklingsporn's library, thanks."}}
{"actor":{"display_login":"yonigibbs"}}