isitayush Comments - Answer Overflow

Topics

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)

That helps & I'll look for it! Thank you Angelelz. 💙

14 replies

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

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

There are many way of searching through many columns. but I'm not sure it can be through several tables in the same query Maybe a concat with several column from a join?

That's interesting! Getting the data & joining is not difficult. I'm just stuck on searching (hopefully a text search) across the result: object[] of all the joins. If I may, could you point me to a few resources for many ways of searching through many columns (for sqlite!) if you're aware of any Angelelz.

How big is the content in each column?

On most of the columns, the content is almost always 1-2 words long.

14 replies

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

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

Thank you @Angelelz! (i apologize for ping!!) This is what I ended up doing. Do you think it's possible by building sql queries via drizzle instead of using the drizzle .query builder. I'm not too good at SQL so I had no choice other than using query builder for this but just wondering.

14 replies

•Created by hhhyh on 4/10/2023 in #❓-help

TRPCClientError - No "query"-procedure on path "user.all"

Aahah 😂, Should've done it before bothering here. I was almost out of breath since this thread is 2.9 months old. Thank you so much hhhyh!🫡

14 replies

•Created by hhhyh on 4/10/2023 in #❓-help

TRPCClientError - No "query"-procedure on path "user.all"

Ah, It worked ^_^!! It was very strange though. I'm unsure what caused it.

14 replies

•Created by hhhyh on 4/10/2023 in #❓-help

TRPCClientError - No "query"-procedure on path "user.all"

Trying it. rm rf the modules and .next and restart the dev server! A moment.

14 replies

•Created by hhhyh on 4/10/2023 in #❓-help

TRPCClientError - No "query"-procedure on path "user.all"

T3!

14 replies

•Created by hhhyh on 4/10/2023 in #❓-help

TRPCClientError - No "query"-procedure on path "user.all"

Similar error, TRPCClientError: No "query"-procedure on path "myRouter.procedure". It worked fine when I added it for the first time although I'm not sure what change I made that caused it to error like that. Other procedures work fine and autocomplete seems to recognize this procedure although it errors out on console. I didn't make any change that could induce such an error. Even verified via git status.

14 replies

•Created by hhhyh on 4/10/2023 in #❓-help

TRPCClientError - No "query"-procedure on path "user.all"

Hey @hhhyh, I know this is late but what was the issue? I've encountered a similar issue so hope I find something here.

14 replies

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

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

Okay, Figured It out! It's .default(sql``) . : )

13 replies

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

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

I'm looking for it to be something like this. "id" UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid()

13 replies

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

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

Hey @bloberenober, Just a small question. How do I set a 'gen_random_uuid()' function as a default value on a custom type? I have the following:

const serial_uuid = customType<
    {
        data: string;
        driverData: string;
        notNull: true;
        default: true;
    }
>({
    dataType(config) {
        return 'UUID';
    },

});

const serial_uuid = customType<
    {
        data: string;
        driverData: string;
        notNull: true;
        default: true;
    }
>({
    dataType(config) {
        return 'UUID';
    },

});

& it generates a following migration, "id" UUID PRIMARY KEY NOT NULL,.

13 replies

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

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

It totally slipped from my head that I could include a script such as ensure_migrations.ts with tsc that runs before dev or start alongisde my next app. A native solution in drizzle-kit would still be awesome but this workaround seems to work too. Welp! Thank you Dan & Andrew. I hope you will bump up 'covers ~95% of the common cases' line to '99%' when db:push ships later this month. Goodluck!

13 replies

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

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

Oh, Okay. I guess until this is taken care of by drizzle-kit push:... command (something similar to what prisma does). It would be impossible to make this work with serverless frameworks (like nextjs) without manually pushing your migrations to db each time you make a change ie. generate new migrations. For now it's a deal breaker & I think I would have to fallback to using prisma but I really wish it's solved soon as would instantly take it over prisma any day. Thank you for the help though Dan!

13 replies