{"action":"created","comment":{"url":"https://api.github.com/repos/PecanProject/pecan/pulls/comments/44497160","id":44497160,"diff_hunk":"@@ -0,0 +1,19 @@\n+##' @name db.query.file.path\n+##' @title Get file path given id and machine\n+##' @param input_id\n+##' @param host_name\n+##' @param con : database connection\n+##' @export \n+##' \n+##' @author Betsy Cowdery \n+query.file.path <- function(input.id, host_name, con){\n+  machine.host <- ifelse(host$name == \"localhost\",fqdn(),host_name)\n+  machine = db.query(paste0(\"SELECT * from machines where hostname = '\",machine.host,\"'\"),con)\n+  dbfile = db.query(paste(\"SELECT file_name,file_path from dbfiles where container_id =\",input.id,\" and container_type = 'Input' and machine_id =\",machine$id),con)\n+  path <- file.path(dbfile$file_path,dbfile$file_name)\n+  if(file.exists(path)){","path":"db/R/query.file.path.R","position":14,"original_position":14,"commit_id":"30121990dceef2af12a53903580fda64170171c4","original_commit_id":"17c3e9c1e3176433475b5bb50440a5177fdd37a1","user":{"login":"mdietze","id":3081466,"avatar_url":"https://avatars.githubusercontent.com/u/3081466?v=3","gravatar_id":"","url":"https://api.github.com/users/mdietze","html_url":"https://github.com/mdietze","followers_url":"https://api.github.com/users/mdietze/followers","following_url":"https://api.github.com/users/mdietze/following{/other_user}","gists_url":"https://api.github.com/users/mdietze/gists{/gist_id}","starred_url":"https://api.github.com/users/mdietze/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdietze/subscriptions","organizations_url":"https://api.github.com/users/mdietze/orgs","repos_url":"https://api.github.com/users/mdietze/repos","events_url":"https://api.github.com/users/mdietze/events{/privacy}","received_events_url":"https://api.github.com/users/mdietze/received_events","type":"User","site_admin":false},"body":"In the short term, I'd say just disable this since it is a non-trivial check. The objective of the function is to query a file from the DB, this check isn't strictly required","created_at":"2015-11-11T02:59:23Z","updated_at":"2015-11-11T02:59:23Z","html_url":"https://github.com/PecanProject/pecan/pull/674#discussion_r44497160","pull_request_url":"https://api.github.com/repos/PecanProject/pecan/pulls/674","_links":{"self":{"href":"https://api.github.com/repos/PecanProject/pecan/pulls/comments/44497160"},"html":{"href":"https://github.com/PecanProject/pecan/pull/674#discussion_r44497160"},"pull_request":{"href":"https://api.github.com/repos/PecanProject/pecan/pulls/674"}}},"pull_request":{"url":"https://api.github.com/repos/PecanProject/pecan/pulls/674","id":49897356,"html_url":"https://github.com/PecanProject/pecan/pull/674","diff_url":"https://github.com/PecanProject/pecan/pull/674.diff","patch_url":"https://github.com/PecanProject/pecan/pull/674.patch","issue_url":"https://api.github.com/repos/PecanProject/pecan/issues/674","number":674,"state":"open","locked":false,"title":"Database query function for formats and variables in conjunction with met2CF.CSV update","user":{"login":"bcow","id":5503595,"avatar_url":"https://avatars.githubusercontent.com/u/5503595?v=3","gravatar_id":"","url":"https://api.github.com/users/bcow","html_url":"https://github.com/bcow","followers_url":"https://api.github.com/users/bcow/followers","following_url":"https://api.github.com/users/bcow/following{/other_user}","gists_url":"https://api.github.com/users/bcow/gists{/gist_id}","starred_url":"https://api.github.com/users/bcow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bcow/subscriptions","organizations_url":"https://api.github.com/users/bcow/orgs","repos_url":"https://api.github.com/users/bcow/repos","events_url":"https://api.github.com/users/bcow/events{/privacy}","received_events_url":"https://api.github.com/users/bcow/received_events","type":"User","site_admin":false},"body":"Primarily motivated by the need to get these things up and running for Fluxnet. \r\nHowever, I haven't had the chance to test with a Fluxnet file yet. ","created_at":"2015-11-05T23:39:09Z","updated_at":"2015-11-11T02:59:23Z","closed_at":null,"merged_at":null,"merge_commit_sha":"cb1003b3371c8ec1905beee43432f4fb69c92f92","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/PecanProject/pecan/pulls/674/commits","review_comments_url":"https://api.github.com/repos/PecanProject/pecan/pulls/674/comments","review_comment_url":"https://api.github.com/repos/PecanProject/pecan/pulls/comments{/number}","comments_url":"https://api.github.com/repos/PecanProject/pecan/issues/674/comments","statuses_url":"https://api.github.com/repos/PecanProject/pecan/statuses/30121990dceef2af12a53903580fda64170171c4","head":{"label":"bcow:master","ref":"master","sha":"30121990dceef2af12a53903580fda64170171c4","user":{"login":"bcow","id":5503595,"avatar_url":"https://avatars.githubusercontent.com/u/5503595?v=3","gravatar_id":"","url":"https://api.github.com/users/bcow","html_url":"https://github.com/bcow","followers_url":"https://api.github.com/users/bcow/followers","following_url":"https://api.github.com/users/bcow/following{/other_user}","gists_url":"https://api.github.com/users/bcow/gists{/gist_id}","starred_url":"https://api.github.com/users/bcow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bcow/subscriptions","organizations_url":"https://api.github.com/users/bcow/orgs","repos_url":"https://api.github.com/users/bcow/repos","events_url":"https://api.github.com/users/bcow/events{/privacy}","received_events_url":"https://api.github.com/users/bcow/received_events","type":"User","site_admin":false},"repo":{"id":19579017,"name":"pecan","full_name":"bcow/pecan","owner":{"login":"bcow","id":5503595,"avatar_url":"https://avatars.githubusercontent.com/u/5503595?v=3","gravatar_id":"","url":"https://api.github.com/users/bcow","html_url":"https://github.com/bcow","followers_url":"https://api.github.com/users/bcow/followers","following_url":"https://api.github.com/users/bcow/following{/other_user}","gists_url":"https://api.github.com/users/bcow/gists{/gist_id}","starred_url":"https://api.github.com/users/bcow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bcow/subscriptions","organizations_url":"https://api.github.com/users/bcow/orgs","repos_url":"https://api.github.com/users/bcow/repos","events_url":"https://api.github.com/users/bcow/events{/privacy}","received_events_url":"https://api.github.com/users/bcow/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/bcow/pecan","description":"The Predictive Ecosystem Analyzer (PEcAn) is an integrated ecological bioinformatics toolbox.","fork":true,"url":"https://api.github.com/repos/bcow/pecan","forks_url":"https://api.github.com/repos/bcow/pecan/forks","keys_url":"https://api.github.com/repos/bcow/pecan/keys{/key_id}","collaborators_url":"https://api.github.com/repos/bcow/pecan/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/bcow/pecan/teams","hooks_url":"https://api.github.com/repos/bcow/pecan/hooks","issue_events_url":"https://api.github.com/repos/bcow/pecan/issues/events{/number}","events_url":"https://api.github.com/repos/bcow/pecan/events","assignees_url":"https://api.github.com/repos/bcow/pecan/assignees{/user}","branches_url":"https://api.github.com/repos/bcow/pecan/branches{/branch}","tags_url":"https://api.github.com/repos/bcow/pecan/tags","blobs_url":"https://api.github.com/repos/bcow/pecan/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/bcow/pecan/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/bcow/pecan/git/refs{/sha}","trees_url":"https://api.github.com/repos/bcow/pecan/git/trees{/sha}","statuses_url":"https://api.github.com/repos/bcow/pecan/statuses/{sha}","languages_url":"https://api.github.com/repos/bcow/pecan/languages","stargazers_url":"https://api.github.com/repos/bcow/pecan/stargazers","contributors_url":"https://api.github.com/repos/bcow/pecan/contributors","subscribers_url":"https://api.github.com/repos/bcow/pecan/subscribers","subscription_url":"https://api.github.com/repos/bcow/pecan/subscription","commits_url":"https://api.github.com/repos/bcow/pecan/commits{/sha}","git_commits_url":"https://api.github.com/repos/bcow/pecan/git/commits{/sha}","comments_url":"https://api.github.com/repos/bcow/pecan/comments{/number}","issue_comment_url":"https://api.github.com/repos/bcow/pecan/issues/comments{/number}","contents_url":"https://api.github.com/repos/bcow/pecan/contents/{+path}","compare_url":"https://api.github.com/repos/bcow/pecan/compare/{base}...{head}","merges_url":"https://api.github.com/repos/bcow/pecan/merges","archive_url":"https://api.github.com/repos/bcow/pecan/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/bcow/pecan/downloads","issues_url":"https://api.github.com/repos/bcow/pecan/issues{/number}","pulls_url":"https://api.github.com/repos/bcow/pecan/pulls{/number}","milestones_url":"https://api.github.com/repos/bcow/pecan/milestones{/number}","notifications_url":"https://api.github.com/repos/bcow/pecan/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/bcow/pecan/labels{/name}","releases_url":"https://api.github.com/repos/bcow/pecan/releases{/id}","created_at":"2014-05-08T15:40:52Z","updated_at":"2015-05-22T19:53:57Z","pushed_at":"2015-11-11T02:50:12Z","git_url":"git://github.com/bcow/pecan.git","ssh_url":"git@github.com:bcow/pecan.git","clone_url":"https://github.com/bcow/pecan.git","svn_url":"https://github.com/bcow/pecan","homepage":"www.pecanproject.org","size":116853,"stargazers_count":0,"watchers_count":0,"language":"R","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":1,"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"base":{"label":"PecanProject:master","ref":"master","sha":"d17894539ab7e4300de807fd2625dbb0e19c8912","user":{"login":"PecanProject","id":2879854,"avatar_url":"https://avatars.githubusercontent.com/u/2879854?v=3","gravatar_id":"","url":"https://api.github.com/users/PecanProject","html_url":"https://github.com/PecanProject","followers_url":"https://api.github.com/users/PecanProject/followers","following_url":"https://api.github.com/users/PecanProject/following{/other_user}","gists_url":"https://api.github.com/users/PecanProject/gists{/gist_id}","starred_url":"https://api.github.com/users/PecanProject/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PecanProject/subscriptions","organizations_url":"https://api.github.com/users/PecanProject/orgs","repos_url":"https://api.github.com/users/PecanProject/repos","events_url":"https://api.github.com/users/PecanProject/events{/privacy}","received_events_url":"https://api.github.com/users/PecanProject/received_events","type":"Organization","site_admin":false},"repo":{"id":6857384,"name":"pecan","full_name":"PecanProject/pecan","owner":{"login":"PecanProject","id":2879854,"avatar_url":"https://avatars.githubusercontent.com/u/2879854?v=3","gravatar_id":"","url":"https://api.github.com/users/PecanProject","html_url":"https://github.com/PecanProject","followers_url":"https://api.github.com/users/PecanProject/followers","following_url":"https://api.github.com/users/PecanProject/following{/other_user}","gists_url":"https://api.github.com/users/PecanProject/gists{/gist_id}","starred_url":"https://api.github.com/users/PecanProject/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PecanProject/subscriptions","organizations_url":"https://api.github.com/users/PecanProject/orgs","repos_url":"https://api.github.com/users/PecanProject/repos","events_url":"https://api.github.com/users/PecanProject/events{/privacy}","received_events_url":"https://api.github.com/users/PecanProject/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/PecanProject/pecan","description":"The Predictive Ecosystem Analyzer (PEcAn) is an integrated ecological bioinformatics toolbox.","fork":false,"url":"https://api.github.com/repos/PecanProject/pecan","forks_url":"https://api.github.com/repos/PecanProject/pecan/forks","keys_url":"https://api.github.com/repos/PecanProject/pecan/keys{/key_id}","collaborators_url":"https://api.github.com/repos/PecanProject/pecan/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/PecanProject/pecan/teams","hooks_url":"https://api.github.com/repos/PecanProject/pecan/hooks","issue_events_url":"https://api.github.com/repos/PecanProject/pecan/issues/events{/number}","events_url":"https://api.github.com/repos/PecanProject/pecan/events","assignees_url":"https://api.github.com/repos/PecanProject/pecan/assignees{/user}","branches_url":"https://api.github.com/repos/PecanProject/pecan/branches{/branch}","tags_url":"https://api.github.com/repos/PecanProject/pecan/tags","blobs_url":"https://api.github.com/repos/PecanProject/pecan/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/PecanProject/pecan/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/PecanProject/pecan/git/refs{/sha}","trees_url":"https://api.github.com/repos/PecanProject/pecan/git/trees{/sha}","statuses_url":"https://api.github.com/repos/PecanProject/pecan/statuses/{sha}","languages_url":"https://api.github.com/repos/PecanProject/pecan/languages","stargazers_url":"https://api.github.com/repos/PecanProject/pecan/stargazers","contributors_url":"https://api.github.com/repos/PecanProject/pecan/contributors","subscribers_url":"https://api.github.com/repos/PecanProject/pecan/subscribers","subscription_url":"https://api.github.com/repos/PecanProject/pecan/subscription","commits_url":"https://api.github.com/repos/PecanProject/pecan/commits{/sha}","git_commits_url":"https://api.github.com/repos/PecanProject/pecan/git/commits{/sha}","comments_url":"https://api.github.com/repos/PecanProject/pecan/comments{/number}","issue_comment_url":"https://api.github.com/repos/PecanProject/pecan/issues/comments{/number}","contents_url":"https://api.github.com/repos/PecanProject/pecan/contents/{+path}","compare_url":"https://api.github.com/repos/PecanProject/pecan/compare/{base}...{head}","merges_url":"https://api.github.com/repos/PecanProject/pecan/merges","archive_url":"https://api.github.com/repos/PecanProject/pecan/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/PecanProject/pecan/downloads","issues_url":"https://api.github.com/repos/PecanProject/pecan/issues{/number}","pulls_url":"https://api.github.com/repos/PecanProject/pecan/pulls{/number}","milestones_url":"https://api.github.com/repos/PecanProject/pecan/milestones{/number}","notifications_url":"https://api.github.com/repos/PecanProject/pecan/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/PecanProject/pecan/labels{/name}","releases_url":"https://api.github.com/repos/PecanProject/pecan/releases{/id}","created_at":"2012-11-25T23:48:26Z","updated_at":"2015-11-04T20:30:51Z","pushed_at":"2015-11-11T02:50:13Z","git_url":"git://github.com/PecanProject/pecan.git","ssh_url":"git@github.com:PecanProject/pecan.git","clone_url":"https://github.com/PecanProject/pecan.git","svn_url":"https://github.com/PecanProject/pecan","homepage":"www.pecanproject.org","size":342044,"stargazers_count":38,"watchers_count":38,"language":"R","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":69,"mirror_url":null,"open_issues_count":136,"forks":69,"open_issues":136,"watchers":38,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/PecanProject/pecan/pulls/674"},"html":{"href":"https://github.com/PecanProject/pecan/pull/674"},"issue":{"href":"https://api.github.com/repos/PecanProject/pecan/issues/674"},"comments":{"href":"https://api.github.com/repos/PecanProject/pecan/issues/674/comments"},"review_comments":{"href":"https://api.github.com/repos/PecanProject/pecan/pulls/674/comments"},"review_comment":{"href":"https://api.github.com/repos/PecanProject/pecan/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/PecanProject/pecan/pulls/674/commits"},"statuses":{"href":"https://api.github.com/repos/PecanProject/pecan/statuses/30121990dceef2af12a53903580fda64170171c4"}}}}