getting weird module issue

[statusunknown418]

trying to generate the dbml using default configurations throws this error

SyntaxError: Cannot use import statement outside a module

[L-Mario564]

Seems like an ESM/CJS related error. Can you share a snippet of your code?

[statusunknown418]

I'm using the one from the example:

import { mysqlGenerate } from "drizzle-dbml-generator";
import * as schema from "./src/lib/db/schema";

const out = "./schema.dbml";
const relational = true;

mysqlGenerate({ schema, out, relational });

[L-Mario564]

Try setting (or adding) the type property in package.json to module. So:

{
  // ...
  "type": "module"
  // ...
}

You can also try using CJS' require syntax instead. Don't recommend it personally but you could try.
If none of this works, try investigating more about the error elsewhere as well, as the error isn't one that's specific to this package.

[statusunknown418]

Problem is that setting module makes nextjs not work at all, actually did that but needed to keep switching the package.json everytime lol

[L-Mario564]

You might be forced to use CJS syntax then, which this package should support.

[stromseng]

Having the same issue, I can't convert my entire project to use require().

[stromseng]

I fixed this by using tsx instead of ts-node.
so simply "generate-dbml": "tsx dbml.ts",