66 lines
1.9 KiB
Python
66 lines
1.9 KiB
Python
"""Quick diagnostic script to check sample paths in both databases."""
|
|
|
|
import json
|
|
from db_utils import DatabaseConnection
|
|
|
|
# Load configuration
|
|
with open('config.json', 'r') as f:
|
|
config = json.load(f)
|
|
|
|
# Connect to databases
|
|
print("Connecting to source database...")
|
|
source_conn = DatabaseConnection(config['source_db'])
|
|
|
|
print("Connecting to target database...")
|
|
target_conn = DatabaseConnection(config['target_db'])
|
|
|
|
# Get sample paths from source
|
|
print("\n" + "="*50)
|
|
print("SAMPLE PATHS FROM SOURCE (_Citadel_CS_Test)")
|
|
print("="*50)
|
|
source_samples = source_conn.execute_query("""
|
|
SELECT TOP 10
|
|
d.DocumentID,
|
|
d.Filename,
|
|
p.Path AS FolderPath,
|
|
p.Path + '\\' + d.Filename AS FullVaultPath
|
|
FROM Documents d
|
|
INNER JOIN DocumentsInProjects dp ON d.DocumentID = dp.DocumentID
|
|
INNER JOIN Projects p ON dp.ProjectID = p.ProjectID
|
|
ORDER BY d.DocumentID
|
|
""")
|
|
|
|
for doc in source_samples:
|
|
print(f"DocID: {doc['DocumentID']}")
|
|
print(f" Filename: {doc['Filename']}")
|
|
print(f" FolderPath: [{doc['FolderPath']}]")
|
|
print(f" FullVaultPath: [{doc['FullVaultPath']}]")
|
|
print()
|
|
|
|
# Get sample paths from target
|
|
print("\n" + "="*50)
|
|
print("SAMPLE PATHS FROM TARGET (IDSVault_Test)")
|
|
print("="*50)
|
|
target_samples = target_conn.execute_query("""
|
|
SELECT TOP 10
|
|
d.DocumentID,
|
|
d.Filename,
|
|
p.Path AS FolderPath,
|
|
p.Path + '\\' + d.Filename AS FullVaultPath
|
|
FROM Documents d
|
|
INNER JOIN DocumentsInProjects dp ON d.DocumentID = dp.DocumentID
|
|
INNER JOIN Projects p ON dp.ProjectID = p.ProjectID
|
|
ORDER BY d.DocumentID
|
|
""")
|
|
|
|
for doc in target_samples:
|
|
print(f"DocID: {doc['DocumentID']}")
|
|
print(f" Filename: {doc['Filename']}")
|
|
print(f" FolderPath: [{doc['FolderPath']}]")
|
|
print(f" FullVaultPath: [{doc['FullVaultPath']}]")
|
|
print()
|
|
|
|
# Close connections
|
|
source_conn.close()
|
|
target_conn.close()
|