DT
Drizzle Team

help

sqliteTable wrapper which modifies fields, with proper types

Ttacomanator
View on Discord
4/12/2023
More of a TypeScript question, but I'm trying to create a wrapper for sqliteTable to add a set of standard fields (and keys) to the fields provided: 
import { sqliteTable, SQLiteTableFn } from "drizzle-orm/sqlite-core"

const extraFields = { ... }

const wrapper: SQLiteTableFn = (name, fields, keys) => {
  return sqliteTable(
    name,
    { ...extraFields, ...fields },
    (Table) => ({ ...keys })
  );
};
import { sqliteTable, SQLiteTableFn } from "drizzle-orm/sqlite-core"

const extraFields = { ... }

const wrapper: SQLiteTableFn = (name, fields, keys) => {
  return sqliteTable(
    name,
    { ...extraFields, ...fields },
    (Table) => ({ ...keys })
  );
};
This results in a type error on wrapper as the generics applied to SQLiteTableFn and the return value of wrapper return value sqliteTable on modified fields) no longer correspond. How can I create a type for wrapper which returns object properly typed?
UUUnknown User
View on Discord
4/12/2023
Message Not Public
Sign In & Join Server To View
Ttacomanator
View on Discord
4/13/2023
I was doing something like that previously, but my goal is to create a function which returns two tables: one with the fields as is, and a second table with extra fields added. The part I am struggling with is the return type of table2, which is intended to be the modified version of the second table. 
const [table1, table2] = wrapper("name", { {/* fields */} })
const [table1, table2] = wrapper("name", { {/* fields */} })

Looking for more? Join the community!

DT
Drizzle Team

help

Join Server
Want results from more Discord servers?
Add your server
Recommended Posts
How to count joined table?I'm trying to count rows returned by join for a query, basically the same as this: https://dba.stackConfig in Typescript?Hello, after upgrading drizzle-kit to 0.17.4 my `drizzle.config.ts` file stopped working. Is it now Problem running a migrationHello there, I'm currently facing an issue with a database migration. I have two simple tables definHow do I connect to sqlite on fly.io?I followed the instructions on fly.io on how to setup a project using sqlite. I believe I did it allEnumsCan pgEnum be converted to zod enums?Typescript build fails with large number of columnsI have a table with ~460 columns, and on trying to run typescript on my app, I'm getting "error TS25