How do I create CLI script that is able to use '$env/static/private?

[mrceperka]

I have a script src/lib/db/sync.ts.

// getRaids uses $env/static/private
import { getRaids } from '../api';
import { db } from './index';
import { bossTable } from './schema/boss.schema';
import { raidTable } from './schema/raid.schema';

const main = async () => {
	const raids = await getRaids();
	for (const raid of raids) {
		await db
			.insert(raidTable)
			.values([{ name: raid.map }])
			.execute();
		for (const boss of raid.bosses) {
			await db.insert(bossTable).values({ entry: boss.entry, name: boss.name }).execute();
		}
	}
};
main();

I run this script with like this node --loader esbuild-register/loader -r esbuild-register --no-warnings ./src/lib/server/db/synchronize-with-api.ts but I got this error

Error: Cannot find module '$env/static/private'

Is there any way around this? I just want to run simple CLI script

[kevbook]

You probably need to use vite to run the script

[mrceperka]

Yeah, but I did not now how exactly one can do it :D

[danielres]

I've used vite-node successfully in the past.
https://github.com/vitest-dev/vitest/tree/main/packages/vite-node#readme

[danielres]

Here for example: https://github.com/danielres/pixel-avatar-editor/blob/v2-save-and-dl/package.json#L16

[mrceperka]

I will give it a try, this sounds very good. Thanks 🙏

[mrceperka]

@danielres any idea how do I convince sveltekit that I am runnig this on server? vite-node script-that-import-from-private-env.ts gives me this error:

Error: Cannot import $env/static/private into client-side code

I was able to overcome this with TEST=true env variable (https://kit.svelte.dev/docs/server-only-modules#further-reading) but I do not like it at all :D

[danielres]

if you want access an environment variable on the frontend side, you have to:

1. prefix its name with PUBLIC_
2. access it through $env/static/public

This is to ensure you don't leak any sensitive env var to the frontend accidentally.

[david-plugge]

#10985 (reply in thread)