isitayush Posts - Answer Overflow

isitayush

Explore posts from servers

RReactiflux TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by isitayush on 12/5/2023 in #help

search on all `with` and `columns` fields via text (sqlite)

Hi! I'm using better-sqlite3 as the driver. I have a bunch of fields selected via columns & with (nested fields) & an offset based pagination. I'm using the querybuilder (.query). How would I go about performing a full text search on the selected columns as well as the selected nested columns? Say,

const { offset, query, limit} = input;
const result = ctx.db.query.myModel.findMany({
   limit: limit ?? 10,
   offset: offset ?? 0,
   with: ...,
   columns: ...
});
const nextOffset: number = result.length + (offset ?? 0);
return {
 data: result,
 nextOffset: nextOffset
};

const { offset, query, limit} = input;
const result = ctx.db.query.myModel.findMany({
   limit: limit ?? 10,
   offset: offset ?? 0,
   with: ...,
   columns: ...
});
const nextOffset: number = result.length + (offset ?? 0);
return {
 data: result,
 nextOffset: nextOffset
};

I'm including towards using where: or(x, or(y, or())) but i'm not sure that's correct (& would work for slected nested relations). Let me know!!

14 replies

DTDrizzle Team

•Created by isitayush on 9/23/2023 in #help

accessing related foreign tables via sql operator

1 replies

DTDrizzle Team

•Created by isitayush on 5/14/2023 in #help

I think I don't really understand migrations local sqlite.

It's a local sqlite db (DB_URL=file:dev.db) in a nextjs & trpc setup. I'm trying drizzle for the first time & I did follow the steps mentioned https://github.com/drizzle-team/drizzle-orm/blob/main/drizzle-orm/src/sqlite-core/README.md#-quick-start. I ran npx drizzle-kit generate:sqlite & it succesfully generated a migration. Good Job Drizzle! The problem is how do I push these migrations to my dev.db file? Do I need to push them manually? Am I missing something? I was planning to later use Turso & switch to it but even in the case of turso, I think I would have to manually write each migration in the db shell. Drizzle Kit does not have a push command for sqlite. I'm using drizzle-kit: v0.17.6 drizzle-orm: v0.25.4. Any help is appreciated as I'm tired reading docs & searching for similar issues here.

13 replies

Gaming

Programming