"Fossies" - the Fresh Open Source Software Archive

Member "bareos-Release-20.0.3/core/src/cats/dml/0023_uar_dif" (14 Sep 2021, 633 Bytes) of package /linux/misc/bareos-Release-20.0.3.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 INSERT INTO temp
    2 SELECT Job.JobId, Job.JobTDate, Job.ClientId, Job.Level, Job.JobFiles, Job.JobBytes, Job.StartTime, Media.VolumeName,
    3        JobMedia.StartFile, Job.VolSessionId, Job.VolSessionTime
    4   FROM Job, JobMedia, Media, FileSet
    5  WHERE Job.JobTDate     > %s
    6    AND Job.StartTime    < '%s'
    7    AND Job.ClientId     = %s
    8    AND JobMedia.JobId   = Job.JobId
    9    AND Media.Enabled    = 1
   10    AND JobMedia.MediaId = Media.MediaId
   11    AND Job.Level        = 'D'
   12    AND JobStatus IN ('T','W')
   13    AND Type             = 'B'
   14    AND Job.FileSetId    = FileSet.FileSetId
   15    AND FileSet.FileSet  = '%s' %s
   16  ORDER BY Job.JobTDate DESC LIMIT 1