carlos Comments - Answer Overflow

carlos

Explore posts from servers

•Created by carlos on 8/11/2023 in #help

There is not enough information to infer relation

export const historyRelations = relations(histories, ({ many }) => ({
  files: many(historyFiles),
}));

export const filesRelations = relations(historyFiles, ({ one }) => ({
  history: one(histories, {
    fields: [historyFiles.historyId],
    references: [histories.id],
  }),
}));

export const historyRelations = relations(histories, ({ many }) => ({
  files: many(historyFiles),
}));

export const filesRelations = relations(historyFiles, ({ one }) => ({
  history: one(histories, {
    fields: [historyFiles.historyId],
    references: [histories.id],
  }),
}));

5 replies

DTDrizzle Team

•Created by carlos on 8/11/2023 in #help

There is not enough information to infer relation

was missing the relation on the other side

5 replies

DTDrizzle Team

•Created by carlos on 8/11/2023 in #help

There is not enough information to infer relation

got it

5 replies

DTDrizzle Team

•Created by carlos on 5/12/2023 in #help

schema generates wrong index

"drizzle-orm": "^0.23.13",
"drizzle-kit": "^0.17.4",

"drizzle-orm": "^0.23.13",
"drizzle-kit": "^0.17.4",

5 replies

DTDrizzle Team

•Created by carlos on 5/12/2023 in #help

schema generates wrong index

export const histories = pgTable('histories', {
  id: serial('id').primaryKey(),
  medicalHistoryNumber: text('medical_history_number').notNull(),
  doctor: text('doctor').notNull(),
  division: text('division').notNull(),
  comments: text('comments').notNull(),
  date: timestamp('date').notNull(),
  type: historyTypeEnum('type').notNull(),
  state: historyStateEnum('state').notNull(),
  creatorId: integer('creator_id')
    .references(() => users.id)
    .notNull(),

  hospitalId: integer('hospital_id')
    .references(() => organizations.id)
    .notNull(),
  providerId: integer('provider_id')
    .references(() => organizations.id)
    .notNull(),

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});

export const historyFiles = pgTable('history_files', {
  id: serial('id').primaryKey(),
  fileId: integer('file_id')
    .references(() => files.id)
    .notNull(),
  historyId: integer('history_id')
    .references(() => histories.id)
    .notNull(),

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});

export const files = pgTable('files', {
  id: serial('id').primaryKey(),
  filename: text('filename').notNull(),
  key: text('key').notNull(),
  uploadedBy: integer('uploaded_by')
    .references(() => users.id)
    .notNull(),
  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});

export const histories = pgTable('histories', {
  id: serial('id').primaryKey(),
  medicalHistoryNumber: text('medical_history_number').notNull(),
  doctor: text('doctor').notNull(),
  division: text('division').notNull(),
  comments: text('comments').notNull(),
  date: timestamp('date').notNull(),
  type: historyTypeEnum('type').notNull(),
  state: historyStateEnum('state').notNull(),
  creatorId: integer('creator_id')
    .references(() => users.id)
    .notNull(),

  hospitalId: integer('hospital_id')
    .references(() => organizations.id)
    .notNull(),
  providerId: integer('provider_id')
    .references(() => organizations.id)
    .notNull(),

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});

export const historyFiles = pgTable('history_files', {
  id: serial('id').primaryKey(),
  fileId: integer('file_id')
    .references(() => files.id)
    .notNull(),
  historyId: integer('history_id')
    .references(() => histories.id)
    .notNull(),

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});

export const files = pgTable('files', {
  id: serial('id').primaryKey(),
  filename: text('filename').notNull(),
  key: text('key').notNull(),
  uploadedBy: integer('uploaded_by')
    .references(() => users.id)
    .notNull(),
  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});

5 replies

DTDrizzle Team

•Created by carlos on 5/1/2023 in #help

inArray

   const [selectHistories, countHistories] = await Promise.all([
      state.length ? await db.with(main).select().from(main).where(inArray(histories.state, state)) : await db.with(main).select().from(main),

   const [selectHistories, countHistories] = await Promise.all([
      state.length ? await db.with(main).select().from(main).where(inArray(histories.state, state)) : await db.with(main).select().from(main),

3 replies

DTDrizzle Team

•Created by carlos on 5/1/2023 in #help

inArray

i don't want to do this :/

  const main = db.$with('main').as(
      db
        .select({
          id: histories.id,
          medicalHistoryNumber: histories.medicalHistoryNumber,
          date: histories.date,
          type: histories.type,
          division: histories.division,
          state: histories.state,
          provider: {
            id: provider.id,
            name: provider.name,
          },
          hospital: {
            id: hospital.id,
            name: hospital.name,
          },
        })
        .from(histories)
        .leftJoin(hospital, eq(histories.hospitalId, hospital.id))
        .leftJoin(provider, eq(histories.providerId, provider.id))
        .where(or(eq(histories.hospitalId, req.session.user?.hospitalId!), eq(histories.providerId, req.session.user?.providerId!)))
        .orderBy(desc(histories.id))
        .limit(Number(limit))
        .offset(Number(offset)),
    );

  const main = db.$with('main').as(
      db
        .select({
          id: histories.id,
          medicalHistoryNumber: histories.medicalHistoryNumber,
          date: histories.date,
          type: histories.type,
          division: histories.division,
          state: histories.state,
          provider: {
            id: provider.id,
            name: provider.name,
          },
          hospital: {
            id: hospital.id,
            name: hospital.name,
          },
        })
        .from(histories)
        .leftJoin(hospital, eq(histories.hospitalId, hospital.id))
        .leftJoin(provider, eq(histories.providerId, provider.id))
        .where(or(eq(histories.hospitalId, req.session.user?.hospitalId!), eq(histories.providerId, req.session.user?.providerId!)))
        .orderBy(desc(histories.id))
        .limit(Number(limit))
        .offset(Number(offset)),
    );