m
5d96814853
- operations.operation_id/ref_id BIGINT (= id client pending_operations), UNIQUE(device_id, operation_id) idempotente ; migration 000004 corrigée + test
- service/sync.go : ApplyBatch séquentiel (no-op si déjà traitée ; create déjà présent / update/move sur ressource absente / delete absent = no-op) ;
arrêt à la première erreur non-idempotente (NAME_CONFLICT, NOT_FOUND, INVALID_REQUEST) + trace après succès ; ops share/share_link accusées sans état (V1)
- handlers/sync.go : POST /sync/ops → {applied, failed|null} ; GET /sync/permissions?after= → snapshot delta (effectiveAccess owner, cachedAt ms)
- snapshot : repo.ListOwned (delta updated_at en ms, trié) ; index partiel racine (owner_id, name) WHERE parent_id IS NULL
- GET /files sans folderId = racine uniquement (convention useFiles(undefined)) ; tests files_test corrigés (codes d'erreur imbriqués, tailles)
- fix dbtest : ping la connexion maintenance (création de la DB cible possible) — les tests handlers/repo tournent enfin contre PG réel
- tests handlers end-to-end : batch appliqué + retry idempotent, arrêt sur NAME_CONFLICT, delete idempotent, snapshot + delta
25 lines
1.2 KiB
SQL
25 lines
1.2 KiB
SQL
CREATE TABLE resources (
|
|
resource_id TEXT PRIMARY KEY CHECK (resource_id ~ '^[0-9a-f]{32}$'),
|
|
type TEXT NOT NULL CHECK (type IN ('file', 'folder')),
|
|
name TEXT NOT NULL,
|
|
parent_id TEXT REFERENCES resources(resource_id) ON DELETE CASCADE,
|
|
owner_id TEXT NOT NULL REFERENCES devices(device_id) ON DELETE CASCADE,
|
|
content_hash VARCHAR(128),
|
|
size_bytes BIGINT DEFAULT 0,
|
|
mime_type VARCHAR(255),
|
|
extension VARCHAR(64),
|
|
category VARCHAR(50) CHECK (category IN ('photo', 'video', 'document', 'audio', 'other')),
|
|
taken_at TIMESTAMPTZ,
|
|
created_at TIMESTAMPTZ DEFAULT NOW(),
|
|
updated_at TIMESTAMPTZ DEFAULT NOW(),
|
|
deleted_at TIMESTAMPTZ,
|
|
CONSTRAINT resources_unique_name_per_parent UNIQUE (parent_id, name)
|
|
);
|
|
|
|
CREATE INDEX idx_resources_owner ON resources(owner_id) WHERE deleted_at IS NULL;
|
|
CREATE INDEX idx_resources_parent ON resources(parent_id);
|
|
CREATE INDEX idx_resources_category ON resources(category) WHERE deleted_at IS NULL;
|
|
|
|
-- Unicité du nom à la racine (NULL ≠ NULL : la contrainte (parent_id,name)
|
|
-- ne couvre pas parent_id NULL).
|
|
CREATE UNIQUE INDEX idx_resources_root_name ON resources(owner_id, name) WHERE parent_id IS NULL; |