Struct PostQuery 

pub struct PostQuery<'a, C> {
    pub ids: IdFilter<PostId>,
    pub title: TextFilter,
    pub source: TextFilter,
    pub updated: DateFilter,
    pub published: DateFilter,
    pub platforms: IdFilter<PlatformId>,
    pub tags: RelationshipsFilter<TagId>,
    pub authors: RelationshipsFilter<AuthorId>,
    pub collections: RelationshipsFilter<CollectionId>,
    /* private fields */
}

Available on crate feature utils only.

Fluent query builder for posts. Obtained via PostArchiverManager::posts().

Available filter fields

• ids: filter by a set of PostId values.
• title: fuzzy match on the title.
• source: fuzzy match on the post source.
• updated：filter by last-updated timestamp range.
• published：filter by published timestamp range.
• platforms：filter by a set of PlatformId values.
• tags：filter by a set of TagId values, through the post_tags relation table.
• authors：filter by a set of AuthorId values, through the author_posts relation table。
• collections：filter by a set of CollectionId values, through the collection_posts relation table.

Example

let posts = manager.posts()
    .sort(PostSort::Updated, SortDir::Desc)
    .pagination(20, 0)
    .query::<post_archiver::Post>()
    .unwrap();

Fields

ids: IdFilter<PostId>

title: TextFilter

source: TextFilter

updated: DateFilter

published: DateFilter

platforms: IdFilter<PlatformId>

tags: RelationshipsFilter<TagId>

authors: RelationshipsFilter<AuthorId>

collections: RelationshipsFilter<CollectionId>

Implementations

impl<'a, C: PostArchiverConnection> PostQuery<'a, C>

pub fn new(manager: &'a PostArchiverManager<C>) -> Self

Trait Implementations

impl<C: PostArchiverConnection> BaseFilter for PostQuery<'_, C>

type Based = Post

fn update_sql<T: FromQuery<Based = Self::Based>>( &self, sql: RawSql<T>, ) -> RawSql<T>

Append all filter conditions held by this builder into sql and return the updated RawSql.

fn queryer(&self) -> &Queryer<'_, impl PostArchiverConnection>

Return a reference to the Queryer owned by this builder, used by the default count() impl.

fn count(&self) -> Result<u64>

impl<'a, C: Debug> Debug for PostQuery<'a, C>

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<C: PostArchiverConnection> Query for PostQuery<'_, C>

type Wrapper<U> = Vec<U>

The wrapper type for query results. For most builders this is Vec<T>; when wrapped by WithTotal it becomes Totalled<Vec<T>>.

type Based = Post

The database table type this query targets.

fn query_with_context<T: FromQuery<Based = Self::Based>>( self, sql: RawSql<T>, ) -> Result<Self::Wrapper<T>>

Execute the query with an externally supplied RawSql context (typically threaded through decorator layers).

fn query<T: FromQuery<Based = Self::Based>>(self) -> Result<Self::Wrapper<T>>

Execute the query with a default empty RawSql context, returning all matching results.

impl<C> Sortable for PostQuery<'_, C>

type SortField = PostSort

The sortable field enum type, defined in each sub-module by impl_sortable!.

fn sort( self, field: Self::SortField, dir: SortDir, ) -> Sorted<Self, Self::SortField>

Sort by the given field and direction, returning Sorted<Self, SortField>.

fn sort_random(self) -> Sorted<Self, Random>

Sort results randomly using ORDER BY RANDOM().