Mercurial > sci

comparison sql/worker-find.sql @ 22:dd078aea5d02

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc: use project/worker name as primary key
author David Demelier <markand@malikania.fr>
date Thu, 21 Jul 2022 20:23:22 +0200
parents de4bf839b565
children 081e1c258e64
comparison
equal deleted inserted replaced
21:ec30e1b078a9 22:dd078aea5d02
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN 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 15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. 16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
17 -- 17 --
18 18
19 SELECT rowid 19 SELECT *
20 , *
21 FROM `worker` 20 FROM `worker`
22 WHERE `name` = ? 21 WHERE `name` = ?
23 LIMIT 1 22 LIMIT 1