Mercurial > paster
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" |