comparison database.c @ 2:65607ae124b1

pasterd: implement /new
author David Demelier <markand@malikania.fr>
date Tue, 04 Feb 2020 20:47:00 +0100
parents 836a698946f8
children f455893bf0b0
comparison
equal deleted inserted replaced
1:836a698946f8 2:65607ae124b1
59 " , code\n" 59 " , code\n"
60 " , strftime('%s', date) AS date\n" 60 " , strftime('%s', date) AS date\n"
61 " , visible\n" 61 " , visible\n"
62 " , duration\n" 62 " , duration\n"
63 " FROM paste\n" 63 " FROM paste\n"
64 " WHERE visible = 1\n"
64 " ORDER BY date\n" 65 " ORDER BY date\n"
65 " LIMIT ?\n"; 66 " LIMIT ?\n";
66 67
67 static const char *sql_clear = 68 static const char *sql_clear =
68 "BEGIN EXCLUSIVE TRANSACTION;\n" 69 "BEGIN EXCLUSIVE TRANSACTION;\n"