6 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
adisbladis	e0af3a292e	Only create ltree postgres extension in migration if doesn't already exist (#3092)	2023-06-14 17:03:10 -04:00
Charles Hall	f43bb454c3	stop requiring superuser to run migrations (#3002) ... Fixes <https://github.com/LemmyNet/lemmy/issues/2863>.	2023-06-14 07:54:12 -04:00
Dessalines	70c549dad8	Speeding up comment-ltree migration, fixing index creation. Fixes #2664 (#2670) ... * Speeding up comment-ltree migration, fixing index creation. Fixes #2664 * Adding some logging lines, fixing for missing posts. * Adding more postgres config	2023-01-23 09:59:25 -05:00
Dessalines	9c3efe32e7	First pass at adding comment trees. (#2362) ... * First pass at adding comment trees. - Extracted comment replies into its own table. - Added ltree column to comment - Added parent_id param to GetComments to fetch a tree branch - No paging / limiting yet * Adding child_count to comment_aggregates. * Adding parent comment update counts * Fix unit tests. * Comment tree paging mostly done. * Fix clippy * Fix drone tests wrong postgres version. * Fix unit tests. * Add back in delete in unit test. * Add postgres upgrade script. * Fixing some PR comments. * Move update ltree into Comment::create * Updating based on comments. * Fix send soft fail.	2022-07-30 05:55:59 +02:00