Files
DeepAudit/backend/scripts/init_llm_settings.py
2025-11-03 09:52:45 +00:00

113 lines
3.8 KiB
Python

"""Initialize Default LLM Settings in Database
Creates default LLM configuration in the database if not exists.
"""
import asyncio
import sys
from pathlib import Path
# Add parent directory to path
sys.path.insert(0, str(Path(__file__).parent.parent))
from sqlalchemy import select
from loguru import logger
from db.session import AsyncSessionLocal
from models.system_settings import SystemSettings
async def init_llm_settings():
"""Initialize default LLM settings in database"""
async with AsyncSessionLocal() as session:
try:
# Default LLM settings
default_settings = [
{
"key": "llm.provider",
"value": "ollama",
"category": "llm",
"description": "LLM Provider (gemini, openai, claude, ollama, etc.)",
"is_sensitive": False
},
{
"key": "llm.model",
"value": "qwen2.5-coder:7b",
"category": "llm",
"description": "LLM Model name",
"is_sensitive": False
},
{
"key": "llm.temperature",
"value": "0.2",
"category": "llm",
"description": "LLM Temperature (0.0-1.0)",
"is_sensitive": False
},
{
"key": "llm.max_tokens",
"value": "4000",
"category": "llm",
"description": "Maximum tokens for LLM response",
"is_sensitive": False
},
{
"key": "llm.timeout",
"value": "150",
"category": "llm",
"description": "LLM request timeout (seconds)",
"is_sensitive": False
},
{
"key": "llm.base_url",
"value": "http://localhost:11434",
"category": "llm",
"description": "Base URL for Ollama or custom LLM endpoint",
"is_sensitive": False
},
]
# Check and add settings
updated_count = 0
created_count = 0
for setting_data in default_settings:
result = await session.execute(
select(SystemSettings).where(SystemSettings.key == setting_data["key"])
)
existing = result.scalar_one_or_none()
if existing:
logger.info(f"⏭️ Setting already exists: {setting_data['key']} = {existing.value}")
else:
# Create new setting
new_setting = SystemSettings(**setting_data)
session.add(new_setting)
created_count += 1
logger.info(f"✅ Created setting: {setting_data['key']} = {setting_data['value']}")
await session.commit()
logger.info("=" * 80)
logger.info(f"✅ LLM Settings Initialization Complete")
logger.info(f"📊 Created: {created_count}, Skipped: {len(default_settings) - created_count}")
logger.info("=" * 80)
except Exception as e:
logger.error(f"❌ Error initializing LLM settings: {e}")
await session.rollback()
raise
def main():
"""Main entry point"""
logger.info("Initializing default LLM settings...")
asyncio.run(init_llm_settings())
logger.info("LLM settings initialization complete")
if __name__ == "__main__":
main()