{"action":"created","issue":{"url":"https://api.github.com/repos/ISISComputingGroup/IBEX/issues/1515","repository_url":"https://api.github.com/repos/ISISComputingGroup/IBEX","labels_url":"https://api.github.com/repos/ISISComputingGroup/IBEX/issues/1515/labels{/name}","comments_url":"https://api.github.com/repos/ISISComputingGroup/IBEX/issues/1515/comments","events_url":"https://api.github.com/repos/ISISComputingGroup/IBEX/issues/1515/events","html_url":"https://github.com/ISISComputingGroup/IBEX/issues/1515","id":173197327,"number":1515,"title":"Database Server: Refactor to reduce the number of connections needed","user":{"login":"KathrynBaker","id":10552381,"avatar_url":"https://avatars.githubusercontent.com/u/10552381?v=3","gravatar_id":"","url":"https://api.github.com/users/KathrynBaker","html_url":"https://github.com/KathrynBaker","followers_url":"https://api.github.com/users/KathrynBaker/followers","following_url":"https://api.github.com/users/KathrynBaker/following{/other_user}","gists_url":"https://api.github.com/users/KathrynBaker/gists{/gist_id}","starred_url":"https://api.github.com/users/KathrynBaker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KathrynBaker/subscriptions","organizations_url":"https://api.github.com/users/KathrynBaker/orgs","repos_url":"https://api.github.com/users/KathrynBaker/repos","events_url":"https://api.github.com/users/KathrynBaker/events{/privacy}","received_events_url":"https://api.github.com/users/KathrynBaker/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ISISComputingGroup/IBEX/labels/3","name":"3","color":"fbca04"},{"url":"https://api.github.com/repos/ISISComputingGroup/IBEX/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-25T13:04:18Z","updated_at":"2016-09-01T15:28:28Z","closed_at":null,"body":"In database_server.py there are a number of queries related to interesting PVs active PVs and IOC pvs, which causes a large number of connections to be opened. IT should be possible to refactor the code to open one connection do the work and then close it, or to filter the information in python as part of the dataabse server rather than using SQL queries.\r\n\r\n\r\nCheck the Experimental Details Database isn't doing anything silly either."},"comment":{"url":"https://api.github.com/repos/ISISComputingGroup/IBEX/issues/comments/244116151","html_url":"https://github.com/ISISComputingGroup/IBEX/issues/1515#issuecomment-244116151","issue_url":"https://api.github.com/repos/ISISComputingGroup/IBEX/issues/1515","id":244116151,"user":{"login":"KathrynBaker","id":10552381,"avatar_url":"https://avatars.githubusercontent.com/u/10552381?v=3","gravatar_id":"","url":"https://api.github.com/users/KathrynBaker","html_url":"https://github.com/KathrynBaker","followers_url":"https://api.github.com/users/KathrynBaker/followers","following_url":"https://api.github.com/users/KathrynBaker/following{/other_user}","gists_url":"https://api.github.com/users/KathrynBaker/gists{/gist_id}","starred_url":"https://api.github.com/users/KathrynBaker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KathrynBaker/subscriptions","organizations_url":"https://api.github.com/users/KathrynBaker/orgs","repos_url":"https://api.github.com/users/KathrynBaker/repos","events_url":"https://api.github.com/users/KathrynBaker/events{/privacy}","received_events_url":"https://api.github.com/users/KathrynBaker/received_events","type":"User","site_admin":false},"created_at":"2016-09-01T15:28:28Z","updated_at":"2016-09-01T15:28:28Z","body":"Increased to 3 to allow for more thorough regression testing"}}
{"actor":{"display_login":"KathrynBaker"}}