.. _f-databasecore2:

module ``sql.database_core2``
=============================





.. inheritance-diagram:: pyensae.sql.database_core2


Short summary
+++++++++++++

module ``pyensae.sql.database_core2``

:class:`Database`


:githublink:`%|py|6`




Classes
+++++++

+---------------------------------------------------------------------------+----------------------------------------------------+
| class                                                                     | truncated documentation                            |
+===========================================================================+====================================================+
| :class:`DatabaseCore2 <pyensae.sql.database_core2.DatabaseCore2>`         | Complementary methods for class :class:`Database`. |
+---------------------------------------------------------------------------+----------------------------------------------------+
| :class:`NoHeaderException <pyensae.sql.database_core2.NoHeaderException>` | just to be meant to be caucht later by a unit test |
+---------------------------------------------------------------------------+----------------------------------------------------+










Methods
+++++++

+-----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
| method                                                                                        | truncated documentation                                                                                               |
+===============================================================================================+=======================================================================================================================+
| :py:meth:`_check_connection <pyensae.sql.database_core2.DatabaseCore2._check_connection>`     | Checks the SQL connection.                                                                                            |
+-----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
| :py:meth:`_check_values <pyensae.sql.database_core2.DatabaseCore2._check_values>`             | When values are inserted or updated, this method doubles ``"'"`` it does not allow str values, only str.              |
+-----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
| :py:meth:`_get_insert_request <pyensae.sql.database_core2.DatabaseCore2._get_insert_request>` | Builds an ``INSERT SQL`` request from a dictionary.                                                                   |
+-----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
| :py:meth:`_guess_columns <pyensae.sql.database_core2.DatabaseCore2._guess_columns>`           | Guesses the columns types from a file (the method assumes there is a header), The types are chosen in that order: ... |
+-----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
| :py:meth:`_process_text_line <pyensae.sql.database_core2.DatabaseCore2._process_text_line>`   | Processes a text line.                                                                                                |
+-----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
| :meth:`get_python_code <pyensae.sql.database_core2.DatabaseCore2.get_python_code>`            | Returns the python code associated to this database.                                                                  |
+-----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
| :meth:`summary <pyensae.sql.database_core2.DatabaseCore2.summary>`                            | Returns the list of tables, their columns, and their length.                                                          |
+-----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+


Documentation
+++++++++++++

.. automodule:: pyensae.sql.database_core2
    :members:
    :special-members: __init__
    :show-inheritance: