pnpm dlx sv@latest add drizzle reports an error on new project

[totemcaf]

I wanted to perform a setup of a Svelte Kit project in non-interactive way.

I installed Svelte Kit with:

pnpm dlx sv@latest create --template minimal --types ts --no-add-ons --install pnpm $NAME

The I tried to install the drizzle add-on

pnpm dlx sv@latest add --no-git-check --install pnpm drizzle=database:postgresql+client:postgres.js+docker

and it reported:

┌  Welcome to the Svelte CLI! (v0.9.2)
│
■  Error: Unable to process 'src/lib/server/db/index.ts'. Reason: unreachable state...
│      at Object.file (file:///home/charly/.cache/pnpm/dlx/4606e059aa0298da97dee039e2d80711d61420ed6c469b7c1bd1e9da56666de4/198fc349f19-16444b/node_modules/.pnpm/sv@0.9.2/node_modules/sv/dist/addons-Ck_pRCRU.js:1139:35)
│      at Object.run (file:///home/charly/.cache/pnpm/dlx/4606e059aa0298da97dee039e2d80711d61420ed6c469b7c1bd1e9da56666de4/198fc349f19-16444b/node_modules/.pnpm/sv@0.9.2/node_modules/sv/dist/addons-Ck_pRCRU.js:3026:6)
│      at runAddon (file:///home/charly/.cache/pnpm/dlx/4606e059aa0298da97dee039e2d80711d61420ed6c469b7c1bd1e9da56666de4/198fc349f19-16444b/node_modules/.pnpm/sv@0.9.2/node_modules/sv/dist/addons-Ck_pRCRU.js:1180:14)
│      at applyAddons (file:///home/charly/.cache/pnpm/dlx/4606e059aa0298da97dee039e2d80711d61420ed6c469b7c1bd1e9da56666de4/198fc349f19-16444b/node_modules/.pnpm/sv@0.9.2/node_modules/sv/dist/addons-Ck_pRCRU.js:1090:50)
│      at async runAddCommand (file:///home/charly/.cache/pnpm/dlx/4606e059aa0298da97dee039e2d80711d61420ed6c469b7c1bd1e9da56666de4/198fc349f19-16444b/node_modules/.pnpm/sv@0.9.2/node_modules/sv/dist/bin.js:1079:79)
│      at async file:///home/charly/.cache/pnpm/dlx/4606e059aa0298da97dee039e2d80711d61420ed6c469b7c1bd1e9da56666de4/198fc349f19-16444b/node_modules/.pnpm/sv@0.9.2/node_modules/sv/dist/bin.js:843:25
│      at async runCommand (file:///home/charly/.cache/pnpm/dlx/4606e059aa0298da97dee039e2d80711d61420ed6c469b7c1bd1e9da56666de4/198fc349f19-16444b/node_modules/.pnpm/sv@0.9.2/node_modules/sv/dist/bin.js:568:3)
│
└  Operation failed.

I tried adding the folder src/lib/server/db, no change.

I tried adding an empty src/lib/server/db/index.ts file, the add-on refuse to install because:

 Welcome to the Svelte CLI! (v0.9.2)
│
■  Unsupported Environment
│
│    drizzle  Preexisting database file at 'src/lib/server/db/index.ts'
│
└  Operation failed.

If I run it without options, selecting interactively the same values, it runs OK.

[totemcaf]

.env file content is (after run):

# Replace with your DB credentials!
DATABASE_URL="postgres://user:password@host:port/db-name"

File src/lib/server/db/schema.ts content is:

import { pgTable, serial, integer } from 'drizzle-orm/pg-core';

export const user = pgTable('user', {
	id: serial('id').primaryKey(),
	age: integer('age')
});

[totemcaf]

Solved !!

The problem was missing quotes in command.

Using following command it worked correctly.

pnpm dlx sv@latest add --no-git-check --install pnpm \
    drizzle="database:postgresql+client:postgres.js+docker:yes"

I will add a PR to improve documentation examples.

[jycouet]

That was fast, thx for the update.

Out of curiosity, what's your OS ? Shell ?
Improvements on doc is always good, and maybe in parallel we can improve the error message or arg detection ?

[totemcaf]

@jycouet I was using Ubuntu Linux with bash.

Linux 5.15.0-152-generic.

When I have time I will debug into the parsing function to see where the exact problem is, and I'll try to improve error message.

[jycouet]

I found!

// error
pnpm dlx sv@latest add --no-git-check --install pnpm drizzle=database:postgresql+client:postgres.js+docker

// no error
pnpm dlx sv@latest add --no-git-check --install pnpm drizzle=database:postgresql+client:postgres.js+docker:yes

The CLI should probably warn that this is not valid as you did provide a key but not the value.
I'm looking at fixing this ATM, but I'm not sure how fare I'll go. Let me know if you wanna do it :)