Function test_user_lifecycle

graphlite/tests/security_role_user_tests.rs:104–133

()

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

    // Test CREATE USER
    fixture.assert_query_succeeds("CREATE USER 'alice' PASSWORD 'password123'");
    fixture.assert_query_succeeds("CREATE USER 'bob' PASSWORD 'secret456'");
    fixture.assert_query_succeeds("CREATE USER 'charlie' PASSWORD 'pass789'");

    // Test duplicate user creation should fail
    fixture.assert_query_fails("CREATE USER 'alice' PASSWORD 'newpass'", "already exists");

    // Test CREATE USER IF NOT EXISTS (may not be implemented yet)
    let if_not_exists_result =
        fixture.query("CREATE USER IF NOT EXISTS 'alice' PASSWORD 'ignored'");
    if if_not_exists_result.is_ok() {
        fixture.assert_query_succeeds("CREATE USER IF NOT EXISTS 'diana' PASSWORD 'newpass'");
    } else {
        fixture.assert_query_succeeds("CREATE USER 'diana' PASSWORD 'newpass'");
    }

    // Test DROP USER
    fixture.assert_query_succeeds("DROP USER 'diana'");

    // Test DROP USER IF EXISTS
    fixture.assert_query_succeeds("DROP USER IF EXISTS 'nonexistent_user'");
    fixture.assert_query_succeeds("DROP USER IF EXISTS 'charlie'");

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

#[test]
fn test_user_listing() {