Skip to content

Releases: memclutter/nocodb-migrator

v0.0.2 — MySQL/Postgres fix + test & CI

Choose a tag to compare

@memclutter memclutter released this 27 Jun 19:16
v0.0.2
2d56cd3

nocodb-migrate v0.0.2 hardens the tool against real-world NocoDB backends and lands a full test + CI safety net.

Fixed

  • Creating the Migrations table now succeeds on external SQL backends (MySQL, PostgreSQL). The Direction/Status SingleSelect fields are added via separate field-create calls so NocoDB materializes a valid enum(...) column instead of failing with ER_PARSE_ERROR ("There was a syntax error in your SQL query"). The underlying NocoDB bulk-create limitation is tracked upstream in nocodb/nocodb#14164. (#1)

Added

  • Unit test suite over the NocoDB API client, the Migrations storage, and the executor, driven by an in-process mock NocoDB — no live instance required.
  • Integration tests that run the real up/down command path against a dockerized NocoDB (testcontainers-go), parameterized across SQLite, MySQL, and PostgreSQL, gated behind the integration build tag and run in a separate CI job.
  • GitHub Actions CI (lint-unit: gofmt check + golangci-lint + unit tests) with a committed .golangci.yml, and a pre-commit configuration.

Changed

  • Relicensed from GPL-3.0 to the MIT License.
  • Reworked README.md: status badges, quick-start, operations table, tightened reference sections.

Full changelog: v0.0.1...v0.0.2

v0.0.1 — first release: NocoDB migration CLI

Choose a tag to compare

@memclutter memclutter released this 27 Jun 10:25

First release of nocodb-migrate — a command-line migration tool for NocoDB,
driving schema and data changes against a base through its Meta API v3.

Features

  • create <name> scaffolds a timestamped *.up.json / *.down.json migration
    file pair in the migrations directory.
  • up [count] applies pending migrations in ascending timestamp order; down [count] rolls them back newest-first; info reports the current version and
    recorded history.
  • Eight migration operation types: create_table, alter_table, drop_table,
    create_field, alter_field, drop_field, insert_row, delete_row, with
    up-front JSON validation of operations and column types.
  • Applied migrations are tracked in a Migrations table the tool creates inside
    the target base — no external state store.
  • Environment-based configuration (NOCODB_URL, NOCODB_API_TOKEN,
    NOCODB_BASE_ID, optional NOCODB_MIGRATIONS_DIR), with .env support.

Built in Go (cobra CLI, go-resty client). This is a v0.x release: the API and
migration format may change in any release before v1.0.0.