3.19 - Preconnect to external domains - Data insertion part

[piotrbak]

User Story
As a user, I want to see the eligible external domains in the database when manually visiting a page

Acceptance Criteria

• The table is created with a fresh install and with an update
• These data are stored in DB when visiting the uncached page while nothing in DB (to be adjusted)
  • URL, ID, device type, status, error message
  • Eligible domain name
• Any possible error will be saved into the DB and status set to failed
• If no proper connections are found, we’ll save this fact to the database and set the status to completed

[wordpressfan]

Database structure is here:
https://www.notion.so/wpmedia/External-domains-preconnect-database-structure-18bed22a22f080e0932dc9ce220a1154

[jeawhanlee]

Scope a solution ✅

• Create the database modules for the PreconnectExternalDomains namespace if not created, the same way we do for the other performance hints features, for example here
  • Queries
  • Rows
  • Schemas
  • Tables
• Use this for the schema
• Create the ajax Controller in the AJAX namespace. The controller will implement WP_Rocket\Engine\Common\PerformanceHints\AJAX\ControllerInterface
• Add the must-implement methods( add_data & check_data ). Add the logic to process data in both methods.
• Update or Add ServiceProvider if not created.
• Add tests

Estimate the effort ✅

[S]

[Khadreal]

Merged this to unblock #7243