"Fossies" - the Fresh Open Source Software Archive

Member "bareos-Release-21.1.4/core/src/cats/dml/0031_uar_jobid_fileindex" (5 Aug 2022, 481 Bytes) of package /linux/misc/bareos-Release-21.1.4.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 # Find JobId, FileIndex for a given path/file and date
    2 # for use when inserting individual files into the tree.
    3 
    4 SELECT Job.JobId,
    5        File.FileIndex
    6 FROM Job,
    7      File,
    8      Path,
    9      Client
   10 WHERE Job.JobId=File.JobId
   11   AND Job.StartTime<='%s'
   12   AND Path.Path='%s'
   13   AND File.Name='%s'
   14   AND Client.Name='%s'
   15   AND Job.ClientId=Client.ClientId
   16   AND Path.PathId=File.PathId
   17   AND JobStatus IN ('T',
   18                     'W')
   19   AND TYPE='B'
   20 ORDER BY Job.StartTime DESC
   21 LIMIT 1