from models import *

def get_video_tag_list(db,video_code:str):
    query = db.query(TpVideoTag)
    query = query.filter(TpVideoTag.del_flag != '2')
    query = query.filter(TpVideoTag.video_code == video_code)
    query = query.order_by(TpVideoTag.video_code)
    return query.all()