lemmy/crates/db_schema/src
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
..
aggregates Add report_counts to post and comment aggregate tables. (#5219) 2024-11-25 11:24:57 +01:00
impls Adding combined person content and person saved tables. (#5251) 2025-01-05 12:48:57 -05:00
source Adding combined person content and person saved tables. (#5251) 2025-01-05 12:48:57 -05:00
utils Combine action tables (#4459) 2024-11-11 11:34:10 +01:00
diesel_ltree.patch Adding a post_view mode. Fixes #3730 (#3731) 2023-08-31 09:01:08 -04:00
lib.rs Adding combined person content and person saved tables. (#5251) 2025-01-05 12:48:57 -05:00
newtypes.rs Adding combined person content and person saved tables. (#5251) 2025-01-05 12:48:57 -05:00
schema.rs Adding combined person content and person saved tables. (#5251) 2025-01-05 12:48:57 -05:00
schema_setup.rs Remove opentelemetry (#4741) 2024-09-10 13:36:03 -04:00
sensitive.rs Upgrading ts_rs to 10.0.0 (#5163) 2024-11-06 15:50:13 +01:00
traits.rs Combine action tables (#4459) 2024-11-11 11:34:10 +01:00
utils.rs Community post tags (part 1) (#4997) 2024-12-18 14:54:35 +01:00