
E_                 @   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)MultipleRowsc             C   s   t  j   } | j d  | j d  | j d  | j   } | d } | d } | d } g  } d j | d  } t j j |  } x= | D]5 }	 i  }
 |	 d |
 d <|	 d |
 d <| j |
  q Wt	 d	 d d
 d d |  S)Nabsipnamez3SELECT * FROM `extensions` WHERE `extn_group_id`={}   Zextension_number   ZsipusernameZstausmessageSuccessresult)
r   RequestParseradd_argument
parse_argsformatr   engineexecuteappendr   )selfparserargsr   r	   r
   result_listsql_strr   rowsresult_data r   7/var/www/html/sampleapi.quiits.com/sql_multiple_rows.pypost   s"    


zMultipleRows.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   