mssqlrust 1.0.2

Lightweight Rust library for Microsoft SQL Server using dataset and datatable
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

pub mod dataset;
pub mod services;
pub mod infrastructure;
mod repositories;

pub use repositories::{Command, CommandType, Parameter};
pub use services::{dataset_service::DatasetService, service::Service};

use anyhow::Result;
use crate::dataset::{DataSet, DataValue};
use crate::infrastructure::mssql::{MssqlConfig, SqlConnection};
use crate::repositories::MssqlDatasetRepository;

/// Execute a [`Command`] against the database using provided [`MssqlConfig`].
/// This function wires up the internal repository and service layers.
pub async fn execute(config: MssqlConfig, command: Command) -> Result<DataSet> {
    let connection = SqlConnection::connect(config).await?;
    let repo = MssqlDatasetRepository::new(connection);
    let mut service = DatasetService::new(repo);
    service.fetch(command).await
}

/// Execute a non-query [`Command`] (e.g., INSERT/UPDATE/DELETE/DDL) and return the
/// total number of affected rows. If the SQL contains multiple statements, the
/// returned count is the sum of row counts reported by the server.
pub async fn execute_non_query(config: MssqlConfig, command: Command) -> Result<u64> {
    let mut connection = SqlConnection::connect(config).await?;
    let (sql, params) = command.build();
    connection.execute_non_query(&sql, params).await
}

/// Execute a [`Command`] and return the first column of the first row
/// as a `DataValue`. If the command returns no rows, returns `Ok(None)`.
pub async fn execute_scalar(config: MssqlConfig, command: Command) -> Result<Option<DataValue>> {
    let mut connection = SqlConnection::connect(config).await?;
    let (sql, params) = command.build();
    connection.execute_scalar(&sql, params).await
}