Mercurial > sci
comparison sql/jobresult-list-by-job.sql @ 62:eaebcc612a0d
misc: add header in SQL files
| author | David Demelier <markand@malikania.fr> |
|---|---|
| date | Thu, 18 Aug 2022 12:18:12 +0200 |
| parents | dae2de19ca5d |
| children | 71cd8447e3a4 |
comparison
equal
deleted
inserted
replaced
| 61:8be8188d61a5 | 62:eaebcc612a0d |
|---|---|
| 1 -- | |
| 2 -- jobresult-list-by-job.sql -- list most recent jobresults from a job | |
| 3 -- | |
| 4 -- Copyright (c) 2021-2022 David Demelier <markand@malikania.fr> | |
| 5 -- | |
| 6 -- Permission to use, copy, modify, and/or distribute this software for any | |
| 7 -- purpose with or without fee is hereby granted, provided that the above | |
| 8 -- copyright notice and this permission notice appear in all copies. | |
| 9 -- | |
| 10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES | |
| 11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF | |
| 12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR | |
| 13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES | |
| 14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN | |
| 15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF | |
| 16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. | |
| 17 -- | |
| 18 | |
| 1 SELECT rowid | 19 SELECT rowid |
| 2 , * | 20 , * |
| 3 FROM `jobresult` | 21 FROM `jobresult` |
| 4 WHERE `job_id` = ? | 22 WHERE `job_id` = ? |
| 5 ORDER BY `job_id` ASC | 23 ORDER BY `job_id` ASC |