Skip to content

sammccord/drizzle-relations-repro

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits

migrations

migrations

 
 

src

src

 
 

.env

.env

 
 

.gitignore

.gitignore

 
 

README.md

README.md

 
 

bun.lockb

bun.lockb

 
 

drizzle.config.ts

drizzle.config.ts

 
 

package.json

package.json

 
 

tsconfig.json

tsconfig.json

 
 

Repository files navigation

This repo reproduces the following issue in drizzle-orm that occurs when querying with relations using bun and sqlite.

sammccord  …/test   main    v18.17.0  ♥ 16:17  bun run ./src/test:bun.ts
271 |         tablesConfig,
272 |         tablesConfig[selectionItem.relationTableTsKey],
273 |         subRows,
274 |         selectionItem.selection,
275 |         mapColumnValue
276 |       ) : subRows.map(
                ^
TypeError: undefined is not an object (evaluating 'subRows.map')
      at mapRelationalRow (/Users/sammccord/work/test/node_modules/drizzle-orm/relations.js:276:11)
      at map (:1:21)
      at /Users/sammccord/work/test/node_modules/drizzle-orm/sqlite-core/query-builders/query.js:100:22
      at execute (/Users/sammccord/work/test/node_modules/drizzle-orm/sqlite-core/query-builders/query.js:133:19)
      at then (/Users/sammccord/work/test/node_modules/drizzle-orm/query-promise.js:21:12)

Steps

curl -fsSL https://bun.sh/install | bash

bun install

bunx drizzle-kit generate:sqlite

bun run src/migrate.ts

verify tables have migrated, should see User and Credential table

bunx drizzle-kit studio

run test script, should insert a user, credential, then find the user it inserted with their credentials

npx tsm ./src/test:sqlite.ts

should run successfully and see

sammccord  …/test   main    v18.17.0  ♥ 16:17  npx tsm ./src/test:sqlite.ts
(node:34287) ExperimentalWarning: Custom ESM Loaders is an experimental feature and might change at any time
(Use `node --trace-warnings ...` to show where the warning was created)
(node:34287) DeprecationWarning: Obsolete loader hook(s) supplied and will be ignored: getFormat, transformSource
{
  id: '0.704631150727792',
  credentials: [ { id: '0.2095886726136571', userId: '0.704631150727792' } ]
}

bun run ./src/test:bun.ts

sammccord  …/test   main    v18.17.0  ♥ 16:17  bun run ./src/test:bun.ts
271 |         tablesConfig,
272 |         tablesConfig[selectionItem.relationTableTsKey],
273 |         subRows,
274 |         selectionItem.selection,
275 |         mapColumnValue
276 |       ) : subRows.map(
                ^
TypeError: undefined is not an object (evaluating 'subRows.map')
      at mapRelationalRow (/Users/sammccord/work/test/node_modules/drizzle-orm/relations.js:276:11)
      at map (:1:21)
      at /Users/sammccord/work/test/node_modules/drizzle-orm/sqlite-core/query-builders/query.js:100:22
      at execute (/Users/sammccord/work/test/node_modules/drizzle-orm/sqlite-core/query-builders/query.js:133:19)
      at then (/Users/sammccord/work/test/node_modules/drizzle-orm/query-promise.js:21:12)

Some more context?

It looks like the row is coming back as a Record<string, string> and not a Record<number, ?> so const rawSubRows = row[selectionItemIndex] will always be undefined.

❯ bun run ./src/test:bun.ts
row {
  id: "0.944135394960811",
  credentials: "[[\"0.23310756733786797\",\"0.944135394960811\"]]",
}
selectionItemIndex 1
selectionItem {
  dbKey: "credentials",
  tsKey: "credentials",
  field: Aliased {
    isSelectionField: false,
    sql: SQL {
      decoder: {
        mapFromDriverValue: [Function: mapFromDriverValue],
      },
      shouldInlineParams: false,
      queryChunks: [
        StringChunk {
          value: [ "(" ],
          getSQL: [Function: getSQL],
        }, SQL {
          decoder: {
            mapFromDriverValue: [Function: mapFromDriverValue],
          },
          shouldInlineParams: false,
          queryChunks: [
            StringChunk {
              value: [ "" ],
              getSQL: [Function: getSQL],
            }, undefined, StringChunk {
              value: [ "select" ],
              getSQL: [Function: getSQL],
            }, undefined, StringChunk {
              value: [ " " ],
              getSQL: [Function: getSQL],
            }, SQL {
              decoder: {
                mapFromDriverValue: [Function: mapFromDriverValue],
              },
              shouldInlineParams: false,
              queryChunks: [
                SQL {
                  decoder: [Object ...],
                  shouldInlineParams: false,
                  queryChunks: [
                    [Object ...], [Object ...], [Object ...]
                  ],
                  append: [Function: append],
                  toQuery: [Function: toQuery],
                  buildQueryFromSourceParams: [Function: buildQueryFromSourceParams],
                  mapInlineParam: [Function: mapInlineParam],
                  getSQL: [Function: getSQL],
                  as: [Function: as],
                  mapWith: [Function: mapWith],
                  inlineParams: [Function: inlineParams],
                }, SQL {
                  decoder: [Object ...],
                  shouldInlineParams: false,
                  queryChunks: [
                    [Object ...], [Object ...], [Object ...]
                  ],
                  append: [Function: append],
                  toQuery: [Function: toQuery],
                  buildQueryFromSourceParams: [Function: buildQueryFromSourceParams],
                  mapInlineParam: [Function: mapInlineParam],
                  getSQL: [Function: getSQL],
                  as: [Function: as],
                  mapWith: [Function: mapWith],
                  inlineParams: [Function: inlineParams],
                }
              ],
              append: [Function: append],
              toQuery: [Function: toQuery],
              buildQueryFromSourceParams: [Function: buildQueryFromSourceParams],
              mapInlineParam: [Function: mapInlineParam],
              getSQL: [Function: getSQL],
              as: [Function: as],
              mapWith: [Function: mapWith],
              inlineParams: [Function: inlineParams],
            }, StringChunk {
              value: [ " from " ],
              getSQL: [Function: getSQL],
            }, SQL {
              decoder: {
                mapFromDriverValue: [Function: mapFromDriverValue],
              },
              shouldInlineParams: false,
              queryChunks: [
                StringChunk {
                  value: [ "" ],
                  getSQL: [Function: getSQL],
                }, Name {
                  brand: undefined,
                  value: "Credential",
                  getSQL: [Function: getSQL],
                }, StringChunk {
                  value: [ " " ],
                  getSQL: [Function: getSQL],
                }, Name {
                  brand: undefined,
                  value: "users_credentials",
                  getSQL: [Function: getSQL],
                }, StringChunk {
                  value: [ "" ],
                  getSQL: [Function: getSQL],
                }
              ],
              append: [Function: append],
              toQuery: [Function: toQuery],
              buildQueryFromSourceParams: [Function: buildQueryFromSourceParams],
              mapInlineParam: [Function: mapInlineParam],
              getSQL: [Function: getSQL],
              as: [Function: as],
              mapWith: [Function: mapWith],
              inlineParams: [Function: inlineParams],
            }, StringChunk {
              value: [ "" ],
              getSQL: [Function: getSQL],
            }, SQL {
              decoder: {
                mapFromDriverValue: [Function: mapFromDriverValue],
              },
              shouldInlineParams: false,
              queryChunks: [],
              append: [Function: append],
              toQuery: [Function: toQuery],
              buildQueryFromSourceParams: [Function: buildQueryFromSourceParams],
              mapInlineParam: [Function: mapInlineParam],
              getSQL: [Function: getSQL],
              as: [Function: as],
              mapWith: [Function: mapWith],
              inlineParams: [Function: inlineParams],
            }, StringChunk {
              value: [ "" ],
              getSQL: [Function: getSQL],
            }, SQL {
              decoder: {
                mapFromDriverValue: [Function: mapFromDriverValue],
              },
              shouldInlineParams: false,
              queryChunks: [
                StringChunk {
                  value: [ " where " ],
                  getSQL: [Function: getSQL],
                }, SQL {
                  decoder: [Object ...],
                  shouldInlineParams: false,
                  queryChunks: [
                    [Object ...]
                  ],
                  append: [Function: append],
                  toQuery: [Function: toQuery],
                  buildQueryFromSourceParams: [Function: buildQueryFromSourceParams],
                  mapInlineParam: [Function: mapInlineParam],
                  getSQL: [Function: getSQL],
                  as: [Function: as],
                  mapWith: [Function: mapWith],
                  inlineParams: [Function: inlineParams],
                }, StringChunk {
                  value: [ "" ],
                  getSQL: [Function: getSQL],
                }
              ],
              append: [Function: append],
              toQuery: [Function: toQuery],
              buildQueryFromSourceParams: [Function: buildQueryFromSourceParams],
              mapInlineParam: [Function: mapInlineParam],
              getSQL: [Function: getSQL],
              as: [Function: as],
              mapWith: [Function: mapWith],
              inlineParams: [Function: inlineParams],
            }, StringChunk {
              value: [ "" ],
              getSQL: [Function: getSQL],
            }, undefined, StringChunk {
              value: [ "" ],
              getSQL: [Function: getSQL],
            }, undefined, StringChunk {
              value: [ "" ],
              getSQL: [Function: getSQL],
            }, undefined, StringChunk {
              value: [ "" ],
              getSQL: [Function: getSQL],
            }, undefined, StringChunk {
              value: [ "" ],
              getSQL: [Function: getSQL],
            }, undefined, StringChunk {
              value: [ "" ],
              getSQL: [Function: getSQL],
            }
          ],
          append: [Function: append],
          toQuery: [Function: toQuery],
          buildQueryFromSourceParams: [Function: buildQueryFromSourceParams],
          mapInlineParam: [Function: mapInlineParam],
          getSQL: [Function: getSQL],
          as: [Function: as],
          mapWith: [Function: mapWith],
          inlineParams: [Function: inlineParams],
        }, StringChunk {
          value: [ ")" ],
          getSQL: [Function: getSQL],
        }
      ],
      append: [Function: append],
      toQuery: [Function: toQuery],
      buildQueryFromSourceParams: [Function: buildQueryFromSourceParams],
      mapInlineParam: [Function: mapInlineParam],
      getSQL: [Function: getSQL],
      as: [Function: as],
      mapWith: [Function: mapWith],
      inlineParams: [Function: inlineParams],
    },
    fieldAlias: "credentials",
    getSQL: [Function: getSQL],
    clone: [Function: clone],
  },
  relationTableTsKey: "credentials",
  isJson: true,
  selection: [
    {
      dbKey: "id",
      tsKey: "id",
      field: ,
      relationTableTsKey: undefined,
      isJson: false,
      selection: [],
    }, {
      dbKey: "userId",
      tsKey: "userId",
      field: ,
      relationTableTsKey: undefined,
      isJson: false,
      selection: [],
    }
  ],
}
rawSubRows undefined
275 |         tablesConfig,
276 |         tablesConfig[selectionItem.relationTableTsKey],
277 |         subRows,
278 |         selectionItem.selection,
279 |         mapColumnValue
280 |       ) : subRows.map(
                ^
TypeError: undefined is not an object (evaluating 'subRows.map')
      at mapRelationalRow (/Users/sammccord/work/drizzle-relations-repro/node_modules/drizzle-orm/relations.js:280:11)
      at map (:1:21)
      at /Users/sammccord/work/drizzle-relations-repro/node_modules/drizzle-orm/sqlite-core/query-builders/query.js:100:22
      at execute (/Users/sammccord/work/drizzle-relations-repro/node_modules/drizzle-orm/sqlite-core/query-builders/query.js:133:19)
      at then (/Users/sammccord/work/drizzle-relations-repro/node_modules/drizzle-orm/query-promise.js:21:12)

About

No description, website, or topics provided.

Resources

Readme
Activity

Stars

0 stars

Watchers

2 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages