On Tue, 3 Mar 2015 07:17:31 -0800 (PST) Michael Sheaver <[email protected]> wrote:
> I am using MySQL on my local Windows laptop to compile data and > produce reports for my enterprise related to PIV issuance. [...] > The challenge that I have is that although all of these scripts > loosely relate to the PIV project, but pretty much stand on their own > for each function. I would like to be able to use tags to monitor > version numbers for each of the scripts ( 1.0, 1.1, 1.2, 2.0, and so > on). In order to do this, do I need to create a separate repository > for each script? If so, that would seem to be a lot of extra work. > > Can anyone suggest a workflow that will help me to monitor and track > version numbers for each script separately? I would keep things as simple as possible and just do this: 1) Turn your folder into a Git repo (`git init .`). 2) Add all your scripts into it and record the first commit; mention current version of each script in the extended part of the commit message. When a new version of a particular script appears, update the appropriate file in your folder to match it, `git add` that script file solely and record a new commit. You will then be able to see the history of changes of a particular script file by using git log -- scriptFileName.sql There is no tags in my simplistic picture, but I'd just record version of the script file recorded in a commit using its version number in the commit message -- you will see them in the `git log` output and will be able to use git-log's search facilities to search for a particular version (present in the commit message). You can still use tags with this approach -- just devise proper "namespacing" for your tag -- for instance, put the base name of a script file (without the extension) into tags related to that script file, and then tag each commit recording a new version of that file with such a tag -- say, if you've just recorded version 3.2 of mumboJumbo.sql, tag it using "mumboJumbo-v3.5". If you feel extravagant, you can even not use branches at all, just shovel new versions of your script files into the repo using the standard if lesser known git hash-object -w myScript.sql and then tag whatever SHA-1 hash it printed out using the naming scheme outlined above. You will then only have tagged blobs and no history at all (it will be implicitly encoded in the tag names). I'd still prefer a single branch and may be tags on its commits. > I have posted this same question on > StackOverflow: > http://stackoverflow.com/questions/28833957/git-workflow-with-mysql-scripts Thanks for mentioning -- this level of netiquette is rare these days ;-) -- You received this message because you are subscribed to the Google Groups "Git for human beings" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
