Struct SQLImporter 

pub struct SQLImporter {
    pub dialect: String,
}

SQL Importer - parses CREATE TABLE statements

Fields

dialect: String

SQL dialect to use for parsing

Implementations

impl SQLImporter

pub fn new(dialect: &str) -> Self

Create a new SQL importer with the specified dialect

Arguments

• dialect - SQL dialect name (“postgres”, “mysql”, “sqlite”, “generic”)

Example

use data_modelling_sdk::import::sql::SQLImporter;

let importer = SQLImporter::new("postgres");

pub fn parse(&self, sql: &str) -> Result<ImportResult>

Parse SQL and extract table definitions

Arguments

• sql - SQL string containing CREATE TABLE statements

Returns

An ImportResult containing extracted tables and any parse errors.

Example

use data_modelling_sdk::import::sql::SQLImporter;

let importer = SQLImporter::new("postgres");
let sql = "CREATE TABLE users (id INT PRIMARY KEY, name VARCHAR(100));";
let result = importer.parse(sql).unwrap();
assert_eq!(result.tables.len(), 1);

pub fn parse_liquibase(&self, sql: &str) -> Result<ImportResult>

Parse SQL with Liquibase format support

Strips Liquibase directive comments (–liquibase formatted sql, –changeset, etc.) before parsing the SQL.

Arguments

• sql - SQL string with optional Liquibase comments

Returns

An ImportResult containing extracted tables.

Example

use data_modelling_sdk::import::sql::SQLImporter;

let importer = SQLImporter::new("postgres");
let sql = r#"
--liquibase formatted sql
--changeset user:1
CREATE TABLE users (id INT);
"#;
let result = importer.parse_liquibase(sql).unwrap();

Trait Implementations

impl Default for SQLImporter

fn default() -> Self

Returns the “default value” for a type.