BluePin
BluePin
Explore posts from servers
TtRPCTTCTheo's Typesafe CultDTDrizzle Team
PostsComments
DTDrizzle Team
Created by BluePin on 3/26/2024 in #help
Bug Report: Drizzle-kit Introspection Failed to Declare Default Value in SQL
Table introspection fails to find a type declaration for a default value. 
     ref_icon character varying(255) COLLATE pg_catalog."default" DEFAULT 'activity'::character varying,
     ref_icon character varying(255) COLLATE pg_catalog."default" DEFAULT 'activity'::character varying,
Automatic SQL import does not occur and it imports without declaring it to be raw SQL. 
import { sql } from 'drizzle-orm';
import { sql } from 'drizzle-orm';
As a result several errors are created in the imported schema. 
    refIcon: varchar("ref_icon", { length: 255}).default('activity'::character varying`),
    refIcon: varchar("ref_icon", { length: 255}).default('activity'::character varying`),
Solution: Introspection must import SQL and make the statement as evidenced in the Documentation: 
refIcon: varchar("ref_icon", { length: 255 }).default(
       sql`'activity'::character varying`,
     ),
refIcon: varchar("ref_icon", { length: 255 }).default(
       sql`'activity'::character varying`,
     ),
https://orm.drizzle.team/docs/indexes-constraints
2 replies
DTDrizzle Team
Created by BluePin on 3/22/2024 in #help
Does anyone know how to write `::character varying` correctly in schema?
refIcon: varchar("ref_icon", { length: 255 }).default('activity'::character varying), I am getting the error: ⚠ Error(TS1005) | , expected. ⚠ Error(TS2554) | Expected 1 arguments, but got 3. ⚠ Error(TS2304) | Cannot find name varying .
2 replies