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
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
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
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
6363e7d5db
Merge branch 'combined_profile' into combined_modlog
2024-12-09 08:25:09 -05:00
63b7f726cb
Using dullbananas trigger procedure
2024-12-09 08:22:35 -05:00
15d1faad72
Adding types, fixing allow and blocklist crud.
2024-12-08 13:30:37 -05:00
58e62d55d9
Fixing TS issues.
2024-12-08 09:27:29 -05:00
40fead2bee
Merge branch 'combined_tables_2' into combined_profile
2024-12-08 08:50:07 -05:00
02bd2f6764
Fixing import and fmt.
2024-12-08 08:49:26 -05: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
1053df1a4b
Adding views and replaceable schema.
2024-12-06 09:49:11 -05:00
724856d684
Start working on profile combined
2024-12-06 08:18:08 -05:00
34a440a6d7
Fixing migration name.
2024-12-02 18:38:18 -05:00
1f284076ce
Adding a few indexes.
2024-12-02 18:35:18 -05:00
46748210ee
Merge remote-tracking branch 'origin/main' into combined_tables_2
2024-12-02 17:07:03 -05:00