Apiflow

70 Commits 4 Branches 0 Tags

3 Commits

Include renames

Author	SHA1	Message	Date
MichaelandClaude Opus 4.8	adc8d357c9	fix: dedupe cube_pa rows by artnoid before full refresh Cube_PA is a heap in SQL Server with no primary key, while the PostgreSQL cube_pa table uses artnoid as PRIMARY KEY. The cube normally emits one row per article, but for 3 articles supplied by two vendors it emitted both vendor prices, so fullRefresh hit: duplicate key value violates unique constraint "cube_pa_pkey" These are not exact duplicates: the two rows carry different PA values, so the choice changes the article's purchase price. Resolve by keeping the price whose last change is the most recent, read from the dated history packed into ARTFOU2.PRIXACHAT ("[01/01/1901,0.990:16/05/2018,1.010]"). SUIVIDATEMODIF cannot be used alone: it is not touched when only the price changes (S028 shows modif 2017 but a price change in 2025). It only breaks ties. The lookup runs solely when duplicates are present, so the nightly sync is unaffected in the normal case. Verified against the live 427 752-row Cube_PA: 427 749 rows out, all artnoid distinct, no fallback triggered. Parsing PRIXACHAT over 20 000 ARTFOU2 rows: 19 999 parsed, 1 empty, 0 failures. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>	2026-07-10 12:30:49 +02:00
Michael	984ed4da5f	Fix sync: null bytes, BIT→SMALLINT, DECIMAL complex types, NbJours safe int, error_msg column	2026-03-18 11:03:29 +01:00
MichaelandClaude Sonnet 4.6	d565ed9f10	Initial commit : API Node.js + PostgreSQL + sync service Docker - API Express/pg connectée à PostgreSQL (converti depuis mssql) - 8 routes : articles, fournisseurs, commandes, stock, mouvements, performance, schema, sync - Service sync nightly (mssql → pg, cron 3h00) - Docker Compose : postgres + api + sync + frpc (tunnel sortant) - Schéma PostgreSQL 17 tables dans postgres/init.sql Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-18 10:10:47 +01:00

Author

SHA1

Message

Date

MichaelandClaude Opus 4.8

adc8d357c9

fix: dedupe cube_pa rows by artnoid before full refresh

Cube_PA is a heap in SQL Server with no primary key, while the
PostgreSQL cube_pa table uses artnoid as PRIMARY KEY. The cube
normally emits one row per article, but for 3 articles supplied by
two vendors it emitted both vendor prices, so fullRefresh hit:

  duplicate key value violates unique constraint "cube_pa_pkey"

These are not exact duplicates: the two rows carry different PA
values, so the choice changes the article's purchase price. Resolve
by keeping the price whose last change is the most recent, read from
the dated history packed into ARTFOU2.PRIXACHAT
("[01/01/1901,0.990:16/05/2018,1.010]"). SUIVIDATEMODIF cannot be
used alone: it is not touched when only the price changes (S028 shows
modif 2017 but a price change in 2025). It only breaks ties.

The lookup runs solely when duplicates are present, so the nightly
sync is unaffected in the normal case.

Verified against the live 427 752-row Cube_PA: 427 749 rows out, all
artnoid distinct, no fallback triggered. Parsing PRIXACHAT over 20 000
ARTFOU2 rows: 19 999 parsed, 1 empty, 0 failures.

Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>

2026-07-10 12:30:49 +02:00

Michael

984ed4da5f

Fix sync: null bytes, BIT→SMALLINT, DECIMAL complex types, NbJours safe int, error_msg column

2026-03-18 11:03:29 +01:00

MichaelandClaude Sonnet 4.6

d565ed9f10

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

- API Express/pg connectée à PostgreSQL (converti depuis mssql)
- 8 routes : articles, fournisseurs, commandes, stock, mouvements, performance, schema, sync
- Service sync nightly (mssql → pg, cron 3h00)
- Docker Compose : postgres + api + sync + frpc (tunnel sortant)
- Schéma PostgreSQL 17 tables dans postgres/init.sql

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

2026-03-18 10:10:47 +01:00