Skip to content

Add declarative SDL workflow for MySQL - #64

Closed
adela-bytebase wants to merge 235 commits into
bytebase:mainfrom
adela-bytebase:add-mysql-sdl-workflow
Closed

Add declarative SDL workflow for MySQL#64
adela-bytebase wants to merge 235 commits into
bytebase:mainfrom
adela-bytebase:add-mysql-sdl-workflow

Conversation

@adela-bytebase

Copy link
Copy Markdown
Contributor

Summary

  • Add schema-mysql/schema.sql with a starter MySQL DDL schema (employee, department)
  • Add declarative-release-action-mysql.yml: build → create-rollout → test (auto) → prod (manual approval), triggered on push to main touching schema-mysql/*.sql
  • Add declarative-sql-review-action-mysql.yml: PR check against proddb, reusing .bytebase/sql-review.md

Mirrors the existing Postgres declarative pipeline (declarative-release-action.yml / declarative-sql-review-action.yml), targeting projects/mysql-project, instance mysql-test-instance-05k8, databases testdb/proddb.

Test plan

  • PR check workflow runs and comments on this PR
  • Merge to main and confirm the rollout workflow creates a plan and deploys to testdb
  • Approve the prod environment gate and confirm deploy to proddb

Replaced 'name' column with 'username' in table t0.
Create initial database schema with tables and triggers
Removed the 't0' table definition from the schema.
Create table 't1' with id and username columns
Create table 't0' with id and username columns
Create table t2 with id and username columns
Created a new table 't2' with an 'id' and 'username' column.
Create table t2 with id and username columns
Changed 'username' column to allow NULL values.
Modify 'username' column to allow NULL values
Create table t2 with id and username columns
Create table t2 with id and username columns
Mirrors the existing Postgres declarative pipeline against the new
mysql-project / mysql-test-instance-05k8 (testdb, proddb) for testing
the SDL feature on MySQL.
@adela-bytebase

Copy link
Copy Markdown
Contributor Author

Opened against the wrong repo by mistake (meant to target my fork, not upstream). Closing — see adela-bytebase/example-gitops-github-flow instead.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant