dafky2000 | NonFungible.com Comments

dafky2000 | NonFungible.com

•Created by dafky2000 | NonFungible.com on 11/19/2024 in #help

malformed array literal when trying to insert a 2d array of strings

Ended up (temporarily) solving this by manually creating the sql array and inserting that. I don't think this is a permanent solution because it opens up sql-injection risks. Hopefully it might help someone else with a temporary solution.

const sqlFrom2DArray = (arr: string[][]) => {
  return arr
    ? sql`array[${sql.join(
      arr.map((item) => sql.raw(`'${item}'`)),
      sql`, `
    )}]`
  : null;
}

const sqlFrom2DArray = (arr: string[][]) => {
  return arr
    ? sql`array[${sql.join(
      arr.map((item) => sql.raw(`'${item}'`)),
      sql`, `
    )}]`
  : null;
}

4 replies

DTDrizzle Team

•Created by dafky2000 | NonFungible.com on 11/19/2024 in #help

malformed array literal when trying to insert a 2d array of strings

And... It's on a postgresql db using import { drizzle } from "drizzle-orm/node-postgres";

4 replies

DTDrizzle Team

•Created by dafky2000 | NonFungible.com on 11/19/2024 in #help

malformed array literal when trying to insert a 2d array of strings

"drizzle-kit": "^0.28.1", "drizzle-orm": "^0.36.3"

4 replies

Gaming

Programming