
    !h                         d dl mZ d dlZd Zy)    )get_connectionNc                   K   d }d }	 t               }|*ddd|r|j                          |r|j                          S S | j                  d      }| j                  dd      }|t        |      nd }|j	                  d      }d	}g }||d
z  }|j                  |       |dz  }|j                  |       |j                  |t        |             |j                         }d}	|j                  |	       |j                         d   }
d }t        |      |k(  r
|r|d   d   }dd||
|d|r|j                          |r|j                          S S # t        $ r@}ddt        |       dcY d }~|r|j                          |r|j                          S S d }~ww xY w# |r|j                          |r|j                          w w xY ww)NFu%   Error de conexión a la base de datos)successmessagecursorpageSize   T)
dictionaryzQ
            SELECT *
            FROM descartados_contactabilidad AS t 
        z WHERE t.id > %szN
            ORDER BY 
                t.id DESC
            LIMIT %s
        z\
            SELECT COUNT(*) AS total
            FROM descartados_contactabilidad 
        totalidzSe encontraron descartados)r   r   datatotalRecords
nextCursorzError: )r   closegetintr   appendexecutetuplefetchallfetchonelen	Exceptionstr)r   conexionr   
cursor_val	page_size	cursor_idqueryparams	registroscount_queryr   next_cursores                M/var/www/dev.api.imparables.com.co/api_imparables/crm/procesos/descartados.pyobtener_descartadosr'      s    HFD!#$1XY| LLNNN } XXh'
HHZ+	 (2'=C
O4	D1   ''EMM)$ 	  	
 	i  	ueFm,OO%	 	{#!'* y>Y&9#B--K 3!%
 LLNNN   
 Q)
 	
 LLNNN 
 LLNNN sQ   GE &GC(E &&G	FF%F&F *&GFF 'F??G)cnxpdor   mathr'        r&   <module>r,      s    ! Hr+   