File size: 1,082 Bytes
e699b35
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
import chromadb
import sys

def search_db(query):
    # Connect to the local database
    client = chromadb.PersistentClient(path="./chroma_db")
    collection = client.get_collection(name="sec_filings")
    
    print(f"\n--- Searching Vector DB for: '{query}' ---")
    print("-" * 50)
    
    # Perform a similarity search
    results = collection.query(
        query_texts=[query],
        n_results=2 # Get top 2 results
    )
    
    chunks = results['documents'][0]
    distances = results['distances'][0]
    
    for i, (chunk, dist) in enumerate(zip(chunks, distances)):
        # Convert L2 distance to a simple similarity percentage
        similarity = max(0.0, (1.0 - (dist / 2.0))) * 100
        print(f"\nResult {i+1} (Similarity: {similarity:.1f}%):")
        print(f"{chunk[:300]}...") # Print first 300 characters
        
    print("\n" + "-" * 50)

if __name__ == "__main__":
    if len(sys.argv) > 1:
        search_db(" ".join(sys.argv[1:]))
    else:
        # Default test query
        search_db("What are the main supply chain risks and disruptions?")