@skip_if_github_validation @scope_reportdb @test_issue @sle_minion

Feature: 0109 - Report database

Description: * Related GitHub Card: https://github.com/SUSE/spacewalk/issues/30810
In order to use reporting tools
As an authorized user
I want to access and use the report database named "ReportDB"

File name: srv_reportdb.feature

Relative path: secondary/srv_reportdb.feature

Scenarios

Chart

Status

Progress

Passed	100.00 %
Failed	0.00 %

Total duration:

00:01:31.432

@skip_if_github_validation @scope_reportdb @test_issue

Scenario: Log in as admin user

@skip_if_github_validation @scope_reportdb @test_issue

Scenario: Populate the report database after bootstrapping minions

@skip_if_github_validation @scope_reportdb @test_issue

Scenario: Connect to the ReportDB on the server with admin user

Then I should be able to connect to the ReportDB on the server 00:00:03.228

And there should be a user allowed to create roles on the ReportDB 00:00:04.442

@skip_if_github_validation @scope_reportdb @test_issue

Scenario: Create read-only user

When I create a read-only user for the ReportDB 00:00:04.126

Then I should see the read-only user listed on the ReportDB user accounts 00:00:02.717

@skip_if_github_validation @scope_reportdb @test_issue

Scenario: External read-only user can connect to ReportDB and make queries

When I connect to the ReportDB with read-only user from external machine 00:00:00.067

Then I should be able to query the ReportDB 00:00:00.001

@skip_if_github_validation @scope_reportdb @test_issue

Scenario: Read-only user can't make changes in the ReportDB

Then I should not be able to "insert" data in a ReportDB "table" as a read-only user 00:00:00.002

And I should not be able to "update" data in a ReportDB "table" as a read-only user 00:00:00.001

And I should not be able to "delete" data in a ReportDB "table" as a read-only user 00:00:00.000

And I should not be able to "insert" data in a ReportDB "view" as a read-only user 00:00:00.000

And I should not be able to "update" data in a ReportDB "view" as a read-only user 00:00:00.000

And I should not be able to "delete" data in a ReportDB "view" as a read-only user 00:00:00.000

@skip_if_github_validation @scope_reportdb @test_issue @test_issue

Scenario: ReportDB admin user can't access product database from external machine

Given I know the ReportDB admin user credentials 00:00:07.191

Then I should be able to connect to the ReportDB with the ReportDB admin user 00:00:00.061

And I should not be able to connect to product database with the ReportDB admin user 00:00:00.092

@skip_if_github_validation @scope_reportdb @test_issue

Scenario: The systems should match between the UI and the ReportDB

When I follow the left menu "Systems > System List > All" 00:00:00.219

And I make a list of the existing systems 00:00:10.003

Then I should find the systems from the UI in the ReportDB 00:00:00.000

@skip_if_github_validation @scope_reportdb @test_issue @sle_minion

Scenario: System changes should be reflected in systems, on ReportDB

Given I have a property "City" with value "Arrakeen" on "sle_minion" 00:00:15.163

+ Show Info

Search by hostname: uyuni-master-suse-minion
[{"last_boot"=>"2026-06-29T16:35:02Z", "name"=>"uyuni-master-suse-minion.sumaci.aws", "id"=>1000010023, "last_checkin"=>"2026-06-29T18:59:20Z"}]

And I know the current synced_date for "sle_minion" 00:00:00.002

When I schedule a task to update ReportDB 00:00:16.556

Then I should find the updated "City" property as "Arrakeen" on the "sle_minion", on ReportDB 00:00:00.000

@skip_if_github_validation @scope_reportdb @test_issue

Scenario: Cleanup: delete read-only user

When I delete the read-only user for the ReportDB 00:00:07.632

Then I shouldn't see the read-only user listed on the ReportDB user accounts 00:00:02.868