github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/queries/sessions.sql (about)

     1  -- name: SessionCreate :exec
     2  INSERT INTO "sessions" (
     3      "name",
     4      "email",
     5      "token",
     6      "access_token",
     7      "expires",
     8      "is_admin"
     9  ) VALUES (
    10      @name,
    11      @email,
    12      @token,
    13      @access_token,
    14      @expires,
    15      @is_admin
    16  );
    17  
    18  -- name: SessionGet :one
    19  SELECT *
    20  FROM "sessions"
    21  WHERE token = @token
    22  AND expires > now();
    23  
    24  -- name: SessionDelete :exec
    25  UPDATE "sessions"
    26  SET "expires" = NOW()
    27  WHERE token = @token;