.. _l-staticmethods:

Static Methods
==============

.. contents::
    :local:
    :depth: 1


Summary
+++++++

+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| staticmethod                                                                                         | class parent            | truncated documentation                                                                                                                           |
+======================================================================================================+=========================+===================================================================================================================================================+
| :meth:`PYTHON_parser <pyensae.filehelper.magic_file.MagicFile.PYTHON_parser>`                        | MagicFile               | Defines the way to parse the magic command ``%%PYTHON``.                                                                                          |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_add_function_parser <pyensae.sql.magic_sql.MagicSQL.SQL_add_function_parser>`             | MagicSQL                | defines the way to parse the magic command ``%SQL_add_function``                                                                                  |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_close_parser <pyensae.sql.magic_sql.MagicSQL.SQL_close_parser>`                           | MagicSQL                | defines the way to parse the magic command ``%SQL_close``                                                                                         |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_connect_parser <pyensae.sql.magic_sql.MagicSQL.SQL_connect_parser>`                       | MagicSQL                | defines the way to parse the magic command ``%SQL_connect``                                                                                       |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_drop_table_parser <pyensae.sql.magic_sql.MagicSQL.SQL_drop_table_parser>`                 | MagicSQL                | defines the way to parse the magic command ``%SQL_drop_table``                                                                                    |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_import_df_parser <pyensae.sql.magic_sql.MagicSQL.SQL_import_df_parser>`                   | MagicSQL                | defines the way to parse the magic command ``%SQL_import_df``                                                                                     |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_import_tsv_parser <pyensae.sql.magic_sql.MagicSQL.SQL_import_tsv_parser>`                 | MagicSQL                | defines the way to parse the magic command ``%SQL_import_tsv``                                                                                    |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_parser <pyensae.sql.magic_sql.MagicSQL.SQL_parser>`                                       | MagicSQL                | defines the way to parse the magic command ``%%SQL``                                                                                              |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_refresh_completion_parser <pyensae.sql.magic_sql.MagicSQL.SQL_refresh_completion_parser>` | MagicSQL                | defines the way to parse the magic command ``%SQL_refresh_completion``                                                                            |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_schema_parser <pyensae.sql.magic_sql.MagicSQL.SQL_schema_parser>`                         | MagicSQL                | defines the way to parse the magic command ``%SQL_schema``                                                                                        |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`SQL_tables_parser <pyensae.sql.magic_sql.MagicSQL.SQL_tables_parser>`                         | MagicSQL                | defines the way to parse the magic command ``%SQL_tables``                                                                                        |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :py:meth:`_filter_name <pyensae.sql.sql_interface.AutoCompletionSQLObject._filter_name>`             | AutoCompletionSQLObject | removes unavailable characters                                                                                                                    |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :py:meth:`_special_function_init_ <pyensae.sql.database_core.DatabaseCore._special_function_init_>`  | DatabaseCore            |                                                                                                                                                   |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :py:meth:`_store <pyensae.sql.file_text_binary_columns.TextFileColumns._store>`                      | TextFileColumns         | Stores a list of dictionaries into a file (add a header).                                                                                         |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`available_dates <pyensae.finance.astock.StockPrices.available_dates>`                         | StockPrices             | Returns the list of values (Open or High or Low or Close or Volume) from each stock for all the available_dates ...                               |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`covariance <pyensae.finance.astock.StockPrices.covariance>`                                   | StockPrices             | Computes the covariances matrix (of returns).                                                                                                     |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`create <pyensae.sql.sql_interface.InterfaceSQL.create>`                                       | InterfaceSQL            |                                                                                                                                                   |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`draw <pyensae.finance.astock.StockPrices.draw>`                                               | StockPrices             | Draws a graph showing one or several time series. The example was taken `date_demo.py <https://matplotlib.org/examples/api/date_demo.html>`_. ... |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`encoding_parser <pyensae.filehelper.magic_file.MagicFile.encoding_parser>`                    | MagicFile               | Defines the way to parse the magic command ``%encoding``.                                                                                         |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`fill_sql_table <pyensae.sql.database_main.Database.fill_sql_table>`                           | Database                | Returns a Database object, creates the database if it does not exists, same for the table.                                                        |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`fusion <pyensae.sql.file_text_binary_columns.TextFileColumns.fusion>`                         | TextFileColumns         | Does a fusion between several files with the same columns (different order is allowed).                                                           |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`getIndentationCount <pyensae.languages.Python3Lexer.Python3Lexer.getIndentationCount>`        | Python3Lexer            |                                                                                                                                                   |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`grep_parser <pyensae.filehelper.magic_file.MagicFile.grep_parser>`                            | MagicFile               | defines the way to parse the magic command ``%grep``                                                                                              |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`head_parser <pyensae.filehelper.magic_file.MagicFile.head_parser>`                            | MagicFile               | defines the way to parse the magic command ``%head``                                                                                              |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`hhelp_parser <pyensae.filehelper.magic_file.MagicFile.hhelp_parser>`                          | MagicFile               | Defines the way to parse the magic command ``%hhelp``.                                                                                            |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`idaytodate <pyensae.sql.database_core.DatabaseCore.idaytodate>`                               | DatabaseCore            | Date conversion. Static method to insert in a SQL query.                                                                                          |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`isectoday <pyensae.sql.database_core.DatabaseCore.isectoday>`                                 | DatabaseCore            | Date conversion. Static method to insert in a SQL query.                                                                                          |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`itimestamp <pyensae.sql.database_core.DatabaseCore.itimestamp>`                               | DatabaseCore            | Date conversion. Static method to insert in a SQL query.                                                                                          |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`jsdf_parser <pyensae.notebookhelper.magic_notebook.MagicNotebook.jsdf_parser>`                | MagicNotebook           | defines the way to parse the magic command ``%jsdf``                                                                                              |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`lsr_parser <pyensae.filehelper.magic_file.MagicFile.lsr_parser>`                              | MagicFile               | defines the way to parse the magic command ``%lsr``                                                                                               |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`lsrepo_parser <pyensae.filehelper.magic_file.MagicFile.lsrepo_parser>`                        | MagicFile               | Defines the way to parse the magic command ``%lsrepo``.                                                                                           |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`mpl_style_parser <pyensae.graphhelper.magic_graph.MagicGraph.mpl_style_parser>`               | MagicGraph              | defines the way to parse the magic command ``%mpl_style``                                                                                         |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`nb_menu_parser <pyensae.notebookhelper.magic_notebook.MagicNotebook.nb_menu_parser>`          | MagicNotebook           | defines the way to parse the magic command ``%nb_menu``                                                                                           |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`regex_match <pyensae.sql.database_core.DatabaseCore.regex_match>`                             | DatabaseCore            | Applies a regular expression. Static method to insert in a SQL query.                                                                             |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`runpy_parser <pyensae.filehelper.magic_file.MagicFile.runpy_parser>`                          | MagicFile               | Defines the way to parse the magic command ``%%runpy``.                                                                                           |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`schema_database <pyensae.sql.database_main.Database.schema_database>`                         | Database                | Returns the schema for a database which would contains this database.                                                                             |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`string_to_date <pyensae.sql.database_core.DatabaseCore.string_to_date>`                       | DatabaseCore            | Date conversion. Static method to insert in a SQL query.                                                                                          |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| :meth:`tail_parser <pyensae.filehelper.magic_file.MagicFile.tail_parser>`                            | MagicFile               | defines the way to parse the magic command ``%tail``                                                                                              |
+------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+