FilesExpand file tree

 opencode

/

sessions.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

48 lines (43 loc) · 727 Bytes

 opencode

/

sessions.sql

Copy path

Top

File metadata and controls

• Code
• Blame

48 lines (43 loc) · 727 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

-- name: CreateSession :one

INSERT INTO sessions (

id,

parent_session_id,

title,

message_count,

prompt_tokens,

completion_tokens,

cost,

updated_at,

created_at

) VALUES (

?,

?,

?,

?,

?,

?,

?,

strftime('%s', 'now'),

strftime('%s', 'now')

) RETURNING *;

-- name: GetSessionByID :one

SELECT *

FROM sessions

WHERE id = ? LIMIT 1;

-- name: ListSessions :many

SELECT *

FROM sessions

WHERE parent_session_id is NULL

ORDER BY created_at DESC;

-- name: UpdateSession :one

UPDATE sessions

SET

title = ?,

prompt_tokens = ?,

completion_tokens = ?,

cost = ?

WHERE id = ?

RETURNING *;

-- name: DeleteSession :exec

DELETE FROM sessions

WHERE id = ?;