many-to-one transaction with select API and Postgres
Hey! I am trying to make a many-to-one transaction with my Postgres database and the select API. Here are some of my table definitions
(I'm sending query in the next message)
export const game = pgTable('game', {
id: varchar('id', { length: 21 })
.primaryKey()
.default(sql.raw(`generate_pri('${ID_PREFIXES.game}')`)),
});
export const game_config = relations(game, ({ one, many }) => ({
goals: many(goal),
}));
export const goal = pgTable('goal', {
id: varchar('id', { length: 21 })
.primaryKey()
.default(sql.raw(`generate_pri('${ID_PREFIXES.goal}')`)),
number: serial('number'),
event_player_id: varchar('event_player_id', { length: 21 }).references(() => event_player.id),
game_id: varchar('game_id', { length: 21 }).references(() => game.id),
});
export const goal_config = relations(goal, ({ one }) => ({
game: one(game, {
fields: [goal.game_id],
references: [game.id]
})
}));export const game = pgTable('game', {
id: varchar('id', { length: 21 })
.primaryKey()
.default(sql.raw(`generate_pri('${ID_PREFIXES.game}')`)),
});
export const game_config = relations(game, ({ one, many }) => ({
goals: many(goal),
}));
export const goal = pgTable('goal', {
id: varchar('id', { length: 21 })
.primaryKey()
.default(sql.raw(`generate_pri('${ID_PREFIXES.goal}')`)),
number: serial('number'),
event_player_id: varchar('event_player_id', { length: 21 }).references(() => event_player.id),
game_id: varchar('game_id', { length: 21 }).references(() => game.id),
});
export const goal_config = relations(goal, ({ one }) => ({
game: one(game, {
fields: [goal.game_id],
references: [game.id]
})
}));(I'm sending query in the next message)
