mirror of
https://github.com/proffesor-for-testing/agentic-qe.git
synced 2026-09-19 08:45:47 +08:00
Profa
3f88c8019a
- Merge unique data from v3/.agentic-qe/memory.db to root database - Update all code references from qe-patterns.db to memory.db - Update cloud-db-config.json to use single primaryDb - Fix statusline to dynamically detect database source - Update sync interfaces to point all sources to root db - Remove obsolete migrate-root-to-v3.sql script - Add merge-v3-to-root.sql for data consolidation - Fix duplicate catch blocks in unified-memory.ts Consolidated tables: - sona_patterns: 6→16 records - goap_actions: 61→113 records - kv_store: 4433→4446 records Deprecated databases documented but no longer used: - ruvector-cache.db (cache now in memory.db) - aqe-telemetry.db (telemetry in events table) - qe-patterns.db (patterns in memory.db) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
49 lines
2.1 KiB
SQL
49 lines
2.1 KiB
SQL
-- Merge V3 unique data to Root database
|
|
-- Run with: sqlite3 .agentic-qe/memory.db < scripts/merge-v3-to-root.sql
|
|
|
|
-- Attach V3 database
|
|
ATTACH DATABASE 'v3/.agentic-qe/memory.db' AS v3db;
|
|
|
|
-- ============================================================================
|
|
-- Merge SONA Patterns (schema compatible)
|
|
-- ============================================================================
|
|
INSERT OR IGNORE INTO sona_patterns
|
|
SELECT * FROM v3db.sona_patterns
|
|
WHERE id NOT IN (SELECT id FROM sona_patterns);
|
|
|
|
-- ============================================================================
|
|
-- Merge GOAP Actions (explicit columns due to schema difference)
|
|
-- V3 has extra 'qe_domain' column, root has 'duration_estimate' vs 'estimated_duration_ms'
|
|
-- ============================================================================
|
|
INSERT OR IGNORE INTO goap_actions (
|
|
id, name, description, agent_type, preconditions, effects,
|
|
cost, duration_estimate, success_rate, execution_count, category,
|
|
created_at, updated_at
|
|
)
|
|
SELECT
|
|
id, name, description, agent_type, preconditions, effects,
|
|
cost, estimated_duration_ms, success_rate, execution_count, category,
|
|
created_at, updated_at
|
|
FROM v3db.goap_actions
|
|
WHERE id NOT IN (SELECT id FROM goap_actions);
|
|
|
|
-- ============================================================================
|
|
-- Merge KV Store entries (schema compatible - both have same columns)
|
|
-- ============================================================================
|
|
INSERT OR IGNORE INTO kv_store (key, namespace, value, created_at, expires_at)
|
|
SELECT key, namespace, value, created_at, expires_at
|
|
FROM v3db.kv_store
|
|
WHERE namespace || ':' || key NOT IN (SELECT namespace || ':' || key FROM kv_store);
|
|
|
|
-- ============================================================================
|
|
-- Verify merge counts
|
|
-- ============================================================================
|
|
SELECT 'sona_patterns' as table_name, COUNT(*) as count FROM sona_patterns
|
|
UNION ALL
|
|
SELECT 'goap_actions', COUNT(*) FROM goap_actions
|
|
UNION ALL
|
|
SELECT 'kv_store', COUNT(*) FROM kv_store;
|
|
|
|
-- Detach
|
|
DETACH DATABASE v3db;
|