...

1. Get the latest version for the code
   1. "git clone" (the first time)
   2. or "git pull" if your local repository already exist
2. change to the correct branch
   1. "git checkout branch_name"
3. create files in the correct subdirectories (you may have to create the subdirectory first) as required
4. add the files to your upcoming commit with: "git add <filename> ..." or "git add ." to commit the whole current directory and its children.
5. Commit the files you have added with :
   git commit -m "Commit message" 
   if the commit message contains some text between square bracket like "Create employee table [JIRA-1234]", a "label" will be automatically created by DaticalDB during the deployer phase. This allows you to add additional label for specific jira, feature, story, ... for a more granular deployment process
6. if you need to insert some kind of orders to process you files (i.e. CREATE the table before the ALTER statement), you can split you git add and git commit as in
   1. git add createEmployeeTable.sql
   2. git commit -m "Create employee table"
   3. git add AlterEmployeeTable.sql
   4. git commit -m "Add a column to the employee table [JIRA-2345]"
7. Push your changes to the git server so the packager (and your colleagues) can have access to the changes:
   1. git push 

TFS

Build Systems

You will find below more specific instructions on how to setup your packager job in each major build system, if yours is not explicitely explained below, feel free to use those instructions to create your own process or contact us to get some help from a team of seasoned professionals.

Jenkins

Those instructions are based on GitHub.com server and a Linux environment.

We use the 2017-july branch for the SQL repo

Source Code Management

We usually set up our build to be a multiple SCMs one. TO avoid to have to deal with passwords (you need to be sure you will not be queried for password or it will hung the job), we simply use the SSK key mechanism provided by GitHub.

We also use 2 additional behaviors for that step:

1. check out to a sub-directory: portal_sql
2. Check out to specific local branch: 2017-2017

That step should look like:

Image Added

IBM uBuild

Atlassian Bamboo

...