Repository Public
1/**2 * =============================================================================3 * SP BOUCHER | SOFTWARE & RESEARCH4 * ARTIFICIAL INTELLIGENCE • FINANCE • ENGINEERING5 * =============================================================================6 *7 * Project : Music SP8 * File : tests/restart.test.ts9 * Module : tests10 * Repository : https://git.spboucher.ai/sp-music11 * Project Website : https://music.spboucher.ai12 * Created : 2026-11-1713 * Last Modified : 2026-11-1714 *15 * Author : Simon-Pierre Boucher16 * Position : Professor of Finance17 * Institution : Université du Québec en Outaouais (UQO)18 * Organization : SP Boucher19 * Website : https://spboucher.ai20 * Git : https://git.spboucher.ai21 *22 * Preferred Contact: support@spboucher.ai23 * Development : dev@spboucher.ai24 * Support : support@spboucher.ai25 * Security/Admin : admin@spboucher.ai26 *27 * Copyright (c) 202628 * Simon-Pierre Boucher29 * All rights reserved where applicable. This file is governed by the30 * applicable project license, copyright notices and relevant law.31 * Existing third-party rights and notices remain unaffected.32 *33 * License : None specified (no license file in this repository)34 *35 * Do not embed credentials, private keys, access tokens,36 * certificates or confidential personal information.37 *38 * =============================================================================39 * END OF SP BOUCHER SOURCE HEADER40 * =============================================================================41 */4243import { afterAll, expect, it } from "vitest";44import { Client, sql } from "./helpers";4546afterAll(async () => { await sql.end(); });4748it("keeps the library, the files and the sessions across a restart", async () => {49 const [s] = await sql`SELECT s.id FROM sessions s JOIN users u ON u.id = s.user_id WHERE u.is_owner AND s.revoked_at IS NULL ORDER BY s.created_at DESC LIMIT 1`;50 expect(s).toBeTruthy();51 const tracks = await sql`SELECT t.id, m.size_bytes FROM tracks t JOIN media_assets m ON m.track_id = t.id AND m.kind = 'original'`;52 expect(tracks.length).toBeGreaterThanOrEqual(5);53 // a fresh listener session proves the passkey store survived too54 const [inv] = await sql`SELECT count(*)::int AS n FROM authenticators`;55 expect(inv.n).toBeGreaterThanOrEqual(2);56 const anon = new Client();57 expect((await anon.req(`/api/v1/stream/${tracks[0].id}`)).status).toBe(401);58 const health = await (await fetch(`${process.env.TEST_BASE_URL}/api/health`)).json();59 expect(health).toMatchObject({ ok: true, db: true, storage: true });60});61