Struct SQLExporter 

pub struct SQLExporter;

Exporter for SQL CREATE TABLE format.

Implementations

impl SQLExporter

pub fn export_table(table: &Table, dialect: Option<&str>) -> String

Export a table to SQL CREATE TABLE statement.

Arguments

• table - The table to export
• dialect - Optional SQL dialect (“postgres”, “mysql”, “sqlserver”, etc.)

Returns

A SQL CREATE TABLE statement as a string, with proper identifier quoting and escaping based on the dialect.

Example

use data_modelling_core::export::sql::SQLExporter;
use data_modelling_core::models::{Table, Column};

let table = Table::new(
    "users".to_string(),
    vec![Column::new("id".to_string(), "INT".to_string())],
);

let sql = SQLExporter::export_table(&table, Some("postgres"));
// Returns: CREATE TABLE "users" (\n  "id" INT\n);

pub fn export( &self, tables: &[Table], dialect: Option<&str>, ) -> Result<ExportResult, ExportError>

Export tables to SQL CREATE TABLE statements (SDK interface).

Arguments

• tables - Slice of tables to export
• dialect - Optional SQL dialect

Returns

An ExportResult containing the SQL statements for all tables.

Example

use data_modelling_core::export::sql::SQLExporter;
use data_modelling_core::models::{Table, Column};

let tables = vec![
    Table::new("users".to_string(), vec![Column::new("id".to_string(), "INT".to_string())]),
    Table::new("orders".to_string(), vec![Column::new("id".to_string(), "INT".to_string())]),
];

let exporter = SQLExporter;
let result = exporter.export(&tables, Some("postgres")).unwrap();
assert_eq!(result.format, "sql");

pub fn export_model( model: &DataModel, table_ids: Option<&[Uuid]>, dialect: Option<&str>, ) -> String

Export a data model to SQL CREATE TABLE statements (legacy method for compatibility).