Drizzle TeamDT
Drizzle Team•14mo ago
nico

SQLite insert schema does not include nullable columns?

Hi, I am just tring out Drizzle with SQLite, but am running into some weird problem.
I created a table like this 
export const products = sqliteTable(
  "products_table",
  {
    id: int().primaryKey(),
    name: text().notNull(),
    type: text(),
    sku: text(),
    externalId: text("external_id").notNull().unique(),
    price: text(),
    regularPrice: text("regular_price"),
    salePrice: text("sale_price"),
    manageStock: int("manage_stock", { mode: "boolean" }),
    stockQuantity: int("stock_quantity"),
  },
  (table) => {
    return {
      nameIdx: index("sku_idx").on(table.sku),
    };
  }
);


Now when I infer the insert schema, or just try to insert data, typescript allways throws an error as it expects this schema:
{
    name: string;
    sku: string;
    price: string;
    regularPrice: string;
}


It seems like to only includes columns that are not optional (and indexed clumns). This is preventing me from buildung my application as typescript allways throws when I try to insert data into the db.

Does someone know why this happens and how to prevent it?
Was this page helpful?