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.

貼文的流式查詢構建器。

透過 PostArchiverManager::posts() 取得。

可用過濾欄位

• ids：依 PostId 陸列過濾。
• title：依標題進行 LIKE 模糊匹配。
• source：依來源字串進行 LIKE 模糊匹配。
• updated：依最後更新時間進行範圍過濾。
• published：依發布時間進行範圍過濾。
• platforms：依所屬平台的 PlatformId 陸列過濾。
• tags：展性匹配標籤，最小定包含透過 post_tags 關聯表指定的所有 TagId。
• authors：展性匹配作者，結構同上，透過 author_posts 關聯表。
• collections：展性匹配收藏集，結構同上，透過 collection_posts 關聯表。

範例

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().