Apiflow

0 Fork 0

T

Claude c5b0896bb4 fix: dedupe foucad rows by foucode before full refresh

The source MSSQL FOUCAD table can return several rows for the same
FOUCODE, but the PostgreSQL foucad table uses foucode as PRIMARY KEY.
The bulk INSERT in fullRefresh has no conflict handling, so duplicate
FOUCODE values triggered:

  duplicate key value violates unique constraint "foucad_pkey"

Deduplicate by foucode before insert, keeping the most recently
modified row (suividatemodif). Routes join foucad 1:1 on foucode, so
one config row per supplier code is the intended shape.

Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_011ad1qwhDEHNniSUDveTQHL

2026-06-29 06:30:00 +00:00

postgres

feat: initialize Postgres schema and set up core API routing for articles and photos

2026-05-06 11:30:03 +02:00

src

fix: use preference = 1 (integer) instead of true (boolean) in artfou1 joins

2026-05-21 16:14:52 +02:00

sync

fix: dedupe foucad rows by foucode before full refresh

2026-06-29 06:30:00 +00:00

.env.docker.example

Initial commit : API Node.js + PostgreSQL + sync service Docker