use serde_json::Value;
use crate::adapters::bigquery::models::{BigQueryDestination, BigQuerySql};
use crate::adapters::contract::models::TableName;
use crate::adapters::contract::types::SqlAdapter;
use crate::bigquery_api::main::table_metadata::table_metadata;
use crate::column_types::models::LiveColumnType;
use crate::http::errors::ApiError;
use crate::schema_plan::models::LiveColumn;
pub(in crate::adapters) async fn describe_table(
destination: &BigQueryDestination,
table: &TableName,
) -> Result<Option<Vec<LiveColumn>>, ApiError> {
let project = table.database.as_deref().unwrap_or(&destination.project);
let Some(found) =
table_metadata(&destination.api, (project, &table.schema, &table.table)).await?
else {
return Ok(None);
};
let number = |value: &Value| match value {
Value::String(text) => text.parse::<i64>().map(Some).map_err(|error| {
ApiError::Protocol(format!(
"tables.get gave a column size {text:?} that is not a number: {error}"
))
}),
other => Ok(other.as_i64()),
};
let adapter = BigQuerySql;
let columns: Vec<LiveColumn> = found["schema"]["fields"]
.as_array()
.into_iter()
.flatten()
.map(|field| {
let base = match field["type"].as_str().unwrap_or_default() {
"RECORD" | "STRUCT" => "STRUCT",
other => other,
};
let data_type = match field["mode"].as_str() {
Some("REPEATED") => format!("ARRAY<{base}>"),
_ => base.to_owned(),
};
Ok(LiveColumn {
name: field["name"].as_str().unwrap_or_default().to_owned(),
column_type: adapter.live_type(&LiveColumnType {
data_type,
precision: number(&field["precision"])?,
scale: number(&field["scale"])?,
char_length: number(&field["maxLength"])?,
}),
fraction_digits: None,
})
})
.collect::<Result<Vec<LiveColumn>, ApiError>>()?;
Ok(Some(columns))
}