schema-reverse-engineer 0.6.30

Reverse-engineer a live PostgreSQL or SQL Server database into a schema-rs XML schema definition
Documentation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
use super::{SqlServerClient, query, string};
use crate::error::SchemaReverseEngineerError;

pub async fn list_tables(
    client: &mut SqlServerClient,
    db_schema: &str,
) -> Result<Vec<String>, SchemaReverseEngineerError> {
    let rows = query(
        client,
        "SELECT t.name AS table_name \
         FROM sys.tables t \
         WHERE t.schema_id = SCHEMA_ID(@P1) AND t.is_ms_shipped = 0 \
         ORDER BY t.name",
        db_schema,
    )
    .await?;
    rows.iter().map(|r| string(r, "table_name")).collect()
}