Mercurial > sci

annotate sql/job-list.sql @ 83:28fd8b5247f0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
scid: make sure index page list most recents first
author David Demelier <markand@malikania.fr>
date Tue, 28 Feb 2023 16:31:34 +0100
parents 71cd8447e3a4
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
62
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
1 --
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
2 -- job-list.sql -- list all jobs for a project
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
3 --
80
71cd8447e3a4 misc: update copyright years
David Demelier <markand@malikania.fr>
parents: 62
diff changeset
4 -- Copyright (c) 2021-2023 David Demelier <markand@malikania.fr>
62
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
5 --
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
6 -- Permission to use, copy, modify, and/or distribute this software for any
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
7 -- purpose with or without fee is hereby granted, provided that the above
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
8 -- copyright notice and this permission notice appear in all copies.
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
9 --
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
17 --
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
18
26
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
19 SELECT rowid
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
20 , *
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
21 FROM `job`
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
22 WHERE `project_name` = ?
83
28fd8b5247f0 scid: make sure index page list most recents first
David Demelier <markand@malikania.fr>
parents: 80
diff changeset
23 ORDER BY `date` DESC