metric_by_sql_general.py 648 B

1234567891011121314151617181920212223242526
  1. # -*- coding: utf-8 -*-
  2. """
  3. @author: yq
  4. @time: 2024/10/31
  5. @desc: sql直接统计指标直出
  6. """
  7. import pandas as pd
  8. from data import DataLoaderBase
  9. from entitys import MetricFucEntity
  10. from .metric_base import MetricBase
  11. class MetricBySqlGeneral(MetricBase):
  12. def __init__(self, sql: str, *args, **kwargs):
  13. self._sql = sql
  14. def validate_data(self):
  15. pass
  16. def load_data(self, data_loader: DataLoaderBase, *args, **kwargs) -> pd.DataFrame:
  17. return data_loader.get_data(self._sql)
  18. def calculate(self, *args, **kwargs) -> MetricFucEntity:
  19. return MetricFucEntity(table=self.load_data(*args, **kwargs))