Function test_schema_ddl_operations

graphlite/tests/ddl_shared_tests.rs:20–46

()

#[test]
fn test_schema_ddl_operations() {
    let fixture = get_shared_fixture();

    // Create a schema within this test's isolated schema namespace
    let test_schema = "business_schema";

    // Test CREATE SCHEMA
    fixture.assert_query_succeeds(&format!("CREATE SCHEMA IF NOT EXISTS {}", test_schema));

    // Test schema creation without IF NOT EXISTS
    fixture.assert_query_succeeds("CREATE SCHEMA new_schema");

    // Test duplicate schema creation should fail
    fixture.assert_query_fails("CREATE SCHEMA new_schema", "already exists");

    // Test IF NOT EXISTS prevents errors
    fixture.assert_query_succeeds("CREATE SCHEMA IF NOT EXISTS new_schema");

    // Test DROP SCHEMA
    fixture.assert_query_succeeds("DROP SCHEMA IF EXISTS new_schema");

    // Test dropping non-existent schema with IF EXISTS
    fixture.assert_query_succeeds("DROP SCHEMA IF EXISTS nonexistent_schema");

    // Test dropping non-existent schema without IF EXISTS should fail
    fixture.assert_query_fails("DROP SCHEMA nonexistent_schema_2", "not found");
}

#[test]
fn test_drop_schema_basic() {