ó ü¤Sc�����������@���s»���d��Z��d�Z�d�d�l�Z�d�d�l�Z�d�d�l�Z�d�d�l�Z�d�d�l�m�Z�m �Z �m �Z �m�Z�d�d�l�m �Z �d�d�l�m�Z�d�d�l�m�Z�d�d�l�m�Z�d �e�j�f�d �„��ƒ��YZ�d�S(���s¸��Implements the SQLTable docutils directive. License :: This work was created by participants in the DataONE project, and is jointly copyrighted by participating institutions in DataONE. For more information on DataONE, see our web site at http://dataone.org. Copyright 2011 Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. SQLTable is an extension to docutils reStructuredText processor which adds the ability to pull table content from an SQL data source, a CSV file, or an Excel spread sheet. SQLManager_ is a convenient tool for working with SQLite databases. Project: DataONE Author: Dave Vieglais Example for use in Sphinx, add to conf.py after ``import sys, os``:: #Import the SQLTable directive RST extension from sqltable import SQLTable from docutils.parsers.rst import directives directives.register_directive('sql-table', SQLTable) .. _SQLManager: http://code.google.com/p/sqlite-manager/ t���reStructuredTextiÿÿÿÿN(���t���iot���nodest���statemachinet���utils(���t���SystemMessagePropagation(���t ���Directive(���t ���directives(���t���tablest���SQLTablec�����������B���s ���e��Z�d��Z�d�Z�d�Z�e�Z�e�Z�i�e�j �d�6e�j �d�6e�j�d�6e�j�d�6e�j �d�6e�j�d�6e�j�d �6e�j�d �6Z�d�„��Z�d�„��Z�d �„��Z�d�„��Z�RS(���s��� i���i���t���headert���widthst���encodings���stub-columnst���classt���drivert���sourcet���sqlc���������C���s���d��S(���N(����(���t���self(����(����sn���/var/lib/jenkins/jobs/DataONE-Operations-Manual/workspace/operations/tools/docutils/rst_directives/sqltable.pyt���check_requirementsK���s����c���������C���sr��y‹�|��j��ƒ��|��j�j�d�d�ƒ�}�|��j�ƒ��\�}�}�|��j�ƒ��\�}�}�|��j�ƒ��}�|��j�|�ƒ�}�|��j�|�d�|�ƒ�|��j�|�|�|�f�ƒ�Wnw�t �k �r«�}�|�j �d�g�St�j�k �r}�|��j �j�j�d�|��j�|�f�t�j�|��j�|��j�ƒ�d�|��j�ƒ} �| �g�SX|�|�|�f�} �|��j�j�| �|��j�|�ƒ�}�|�d�c�|��j�j�d�g��ƒ�7<|�rg|�j�d�|�ƒ�n��|�g�|�S(���Ns���stub-columnsi����s)���Error with SQL data in "%s" directive: %st���linet���classesR ���(���R���t���optionst���gett ���make_titlet���get_sql_datat���process_header_optiont���get_column_widthst���check_table_dimensionst"���extend_short_rows_with_empty_cellsR���t���argst���csvt���Errort ���state_machinet���reportert���errort���nameR���t ���literal_blockt ���block_textt���linenot���statet���build_tablet���content_offsett���insert(���R���t���stub_columnst���titlet���messagest ���table_bodyt���max_colst ���table_headt ���col_widthst���detailR"���t���tablet ���table_node(����(����sn���/var/lib/jenkins/jobs/DataONE-Operations-Manual/workspace/operations/tools/docutils/rst_directives/sqltable.pyt���runO���s0���� c���������C���sj���g��}�|��j��j�d�d�ƒ�}�xE�|�j�d�ƒ�D]4�}�|�j�d�d�d�t�j�|�j�ƒ��j�ƒ��ƒ�g�ƒ�q+�W|�g�S(���s���Returns table_head R ���t����t���,i����(���R���R���t���splitt���appendR���t ���StringListt���stript ���splitlines(���R���t���rest���colnamest���col(����(����sn���/var/lib/jenkins/jobs/DataONE-Operations-Manual/workspace/operations/tools/docutils/rst_directives/sqltable.pyR���j���s ����2c���������B���s°��|��j��j�d�d�ƒ�}�|�d�k�rw�d�d�l�m�}�d�d�l�}�|�j�d�ƒ�}�|�|�ƒ�}�|�j�|��j��j�d�d�ƒ�ƒ�nH�d �}�d �}�d�|��j��j�d�d�ƒ�d�Ud �|��j��j�d�|�ƒ�}�|�d�U|�j�ƒ��}�e�|��j��j�d�ƒ�ƒ�} �|�j �| �ƒ�} �g��}�d�}�|�j �ƒ��} �x�| �d�k �r›g��}�xH�| �D]@�}�e�|�ƒ�}�d�d�d�e �j�|�j�ƒ��ƒ�f�}�|�j�|�ƒ�q&W|�j�|�ƒ�e�|�e�|�ƒ�ƒ�}�|�j �ƒ��} �q W|�j�ƒ��|�|�f�S(���s���Returns rows, max_cols R���t���xlsxiÿÿÿÿ(���t���Xls2SqlNs���:memory:R���s ���data.xlsxs"���database="data.xlsx",driver="xslx"s ���database="csv-data",driver="csv"s���import %s as DBDRVt���SnakeSQLs���dbconn = DBDRV.connect(%s)R���i����(���R���R���t ���utils.xls2sqlRA���t���sqlite3t���connectt���loadt���cursort���strt���executet���fetchonet���Nonet���unicodeR���R:���R<���R9���t���maxt���lent���close(���R���R���RA���RD���t���dbconnt���loadert���default_srct���cnstrRG���t���SQLR=���t���rowsR/���t���rowt���row_datat���cellt ���cell_textt ���cell_data(����(����sn���/var/lib/jenkins/jobs/DataONE-Operations-Manual/workspace/operations/tools/docutils/rst_directives/sqltable.pyR���t���s<���� (���t���__name__t ���__module__t���__doc__t���required_argumentst���optional_argumentst���Truet���final_argument_whitespacet���has_contentR���t ���unchangedt���positive_int_listR���t���nonnegative_intt���class_optiont���unchanged_requiredt���option_specR���R5���R���R���(����(����(����sn���/var/lib/jenkins/jobs/DataONE-Operations-Manual/workspace/operations/tools/docutils/rst_directives/sqltable.pyR ���9���s"��� (���R]���t ���__docformat__t���syst���os.patht���osR���t���loggingt���docutilsR���R���R���R���t���docutils.utilsR���t���docutils.parsers.rstR���R���t���docutils.parsers.rst.directivesR���t���TableR ���(����(����(����sn���/var/lib/jenkins/jobs/DataONE-Operations-Manual/workspace/operations/tools/docutils/rst_directives/sqltable.pyt���<module>*���s���"