{"action":"created","issue":{"url":"https://api.github.com/repos/Paradigm4/scidb.dplyr/issues/6","repository_url":"https://api.github.com/repos/Paradigm4/scidb.dplyr","labels_url":"https://api.github.com/repos/Paradigm4/scidb.dplyr/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/Paradigm4/scidb.dplyr/issues/6/comments","events_url":"https://api.github.com/repos/Paradigm4/scidb.dplyr/issues/6/events","html_url":"https://github.com/Paradigm4/scidb.dplyr/issues/6","id":230462975,"number":6,"title":"create table, load, and reference data enhancement","user":{"login":"jrivers96","id":11034356,"avatar_url":"https://avatars1.githubusercontent.com/u/11034356?v=3","gravatar_id":"","url":"https://api.github.com/users/jrivers96","html_url":"https://github.com/jrivers96","followers_url":"https://api.github.com/users/jrivers96/followers","following_url":"https://api.github.com/users/jrivers96/following{/other_user}","gists_url":"https://api.github.com/users/jrivers96/gists{/gist_id}","starred_url":"https://api.github.com/users/jrivers96/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jrivers96/subscriptions","organizations_url":"https://api.github.com/users/jrivers96/orgs","repos_url":"https://api.github.com/users/jrivers96/repos","events_url":"https://api.github.com/users/jrivers96/events{/privacy}","received_events_url":"https://api.github.com/users/jrivers96/received_events","type":"User","site_admin":false},"labels":[{"id":593982885,"url":"https://api.github.com/repos/Paradigm4/scidb.dplyr/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-05-22T17:17:26Z","updated_at":"2017-05-22T18:06:01Z","closed_at":null,"body":"A customer is interested in having the equivalent of the dplyr airline tutorial to train users with. Loading and referencing data within the dplyr paradigm was important to them. \r\n\r\nhttps://cran.r-project.org/web/packages/dplyr/vignettes/databases.html\r\n\r\n```\r\n#Install necessary packages\r\ninstall.packages('RSQLite')\r\ninstall.packages('nycflights13')\r\n\r\n#Create table\r\nmy_db <- src_sqlite(\"my_db.sqlite3\", create = T)\r\n\r\n#load example dataset into R\r\nlibrary(nycflights13)\r\n\r\n#load data into sqlite table\r\nflights_sqlite <- copy_to(my_db, flights, temporary = FALSE, indexes = list(\r\n  c(\"year\", \"month\", \"day\"), \"carrier\", \"tailnum\"))\r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/Paradigm4/scidb.dplyr/issues/comments/303176335","html_url":"https://github.com/Paradigm4/scidb.dplyr/issues/6#issuecomment-303176335","issue_url":"https://api.github.com/repos/Paradigm4/scidb.dplyr/issues/6","id":303176335,"user":{"login":"bwlewis","id":142494,"avatar_url":"https://avatars0.githubusercontent.com/u/142494?v=3","gravatar_id":"","url":"https://api.github.com/users/bwlewis","html_url":"https://github.com/bwlewis","followers_url":"https://api.github.com/users/bwlewis/followers","following_url":"https://api.github.com/users/bwlewis/following{/other_user}","gists_url":"https://api.github.com/users/bwlewis/gists{/gist_id}","starred_url":"https://api.github.com/users/bwlewis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bwlewis/subscriptions","organizations_url":"https://api.github.com/users/bwlewis/orgs","repos_url":"https://api.github.com/users/bwlewis/repos","events_url":"https://api.github.com/users/bwlewis/events{/privacy}","received_events_url":"https://api.github.com/users/bwlewis/received_events","type":"User","site_admin":false},"created_at":"2017-05-22T18:06:01Z","updated_at":"2017-05-22T18:06:01Z","body":"so just add a copy_to function that wraps as.scidb to the scidb.dplyr\npackage...\n\nOn May 22, 2017 13:29, \"Jonathan Rivers\" <notifications@github.com> wrote:\n\n> I showed them the as.scidb and they were not happy with it. The want to be\n> able to find all of the syntax in one set of documents and a single\n> package. I will take a shot at implementing the airline tutorial.\n>\n> —\n> You are receiving this because you commented.\n> Reply to this email directly, view it on GitHub\n> <https://github.com/Paradigm4/scidb.dplyr/issues/6#issuecomment-303167121>,\n> or mute the thread\n> <https://github.com/notifications/unsubscribe-auth/AAIsnt-WpXQN4nyBDzPkAmuKJaXTGg98ks5r8cYNgaJpZM4NipSA>\n> .\n>\n"}}
{"actor":{"display_login":"bwlewis"}}