xftp-server: support postgresql backend - #1755

#1755

Merged

epoberezkin merged 47 commits into

Apr 16, 2026

Commits on Apr 15, 2026

xftp: add PostgreSQL backend design spec
shumvgolove
committed
6ce9c61
Copy full SHA for 6ce9c61
update doc
shumvgolove
committed
a31e998
Copy full SHA for a31e998
adjust styling
shumvgolove
committed
0acd0c6
Copy full SHA for 0acd0c6
add implementation plan
shumvgolove
committed
ba6774e
Copy full SHA for ba6774e
refactor: move usedStorage from FileStore to XFTPEnv
shumvgolove
committed
0e3d133
Copy full SHA for 0e3d133
refactor: add getUsedStorage, getFileCount, expiredFiles store functions
shumvgolove
committed
b4aeb74
Copy full SHA for b4aeb74
refactor: change file store operations from STM to IO
shumvgolove
committed
aed8664
Copy full SHA for aed8664
refactor: extract FileStoreClass typeclass, move STM impl to Store.STM
shumvgolove
committed
b9fbdc7
Copy full SHA for b9fbdc7
refactor: make XFTPEnv and server polymorphic over FileStoreClass
shumvgolove
committed
cfb60f6
Copy full SHA for cfb60f6
feat: add PostgreSQL store skeleton with schema migration
shumvgolove
committed
7e97cc2
Copy full SHA for 7e97cc2
feat: implement PostgresFileStore operations
shumvgolove
committed
899dce7
Copy full SHA for 899dce7
feat: add PostgreSQL INI config, store dispatch, startup validation
shumvgolove
committed
4b5be92
Copy full SHA for 4b5be92
feat: add database import/export CLI commands
shumvgolove
committed
926362e
Copy full SHA for 926362e
test: add PostgreSQL backend tests
shumvgolove
committed
c736b45
Copy full SHA for c736b45
fix: map ForeignKeyViolation to AUTH in addRecipient
Show description for 3489554
shumvgolove
committed
3489554
Copy full SHA for 3489554
fix: only decrement usedStorage for uploaded files on expiration
Show description for a2a6f4c
shumvgolove
committed
a2a6f4c
Copy full SHA for a2a6f4c
fix: handle setFilePath error in receiveServerFile
Show description for 9b20525
shumvgolove
committed
9b20525
Copy full SHA for 9b20525
fix: escape double quotes in COPY CSV status field
Show description for f1528d8
shumvgolove
committed
f1528d8
Copy full SHA for f1528d8
fix: reject upload to blocked file in Postgres setFilePath
Show description for 1133ea1
shumvgolove
committed
1133ea1
Copy full SHA for 1133ea1
fix: add CHECK constraint on file_size > 0
Show description for 4b5ab9d
shumvgolove
committed
4b5ab9d
Copy full SHA for 4b5ab9d
fix: check for existing data before database import
Show description for 5cea36b
shumvgolove
committed
5cea36b
Copy full SHA for 5cea36b
fix: clean up disk file when setFilePath fails in receiveServerFile
Show description for 73b0de3
shumvgolove
committed
73b0de3
Copy full SHA for 73b0de3
fix: check storeAction result in deleteOrBlockServerFile_
Show description for fecb248
shumvgolove
committed
fecb248
Copy full SHA for fecb248
fix: check deleteFile result in expireServerFiles
Show description for e813044
shumvgolove
committed
e813044
Copy full SHA for e813044
refactor: merge STM store into Store.hs, parameterize server tests
Show description for 29a3960
shumvgolove
committed
29a3960
Copy full SHA for 29a3960
refactor: clean up per good-code review
Show description for 7f6902c
shumvgolove
committed
7f6902c
Copy full SHA for 7f6902c
test: parameterize XFTP server, agent and CLI tests over store backend
Show description for 7f8f8e0
shumvgolove
committed
7f8f8e0
Copy full SHA for 7f8f8e0
refactor: remove dead test wrappers after parameterization
Show description for c902004
shumvgolove
committed
c902004
Copy full SHA for c902004
feat: add manual tests and guide
shumvgolove
committed
918135f
Copy full SHA for 918135f
refactor: merge file_size CHECK into initial migration
shumvgolove
committed
835e968
Copy full SHA for 835e968
refactor: extract rowToFileRec shared by getFile sender/recipient paths
shumvgolove
committed
51de8a5
Copy full SHA for 51de8a5
refactor: parameterize XFTPServerConfig over store type
Show description for 2edc0ae
shumvgolove
committed
2edc0ae
Copy full SHA for 2edc0ae
refactor: minimize diff in tests
Show description for 5833a84
shumvgolove
committed
5833a84
Copy full SHA for 5833a84
refactor: restore getFile position to match master
shumvgolove
committed
aada451
Copy full SHA for aada451
refactor: rename withSTMFile back to withFile
shumvgolove
committed
fd83dd4
Copy full SHA for fd83dd4
refactor: close store log inside closeFileStore for STM backend
Show description for 8b34da4
shumvgolove
committed
8b34da4
Copy full SHA for 8b34da4
refactor: rename XFTPTestBracket to XFTPTestServer
shumvgolove
committed
66810c0
Copy full SHA for 66810c0
fix: move file_size check from PG schema to store log import
shumvgolove
committed
0d1cddb
Copy full SHA for 0d1cddb
refactor: use SQL-standard type names in XFTP schema
shumvgolove
committed
4aa2589
Copy full SHA for 4aa2589
perf: batch expired file deletions with deleteFiles
shumvgolove
committed
8f812c8
Copy full SHA for 8f812c8
refactor: stream export instead of loading recipients into memory
shumvgolove
committed
b25ec92
Copy full SHA for b25ec92
refactor: parameterize XFTP store with FSType singleton dispatch
shumvgolove
committed
bf7af13
Copy full SHA for bf7af13
refactor: minimize diff per review feedback
shumvgolove
committed
6d68d6b
Copy full SHA for 6d68d6b
refactor: use types over strings, deduplicate parser
shumvgolove
committed
168ea3e
Copy full SHA for 168ea3e
refactor: always parse database store type, fail at startup
shumvgolove
committed
849976a
Copy full SHA for 849976a
fix compilation without postgresql
shumvgolove
committed
cd2aec2
Copy full SHA for cd2aec2
refactor: always parse database store type, fail at startup
shumvgolove
committed
8a37341
Copy full SHA for 8a37341