Jaymal
Jaymal
PostsComments
DTDrizzle Team
Created by Jaymal on 4/4/2024 in #help
Timestamp formatted differently if fetched as relation rather than directly
Done, I appreciate the support 🙂
19 replies
DTDrizzle Team
Created by Jaymal on 4/4/2024 in #help
Timestamp formatted differently if fetched as relation rather than directly
Cool - have created an issue here - https://github.com/drizzle-team/drizzle-orm/issues/2282. I've just linked to this thread atm, but I can copy in the detail if that's helpful?
19 replies
DTDrizzle Team
Created by Jaymal on 4/4/2024 in #help
Timestamp formatted differently if fetched as relation rather than directly
@Dan Kochetov I've put ... to hide fields which shouldn't be relevant. Hopefully that's enough for you to go on?
19 replies
DTDrizzle Team
Created by Jaymal on 4/4/2024 in #help
Timestamp formatted differently if fetched as relation rather than directly
Farms schema: 
export const farmsTable = pgTable(
  "farms",
  {
    id: uuid("id").defaultRandom().primaryKey().notNull(),
    ...
    createdAt: timestamp("created_at", { withTimezone: true, mode: "string" }).defaultNow().notNull(),
    updatedAt: timestamp("updated_at", { withTimezone: true, mode: "string" }).defaultNow().notNull(),
  },
  (table) => {
    return {
      ownerIdx: index("farms_owner_idx").on(table.ownerId),
    };
  },
);

export const farmsRelations = relations(farmsTable, ({ one, many }) => ({
  assessments: many(assessmentsTable),
  owner: one(usersTable, {
    fields: [farmsTable.ownerId],
    references: [usersTable.id],
  }),
}));
export const farmsTable = pgTable(
  "farms",
  {
    id: uuid("id").defaultRandom().primaryKey().notNull(),
    ...
    createdAt: timestamp("created_at", { withTimezone: true, mode: "string" }).defaultNow().notNull(),
    updatedAt: timestamp("updated_at", { withTimezone: true, mode: "string" }).defaultNow().notNull(),
  },
  (table) => {
    return {
      ownerIdx: index("farms_owner_idx").on(table.ownerId),
    };
  },
);

export const farmsRelations = relations(farmsTable, ({ one, many }) => ({
  assessments: many(assessmentsTable),
  owner: one(usersTable, {
    fields: [farmsTable.ownerId],
    references: [usersTable.id],
  }),
}));
Assessment schema: 
export const assessmentsTable = pgTable(
  "assessments",
  {
    id: uuid("id").defaultRandom().primaryKey().notNull(),
    ...
    farmId: uuid("farm_id")
      .references(() => farmsTable.id)
      .notNull(),
  },
  (table) => {
    return {
      farmIdx: index("assessments_farm_idx").on(table.farmId),
    };
  },
);

export const assessmentsRelations = relations(assessmentsTable, ({ one, many }) => ({
  ...
  farm: one(farmsTable, {
    fields: [assessmentsTable.farmId],
    references: [farmsTable.id],
  }),
}));
export const assessmentsTable = pgTable(
  "assessments",
  {
    id: uuid("id").defaultRandom().primaryKey().notNull(),
    ...
    farmId: uuid("farm_id")
      .references(() => farmsTable.id)
      .notNull(),
  },
  (table) => {
    return {
      farmIdx: index("assessments_farm_idx").on(table.farmId),
    };
  },
);

export const assessmentsRelations = relations(assessmentsTable, ({ one, many }) => ({
  ...
  farm: one(farmsTable, {
    fields: [assessmentsTable.farmId],
    references: [farmsTable.id],
  }),
}));
19 replies
DTDrizzle Team
Created by Jaymal on 4/4/2024 in #help
Timestamp formatted differently if fetched as relation rather than directly
Query for standalone farm: 
await this.dbClient.query.farmsTable.findFirst({
        where: (farm, { sql }) => sql`${farm.id} = ${id}::UUID`,
        with: {
          owner: true,
        },
        columns: {
          ownerId: false,
        },
      });
await this.dbClient.query.farmsTable.findFirst({
        where: (farm, { sql }) => sql`${farm.id} = ${id}::UUID`,
        with: {
          owner: true,
        },
        columns: {
          ownerId: false,
        },
      });
Query for assessment with farm: 
await this.dbClient.query.assessmentsTable.findFirst({
        where: (assessments, { sql }) => sql`${assessments.id} = ${id}::UUID`,
        with: {
          runs: true,
          createdBy: true,
          farm: {
            with: {
              owner: true,
            },
            columns: {
              ownerId: false,
            },
          },
        },
        columns: {
          pathwayId: false,
          createdById: false,
          farmId: false,
        },
      });
await this.dbClient.query.assessmentsTable.findFirst({
        where: (assessments, { sql }) => sql`${assessments.id} = ${id}::UUID`,
        with: {
          runs: true,
          createdBy: true,
          farm: {
            with: {
              owner: true,
            },
            columns: {
              ownerId: false,
            },
          },
        },
        columns: {
          pathwayId: false,
          createdById: false,
          farmId: false,
        },
      });
19 replies
DTDrizzle Team
Created by Jaymal on 4/4/2024 in #help
Timestamp formatted differently if fetched as relation rather than directly
Sure, the entity in question here is a "Farm", which also has a 1 to many relationship with an "Assessment". We can either fetch this from the "farm" table as a standalone object (in which the timestamp appears to be formatted incorrectly), or we can fetch an "Assessment" from the "assessment" table "with" its corresponding "Farm" (in which case the timestamp is formatted correctly).
19 replies
DTDrizzle Team
Created by Jaymal on 4/4/2024 in #help
Timestamp formatted differently if fetched as relation rather than directly
Thanks that's good to know. Do you have a triage process/a rough idea when we could expect a fix for it?
19 replies
DTDrizzle Team
Created by Jaymal on 4/4/2024 in #help
Timestamp formatted differently if fetched as relation rather than directly
@Dan Kochetov @alexblokh are you able to help with the issue above please?
19 replies
DTDrizzle Team
Created by Jaymal on 4/4/2024 in #help
Timestamp formatted differently if fetched as relation rather than directly
@Aaroned have you come across something like this before? Or know who may be the person to ask?
19 replies