ci(python): run the integration tests on pytest-xdist workers - #45756

…names table)

Two leftovers of the serial run that pytest-xdist workers do not inherit:

- PUBLIC_ROLE_LIKE: `superset init` gave Public the Gamma permissions, but
  the first public_role_like_* fixture teardown cleared them and most of the
  suite asserts anonymous requests are rejected on that cleared role. The
  test config now starts from a cleared Public role; tests that need Gamma
  use the public_role_like_gamma fixtures.
- Table id 1: the first load_birth_names_dashboard_with_slices use created
  the birth_names SqlaTable and left the row behind, which the many
  insert_chart(..., 1) callers and the "[examples].[birth_names](id:1)"
  assertions rely on. An autouse session fixture now does that once up
  front.

test_get_catalog_names tolerates the per-worker superset_gw<N> databases.

Co-Authored-By: Evan Rusackas <evan@preset.io>
Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>

… alone

Under pytest-xdist each worker runs only part of the suite, so state that
one file used to leave behind for a later one is no longer guaranteed to
be there. Fix the tests that depended on it:

- sql_lab/test_execute_sql_statements: superset.sql_lab.results_backend is
  a werkzeug LocalProxy, which defines __await__, so patch() built an
  AsyncMock whose set() returned a truthy coroutine. In a serial run
  sql_lab/api_tests.py had already swapped the proxy for a plain Mock, which
  hid this. Pin new_callable=MagicMock.
- core_tests permalink tests: the anonymous-access assertions need the
  Public role to reach the view, which the serial run got from the first
  public_role fixture leaking Gamma permissions. Use
  public_role_like_gamma_scoped explicitly.
- fixtures/users.create_role_with_permissions: add_role() returns an
  existing role untouched and the fixtures never delete their roles, so the
  "dar" role created by databases/api_tests.py with only
  all_database_access shadowed the datasource_access one security_tests
  expected. Make the role carry the requested permissions.
- reports/api_tests native-filter tests: they query the first Dashboard
  without creating one; load the birth_names dashboard.
- saved_queries related-databases test: compare by database id instead of
  relying on physical row order, which PostgreSQL does not preserve across
  updates.

Co-Authored-By: Evan Rusackas <evan@preset.io>
Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>

…migrated

The semantic-cache coordination job runs integration tests against a
bare SQLite file, so the session autouse fixture failed at setup with
'no such table: dbs'.

Co-Authored-By: Evan Rusackas <evan@preset.io>
Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>