server/src/sql/user_sessions.sql at master · keii.dev/kirakira

keii.dev / kirakira

A lobste.rs like forum made in Gleam

kirakira / server / src / sql / user_sessions.sql

at master 243 B view raw

 1-- name: CreateUserSession :exec
 2INSERT INTO
 3    user_session (user_id, token)
 4VALUES
 5    (?, ?);
 6
 7-- name: GetUserIdFromSession :one
 8SELECT
 9    user_session.id,
10    user_session.user_id
11FROM
12    user_session
13WHERE
14    user_session.token = ?;