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

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

54