
¸i¦_2  ã               @   sV   d  d l  m Z m Z d  d l m Z m Z d  d l m Z Gd d „  d e ƒ Z d S)é    )ÚjsonifyÚmake_response)ÚResourceÚreqparse)Údbc               @   s   e  Z d  Z d d „  Z d S)ÚMixingc       
   	   C   sú   t  j ƒ  } | j d d d ƒ| j d d d ƒ| j d d d ƒ| j ƒ  } | d } | d } | d } d } d j | ƒ } } t j j | ƒ } x" | D] }	 t d t	 |	 ƒ ƒ q¡ Wt
 d	 d
 d d d t	 | ƒ d t	 | ƒ d t	 | ƒ ƒ S)NÚaÚrequiredTÚbÚci¢ zTSELECT `account_number`, `account_balance` FROM account WHERE `account_number` = {0}zres -->Ústatusé   ÚmessageZSucessÚresultú )r   ÚRequestParserÚadd_argumentÚ
parse_argsÚformatr   ÚengineÚexecuteÚprintÚstrr   )
ÚselfÚparserÚargsr   r
   r   Úaccount_numberZsql_strr   Úrows© r   ú./var/www/html/sampleapi.quiits.com/concate1.pyÚpost   s    


zMixing.postN)Ú__name__Ú
__module__Ú__qualname__r    r   r   r   r   r      s   r   N)	Úflaskr   r   Úflask_restfulr   r   Úappr   r   r   r   r   r   Ú<module>   s   