
    h                         S SK r S SKrS rg)    Nc            	         [         R                  " [        R                  " S5      [	        [        R                  " SS5      5      [        R                  " S5      [        R                  " S5      [        R                  " S5      [         R
                  R                  S9n  U R                  5        nUR                  S5        UR                  5       nU(       a  S	U;  d  S
U;  a  [        S5      e[        US	   5      [        US
   5      -   nSU0sS S S 5        U R                  5         $ ! , (       d  f       O= f U R                  5         g ! U R                  5         f = f)NDB_HOSTDB_PORTi  DB_USERDB_PASSDB_NAME)hostportuserpassworddatabasecursorclassz
                SELECT IPV, MPV
                FROM pensavT
                ORDER BY Date DESC
                LIMIT 1
            IPVMPVzMissing IPV or MPV in DB rowstart_value)pymysqlconnectosgetenvintcursors
DictCursorcursorexecutefetchone
ValueErrorfloatclose)connr   rowtotal_values       /D:\OneDrive\mawdz09.ukweb\api\test_pensav_db.py
fetch_datar#      s   ??YYy!9d+,YYy!9%9%OO..D[[]fNN   //#C%s*e3.> !?@@E
+eCJ.??K { ]& 	

' ]]& 	



s%   !E 1A D+	E +
D95E E )r   r   r#        r"   <module>r&      s    	 r%   