This PR:

• closes https://github.com/prisma/team-orm/issues/1062
• closes https://github.com/prisma/team-orm/issues/1063
• deprecates feat(cli): add --local-d1 #23613

In particular, it:

• adds the --from-local-d1 and --to-local-d1 boolean flags to prisma migrate diff. They locate the local Cloudflare D1 database automatically, if it exists.
• adds the --local-d1 boolean flag to prisma db pull. It locate the local Cloudflare D1 database automatically, if it exists.

  • When schema.prisma exists already, it overrides it. If the schema had no "driverAdapters" preview feature, the following warning is emitted:

    Without the driverAdapters preview feature, the schema introspected via the --local-d1 flag will not work with @prisma/client.
    

    

  • When no schema.prisma exists, it generates it in ./schema.prisma (rather than ./prisma/schema.prisma, matching the same location used by --url), including a generator client block with the "driverAdapters" preview feature.

  • An introspected datasource looks like:

    datasource db {
      provider = "sqlite"
      url      = "file:../.wrangler/state/v3/d1/miniflare-D1DatabaseObject/5d11bcce386042472d19a6a4f58e40041ebc5932c972e1449cbf404f3e3c4a7a.sqlite"
    }

• adds argument validation
• adds tests for prisma migrate diff
• adds tests for prisma db pull
• I've also manually tested this PR against a Cloudflare Worker

How is a local Cloudflare D1 database located?

Let's see an example when using migrate diff --from-local-d1:

1. Prisma looks into .wrangler/state/v3/d1/miniflare-D1DatabaseObject/<UUID>.sqlite.
2. If no .sqlite file exists, the following error is emitted:

No Cloudflare D1 databases found in .wrangler/state/v3/d1/miniflare-D1DatabaseObject/<UUID>.sqlite.
Did you run `wrangler d1 create <DATABASE_NAME>` and `wrangler dev`?

3. If multiple .sqlite files exist, the following error are emitted:

Multiple Cloudflare D1 databases found in .wrangler/state/v3/d1/miniflare-D1DatabaseObject.
Please manually specify the local D1 database with `--from-url file:`, without using the `--from-local-d1` flag.`,

This logic is shared between prisma migrate diff and prisma db pull, and lives in packages/internals/src/utils/cloudflareD1.ts.