Update Geo SSF Blob Generator script

Douglas Barbosa Alexandrerequested to merge
da-ssf-blob-generator into master

What does this MR do and why?

This code change improves a script that automatically generates database replication code for GitLab's Geo feature (which keeps multiple GitLab instances in sync).

The main improvements are:

  1. Better database indexing: Adds a new method to create unique indexes on partition tables, which helps the database find and organize data more efficiently. This is especially important for file upload tables that are split into smaller pieces (partitions).

  2. Proper timing: Ensures that database indexes are created before other database structures that depend on them, preventing potential setup errors.

  3. Bug fix: Corrects a reference to the wrong table name in foreign key relationships, ensuring data connections between tables work properly.

  4. Code cleanup: Fixes some formatting issues in the generated code to make it more readable.

These changes make the automatic code generation more reliable and ensure that the database structures created for keeping GitLab instances synchronized will work correctly, particularly when dealing with file uploads stored in partitioned tables.

References

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Douglas Barbosa Alexandre

Merge request reports