Izaan
DTDrizzle Team
•Created by Izaan on 12/16/2023 in #help
how do I store list of string in my pg table
@Angelelz It seemd cool so
6 replies
DTDrizzle Team
•Created by Izaan on 12/8/2023 in #help
self reference error
I did
channelId: text("channelId").references(
(): AnyPgColumn => youtubeChannels.id,
{
onDelete: "cascade",
}
), and it fixed the error20 replies
DTDrizzle Team
•Created by Izaan on 12/8/2023 in #help
self reference error
well pg is not needed I was getting some errors saying pg is missing when I was pushing the migrations so I added it as dev dep
20 replies
DTDrizzle Team
•Created by Izaan on 12/8/2023 in #help
self reference error
I have postgres as core dependency and pg as dev depdency
20 replies
DTDrizzle Team
•Created by Izaan on 12/8/2023 in #help
self reference error
yup
import { timestamp, pgTable, primaryKey, text } from "drizzle-orm/pg-core";
import type { AdapterAccount } from "@auth/core/adapters";
import { relations } from "drizzle-orm";20 replies
DTDrizzle Team
•Created by Izaan on 12/8/2023 in #help
self reference error
what I want the user to have two roles if the user is admin he will have multiple editor users and every editor user will have one admin user. Then I thought why not channel table have this logic contained ie the channel will have users as editor and one user as admin. If you have any suggestions in this regard I will be glad to see it
20 replies
DTDrizzle Team
•Created by Izaan on 12/8/2023 in #help
self reference error
I have anothe table channel and when i reference it in user it gives the same error
20 replies
DTDrizzle Team
•Created by Izaan on 12/8/2023 in #help
self reference error
No no its in the schema
20 replies
DTDrizzle Team
•Created by Izaan on 11/14/2023 in #help
One to Many Self Relations...
@peterferguson it worked for that particular relation but I have other which I needed to define so, I switched my db to pg. And I am trying my schema in it.
If anyone would be willing to help I will post my schema template (drawing), and if you could give me the schema in drizzle that would help a lot.
22 replies
DTDrizzle Team
•Created by Izaan on 11/14/2023 in #help
One to Many Self Relations...
Thanks I am not getting the error now, let me see if the functionality is there .... Thanks agian
22 replies
DTDrizzle Team
•Created by Izaan on 11/14/2023 in #help
One to Many Self Relations...
this is the link to my stack overflow question... >> https://stackoverflow.com/questions/77476592/how-do-define-relations-in-planetscalemysql-with-drizzle-orm
22 replies
DTDrizzle Team
•Created by Izaan on 11/14/2023 in #help
One to Many Self Relations...
I am not sure if I understand that...
22 replies