iridium_server 0.1.12

TDS 7.4 server for Iridium SQL
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

//! Playground mode for iridium-server
//!
//! Provides a seeded database with sample tables, views, and data
//! for testing SQL Server clients without requiring complex setup.

pub mod data;
pub mod schema;
pub mod views;

use iridium_core::{SessionManager, StatementExecutor};

/// Seeds the database with playground schema and data
pub fn seed_playground<D>(db: &D) -> Result<(), iridium_core::DbError>
where
    D: SessionManager + StatementExecutor,
{
    let session_id = db.create_session();

    // Execute schema creation
    for sql in schema::DDL_STATEMENTS {
        db.execute_session_batch_sql(session_id, sql)?;
    }

    // Execute views creation
    for sql in views::DDL_STATEMENTS {
        db.execute_session_batch_sql(session_id, sql)?;
    }

    // Insert sample data
    for sql in data::INSERT_STATEMENTS {
        db.execute_session_batch_sql(session_id, sql)?;
    }

    let _ = db.close_session(session_id);
    Ok(())
}