7693f76e75
Merge remote-tracking branch 'origin' into search_combined
2025-01-21 10:02:46 -05:00
dullbananas
6f05254aae
Prevent incorrectly using delete instead of uplete ( #5331 )
...
* implement check and test it by modifying PostLike::remove
* revert change in PostLike::remove
2025-01-21 09:52:18 -05:00
25920ad8b4
Adding search_combined.score column, and DB triggers.
2025-01-20 16:16:28 -05:00
a11f97e3a6
Merge remote-tracking branch 'origin/main' into search_combined
2025-01-17 18:46:34 -05:00
67b36c6537
Add support for donation dialog ( fixes #4856 ) ( #5318 )
...
* Add support for donation dialog (fixes #4856 )
* more changes
* test
* remove files
* default value for new user last_donation_notification
* move disable_donation_dialog to local_site
* restore formatting
2025-01-17 07:28:41 -05:00
dd66ef57b8
Fixing search result, running clippy.
2025-01-16 15:01:11 -05:00
66a8823068
Merge remote-tracking branch 'origin/main' into search_combined
2025-01-16 14:17:21 -05:00
dullbananas
4120c2fc2f
Changes to get_random_community_id: add filters for nsfw and private, use algorthm that doesn't scan the entire table ( #5267 )
...
* get_random_community_id: add filters for nsfw and private, use algorithm that doesn't scan the entire table
* only call random_smallint once for filter
* change migration date
* make random_smallint function work in postgresql 16
* replace "32768 + 32767 + 1" with "65536" and improve comments
---------
Co-authored-by: Dessalines <dessalines@users.noreply.github.com>
2025-01-16 14:16:57 -05:00
flamingos-cant
099328a5b1
Add media filter setting ( #5325 )
...
* Add hide_media filter
* Test media is returned when hide_media is false
* Add GIN index
* SQL fmt
* Drop GIN index in migration
2025-01-16 12:57:58 +01:00
efbd329b23
Formatting sql 2.
2025-01-15 15:09:03 -05:00
60e31b6dbb
Merge branch 'combined_inbox' into search_combined
2025-01-15 15:00:29 -05:00
Dessalines
3f06317878
Adding combined inbox ( #5257 )
...
* Renaming person_mention to person_comment_mention.
* Finishing up post body mentions.
* Combined tables try 2
* Finishing up combined report table.
* Fix ts optionals.
* Adding tests, triggers, and history updates for report_combined.
* Adding profile.
* Add cursor pagination to report_combined view (#5244 )
* add pagination cursor
* store timestamp instead of id in cursor (partial)
* Revert "store timestamp instead of id in cursor (partial)"
This reverts commit 89359dde4b
.
* use paginated query builder
* Fixing migration and paged API.
* Using dullbananas trigger procedure
* Removing pointless list routes, reorganizing tests.
* Fixing column XOR check.
* Forgot to remove list report actions.
* Cleanup.
* Use internal tagging.
* Fixing api tests.
* Adding a few indexes.
* Fixing migration name.
* Fixing unique constraints.
* Addressing PR comments.
* Start working on profile combined
* Adding views and replaceable schema.
* A few changes to profile view.
- Separating the profile fetch from its combined content fetch.
- Starting to separate saved_only into its own combined view.
* Finishing up combined person_saved and person_content.
* Fixing api tests.
* Moving to api-v4 routes.
* Fixing imports.
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update migrations/2024-12-02-181601_add_report_combined_table/up.sql
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update migrations/2024-12-02-181601_add_report_combined_table/up.sql
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Fixing import and fmt.
* Fixing null types in postgres.
* Comment out err.
* Fixing TS issues.
* Adding types, fixing allow and blocklist crud.
* Starting to work on combined views.
* Using dullbananas trigger procedure
* Adding the full combined view queries.
* Adding tests.
* taplo fmt.
* Upgrading package.json deps.
* Updating pnpm
* Most of the bulk work done, need to add tests yet.
* Finishing up inbox.
* Using assert_length
* Fixing sql_format.
* Running fmt.
* Fixing cargo shear.
* Fixing clippy.
* Addressing PR comments.
* Removing serialization
* Removing serialization
* Fixing duped trigger.
* Remove saved_only test.
* Remove pointless post_tags types.
* Remove pointless index.
* Changing published to saved for person_saved_combined.
* Removing comment.
* Renaming modlog when_ columns to published.
- Fixes #5312
* Adding strum and simplifying imports.
* Avoiding clone in map_to_enum
* Changing modded_person to other_person.
* Update crates/db_views_moderator/src/modlog_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views_moderator/src/modlog_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views_moderator/src/modlog_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Addressing PR comments.
* Fixing split.
* Revert "Adding strum and simplifying imports."
This reverts commit 15f1671107
.
* Running fmt.
* Using assert + matches instead of filter_map.
* Adding listPersonContent check.
* Updating lemmy-js-client
* Fixing mark all as read route, changing mark read to SuccessResponse.
* Adding post body mention api test, fixing api tests.
* Fixing route locations, and api tests.
---------
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
2025-01-15 12:51:39 -05:00
236d8bda3e
Merge remote-tracking branch 'origin/main' into combined_inbox
2025-01-15 11:31:14 -05:00
5bc3f0c4d9
Pictrs delete token ( #5317 )
...
* Split image endpoints into API v3 and v4
* Move into subfolders
* Upload avatar endpoint and other changes
* Various other changes
fixes #1772
fixes #4001
* clippy
* config options
* fix ts bindings
* fix api tests
* Add option to disable image upload (fixes #1118 )
* split files into upload, download
* move sitemap to top level, not in api
* simplify code
* add upload user banner
* community icon/banner
* site icon/banner
* update js client
* wip
* add delete endpoints
* change comment
* optimization
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* move fn
* 1024px banner
* dont use static client
* fix api tests
* shear
* proxy pictrs in request.rs (fixes #5270 )
* clippy
* Get rid of pictrs delete token
* remove delete token params
* try to fix api tests
* fmt
* skip api tests
* clippy
* create user
* debug
* dbg
* ignore test
* test
* image
* run another
* fixed?
* clippy
* fix
* migration with column order
* drop default
* fix health check
* update client
* remove unused
* fix
* reuse delete_image_from_pictrs
* update lib
---------
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
2025-01-15 11:28:43 -05:00
70fcd5cdb4
Merge branch 'combined_modlog' into combined_inbox
2025-01-14 16:49:54 -05:00
Dessalines
9c1347c7a0
Adding Combined modlog ( #5253 )
...
* Combined tables try 2
* Finishing up combined report table.
* Fix ts optionals.
* Adding tests, triggers, and history updates for report_combined.
* Adding profile.
* Add cursor pagination to report_combined view (#5244 )
* add pagination cursor
* store timestamp instead of id in cursor (partial)
* Revert "store timestamp instead of id in cursor (partial)"
This reverts commit 89359dde4b
.
* use paginated query builder
* Fixing migration and paged API.
* Using dullbananas trigger procedure
* Removing pointless list routes, reorganizing tests.
* Fixing column XOR check.
* Forgot to remove list report actions.
* Cleanup.
* Use internal tagging.
* Fixing api tests.
* Adding a few indexes.
* Fixing migration name.
* Fixing unique constraints.
* Addressing PR comments.
* Start working on profile combined
* Adding views and replaceable schema.
* A few changes to profile view.
- Separating the profile fetch from its combined content fetch.
- Starting to separate saved_only into its own combined view.
* Finishing up combined person_saved and person_content.
* Fixing api tests.
* Moving to api-v4 routes.
* Fixing imports.
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update migrations/2024-12-02-181601_add_report_combined_table/up.sql
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update migrations/2024-12-02-181601_add_report_combined_table/up.sql
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Fixing import and fmt.
* Fixing null types in postgres.
* Comment out err.
* Fixing TS issues.
* Adding types, fixing allow and blocklist crud.
* Starting to work on combined views.
* Using dullbananas trigger procedure
* Adding the full combined view queries.
* Adding tests.
* taplo fmt.
* Upgrading package.json deps.
* Updating pnpm
* Addressing PR comments.
* Removing serialization
* Removing serialization
* Fixing duped trigger.
* Remove saved_only test.
* Remove pointless post_tags types.
* Remove pointless index.
* Changing published to saved for person_saved_combined.
* Removing comment.
* Renaming modlog when_ columns to published.
- Fixes #5312
* Adding strum and simplifying imports.
* Avoiding clone in map_to_enum
* Changing modded_person to other_person.
* Update crates/db_views_moderator/src/modlog_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views_moderator/src/modlog_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views_moderator/src/modlog_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Addressing PR comments.
* Fixing split.
* Revert "Adding strum and simplifying imports."
This reverts commit 15f1671107
.
* Running fmt.
* Using assert + matches instead of filter_map.
* Adding listPersonContent check.
---------
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
2025-01-14 15:14:58 +01:00
143da4bb45
Merge remote-tracking branch 'origin/main' into combined_modlog
2025-01-13 15:48:13 -05:00
dullbananas
c08e216ae8
Correctly paginate PostView when read_only is enabled ( #5320 )
2025-01-13 15:46:46 -05:00
b021e4b416
Merge remote-tracking branch 'origin/main' into combined_modlog
2025-01-13 10:53:12 -05:00
dullbananas
4d17eef82b
Add community reports (only the database part) ( #4996 )
...
* database stuff, not including tests
* change migration date
* fix community_report_view
* update stuff related to report_combined
* add db_schema/src/impls/community_report.rs
* add report counts to community_aggregates
* fix community_report columns and update report_combined_view::tests::test_combined
* add column for original sidebar; use None instead of clone; add report_combined_view::tests::test_community_reports
* use ts(optional) in CommunityReportView
* remove CommunityReportView::read
2025-01-13 05:14:56 -05:00
43179177a0
Avoiding clone in map_to_enum
2025-01-08 18:19:51 -05:00
be4a05e549
Merge remote-tracking branch 'origin/main' into combined_modlog
2025-01-08 16:58:56 -05:00
d27a6346ab
Renaming modlog when_ columns to published.
...
- Fixes #5312
2025-01-08 16:58:19 -05:00
dullbananas
6b1b29419d
Add custom migration runner, forbid some diesel migration
commands, fix old migrations ( #4673 )
...
* 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 clippy
* Make diff check work just like before
* Move new migrations to the end
* Revert changes to old migrations
* don't assume that migrations are already sorted
* retry CI
* fix merge
* find migrations dir in debug mode using CARGO_MANIFEST_DIR variable instead of current working directory
* always use embedded migrations
* improve doc comments for migration subcommand
* clippy fix
* move cfg(test) attribute to diff_check.rs
* copy `o` variable instead of calling `o` function
* use chrono::TimeDelta Display implementation to show migration duration
2025-01-08 11:07:32 +01:00
Dessalines
0bfbd74e59
Adding combined person content and person saved tables. ( #5251 )
...
* Combined tables try 2
* Finishing up combined report table.
* Fix ts optionals.
* Adding tests, triggers, and history updates for report_combined.
* Adding profile.
* Add cursor pagination to report_combined view (#5244 )
* add pagination cursor
* store timestamp instead of id in cursor (partial)
* Revert "store timestamp instead of id in cursor (partial)"
This reverts commit 89359dde4b
.
* use paginated query builder
* Fixing migration and paged API.
* Using dullbananas trigger procedure
* Removing pointless list routes, reorganizing tests.
* Fixing column XOR check.
* Forgot to remove list report actions.
* Cleanup.
* Use internal tagging.
* Fixing api tests.
* Adding a few indexes.
* Fixing migration name.
* Fixing unique constraints.
* Addressing PR comments.
* Start working on profile combined
* Adding views and replaceable schema.
* A few changes to profile view.
- Separating the profile fetch from its combined content fetch.
- Starting to separate saved_only into its own combined view.
* Finishing up combined person_saved and person_content.
* Fixing api tests.
* Moving to api-v4 routes.
* Fixing imports.
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update migrations/2024-12-02-181601_add_report_combined_table/up.sql
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update migrations/2024-12-02-181601_add_report_combined_table/up.sql
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Fixing import and fmt.
* Fixing null types in postgres.
* Comment out err.
* Fixing TS issues.
* Using dullbananas trigger procedure
* Addressing PR comments.
* Removing serialization
* Removing serialization
* Fixing duped trigger.
* Remove saved_only test.
* Remove pointless post_tags types.
* Remove pointless index.
* Changing published to saved for person_saved_combined.
---------
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
2025-01-05 12:48:57 -05:00
b46fdab768
Merge branch 'combined_profile' into combined_modlog
2025-01-03 14:45:08 -05:00
5cf0bb834a
Merge remote-tracking branch 'origin/main' into combined_profile
2025-01-03 14:33:34 -05:00
b6d0ecfcb3
Merge branch 'combined_profile' into combined_modlog
2025-01-03 09:16:54 -05:00
2244fd005d
Changing published to saved for person_saved_combined.
2025-01-02 17:08:05 -05:00
918c5e820d
Merge remote-tracking branch 'origin/main' into combined_profile
2025-01-02 16:38:02 -05:00
Dessalines
76034f058d
Cleaning up oauth providers conversion. ( #5280 )
...
* Cleaning up oauth providers conversion.
* Use into_iter
2024-12-27 12:52:05 -05:00
bd5210aed0
Merge remote-tracking branch 'origin/main' into combined_profile
2024-12-23 14:59:09 -05:00
7585aac446
Fix startup errors, add unit test for scheduled task errors ( fixes #5209 ) ( #5269 )
...
* Fix startup errors, add ci check (fixes #5209 )
* normal unit test
* cleanup
* shear
* remove serial
* migration
2024-12-20 19:21:09 -05:00
Dessalines
6015ef045d
Running cargo-features-manager prune. ( #5274 )
...
- Context #5273
2024-12-20 23:20:16 +01:00
cfd302dc1d
Fixing duped trigger.
2024-12-19 17:58:18 -05:00
a1792bb16e
Merge remote-tracking branch 'origin/main' into combined_profile
2024-12-19 17:53:24 -05:00
0b514c5b92
Merge branch 'combined_tables_2' into combined_profile
2024-12-19 17:44:07 -05:00
Dessalines
9d3a0cef56
Adding report_combined
table. ( #5231 )
...
* Combined tables try 2
* Finishing up combined report table.
* Fix ts optionals.
* Adding tests, triggers, and history updates for report_combined.
* Adding profile.
* Add cursor pagination to report_combined view (#5244 )
* add pagination cursor
* store timestamp instead of id in cursor (partial)
* Revert "store timestamp instead of id in cursor (partial)"
This reverts commit 89359dde4b
.
* use paginated query builder
* Fixing migration and paged API.
* Using dullbananas trigger procedure
* Removing pointless list routes, reorganizing tests.
* Fixing column XOR check.
* Forgot to remove list report actions.
* Cleanup.
* Use internal tagging.
* Fixing api tests.
* Adding a few indexes.
* Fixing migration name.
* Fixing unique constraints.
* Addressing PR comments.
* Fixing api tests.
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update crates/db_views/src/report_combined_view.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update migrations/2024-12-02-181601_add_report_combined_table/up.sql
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Update migrations/2024-12-02-181601_add_report_combined_table/up.sql
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
* Fixing import and fmt.
* Fixing null types in postgres.
* Comment out err.
* Addressing PR comments.
* Removing serialization
---------
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
2024-12-19 17:22:31 -05:00
154cea9366
Merge remote-tracking branch 'origin/main' into combined_tables_2
2024-12-19 16:30:15 -05:00
phiresky
a2a5cb091a
Community post tags (part 1) ( #4997 )
...
* partial post tags implementation
* fixes
* fix lints
* schema fix
* chore: restructure / rename tag tables
* chore: fix post view tests
* format
* lint
* expect used
* chore: update code to maybe final version
* add ts-rs optionals
* remove error context
* clippy
2024-12-18 14:54:35 +01:00
fb1f2ff174
Merge branch 'combined_tables_2' into search_combined
2024-12-13 11:14:29 -05:00
b4ce1d9121
Removing serialization
2024-12-13 08:50:14 -05:00
af543cc70b
Merge branch 'combined_tables_2' into combined_profile
2024-12-13 08:43:45 -05:00
7c962d63fb
Removing serialization
2024-12-12 19:20:31 -05:00
031dc2607e
Fix
2024-12-12 19:13:51 -05:00
dada964df7
Starting to work on search combined.
2024-12-12 19:13:31 -05:00
37aa20057c
Fixing sql_format.
2024-12-11 22:22:55 -05:00
41cfdca1cf
Finishing up inbox.
2024-12-11 22:12:56 -05:00
05f218d53c
Most of the bulk work done, need to add tests yet.
2024-12-11 15:06:08 -05:00
f133079f0b
Merge branch 'post_body_mentions' into combined_inbox
2024-12-10 14:33:28 -05:00