Misi c6a6b9fdd2 IAM: Create and delete user from the legacy store (#107694) ...

* Add Create for User + DualWriter setup

* Add delete User

* Fix delete + access check

* Add tests for delete user

* Add tests for create user

* Fixes

* Use sqlx session to fix database locked issues

* wip authz checks

* legacyAccessClient

* Update legacyAccessClient, add tests for create user

* Close rows before running other queries

* Use ExecWithReturningId

* Verify deletion in the tests

* Add Validate and Mutate

* Other changes

* Address feedback

* Update tests

---------

Co-authored-by: Gabriel Mabille <gabriel.mabille@grafana.com>

2025-07-17 11:50:40 +02:00

..

mysql--create_org_user-create_org_user_admin.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

mysql--create_org_user-create_org_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

mysql--create_user-create_user_admin.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

mysql--create_user-create_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

mysql--delete_org_user-delete_org_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

mysql--delete_org_user-delete_org_user_different_id.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

mysql--delete_user-delete_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

mysql--delete_user-delete_user_different_org.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

mysql--display_query-display_ids_uids.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

mysql--display_query-display_ids.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

mysql--display_query-display_uids.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

mysql--service_account_internal_id-basic.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

mysql--service_account_tokens_query-service_account_tokens_page_1.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

mysql--service_account_tokens_query-service_account_tokens.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

mysql--service_account_tokens_query-service_accounts_tokens_page_2.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

mysql--service_accounts_query-service_accounts_page_1.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

mysql--service_accounts_query-service_accounts_page_2.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

mysql--service_accounts_query-service_accounts.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

mysql--team_bindings_query-team_1_bindings.sql

…

mysql--team_bindings_query-team_bindings_page_1.sql

…

mysql--team_bindings_query-team_bindings_page_2.sql

…

mysql--team_internal_id-team_internal_id.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

mysql--team_members_query-team_1_members_page_1.sql

…

mysql--team_members_query-team_1_members_page_2.sql

…

mysql--teams_query-teams_page_1.sql

…

mysql--teams_query-teams_page_2.sql

…

mysql--teams_query-teams_uid.sql

…

mysql--user_internal_id-user_internal_id.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

mysql--user_teams_query-team_1_members_page_1.sql

…

mysql--user_teams_query-team_1_members_page_2.sql

…

mysql--users_query-users_page_1.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

mysql--users_query-users_page_2.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

mysql--users_query-users_uid.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

postgres--create_org_user-create_org_user_admin.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

postgres--create_org_user-create_org_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

postgres--create_user-create_user_admin.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

postgres--create_user-create_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

postgres--delete_org_user-delete_org_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

postgres--delete_org_user-delete_org_user_different_id.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

postgres--delete_user-delete_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

postgres--delete_user-delete_user_different_org.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

postgres--display_query-display_ids_uids.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

postgres--display_query-display_ids.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

postgres--display_query-display_uids.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

postgres--service_account_internal_id-basic.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

postgres--service_account_tokens_query-service_account_tokens_page_1.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

postgres--service_account_tokens_query-service_account_tokens.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

postgres--service_account_tokens_query-service_accounts_tokens_page_2.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

postgres--service_accounts_query-service_accounts_page_1.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

postgres--service_accounts_query-service_accounts_page_2.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

postgres--service_accounts_query-service_accounts.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

postgres--team_bindings_query-team_1_bindings.sql

…

postgres--team_bindings_query-team_bindings_page_1.sql

…

postgres--team_bindings_query-team_bindings_page_2.sql

…

postgres--team_internal_id-team_internal_id.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

postgres--team_members_query-team_1_members_page_1.sql

…

postgres--team_members_query-team_1_members_page_2.sql

…

postgres--teams_query-teams_page_1.sql

…

postgres--teams_query-teams_page_2.sql

…

postgres--teams_query-teams_uid.sql

…

postgres--user_internal_id-user_internal_id.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

postgres--user_teams_query-team_1_members_page_1.sql

…

postgres--user_teams_query-team_1_members_page_2.sql

…

postgres--users_query-users_page_1.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

postgres--users_query-users_page_2.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

postgres--users_query-users_uid.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

sqlite--create_org_user-create_org_user_admin.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

sqlite--create_org_user-create_org_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

sqlite--create_user-create_user_admin.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

sqlite--create_user-create_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

sqlite--delete_org_user-delete_org_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

sqlite--delete_org_user-delete_org_user_different_id.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

sqlite--delete_user-delete_user_basic.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

sqlite--delete_user-delete_user_different_org.sql

IAM: Create and delete user from the legacy store (#107694)

2025-07-17 11:50:40 +02:00

sqlite--display_query-display_ids_uids.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

sqlite--display_query-display_ids.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

sqlite--display_query-display_uids.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

sqlite--service_account_internal_id-basic.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

sqlite--service_account_tokens_query-service_account_tokens_page_1.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

sqlite--service_account_tokens_query-service_account_tokens.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

sqlite--service_account_tokens_query-service_accounts_tokens_page_2.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

sqlite--service_accounts_query-service_accounts_page_1.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

sqlite--service_accounts_query-service_accounts_page_2.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

sqlite--service_accounts_query-service_accounts.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

sqlite--team_bindings_query-team_1_bindings.sql

…

sqlite--team_bindings_query-team_bindings_page_1.sql

…

sqlite--team_bindings_query-team_bindings_page_2.sql

…

sqlite--team_internal_id-team_internal_id.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

sqlite--team_members_query-team_1_members_page_1.sql

…

sqlite--team_members_query-team_1_members_page_2.sql

…

sqlite--teams_query-teams_page_1.sql

…

sqlite--teams_query-teams_page_2.sql

…

sqlite--teams_query-teams_uid.sql

…

sqlite--user_internal_id-user_internal_id.sql

SQLTemplates: Add helper to ensure all templates have a test-case (#103964)

2025-04-22 11:21:51 +02:00

sqlite--user_teams_query-team_1_members_page_1.sql

…

sqlite--user_teams_query-team_1_members_page_2.sql

…

sqlite--users_query-users_page_1.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

sqlite--users_query-users_page_2.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00

sqlite--users_query-users_uid.sql

IAM: Move resource definitions to apps/iam step 1 (#107389)

2025-07-04 11:07:48 +02:00