Drizzle Team•10mo ago

Loosing ability to add more than one join/where/etc call when using a generic type definition

Hi, I struggle a bit with getting the types correct for this method using generics. The db variable is of type NodePgDatabase<Record<string, unknown>>. It seems like I'm not able to chain more than one join. The error I get is

Property 'leftJoin' does not exist on type 'Omit<PgSelectKind<PgSelectKind<PgSelectHKT, "activities", AppendToResult<"activities", T extends undefined ? { id: PgColumn<{ name: "id"; tableName: "activities"; dataType: "string"; columnType: "PgUUID"; ... 5 more ...; baseColumn: never; }, {}, {}>; ... 27 more ...; updatedById: PgColumn<...>; } : T, "companies", ...'.

Property 'leftJoin' does not exist on type 'Omit<PgSelectKind<PgSelectKind<PgSelectHKT, "activities", AppendToResult<"activities", T extends undefined ? { id: PgColumn<{ name: "id"; tableName: "activities"; dataType: "string"; columnType: "PgUUID"; ... 5 more ...; baseColumn: never; }, {}, {}>; ... 27 more ...; updatedById: PgColumn<...>; } : T, "companies", ...'.

This is working if I do not use the generics type T and just provide the fields directly.

1 Reply

bjorbratOP•10mo ago

The issue is described here at the typescript playground: https://www.typescriptlang.org/play?#code/JYWwDg9gTgLgBAbzgZQKYBtUGMaoCYBiwGeAzgDRxgDmAKgIYBGmlpqUw96luAHvAF84AMygQQcAER4OAL1mYAtNBAB6GoqzRUkgNwAoUJFiI4M4PMxwho8VPOXUyqGoB2EPE8ikY1KKlI9Q3BoeCRUAEdKZABFABlrETEJaTkFJxUg-VReY3gtVx84EHpgVzgAXio6JkwACkkSsslKBH04OGA8AC44Ng4uBq7JAEpydrhXehBUXr4YBqmZ0fGBEYNs3NC4AqKAKwgygEZK6oZmVAaD45bECa7e-s50IbwViabXAEkevvZnhqfAD6wxGADp-MJ2KhXFgAnU6iNKgA+YqlVxgrpjCZgMRgOY5BaSXEQMDvNYbHJ5HYQQrwa6uABMpxo53qkgZjNubQ6Dz+AxeklB4w6nx+j3+g0a6JBb3BkOhsPhiJRaLKmLw2I6JPxcHmDR15PW+n0u3geEYpwc6TqCCE9FIcHorgAnsb9KoAFSe9qeuC0AAWwEdAHdoABrUi+1Qms1wMNQcNlainegh0rmxhgtiYHC2+6-T4akWTaazNUYpaoEsMo4ABTxvVrYJ1NcOTIbpKb7cZLbxqxGEzBthAdU+g46YMwwhgACl23Va5RImP0cW4M2xZqJ3Ap6gZ-Oyoue8uIqv1V1KJywVuRjuwSGA9C6iui1XKJJ5wHXKN3V6fXAfpEFART0DAuDgDA0b6DALpgKgKAYNgMC1KgRAkKQAA8tAAKL8FA9BwISMJkH0MAcK4KZVK4qAAG7sKiFQTHUsHwRAwgViMADakhApIAC6PFaOgACuICFAJcAAGRwAAStg0B4NheHkfQ0TxJhImuOG7ghq4yLIhscYgC6whaTgwC0icVSYXWRH8CRjp1vQsDPJhaC5ihFzoegZAGXUwjEL5pC9HWSIVMiEwWhMk45shAVBWQO6TiO56uMlu7TnOC5LkRZ5FpeG7tkcN7oj8d4xZl+7ZUenKnml67XreGUPk+-gvvla7vlIX4-neRm0kUMLkcQpDWU66bAPAJlmbCMCWa4Rz5ryhZrpeExVr0b5lm2xydrqzathMnL7d2ZS9kdFImv+vqIQUeBOuBqCQdBxmmeZ820syNl2cRrikR5yH4D5fkJRhoXhZFHTRR0sVIXmgUYS1qXjpVe4HjlxX1QVeBXsVpVlOVLVZYerjHud2NrbjRXnQT3zbmjj7Pq+XU7T1EDfr+A10kRrgjQE30TRmxTvXNC2MstnSrReuMbWWW2szMu2LadNOLX2pLK4yqvXpdf6qLDsMAHoAPz6EAA

TS Playground - An online editor for exploring TypeScript and JavaS...

The Playground lets you write TypeScript or JavaScript online in a safe and sharable way.

Gaming

Programming

Loosing ability to add more than one join/where/etc call when using a generic type definition