python-fastapi-mm-zhcs-yj-api/routers/api/videoResource/avcon.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
from fastapi import APIRouter, Request, Depends,Query,HTTPException
from database import get_db
from sqlalchemy.orm import Session
from sqlalchemy import case,or_
from sqlalchemy import  text
from utils import *
from utils.ry_system_util import *
from utils.video_util import *
from common.security import valid_access_token
from fastapi.responses import JSONResponse
import traceback
from datetime import datetime
from common import AvconH5API

router = APIRouter()

@router.get('/get_video_list')
async def get_video_list(
    db: Session = Depends(get_db)
):
    region_list = AvconH5API.get_region()
    if region_list is not None:
        for region_item in region_list:

            region_id = region_item['region_id']
            region_name = region_item['region_name']
            region_group_list = AvconH5API.get_group(region_id)
            
            if region_group_list is not None:                
                for region_group_item in region_group_list:

                    group_id = region_group_item['group_id']
                    group_name = region_group_item['group_name']
                    
                    device_list = AvconH5API.get_group_device(group_id)
                    if device_list is not None:
                        for device_item in device_list:
                            dev_id = device_item['dev_id']
                            dev_name = device_item['dev_name']
                            logger.info("device info: {}", device_item)