ó
|
J-gi ã ó8 S SK rS SKJr S SKJr " S S5 rg)é N)Ú lru_cache)ÚDatabaseConnectionc ó& \ rS rSrS rS rS rSrg)ÚDataQueryServiceé c ó" [ 5 U l g )N)r Údb©Úselfs ÚUC:\Users\admin\Documents\trae_projects\trt_analyse\app\services\data_query_service.pyÚ__init__ÚDataQueryService.__init__ s Ü$Ó&ó c ó@ U R R 5 ( d! U R R 5 ( d gU R R 5 nSn[ R
|
" XCX4S9nU$ ! [ a n[ SU 35 SnAgSnAff = f! f = f)u
|
æ¥è¯¢åæ£ç£
秤æ°æ®
|
:param start_date: å¼å§æ¥æ
|
:param end_date: ç»ææ¥æ
|
:return: å
å«count_under, count_in_range, count_overçæ°æ®æ¡
|
Na´
|
SELECT
|
time,
|
count_under,
|
count_in_range,
|
count_over,
|
weight,
|
baseline_value,
|
over_difference,
|
under_difference
|
FROM
|
public.aics_sorting_scale_data
|
WHERE
|
time BETWEEN %s AND %s
|
ORDER BY
|
time ASC
|
)Úparamsu æ¥è¯¢æ°æ®å¤±è´¥: )r Ú is_connectedÚconnectÚget_connectionÚpdÚread_sqlÚ ExceptionÚprint)r Ú
|
start_dateÚend_dateÚ
|
connectionÚqueryÚdfÚes r Úget_sorting_scale_dataÚ'DataQueryService.get_sorting_scale_data s ð$ à77×'Ñ'×)Ñ)Øww×(Ñ(Ø ð@ ð= ×/Ñ/Ó1JðEô& U¸
|
Ð7MÑNBàð øô ó Ü Ð(¨¨Ð,Ô -Ûð ûð ûð
|
ús/ >A6 Á3A6 Á6
|
BÂ BÂB ÂBÂB ÂB c ó8 U R R 5 g)u å
³éæ°æ®åºè¿æ¥N)r Ú
|
disconnectr
|
s r Úclose_connectionÚ!DataQueryService.close_connection6 s à ×ÑÕ r )r N)Ú__name__Ú
|
__module__Ú __qualname__Ú__firstlineno__r r r# Ú__static_attributes__© r r r r s ò'ò+õZ r r )Úpandasr Ú functoolsr Úapp.database.databaser r r* r r Ú<module>r. s ðÛ Ý Ý 4÷3 ò 3 r
|
