fercord_storage 0.3.4

Storage crate for Fercord
Documentation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

pub(super) const REMINDERS_BETWEEN_QUERY: &str = r#"SELECT *
FROM reminders
WHERE unixepoch("when") >= unixepoch(?) and unixepoch("when") < unixepoch(?)
"#;

pub(super) const INSERT_QUERY: &str = r#"INSERT INTO reminders
(who, 'when', what, server, channel)
VALUES(?, ?, ?, ?, ?) RETURNING id;"#;

pub(super) const DELETE_QUERY: &str = "DELETE FROM reminders WHERE id = ?;";

pub(super) const GET_ONE_QUERY: &str = "SELECT * FROM reminders WHERE id = ?";

pub(super) const BATCH_DELETE_QUERY: &str = "DELETE FROM reminders WHERE id IN (?)";