{"action":"created","issue":{"url":"https://api.github.com/repos/desihub/desitarget/issues/53","repository_url":"https://api.github.com/repos/desihub/desitarget","labels_url":"https://api.github.com/repos/desihub/desitarget/issues/53/labels{/name}","comments_url":"https://api.github.com/repos/desihub/desitarget/issues/53/comments","events_url":"https://api.github.com/repos/desihub/desitarget/issues/53/events","html_url":"https://github.com/desihub/desitarget/pull/53","id":164879887,"number":53,"title":"DR2 Tractor Catalogues psql tables and load scripts","user":{"login":"kaylanb","id":5062170,"avatar_url":"https://avatars.githubusercontent.com/u/5062170?v=3","gravatar_id":"","url":"https://api.github.com/users/kaylanb","html_url":"https://github.com/kaylanb","followers_url":"https://api.github.com/users/kaylanb/followers","following_url":"https://api.github.com/users/kaylanb/following{/other_user}","gists_url":"https://api.github.com/users/kaylanb/gists{/gist_id}","starred_url":"https://api.github.com/users/kaylanb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kaylanb/subscriptions","organizations_url":"https://api.github.com/users/kaylanb/orgs","repos_url":"https://api.github.com/users/kaylanb/repos","events_url":"https://api.github.com/users/kaylanb/events{/privacy}","received_events_url":"https://api.github.com/users/kaylanb/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-07-11T16:32:35Z","updated_at":"2016-07-11T17:59:03Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/desihub/desitarget/pulls/53","html_url":"https://github.com/desihub/desitarget/pull/53","diff_url":"https://github.com/desihub/desitarget/pull/53.diff","patch_url":"https://github.com/desihub/desitarget/pull/53.patch"},"body":"-- Version of code and tables used to create current dr2 schema in the psql db \r\n-- Updated files in db/ and bin/ so that db/*.dr1 schemas are now db/*.dr2 schemas and bin/*.py scripts for loading to psql db use the dr2 tractor catalogue naming scheme instead of dr1."},"comment":{"url":"https://api.github.com/repos/desihub/desitarget/issues/comments/231813765","html_url":"https://github.com/desihub/desitarget/pull/53#issuecomment-231813765","issue_url":"https://api.github.com/repos/desihub/desitarget/issues/53","id":231813765,"user":{"login":"sbailey","id":218471,"avatar_url":"https://avatars.githubusercontent.com/u/218471?v=3","gravatar_id":"","url":"https://api.github.com/users/sbailey","html_url":"https://github.com/sbailey","followers_url":"https://api.github.com/users/sbailey/followers","following_url":"https://api.github.com/users/sbailey/following{/other_user}","gists_url":"https://api.github.com/users/sbailey/gists{/gist_id}","starred_url":"https://api.github.com/users/sbailey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sbailey/subscriptions","organizations_url":"https://api.github.com/users/sbailey/orgs","repos_url":"https://api.github.com/users/sbailey/repos","events_url":"https://api.github.com/users/sbailey/events{/privacy}","received_events_url":"https://api.github.com/users/sbailey/received_events","type":"User","site_admin":false},"created_at":"2016-07-11T17:59:03Z","updated_at":"2016-07-11T17:59:03Z","body":"OK, it sounds like the dr3 change is the one we really want, in particular the auto-generation of the tables instead of hardcoding everything.\r\n\r\ngit tagging: the basic idea is that you get everything into the state you want, and then you make a tag to say \"this is a reference copy that I don't want to forget about\".  ideally we would:\r\n* merge this pull request\r\n* make the tag\r\n* install that tag\r\n* use that installed copy of the code to load the database; this guarantees that the tag actually represents the version used.\r\n\r\nFor the actual mechanics of the tagging, please see https://desi.lbl.gov/trac/wiki/Computing/Software/Guidelines#CodeTags .  If something isn't clear about that, let's fix it in the documentation so that it will be clear for the next person.  That example uses versions like x.y.z .  We should make a tag like that for this code, but I wouldn't be opposed to also having a tag named \"dr2\" to be clear even though that is technically a non-standard version name.\r\n\r\nLet's go ahead and leave the .dr2 on the schema files if this is going to be the last version of those, with the dr3+ equivalents auto-generated.  If I misunderstood, we can clean up this point in a later pass.  I'll merge now and you can proceed with the tagging off of master."}}
{"actor":{"display_login":"sbailey"}}