Summary of Changes

System Tests are failing with #46631 as db_createCategory() hacks the category simplified in the database table. To prevent reimplementing nested set properly (lft/rgt/level/path) it is simple replaced by api_post() call.

• Replaced all db_createCategory() by api_post()
• Deleted db_createCategory() command in source and documentation
• Unified all create category usage with beforeEach() deletion as recommended by Cypress.
  • This ensures even with test canceled in the middle of execution, the next test will work.
  • As there is no afterEach there may stay objects in instance, e.g. news feed category 'Automated System Tests Category Title feed delete'
• Introduced support/constants.mjs with AST_CATEGORY_TITLE
  • Only used for the changed stuff, could be extended later
• Note: There are 19 more db_* commands, but the other ones we would leave for performance reasons.

Testing Instructions

• Code review is needed and requested before human tests
• Human tests:
  • System Tests should run without error (this is already given by CI)
  • System Tests should run withouts errors including PR #46631
  • Single System Tests (without Joomla installation step) should be running multiple times without errors,
    choose one or multiple of the modified tests, e.g.

    npx cypress run --spec tests/System/integration/administrator/components/com_categories/Categories.cy.js
    npx cypress run --spec tests/System/integration/administrator/components/com_categories/Categories.cy.js
    

  • Check db_createCategory() is removed from source and documentation

Actual result BEFORE applying this Pull Request

• System Tests failing with #46631

Expected result AFTER applying this Pull Request

• System Tests passed with #46631

Link to documentations

Please select:

• Documentation link for docs.joomla.org:

• No documentation changes for docs.joomla.org needed

• Pull Request link for manual.joomla.org:

• No documentation changes for manual.joomla.org needed