reifydb_function/datetime/
day_of_year.rs

1// SPDX-License-Identifier: AGPL-3.0-or-later
2// Copyright (c) 2025 ReifyDB
3
4use reifydb_core::value::column::data::ColumnData;
5use reifydb_type::value::{date::Date, r#type::Type};
6
7use crate::{ScalarFunction, ScalarFunctionContext, error::ScalarFunctionError, propagate_options};
8
9pub struct DateTimeDayOfYear;
10
11impl DateTimeDayOfYear {
12	pub fn new() -> Self {
13		Self
14	}
15}
16
17impl ScalarFunction for DateTimeDayOfYear {
18	fn scalar(&self, ctx: ScalarFunctionContext) -> crate::error::ScalarFunctionResult<ColumnData> {
19		if let Some(result) = propagate_options(self, &ctx) {
20			return result;
21		}
22		let columns = ctx.columns;
23		let row_count = ctx.row_count;
24
25		if columns.len() != 1 {
26			return Err(ScalarFunctionError::ArityMismatch {
27				function: ctx.fragment.clone(),
28				expected: 1,
29				actual: columns.len(),
30			});
31		}
32
33		let col = columns.get(0).unwrap();
34
35		match col.data() {
36			ColumnData::DateTime(container) => {
37				let mut data = Vec::with_capacity(row_count);
38				let mut bitvec = Vec::with_capacity(row_count);
39
40				for i in 0..row_count {
41					if let Some(dt) = container.get(i) {
42						let date = dt.date();
43						let jan1 = Date::new(date.year(), 1, 1).unwrap();
44						let doy = date.to_days_since_epoch() - jan1.to_days_since_epoch() + 1;
45						data.push(doy);
46						bitvec.push(true);
47					} else {
48						data.push(0);
49						bitvec.push(false);
50					}
51				}
52
53				Ok(ColumnData::int4_with_bitvec(data, bitvec))
54			}
55			other => Err(ScalarFunctionError::InvalidArgumentType {
56				function: ctx.fragment.clone(),
57				argument_index: 0,
58				expected: vec![Type::DateTime],
59				actual: other.get_type(),
60			}),
61		}
62	}
63
64	fn return_type(&self, _input_types: &[Type]) -> Type {
65		Type::Int4
66	}
67}
reifydb_function/datetime/day_of_year.rs

reifydb_function/datetime/
day_of_year.rs
