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

HHono

•Created by Meexa on 6/20/2024 in #help

How to do filepath as a param in an RPC route?

{ filepath: filepath ?? '/' } seems to work. http://localhost:3000/api/folders//? Not sure how to get rid of the ? though

7 replies

HHono

•Created by Meexa on 6/20/2024 in #help

How to do filepath as a param in an RPC route?

Hey, I've had some time to look into this and I have this endpoint now .get('/:filepath{.+}?', ...) Then I can execute this function like so

function getFolders(filepath?: string) {
  return api.folders[':filepath{.+}?'].$get({ param: { filepath } })
}

function getFolders(filepath?: string) {
  return api.folders[':filepath{.+}?'].$get({ param: { filepath } })
}

The problem I have now is since filepath is optional, the filepath can be undefined. What happens then is that This request is made http://localhost:3000/api/folders/undefined? If I do this { filepath: filepath ?? '' } then the request is http://localhost:3000/api/folders/? Both requests fail. What am I doing wrong?

7 replies

HHono

•Created by Meexa on 6/20/2024 in #help

How to do filepath as a param in an RPC route?

Thanks 🙏

7 replies

HHono

•Created by Meexa on 6/20/2024 in #help

How to do filepath as a param in an RPC route?

@Nico Is that the correct link? Where do I look for the example?

7 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

Gaming

Programming