Скрипт для ручной миграции

from re import search

from sqlalchemy import create_engine, not_
from sqlalchemy.orm import sessionmaker

from settings import get_settings
from userdata_api.exceptions import ObjectNotFound
from userdata_api.models.db import Info, Param


def create_session():
    settings = get_settings()
    engine = create_engine(str(settings.DB_DSN))
    TestingSessionLocal = sessionmaker(bind=engine)
    return TestingSessionLocal()


def validate_info():
    dbsession = create_session()
    info_list = (
        dbsession.query(Info)
        .join(Param)
        .filter(Param.validation != None, not_(Info.is_deleted))
        .order_by(Info.owner_id)
        .all()
    )
    print("Invalid userdata:\n")
    for info in info_list:
        param = dbsession.query(Param).filter(Param.id == info.param_id).one_or_none()
        if not param:
            raise ObjectNotFound(Param, info.param_id)
        if not search(param.validation, info.value):
            print(info, end="\n\n")

Валидация данных в юзердате #19

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions