Reylo v0.8.2 prints analyses as JSON and TypeScript, adds Rollup and Rolldown entry points, and types MySQL columns through WITH queries.
Three changes can surface in an existing project, listed in Upgrading from v0.8.1.
JSON and TypeScript from reylo analyze
The reylo analyze command now prints JSON by default, and TypeScript with --format typescript (#365).
$ reylo analyze queries/get_user.sql --format typescript
type Params = { id: number | bigint | string };
type Returns = {
id: bigint;
email: string;
/** Shown on the profile page */
bio: string | null;
} | null;
What it prints:
- In a terminal: indented JSON, each object on one line where it fits in 80 columns
- Piped: one line of JSON per statement
- TypeScript: each statement's
Paramsand what.run()resolves to, its cardinality applied - YAML: the output v0.8.1 printed, with
--format yaml - One file: its result alone, with the
filekey only when the command reads several (#350)
Rollup and Rolldown
Reylo's plugin now has an entry point for each, reylo/rollup and reylo/rolldown (#353, fixes #296).
import { defineConfig } from "rolldown";
import reylo from "reylo/rolldown";
export default defineConfig({
input: "src/server.ts",
platform: "node",
plugins: [reylo()],
});Replaced columns in migrations
A migration that can't tell renames from new columns now lists each column with its own flags (#324). Any mix of renames and drops can be picked, where it offered all renames or all drops.
$ reylo migrate new tidy_columns
✗ This migration can't tell renames from new columns
posts.title → heading varchar(100) → varchar(200)
users.bio → about varchar(200) → text
For each, rename to keep its rows, or drop it:
--rename posts.title=heading or --drop posts.title
--rename users.bio=about or --drop users.bio
Add the flags you picked to:
reylo migrate new tidy_columns
A column replaced by one of another kind of type, such as text to a date, is now asked about the same way. It was a refusal to drop it, with a placeholder for the new name.
MySQL types through WITH queries
MySQL columns now keep their types through WITH queries, derived tables and UNIONs (#339).
with recursive nums (n) as (
select 1 union all select n + 1 from nums where n < 5
)
select n from numsWhat it infers:
- Recursive WITH queries: a column that no query of the WITH makes NULL is never null, as
nabove, where every column was nullable - ENUM labels: an ENUM column read through a WITH query, a derived table or a UNION is typed as its labels, such as
"admin" | "member", where it wasstring
Faster Postgres analysis
Each connection now prepares a catalog query once, where each analysis prepared it again (#297). Over 200 statements on a server 20 ms away:
- 40 tables: 13.4 s → 9.3 s
- 200 tables: 25.1 s → 17.3 s
Upgrading from v0.8.1
Each change below can surface in a project that upgrades from v0.8.1.
Every dialect
- The
reylo analyzecommand prints JSON, where it printed YAML. Pass--format yamlwhere a script reads the old output (#365). - A one-file run of
reylo analyzehas nofilekey. Read the file's name from the command line, which names it (#350).
MySQL
- An ENUM column read through a WITH query, a derived table or a UNION is typed as its labels, where it was
string. Handle the labels where the type check now asks. A row holding MySQL's''error value there now throws in.run(), as it does for a plain ENUM column (#339).
What's Changed
- fix(mysql): type recursive with columns and labels through queries by @colinhacks in #339
- ci(release): keep docs fixes on reylo.dev across a release by @colinhacks in #348
- feat(cli)!: name the file only when reylo analyze reads several by @colinhacks in #350
- feat: add reylo/rollup and reylo/rolldown entry points by @colinhacks in #353
- feat(cli): ask about each replaced column with its own flags by @colinhacks in #324
- feat(engine): repair syntax errors in place and list what would fit by @colinhacks in #354
- feat(cli)!: print reylo analyze as json, add typescript and rust formats by @colinhacks in #365
- feat(postgres): read PL/pgSQL bodies into PL/pgSQL's own tree by @colinhacks in #366
- fix(cli): order schema keys as javascript does in --format typescript by @colinhacks in #367
- perf(postgres): prepare each catalog query once per connection by @hood in #297
- docs: show each refusal as the cli prints it by @colinhacks in #368
- chore(release): 0.8.2 by @colinhacks in #369
New Contributors
Full Changelog: v0.8.1...v0.8.2