use std::sync::Arc;
use arrow_array::{ArrayRef, RecordBatch, RecordBatchOptions};
use arrow_schema::{Field, Schema};
use crate::column_types::models::ColumnType;
use crate::sheets_source::_helpers::arrays::column_array;
use crate::sheets_source::_helpers::layout::{data_rows, header_names};
use crate::sheets_source::models::{Grid, HeaderRule};
pub fn sheet_batch(
grid: &Grid,
rule: HeaderRule,
columns: &[(String, ColumnType)],
) -> Result<RecordBatch, String> {
let names = header_names(grid, rule).map_err(|problems| problems.join("; "))?;
let rows = data_rows(grid, rule, names.len());
let mut fields: Vec<Field> = Vec::with_capacity(columns.len());
let mut arrays: Vec<ArrayRef> = Vec::with_capacity(columns.len());
for (name, column_type) in columns {
let position = names
.iter()
.position(|header| header.eq_ignore_ascii_case(name))
.ok_or_else(|| {
format!(
"{}: column {name} is no longer in the header; run plan again",
grid.title
)
})?;
let (field, converted) = column_array(grid, &rows, position, (name, column_type))?;
fields.push(field);
arrays.push(converted);
}
let options = RecordBatchOptions::new().with_row_count(Some(rows.len()));
RecordBatch::try_new_with_options(Arc::new(Schema::new(fields)), arrays, &options)
.map_err(|error| error.to_string())
}