© 2026 Hedgehog Software, LLC
export const dailyStats = pgTable( "daily_stats", { ad_id: text("ad_id") .references(() => ads.id) .primaryKey(), created_at: timestamp("created_at").notNull().defaultNow(), updated_at: timestamp("updated_at").notNull().defaultNow(), date: date("date").notNull(), ...statObject, }, (t) => ({ ad_and_date: uniqueIndex("ad_and_date").on(t.ad_id, t.date), }) );
await db .insert(dailyStats) .values({ ad_id: dbAd.id, date: date.toISOString(), ...dailyStatsInsert, }) .onConflictDoUpdate({ target: [dailyStats.ad_id, dailyStats.date], set: dailyStatsInsert, });
duplicate key value violates unique constraint
target
onConflictDoUpdate