fetch_root_headline_items

prehnite_core::db::query

Function fetch_root_headline_items 

Source 
pub async fn fetch_root_headline_items(
    conn: &mut SqliteConnection,
    per_page: u8,
    page: u32,
) -> Result<IndexMap<i64, Item>, Error>
Expand description

親が存在しない見出しを取得します。

SELECT *
FROM view_deserializable_item
WHERE item_type = 'headline'
  AND h_parent_id IS NULL
ORDER BY h_headline_pos NULLS LAST
LIMIT ? OFFSET ?;