Tomathy
Tomathy
Explore posts from servers
PPrismaDTDrizzle Team
PostsComments
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
i figured out the problem... I was reaching for the wrong port on supabase. Since im not in a serverless enviornment i should reach for the session mode which uses a different port than the transaction mode in supabase. I changed the port and everything worked fine -_- Thanks for all the help anyways
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
I put the cert in the ./prisma folder, to be as straight forward as possible "sslcert=dbcert.crt" on the URl, but all im gettingis a connection not establishing (the terminal gets stuck at this): 
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "<HOST>:6543"
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "<HOST>:6543"
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
wow, thanks that makes sense. Thank you for the answers ❤️
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
ah fair, thought the connection used the cert as an encryption key for sending the credentials.
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
thank you! Would i need any more arguments in the url than those? Or are those enough? Cause i see that there are options for sslidentity=<PATH> and sslpassword=<PASSWORD> and im not sure if those are required to establish a sll connection
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
No sorry, Im figuring out things as I go so I'm a bit lost here 😅 . Basically what's happening is I want to connect top my supabase database with SSL. I wasn't able to do it before, basically when i ran, say "db push" it attempted to connect to the database but would just continuously run without connecting and nothing would happen. Since then I have read the documentation and downloaded the certificate from supabase, but I'm still having difficulties figuring out what is needed and what isn't needed in the connection URL to always establish a SSL connection. currently my string is looking like this: postgresql://USER:PASSWORD@HOST:6543/postgres?pgbouncer=true&connection_limit=1&sslcert=../certificates/dbcert.crt with the correct values where appropriate
18 replies
DTDrizzle Team
Created by Tomathy on 9/2/2024 in #help
No overload matches this call
but the enum is composed of strings. Is there a way to export/import the enums type and how do I insert enum values into the table?
12 replies
DTDrizzle Team
Created by Tomathy on 9/2/2024 in #help
No overload matches this call
Tried it, but gives the same error but for a different attribute? It's so weird seeing as the first error was for "name" and not the bytea attribute. Nw it's just pointing out the enum 🤔 Here's the new schema: 
export const clients = pgTable("clients",{
    id: serial("id").primaryKey(),
    name: varchar("name", { length: 256 }).notNull(),
    nif: char("nif", { length: 9}).unique().notNull(),
    password: varchar("password", {length: 256}).unique().notNull(),
    email: varchar("email", { length: 256}).unique(),
    rf_taxrep: rfEnum("rf_taxrep"),
    activity: activityEnum("activity").notNull(),
    obs: text("obs"),
    services: serial("services").references(() => service.id, {onDelete: "cascade"}),
})
export const clients = pgTable("clients",{
    id: serial("id").primaryKey(),
    name: varchar("name", { length: 256 }).notNull(),
    nif: char("nif", { length: 9}).unique().notNull(),
    password: varchar("password", {length: 256}).unique().notNull(),
    email: varchar("email", { length: 256}).unique(),
    rf_taxrep: rfEnum("rf_taxrep"),
    activity: activityEnum("activity").notNull(),
    obs: text("obs"),
    services: serial("services").references(() => service.id, {onDelete: "cascade"}),
})
Here's the new error: No overload matches this call. Overload 1 of 2, '(value: { name: string | SQL<unknown> | Placeholder<string, any>; nif: string | SQL<unknown> | Placeholder<string, any>; password: string | SQL<unknown> | Placeholder<...>; ... 5 more ...; services?: number | ... 2 more ... | undefined; }): PgInsertBase<...>', gave the following error. Type 'string' is not assignable to type 'SQL<unknown> | "ATIVO" | "NÃO ATIVO" | "SUSPENSO" | Placeholder<string, any>'. Overload 2 of 2, '(values: { name: string | SQL<unknown> | Placeholder<string, any>; nif: string | SQL<unknown> | Placeholder<string, any>; password: string | SQL<unknown> | Placeholder<...>; ... 5 more ...; services?: number | ... 2 more ... | undefined; }[]): PgInsertBase<...>', gave the following error. Object literal may only specify known properties, and 'name' does not exist in type '{ name: string | SQL<unknown> | Placeholder<string, any>; nif: string | SQL<unknown> | Placeholder<string, any>; ... (Discord limit)
12 replies
DTDrizzle Team
Created by Tomathy on 9/2/2024 in #help
No overload matches this call
const bytea = customType<{ data: Buffer; notNull: false; default: false }>({
    dataType() {
      return "bytea";
    },
  });
const bytea = customType<{ data: Buffer; notNull: false; default: false }>({
    dataType() {
      return "bytea";
    },
  });
From the error message, it seems it's not recognizing name as an attribute :/
12 replies
DTDrizzle Team
Created by Tomathy on 9/2/2024 in #help
No overload matches this call
no, just a single project
12 replies