Ganbatte Posts - Answer Overflow

Ganbatte

Explore posts from servers

KPCKevin Powell - Community DTDrizzle Team

Posts Comments

DTDrizzle Team

•Created by Ganbatte on 11/27/2024 in #help

Why Isn't RLS Working with Drizzle and Supabase?

42 replies

DTDrizzle Team

•Created by Ganbatte on 11/9/2024 in #help

Issues Using RLS with Supabase Through Drizzle

4 replies

DTDrizzle Team

•Created by Ganbatte on 10/28/2024 in #help

How to Handle Incorrect Schema Generation with Drizzle?

Hi everyone! What is the usual practice when I generate an incorrect schema with Drizzle and can't successfully migrate? Is there a command to delete the previous migration/generation? Because no matter what I change afterward, it keeps throwing the same error. For example, I have two tables that I linked together, but I later noticed that one has an int column and the other has text. Even if I fix the schema, regenerate it, and try to migrate again, it still throws the same error. How should I properly handle this? Thanks in advance! Error example:

  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42804',
  detail: 'Key columns "dishID" and "id" are of incompatible types: integer and text.',
  where: 'SQL statement "ALTER TABLE "topping_dish" ADD CONSTRAINT "topping_dish_dishID_dish_id_fk" FOREIGN KEY ("dishID") REFERENCES "public"."dish"("id") ON DELETE cascade ON UPDATE no action"\n' +
    'PL/pgSQL function inline_code_block line 2 at SQL statement',
  file: 'tablecmds.c',
  line: '9339',
  routine: 'ATAddForeignKeyConstraint'

1 replies

DTDrizzle Team

•Created by Ganbatte on 10/25/2024 in #help

Middleware Issues in Next.js Using Drizzle, Supabase, and NextAuth

9 replies

DTDrizzle Team

•Created by Ganbatte on 8/14/2024 in #help

Help Needed with Drizzlekit Migration Issue

I've encountered an issue where I manually deleted a table in Drizzlekit Studio using DROP TABLE "orderProduct". This was due to a bug inside my orderProduct where I had both an "orders" and "order" column, each referencing the "orders" table, and I couldn't remove them. I'm not fully understanding how migrations work in Drizzlekit, which is why I'm reaching out. When I run bunx drizzle-kit generate and migrate, the table isn't being regenerated along with its relations. Bunx drizzle-kit generate output:

14 tables
orderProduct 5 columns 0 indexes 3 fks
orders 7 columns 0 indexes 1 fks
.....
No schema changes, nothing to migrate 😴

Bunx drizzle-kit migrate output:

No config path provided, using default 'drizzle.config.ts'
Reading config file 'C:\...\drizzle.config.ts'
Using 'postgres' driver for database querying
[⣟] applying migrations...{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42P06',
  message: 'schema "drizzle" already exists, skipping',
  file: 'schemacmds.c',
  line: '132',
  routine: 'CreateSchemaCommand'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42P07',
  message: 'relation "__drizzle_migrations" already exists, skipping',   
  file: 'parse_utilcmd.c',
  line: '207',
  routine: 'transformCreateStmt'
}
[⡿] applying migrations...PostgresError: relation "orderProduct" does not exist
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42P01',
  file: 'namespace.c',
  line: '434',
  routine: 'RangeVarGetRelidExtended'
}
error: script "migrate" exited with code 1

How can I fix this? The schema clearly defines what should be generated. Any help would be greatly appreciated!

2 replies

DTDrizzle Team

•Created by Ganbatte on 7/17/2024 in #help

How to Reference a Column Type in Drizzle

4 replies

KPCKevin Powell - Community

•Created by Ganbatte on 12/20/2023 in #front-end

Difficulty with Autocompletion for SCSS Variables in Visual Studio Code

I'm facing challenges with getting proper autocompletion for SCSS variables in Visual Studio Code. I have a separate SCSS file where I store all my variables (_variables.scss), and I'm importing them into another file (style.scss). However, despite using @use access these variables, the autocomplete doesn't seem to work efficiently. Is there a recommended extension or configuration to enable accurate autocompletion for SCSS variables across files in Visual Studio Code? Currently, I'm manually referencing variables like variables.$variableName, which becomes cumbersome with a growing number of variables. Any guidance or suggestions to streamline the autocompletion process for SCSS variables would be greatly appreciated! If someone could provide an example of how to use SCSS and CSS variables in separate files while ensuring autocomplete works in VSCode, I'd greatly appreciate it.

8 replies

Gaming

Programming