quill-sql 0.3.1

use crate::error::{QuillSQLError, QuillSQLResult};
use crate::plan::logical_plan::{LogicalPlan, Update};
use crate::plan::LogicalPlanner;
use std::collections::HashMap;

impl<'a> LogicalPlanner<'a> {
    pub fn plan_update(
        &self,
        table: &sqlparser::ast::TableWithJoins,
        assignments: &[sqlparser::ast::Assignment],
        selection: &Option<sqlparser::ast::Expr>,
    ) -> QuillSQLResult<LogicalPlan> {
        let table_ref = match &table.relation {
            sqlparser::ast::TableFactor::Table { name, .. } => self.bind_table_name(name)?,
            _ => {
                return Err(QuillSQLError::Plan(format!(
                    "table {} is not supported",
                    table
                )))
            }
        };

        let table_schema = self.context.catalog.table_schema(&table_ref)?;

        let mut assignment_map = HashMap::new();
        for assign in assignments {
            let column_ident = assign.id.first().ok_or(QuillSQLError::Plan(format!(
                "Assignment {} is not supported",
                assign
            )))?;
            let column_name = column_ident.value.to_ascii_lowercase();
            let value = self.bind_expr(&assign.value)?;
            assignment_map.insert(column_name, value);
        }

        let selection = match selection {
            Some(e) => Some(self.bind_expr(e)?),
            None => None,
        };

        Ok(LogicalPlan::Update(Update {
            table: table_ref,
            table_schema,
            assignments: assignment_map,
            selection,
        }))
    }
}