queries_generated.h

Go to the documentation of this file.

/* Generated by mmmbed; do not edit. */
/* clang-format off */
#pragma once
#include <stddef.h>
 
enum database_access { DATABASE_READ, DATABASE_WRITE };
enum database_rows { DATABASE_ZERO, DATABASE_ZERO_OR_ONE, DATABASE_ONE, DATABASE_MANY };
typedef enum database_query_id {
  DATABASE_QUERY_AddSessionKey,
  DATABASE_QUERY_BackfillSessionIdentityKeys,
  DATABASE_QUERY_BackfillSessionKeyPolicy,
  DATABASE_QUERY_BeginHostTransportRefresh,
  DATABASE_QUERY_BeginKeySet,
  DATABASE_QUERY_BeginTransaction,
  DATABASE_QUERY_ClearHost,
  DATABASE_QUERY_CommitHostTransportRefresh,
  DATABASE_QUERY_CommitKeySet,
  DATABASE_QUERY_CommitTransaction,
  DATABASE_QUERY_CountRateEvents,
  DATABASE_QUERY_CountSessions,
  DATABASE_QUERY_CountUniqueClients,
  DATABASE_QUERY_CreateSession,
  DATABASE_QUERY_DecrementParticipants,
  DATABASE_QUERY_DeleteExpiredSessions,
  DATABASE_QUERY_DeleteParticipant,
  DATABASE_QUERY_DeleteRateEvents,
  DATABASE_QUERY_DeleteSession,
  DATABASE_QUERY_EnableForeignKeys,
  DATABASE_QUERY_EnableWAL,
  DATABASE_QUERY_FindExpiredSessions,
  DATABASE_QUERY_GetMigrationState,
  DATABASE_QUERY_GetParticipantCount,
  DATABASE_QUERY_GetSessionById,
  DATABASE_QUERY_GetSessionByString,
  DATABASE_QUERY_GetSessionKeyPolicy,
  DATABASE_QUERY_GetSessionKeys,
  DATABASE_QUERY_GetSessionParticipants,
  DATABASE_QUERY_GetSessionTransports,
  DATABASE_QUERY_GetStatsSnapshot,
  DATABASE_QUERY_HasLegacySessionKeys,
  DATABASE_QUERY_ImportLegacySessionKeys,
  DATABASE_QUERY_IncrementParticipants,
  DATABASE_QUERY_InsertParticipant,
  DATABASE_QUERY_InsertRateEvent,
  DATABASE_QUERY_InsertSessionKeyPolicy,
  DATABASE_QUERY_LookupSession,
  DATABASE_QUERY_LookupSessionString,
  DATABASE_QUERY_RevokeSessionKey,
  DATABASE_QUERY_RollbackHostTransportRefresh,
  DATABASE_QUERY_RollbackToKeySet,
  DATABASE_QUERY_RollbackTransaction,
  DATABASE_QUERY_SchemaClearTransportsTrigger,
  DATABASE_QUERY_SchemaIdentityKeys,
  DATABASE_QUERY_SchemaIdxParticipantsSession,
  DATABASE_QUERY_SchemaIdxRateEvents,
  DATABASE_QUERY_SchemaIdxSessionsActivity,
  DATABASE_QUERY_SchemaIdxSessionsId,
  DATABASE_QUERY_SchemaKeyPolicy,
  DATABASE_QUERY_SchemaParticipants,
  DATABASE_QUERY_SchemaRateEvents,
  DATABASE_QUERY_SchemaSessionTransportHosts,
  DATABASE_QUERY_SchemaSessionTransports,
  DATABASE_QUERY_SchemaSessions,
  DATABASE_QUERY_SetSessionInitiator,
  DATABASE_QUERY_SetSessionTransportHost,
  DATABASE_QUERY_SetSessionTransports,
  DATABASE_QUERY_StartMigration,
  DATABASE_QUERY_UpdateHost,
  DATABASE_QUERY_VerifySessionKey,
  DATABASE_QUERY_COUNT
} database_query_id_t;

struct database_query { const char *name; const char *sql; enum database_access access; enum database_rows rows; };
static const struct database_query database_queries[] = {
  {"AddSessionKey", "INSERT OR IGNORE INTO session_identity_keys (\n"
    "  session_string,\n"
    "  key_type,\n"
    "  identity_pubkey,\n"
    "  key_version,\n"
    "  added_at\n"
    ")\n"
    "VALUES\n"
    "  (\n"
    "    :session_string,\n"
    "    'ed25519',\n"
    "    :identity_pubkey,\n"
    "    :key_version,\n"
    "    :added_at\n"
    "  )", DATABASE_WRITE, DATABASE_ZERO},
  {"BackfillSessionIdentityKeys", "INSERT OR IGNORE INTO session_identity_keys\n"
    "SELECT\n"
    "  s.session_string,\n"
    "  'ed25519',\n"
    "  s.host_pubkey,\n"
    "  0,\n"
    "  s.created_at,\n"
    "  0\n"
    "FROM sessions s\n"
    "WHERE\n"
    "  typeof(s.host_pubkey) = 'blob'\n"
    "  AND length(s.host_pubkey) = 32\n"
    "  AND s.host_pubkey != zeroblob(32)\n"
    "  AND NOT EXISTS (\n"
    "    SELECT\n"
    "      1\n"
    "    FROM session_key_policy p\n"
    "    WHERE\n"
    "      p.session_string = s.session_string\n"
    "  );", DATABASE_WRITE, DATABASE_ZERO},
  {"BackfillSessionKeyPolicy", "INSERT OR IGNORE INTO session_key_policy\n"
    "SELECT\n"
    "  session_string,\n"
    "  0\n"
    "FROM sessions;", DATABASE_WRITE, DATABASE_ZERO},
  {"BeginHostTransportRefresh", "SAVEPOINT host_transport_refresh;", DATABASE_WRITE, DATABASE_ZERO},
  {"BeginKeySet", "SAVEPOINT create_key_set", DATABASE_WRITE, DATABASE_ZERO},
  {"BeginTransaction", "BEGIN IMMEDIATE;", DATABASE_WRITE, DATABASE_ZERO},
  {"ClearHost", "UPDATE sessions\n"
    "SET\n"
    "  host_established = 0,\n"
    "  host_participant_id = NULL,\n"
    "  host_address = NULL,\n"
    "  host_port = 0,\n"
    "  host_connection_type = 0\n"
    "WHERE\n"
    "  session_id = :session_id", DATABASE_WRITE, DATABASE_ZERO},
  {"CommitHostTransportRefresh", "RELEASE host_transport_refresh;", DATABASE_WRITE, DATABASE_ZERO},
  {"CommitKeySet", "RELEASE create_key_set", DATABASE_WRITE, DATABASE_ZERO},
  {"CommitTransaction", "COMMIT;", DATABASE_WRITE, DATABASE_ZERO},
  {"CountRateEvents", "SELECT\n"
    "  COUNT(*)\n"
    "FROM rate_events\n"
    "WHERE\n"
    "  ip_address = :ip_address\n"
    "  AND event_type = :event_type\n"
    "  AND timestamp >= :window_start", DATABASE_READ, DATABASE_ONE},
  {"CountSessions", "SELECT\n"
    "  COUNT(*)\n"
    "FROM sessions\n"
    "WHERE\n"
    "  expires_at > :now", DATABASE_READ, DATABASE_ONE},
  {"CountUniqueClients", "SELECT\n"
    "  COUNT(DISTINCT participant_id)\n"
    "FROM participants", DATABASE_READ, DATABASE_ONE},
  {"CreateSession", "INSERT INTO sessions (\n"
    "  session_string,\n"
    "  session_id,\n"
    "  host_pubkey,\n"
    "  password_hash,\n"
    "  max_participants,\n"
    "  current_participants,\n"
    "  capabilities,\n"
    "  has_password,\n"
    "  expose_ip_publicly,\n"
    "  session_type,\n"
    "  server_address,\n"
    "  server_port,\n"
    "  created_at,\n"
    "  expires_at,\n"
    "  last_activity_at\n"
    ")\n"
    "VALUES\n"
    "  (\n"
    "    :session_string,\n"
    "    :session_id,\n"
    "    :host_pubkey,\n"
    "    :password_hash,\n"
    "    :max_participants,\n"
    "    0,\n"
    "    :capabilities,\n"
    "    :has_password,\n"
    "    :expose_ip_publicly,\n"
    "    :session_type,\n"
    "    :server_address,\n"
    "    :server_port,\n"
    "    :created_at,\n"
    "    :expires_at,\n"
    "    :last_activity_at\n"
    "  )", DATABASE_WRITE, DATABASE_ZERO},
  {"DecrementParticipants", "UPDATE sessions\n"
    "SET\n"
    "  current_participants = current_participants - 1,\n"
    "  last_activity_at = :last_activity_at\n"
    "WHERE\n"
    "  session_string = :session_string\n"
    "  AND current_participants > 0", DATABASE_WRITE, DATABASE_ZERO},
  {"DeleteExpiredSessions", "DELETE FROM sessions\n"
    "WHERE\n"
    "  last_activity_at < :cutoff_time", DATABASE_WRITE, DATABASE_ZERO},
  {"DeleteParticipant", "DELETE FROM participants\n"
    "WHERE\n"
    "  participant_id = :participant_id\n"
    "  AND session_string = :session_string", DATABASE_WRITE, DATABASE_ZERO},
  {"DeleteRateEvents", "DELETE FROM rate_events\n"
    "WHERE\n"
    "  timestamp < :cutoff_time", DATABASE_WRITE, DATABASE_ZERO},
  {"DeleteSession", "DELETE FROM sessions\n"
    "WHERE\n"
    "  session_string = :session_string", DATABASE_WRITE, DATABASE_ZERO},
  {"EnableForeignKeys", "PRAGMA foreign_keys = ON;", DATABASE_WRITE, DATABASE_ZERO},
  {"EnableWAL", "PRAGMA journal_mode = WAL;", DATABASE_WRITE, DATABASE_ONE},
  {"FindExpiredSessions", "SELECT\n"
    "  session_string,\n"
    "  last_activity_at\n"
    "FROM sessions\n"
    "WHERE\n"
    "  last_activity_at < :cutoff_time", DATABASE_READ, DATABASE_MANY},
  {"GetMigrationState", "SELECT\n"
    "  in_migration,\n"
    "  migration_start_ns\n"
    "FROM sessions\n"
    "WHERE\n"
    "  session_id = :session_id", DATABASE_READ, DATABASE_ZERO_OR_ONE},
  {"GetParticipantCount", "SELECT\n"
    "  current_participants\n"
    "FROM sessions\n"
    "WHERE\n"
    "  session_string = :session_string", DATABASE_READ, DATABASE_ZERO_OR_ONE},
  {"GetSessionById", "SELECT\n"
    "  session_string,\n"
    "  session_id,\n"
    "  host_pubkey,\n"
    "  password_hash,\n"
    "  max_participants,\n"
    "  current_participants,\n"
    "  capabilities,\n"
    "  has_password,\n"
    "  expose_ip_publicly,\n"
    "  session_type,\n"
    "  server_address,\n"
    "  server_port,\n"
    "  created_at,\n"
    "  expires_at,\n"
    "  last_activity_at,\n"
    "  initiator_id,\n"
    "  host_established,\n"
    "  host_participant_id,\n"
    "  host_address,\n"
    "  host_port,\n"
    "  host_connection_type,\n"
    "  in_migration,\n"
    "  migration_start_ns\n"
    "FROM sessions\n"
    "WHERE\n"
    "  session_id = :session_id", DATABASE_READ, DATABASE_ZERO_OR_ONE},
  {"GetSessionByString", "SELECT\n"
    "  session_string,\n"
    "  session_id,\n"
    "  host_pubkey,\n"
    "  password_hash,\n"
    "  max_participants,\n"
    "  current_participants,\n"
    "  capabilities,\n"
    "  has_password,\n"
    "  expose_ip_publicly,\n"
    "  session_type,\n"
    "  server_address,\n"
    "  server_port,\n"
    "  created_at,\n"
    "  expires_at,\n"
    "  last_activity_at,\n"
    "  initiator_id,\n"
    "  host_established,\n"
    "  host_participant_id,\n"
    "  host_address,\n"
    "  host_port,\n"
    "  host_connection_type,\n"
    "  in_migration,\n"
    "  migration_start_ns\n"
    "FROM sessions\n"
    "WHERE\n"
    "  session_string = :session_string", DATABASE_READ, DATABASE_ZERO_OR_ONE},
  {"GetSessionKeyPolicy", "SELECT\n"
    "  restricted\n"
    "FROM session_key_policy\n"
    "WHERE\n"
    "  session_string = :session_string", DATABASE_READ, DATABASE_ZERO_OR_ONE},
  {"GetSessionKeys", "SELECT\n"
    "  identity_pubkey\n"
    "FROM session_identity_keys\n"
    "WHERE\n"
    "  session_string = :session_string\n"
    "  AND key_type = 'ed25519'\n"
    "  AND revoked = 0\n"
    "ORDER BY\n"
    "  key_version ASC,\n"
    "  identity_pubkey ASC", DATABASE_READ, DATABASE_MANY},
  {"GetSessionParticipants", "SELECT\n"
    "  participant_id,\n"
    "  identity_pubkey,\n"
    "  joined_at\n"
    "FROM participants\n"
    "WHERE\n"
    "  session_string = :session_string", DATABASE_READ, DATABASE_MANY},
  {"GetSessionTransports", "SELECT\n"
    "  t.metadata\n"
    "FROM session_transports t\n"
    "JOIN sessions s\n"
    "  ON s.session_id = t.session_id\n"
    "LEFT JOIN session_transport_hosts h\n"
    "  ON h.session_id = t.session_id\n"
    "WHERE\n"
    "  t.session_id = :session_id\n"
    "  AND s.in_migration = 0\n"
    "  AND COALESCE(s.host_participant_id, s.initiator_id) IS COALESCE(h.host_id, s.initiator_id);", DATABASE_READ, DATABASE_ZERO_OR_ONE},
  {"GetStatsSnapshot", "SELECT\n"
    "  session_string,\n"
    "  current_participants,\n"
    "  host_established,\n"
    "  in_migration\n"
    "FROM sessions\n"
    "WHERE\n"
    "  expires_at > :now\n"
    "ORDER BY\n"
    "  session_string", DATABASE_READ, DATABASE_MANY},
  {"HasLegacySessionKeys", "SELECT\n"
    "  1\n"
    "FROM sqlite_master\n"
    "WHERE\n"
    "  type = 'table'\n"
    "  AND name = 'session_keys'", DATABASE_READ, DATABASE_ZERO_OR_ONE},
  {"ImportLegacySessionKeys", "INSERT OR IGNORE INTO session_identity_keys\n"
    "SELECT\n"
    "  k.session_string,\n"
    "  'ed25519',\n"
    "  k.identity_pubkey,\n"
    "  k.key_version,\n"
    "  k.added_at,\n"
    "  CASE\n"
    "    WHEN k.revoked = 0 THEN 0\n"
    "    ELSE 1\n"
    "  END\n"
    "FROM session_keys k\n"
    "WHERE\n"
    "  typeof(k.identity_pubkey) = 'blob'\n"
    "  AND length(k.identity_pubkey) = 32\n"
    "  AND EXISTS (\n"
    "    SELECT\n"
    "      1\n"
    "    FROM sessions s\n"
    "    WHERE\n"
    "      s.session_string = k.session_string\n"
    "  )\n"
    "  AND NOT EXISTS (\n"
    "    SELECT\n"
    "      1\n"
    "    FROM session_key_policy p\n"
    "    WHERE\n"
    "      p.session_string = k.session_string\n"
    "  );", DATABASE_WRITE, DATABASE_ZERO},
  {"IncrementParticipants", "UPDATE sessions\n"
    "SET\n"
    "  current_participants = current_participants + 1,\n"
    "  last_activity_at = :last_activity_at\n"
    "WHERE\n"
    "  session_string = :session_string", DATABASE_WRITE, DATABASE_ZERO},
  {"InsertParticipant", "INSERT INTO participants (participant_id, session_string, identity_pubkey, joined_at)\n"
    "VALUES\n"
    "  (:participant_id, :session_string, :identity_pubkey, :joined_at)", DATABASE_WRITE, DATABASE_ZERO},
  {"InsertRateEvent", "INSERT INTO rate_events (ip_address, event_type, timestamp)\n"
    "VALUES\n"
    "  (:ip_address, :event_type, :timestamp)", DATABASE_WRITE, DATABASE_ZERO},
  {"InsertSessionKeyPolicy", "INSERT INTO session_key_policy\n"
    "VALUES\n"
    "  (:session_string, :restricted)", DATABASE_WRITE, DATABASE_ZERO},
  {"LookupSession", "SELECT\n"
    "  session_string,\n"
    "  session_id,\n"
    "  host_pubkey,\n"
    "  password_hash,\n"
    "  max_participants,\n"
    "  current_participants,\n"
    "  capabilities,\n"
    "  has_password,\n"
    "  expose_ip_publicly,\n"
    "  session_type,\n"
    "  server_address,\n"
    "  server_port,\n"
    "  created_at,\n"
    "  expires_at,\n"
    "  last_activity_at\n"
    "FROM sessions\n"
    "WHERE\n"
    "  session_string = :session_string", DATABASE_READ, DATABASE_ZERO_OR_ONE},
  {"LookupSessionString", "SELECT\n"
    "  session_string\n"
    "FROM sessions\n"
    "WHERE\n"
    "  session_id = :session_id", DATABASE_READ, DATABASE_ZERO_OR_ONE},
  {"RevokeSessionKey", "UPDATE session_identity_keys\n"
    "SET\n"
    "  revoked = 1\n"
    "WHERE\n"
    "  session_string = :session_string\n"
    "  AND key_type = 'ed25519'\n"
    "  AND identity_pubkey = :identity_pubkey", DATABASE_WRITE, DATABASE_ZERO},
  {"RollbackHostTransportRefresh", "ROLLBACK TO host_transport_refresh;", DATABASE_WRITE, DATABASE_ZERO},
  {"RollbackToKeySet", "ROLLBACK TO create_key_set;", DATABASE_WRITE, DATABASE_ZERO},
  {"RollbackTransaction", "ROLLBACK;", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaClearTransportsTrigger", "CREATE TRIGGER IF NOT EXISTS clear_session_transports_after_host_clear AFTER UPDATE OF host_established ON sessions WHEN OLD.host_established = 1 AND NEW.host_established = 0 BEGIN DELETE\n"
    "FROM session_transports\n"
    "WHERE\n"
    "  session_id = NEW.session_id;\n"
    "END;", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaIdentityKeys", "CREATE TABLE IF NOT EXISTS session_identity_keys (\n"
    "  session_string TEXT NOT NULL REFERENCES sessions(session_string) ON DELETE CASCADE, key_type TEXT NOT NULL CHECK(key_type = 'ed25519'), identity_pubkey BLOB NOT NULL CHECK(\n"
    "    typeof(identity_pubkey) = 'blob' AND length(identity_pubkey) = 32\n"
    "  ), key_version INTEGER NOT NULL, added_at INTEGER NOT NULL, revoked INTEGER NOT NULL DEFAULT 0 CHECK(revoked IN (0, 1)), PRIMARY KEY(session_string, key_type, identity_pubkey)\n"
    ");", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaIdxParticipantsSession", "CREATE INDEX IF NOT EXISTS idx_participants_session ON participants(session_string);", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaIdxRateEvents", "CREATE INDEX IF NOT EXISTS idx_rate_events ON rate_events(ip_address, event_type, timestamp);", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaIdxSessionsActivity", "CREATE INDEX IF NOT EXISTS idx_sessions_activity ON sessions(last_activity_at);", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaIdxSessionsId", "CREATE INDEX IF NOT EXISTS idx_sessions_id ON sessions(session_id);", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaKeyPolicy", "CREATE TABLE IF NOT EXISTS session_key_policy (\n"
    "  session_string TEXT PRIMARY KEY REFERENCES sessions(session_string) ON DELETE CASCADE, restricted INTEGER NOT NULL CHECK(restricted IN (0, 1))\n"
    ");", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaParticipants", "CREATE TABLE IF NOT EXISTS participants (\n"
    "  participant_id BLOB PRIMARY KEY,\n"
    "  session_string TEXT NOT NULL,\n"
    "  identity_pubkey BLOB NOT NULL,\n"
    "  joined_at INTEGER NOT NULL,\n"
    "  FOREIGN KEY (session_string) REFERENCES sessions(session_string) ON DELETE CASCADE\n"
    ");", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaRateEvents", "CREATE TABLE IF NOT EXISTS rate_events (\n"
    "  id INTEGER PRIMARY KEY AUTOINCREMENT,\n"
    "  ip_address TEXT NOT NULL,\n"
    "  event_type TEXT NOT NULL,\n"
    "  timestamp INTEGER NOT NULL\n"
    ");", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaSessionTransportHosts", "CREATE TABLE IF NOT EXISTS session_transport_hosts (\n"
    "  session_id BLOB PRIMARY KEY REFERENCES session_transports(session_id) ON DELETE CASCADE, host_id BLOB NOT NULL CHECK(length(host_id) = 16)\n"
    ");", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaSessionTransports", "CREATE TABLE IF NOT EXISTS session_transports (\n"
    "  session_id BLOB PRIMARY KEY REFERENCES sessions(session_id) ON DELETE CASCADE, metadata BLOB NOT NULL\n"
    ");", DATABASE_WRITE, DATABASE_ZERO},
  {"SchemaSessions", "CREATE TABLE IF NOT EXISTS sessions (\n"
    "  session_string TEXT PRIMARY KEY,\n"
    "  session_id BLOB UNIQUE NOT NULL,\n"
    "  host_pubkey BLOB NOT NULL,\n"
    "  password_hash TEXT,\n"
    "  max_participants INTEGER DEFAULT 4,\n"
    "  current_participants INTEGER DEFAULT 0,\n"
    "  capabilities INTEGER DEFAULT 3,\n"
    "  has_password INTEGER DEFAULT 0,\n"
    "  expose_ip_publicly INTEGER DEFAULT 0,\n"
    "  session_type INTEGER DEFAULT 0,\n"
    "  server_address TEXT,\n"
    "  server_port INTEGER DEFAULT 0,\n"
    "  created_at INTEGER NOT NULL,\n"
    "  expires_at INTEGER NOT NULL,\n"
    "  last_activity_at INTEGER NOT NULL,\n"
    "  initiator_id BLOB,\n"
    "  host_established INTEGER DEFAULT 0,\n"
    "  host_participant_id BLOB,\n"
    "  host_address TEXT,\n"
    "  host_port INTEGER DEFAULT 0,\n"
    "  host_connection_type INTEGER DEFAULT 0,\n"
    "  in_migration INTEGER DEFAULT 0,\n"
    "  migration_start_ns INTEGER DEFAULT 0\n"
    ");", DATABASE_WRITE, DATABASE_ZERO},
  {"SetSessionInitiator", "UPDATE sessions\n"
    "SET\n"
    "  initiator_id = :initiator_id\n"
    "WHERE\n"
    "  session_string = :session_string", DATABASE_WRITE, DATABASE_ZERO},
  {"SetSessionTransportHost", "INSERT OR REPLACE INTO session_transport_hosts(session_id, host_id)\n"
    "VALUES\n"
    "  (:session_id, :host_id);", DATABASE_WRITE, DATABASE_ZERO},
  {"SetSessionTransports", "INSERT OR REPLACE INTO session_transports(session_id, metadata)\n"
    "VALUES\n"
    "  (:session_id, :metadata);", DATABASE_WRITE, DATABASE_ZERO},
  {"StartMigration", "UPDATE sessions\n"
    "SET\n"
    "  in_migration = 1,\n"
    "  migration_start_ns = :migration_start_ns\n"
    "WHERE\n"
    "  session_id = :session_id", DATABASE_WRITE, DATABASE_ZERO},
  {"UpdateHost", "UPDATE sessions\n"
    "SET\n"
    "  host_established = 1,\n"
    "  in_migration = 0,\n"
    "  migration_start_ns = 0,\n"
    "  host_participant_id = :host_participant_id,\n"
    "  host_address = :host_address,\n"
    "  host_port = :host_port,\n"
    "  host_connection_type = :host_connection_type,\n"
    "  last_activity_at = :last_activity_at\n"
    "WHERE\n"
    "  session_id = :session_id", DATABASE_WRITE, DATABASE_ZERO},
  {"VerifySessionKey", "SELECT\n"
    "  1\n"
    "FROM session_identity_keys\n"
    "WHERE\n"
    "  session_string = :session_string\n"
    "  AND key_type = 'ed25519'\n"
    "  AND identity_pubkey = :identity_pubkey\n"
    "  AND revoked = 0", DATABASE_READ, DATABASE_ZERO_OR_ONE},
};
/* clang-format on */