// Copyright Materialize, Inc. and contributors. All rights reserved.
//
// Use of this software is governed by the Business Source License
// included in the LICENSE file.
//
// As of the Change Date specified in that file, in accordance with
// the Business Source License, use of this software will be governed
// by the Apache License, Version 2.0.
use anyhow::Context;
use mz_sql_server_util::{Client, Config};
use crate::action::{ControlFlow, State};
use crate::parser::BuiltinCommand;
pub async fn run_connect(
mut cmd: BuiltinCommand,
state: &mut State,
) -> Result<ControlFlow, anyhow::Error> {
let name = cmd.args.string("name")?;
cmd.args.done()?;
let ado_string = cmd.input.join("\n");
let config = Config::from_ado_string(&ado_string).context("parsing ADO string: {}")?;
let (client, connection) = Client::connect(config)
.await
.context("connecting to SQL server")?;
state.sql_server_clients.insert(name.clone(), client);
// Spawn the connection in a tokio task so it gets polled.
let task_name = format!("sql-server {name} connection");
mz_ore::task::spawn(|| task_name, async move {
connection.await;
tracing::info!("SQL Server connection '{name}' closed");
});
Ok(ControlFlow::Continue)
}