from sqlalchemy import create_engine, Column, String, Integer, Text
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
import logging
import os

Base = declarative_base()

class DocumentAnalysis(Base):
    __tablename__ = "document_analysis"
    id = Column(Integer, primary_key=True, autoincrement=True)
    source = Column(String, nullable=False)
    title = Column(String, nullable=True)
    links = Column(Text, nullable=True)
    error = Column(Text, nullable=True)

DATABASE_URL = os.getenv("DATABASE_URL", "sqlite:///document_analysis.db")
if not DATABASE_URL:
    raise ValueError("DATABASE_URL environment variable is not set.")
engine = create_engine(DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base.metadata.create_all(bind=engine)

# Connect to the apps, dashboards, modules, tools, payloads, and exploits
from app_security.app_vulnerability_scanner import scan_application
from app import monitoring, threat_intelligence, advanced_threat_intelligence, predictive_analytics, automated_incident_response, ai_red_teaming, apt_simulation, machine_learning_ai, data_visualization, blockchain_logger, cloud_exploitation, iot_exploitation, quantum_computing, edge_computing, serverless_computing, microservices_architecture, cloud_native_applications
from backend.code_parser import CodeParser
from backend.pipeline_manager import PipelineManager
from c2_dashboard import C2Dashboard
from chatbot.app import scan_network, deploy_exploit
from chatbot.chatbot import handle_vulnerability_scanning, handle_exploit_deployment
from dashboard.dashboard import malware_analysis, social_engineering
from exploits.exploits2 import deploy_exploit as deploy_exploit2
from exploits.ios_framework_extracted.iOS_Zero_Click_Framework_Updated.exploits import deploy_exploit as deploy_exploit_ios
from modules.alerts_notifications import AlertsNotifications
from modules.apt_simulation import APTSimulation

# Configure logging
logging.basicConfig(level=logging.ERROR, format='%(asctime)s - %(levelname)s - %(message)s')

# Verification of component connections
def verify_component_connections():
    try:
        # Check database connection
        session = SessionLocal()
        session.execute('SELECT 1')
        session.close()
        logging.info("Database connection verified.")
        
        # Check app components
        if not all([monitoring, threat_intelligence, advanced_threat_intelligence, predictive_analytics, automated_incident_response, ai_red_teaming, apt_simulation, machine_learning_ai, data_visualization, blockchain_logger, cloud_exploitation, iot_exploitation, quantum_computing, edge_computing, serverless_computing, microservices_architecture, cloud_native_applications]):
            raise ValueError("App component connection check failed")
        logging.info("App components connection verified.")
        
        # Check backend components
        if not all([CodeParser, PipelineManager]):
            raise ValueError("Backend component connection check failed")
        logging.info("Backend components connection verified.")
        
        # Check chatbot components
        if not all([scan_network, deploy_exploit, handle_vulnerability_scanning, handle_exploit_deployment]):
            raise ValueError("Chatbot component connection check failed")
        logging.info("Chatbot components connection verified.")
        
        # Check dashboard components
        if not all([malware_analysis, social_engineering]):
            raise ValueError("Dashboard component connection check failed")
        logging.info("Dashboard components connection verified.")
        
        # Check exploits components
        if not all([deploy_exploit2, deploy_exploit_ios]):
            raise ValueError("Exploits component connection check failed")
        logging.info("Exploits components connection verified.")
        
        # Check modules components
        if not all([AlertsNotifications, APTSimulation]):
            raise ValueError("Modules components connection check failed")
        logging.info("Modules components connection verified.")
        
    except Exception as e:
        logging.error(f"Component connection verification failed: {e}")

# Run verification
verify_component_connections()