Enum PageVisibility

pub enum PageVisibility {
    Any,
    Public,
    Hidden,
}

Variants

Any

Public

Hidden

Implementations

impl PageVisibility

fn get_inverse_visibility_filter(&self) -> Option<bool>

Hacky way to implement a nullable boolean filter. Based on the idea that null IS DISTINCT FROM anything in PostgreSQL.

More information at: https://www.postgresql.org/docs/current/functions-comparison.html

Examples

// Evaluates to "hidden <> NULL"
let visibility = PageVisibility::Any;
sqlx::query!(
    "SELECT id FROM pages WHERE hidden IS DISTINCT FROM $1",
    visibility.get_inverse_visibility_filter(),
)
.fetch_all(conn)
.await?;

// Evaluates to "hidden <> true"
let visibility = PageVisibility::Public;
sqlx::query!(
    "SELECT id FROM pages WHERE hidden IS DISTINCT FROM $1",
    visibility.get_inverse_visibility_filter(),
)
.fetch_all(conn)
.await?;