migs Comments - Answer Overflow

migs

Explore posts from servers

TTCTheo's Typesafe Cult DTDrizzle Team

Posts Comments

DTDrizzle Team

•Created by migs on 6/14/2024 in #help

TypeError: Cannot read properties of undefined (reading 'columns') - SQLite TursoDB

@Genio

8 replies

DTDrizzle Team

•Created by Genio on 6/24/2024 in #help

[ERROR] TypeError: Cannot read properties of undefined (reading 'toString')

We might have different problems, if you check my thread, I have also defined the relations with the drizzle api

17 replies

DTDrizzle Team

•Created by Genio on 6/24/2024 in #help

[ERROR] TypeError: Cannot read properties of undefined (reading 'toString')

Don't know if it's just with sqlite/turso but lately I've been having a lot of problems with migrations

17 replies

DTDrizzle Team

•Created by migs on 6/14/2024 in #help

TypeError: Cannot read properties of undefined (reading 'columns') - SQLite TursoDB

Created an issue on github https://github.com/drizzle-team/drizzle-kit-mirror/issues/470

8 replies

DTDrizzle Team

•Created by Kenpaffu on 6/16/2024 in #help

SQLITE error "Table already exists"

Same problem here, also getting problems using db:push with a new table with foreign keys

3 replies

DTDrizzle Team

•Created by The Fabulous Geek on 6/15/2024 in #help

Automating migration

The correct way of doing this is to generate the migration files locally, commit them and have the the migrations being run on your CI/CD

2 replies

DTDrizzle Team

•Created by migs on 6/14/2024 in #help

TypeError: Cannot read properties of undefined (reading 'columns') - SQLite TursoDB

Looks like if I push without the foreign keys, it works, and if I add the foreign keys after the table already exists it will work. The problem seems to happen when you create a table with foreign keys from the beggining

8 replies

DTDrizzle Team

•Created by migs on 6/14/2024 in #help

TypeError: Cannot read properties of undefined (reading 'columns') - SQLite TursoDB

This is the table I added that causes the problem, I might be missing something but I don't see anything wrong in it. If I remove this table and push again it will correctly apply changes, but I can't push when I add this table. Must be something wrong on this table

export const discountUses = sqLiteTable(
  "discountUse",
  {
    id: integer("id", { mode: "number" }).primaryKey({ autoIncrement: true }),
    discountId: integer("discountId")
      .references(() => storeDiscounts.id, {
        onDelete: "cascade",
      })
      .notNull(),
    invoiceId: text("invoiceId")
      .references(() => storeInvoices.id, {
        onDelete: "cascade",
      })
      .notNull(),
  },
  (discountUse) => ({
    discountUse_id_idxIdIdx: index("discountUse_id_idx").on(discountUse.id),
  }),
);

export const discountUsesRelations = relations(discountUses, ({ one }) => ({
  discount: one(storeDiscounts, {
    fields: [discountUses.discountId],
    references: [storeDiscounts.id],
  }),
  invoice: one(storeInvoices, {
    fields: [discountUses.invoiceId],
    references: [storeInvoices.id],
  }),
}));

export const discountUses = sqLiteTable(
  "discountUse",
  {
    id: integer("id", { mode: "number" }).primaryKey({ autoIncrement: true }),
    discountId: integer("discountId")
      .references(() => storeDiscounts.id, {
        onDelete: "cascade",
      })
      .notNull(),
    invoiceId: text("invoiceId")
      .references(() => storeInvoices.id, {
        onDelete: "cascade",
      })
      .notNull(),
  },
  (discountUse) => ({
    discountUse_id_idxIdIdx: index("discountUse_id_idx").on(discountUse.id),
  }),
);

export const discountUsesRelations = relations(discountUses, ({ one }) => ({
  discount: one(storeDiscounts, {
    fields: [discountUses.discountId],
    references: [storeDiscounts.id],
  }),
  invoice: one(storeInvoices, {
    fields: [discountUses.invoiceId],
    references: [storeInvoices.id],
  }),
}));

8 replies

DTDrizzle Team

•Created by g0053 on 4/19/2024 in #help

Drizzle Kit Studio: Object is not iterable

all fixed on my side too. The only small detail I've noticed is that the db:push always says "Changes Applied" even when there's no changes. It used to be able to distinguish this

25 replies

DTDrizzle Team

•Created by migs on 4/21/2024 in #help

Field 'email' doesn't have a default with connection pool in MySQL

Fixed it. I had a custom scope on next auth for discord that was missing the email scope. Removed it so it uses the default scopes

2 replies

DTDrizzle Team

•Created by g0053 on 4/19/2024 in #help

Drizzle Kit Studio: Object is not iterable

for some reason its still not fixed for me, maybe pnpm is caching something from the previous one and I just updated to 20.17

25 replies

Gaming

Programming