"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