gui.do
Sifa professional network API (Fastify, AT Protocol, Jetstream)
sifa.id/
1import { describe, it, expect } from 'vitest';
2import { profiles, positions, education, skills } from '../../src/db/schema/index.js';
3
4describe('Core schema tables', () => {
5 it('profiles table has expected columns', () => {
6 expect(profiles.did).toBeDefined();
7 expect(profiles.handle).toBeDefined();
8 expect(profiles.headline).toBeDefined();
9 expect(profiles.about).toBeDefined();
10 expect(profiles.indexedAt).toBeDefined();
11 });
12
13 it('positions table references profiles via did', () => {
14 expect(positions.did).toBeDefined();
15 expect(positions.rkey).toBeDefined();
16 expect(positions.companyName).toBeDefined();
17 expect(positions.title).toBeDefined();
18 });
19
20 it('education table references profiles via did', () => {
21 expect(education.did).toBeDefined();
22 expect(education.rkey).toBeDefined();
23 expect(education.institution).toBeDefined();
24 });
25
26 it('skills table references profiles via did', () => {
27 expect(skills.did).toBeDefined();
28 expect(skills.rkey).toBeDefined();
29 expect(skills.skillName).toBeDefined();
30 });
31});