Query class

[peterwilsoncc]

A query class, the intent behind it is to set up persistent caching:

Global Caches

• cavalcade-jobs: Individual jobs

  • name: job:{$job_id}

• cavalcade-query: Query results

  • name: query:{$site_id}:{$query_and_last_changed_hash}
  • name: query:{$site_id}:last_changed

Need to store the last changed time on a site by site basis and include that as part of the query hash.

Query

Constructs a Database query based on given paramaters

• Each individual query runs two DB queries:

  • The first returns the IDs for a given query and warms query cache
  • The second queries the IDs (SELECT WHERE IN), excluding those already cached, and warms each job's cache

• Key parameters

  • Fields: the fields to return ALL (Default), ID
  • Hook: Required
  • Site ID: defaults to current site ID
  • nextrun: default >= time() -- may be able to use WP_Date_Query
  • args: default []
  • status: default waiting

[peterwilsoncc]

Yeah, yeah, nah.

Closing this off as it looks like it will be covered elsewhere.