Mercurial > paster
comparison sql/search.sql @ 78:9bfe5ce3cc45
pasterd: rework themes
author | David Demelier <markand@malikania.fr> |
---|---|
date | Thu, 16 Mar 2023 20:45:59 +0100 |
parents | |
children |
comparison
equal
deleted
inserted
replaced
77:fe78b16c694d | 78:9bfe5ce3cc45 |
---|---|
1 -- | |
2 -- search.sql -- search existing public pastes | |
3 -- | |
4 -- Copyright (c) 2020-2023 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 | |
19 SELECT `id` | |
20 , `title` | |
21 , `author` | |
22 , `language` | |
23 , `code` | |
24 , strftime('%s', date) | |
25 , `visible` | |
26 , `duration` | |
27 FROM paste | |
28 WHERE `title` like ? | |
29 AND `author` like ? | |
30 AND `language` like ? | |
31 AND `visible` = 1 | |
32 ORDER BY date DESC | |
33 LIMIT ? |