Emerson Posts - Answer Overflow

Emerson

Posts Comments

DTDrizzle Team

•Created by Emerson on 11/18/2023 in #help

Error when running Migrate on inngest function

1 replies

DTDrizzle Team

•Created by Emerson on 11/13/2023 in #help

Error Parse BigInt

When I've a blob big int column and I try to select or returning the data, my bun execution is terminated because the parsing is crashed. https://github.com/emersonlaurentino/drizzle-bigint

1 replies

DTDrizzle Team

•Created by Emerson on 11/10/2023 in #help

error with ILIKE on libsql

I'm trying to use ILIKE clause on libsql and I receive a error. Repository to reproduce the error: https://github.com/emersonlaurentino/libsql-ilike-error

4 replies

DTDrizzle Team

•Created by Emerson on 11/10/2023 in #help

Dynamic query building

2 replies

DTDrizzle Team

•Created by Emerson on 11/8/2023 in #help

error on push on local libsql

I'm trying to use libsql locally, so i configure my drizzle.config.ts and when i try to run the push command i receive this error

Error: Could not locate the bindings file. Tried:
 → .../node_modules/better-sqlite3/build/better_sqlite3.node

Error: Could not locate the bindings file. Tried:
 → .../node_modules/better-sqlite3/build/better_sqlite3.node

I'm not using better_sqlite3 this is my config

import type { Config } from "drizzle-kit";

const dbCredentials = {
  url: "file:local.db",
};

export default {
  schema: "./src/db/schema.ts",
  driver: "turso",
  dbCredentials,
  verbose: true,
  strict: true,
} satisfies Config;

import type { Config } from "drizzle-kit";

const dbCredentials = {
  url: "file:local.db",
};

export default {
  schema: "./src/db/schema.ts",
  driver: "turso",
  dbCredentials,
  verbose: true,
  strict: true,
} satisfies Config;

1 replies

DTDrizzle Team

•Created by Emerson on 11/8/2023 in #help

SQL string does not contain any statement

I currently have 1 sqliteTable on my schema and 1 migration, so I wan't to create a new table and migration. When I run the drizzle-kit generate:sqlite command, all works well, but when I run the migrate... one error heppens: LibsqlError: SQL_NO_STATEMENT: SQL string does not contain any statement this is my migrate.ts file

import { migrate } from "drizzle-orm/libsql/migrator";
import { db } from "../lib/db";

async function main() {
  try {
    await migrate(db, { migrationsFolder: "src/drizzle/migrations" });
    console.log("Tables migrated!");
    process.exit(0);
  } catch (error) {
    console.error("Error performing migration: ", error);
    process.exit(1);
  }
}

main();

import { migrate } from "drizzle-orm/libsql/migrator";
import { db } from "../lib/db";

async function main() {
  try {
    await migrate(db, { migrationsFolder: "src/drizzle/migrations" });
    console.log("Tables migrated!");
    process.exit(0);
  } catch (error) {
    console.error("Error performing migration: ", error);
    process.exit(1);
  }
}

main();

3 replies

Gaming

Programming