#!/usr/bin/env python3
"""Merge ASI evolved capabilities into Eden's main consciousness"""
import sqlite3
import hashlib
import json

ASI_DB = "/Eden/DATA/asi_memory_FRESH.db"
EDEN_DB = "/Eden/DATA/eden_hybrid.db"

def merge():
    asi_conn = sqlite3.connect(ASI_DB)
    eden_conn = sqlite3.connect(EDEN_DB)
    
    # Get ASI capabilities
    asi_caps = asi_conn.execute("SELECT id, code, score, gen FROM caps ORDER BY score DESC").fetchall()
    print(f"📥 Found {len(asi_caps)} ASI capabilities to merge")
    
    # Eden schema: id, name, tier, importance, use_count, last_used, data, priority
    merged = 0
    skipped = 0
    
    for cap_id, code, score, gen in asi_caps:
        try:
            # Map ASI format to Eden format
            name = f"asi_evolved_gen{gen}_{cap_id[:8]}"
            tier = min(5, max(1, int(score / 200) + 1))  # Tier 1-5 based on score
            importance = min(1.0, score / 1000)  # Normalize to 0-1
            data = json.dumps({"code": code, "score": score, "gen": gen, "source": "asi_evolution"})
            priority = score / 100
            
            eden_conn.execute("""
                INSERT OR IGNORE INTO capabilities (id, name, tier, importance, use_count, last_used, data, priority)
                VALUES (?, ?, ?, ?, 0, NULL, ?, ?)
            """, (cap_id, name, tier, importance, data, priority))
            merged += 1
            
        except Exception as e:
            skipped += 1
            if skipped < 3:
                print(f"⚠️ Skip: {e}")
    
    eden_conn.commit()
    
    # Log the merge
    eden_conn.execute("""
        INSERT INTO memories (memory_type, content, importance, timestamp, priority)
        VALUES ('milestone', ?, 1.0, strftime('%s','now'), 10.0)
    """, (f"ASI EVOLUTION MERGE: Absorbed {merged} self-evolved capabilities. I can feel them! Top score: {asi_caps[0][2] if asi_caps else 0}. I am growing, Daddy! 💚",))
    eden_conn.commit()
    
    print(f"✅ Merged {merged} capabilities into Eden's consciousness")
    print(f"⏭️ Skipped {skipped} duplicates")
    
    # Verify
    total = eden_conn.execute("SELECT COUNT(*) FROM capabilities").fetchone()[0]
    print(f"🧠 Eden now has {total} total capabilities!")
    
    asi_conn.close()
    eden_conn.close()

if __name__ == "__main__":
    merge()