Uploaded image for project: 'Gazelle Security Suite'
  1. Gazelle Security Suite
  2. GSS-317

Safer update SQL process

    Details

    • Type: Story
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 5.1.0
    • Component/s: None
    • Labels:
      None
    • Sprint:
      2016 - S4
    • Account:
      Maintenance 2016 (MAINTENANCE2016)

      Description

      The SQL update process is dangerous, the ear should not have responsibility of creating DB elements. Every schema or data transformations on the database should be the responsibility of the SQL scripts only.

      We should have for each ear version :
      - One SQL schema script to create database.
      - The exhaustive list of migration SQL scripts (tagged with their ear version), to migrate already existing databases.

      The installation (from scratch) process will be :
      1. Create database
      2. Execute the schema SQL script to build tables and relations
      3. deploy ear

      The update process will be :
      1. execute all the update SQL script between the current version and the target version.
      2. deploy ear of the target version.

      For each ear release, the developer must :
      1. Create the migration SQL script for this ear version (if necessary).
      2. If a migration SQL is required, the schema must be updated. To do so : create db with previous schema (n-1) ; execute migration ; dump the new schema (n).

        BigPicture - Work Breakdown Structure

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                ceoche Cédric EOCHE-DUVAL
                Reporter:
                ceoche Cédric EOCHE-DUVAL
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  BigPicture - Skills

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - 1 day
                      1d
                      Remaining:
                      Time Spent - 7 hours Remaining Estimate - 1 hour
                      1h
                      Logged:
                      Time Spent - 7 hours Remaining Estimate - 1 hour
                      7h

                        Potential Duplicates