consolidator

1
import os
2
import sys
3
import pandas as pd
4
import datetime
5
from MainConsolidator import MainConsolidator
6

7
class handler(object):
8
    @staticmethod
9
    def module_name():
10
        return 'Заготовка муфтовая ТЭСЦ-3'
11
    @staticmethod
12
    def handle(row:pd.Series,consolidator:MainConsolidator)->pd.Series:
13
        try:
14
            product = row["Первичный продукт"]
15
            diametr = row["Диаметр, мм <Производство>"]
16
            carving = row["Тип резьбы <Производство>"]
17
            strength_class = row["Класс прочности <Производство>"]
18
            diametr_type = consolidator.scalar_in_guid("Параметры по Продукту ТЭСЦ-5",f"`Производство`=='Муфта ТЭСЦ-5' and `Доп параметр1`=={round(diametr,1)}","Доп параметр2")
19
            carving_type = consolidator.scalar_in_guid("Резьба",f"`Исх резьба`=='{carving}'","Результ Резьба")
20
            strength_group = consolidator.scalar_in_guid("Группа по классу прочности для муфт",f"`Марка стали`=='{strength_class}'","Группа прочности")
21
            if pd.isna(carving): carving_type="БР"
22
            print(f"product: {product}; diametr: {diametr}; diametr_type: {diametr_type}; carving: {carving}; carving_type: {carving_type}; strength_class_type: {strength_group}")
23
            product_up=f"{product}{diametr_type} {strength_group} {carving_type}" 
24
            row["error"] = pd.NA
25
        except Exception as exp:            
26
            row["error"] = f"{exp}"
27
        finally:
28
            row["Продукт УП"]=product_up
29
            row["Время укрупнения"]=datetime.datetime.now()
30
            return row
31
        
32
    def debug_handle(self,inputDf:pd.DataFrame,consolidator:MainConsolidator,module:str=None)->pd.DataFrame:
33
        try:
34
            if module is None: return inputDf.apply(lambda row: self.handle(row,consolidator), axis=1)
35
            else: return inputDf[inputDf["Производство2"]==module].apply(lambda row: self.handle(row,consolidator), axis=1)
36
        except: raise
37
    
38
    def get_compiled(self):
39
        code:str=f"print('{__file__}')"
40
        try:
41
            with open(__file__,encoding="utf-8",mode="r") as f:
42
                code=f.read()
43
        except Exception as exp: 
44
            code=f"print('error: {exp}')"
45
        finally:
46
            cc = compile(code,"","exec")
47
            return cc
48

49
if __name__=="__billet_sleeve_t3__":
50
    consolidator:MainConsolidator
51
    record:pd.Series
52
    result:pd.Series
53
    result = handler.handle(record,consolidator)
54

55