// Copyright 2023 Greptime Team
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

use snafu::ResultExt;
use sqlparser::keywords::Keyword;

use crate::error::{self, Result};
use crate::parser::ParserContext;
use crate::statements::explain::ExplainStatement;
use crate::statements::statement::Statement;

/// EXPLAIN statement parser implementation
impl ParserContext<'_> {
    /// explain that support use our own parser to parse the inner statement
    pub(crate) fn parse_explain(&mut self) -> Result<Statement> {
        let analyze = self.parser.parse_keyword(Keyword::ANALYZE);
        let verbose = self.parser.parse_keyword(Keyword::VERBOSE);
        let format =
            if self.parser.parse_keyword(Keyword::FORMAT) {
                Some(self.parser.parse_analyze_format().with_context(|_| {
                    error::UnexpectedSnafu {
                        expected: "analyze format",
                        actual: self.peek_token_as_string(),
                    }
                })?)
            } else {
                None
            };

        let statement = self.parse_statement()?;

        let explain = ExplainStatement {
            analyze,
            verbose,
            format,
            statement: Box::new(statement),
        };
        Ok(Statement::Explain(Box::new(explain)))
    }
}

#[cfg(test)]
mod tests {
    use sqlparser::ast::helpers::attached_token::AttachedToken;
    use sqlparser::ast::{GroupByExpr, Query as SpQuery, SelectFlavor, WildcardAdditionalOptions};

    use super::*;
    use crate::dialect::GreptimeDbDialect;
    use crate::parser::ParseOptions;

    #[test]
    pub fn test_explain() {
        let sql = "EXPLAIN select * from foo";
        let result =
            ParserContext::create_with_dialect(sql, &GreptimeDbDialect {}, ParseOptions::default());
        let stmts = result.unwrap();
        assert_eq!(1, stmts.len());

        let select = sqlparser::ast::Select {
            distinct: None,
            select_modifiers: None,
            top: None,
            projection: vec![sqlparser::ast::SelectItem::Wildcard(
                WildcardAdditionalOptions::default(),
            )],
            exclude: None,
            into: None,
            from: vec![sqlparser::ast::TableWithJoins {
                relation: sqlparser::ast::TableFactor::Table {
                    name: sqlparser::ast::ObjectName::from(vec![sqlparser::ast::Ident::new("foo")]),
                    alias: None,
                    args: None,
                    with_hints: vec![],
                    partitions: vec![],
                    version: None,
                    with_ordinality: false,
                    json_path: None,
                    sample: None,
                    index_hints: vec![],
                },
                joins: vec![],
            }],
            lateral_views: vec![],
            selection: None,
            group_by: GroupByExpr::Expressions(vec![], vec![]),
            cluster_by: vec![],
            distribute_by: vec![],
            sort_by: vec![],
            having: None,
            qualify: None,
            named_window: vec![],
            value_table_mode: None,
            top_before_distinct: false,
            prewhere: None,
            window_before_qualify: false,
            connect_by: vec![],
            select_token: AttachedToken::empty(),
            flavor: SelectFlavor::Standard,
            optimizer_hint: None,
        };

        let sp_query = Box::new(
            SpQuery {
                with: None,
                body: Box::new(sqlparser::ast::SetExpr::Select(Box::new(select))),
                order_by: None,
                limit_clause: None,
                pipe_operators: vec![],
                fetch: None,
                locks: vec![],
                for_clause: None,
                settings: None,
                format_clause: None,
            }
            .try_into()
            .unwrap(),
        );

        let explain = ExplainStatement {
            analyze: false,
            verbose: false,
            format: None,
            statement: Box::new(Statement::Query(sp_query)),
        };

        assert_eq!(stmts[0], Statement::Explain(Box::new(explain)))
    }
}
