Skip to content

0.7.0

Choose a tag to compare

View all tags
@klinux klinux released this 18 Sep 13:54
· 20 commits to main since this release
v0.7.0
7d3b092

Seed a MySQL datasource from its schema

Seeding from the schema (Operations → Seed from schemas) was PostgreSQL only. The same plan, panel and job now run on MySQL:

  • The catalog comes from information_schema, MySQL's types mapped onto the generators (tinyint(1)/bit(1) as booleans, DATETIME as a Date, ENUM and SET labels, AUTO_INCREMENT as the identity; a generated column is never written nor copied).
  • What MySQL has no spelling for is done another way: no RETURNING, so a batch's numbered keys are read back; no TRUNCATE CASCADE, so the tables are emptied with DELETE children first and the counters reset; ? binds and a bounded IN list for a copied sample.
  • The schema is the datasource's own database unless named; a sample is copied from a datasource of the same engine only.
  • The Seed tab now says which reason keeps a datasource out (the engine, or production).

Not verified against a live MySQL yet.

Image: ghcr.io/klinux/dbportal:0.7.0 · chart 0.1.29.

Assets 2
Loading