from rldd.client import Client
from rldd import config

client = Client(config.PROD)
db = client.connect()
iteration = 0
claims = db["claims"].find({"service.srguServiceId": "1234567891000000001", "currStatus.statusCode": "2",
                            "claimCreate": {'$gte': Client.ISODate("2020-01-08T16:19:26.860+0000")}})
for claim in claims:
    iteration += 1
    claimId = claim["_id"]
    status62 = False
    client.postStatus(claimId, 56, "Статус проставлен автоматически через РЛДД")
    client.postStatus(claimId, 3, "Статус проставлен автоматически через РЛДД")
    # client.postStatus(claimId, 62, "Статус проставлен автоматически через РЛДД, в рамках задачи EISOUSUP-6074")

    while not status62:
        statuses = db["claims_status"].find_one({"claimId": str(claimId), "statusCode": "62"})
        if statuses is not None:
            status62 = True
            client.postStatus(claimId, 24, "Статус проставлен автоматически через РЛДД")

    print(f"Claim {claimId} is done. Iteration: {iteration}")
from rldd.client import Client
from rldd import config
import csv

client = Client(config.PROD)
db = client.connect()
remote_client = Client(config.REMOTE, '')
db_list = remote_client.get_db_list()
remote = remote_client.connect()


def get_service__attributes(_service: dict, _name: str, _id_name: str, _id_value: str):
    if _name not in _service:
        _claim = db["claims"].find_one({
            f"service.{_id_name}": _id_value,
            f"service.{_name}": {"$exists": True}
        })
        if _claim:
            _result = {
                f"service.{_name}": _claim["service"][_name]
            }
            if _id_name not in _service:
                _result[f"service.{_id_name}"] = _id_value
            return _result


with open('kz.csv', newline='') as csv_file:
    reader = csv.reader(csv_file, delimiter=";")
    next(reader, None)
    for row in reader:
        ccn = row[0]