Skip to main content
Glama
load_regions.py723 B
import json from pathlib import Path from sqlalchemy.orm import Session from backend.app.database import SessionLocal from backend.app.models import Region def load_regions(db: Session, path: Path): data = json.loads(path.read_text(encoding="utf-8")) for item in data: exists = db.query(Region).filter(Region.name == item["name"]).one_or_none() if exists: continue region = Region(name=item["name"], state=item.get("state")) db.add(region) db.commit() if __name__ == "__main__": db = SessionLocal() try: load_regions(db, Path(__file__).parent.parent / "data" / "regions.json") print("Regions loaded.") finally: db.close()

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/sudhans18/AegisFlood-Flood-Prediction-Community-Alert-System'

If you have feedback or need assistance with the MCP directory API, please join our Discord server