{"action":"created","issue":{"url":"https://api.github.com/repos/smithjd/sql-pet/issues/81","repository_url":"https://api.github.com/repos/smithjd/sql-pet","labels_url":"https://api.github.com/repos/smithjd/sql-pet/issues/81/labels{/name}","comments_url":"https://api.github.com/repos/smithjd/sql-pet/issues/81/comments","events_url":"https://api.github.com/repos/smithjd/sql-pet/issues/81/events","html_url":"https://github.com/smithjd/sql-pet/issues/81","id":362988546,"node_id":"MDU6SXNzdWUzNjI5ODg1NDY=","number":81,"title":"Working Directory Issues of Windows VS Mac","user":{"login":"ianfrantz","id":11981942,"node_id":"MDQ6VXNlcjExOTgxOTQy","avatar_url":"https://avatars2.githubusercontent.com/u/11981942?v=4","gravatar_id":"","url":"https://api.github.com/users/ianfrantz","html_url":"https://github.com/ianfrantz","followers_url":"https://api.github.com/users/ianfrantz/followers","following_url":"https://api.github.com/users/ianfrantz/following{/other_user}","gists_url":"https://api.github.com/users/ianfrantz/gists{/gist_id}","starred_url":"https://api.github.com/users/ianfrantz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ianfrantz/subscriptions","organizations_url":"https://api.github.com/users/ianfrantz/orgs","repos_url":"https://api.github.com/users/ianfrantz/repos","events_url":"https://api.github.com/users/ianfrantz/events{/privacy}","received_events_url":"https://api.github.com/users/ianfrantz/received_events","type":"User","site_admin":false},"labels":[{"id":1018846343,"node_id":"MDU6TGFiZWwxMDE4ODQ2MzQz","url":"https://api.github.com/repos/smithjd/sql-pet/labels/bug","name":"bug","color":"d73a4a","default":true}],"state":"open","locked":false,"assignee":{"login":"SophieMYang","id":28746796,"node_id":"MDQ6VXNlcjI4NzQ2Nzk2","avatar_url":"https://avatars2.githubusercontent.com/u/28746796?v=4","gravatar_id":"","url":"https://api.github.com/users/SophieMYang","html_url":"https://github.com/SophieMYang","followers_url":"https://api.github.com/users/SophieMYang/followers","following_url":"https://api.github.com/users/SophieMYang/following{/other_user}","gists_url":"https://api.github.com/users/SophieMYang/gists{/gist_id}","starred_url":"https://api.github.com/users/SophieMYang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SophieMYang/subscriptions","organizations_url":"https://api.github.com/users/SophieMYang/orgs","repos_url":"https://api.github.com/users/SophieMYang/repos","events_url":"https://api.github.com/users/SophieMYang/events{/privacy}","received_events_url":"https://api.github.com/users/SophieMYang/received_events","type":"User","site_admin":false},"assignees":[{"login":"SophieMYang","id":28746796,"node_id":"MDQ6VXNlcjI4NzQ2Nzk2","avatar_url":"https://avatars2.githubusercontent.com/u/28746796?v=4","gravatar_id":"","url":"https://api.github.com/users/SophieMYang","html_url":"https://github.com/SophieMYang","followers_url":"https://api.github.com/users/SophieMYang/followers","following_url":"https://api.github.com/users/SophieMYang/following{/other_user}","gists_url":"https://api.github.com/users/SophieMYang/gists{/gist_id}","starred_url":"https://api.github.com/users/SophieMYang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SophieMYang/subscriptions","organizations_url":"https://api.github.com/users/SophieMYang/orgs","repos_url":"https://api.github.com/users/SophieMYang/repos","events_url":"https://api.github.com/users/SophieMYang/events{/privacy}","received_events_url":"https://api.github.com/users/SophieMYang/received_events","type":"User","site_admin":false}],"milestone":null,"comments":5,"created_at":"2018-09-23T23:49:58Z","updated_at":"2018-09-25T21:19:08Z","closed_at":null,"author_association":"COLLABORATOR","body":"**Bug in: 05-docker-setup-postgres-with-dvdrental.Rmd**\r\nLine 72-73: The source parameter contains two apostrophes. This causes an invalid mount path on windows. `invalid mount path: ''C:/Users/ianfr/Desktop/R_Programs/sql-pet/r-database-docker/'' mount path must be absolute.\"`\r\n\r\n**To Fix** \r\nThese apostrophes must be removed but this may impact the Mac OS users. I suspect the problem starts on line 63 `wd <- getwd()`. Perhaps we want to look at what parameters are available to standardize how R reads the wd into it's namespace. \r\n\r\n**To Reproduce**\r\nSteps to reproduce the behavior:\r\n1. Open: 05-docker-setup-postgres-with-dvdrental.Rmd\r\n2. GoTo: Line 65 - setting up docker_cmd with glue\r\n3. Windows output:\r\n`run --detach  --name sql-pet --publish 5432:5432 --mount type=bind,source='C:/Users/ianfr/Desktop/R_Programs/sql-pet/r-database-docker/',target=/petdir postgres-dvdrental`\r\n4. Notice how source is single quoted in the docker_cmd. \r\n5. Source becomes double quoted in the execution phase. `''C:/Users/ianfr/Desktop/R_Programs/sql-pet/r-database-docker/''`\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/smithjd/sql-pet/issues/comments/424505214","html_url":"https://github.com/smithjd/sql-pet/issues/81#issuecomment-424505214","issue_url":"https://api.github.com/repos/smithjd/sql-pet/issues/81","id":424505214,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNDUwNTIxNA==","user":{"login":"smithjd","id":2738096,"node_id":"MDQ6VXNlcjI3MzgwOTY=","avatar_url":"https://avatars3.githubusercontent.com/u/2738096?v=4","gravatar_id":"","url":"https://api.github.com/users/smithjd","html_url":"https://github.com/smithjd","followers_url":"https://api.github.com/users/smithjd/followers","following_url":"https://api.github.com/users/smithjd/following{/other_user}","gists_url":"https://api.github.com/users/smithjd/gists{/gist_id}","starred_url":"https://api.github.com/users/smithjd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smithjd/subscriptions","organizations_url":"https://api.github.com/users/smithjd/orgs","repos_url":"https://api.github.com/users/smithjd/repos","events_url":"https://api.github.com/users/smithjd/events{/privacy}","received_events_url":"https://api.github.com/users/smithjd/received_events","type":"User","site_admin":false},"created_at":"2018-09-25T21:19:08Z","updated_at":"2018-09-25T21:19:08Z","author_association":"OWNER","body":"That's basically what I've got:\r\n\r\n` 'type=bind,source=\"', wd, '/\",target=/petdir',`\r\n\r\nAre you suggesting that `type`, `source`, `target` should all be separated out?  I've left them in one undifferentiated chunk, not being clear that we have something useful to say about each of those parts."}}
{"actor":{"display_login":"smithjd"}}