On Tue, 3 Mar 2015 07:17:31 -0800 (PST)
Michael Sheaver <mshea...@me.com> 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 git-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to