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
            thickness = row["Толщина стенки, мм <Производство>"]
16
            diametr = row["Диаметр, мм <Производство>"]
17
            diametr_range = consolidator.scalar_in_guid("Параметры по Продукту ТЭСЦ-3",
18
                f"`Производство`=='Труба бесшовная ТЭСЦ-3' and `Продукт`=='{product}' and {diametr}>=`Мин` and {diametr}<=`Макс`","Диапазон")
19
            strength_class_led = consolidator.scalar_in_guid("Параметры по Продукту ТЭСЦ-3",
20
                f"`Производство`=='Труба бесшовная ТЭСЦ-3' and `Продукт`=='{product}' and `Доп параметр1`=='{row['Класс прочности <Производство>']}'","Доп параметр2")
21
            if pd.isna(strength_class_led):
22
                strength_class_led = consolidator.scalar_in_guid("Параметры по Продукту ТЭСЦ-3",
23
                f"`Производство`=='Труба бесшовная ТЭСЦ-3' and `Продукт`=='{product}' and `Доп параметр1`=='{row['Марка стали <Производство>']}'","Доп параметр2")
24
            if pd.isna(strength_class_led): strength_class_led = "ПD"
25

26
            print(f"product: {product}; thickness: {thickness}; diametr: {diametr}; diametr_range: {diametr_range}; strength_class_led: {strength_class_led}")
27
            row["error"] = pd.NA
28
        except Exception as exp: 
29
            row["error"] = f"{exp}"
30
        finally:
31
            row["Продукт УП"]=f"{product} {diametr_range} {strength_class_led}"
32
            row["Время укрупнения"]=datetime.datetime.now()
33
            return row
34
        
35
    def debug_handle(self,inputDf:pd.DataFrame,consolidator:MainConsolidator,module:str=None)->pd.DataFrame:
36
        try:
37
            if module is None: return inputDf.apply(lambda row: self.handle(row,consolidator), axis=1)
38
            else: return inputDf[inputDf["Производство2"]==module].apply(lambda row: self.handle(row,consolidator), axis=1)
39
        except: raise
40
    
41
    def get_compiled(self):
42
        code:str=f"print('{__file__}')"
43
        try:
44
            with open(__file__,encoding="utf-8",mode="r") as f:
45
                code=f.read()
46
        except Exception as exp: 
47
            code=f"print('error: {exp}')"
48
        finally:
49
            cc = compile(code,"","exec")
50
            return cc
51

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

58