3 commits

Author	SHA1	Message	Date
dullbananas	bb63eaa794	Improve migration diff check and fix old migrations (#5204) ... * Update schema.rs * rename * stuff * finish new implementation of schema_setup::run (not including revert, test, etc.) * fmt * refactor * fix sql * migriation run command * use trigger on migrations table * add Options with disable_migrations field for test * rename to enable_forbid_diesel_cli_trigger * fix * fix merge * diff_checker (partial) * Revert "diff_checker (partial)" This reverts commit 6709882e14. * Revert "Revert "diff_checker (partial)"" This reverts commit d4bdda5d11. * diff check * improve schema diff * timestamp replacement * ignore column order * remove fedi_name default * stuff * improve diff * stuff * attempt parallel pg_dump * attempt 2 * Revert "attempt 2" This reverts commit a909d2d643. * Revert "attempt parallel pg_dump" This reverts commit 592a127954. * improve diff check * finish fixing migrations * stuff * use advisory lock * stuff * Update lib.rs * fmt * fmt * clippy * Update diff_check.rs * Update .woodpecker.yml * Update lib.rs * Update lib.rs * Update lib.rs * Update .woodpecker.yml * Update .woodpecker.yml * Update lib.rs * re-run ci * fmt * fmt * Update .woodpecker.yml * Update .woodpecker.yml * create separate database in ci * Update .woodpecker.yml * Update .woodpecker.yml * Update .woodpecker.yml * Update .woodpecker.yml * try to fix env var * Update diff_check.rs * Remove condition that's not needed anymore * clippy * exclude views and fast tables * revert some migration changes * fix * fmt * re-attempt checking character after skipped trigger name, and make code less confusing * fmt * fix * rerun ci * rerun ci * fix strip_prefix order * fix weird big Cargo.lock change by running `git checkout upstream/main Cargo.lock` then letting it auto update again * fix * remove installation commands that were removed in main branch * Revert "remove installation commands that were removed in main branch" This reverts commit fd65234a76. * move create_database_user woodpecker step to make diff less weird * Fix migration duplication caused by merge * optimize * Merge remote-tracking branch 'upstream/main' into new-migration-diff-check * fmt * Revert "fmt" This reverts commit 7d5652945f. * Revert "Merge remote-tracking branch 'upstream/main' into new-migration-diff-check" This reverts commit 28bb1c7497. * fmt * move diff dependency to db_schema_file * stuff * revert some migration changes * stuff * refactor pair selection * fix all migrations * clippy * stuff * remove thing from removed dbg * remove use of BTreeSet::difference * trim_matching_chunks_at_beginning_and_end * use sorted_unstable itertools method * display_diffs * use aho-corasick for chunk filtering * fsync=off * remove some unimportant optimizations * Revert "remove some unimportant optimizations" This reverts commit f8d88ddcce. * Revert "use aho-corasick for chunk filtering" This reverts commit 6b1f3e4416. * remove some unimportant optimizations * refactor diff_check.rs * clippers	2025-06-16 11:35:41 -04:00
Dessalines	be1389420b	Adding SQL format checking via pg_format / pgFormatter (#3740) ... * SQL format checking, 1. * SQL format checking, 2. * SQL format checking, 3. * SQL format checking, 4. * SQL format checking, 5. * Running pg_format * Getting rid of comment. * Upping pg_format version. * Using git ls-files for sql format check. * Fixing sql lints. * Addressing PR comments.	2023-08-02 12:44:51 -04:00
Nutomic	e9e76549a8	Split activity table into sent and received parts (fixes #3103) (#3583) ... * Split activity table into sent and received parts (fixes #3103) The received activities are only stored in order to avoid processing the same incoming activity multiple times. For this purpose it is completely unnecessary to store the data. So we can split the table into sent_activity and received_activity parts, where only sent_activity table needs to store activity data. This should reduce storage use significantly. Also reduces activity storage duration to three months, we can reduce this further if necessary. Additionally the id columns of activity tables are removed because they are completely unused and risk overflowing (fixes #3560). * address review * move insert_received_activity() methods to verify handlers * remove unnecessary conflict line * clippy * use on conflict, add tests	2023-07-14 11:17:06 -04:00