"Fossies" - the Fresh Open Source Software Archive

Member "bareos-Release-20.0.2/core/src/cats/dml/0040_uap_upgrade_copies_oldest_job" (10 Jun 2021, 419 Bytes) of package /linux/misc/bareos-Release-20.0.2.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 # Select the first available Copy Job that must be upgraded to a Backup job when the original backup job is expired.
    2 
    3 CREATE TEMPORARY TABLE cpy_tmp AS
    4 SELECT MIN(JobId) AS JobId
    5   FROM Job
    6  WHERE Type = '%c'
    7    AND (
    8           PriorJobId IN (%s)
    9        OR PriorJobId IN (
   10          SELECT PriorJobId
   11            FROM Job
   12           WHERE JobId IN (%s)
   13             AND Type = 'B'
   14           )
   15        )
   16  GROUP BY PriorJobId