Function test_role_lifecycle

graphlite/tests/security_role_user_tests.rs:18–46

()

#[test]
fn test_role_lifecycle() {
    let fixture = TestFixture::empty().expect("Failed to create test fixture");

    // Test CREATE ROLE
    fixture.assert_query_succeeds("CREATE ROLE 'data_scientist'");
    fixture.assert_query_succeeds("CREATE ROLE 'analyst'");
    fixture.assert_query_succeeds("CREATE ROLE 'viewer'");

    // Test duplicate role creation should fail
    fixture.assert_query_fails("CREATE ROLE 'data_scientist'", "already exists");

    // Test CREATE ROLE IF NOT EXISTS (may not be implemented yet)
    let if_not_exists_result = fixture.query("CREATE ROLE IF NOT EXISTS 'data_scientist'");
    if if_not_exists_result.is_ok() {
        fixture.assert_query_succeeds("CREATE ROLE IF NOT EXISTS 'new_role'");
    } else {
        fixture.assert_query_succeeds("CREATE ROLE 'new_role'");
    }

    // Test DROP ROLE
    fixture.assert_query_succeeds("DROP ROLE 'new_role'");

    // Test DROP ROLE IF EXISTS
    fixture.assert_query_succeeds("DROP ROLE IF EXISTS 'nonexistent_role'");
    fixture.assert_query_succeeds("DROP ROLE IF EXISTS 'analyst'");

    // Test dropping non-existent role should fail without IF EXISTS
    fixture.assert_query_fails("DROP ROLE 'nonexistent_role'", "not found");
}

#[test]
fn test_role_listing() {