DT
Drizzle Team•14mo ago
mirinbrah

many to many doc example

hello, i want to know how its possible to get the same value in the doc for many to many ?https://orm.drizzle.team/docs/rqb#include-custom-fields
Relational queries – DrizzleORM
Drizzle ORM | %s
4 Replies
mirinbrah
mirinbrah•14mo ago
with: {
        usersToGroups: {
            columns: {
                group: true,
            },
        },
    },
with: {
        usersToGroups: {
            columns: {
                group: true,
            },
        },
    },
how is it possible ? usersToGroups doesn't have colums group
mirinbrah
mirinbrah•14mo ago
mirinbrah
mirinbrah•14mo ago
it tell me i can't assign '{ group: true; }' to '{ userId?: boolean | undefined; groupId?: boolean | undefined; }'.
Andrii Sherman
Andrii Sherman•14mo ago
Use with Not columns
Want results from more Discord servers?
Add your server
More Posts
Custom Function to Transform Subqueries is missing types👋 So I am trying to write helper functions that are able to transform subqueries. The goal is to woHow to insert many rows with one-to-many relationshipsI have 100+ rows I want to insert into an `artists` table, and at the same time insert each artist'sDrizzle migrations workflow with CICD and multi-dev teamsHi! I'm looking into ORMs to use for my team in a new Node/TS project, and Drizzle has caught my attQuery from table with where clause NOT IN another sub query?For ex: select * from TableA where email not in (select email from TableB); ?how to empty a table (postgres)What's the best way to programatically empty a database table? I'm using ```javascript const emptieusing in nest.jsWhat is the proper way to use in nest.js (or express). Should I create one single instance of db tha"bind message supplies 1 parameters, but prepared statement \"\" requires 0"``` const results = await drizzleDb .select({ count: sql<number>`count(*)` }) .from(calls)POSTGRES_URL_NON_POOLING vs POOLINGI'm setting up postgres and drizzle to try to run some edge function. I'm reading these docs: httpsSubquery in selectHi, is it possible to use subquery in a select? I'd like to generate something like this ``` selectError when running drizzle-kit generate:mysqlI have no clue what this means ```apache ...>pnpm drizzle-kit generate:mysql drizzle-kit: v0.17.1 dr