|
78
|
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 ? |
