U
    aS                     @   sv   d dl Z d dlZdZdZdZdZde d e d e d	 e Zd dlZd dl	Z
e
jd
 e
 ZG dd dZdS )    Nz192.168.3.100DataZweb_appZ
web_app_pwz.DRIVER={ODBC Driver 17 for SQL Server};SERVER=z
;DATABASE=z;UID=z;PWD=z)/var/www/bike-ojisan.f5.si/logging.configc                   @   s,   e Zd Zdd Zdd Zdd Zdd Zd	S )

controllerc                 C   s   d S )N )selfr   r   :/var/www/bike-ojisan.f5.si/BikeParkingMapAPI/controller.py__init__   s    zcontroller.__init__c              	   C   s8   d}t t}t||d}W 5 Q R X t|dkS )Nz)select top 1 * from Bike_ParkingData_Mainrecordsr   )pyodbcconnectconnectionStrpdread_sqlto_dictlen)r   strSQLcondatar   r   r   healthcheck   s    zcontroller.healthcheckc              	   C   s8   d}t t }tj||||fdd}W 5 Q R X |S )Naf  
declare @maxdistance real
declare @limit int
select @maxdistance=SettingValue from Bike_Mst_SystemSettings where SettingKey ='SearchMaxDistance'
select @limit=SettingValue from Bike_Mst_SystemSettings where SettingKey ='SearchLimit'
EXEC	[dbo].[Data_up_GetNearBikeParking]
		@a_rLat = ?,
		@a_rLon = ?,
		@a_iMaxDistance = @maxdistance,
		@_iLimit = @limit
)paramsr   )r	   r
   r   r   r   r   )r   latlonr   r   r   r   r   r   getData   s    $zcontroller.getDatac              	   C   s:   d}t t"}| }||| | }W 5 Q R X |S )NzEselect SettingValue from Bike_Mst_SystemSettings where SettingKey = ?)r	   r
   r   cursorexecutefetchval)r   ZparameterNamer   r   curvalr   r   r   getSystemSetting+   s    zcontroller.getSystemSettingN)__name__
__module____qualname__r   r   r   r   r   r   r   r   r      s   r   )r	   pandasr   serverZdatabaseusernamepasswordr   	tracebacklogging.configloggingconfig
fileConfig	getLoggerloggerr   r   r   r   r   <module>   s    