Resolve any constraint wildcards by looking for matches in the local database, e.g.:
SELECT DISTINCT model FROM esgf_dataset WHERE model ILIKE 'ACCESS%' ;Call find_missing_id() with the resolved constraints
- Search ESGF using the constraints, returning the checksum of each matching file
- Match the ESGF checksums against the local metadata database
- Return the ESGF id for any files whose checksums cannot be found in the local database
Query the local database for files:
SELECT path FROM esgf_paths NATURAL JOIN esgf_metadata_dataset_link NATURAL JOIN esgf_dataset WHERE model ILIKE 'ACCESS%' -- ... ;
- If using the
--latest
flag, query ESGF using the constraints toretrieve checksums, match these checksums against the local results and return only those found. This is the default behaviour