{"action":"created","issue":{"url":"https://api.github.com/repos/NRGI/resource-projects-etl/issues/48","labels_url":"https://api.github.com/repos/NRGI/resource-projects-etl/issues/48/labels{/name}","comments_url":"https://api.github.com/repos/NRGI/resource-projects-etl/issues/48/comments","events_url":"https://api.github.com/repos/NRGI/resource-projects-etl/issues/48/events","html_url":"https://github.com/NRGI/resource-projects-etl/issues/48","id":109493297,"number":48,"title":"Automate/document and debug virtuoso live/dev setup","user":{"login":"Bjwebb","id":634,"avatar_url":"https://avatars.githubusercontent.com/u/634?v=3","gravatar_id":"","url":"https://api.github.com/users/Bjwebb","html_url":"https://github.com/Bjwebb","followers_url":"https://api.github.com/users/Bjwebb/followers","following_url":"https://api.github.com/users/Bjwebb/following{/other_user}","gists_url":"https://api.github.com/users/Bjwebb/gists{/gist_id}","starred_url":"https://api.github.com/users/Bjwebb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bjwebb/subscriptions","organizations_url":"https://api.github.com/users/Bjwebb/orgs","repos_url":"https://api.github.com/users/Bjwebb/repos","events_url":"https://api.github.com/users/Bjwebb/events{/privacy}","received_events_url":"https://api.github.com/users/Bjwebb/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/NRGI/resource-projects-etl/labels/2%20-%20Working","name":"2 - Working","color":"CCCCCC"},{"url":"https://api.github.com/repos/NRGI/resource-projects-etl/labels/RP.org%20ETL%20Dashboard","name":"RP.org ETL Dashboard","color":"0052cc"}],"state":"open","locked":false,"assignee":{"login":"Bjwebb","id":634,"avatar_url":"https://avatars.githubusercontent.com/u/634?v=3","gravatar_id":"","url":"https://api.github.com/users/Bjwebb","html_url":"https://github.com/Bjwebb","followers_url":"https://api.github.com/users/Bjwebb/followers","following_url":"https://api.github.com/users/Bjwebb/following{/other_user}","gists_url":"https://api.github.com/users/Bjwebb/gists{/gist_id}","starred_url":"https://api.github.com/users/Bjwebb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bjwebb/subscriptions","organizations_url":"https://api.github.com/users/Bjwebb/orgs","repos_url":"https://api.github.com/users/Bjwebb/repos","events_url":"https://api.github.com/users/Bjwebb/events{/privacy}","received_events_url":"https://api.github.com/users/Bjwebb/received_events","type":"User","site_admin":false},"milestone":null,"comments":7,"created_at":"2015-10-02T13:43:27Z","updated_at":"2015-10-22T11:02:32Z","closed_at":null,"body":"To set up virtuoso to have live/staging endpoints, you must run something like:\n```\nDB.DBA.RDF_GRAPH_GROUP_CREATE('http://staging.resourceprojects.org/data/', 1);\nDB.DBA.RDF_GRAPH_GROUP_CREATE('http://resourceprojects.org/data/', 1);\n insert into DB.DBA.SYS_SPARQL_HOST (SH_HOST, SH_GRAPH_URI) values ('%live%', 'http://resourceprojects.org/data/');\ninsert into DB.DBA.SYS_SPARQL_HOST (SH_HOST, SH_GRAPH_URI) values ('%staging%', 'http://staging.resourceprojects.org/data/');\n```\n\nThis only needs to be run once for that virtuoso instance.\n\nHowever http://staging.resourceprojects.org/data/ seems to show stuff belonging to both graph groups.\r\n\r\n<!---\r\n@huboard:{\"order\":1.4210854715202004e-14,\"milestone_order\":8.731149137020111e-11,\"custom_state\":\"\"}\n-->\r\n"},"comment":{"url":"https://api.github.com/repos/NRGI/resource-projects-etl/issues/comments/150180865","html_url":"https://github.com/NRGI/resource-projects-etl/issues/48#issuecomment-150180865","issue_url":"https://api.github.com/repos/NRGI/resource-projects-etl/issues/48","id":150180865,"user":{"login":"Bjwebb","id":634,"avatar_url":"https://avatars.githubusercontent.com/u/634?v=3","gravatar_id":"","url":"https://api.github.com/users/Bjwebb","html_url":"https://github.com/Bjwebb","followers_url":"https://api.github.com/users/Bjwebb/followers","following_url":"https://api.github.com/users/Bjwebb/following{/other_user}","gists_url":"https://api.github.com/users/Bjwebb/gists{/gist_id}","starred_url":"https://api.github.com/users/Bjwebb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bjwebb/subscriptions","organizations_url":"https://api.github.com/users/Bjwebb/orgs","repos_url":"https://api.github.com/users/Bjwebb/repos","events_url":"https://api.github.com/users/Bjwebb/events{/privacy}","received_events_url":"https://api.github.com/users/Bjwebb/received_events","type":"User","site_admin":false},"created_at":"2015-10-22T11:02:32Z","updated_at":"2015-10-22T11:02:32Z","body":"Actually, after some brief digging in the lodspeakr source code, it looks like we should be able to do this directly in the settings file, which avoids having to modify every single query file:\r\n```\r\n$conf['endpointParams']['config'] = array(\r\n    'default-graph-uri' => 'http://staging.resourceprojects.org/data/'\r\n);\r\n```\r\nI'll look into setting this up.\r\n\r\nI'll also set the /sparql endpoint to default to live, as you suggest."}}