Meexa Comments - Answer Overflow

Meexa

Explore posts from servers

RRailway TTCTheo's Typesafe Cult HHono DTDrizzle Team

Posts Comments

DTDrizzle Team

•Created by Meexa on 8/24/2024 in #help

Providing optional columns to insert query results in type error

Yep that was it, thanks @Darren 🙌

12 replies

DTDrizzle Team

•Created by Meexa on 8/24/2024 in #help

Providing optional columns to insert query results in type error

That might be it actually 😅 can’t try until tomorrow but this project was setup from scratch instead of my regular nextjs setup, so the tsconfig might be missing some things

12 replies

DTDrizzle Team

•Created by Meexa on 8/24/2024 in #help

Providing optional columns to insert query results in type error

12 replies

DTDrizzle Team

•Created by Meexa on 8/24/2024 in #help

Providing optional columns to insert query results in type error

12 replies

DTDrizzle Team

•Created by Meexa on 8/24/2024 in #help

Providing optional columns to insert query results in type error

12 replies

DTDrizzle Team

•Created by Meexa on 8/24/2024 in #help

Providing optional columns to insert query results in type error

I renamed the variable to teamTable to make sure it's the table from the schema and removed the capital T from the table name. Still doesn't allow me to pass creatorId

export const teamTable = pgTable(
  'team',
  {
    id: bigint('id', { mode: 'number' }).primaryKey().generatedByDefaultAsIdentity(),
    creatorId: uuid('creator_id'),
    createdAt: timestamp('created_at')
      .defaultNow()
      .notNull(),
    updatedAt: timestamp('updated_at')
      .defaultNow()
      .notNull(),
    deletedAt: timestamp('deleted_at'),
  },
);

export const teamTable = pgTable(
  'team',
  {
    id: bigint('id', { mode: 'number' }).primaryKey().generatedByDefaultAsIdentity(),
    creatorId: uuid('creator_id'),
    createdAt: timestamp('created_at')
      .defaultNow()
      .notNull(),
    updatedAt: timestamp('updated_at')
      .defaultNow()
      .notNull(),
    deletedAt: timestamp('deleted_at'),
  },
);

12 replies

DTDrizzle Team

•Created by Meexa on 8/24/2024 in #help

Providing optional columns to insert query results in type error

Sorry for bumping. Do I need to provide more context for this problem? What would help?

12 replies

DTDrizzle Team

•Created by Meexa on 8/24/2024 in #help

Providing optional columns to insert query results in type error

It does work though, it's only typescript that doesn't like it

12 replies

DTDrizzle Team

•Created by Meexa on 1/9/2024 in #help

Error: Cannot open database because the directory does not exist

Updated my setup and now it works.

import { defineConfig } from 'drizzle-kit';

export default defineConfig({
  schema: './src/db/schema.ts',
  driver: 'better-sqlite',
  dbCredentials: {
    url: './sqlite.db',
  },
  verbose: true,
  strict: true,
  out: 'drizzle',
});

import { defineConfig } from 'drizzle-kit';

export default defineConfig({
  schema: './src/db/schema.ts',
  driver: 'better-sqlite',
  dbCredentials: {
    url: './sqlite.db',
  },
  verbose: true,
  strict: true,
  out: 'drizzle',
});

import { createClient } from '@libsql/client';
import { drizzle } from 'drizzle-orm/libsql';
import { migrate } from 'drizzle-orm/libsql/migrator';

import * as schema from './schema';

export const db = drizzle(createClient({ url: 'file:./sqlite.db' }), { schema });

migrate(db, { migrationsFolder: 'drizzle' });

import { createClient } from '@libsql/client';
import { drizzle } from 'drizzle-orm/libsql';
import { migrate } from 'drizzle-orm/libsql/migrator';

import * as schema from './schema';

export const db = drizzle(createClient({ url: 'file:./sqlite.db' }), { schema });

migrate(db, { migrationsFolder: 'drizzle' });

4 replies

DTDrizzle Team

•Created by Meexa on 1/9/2024 in #help

Error: Cannot open database because the directory does not exist

I've also tried file:./sqlite.db

4 replies

DTDrizzle Team

•Created by Meexa on 12/7/2023 in #help

How to do "onConflictDoUpdate" when inserting an array of values?

Got it! I think it's working. Thanks a lot!

16 replies

DTDrizzle Team

•Created by Meexa on 12/7/2023 in #help

How to do "onConflictDoUpdate" when inserting an array of values?

Nice, thanks, will try this

16 replies

DTDrizzle Team

•Created by Meexa on 12/7/2023 in #help

How to do "onConflictDoUpdate" when inserting an array of values?

Ah yeah, "excluded" is something that copilot suggested but it added sql.excluded which wasnt a thing

16 replies

DTDrizzle Team

•Created by Meexa on 12/7/2023 in #help

How to do "onConflictDoUpdate" when inserting an array of values?

These are multiple ~2000 row inserts, so I don't think I want to wrap the map around the insert, that would be 10k+ insert queries

16 replies

DTDrizzle Team

•Created by Meexa on 11/21/2023 in #help

sqlite insert results in error: "SQLite error: no such table: main.__old_push_items"

I continue to get this error, but one way to solve it is by deleting all the tables and pushing again. Not great, but its the only solution I've found so far.

7 replies

DTDrizzle Team

•Created by Meexa on 11/21/2023 in #help

sqlite insert results in error: "SQLite error: no such table: main.__old_push_items"

I have pushed all changes

7 replies

DTDrizzle Team

•Created by Meexa on 11/21/2023 in #help

sqlite insert results in error: "SQLite error: no such table: main.__old_push_items"

Also happens with a local sqlite db

7 replies

DTDrizzle Team

•Created by Meexa on 11/21/2023 in #help

sqlite insert results in error: "SQLite error: no such table: main.__old_push_items"

Schema file: https://pastebin.com/Wf0WyWLe

7 replies

DTDrizzle Team

•Created by Meexa on 8/16/2023 in #help

SQL_PARSE_ERROR: SQL string could not be parsed: near LP, "None"

I had to remove .all() because getSQL doesn't exist on that

8 replies

DTDrizzle Team

•Created by Meexa on 8/16/2023 in #help

SQL_PARSE_ERROR: SQL string could not be parsed: near LP, "None"

code

const notExistingCharsInDb = await db
  .select({ id: characters.id })
  .from(characters)
  .where(
    notExists(
      db
        .select({ id: characters.id })
        .from(characters)
        .where(inArray(characters.id, memberIds)),
    ),
  )
  .getSQL();
console.log(notExistingCharsInDb);

const notExistingCharsInDb = await db
  .select({ id: characters.id })
  .from(characters)
  .where(
    notExists(
      db
        .select({ id: characters.id })
        .from(characters)
        .where(inArray(characters.id, memberIds)),
    ),
  )
  .getSQL();
console.log(notExistingCharsInDb);

8 replies

Gaming

Programming