DT
Drizzle Teamjean

Error when using Drizzle (Non-abstract class 'PgSelect<TTableName, TSelection, TSelectMode, [...])

I'm getting the following error when I try to use Drizzle: 
> graphql-server@1.0.0 start
> npm run compile && node ./dist/index.js


> graphql-server@1.0.0 compile
> tsc

node_modules/drizzle-orm/db.d-2eb7c122.d.ts:521:15 - error TS2515: Non-abstract class 'PgSelect<TTableName, TSelection, TSelectMode, TNullabilityMap>' does not implement inherited abstract member 'getSQL' from class 'PgSelectQueryBuilder<PgSelectHKT, TTableName, TSelection, TSelectMode, TNullabilityMap>'.

521 declare class PgSelect<TTableName extends string | undefined, TSelection, TSelectMode extends SelectMode, TNullabilityMap extends Record<string, JoinNullability> = TTableName extends string ? Record<TTableName, 'not-null'> : {}> extends PgSelectQueryBuilder<PgSelectHKT, TTableName, TSelection, TSelectMode, TNullabilityMap> {
                  ~~~~~~~~

node_modules/drizzle-orm/db.d-2eb7c122.d.ts:655:15 - error TS2420: Class 'PgDelete<TTable, TQueryResult, TReturning>' incorrectly implements interface 'SQLWrapper'.
  Property 'getSQL' is missing in type 'PgDelete<TTable, TQueryResult, TReturning>' but required in type 'SQLWrapper'.

655 declare class PgDelete<TTable extends AnyPgTable, TQueryResult extends QueryResultHKT, TReturning extends Record<string, unknown> | undefined = undefined> extends QueryPromise<TReturning extends undefined ? QueryResultKind<TQueryResult, never> : TReturning[]> implements SQLWrapper {
                  ~~~~~~~~

  node_modules/drizzle-orm/column.d-c31e7ad3.d.ts:257:5
    257     getSQL(): SQL;
            ~~~~~~~~~~~~~~
    'getSQL' is declared here.


Found 2 errors in the same file, starting at: node_modules/drizzle-orm/db.d-2eb7c122.d.ts:521
> graphql-server@1.0.0 start
> npm run compile && node ./dist/index.js


> graphql-server@1.0.0 compile
> tsc

node_modules/drizzle-orm/db.d-2eb7c122.d.ts:521:15 - error TS2515: Non-abstract class 'PgSelect<TTableName, TSelection, TSelectMode, TNullabilityMap>' does not implement inherited abstract member 'getSQL' from class 'PgSelectQueryBuilder<PgSelectHKT, TTableName, TSelection, TSelectMode, TNullabilityMap>'.

521 declare class PgSelect<TTableName extends string | undefined, TSelection, TSelectMode extends SelectMode, TNullabilityMap extends Record<string, JoinNullability> = TTableName extends string ? Record<TTableName, 'not-null'> : {}> extends PgSelectQueryBuilder<PgSelectHKT, TTableName, TSelection, TSelectMode, TNullabilityMap> {
                  ~~~~~~~~

node_modules/drizzle-orm/db.d-2eb7c122.d.ts:655:15 - error TS2420: Class 'PgDelete<TTable, TQueryResult, TReturning>' incorrectly implements interface 'SQLWrapper'.
  Property 'getSQL' is missing in type 'PgDelete<TTable, TQueryResult, TReturning>' but required in type 'SQLWrapper'.

655 declare class PgDelete<TTable extends AnyPgTable, TQueryResult extends QueryResultHKT, TReturning extends Record<string, unknown> | undefined = undefined> extends QueryPromise<TReturning extends undefined ? QueryResultKind<TQueryResult, never> : TReturning[]> implements SQLWrapper {
                  ~~~~~~~~

  node_modules/drizzle-orm/column.d-c31e7ad3.d.ts:257:5
    257     getSQL(): SQL;
            ~~~~~~~~~~~~~~
    'getSQL' is declared here.


Found 2 errors in the same file, starting at: node_modules/drizzle-orm/db.d-2eb7c122.d.ts:521
jean
jean•356d ago
Here's my package.json: 
{
  [... removed]
  "main": "index.js",
  "type": "module",
  "scripts": {
    "compile": "tsc",
    "start": "npm run compile && node ./dist/index.js"
  },
  "dependencies": {
    "@apollo/server": "^4.7.1",
    "drizzle-orm": "^0.26.1",
    "graphql": "^16.6.0",
    "postgres": "^3.3.4"
  },
  "devDependencies": {
    "@types/node": "^20.2.5",
    "drizzle-kit": "^0.18.1",
    "typescript": "^5.0.4"
  }
}
{
  [... removed]
  "main": "index.js",
  "type": "module",
  "scripts": {
    "compile": "tsc",
    "start": "npm run compile && node ./dist/index.js"
  },
  "dependencies": {
    "@apollo/server": "^4.7.1",
    "drizzle-orm": "^0.26.1",
    "graphql": "^16.6.0",
    "postgres": "^3.3.4"
  },
  "devDependencies": {
    "@types/node": "^20.2.5",
    "drizzle-kit": "^0.18.1",
    "typescript": "^5.0.4"
  }
}
And my tsconfig.json: 
{
  "compilerOptions": {
    "rootDirs": ["src"],
    "outDir": "dist",
    "lib": ["es2020"],
    "target": "es2020",
    "module": "esnext",
    "moduleResolution": "node",
    "esModuleInterop": true,
    "types": ["node"]
  }
}
{
  "compilerOptions": {
    "rootDirs": ["src"],
    "outDir": "dist",
    "lib": ["es2020"],
    "target": "es2020",
    "module": "esnext",
    "moduleResolution": "node",
    "esModuleInterop": true,
    "types": ["node"]
  }
}
Not sure what I'm doing wrong here. I suppressed the error by adding: "skipLibCheck": true to my tsconfig.json
Angelelz
Angelelz•183d ago
That's it
Want results from more Discord servers?
Add your server
More Posts
Generate classes/interfaces from existing schemas?Messing around with drizzle, and I was wondering if there was any way to generate a class or interfaRelation Query - Get likes in postPlaying around with relational queries and I'm not quite getting how I'd retrieve the count of likesRelation query `extras` needs access to `with`I have a mysql table with two relations to another table. (one is for source values, one is for optiOptional filter param, coalesce to true?Is there a way to achieve this coalescing technique, but in valid drizzle sql? ```ts const filterByRelational query, Planetscale throws: `ResourceExhausted desc = Out of sort memory`SOLUTION: the problem was that I had a json column storing a massive value on each row. `code = ReInt to Float or Double db:pushHi we are working on a project that has drizzle db connected to a planetscale database. We initiallyTimestamp mode differences?What is the difference between the timestamp "mode" of "string'"and "date"?Many-to-Many Self RelationI'm looking to migrate from Prisma, but I'm having trouble trying to figure out how a many-to-many sRelations, three level nested where?Given a `User, Role, RoleToUser` many-to-many relation: ```ts export const userRelations = relationHelp with this relational query?I am trying to get all the organizations that a member is associated with. This code is working: