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
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
8f39568760
Fixing mark all as read route, changing mark read to SuccessResponse.
2025-01-14 17:58:10 -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
Dessalines
85d8810139
Merge branch 'main' into combined_modlog
2025-01-13 23:23:11 -05:00
a91a03a536
Image api rework ( #5260 )
...
* 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
* try to fix api tests
* skip api tests
* create user
* debug
* dbg
* test
* image
* run another
* fixed?
* clippy
* fix
* fix health check
---------
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
2025-01-13 16:09:00 -05:00
0723ef2055
Changing modded_person to other_person.
2025-01-08 18:26:25 -05: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
Dessalines
e9d27f2840
Don't send out new user email verifies to admins, if already verified. ( #5288 )
...
- Fixes #5272
2025-01-03 11:16:25 +01:00
918c5e820d
Merge remote-tracking branch 'origin/main' into combined_profile
2025-01-02 16:38:02 -05:00
anhcuky
c034229295
reset_password API to always return success ( #5284 )
2025-01-02 12:37:13 -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
3721067cce
Moving db_views_actor and _moderator into db_views.
...
- This is necessary because the combined views use both, and that
separation was arbitrary to begin with. db_schema has no such crate
separation.
2024-12-13 11:13:21 -05:00
af543cc70b
Merge branch 'combined_tables_2' into combined_profile
2024-12-13 08:43:45 -05:00
ae9da4da69
Merge remote-tracking branch 'origin/main' into combined_tables_2
2024-12-12 19:23:20 -05:00
17d2de8691
Merge branch 'combined_modlog' into combined_inbox
2024-12-12 17:29:33 -05:00
942da64f07
Merge remote-tracking branch 'origin/main' into combined_modlog
2024-12-12 17:25:02 -05:00
8d91543a13
Allow admins to view deleted users ( fixes #5249 ) ( #5258 )
...
* Allow admins to view deleted users (fixes #5249 )
* remove check
2024-12-12 10:06:38 -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
c157b8f0fc
Adding tests.
2024-12-09 19:13:25 -05:00
9d36f1f176
Adding the full combined view queries.
2024-12-09 14:34:53 -05:00
15d1faad72
Adding types, fixing allow and blocklist crud.
2024-12-08 13:30:37 -05:00
a4de41ddae
Merge branch 'combined_tables_2' into combined_profile
2024-12-07 21:20:25 -05:00
a940ce38ef
Merge remote-tracking branch 'origin/main' into combined_tables_2
2024-12-07 17:54:18 -05:00
5e7b30ac6a
Reorganize api endpoints ( fixes #2022 ) ( #5216 )
...
* Reorganize api endpoints (fixes #2022 )
* scopes
* move message rate limit
* move rate limit
* apply suggestions
* move my_user to separate endpoint
* remove taglines and custom emojis from siteview
* routes for api v3 and v4
* remove new features from api v3
* js client
* replace occurences of `v3`, fix routes
* replace getSite().my_user with getMyUser()
* update
* update config
* remove web::
* update
* prettier
* lockfile
* v
* fix settings
* move block endpoints
* more changes
* fmt
* update
* change some routes
* lockfile
* Add comment about deprecation
2024-12-07 14:06:33 -07:00
3abc46fad9
Finishing up combined person_saved and person_content.
2024-12-07 15:46:46 -05:00
32b5411abd
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.
2024-12-07 12:38:20 -05:00
1776de2f45
Removing pointless list routes, reorganizing tests.
2024-12-02 16:10:59 -05:00
7fdbb58e98
Fixing migration and paged API.
2024-12-02 13:28:26 -05:00
a9f28af554
Merge remote-tracking branch 'origin/main' into combined_tables_2
2024-11-28 18:25:55 -05:00
66a63df152
Instance blocks with mod log entry and expiration ( fixes #2506 ) ( #5214 )
...
* Instance blocks with mod log entry and expiration (fixes #2506 )
* separate table for instance block mod log
* fix tests
* fix ts
* modlog entry for allow instance
* fix test cleanup
* add back test
* clippy
* fix check
* more changes
* move files
* update
* sql fmt
* partly working
* fix setup
* cleanup
* fixes
* prettier
* try catch
* address comments
2024-11-28 18:21:43 -05:00
0ba961ff5c
Adding tests, triggers, and history updates for report_combined.
2024-11-27 16:02:11 -05:00
1ff8ae0641
Finishing up combined report table.
2024-11-26 16:53:01 -05:00
Dessalines
417e18e819
Upgrading diesel and a few other deps. ( #5203 )
...
* Upgrading diesel and a few other deps.
* Update crates/db_schema/src/utils.rs
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
---------
Co-authored-by: dullbananas <dull.bananas0@gmail.com>
2024-11-18 10:23:02 -07:00
797aac7281
Check for error when fetching link metadata ( fixes #5127 ) ( #5129 )
...
* Check for error when fetching link metadata (fixes #5127 )
* use error_for_status everywhere
* dont ignore errors
* enable lint
* fixes
* review
* more review
2024-11-15 09:13:43 -05:00
Dessalines
fa4825b524
Removing a few expects from production and test code. ( #5193 )
...
* Removing a few expects from production and test code.
- Fixes #5192
* Using if let filter for admin emails.
* Fixing unused error.
* Adding expect_used = deny to clippy lints.
* Update src/lib.rs
Co-authored-by: Nutomic <me@nutomic.com>
* Update crates/utils/src/settings/structs.rs
Co-authored-by: Nutomic <me@nutomic.com>
* Update crates/utils/src/settings/mod.rs
Co-authored-by: Nutomic <me@nutomic.com>
* Some more cleanup.
* Fix clippy
---------
Co-authored-by: Nutomic <me@nutomic.com>
2024-11-15 08:18:52 -05:00
Dessalines
231cce9350
Cleanup post action forms ( #5197 )
...
* Removing a few SuccessResponses for PostHide and MarkPostAsRead.
- This also removes the pointless multiple post_ids. These can be done
as individual calls on the front end anyway.
- Fixes #4755
* Fixing federation tests.
* Upgrading lemmy-js-client deps.
* Add ability to mark several posts as read.
Context:
- https://github.com/LemmyNet/lemmy/pull/5043
- https://github.com/LemmyNet/lemmy/issues/4755
- https://github.com/LemmyNet/lemmy/pull/5160
* Simplifying forms.
* Fixing forms.
* Cleanup post action forms by using derive_new defaults.
- Fixes #5195
* Fix ntfy to notify on success builds also.
* Removing pointless naive_now function.
* Running taplo fmt.
2024-11-15 11:21:08 +01:00
Dessalines
7f4e26e29e
Add ability to mark multiple posts as read. ( #5178 )
...
* Removing a few SuccessResponses for PostHide and MarkPostAsRead.
- This also removes the pointless multiple post_ids. These can be done
as individual calls on the front end anyway.
- Fixes #4755
* Fixing federation tests.
* Upgrading lemmy-js-client deps.
* Add ability to mark several posts as read.
Context:
- https://github.com/LemmyNet/lemmy/pull/5043
- https://github.com/LemmyNet/lemmy/issues/4755
- https://github.com/LemmyNet/lemmy/pull/5160
* Fix ntfy to notify on success builds also.
* Addressing PR comments.
2024-11-14 09:03:39 -05:00
Dessalines
a9d6d4e6e0
Add user setting to auto-mark fetched posts as read. ( #5160 )
...
* Add user setting to auto-mark fetched posts as read.
- Rather than apps collecting up viewed posts ids, and sending many
mark as read requests, users can now turn this setting on, and any
results from /post/list will be auto-marked as read.
- Fixes #5144
* Adding list_post request option to auto-mark as read.
* Moving db_perf to before federation tests.
* Fixing lemmyerrortype import.
* Fixing ts_option.
* Fix clippy.
* Fix override logic.
* Revert "Fix override logic."
This reverts commit 923d7f0eca
.
* Changing name to mark_as_read
2024-11-13 10:05:16 -05:00
Dessalines
c4d864878f
Change "mark post as read", "hide post" api calls to take single post instead of multiple ( #5043 )
...
* Removing a few SuccessResponses for PostHide and MarkPostAsRead.
- This also removes the pointless multiple post_ids. These can be done
as individual calls on the front end anyway.
- Fixes #4755
* Fixing federation tests.
* Upgrading lemmy-js-client deps.
* Simplifying forms.
* Fixing forms.
* Removing indexing slicing from a test.
2024-11-13 09:36:18 -05:00
Dessalines
39eeb2cbb3
Allow disabling private messages. Fixes #3640 ( #4094 )
...
* Allow disabling private messages. Fixes #3640
* Fix typo.
* Fixing local user check in apub code.
* Removing pointless local check.
2024-11-07 22:16:28 -05:00