Struct Extract 

pub struct Extract {
    pub component: ExtractComponent,
    /* private fields */
}

Extract component from date/time

Fields

component: ExtractComponent

The component.

Implementations

impl Extract

pub fn new(expression: AnnotationValue, component: ExtractComponent) -> Extract

Available on native and crate feature database only.

Extract a component from a date/time value

Examples

use reinhardt_db::orm::functions::{Extract, ExtractComponent};
use reinhardt_db::orm::annotation::AnnotationValue;
use reinhardt_db::orm::expressions::F;

let extract = Extract::new(
    AnnotationValue::Field(F::new("created_at")),
    ExtractComponent::Year
);
assert_eq!(extract.to_sql(), "EXTRACT(YEAR FROM \"created_at\")");

pub fn year(expression: AnnotationValue) -> Extract

Available on native and crate feature database only.

Extract year from a date/time

Examples

use reinhardt_db::orm::functions::Extract;
use reinhardt_db::orm::annotation::AnnotationValue;
use reinhardt_db::orm::expressions::F;

let year_extract = Extract::year(AnnotationValue::Field(F::new("birth_date")));
assert_eq!(year_extract.to_sql(), "EXTRACT(YEAR FROM \"birth_date\")");

pub fn month(expression: AnnotationValue) -> Extract

Available on native and crate feature database only.

Extract month from a date/time

Examples

use reinhardt_db::orm::functions::Extract;
use reinhardt_db::orm::annotation::AnnotationValue;
use reinhardt_db::orm::expressions::F;

let month_extract = Extract::month(AnnotationValue::Field(F::new("order_date")));
assert_eq!(month_extract.to_sql(), "EXTRACT(MONTH FROM \"order_date\")");

pub fn day(expression: AnnotationValue) -> Extract

Available on native and crate feature database only.

Extract day from a date/time

Examples

use reinhardt_db::orm::functions::Extract;
use reinhardt_db::orm::annotation::AnnotationValue;
use reinhardt_db::orm::expressions::F;

let day_extract = Extract::day(AnnotationValue::Field(F::new("timestamp")));
assert_eq!(day_extract.to_sql(), "EXTRACT(DAY FROM \"timestamp\")");

pub fn hour(expression: AnnotationValue) -> Extract

Available on native and crate feature database only.

Extract hour from a date/time

Examples

use reinhardt_db::orm::functions::Extract;
use reinhardt_db::orm::annotation::AnnotationValue;
use reinhardt_db::orm::expressions::F;

let hour_extract = Extract::hour(AnnotationValue::Field(F::new("event_time")));
assert_eq!(hour_extract.to_sql(), "EXTRACT(HOUR FROM \"event_time\")");

pub fn minute(expression: AnnotationValue) -> Extract

Available on native and crate feature database only.

Extract minute from a date/time

Examples

use reinhardt_db::orm::functions::Extract;
use reinhardt_db::orm::annotation::AnnotationValue;
use reinhardt_db::orm::expressions::F;

let minute_extract = Extract::minute(AnnotationValue::Field(F::new("timestamp")));
assert_eq!(minute_extract.to_sql(), "EXTRACT(MINUTE FROM \"timestamp\")");

pub fn second(expression: AnnotationValue) -> Extract

Available on native and crate feature database only.

Extract second from a date/time

Examples

use reinhardt_db::orm::functions::Extract;
use reinhardt_db::orm::annotation::AnnotationValue;
use reinhardt_db::orm::expressions::F;

let second_extract = Extract::second(AnnotationValue::Field(F::new("timestamp")));
assert_eq!(second_extract.to_sql(), "EXTRACT(SECOND FROM \"timestamp\")");

pub fn to_sql(&self) -> String

Available on native and crate feature database only.

Generate EXTRACT SQL

Examples

use reinhardt_db::orm::functions::Extract;
use reinhardt_db::orm::annotation::AnnotationValue;
use reinhardt_db::orm::expressions::F;

let extract = Extract::year(AnnotationValue::Field(F::new("created_at")));
assert!(extract.to_sql().starts_with("EXTRACT("));

pub fn expression(&self) -> &AnnotationValue

Available on native and crate feature database only.

Get a reference to the expression

pub fn into_expression(self) -> AnnotationValue

Available on native and crate feature database only.

Convert into the expression, consuming self

Trait Implementations

impl Clone for Extract

fn clone(&self) -> Extract

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Extract

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Extract

fn deserialize<__D>( __deserializer: __D, ) -> Result<Extract, <__D as Deserializer<'de>>::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for Extract

fn serialize<__S>( &self, __serializer: __S, ) -> Result<<__S as Serializer>::Ok, <__S as Serializer>::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.