1- import { expect , test } from "bun:test"
1+ import { Database } from "bun:sqlite"
2+ import { afterEach , expect , setSystemTime , test } from "bun:test"
3+ import { readdirSync , readFileSync } from "node:fs"
4+ import path from "node:path"
25import worker from "../src/index"
36
7+ type Env = Parameters < typeof worker . fetch > [ 1 ]
8+
9+ const migrations = path . join ( import . meta. dir , "../migrations" )
10+
11+ afterEach ( ( ) => setSystemTime ( ) )
12+
13+ // Runs the real schema and queries through bun:sqlite and records every statement sent to D1.
14+ function database ( ) {
15+ const sqlite = new Database ( ":memory:" )
16+ readdirSync ( migrations )
17+ . sort ( )
18+ . forEach ( ( file ) => sqlite . exec ( readFileSync ( path . join ( migrations , file ) , "utf8" ) ) )
19+ const queries : string [ ] = [ ]
20+ const DB = {
21+ prepare : ( sql : string ) => ( {
22+ bind : ( ...values : unknown [ ] ) => ( {
23+ first : async ( ) => {
24+ queries . push ( sql )
25+ return sqlite . query ( sql ) . get ( ...( values as never [ ] ) ) ?? null
26+ } ,
27+ all : async ( ) => {
28+ queries . push ( sql )
29+ return { results : sqlite . query ( sql ) . all ( ...( values as never [ ] ) ) }
30+ } ,
31+ } ) ,
32+ } ) ,
33+ }
34+ const env = { DB , EVENTS : { send : ( ) => Promise . resolve ( ) } } as unknown as Env
35+ const insert = ( input : { channel : string ; version : string ; time : number ; active ?: boolean ; minimum ?: boolean } ) =>
36+ sqlite
37+ . query (
38+ "INSERT INTO artifact (channel, name, distribution, version, metadata, active, minimum, time_created, time_updated) VALUES (?, 'cli', 'opencode', ?, '{}', ?, ?, ?, ?)" ,
39+ )
40+ . run ( input . channel , input . version , input . active ? 1 : 0 , input . minimum ? 1 : 0 , input . time , input . time )
41+ return { sqlite, env, queries, insert }
42+ }
43+
44+ function lookup ( env : Env , pathname : string , headers ?: HeadersInit ) {
45+ return worker . fetch ( new Request ( `https://opencode.ai/update/api/${ pathname } ` , { headers } ) , env , {
46+ waitUntil : ( ) => { } ,
47+ } )
48+ }
49+
50+ async function version ( response : Response ) {
51+ expect ( response . status ) . toBe ( 200 )
52+ const body = ( await response . json ( ) ) as { version : string }
53+ return body . version
54+ }
55+
456test ( "returns a retryable 503 when D1 rejects a lookup" , async ( ) => {
557 const overloaded = new Error ( "D1_ERROR: D1 DB is overloaded. Requests queued for too long." )
658 const env = {
759 DB : { prepare : ( ) => ( { bind : ( ) => ( { first : ( ) => Promise . reject ( overloaded ) } ) } ) } ,
860 EVENTS : { send : ( ) => Promise . resolve ( ) } ,
9- } as unknown as Parameters < typeof worker . fetch > [ 1 ]
61+ } as unknown as Env
1062 const response = await worker . fetch (
1163 new Request ( "https://opencode.ai/update/api/latest/desktop/opencode/opencode-desktop-win-x64.exe" ) ,
1264 env ,
@@ -17,3 +69,74 @@ test("returns a retryable 503 when D1 rejects a lookup", async () => {
1769 expect ( response . headers . get ( "Cache-Control" ) ) . toBe ( "no-store" )
1870 expect ( await response . json ( ) ) . toEqual ( { error : "Update service temporarily unavailable" } )
1971} )
72+
73+ test ( "reuses D1 reads across lookups for 1 minute" , async ( ) => {
74+ const db = database ( )
75+ db . insert ( { channel : "reuse" , version : "1.0.0" , time : 1 , active : true } )
76+ setSystemTime ( new Date ( "2026-10-13T00:00:00Z" ) )
77+
78+ expect (
79+ await Promise . all ( [ lookup ( db . env , "reuse/cli/opencode" ) , lookup ( db . env , "reuse/cli/opencode" ) ] ) . then ( ( responses ) =>
80+ Promise . all ( responses . map ( version ) ) ,
81+ ) ,
82+ ) . toEqual ( [ "1.0.0" , "1.0.0" ] )
83+ expect ( db . queries ) . toHaveLength ( 2 )
84+
85+ db . sqlite . query ( "UPDATE artifact SET active = 0" ) . run ( )
86+ db . insert ( { channel : "reuse" , version : "1.0.1" , time : 2 , active : true } )
87+ setSystemTime ( new Date ( "2026-10-13T00:00:59Z" ) )
88+ expect ( await version ( await lookup ( db . env , "reuse/cli/opencode" ) ) ) . toBe ( "1.0.0" )
89+ expect ( db . queries ) . toHaveLength ( 2 )
90+
91+ setSystemTime ( new Date ( "2026-10-13T00:01:01Z" ) )
92+ expect ( await version ( await lookup ( db . env , "reuse/cli/opencode" ) ) ) . toBe ( "1.0.1" )
93+ expect ( db . queries ) . toHaveLength ( 4 )
94+ } )
95+
96+ test ( "evicts stale and cold entries without clearing hot reads" , async ( ) => {
97+ const db = database ( )
98+ db . insert ( { channel : "hot" , version : "1.0.0" , time : 1 , active : true } )
99+ setSystemTime ( new Date ( "2026-10-13T01:00:00Z" ) )
100+
101+ expect ( await version ( await lookup ( db . env , "hot/cli/opencode" ) ) ) . toBe ( "1.0.0" )
102+ expect ( db . queries ) . toHaveLength ( 2 )
103+
104+ for ( let i = 0 ; i < 600 ; i ++ ) {
105+ expect ( ( await lookup ( db . env , `cold-${ i } /cli/opencode` ) ) . status ) . toBe ( 404 )
106+ expect ( await version ( await lookup ( db . env , "hot/cli/opencode" ) ) ) . toBe ( "1.0.0" )
107+ }
108+ expect ( db . queries ) . toHaveLength ( 1202 )
109+ } )
110+
111+ test ( "retries D1 on the next lookup after a failed read" , async ( ) => {
112+ const db = database ( )
113+ db . insert ( { channel : "retry" , version : "1.0.0" , time : 1 , active : true } )
114+ const prepare = db . env . DB . prepare
115+ let fail = true
116+ db . env . DB . prepare = ( ( sql : string ) =>
117+ fail
118+ ? { bind : ( ) => ( { first : ( ) => Promise . reject ( new Error ( "overloaded" ) ) } ) }
119+ : prepare . call ( db . env . DB , sql ) ) as typeof prepare
120+
121+ expect ( ( await lookup ( db . env , "retry/cli/opencode" ) ) . status ) . toBe ( 503 )
122+ fail = false
123+ expect ( await version ( await lookup ( db . env , "retry/cli/opencode" ) ) ) . toBe ( "1.0.0" )
124+ } )
125+
126+ test ( "selects the minimum and active artifacts from the partial indexes" , async ( ) => {
127+ const db = database ( )
128+ db . insert ( { channel : "minimum" , version : "1.0.0" , time : 1 , minimum : true } )
129+ db . insert ( { channel : "minimum" , version : "1.5.0" , time : 2 } )
130+ db . insert ( { channel : "minimum" , version : "2.0.0" , time : 3 , active : true } )
131+
132+ expect ( await version ( await lookup ( db . env , "minimum/cli/opencode?current=0.9.0" ) ) ) . toBe ( "1.0.0" )
133+ expect ( await version ( await lookup ( db . env , "minimum/cli/opencode?current=1.0.0" ) ) ) . toBe ( "2.0.0" )
134+ expect ( await version ( await lookup ( db . env , "minimum/cli/opencode" ) ) ) . toBe ( "2.0.0" )
135+
136+ // A release that is both active and minimum is listed once.
137+ db . insert ( { channel : "both" , version : "3.0.0" , time : 1 , active : true , minimum : true } )
138+ const response = await lookup ( db . env , "both" )
139+ expect ( response . status ) . toBe ( 200 )
140+ const body = ( await response . json ( ) ) as { artifacts : { version : string } [ ] }
141+ expect ( body . artifacts . map ( ( artifact ) => artifact . version ) ) . toEqual ( [ "3.0.0" ] )
142+ } )
0 commit comments