use std::time::Instant;
use crate::adapters::duckdb::_helpers::blocking::with_connection;
use crate::adapters::duckdb::_helpers::pull_sql::{bucket_access, secret_current};
use crate::adapters::duckdb::errors::DuckDbError;
use crate::adapters::duckdb::models::{DuckDbConnection, DuckDbDestination};
use crate::adapters::motherduck_bridge::main::run_statement::run_statement;
use crate::store_paths::models::StoreKind;
pub(in crate::adapters) async fn open_bucket(
destination: &DuckDbDestination,
store: &StoreKind,
) -> Result<(), DuckDbError> {
let Some(access) = bucket_access(store)? else {
return Ok(());
};
let now = Instant::now();
let wanted = access.set_at(now);
let mut set = destination.secrets.lock().await;
if secret_current(set.get(&access.bucket), &wanted, now) {
return Ok(());
}
set.remove(&access.bucket);
match &destination.connection {
DuckDbConnection::Bridge(bridge) => {
run_statement(bridge, access.extensions.to_owned(), Vec::new()).await?;
run_statement(bridge, access.statement, access.parameters).await?;
}
DuckDbConnection::Local(_) => {
let (extensions, statement, values) =
(access.extensions, access.statement, access.parameters);
with_connection(destination, move |connection| {
connection.execute_batch(extensions)?;
connection.execute(&statement, duckdb::params_from_iter(values))?;
Ok(())
})
.await?;
}
}
set.insert(access.bucket, wanted);
Ok(())
}