Team mode stays in the repository but is not built or shipped (ADR-0003). - The team server (index.ts, config, db, daemons, plugins, proactive, routes, scheduler, services, ws, drizzle migrations) and its tests move from @waggle/server to packages/team-server (@waggle/team-server, private). It keeps its own copies of the logger and the agent-group executor, so it does not import @waggle/server. @clerk/fastify, bullmq, ioredis, postgres, drizzle-orm, drizzle-kit, cron-parser and @waggle/waggle-dance leave @waggle/server; the launcher drops the same team-only dependencies. - build:packages no longer builds waggle-dance or the worker: nothing in the community edition imports them, and the worker's project reference would otherwise build the team server. The worker now imports from team-server; the team Dockerfile builds both explicitly. - The sidecar no longer starts the team server when DATABASE_URL is set, and loses the team routes (/api/team/*, /api/teams), the WaggleDance routes and bridge (/api/waggle-dance/*), the Team server binding and egress guard, the WebSocket team client, the TeamSync cache and pushes, team audit forwarding, team workspace registration and the team capability-policy lookup in chat. The in-process room signal bus stays: agent groups, fleet runs and external tool runs use it. middleware/audit.ts was dead and is deleted. - @waggle/core loses TeamSync and the teamServer part of WaggleConfig. A teamServer key in config.json is ignored and kept on save, as P0.1 does for the tier keys. Workspaces lose teamServerUrl and teamUserId; teamId and teamRole stay because workspaces from a shared data directory still carry them and the viewer write guards read them. POST /api/workspaces ignores team fields. - The sidecar bundle no longer marks the team packages as external. The agent still references the TeamSync type in orchestrator.ts and pattern-write-back.ts; those files are being rewritten in P1.5 and drop it there. Logs UF-030 and UF-031 (team sync and team policy defects found while removing the code).
94 lines
3.8 KiB
TypeScript
94 lines
3.8 KiB
TypeScript
import { describe, it, expect, beforeAll, afterAll } from 'vitest';
|
|
import { createDb, type Db } from '../../src/db/connection.js';
|
|
import { users, teams, teamMembers, tasks, messages, agents, agentGroups } from '../../src/db/schema.js';
|
|
import { sql } from 'drizzle-orm';
|
|
|
|
const SUFFIX = `_schema_${Date.now()}`;
|
|
|
|
describe('PostgreSQL schema', () => {
|
|
let db: Db;
|
|
let testUserId: string;
|
|
let testTeamId: string;
|
|
|
|
beforeAll(async () => {
|
|
db = createDb(process.env.DATABASE_URL ?? 'postgres://waggle:waggle_dev@localhost:5434/waggle');
|
|
|
|
// Clean up any leftovers from previous runs
|
|
await db.execute(sql`DELETE FROM team_members WHERE team_id IN (SELECT id FROM teams WHERE slug LIKE '%_schema_%')`);
|
|
await db.execute(sql`DELETE FROM team_capability_requests WHERE team_id IN (SELECT id FROM teams WHERE slug LIKE '%_schema_%')`);
|
|
await db.execute(sql`DELETE FROM team_capability_overrides WHERE team_id IN (SELECT id FROM teams WHERE slug LIKE '%_schema_%')`);
|
|
await db.execute(sql`DELETE FROM team_capability_policies WHERE team_id IN (SELECT id FROM teams WHERE slug LIKE '%_schema_%')`);
|
|
await db.execute(sql`DELETE FROM teams WHERE slug LIKE '%_schema_%'`);
|
|
await db.execute(sql`DELETE FROM users WHERE clerk_id LIKE '%_schema_%'`);
|
|
});
|
|
|
|
afterAll(async () => {
|
|
// Clean up test data created by these tests
|
|
if (testTeamId) {
|
|
await db.execute(sql`DELETE FROM team_members WHERE team_id = ${testTeamId}`);
|
|
await db.execute(sql`DELETE FROM team_capability_requests WHERE team_id = ${testTeamId}`);
|
|
await db.execute(sql`DELETE FROM team_capability_overrides WHERE team_id = ${testTeamId}`);
|
|
await db.execute(sql`DELETE FROM team_capability_policies WHERE team_id = ${testTeamId}`);
|
|
await db.execute(sql`DELETE FROM teams WHERE id = ${testTeamId}`);
|
|
}
|
|
if (testUserId) {
|
|
await db.execute(sql`DELETE FROM users WHERE id = ${testUserId}`);
|
|
}
|
|
});
|
|
|
|
it('creates a user', async () => {
|
|
const [user] = await db.insert(users).values({
|
|
clerkId: `clerk${SUFFIX}`,
|
|
displayName: 'Schema Test User',
|
|
email: `schematest${SUFFIX}@test.com`,
|
|
}).returning();
|
|
testUserId = user.id;
|
|
expect(user.id).toBeDefined();
|
|
expect(user.displayName).toBe('Schema Test User');
|
|
});
|
|
|
|
it('creates a team with owner', async () => {
|
|
// Depends on previous test having created user
|
|
expect(testUserId).toBeTruthy();
|
|
|
|
const [team] = await db.insert(teams).values({
|
|
name: 'Marketing',
|
|
slug: `marketing${SUFFIX}`,
|
|
ownerId: testUserId,
|
|
}).returning();
|
|
testTeamId = team.id;
|
|
expect(team.slug).toBe(`marketing${SUFFIX}`);
|
|
|
|
await db.insert(teamMembers).values({
|
|
teamId: team.id,
|
|
userId: testUserId,
|
|
role: 'owner',
|
|
});
|
|
});
|
|
|
|
it('creates all 16 tables', async () => {
|
|
const result = await db.execute(sql`
|
|
SELECT table_name FROM information_schema.tables
|
|
WHERE table_schema = 'public' AND table_type = 'BASE TABLE'
|
|
ORDER BY table_name
|
|
`);
|
|
const tableNames = (result as Array<{ table_name: string }>).map((r) => r.table_name);
|
|
expect(tableNames).toContain('users');
|
|
expect(tableNames).toContain('teams');
|
|
expect(tableNames).toContain('team_members');
|
|
expect(tableNames).toContain('agents');
|
|
expect(tableNames).toContain('agent_groups');
|
|
expect(tableNames).toContain('tasks');
|
|
expect(tableNames).toContain('messages');
|
|
expect(tableNames).toContain('team_entities');
|
|
expect(tableNames).toContain('team_relations');
|
|
expect(tableNames).toContain('team_resources');
|
|
expect(tableNames).toContain('agent_jobs');
|
|
expect(tableNames).toContain('cron_schedules');
|
|
expect(tableNames).toContain('scout_findings');
|
|
expect(tableNames).toContain('proactive_patterns');
|
|
expect(tableNames).toContain('suggestions_log');
|
|
expect(tableNames).toContain('agent_audit_log');
|
|
});
|
|
});
|