File size: 6,377 Bytes
7cfdc4c
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
"""
Migration script to migrate messages in database for a specific thread.

Usage:
    python -m core.utils.migrate_thread <thread_id>
    python -m core.utils.migrate_thread <thread_id> --dry-run
"""
import sys
import argparse

from core.utils.message_migration import migrate_message, needs_migration
from core.utils.json_helpers import safe_json_parse
from core.utils.config import config
from supabase.client import create_client


def migrate_thread_in_db(thread_id: str, dry_run: bool = False):
    """Migrate messages in database for a specific thread."""
    
    # Initialize Supabase client
    client = create_client(config.SUPABASE_URL, config.SUPABASE_SERVICE_ROLE_KEY)
    
    print(f"=" * 80)
    print(f"MIGRATING THREAD IN DATABASE: {thread_id}")
    if dry_run:
        print(f"⚠️  DRY RUN MODE - No changes will be written to database")
    print(f"=" * 80)
    
    # Fetch messages
    print("\n1️⃣  Fetching messages from database...")
    result = client.table('messages')\
        .select('*')\
        .eq('thread_id', thread_id)\
        .order('created_at')\
        .execute()
    
    messages = result.data
    print(f"   ✓ Fetched {len(messages)} messages")
    
    # Separate by type for migration
    assistant_messages = [m for m in messages if m.get('type') == 'assistant']
    tool_messages = [m for m in messages if m.get('type') == 'tool']
    
    print(f"\n2️⃣  Migrating assistant messages...")
    migrated_assistants = []
    updated_assistants = 0
    
    for msg in assistant_messages:
        if needs_migration(msg):
            print(f"   Migrating assistant: {msg['message_id']}")
            migrated = migrate_message(msg)
            if migrated:
                migrated_assistants.append(migrated)
                # Update database
                if not dry_run:
                    try:
                        # Get migrated metadata
                        migrated_metadata = safe_json_parse(migrated.get('metadata', '{}'), {})
                        # Update in database
                        client.table('messages')\
                            .update({'metadata': migrated_metadata})\
                            .eq('message_id', msg['message_id'])\
                            .execute()
                        updated_assistants += 1
                        print(f"      ✓ Updated in database")
                    except Exception as e:
                        print(f"      ❌ Error updating: {e}")
                else:
                    print(f"      [DRY RUN] Would update metadata")
                    updated_assistants += 1
            else:
                migrated_assistants.append(msg)
        else:
            print(f"   Skipping (already migrated): {msg['message_id']}")
            migrated_assistants.append(msg)
    
    print(f"\n3️⃣  Migrating tool messages...")
    migrated_tools = []
    updated_tools = 0
    
    for msg in tool_messages:
        if needs_migration(msg):
            print(f"   Migrating tool: {msg['message_id']}")
            migrated = migrate_message(msg, migrated_assistants)
            if migrated:
                migrated_tools.append(migrated)
                # Update database
                if not dry_run:
                    try:
                        # Get migrated metadata
                        migrated_metadata = safe_json_parse(migrated.get('metadata', '{}'), {})
                        # Update in database
                        client.table('messages')\
                            .update({'metadata': migrated_metadata})\
                            .eq('message_id', msg['message_id'])\
                            .execute()
                        updated_tools += 1
                        print(f"      ✓ Updated in database")
                    except Exception as e:
                        print(f"      ❌ Error updating: {e}")
                else:
                    print(f"      [DRY RUN] Would update metadata")
                    updated_tools += 1
            else:
                migrated_tools.append(msg)
        else:
            print(f"   Skipping (already migrated): {msg['message_id']}")
            migrated_tools.append(msg)
    
    # Summary
    print(f"\n{'=' * 80}")
    print(f"MIGRATION SUMMARY")
    print(f"{'=' * 80}")
    print(f"  Assistant messages migrated: {updated_assistants}/{len(assistant_messages)}")
    print(f"  Tool messages migrated: {updated_tools}/{len(tool_messages)}")
    print(f"  Total messages updated: {updated_assistants + updated_tools}")
    
    if dry_run:
        print(f"\n⚠️  DRY RUN - No changes were written to database")
        print(f"   Run without --dry-run flag to apply changes")
    else:
        print(f"\n✅ Migration complete! Database updated successfully.")
    
    # Show sample migrated message
    if migrated_assistants:
        sample = migrated_assistants[0]
        metadata = safe_json_parse(sample.get('metadata', '{}'), {})
        print(f"\n📄 Sample migrated assistant message:")
        print(f"   Message ID: {sample['message_id']}")
        print(f"   Has tool_calls: {'tool_calls' in metadata}")
        print(f"   Has text_content: {'text_content' in metadata}")
        if 'tool_calls' in metadata:
            print(f"   Tool calls: {len(metadata['tool_calls'])}")
    
    if migrated_tools:
        sample = migrated_tools[0]
        metadata = safe_json_parse(sample.get('metadata', '{}'), {})
        print(f"\n📄 Sample migrated tool message:")
        print(f"   Message ID: {sample['message_id']}")
        print(f"   Has result: {'result' in metadata}")
        print(f"   Has tool_call_id: {'tool_call_id' in metadata}")
        print(f"   Function: {metadata.get('function_name')}")


if __name__ == '__main__':
    parser = argparse.ArgumentParser(description='Migrate messages in database for a thread')
    parser.add_argument('thread_id', nargs='?', help='Thread ID to migrate')
    parser.add_argument('--dry-run', action='store_true', help='Dry run mode - do not write to database')
    args = parser.parse_args()
    
    if not args.thread_id:
        print("❌ Error: thread_id is required")
        print("Usage: python -m core.utils.migrate_thread <thread_id> [--dry-run]")
        sys.exit(1)
    
    migrate_thread_in_db(args.thread_id, dry_run=args.dry_run)