Move query join logic into common functions

[dessalines]

All the views have a list version, and a single get version. IE getting a post, and fetching a list of posts.

These views have to do the exact joins, but currently this join code is duplicated. It should probably be possible to move this join logic into a common function to be used by both the single get, and the list versions.

[dessalines]

From the diesel chat:

<@happydooby:matrix.org> Question: I have two methods that both require the same joins ( one that fetches a single result with first(), and the other that does a boxed query of many results) so I'd like to extract this into a SelectStatement to a common function.

When I do this, it creates an extremely complicated type, with a lot of internally private diesel functions like JoinOn and Grouped. The type is very unwieldy too.

Is there any way to easily do this, or am I stuck with copy-pasting the join query?

You want to use the types from diesel::dsl for that. They hide those internal private types. The documentation of QueryDsl shows the correct type. For example for users::table.select(users::name) you would look at QueryDsl::select, which states that it returns Select<Self, Selection> where Self is the type you called select onto, and Selection is the argument passed to the function. That would result in diesel::dsl::Select<users::table, users::name> as correct public nameable type for that statement.