
    Hf                     b    d Z ddlmZ ddlmZ ddlmZ ddlmZ ddl	m
Z
  G d d	e          Zd
S )z
    pyexcel.plugins.sources.querysets
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    Representation of querysets

    :copyright: (c) 2015-2022 by Onni Software Ltd.
    :license: New BSD License
    )	constants)AbstractSource)get_data)DB_QUERYSET   )paramsc                   p    e Zd ZdZej        ej        gZej	        fZ
ej        fZg Z	 	 	 	 	 	 	 	 ddZd ZdS )SheetQuerySetSourcez_
    Database query set as data source

    SQLAlchemy and Django query sets are supported
    Nr   c                 "   || _         | j         t          j        | _         || _        || _        || _        || _        || _        |	| _        |t          d           |t          d           |
t          d           t          j        | fi | d S )Nzstart_column is ignoredzcolumn_limit is ignoredzskip_column_func is ignored) _SheetQuerySetSource__sheet_namer   DEFAULT_SHEET_NAME"_SheetQuerySetSource__column_names _SheetQuerySetSource__query_sets"_SheetQuerySetSource__row_renderer_SheetQuerySetSource__start_row_SheetQuerySetSource__row_limit#_SheetQuerySetSource__skip_row_funcprintr   __init__)selfcolumn_names
query_sets
sheet_namerow_renderer	start_row	row_limitstart_columncolumn_limitskip_row_funcskip_column_funckeywordss               c/var/www/ffwdstore.be/apps/py-env/lib/python3.11/site-packages/pyexcel/plugins/sources/querysets.pyr   zSheetQuerySetSource.__init__   s     '$ ) <D*&*$$,+,,,+,,,#/0001111111    c                     t          | j        | j        | j                  }| j        
| j        |d<   t          | j        ft          | j        d|}|S )N)r   r   r   r    )	file_typer   )	dictr   r   r   r   r   r   r   r   )r   local_paramsdatas      r#   r   zSheetQuerySetSource.get_data?   sy    ,&&
 
 

 +,0,@L)
!,
 
 	
 
 r$   )NNr   r   NNNN)__name__
__module____qualname____doc__r   COLUMN_NAMES
QUERY_SETSfieldsr   SHEETtargetsREAD_ACTIONactions
attributesr   r    r$   r#   r
   r
      s          !6#45F G$&GJ 2 2 2 2@    r$   r
   N)r-   pyexcelr   pyexcel.sourcer   
pyexcel_ior   pyexcel_io.constantsr    r   r
   r6   r$   r#   <module>r<      s     + * * * * * ) ) ) ) ) )       , , , , , ,      ; ; ; ; ;. ; ; ; ; ;r$   