api,server: list autoscalevmgroups with keyword

[shwstppr]

Description

fixes #9042

Types of changes

• [ ] Breaking change (fix or feature that would cause existing functionality to change)
• [ ] New feature (non-breaking change which adds functionality)
• [x] Bug fix (non-breaking change which fixes an issue)
• [ ] Enhancement (improves an existing feature and functionality)
• [ ] Cleanup (Code refactoring and cleanup, that may add test cases)
• [ ] build/CI

Feature/Enhancement Scale or Bug Severity

Feature/Enhancement Scale

• [ ] Major
• [ ] Minor

Bug Severity

• [ ] BLOCKER
• [ ] Critical
• [ ] Major
• [ ] Minor
• [ ] Trivial

Screenshots (if appropriate):

How Has This Been Tested?

https://github.com/apache/cloudstack/assets/153340/71d5ea98-f156-4951-a2f9-a305df2e3790

How did you try to break this feature and the system with this change?

[codecov-commenter]

Codecov Report

Attention: Patch coverage is 0% with 4 lines in your changes are missing coverage. Please review.

Project coverage is 14.96%. Comparing base (87e7c57) to head (6e8f6e2).

Files	Patch %	Lines
...ava/com/cloud/network/as/AutoScaleManagerImpl.java	0.00%	4 Missing :warning:

Additional details and impacted files

@@             Coverage Diff              @@
##               4.19    #9046      +/-   ##
============================================
- Coverage     14.96%   14.96%   -0.01%     
+ Complexity    10995    10992       -3     
============================================
  Files          5373     5373              
  Lines        469005   469009       +4     
  Branches      58953    58345     -608     
============================================
- Hits          70198    70186      -12     
- Misses       391036   391054      +18     
+ Partials       7771     7769       -2     

Flag	Coverage Δ
uitests	4.31% <ø> (ø)
unittests	15.67% <0.00%> (-0.01%)	:arrow_down:

Flags with carried forward coverage won't be shown. Click here to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[DaanHoogland]

@shwstppr , did you test this? it seems strange that this would work as the DB does not have a field 'keyword'. I would expect a bit of code like

        if (keyword != null) {
            SearchCriteria<AccountJoinVO> ssc = _accountJoinDao.createSearchCriteria();
            ssc.addOr("accountName", SearchCriteria.Op.LIKE, "%" + keyword + "%");
            ssc.addOr("state", SearchCriteria.Op.LIKE, "%" + keyword + "%");
            sc.addAnd("accountName", SearchCriteria.Op.SC, ssc);
        }

(stolen from ListAccounts)

[shwstppr]

@shwstppr , did you test this? it seems strange that this would work as the DB does not have a field 'keyword'. I would expect a bit of code like

        if (keyword != null) {
            SearchCriteria<AccountJoinVO> ssc = _accountJoinDao.createSearchCriteria();
            ssc.addOr("accountName", SearchCriteria.Op.LIKE, "%" + keyword + "%");
            ssc.addOr("state", SearchCriteria.Op.LIKE, "%" + keyword + "%");
            sc.addAnd("accountName", SearchCriteria.Op.SC, ssc);
        }

(stolen from ListAccounts)

@DaanHoogland at line 1188, name field is used

[shwstppr]

And I already added a screen recording of my testing in the description

[DaanHoogland]

@DaanHoogland at line 1188, name field is used

yes, so only the name is possible in a keyword search!? not state, min/max, etc; that is what I question.

[DaanHoogland]

yes, so only the name is possible in a keyword search!? not state, min/max, etc; that is what I question.

I have been reading the code again and I think we may choose to leave it at this , sorry to question @shwstppr . We may allow search for extra but this is at least sensible functionality.

[shwstppr]

@blueorangutan package

[blueorangutan]

@shwstppr a [SL] Jenkins job has been kicked to build packages. It will be bundled with KVM, XenServer and VMware SystemVM templates. I'll keep you posted as I make progress.

[blueorangutan]

Packaging result [SF]: ✔️ el7 ✔️ el8 ✔️ el9 ✔️ debian ✔️ suse15. SL-JID 9582

[DaanHoogland]

@blueorangutan test

[blueorangutan]

@DaanHoogland a [SL] Trillian-Jenkins test job (centos7 mgmt + kvm-centos7) has been kicked to run smoke tests

[blueorangutan]

[SF] Trillian Build Failed (tid-10213)

[shwstppr]

@blueorangutan package

[blueorangutan]

@shwstppr a [SL] Jenkins job has been kicked to build packages. It will be bundled with KVM, XenServer and VMware SystemVM templates. I'll keep you posted as I make progress.

[blueorangutan]

Packaging result [SF]: ✔️ el7 ✔️ el8 ✔️ el9 ✔️ debian ✔️ suse15. SL-JID 9655

[weizhouapache]

@blueorangutan test rocky8 kvm-rocky8

[blueorangutan]

@weizhouapache a [SL] Trillian-Jenkins test job (rocky8 mgmt + kvm-rocky8) has been kicked to run smoke tests

[blueorangutan]

[SF] Trillian test result (tid-10237) Environment: kvm-rocky8 (x2), Advanced Networking with Mgmt server r8 Total time taken: 46979 seconds Marvin logs: https://github.com/blueorangutan/acs-prs/releases/download/trillian/pr9046-t10237-kvm-rocky8.zip Smoke tests completed. 127 look OK, 4 have errors, 0 did not run Only failed and skipped tests results shown below:

Test	Result	Time (s)	Test File
test_01_events_resource	Error	420.44	test_events_resource.py
test_create_pvlan_network	Error	0.11	test_pvlan.py
test_02_trigger_shutdown	Failure	341.87	test_safe_shutdown.py
test_05_vmschedule_test_e2e	Failure	362.75	test_vm_schedule.py

[DaanHoogland]

@blueorangutan test alma9 kvm-alma9

[blueorangutan]

@DaanHoogland a [SL] Trillian-Jenkins test job (alma9 mgmt + kvm-alma9) has been kicked to run smoke tests

[blueorangutan]

[SF] Trillian test result (tid-10262) Environment: kvm-alma9 (x2), Advanced Networking with Mgmt server a9 Total time taken: 56687 seconds Marvin logs: https://github.com/blueorangutan/acs-prs/releases/download/trillian/pr9046-t10262-kvm-alma9.zip Smoke tests completed. 127 look OK, 4 have errors, 0 did not run Only failed and skipped tests results shown below:

Test	Result	Time (s)	Test File
test_01_events_resource	Error	423.68	test_events_resource.py
test_list_system_vms_metrics_history	Failure	0.27	test_metrics_api.py
test_01_sys_vm_start	Failure	240.49	test_secondary_storage.py
test_11_destroy_ssvm	Failure	923.73	test_ssvm.py
test_12_destroy_cpvm	Failure	920.06	test_ssvm.py

[shwstppr]

@blueorangutan package

[blueorangutan]

@shwstppr a [SL] Jenkins job has been kicked to build packages. It will be bundled with KVM, XenServer and VMware SystemVM templates. I'll keep you posted as I make progress.

[blueorangutan]

Packaging result [SF]: ✔️ el7 ✔️ el8 ✔️ el9 ✔️ debian ✔️ suse15. SL-JID 9697

[shwstppr]

@blueorangutan test

[blueorangutan]

@shwstppr a [SL] Trillian-Jenkins test job (centos7 mgmt + kvm-centos7) has been kicked to run smoke tests

[blueorangutan]

[SF] Trillian test result (tid-10281) Environment: kvm-centos7 (x2), Advanced Networking with Mgmt server 7 Total time taken: 43207 seconds Marvin logs: https://github.com/blueorangutan/acs-prs/releases/download/trillian/pr9046-t10281-kvm-centos7.zip Smoke tests completed. 131 look OK, 0 have errors, 0 did not run Only failed and skipped tests results shown below:

Test	Result	Time (s)	Test File

[shwstppr]

Merging based on approvals and test results