U
    YHg                     @   sV   d dl mZ d dlZd dlmZ d dlmZmZmZ d dlm	Z	 G dd dej
ZdS )    )absolute_importN)datetime)appdb
app_logger)get_current_isttimec                   @   s   e Zd ZdZejejddZeedZ	eej
ZeedZeedZeej
ZejedddZedd	 Zed
d ZdS )
ChangeReqschange_reqsT)primary_key   2   open)server_defaultc              
   C   s   dt jd  d t jd  d t jd  d t jd  }zt|W S  tk
r } z td	| d
|  W Y d S d }~X Y nX d S )Nzdbname=DB_NAMEz user=DB_USERz host=DB_HOSTz
 password=DB_PWDz#Unable to connect to the database: z. Error message: )r   configpsycopg2connect	Exceptionr   info)clsdb_conn_stringerror r   4/var/www/dostadmin/dostadmin/db_model/change_reqs.pyget_db_connection   s.    
zChangeReqs.get_db_connectionc                 C   sV   t  }|sdS | }t  }d|d d| d| d}|| |  dS )NFzXINSERT INTO change_reqs(request_type, request_date, phone, new_data) VALUES('TIME_CR', 'z%Y-%m-%dz', 'z')T)r   r   cursorr   datestrftimeexecutecommit)r   phoneZnew_timeZdb_connectionr   
today_dateZ
insert_sqlr   r   r   create_change_request'   s    

z ChangeReqs.create_change_requestN)__name__
__module____qualname____tablename__r   ColumnIntegeridStringZrequest_typeDateZrequest_dater#   new_dataZchange_datestatusclassmethodr   r%   r   r   r   r   r      s   
r   )
__future__r   r   r   	dostadminr   r   r   utils.helpers.helpersr   Modelr   r   r   r   r   <module>   s
   