rocket_auth2/db/tokio_postgres/
sql.rs

1pub(crate) const CREATE_TABLE: &str = "
2CREATE TABLE IF NOT EXISTS users (
3    id SERIAL PRIMARY KEY,
4    email VARCHAR (254) UNIQUE NOT NULL,
5	password VARCHAR ( 255 ) NOT NULL,
6    roles BYTEA NOT NULL
7);
8";
9
10pub(crate) const INSERT_USER: &str = "
11INSERT INTO users (email, password, roles) VALUES ($1, $2, $3);
12";
13
14pub(crate) const UPDATE_USER: &str = "
15UPDATE table SET 
16    email = $2,
17    password = $3,
18    roles = $4,
19WHERE
20    id = $1
21";
22
23pub(crate) const SELECT_BY_ID: &str = "
24SELECT * FROM users WHERE id = $1;
25";
26
27pub(crate) const SELECT_BY_EMAIL: &str = "
28SELECT * FROM users WHERE email = $1;
29";
30
31pub(crate) const REMOVE_BY_ID: &str = "
32DELETE FROM users WHERE id =$1;
33";
34pub(crate) const REMOVE_BY_EMAIL: &str = "
35DELETE FROM users WHERE email =$1;
36";
37pub(crate) const GET_ALL: &str = "
38SELECT id FROM users;
39";