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?;

Trait Implementations

impl Clone for PageVisibility

fn clone(&self) -> PageVisibility

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for PageVisibility

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

Formats the value using the given formatter.

impl PartialEq for PageVisibility

fn eq(&self, other: &PageVisibility) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Copy for PageVisibility

impl Eq for PageVisibility

impl StructuralPartialEq for PageVisibility