Jonathan Posts - Answer Overflow

Jonathan

Explore posts from servers

•Created by Jonathan on 5/10/2024 in #help

Incorrect relations

I have this Drizzle ORM query:

const projects = await ctx.db.query.syndicationProject.findMany({
        with: {
            entity: {
                with: {
                    members: {
                        with: {
                            member: true,
                        },
                    },
                },
            },
        },
    });

const projects = await ctx.db.query.syndicationProject.findMany({
        with: {
            entity: {
                with: {
                    members: {
                        with: {
                            member: true,
                        },
                    },
                },
            },
        },
    });

The problem is that "members" under each project.entity is empty, even though the correct rows and references are in the database. You can see how I have defined my schemas in my comment on this post. The weird thing is, if I change the relation name to "entity" like so:

export const personRelations = relations(person, ({ one, many }) => ({
    members: many(membership, { relationName: "entity" }),
}));

export const personRelations = relations(person, ({ one, many }) => ({
    members: many(membership, { relationName: "entity" }),
}));

Suddenly I do get the correct result. How can this be? The relation name should be "member", because I want to fetch the nested members. Or am I misunderstanding? Hopefully you can help me out!

4 replies

DTDrizzle Team

•Created by Jonathan on 4/13/2024 in #help

How do I recursively fetch tables?

Hi all, I have two tables in my postgres database:

person {
  id
}

person_to_person {
  id
  parent_id
  child_id
}

person {
  id
}

person_to_person {
  id
  parent_id
  child_id
}

The parent_id and child_id are references to the person table. I am trying to create a family tree-like structure, which means that I need to fetch every child recursively until there are no children left to fetch. Imagine a family tree. If you know the id of any given member in that tree (could be anywhere in the family tree), fetch all of its children recursively all the way to the bottom where there are no more children left. How do I accomplish this with Drizzle ORM? Preferably I want the result to be typed, so that the front-end can easily show this family tree on a webpage. I hope you can help me out!

5 replies

DTDrizzle Team

•Created by Jonathan on 8/1/2023 in #help

Drizzle kit SQL error

Hi all, I'm getting this weird error when I try to push my schema changes using drizzle-kit push and I have no idea where to begin to solve it:

Error: unknown: uncaught panic: interface conversion: interface is nil, not sqlparser.Expr, vtgate: http://
pscluster-xkj7v0lvx1yw-aws-uswest2a-2-vtgate-6cd24c1e-84962nl82:15000/
    at PromiseConnection.execute (C:\Users\jrrvd\Desktop\Projects\dcap-docgen\node_modules\drizzle-kit\inde
x.cjs:35435:26)
    at fromDatabase (C:\Users\jrrvd\Desktop\Projects\dcap-docgen\node_modules\drizzle-kit\index.cjs:11845:3
3)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async mysqlPushIntrospect (C:\Users\jrrvd\Desktop\Projects\dcap-docgen\node_modules\drizzle-kit\inde
x.cjs:37725:19)
    at async Command.<anonymous> (C:\Users\jrrvd\Desktop\Projects\dcap-docgen\node_modules\drizzle-kit\inde
x.cjs:53103:31) {
  code: 'ER_UNKNOWN_ERROR',
  errno: 1105,
  sql: 'SELECT table_name, column_name\n' +
    '  FROM information_schema.table_constraints t\n' +
    '  LEFT JOIN information_schema.key_column_usage k\n' +
    '  USING(constraint_name,table_schema,table_name)\n' +
    "  WHERE t.constraint_type='PRIMARY KEY'\n" +
    "      and table_name != '__drizzle_migrations'\n" +
    '      AND t.table_schema = ?',
  sqlState: 'HY000',
  sqlMessage: 'unknown: uncaught panic: interface conversion: interface is nil, not sqlparser.Expr, vtgate:
 http://pscluster-xkj7v0lvx1yw-aws-uswest2a-2-vtgate-6cd24c1e-84962nl82:15000/'
}

Error: unknown: uncaught panic: interface conversion: interface is nil, not sqlparser.Expr, vtgate: http://
pscluster-xkj7v0lvx1yw-aws-uswest2a-2-vtgate-6cd24c1e-84962nl82:15000/
    at PromiseConnection.execute (C:\Users\jrrvd\Desktop\Projects\dcap-docgen\node_modules\drizzle-kit\inde
x.cjs:35435:26)
    at fromDatabase (C:\Users\jrrvd\Desktop\Projects\dcap-docgen\node_modules\drizzle-kit\index.cjs:11845:3
3)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async mysqlPushIntrospect (C:\Users\jrrvd\Desktop\Projects\dcap-docgen\node_modules\drizzle-kit\inde
x.cjs:37725:19)
    at async Command.<anonymous> (C:\Users\jrrvd\Desktop\Projects\dcap-docgen\node_modules\drizzle-kit\inde
x.cjs:53103:31) {
  code: 'ER_UNKNOWN_ERROR',
  errno: 1105,
  sql: 'SELECT table_name, column_name\n' +
    '  FROM information_schema.table_constraints t\n' +
    '  LEFT JOIN information_schema.key_column_usage k\n' +
    '  USING(constraint_name,table_schema,table_name)\n' +
    "  WHERE t.constraint_type='PRIMARY KEY'\n" +
    "      and table_name != '__drizzle_migrations'\n" +
    '      AND t.table_schema = ?',
  sqlState: 'HY000',
  sqlMessage: 'unknown: uncaught panic: interface conversion: interface is nil, not sqlparser.Expr, vtgate:
 http://pscluster-xkj7v0lvx1yw-aws-uswest2a-2-vtgate-6cd24c1e-84962nl82:15000/'
}

I am using PlanetScale as my database provider.

12 replies

Gaming

Programming