database-build

Build tooling for PostgreSQL database projects.

Build script

Reproducible builds — git hashes and uncommitted state

When using Build.rb directly, a database is not 100% reproducible (uncommitted changes). As a first step, the build can store the git hashes of all common module repositories and whether there were uncommitted changes.

When your runscript calls add_build_constants, the build stores:

• CURRENT_BUILD_COMMON_MODULE_REPO_HASHES — A JSON string with one entry per common module repository (from $common_sql_paths / $common_data_paths). Each entry has repo_url, commit_hash, sql_paths (array), data_paths (array), and had_uncommitted_changes. A repository can have multiple paths, so the path arrays can have more than one element. Paths are relative to the git repository root, not to the project settings file.

• CURRENT_BUILD_SCRIPT_HAD_UNCOMMITTED_CHANGES — 'true' if the product sql path repository, product data path repository, or any common module repository had uncommitted or untracked changes; 'false' otherwise.

Example JSON stored in CURRENT_BUILD_COMMON_MODULE_REPO_HASHES:

{
  "common_module_repos": [
    {
      "repo_url": "https://github.com/org/database-modules.git",
      "commit_hash": "k1l2m3n4o5...",
      "sql_paths": ["source/modules/src/main/sql/"],
      "data_paths": ["source/modules/src/data/sql/"],
      "had_uncommitted_changes": false
    }
  ]
}

Common database modules

README.md