Mercurial > sci
view sql/jobresult-list-by-worker.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 | 3cf148705724 |
children | 71cd8447e3a4 |
line wrap: on
line source
-- -- jobresult-list-by-worker.sql -- list all jobresults by a worker -- -- Copyright (c) 2021-2022 David Demelier <markand@malikania.fr> -- -- Permission to use, copy, modify, and/or distribute this software for any -- purpose with or without fee is hereby granted, provided that the above -- copyright notice and this permission notice appear in all copies. -- -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. -- SELECT rowid , * FROM `jobresult` WHERE `worker_name` = ? ORDER BY `job_id` ASC