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 'Труба круглая ТЭСЦ-2'
11
    @staticmethod
12
    def handle(row:pd.Series,consolidator:MainConsolidator)->pd.Series:
13
        try:
14
            product = row["Первичный продукт"]
15
            thickness = row["Толщина стенки, мм <Производство>"]
16
            typical_diametr = consolidator.nearest_in_guid("Параметры по Продукту ТЭСЦ-2",
17
                f"`Производство`=='Труба круглая ТЭСЦ-2' and `Продукт`=='{product}'",
18
                "Доп параметр1",
19
                row["Диаметр, мм <Производство>"],
20
                "Доп параметр1"
21
                )
22
            typical_diametr_s = str(typical_diametr).replace(".",",").replace(",0","")
23
            thickness_range = consolidator.scalar_in_guid("Параметры по Продукту ТЭСЦ-2",
24
                f"`Производство`=='Труба круглая ТЭСЦ-2' and `Продукт`=='{product}' and `Доп параметр1`=='{typical_diametr_s}'","Диапазон")            
25
            print(f"product: {product}; thickness: {thickness}; thickness_range: {thickness_range}; typical_diametr: {typical_diametr_s}")
26
            row["error"] = pd.NA
27
        except Exception as exp: 
28
            row["error"] = f"{exp}"
29
        finally:
30
            row["Продукт УП"]=f"{product}{typical_diametr_s} {thickness_range} ГУ"
31
            row["Время укрупнения"]=datetime.datetime.now()
32
            return row
33
        
34
    def debug_handle(self,inputDf:pd.DataFrame,consolidator:MainConsolidator,module:str=None)->pd.DataFrame:
35
        try:
36
            if module is None: return inputDf.apply(lambda row: self.handle(row,consolidator), axis=1)
37
            else: return inputDf[inputDf["Производство2"]==module].apply(lambda row: self.handle(row,consolidator), axis=1)
38
        except: raise
39
    
40
    def get_compiled(self):
41
        code:str=f"print('{__file__}')"
42
        try:
43
            with open(__file__,encoding="utf-8",mode="r") as f:
44
                code=f.read()
45
        except Exception as exp: 
46
            code=f"print('error: {exp}')"
47
        finally:
48
            cc = compile(code,"","exec")
49
            return cc
50

51
if __name__=="__pipe_t2__":
52
    consolidator:MainConsolidator
53
    record:pd.Series
54
    result:pd.Series
55
    result = handler.handle(record,consolidator)
56

57