{"action":"created","issue":{"url":"https://api.github.com/repos/r-dbi/DBI/issues/237","repository_url":"https://api.github.com/repos/r-dbi/DBI","labels_url":"https://api.github.com/repos/r-dbi/DBI/issues/237/labels{/name}","comments_url":"https://api.github.com/repos/r-dbi/DBI/issues/237/comments","events_url":"https://api.github.com/repos/r-dbi/DBI/issues/237/events","html_url":"https://github.com/r-dbi/DBI/issues/237","id":316859915,"number":237,"title":"dbListObjects() documentation","user":{"login":"RLesur","id":19177171,"avatar_url":"https://avatars0.githubusercontent.com/u/19177171?v=4","gravatar_id":"","url":"https://api.github.com/users/RLesur","html_url":"https://github.com/RLesur","followers_url":"https://api.github.com/users/RLesur/followers","following_url":"https://api.github.com/users/RLesur/following{/other_user}","gists_url":"https://api.github.com/users/RLesur/gists{/gist_id}","starred_url":"https://api.github.com/users/RLesur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RLesur/subscriptions","organizations_url":"https://api.github.com/users/RLesur/orgs","repos_url":"https://api.github.com/users/RLesur/repos","events_url":"https://api.github.com/users/RLesur/events{/privacy}","received_events_url":"https://api.github.com/users/RLesur/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-23T15:18:55Z","updated_at":"2018-04-23T19:34:14Z","closed_at":null,"author_association":"NONE","body":"I don't understand the `dbListObjects` documentation for the `prefix` argument. I'm sorry if the answer is obvious.  \r\nIt is stated that:\r\n\r\n> The `table` column is of type list. Each object in this list is suitable for use as argument in `dbQuoteIdentifier()`. \r\nhttps://github.com/r-dbi/DBItest/blob/2f59ef31d157cbbd95eaf67869e60ed03f6d035b/R/spec-sql-list-objects.R#L26\r\n\r\n> Values in `table` column that have `is_prefix == TRUE` can be passed as the `prefix` argument to another call to `dbListObjects()`.\r\nhttps://github.com/r-dbi/DBItest/blob/2f59ef31d157cbbd95eaf67869e60ed03f6d035b/R/spec-sql-list-objects.R#L134\r\n\r\nI understand from these quotes that values passed to the `prefix` argument should be suitable for use as argument in `dbQuoteIdentifier()`.\r\n\r\nHowever, the documentation for the `prefix` argument says:\r\n\r\n> `prefix` A fully qualified path in the database's namespace, or `NULL`.  will be passed to `dbUnquoteIdentifier()`.\r\nhttps://github.com/r-dbi/DBI/blob/2bcb77d03ab52c8fd14ff76af1087a8b12dcbd25/R/DBConnection.R#L388\r\n\r\nShall I understand that the `prefix` argument is suitable for use as argument in both `dbQuoteIdentifier()` and `dbUnquoteIdentifier()`? (I wonder how it is possible). "},"comment":{"url":"https://api.github.com/repos/r-dbi/DBI/issues/comments/383695832","html_url":"https://github.com/r-dbi/DBI/issues/237#issuecomment-383695832","issue_url":"https://api.github.com/repos/r-dbi/DBI/issues/237","id":383695832,"user":{"login":"krlmlr","id":1741643,"avatar_url":"https://avatars0.githubusercontent.com/u/1741643?v=4","gravatar_id":"","url":"https://api.github.com/users/krlmlr","html_url":"https://github.com/krlmlr","followers_url":"https://api.github.com/users/krlmlr/followers","following_url":"https://api.github.com/users/krlmlr/following{/other_user}","gists_url":"https://api.github.com/users/krlmlr/gists{/gist_id}","starred_url":"https://api.github.com/users/krlmlr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krlmlr/subscriptions","organizations_url":"https://api.github.com/users/krlmlr/orgs","repos_url":"https://api.github.com/users/krlmlr/repos","events_url":"https://api.github.com/users/krlmlr/events{/privacy}","received_events_url":"https://api.github.com/users/krlmlr/received_events","type":"User","site_admin":false},"created_at":"2018-04-23T19:34:14Z","updated_at":"2018-04-23T19:34:14Z","author_association":"OWNER","body":"Thanks. The documentation could be clearer on the fact that `dbQuoteIdentifier()` returns `SQL` objects unchanged, and `dbUnquoteIdentifier()` returns `Id` objects unchanged. Calling `dbQuoteIdentifier()` on `Id` converts it to an `SQL`, calling `dbUnquoteIdentifier()` on an `SQL` converts it to an `Id` (or dies trying).\r\n\r\nI'll tweak the documentation. Are the examples more helpful?"}}
{"actor":{"display_login":"krlmlr"}}