use crate::adapters::contract::types::SqlAdapter;
use crate::adapters::duckdb::models::DuckDbSql;
use arrow_array::RecordBatch;
use duckdb::vtab::ArrowBatchRegistration;
use crate::adapters::contract::models::TableName;
use crate::adapters::duckdb::_helpers::blocking::with_connection;
use crate::adapters::duckdb::errors::DuckDbError;
use crate::adapters::duckdb::models::{DuckDbConnection, DuckDbDestination};
use crate::adapters::motherduck_bridge::main::_append_batch::append_batch as bridge_append;
pub(in crate::adapters) async fn append_batch(
destination: &DuckDbDestination,
table: &TableName,
batch: RecordBatch,
) -> Result<(), DuckDbError> {
let target = DuckDbSql.render_qualified_name(table);
let columns: Vec<String> = batch
.schema()
.fields()
.iter()
.map(|field| DuckDbSql.render_identifier(field.name()))
.collect();
let list = columns.join(", ");
if let DuckDbConnection::Bridge(bridge) = &destination.connection {
let insert = format!("INSERT INTO {target} ({list}) SELECT {list} FROM read_parquet(?)");
return Ok(bridge_append(bridge, insert, batch).await?);
}
with_connection(destination, move |connection| {
connection
.prepare(&format!(
"INSERT INTO {target} ({list}) SELECT {list} FROM system.main.arrow(?)"
))?
.execute([&ArrowBatchRegistration::new(batch)])?;
Ok(())
})
.await
}