{"action":"closed","issue":{"url":"https://api.github.com/repos/BOINC/boinc-ng/issues/692","labels_url":"https://api.github.com/repos/BOINC/boinc-ng/issues/692/labels{/name}","comments_url":"https://api.github.com/repos/BOINC/boinc-ng/issues/692/comments","events_url":"https://api.github.com/repos/BOINC/boinc-ng/issues/692/events","html_url":"https://github.com/BOINC/boinc-ng/issues/692","id":56467644,"number":692,"title":"Keeping track of applied database updates","user":{"login":"romw","id":985772,"avatar_url":"https://avatars.githubusercontent.com/u/985772?v=3","gravatar_id":"","url":"https://api.github.com/users/romw","html_url":"https://github.com/romw","followers_url":"https://api.github.com/users/romw/followers","following_url":"https://api.github.com/users/romw/following{/other_user}","gists_url":"https://api.github.com/users/romw/gists{/gist_id}","starred_url":"https://api.github.com/users/romw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/romw/subscriptions","organizations_url":"https://api.github.com/users/romw/orgs","repos_url":"https://api.github.com/users/romw/repos","events_url":"https://api.github.com/users/romw/events{/privacy}","received_events_url":"https://api.github.com/users/romw/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/BOINC/boinc-ng/labels/C:%20Server%20-%20Other","name":"C: Server - Other","color":"0000aa"},{"url":"https://api.github.com/repos/BOINC/boinc-ng/labels/P:%20Undetermined","name":"P: Undetermined","color":"aa8888"},{"url":"https://api.github.com/repos/BOINC/boinc-ng/labels/R:%20fixed","name":"R: fixed","color":"55ff55"},{"url":"https://api.github.com/repos/BOINC/boinc-ng/labels/T:%20Task","name":"T: Task","color":"cccccc"}],"state":"closed","locked":false,"assignee":{"login":"davidpanderson","id":985729,"avatar_url":"https://avatars.githubusercontent.com/u/985729?v=3","gravatar_id":"","url":"https://api.github.com/users/davidpanderson","html_url":"https://github.com/davidpanderson","followers_url":"https://api.github.com/users/davidpanderson/followers","following_url":"https://api.github.com/users/davidpanderson/following{/other_user}","gists_url":"https://api.github.com/users/davidpanderson/gists{/gist_id}","starred_url":"https://api.github.com/users/davidpanderson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidpanderson/subscriptions","organizations_url":"https://api.github.com/users/davidpanderson/orgs","repos_url":"https://api.github.com/users/davidpanderson/repos","events_url":"https://api.github.com/users/davidpanderson/events{/privacy}","received_events_url":"https://api.github.com/users/davidpanderson/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/BOINC/boinc-ng/milestones/3","labels_url":"https://api.github.com/repos/BOINC/boinc-ng/milestones/3/labels","id":964209,"number":3,"title":"Undetermined","description":"Features for this release:\r\n\r\n * WIN: Streamline installer for mass deployments using either Installshield or WiX\r\n","creator":{"login":"romw","id":985772,"avatar_url":"https://avatars.githubusercontent.com/u/985772?v=3","gravatar_id":"","url":"https://api.github.com/users/romw","html_url":"https://github.com/romw","followers_url":"https://api.github.com/users/romw/followers","following_url":"https://api.github.com/users/romw/following{/other_user}","gists_url":"https://api.github.com/users/romw/gists{/gist_id}","starred_url":"https://api.github.com/users/romw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/romw/subscriptions","organizations_url":"https://api.github.com/users/romw/orgs","repos_url":"https://api.github.com/users/romw/repos","events_url":"https://api.github.com/users/romw/events{/privacy}","received_events_url":"https://api.github.com/users/romw/received_events","type":"User","site_admin":false},"open_issues":95,"closed_issues":440,"state":"open","created_at":"2015-02-03T19:47:35Z","updated_at":"2015-02-04T01:37:28Z","due_on":"1970-01-01T00:00:00Z","closed_at":null},"comments":0,"created_at":"2015-02-04T01:37:17Z","updated_at":"2015-02-04T01:37:28Z","closed_at":"2015-02-04T01:37:28Z","body":"**Reported by Eric Myers on 3 Jan 38600899 16:53 UTC**\nI suspect many projects don't upgrade because it is not easy to do, and one thing that takes time and attention is doing the database updates.  You have to sort out by hand which ones you've already applied and only apply the new ones.  It would be very useful if a log was kept of which updates had been applied.  Even better, when running the update script have it check this log and decline to apply the updates which have already been applied. \r\n\r\nThe attached file, db_update_util.php, contains a modified version of the do_query() function which does all that.  It can handle updates which consist of more than one mySQL request.  The log file db_update.log is kept in the project log directory, and while the lines written to it by do_query() have a timestamp, one can also add lines by hand with just the names of previously applied updates."}}