Module Expr Str ImportFrom alias Import alias Import alias Import alias Import alias Import alias Import alias Import alias ImportFrom alias Import alias ImportFrom alias ClassDef bases NameLoad body Expr Str FunctionDef arguments args NameParam defaults body Expr Str Return AttributeLoad NameLoad attr decorator_list NameLoad FunctionDef arguments args NameParam defaults body Expr Str Return AttributeLoad NameLoad attr decorator_list NameLoad FunctionDef arguments args NameParam defaults body Expr Str Return AttributeLoad NameLoad attr decorator_list NameLoad FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults Str NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults body Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str TryExcept body Expr Call AttributeLoad NameLoad attr handlers ExceptHandler type AttributeLoad NameLoad attr body Return NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str If CompareIs AttributeLoad NameLoad attr NameLoad body Raise Call AttributeLoad NameLoad attr Str If Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Raise Call AttributeLoad NameLoad attr Str decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults Str body Expr Str Expr Call AttributeLoad NameLoad attr If CompareEq NameLoad Str body Expr Call AttributeLoad NameLoad attr NameLoad orelse If CompareIn NameLoad ListLoad Str Str body Expr Call AttributeLoad NameLoad attr NameLoad orelse Raise Call NameLoad BinOpAdd Str NameLoad If CompareEq NameLoad AttributeLoad NameLoad attr body Assign AttributeStore NameLoad attr NameLoad orelse Assign AttributeStore NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad If CompareNotEq NameLoad Str body Return For NameStore Call AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults NameLoad body Expr Str Import alias Expr Call AttributeLoad NameLoad attr If Call AttributeLoad NameLoad attr NameLoad body Return NameLoad If AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad NameLoad attr TryExcept body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad handlers ExceptHandler type AttributeLoad NameLoad attr body Assign TupleStore NameStore NameStore NameStore Call AttributeLoad NameLoad attr If CompareIs NameLoad NameLoad body Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr Assign TupleStore NameStore NameStore NameStore SubscriptLoad NameLoad Slice Num Assign NameStore ListLoad BinOpMod Str TupleLoad NameLoad NameLoad NameLoad BinOpMod Str NameLoad BinOpMod Str NameLoad BinOpMod Str AttributeLoad NameLoad attr Raise Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad If AttributeLoad NameLoad attr body Assign SubscriptStore AttributeLoad NameLoad attr Index NameLoad BinOpAdd Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Num Num Assign NameStore BinOpSub Call AttributeLoad NameLoad attr NameLoad Assign SubscriptStore AttributeLoad NameLoad attr Index NameLoad BinOpAdd Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Num NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad Return Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad If Call AttributeLoad NameLoad attr NameLoad body Return Assign NameStore Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad SubscriptLoad NameLoad Index Num keyword NameLoad TryExcept body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad handlers ExceptHandler type AttributeLoad NameLoad attr body Assign TupleStore NameStore NameStore NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr attr Assign TupleStore NameStore NameStore NameStore SubscriptLoad NameLoad Slice Num Raise Call AttributeLoad NameLoad attr BinOpAdd BinOpAdd BinOpAdd BinOpAdd BinOpMod Str TupleLoad NameLoad NameLoad NameLoad BinOpMod Str NameLoad BinOpMod Str Call NameLoad NameLoad BinOpMod Str AttributeLoad NameLoad attr BinOpMod Str SubscriptLoad NameLoad Slice Num decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad body Expr Str Expr Call AttributeLoad NameLoad attr ListLoad Str Str Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad Return Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr Return AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr If CompareIs NameLoad NameLoad body Return NameLoad Assign NameStore Call AttributeLoad NameLoad attr If CompareIs NameLoad NameLoad body Return NameLoad Return SubscriptLoad NameLoad Index Num decorator_list FunctionDef arguments args NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr Assign NameStore Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr If CompareIs NameLoad NameLoad body Return ListLoad Return Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore BinOpMod Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr Return Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore BinOpMod Str TupleLoad Call AttributeLoad Str attr ListComp BinOpMod Str Call AttributeLoad NameLoad attr NameLoad comprehension NameStore NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr Return Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults Num body Expr Str ImportFrom alias Assign NameStore Str Assign NameStore ListComp ListLoad NameLoad NameLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Num comprehension TupleStore NameStore NameStore Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign NameStore TupleLoad Str Str Str Assign NameStore Call AttributeLoad NameLoad attr TryExcept body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad keyword NameLoad handlers ExceptHandler type NameLoad body Return ListLoad TryExcept body Assign NameStore Call AttributeLoad NameLoad attr keyword BinOpMod Str NameLoad keyword NameLoad keyword BinOpMod Str TupleLoad Str Str NameLoad handlers ExceptHandler type AttributeLoad NameLoad attr body Return ListLoad If CompareIs NameLoad NameLoad body Return ListLoad Assign NameStore Call NameLoad Str Call AttributeLoad Str attr NameLoad Return ListComp Call NameLoad NameLoad comprehension NameStore Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr Assign NameStore AttributeLoad AttributeLoad NameLoad attr attr Assign AttributeStore AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Assign NameStore ListLoad Assign NameStore Call AttributeLoad NameLoad attr Str For NameStore Call AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr Call NameLoad ListComp ListLoad NameLoad SubscriptLoad NameLoad Index NameLoad comprehension NameStore Call AttributeLoad NameLoad attr Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str TryExcept body Expr Call AttributeLoad NameLoad attr NameLoad handlers ExceptHandler type NameLoad body Return NameLoad Return CompareIn NameLoad Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad If Call AttributeLoad NameLoad attr NameLoad body Return NameLoad Return CompareIn NameLoad Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str If Call AttributeLoad NameLoad attr NameLoad body Return NameLoad Assign NameStore ListComp NameLoad comprehension NameStore NameLoad UnaryOpNot Call AttributeLoad NameLoad attr NameLoad NameLoad If CompareGt Call NameLoad NameLoad Num body Return NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad If Call AttributeLoad NameLoad attr NameLoad body Return Raise Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad NameLoad AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad If Call AttributeLoad NameLoad attr NameLoad NameLoad body Return Raise Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr ListLoad Str Str If Call AttributeLoad NameLoad attr NameLoad body Assign NameStore BinOpMod Str NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr ListLoad Str Str Assign NameStore Call AttributeLoad NameLoad attr If Call AttributeLoad NameLoad attr NameLoad body Return NameLoad Assign NameStore BinOpMod Str TupleLoad NameLoad Call AttributeLoad Str attr NameLoad If CompareIs Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr NameLoad body Return NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr ListLoad Str Str Assign NameStore BinOpMod Str TupleLoad Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad NameLoad attr NameLoad Assign NameStore BinOpMod Str TupleLoad NameLoad Call AttributeLoad NameLoad attr NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr ListLoad Str Str If Call AttributeLoad NameLoad attr NameLoad body Return For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults TupleLoad body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr ListLoad Str Str If Call AttributeLoad NameLoad attr NameLoad body Raise Call NameLoad BinOpMod Str TupleLoad NameLoad Call AttributeLoad Str attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Assign NameStore Call NameLoad Call AttributeLoad Call NameLoad NameLoad attr Call NameLoad NameLoad Assign NameStore ListLoad For TupleStore NameStore NameStore Call NameLoad Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad body Assign NameStore SubscriptLoad NameLoad Index NameLoad Expr Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults Str ListLoad Str Str Str body Expr Str Import alias Assign NameStore Call AttributeLoad NameLoad attr Call NameLoad NameLoad Str keyword NameLoad keyword NameLoad Assign NameStore ListComp ListComp IfExp UnaryOpNot Call AttributeLoad NameLoad attr NameLoad Call AttributeLoad Call AttributeLoad NameLoad attr NameLoad attr NameLoad Str NameLoad comprehension NameStore NameLoad comprehension NameStore NameLoad If Call AttributeLoad NameLoad attr NameLoad body Assign NameStore SubscriptLoad NameLoad Index Num If Call NameLoad ListComp Call AttributeLoad NameLoad attr NameLoad comprehension NameStore NameLoad body Raise Call NameLoad Str Assign NameStore SubscriptLoad NameLoad Slice Num orelse Assign NameStore NameLoad If Call AttributeLoad NameLoad attr NameLoad body Assign NameStore SubscriptLoad Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Index Num Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str TryExcept body Expr Call AttributeLoad NameLoad attr handlers ExceptHandler type AttributeLoad NameLoad attr body Return Expr Call AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str TryExcept body Expr Call AttributeLoad NameLoad attr handlers ExceptHandler type AttributeLoad NameLoad attr body Return Expr Call AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str TryExcept body Expr Call AttributeLoad NameLoad attr handlers ExceptHandler type AttributeLoad NameLoad attr body Return Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body If Call AttributeLoad NameLoad attr NameLoad body Raise Call NameLoad Str If CompareEq NameLoad AttributeLoad NameLoad attr body Return Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad decorator_list NameLoad FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad If UnaryOpNot Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad body Raise Call NameLoad BinOpAdd Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore ListLoad For NameStore Call NameLoad Call NameLoad NameLoad body If CompareEq Call NameLoad NameLoad Call NameLoad SubscriptLoad NameLoad Index NameLoad body Continue Expr Call AttributeLoad NameLoad attr NameLoad If CompareEq Call NameLoad NameLoad Num body Return Assign NameStore SubscriptLoad NameLoad Index SubscriptLoad NameLoad Index Num Raise Call NameLoad BinOpAdd BinOpAdd BinOpAdd Str BinOpMod Str TupleLoad Call NameLoad NameLoad Call NameLoad NameLoad BinOpMod Str TupleLoad Call NameLoad NameLoad Call NameLoad NameLoad BinOpMod Str TupleLoad SubscriptLoad NameLoad Index Num Call NameLoad NameLoad Call NameLoad NameLoad decorator_list NameLoad FunctionDef arguments args NameParam defaults body Expr Str Return ListComp SubscriptLoad NameLoad Index Num comprehension NameStore NameLoad decorator_list NameLoad FunctionDef arguments args NameParam defaults body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Dict Assign AttributeStore NameLoad attr Dict decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr If Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Raise Call NameLoad Str If CompareNotIn AttributeLoad NameLoad attr NameLoad body Raise Call NameLoad Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore Dict AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad AttributeLoad NameLoad attr attr Str Str Str Assign NameStore Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr Return Call NameLoad ListComp ListLoad NameLoad SubscriptLoad NameLoad Index AttributeLoad NameLoad attr comprehension TupleStore NameStore NameStore Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body If CompareIs NameLoad NameLoad body Return Str Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body TryExcept body Return ListComp Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad comprehension NameStore NameLoad handlers ExceptHandler type NameLoad body Pass TryExcept body Assign NameStore Call AttributeLoad NameLoad attr Return ListComp Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad comprehension NameStore NameLoad handlers ExceptHandler type NameLoad body Pass If Call AttributeLoad NameLoad attr NameLoad body Return NameLoad Raise Call NameLoad Str decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Return ListComp Call AttributeLoad NameLoad attr NameLoad NameLoad comprehension NameStore NameLoad decorator_list decorator_list
N/A N/A 
@author: Tsuyoshi Hombashi
 __future__ absolute_import N/A logging N/A os N/A sqlite3 N/A sys N/A dataproperty N/A pathvalidate N/A six six.moves range N/A simplesqlite sqlquery SqlQuery SimpleSQLite N/A object N/A N/A 
    Wrapper class of |sqlite3| module.

    :param str database_path: File path of the database to be connected.
    :param str mode: Open mode.
    :param bool profile:
        Recording SQL query execution time profile, if the value is |True|.

    .. seealso::

        :py:meth:`.connect`
        :py:meth:`.get_profile`
     database_path N/A N/A self N/A N/A N/A 
        :return: File path of the connected database.
        :rtype: str

        :Examples:

            >>> from simplesqlite import SimpleSQLite
            >>> con = SimpleSQLite("sample.sqlite", "w")
            >>> con.database_path
            '/tmp/sample.sqlite'
            >>> con.close()
            >>> print(con.database_path)
            None
         N/A N/A self __database_path N/A property connection N/A N/A self N/A N/A N/A 
        :return: |Connection| instance of the connected database.
        :rtype: sqlite3.Connection
         N/A N/A self __connection N/A property mode N/A N/A self N/A N/A N/A 
        :return: Connection mode: ``"r"``/``"w"``/``"a"``.
        :rtype: str

        .. seealso:: :py:meth:`.connect`
         N/A N/A self __mode N/A property __init__ N/A N/A self database_path mode is_create_table_config profile N/A a True False N/A N/A N/A N/A self __initialize_connection N/A N/A self __is_profile profile N/A N/A self __is_create_table_config is_create_table_config N/A N/A N/A self connect database_path mode N/A __del__ N/A N/A self N/A N/A N/A N/A N/A self close N/A __exit__ N/A N/A self exc_type exc_value traceback N/A N/A N/A N/A N/A self close N/A is_connected N/A N/A self N/A N/A N/A 
        :return: |True| if the connection to a database is valid.
        :rtype: bool

        :Examples:

            >>> from simplesqlite import SimpleSQLite
            >>> con = SimpleSQLite("sample.sqlite", "w")
            >>> con.is_connected()
            True
            >>> con.close()
            >>> con.is_connected()
            False
         N/A N/A N/A N/A N/A self check_connection N/A N/A N/A N/A simplesqlite NullDatabaseConnectionError N/A N/A False N/A True N/A check_connection N/A N/A self N/A N/A N/A 
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|

        :Examples:

            .. code:: python

                from simplesqlite import SimpleSQLite, NullDatabaseConnectionError
                import six

                con = SimpleSQLite("sample.sqlite", "w")
                six.print_("---- connected to a database ----")
                con.check_connection()
                six.print_("---- disconnected from a database ----")
                con.close()
                try:
                    con.check_connection()
                except NullDatabaseConnectionError as e:
                    six.print_(e)

            .. parsed-literal::

                ---- connected to a database ----
                ---- disconnected from a database ----
                null database connection
         N/A N/A N/A self connection None N/A N/A N/A N/A simplesqlite NullDatabaseConnectionError null database connection N/A N/A N/A dataproperty is_empty_string N/A self database_path N/A N/A N/A N/A simplesqlite NullDatabaseConnectionError null database file path N/A connect N/A N/A self database_path mode N/A a N/A N/A 
        :param str database_path:
            Path to the SQLite database file to be connected.
        :param str mode:
            ``"r"``: Open for read only.
            ``"w"``: Open for read/write.
            Delete existing tables when connecting.
            ``"a"``: Open for read/write. Append to the existing tables.
        :raises ValueError:
            If ``database_path`` is invalid or |attr_mode| is invalid.
        :raises sqlite3.OperationalError: If unable to open the database file.
         N/A N/A N/A self close N/A N/A mode r N/A N/A N/A N/A self __verify_sqlite_db_file database_path N/A N/A N/A mode N/A w a N/A N/A N/A N/A self __validate_db_path database_path N/A N/A N/A ValueError N/A unknown connection mode:  mode N/A N/A database_path N/A simplesqlite MEMORY_DB_NAME N/A N/A N/A self __database_path database_path N/A N/A N/A self __database_path N/A N/A N/A os path realpath database_path N/A N/A self __connection N/A N/A sqlite3 connect database_path N/A N/A self __mode mode N/A N/A mode w N/A N/A N/A table N/A N/A self get_table_name_list N/A N/A N/A N/A self drop_table table N/A execute_query N/A N/A self query caller N/A None N/A N/A 
        Execute arbitrary SQLite query.

        :param str query: Query to be executed.
        :param tuple caller:
            Caller information.
            Expects the return value of :py:meth:`logging.Logger.findCaller`.
        :return: Result of the query execution.
        :rtype: sqlite3.Cursor
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises sqlite3.OperationalError: |raises_operational_error|

        .. warning::

            This method can execute an arbitrary query.
            i.e. No access permissions check by |attr_mode|.
         N/A time N/A N/A N/A self check_connection N/A N/A N/A dataproperty is_empty_string query N/A N/A None N/A N/A self __is_profile N/A N/A exec_start_time N/A N/A time time N/A N/A N/A result N/A N/A N/A self connection execute query N/A N/A N/A N/A sqlite3 OperationalError N/A N/A N/A _ e _ N/A N/A sys exc_info N/A N/A caller None N/A N/A caller N/A N/A N/A N/A logging getLogger findCaller N/A N/A file_path line_no func_name N/A caller N/A 3 N/A message_list N/A N/A failed to execute query at %s(%d) %s N/A file_path line_no func_name N/A   - query: %s query N/A   - msg:   %s e N/A   - db:    %s N/A self database_path N/A N/A N/A sqlite3 OperationalError N/A N/A N/A os linesep join message_list N/A N/A self __is_profile N/A N/A N/A N/A self __dict_query_count N/A query N/A N/A N/A N/A self __dict_query_count get query 0 1 N/A elapse_time N/A N/A N/A time time exec_start_time N/A N/A N/A self __dict_query_totalexectime N/A query N/A N/A N/A N/A self __dict_query_totalexectime get query 0 elapse_time N/A result N/A select N/A N/A self select table_name where extra N/A None None N/A N/A 
        Execute SELECT query.

        :param str select: Attribute for the SELECT query.
        :param str table_name: Table name of executing the query.
        :return: Result of the query execution.
        :rtype: sqlite3.Cursor
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|
        :raises sqlite3.OperationalError: |raises_operational_error|

        .. seealso::

            :py:meth:`.sqlquery.SqlQuery.make_select`
         N/A N/A N/A self verify_table_existence table_name N/A query N/A N/A SqlQuery make_select select table_name where extra N/A N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller N/A insert N/A N/A self table_name insert_record N/A N/A N/A 
        Execute INSERT query.

        :param str table_name: Table name of executing the query.
        :param insert_record: Record to be inserted.
        :type insert_record: |dict|/|namedtuple|/|list|/|tuple|
        :raises IOError: |raises_write_permission|
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises sqlite3.OperationalError: |raises_operational_error|

        .. seealso:: :py:meth:`.sqlquery.SqlQuery.make_insert`
         N/A N/A N/A self validate_access_permission N/A w a N/A N/A N/A self verify_table_existence table_name N/A query N/A N/A SqlQuery make_insert table_name N/A N/A self __to_record N/A N/A self get_attribute_name_list table_name insert_record N/A N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller N/A insert_many N/A N/A self table_name insert_record_list N/A N/A N/A 
        Execute INSERT query for multiple records.

        :param str table: Table name of executing the query.
        :param insert_record: Records to be inserted.
        :type insert_record: |dict|/|namedtuple|/|list|/|tuple|
        :raises IOError: |raises_write_permission|
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|
        :raises sqlite3.OperationalError: |raises_operational_error|

        .. seealso:: :py:meth:`.sqlquery.SqlQuery.make_insert`
         N/A N/A N/A self validate_access_permission N/A w a N/A N/A N/A self verify_table_existence table_name N/A N/A N/A dataproperty is_empty_list_or_tuple insert_record_list N/A N/A N/A record_list N/A N/A self __to_data_matrix N/A N/A self get_attribute_name_list table_name insert_record_list N/A query N/A N/A SqlQuery make_insert table_name N/A record_list N/A 0 is_insert_many True N/A N/A N/A N/A N/A N/A self connection executemany query record_list N/A N/A N/A N/A sqlite3 OperationalError N/A N/A N/A _ e _ N/A N/A sys exc_info N/A caller N/A N/A N/A N/A logging getLogger findCaller N/A N/A file_path line_no func_name N/A caller N/A 3 N/A N/A N/A sqlite3 OperationalError N/A N/A N/A N/A N/A %s(%d) %s: failed to execute query:
 N/A file_path line_no func_name N/A   query=%s
 query N/A   msg='%s'
 N/A str e N/A   db=%s
 N/A self database_path N/A   records=%s
 N/A record_list N/A 2 N/A update N/A N/A self table_name set_query where N/A None N/A N/A 
        Execute UPDATE query.

        :param str table_name: Table name of executing the query.
        :param str set_query:
        :raises IOError: |raises_write_permission|
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|
        :raises sqlite3.OperationalError: |raises_operational_error|

        .. seealso::

            :py:meth:`.sqlquery.SqlQuery.make_update`
         N/A N/A N/A self validate_access_permission N/A w a N/A N/A N/A self verify_table_existence table_name N/A query N/A N/A SqlQuery make_update table_name set_query where N/A N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller N/A get_total_changes N/A N/A self N/A N/A N/A 
        .. seealso::

            :py:attr:`sqlite3.Connection.total_changes`
         N/A N/A N/A self check_connection N/A N/A N/A self connection total_changes N/A get_value N/A N/A self select table_name where extra N/A None None N/A N/A 
        Get a value from the table.

        :param str select: Attribute for SELECT query
        :param str table_name: Table name of executing the query.
        :return: Result of execution of the query.
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises sqlite3.OperationalError: |raises_operational_error|

        .. seealso::

            :py:meth:`.sqlquery.SqlQuery.make_select`
         N/A N/A N/A self verify_table_existence table_name N/A query N/A N/A SqlQuery make_select select table_name where extra N/A result N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller N/A N/A result None N/A N/A None N/A fetch N/A N/A result fetchone N/A N/A fetch None N/A N/A None N/A N/A fetch N/A 0 N/A get_table_name_list N/A N/A self N/A N/A N/A 
        :return: List of table names in the database.
        :rtype: list
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises sqlite3.OperationalError: |raises_operational_error|

        :Examples:

            .. code:: python

                from simplesqlite import SimpleSQLite
                import six

                table_name = "sample_table"
                con = SimpleSQLite("sample.sqlite", "w")
                con.create_table_with_data(
                    table_name="hoge",
                    attribute_name_list=["attr_a", "attr_b"],
                    data_matrix=[[1, "a"], [2, "b"]])
                six.print_(con.get_table_name_list())

            .. parsed-literal::

                [u'hoge']
         N/A N/A N/A self check_connection N/A query SELECT name FROM sqlite_master WHERE TYPE='table' N/A result N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller N/A N/A result None N/A N/A N/A N/A N/A N/A self __get_list_from_fetch N/A N/A result fetchall N/A get_attribute_name_list N/A N/A self table_name N/A N/A N/A 
        :return: List of attribute names in the table.
        :rtype: list
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|
        :raises sqlite3.OperationalError: |raises_operational_error|

        :Examples:

            .. code:: python

                from simplesqlite import SimpleSQLite, TableNotFoundError
                import six

                table_name = "sample_table"
                con = SimpleSQLite("sample.sqlite", "w")
                con.create_table_with_data(
                    table_name=table_name,
                    attribute_name_list=["attr_a", "attr_b"],
                    data_matrix=[[1, "a"], [2, "b"]])

                six.print_(con.get_attribute_name_list(table_name))
                try:
                    six.print_(con.get_attribute_name_list("not_existing"))
                except TableNotFoundError as e:
                    six.print_(e)

            .. parsed-literal::

                ['attr_a', 'attr_b']
                'not_existing' table not found in /tmp/sample.sqlite
         N/A N/A N/A self verify_table_existence table_name N/A query N/A SELECT * FROM '%s' table_name N/A result N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller N/A N/A N/A self __get_list_from_fetch N/A result description N/A get_attribute_type_list N/A N/A self table_name N/A N/A N/A 
        :return: List of attribute names in the table.
        :rtype: list
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|
        :raises sqlite3.OperationalError: |raises_operational_error|
         N/A N/A N/A self verify_table_existence table_name N/A attribute_name_list N/A N/A self get_attribute_name_list table_name N/A query N/A SELECT DISTINCT %s FROM '%s' N/A N/A N/A , join N/A N/A TYPEOF(%s) N/A N/A SqlQuery to_attr_str attribute N/A attribute attribute_name_list table_name N/A result N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller N/A N/A N/A result fetchone N/A get_profile N/A N/A self profile_count N/A 50 N/A N/A 
        Get profile of query execution time.

        :param int profile_count:
            Number of profiles to retrieve,
            counted from the top query in descending order by
            the cumulative execution time.
        :return: Profile information for each query.
        :rtype: list of |namedtuple|
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises sqlite3.OperationalError: |raises_operational_error|
         collections namedtuple N/A TN_SQL_PROFILE sql_profile N/A value_matrix N/A N/A query execute_time N/A N/A N/A self __dict_query_count get query 0 N/A N/A query execute_time N/A N/A six iteritems N/A self __dict_query_totalexectime N/A attribute_name_list N/A query cumulative_time count N/A con_tmp N/A N/A simplesqlite connect_sqlite_db_mem N/A N/A N/A N/A N/A con_tmp create_table_with_data TN_SQL_PROFILE attribute_name_list data_matrix value_matrix N/A N/A N/A ValueError N/A N/A N/A N/A N/A N/A result N/A N/A con_tmp select select N/A %s,SUM(%s),SUM(%s) attribute_name_list table_name TN_SQL_PROFILE extra N/A GROUP BY %s ORDER BY %s DESC LIMIT %d N/A query cumulative_time profile_count N/A N/A N/A N/A sqlite3 OperationalError N/A N/A N/A N/A N/A result None N/A N/A N/A N/A SqliteProfile N/A namedtuple SqliteProfile N/A N/A join attribute_name_list N/A N/A N/A SqliteProfile profile N/A profile N/A N/A result fetchall N/A get_sqlite_master N/A N/A self N/A N/A N/A 
        Get sqlite_master table information as a list of dictionaries.

        :return: sqlite_master table information.
        :rtype: list
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|

        :Examples:

            .. code:: python

                import json
                from simplesqlite import SimpleSQLite

                con = SimpleSQLite("sample.sqlite", "w")
                data_matrix = [
                    [1, 1.1, "aaa", 1,   1],
                    [2, 2.2, "bbb", 2.2, 2.2],
                    [3, 3.3, "ccc", 3,   "ccc"],
                ]
                con.create_table_with_data(
                    table_name="sample_table",
                    attribute_name_list=["a", "b", "c", "d", "e"],
                    data_matrix=data_matrix,
                    index_attribute_list=["a"])
                print(json.dumps(con.get_sqlite_master(), indent=4))

            .. parsed-literal::

                [
                    {
                        "tbl_name": "sample_table",
                        "sql": "CREATE TABLE 'sample_table' ('a' INTEGER, 'b' REAL, 'c' TEXT, 'd' REAL, 'e' TEXT)",
                        "type": "table",
                        "name": "sample_table",
                        "rootpage": 2
                    },
                    {
                        "tbl_name": "sample_table",
                        "sql": "CREATE INDEX sample_table_a_index ON sample_table('a')",
                        "type": "index",
                        "name": "sample_table_a_index",
                        "rootpage": 3
                    }
                ]
         N/A N/A N/A self check_connection N/A old_row_factory N/A N/A self connection row_factory N/A N/A N/A self connection row_factory N/A sqlite3 Row N/A sqlite_master_list N/A N/A result N/A N/A self execute_query select * from sqlite_master N/A item N/A N/A result fetchall N/A N/A N/A N/A sqlite_master_list append N/A dict N/A N/A key N/A item N/A key N/A key N/A N/A item keys N/A N/A N/A self connection row_factory old_row_factory N/A sqlite_master_list N/A has_table N/A N/A self table_name N/A N/A N/A 
        :param str table_name: Table name to be tested.
        :return: |True| if the database has the table.
        :rtype: bool

        :Examples:

            .. code:: python

                from simplesqlite import SimpleSQLite
                import six

                con = SimpleSQLite("sample.sqlite", "w")
                con.create_table_with_data(
                    table_name="hoge",
                    attribute_name_list=["attr_a", "attr_b"],
                    data_matrix=[[1, "a"], [2, "b"]])
                six.print_(con.has_table("hoge"))
                six.print_(con.has_table("not_existing"))

            .. parsed-literal::

                True
                False
         N/A N/A N/A N/A N/A simplesqlite validate_table_name table_name N/A N/A N/A ValueError N/A N/A False N/A N/A table_name N/A N/A self get_table_name_list N/A has_attribute N/A N/A self table_name attribute_name N/A N/A N/A 
        :param str table_name: Table name that exists attribute.
        :param str attribute_name: Attribute name to be tested.
        :return: |True| if the table has the attribute.
        :rtype: bool
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|

        :Examples:

            .. code:: python

                from simplesqlite import SimpleSQLite, TableNotFoundError
                import six

                table_name = "sample_table"
                con = SimpleSQLite("sample.sqlite", "w")
                con.create_table_with_data(
                    table_name=table_name,
                    attribute_name_list=["attr_a", "attr_b"],
                    data_matrix=[[1, "a"], [2, "b"]])

                six.print_(con.has_attribute(table_name, "attr_a"))
                six.print_(con.has_attribute(table_name, "not_existing"))
                try:
                    six.print_(con.has_attribute("not_existing", "attr_a"))
                except TableNotFoundError as e:
                    six.print_(e)

            .. parsed-literal::

                True
                False
                'not_existing' table not found in /tmp/sample.sqlite
         N/A N/A N/A self verify_table_existence table_name N/A N/A N/A dataproperty is_empty_string attribute_name N/A N/A False N/A N/A attribute_name N/A N/A self get_attribute_name_list table_name N/A has_attribute_list N/A N/A self table_name attribute_name_list N/A N/A N/A 
        :param str table_name: Table name that exists attribute.
        :param str attribute_name_list: Attribute names to be tested.
        :return: |True| if the table has all of the attribute.
        :rtype: bool
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|

        :Examples:

            .. code:: python

                from simplesqlite import SimpleSQLite, TableNotFoundError
                import six

                table_name = "sample_table"
                con = SimpleSQLite("sample.sqlite", "w")
                con.create_table_with_data(
                    table_name=table_name,
                    attribute_name_list=["attr_a", "attr_b"],
                    data_matrix=[[1, "a"], [2, "b"]])

                six.print_(con.has_attribute_list(table_name, ["attr_a"]))
                six.print_(con.has_attribute_list(
                    table_name, ["attr_a", "attr_b"]))
                six.print_(con.has_attribute_list(
                    table_name, ["attr_a", "attr_b", "not_existing"]))
                try:
                    six.print_(con.has_attribute("not_existing", ["attr_a"]))
                except TableNotFoundError as e:
                    six.print_(e)

            .. parsed-literal::

                True
                True
                False
                'not_existing' table not found in /tmp/sample.sqlite
         N/A N/A N/A dataproperty is_empty_list_or_tuple attribute_name_list N/A N/A False N/A not_exist_field_list N/A attribute_name N/A attribute_name attribute_name_list N/A N/A N/A self has_attribute table_name attribute_name N/A N/A N/A len not_exist_field_list 0 N/A N/A False N/A True N/A verify_table_existence N/A N/A self table_name N/A N/A N/A 
        :param str table_name: Table name to be tested.
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|
        :raises ValueError: |raises_validate_table_name|

        :Examples:

            .. code:: python

                from simplesqlite import SimpleSQLite, TableNotFoundError
                import six

                table_name = "sample_table"
                con = SimpleSQLite("sample.sqlite", "w")
                con.create_table_with_data(
                    table_name=table_name,
                    attribute_name_list=["attr_a", "attr_b"],
                    data_matrix=[[1, "a"], [2, "b"]])

                con.verify_table_existence(table_name)
                try:
                    con.verify_table_existence("not_existing")
                except TableNotFoundError as e:
                    six.print_(e)

            .. parsed-literal::

                'not_existing' table not found in /tmp/sample.sqlite
         N/A N/A N/A simplesqlite validate_table_name table_name N/A N/A N/A self has_table table_name N/A N/A N/A N/A N/A simplesqlite TableNotFoundError N/A '%s' table not found in %s N/A table_name N/A self database_path N/A verify_attribute_existence N/A N/A self table_name attribute_name N/A N/A N/A 
        :param str table_name: Table name that exists attribute.
        :param str attribute_name: Attribute name to be tested.
        :raises simplesqlite.AttributeNotFoundError:
            If attribute not found in the table
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|

        :Examples:

            .. code:: python

                from simplesqlite import SimpleSQLite, TableNotFoundError, AttributeNotFoundError
                import six

                table_name = "sample_table"
                con = SimpleSQLite("sample.sqlite", "w")
                con.create_table_with_data(
                    table_name=table_name,
                    attribute_name_list=["attr_a", "attr_b"],
                    data_matrix=[[1, "a"], [2, "b"]])

                con.verify_attribute_existence(table_name, "attr_a")
                try:
                    con.verify_attribute_existence(table_name, "not_existing")
                except AttributeNotFoundError as e:
                    six.print_(e)
                try:
                    con.verify_attribute_existence("not_existing", "attr_a")
                except TableNotFoundError as e:
                    six.print_(e)

            .. parsed-literal::

                'not_existing' attribute not found in 'sample_table' table
                'not_existing' table not found in /tmp/sample.sqlite
         N/A N/A N/A self verify_table_existence table_name N/A N/A N/A self has_attribute table_name attribute_name N/A N/A N/A N/A N/A simplesqlite AttributeNotFoundError N/A '%s' attribute not found in '%s' table N/A attribute_name table_name N/A drop_table N/A N/A self table_name N/A N/A N/A 
        :param str table_name: Table name to drop.
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises IOError: |raises_write_permission|
         N/A N/A N/A self validate_access_permission N/A w a N/A N/A N/A self has_table table_name N/A N/A query N/A DROP TABLE IF EXISTS '%s' table_name N/A N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller N/A N/A N/A self commit N/A create_table N/A N/A self table_name attribute_description_list N/A N/A N/A 
        :param str table_name: Table name to create.
        :param list attribute_description_list: List of table description.
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises IOError: |raises_write_permission|
         N/A N/A N/A self validate_access_permission N/A w a N/A table_name N/A N/A table_name strip N/A N/A N/A self has_table table_name N/A N/A True N/A query N/A CREATE TABLE IF NOT EXISTS '%s' (%s) N/A table_name N/A N/A ,  join attribute_description_list N/A N/A N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller None N/A N/A False N/A True N/A create_index N/A N/A self table_name attribute_name N/A N/A N/A 
        :param str table_name:
            Table name that contains the attribute to be indexed.
        :param str attribute_name: Attribute name to create index.
        :raises IOError: |raises_write_permission|
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
        :raises simplesqlite.TableNotFoundError:
            |raises_verify_table_existence|
         N/A N/A N/A self verify_table_existence table_name N/A N/A N/A self validate_access_permission N/A w a N/A index_name N/A %s_%s_index N/A N/A N/A SqlQuery sanitize table_name N/A N/A SqlQuery sanitize attribute_name N/A query N/A CREATE INDEX IF NOT EXISTS %s ON %s('%s') N/A index_name N/A N/A SqlQuery to_table_str table_name attribute_name N/A N/A N/A self execute_query query N/A N/A N/A N/A logging getLogger findCaller N/A create_index_list N/A N/A self table_name attribute_name_list N/A N/A N/A 
        :param str table_name: Table name that exists attribute.
        :param list attribute_name_list:
            List of attribute names to create indices.

        .. seealso:: :py:meth:`.create_index`
         N/A N/A N/A self validate_access_permission N/A w a N/A N/A N/A dataproperty is_empty_list_or_tuple attribute_name_list N/A N/A N/A attribute attribute_name_list N/A N/A N/A N/A self create_index table_name attribute N/A create_table_with_data N/A N/A self table_name attribute_name_list data_matrix index_attribute_list N/A N/A N/A N/A 
        Create a table if not exists. And insert data into the created table.

        :param str table_name: Table name to create.
        :param list attribute_name_list: List of attribute names of the table.
        :param data_matrix: Data to be inserted into the table.
        :type data_matrix: List of |dict|/|namedtuple|/|list|/|tuple|
        :param tuple index_attribute_list:
            List of attribute names of create indices.
        :raises ValueError: If the ``data_matrix`` is empty.

        .. seealso::

            :py:meth:`.create_table`
            :py:meth:`.insert_many`
            :py:meth:`.create_index_list`
         N/A N/A N/A simplesqlite validate_table_name table_name N/A N/A N/A self validate_access_permission N/A w a N/A N/A N/A dataproperty is_empty_list_or_tuple data_matrix N/A N/A N/A ValueError N/A input data is null: '%s (%s)' N/A table_name N/A N/A ,  join attribute_name_list N/A data_matrix N/A N/A self __to_data_matrix attribute_name_list data_matrix N/A N/A N/A self __verify_value_matrix attribute_name_list data_matrix N/A strip_index_attribute_list N/A list N/A N/A N/A set attribute_name_list intersection N/A set index_attribute_list N/A attr_description_list N/A N/A N/A col value_type N/A sorted N/A N/A six iteritems N/A N/A self __get_column_valuetype data_matrix N/A N/A attr_name N/A attribute_name_list N/A col N/A N/A N/A attr_description_list append N/A '%s' %s N/A attr_name value_type N/A N/A N/A self create_table table_name attr_description_list N/A N/A N/A self insert_many table_name data_matrix N/A N/A N/A self create_index_list table_name strip_index_attribute_list N/A N/A N/A self commit N/A create_table_from_csv N/A N/A self csv_path table_name attribute_name_list delimiter quotechar encoding N/A N/A , " utf-8 N/A N/A 
        Create a table from a csv file.

        :param str csv_path: Path to the csv file.
        :param str table_name:
            Table name to create.
            Use csv file basename as the table name if the value is empty.
        :param list attribute_name_list:
            Attribute names of the table.
            Use the first line of the csv file as attribute list
            if attribute_name_list is empty.
        :param str delimiter:
            A one-character string used to separate fields.
        :param str quotechar:
            A one-character string used to quote fields
            containing special characters, such as the delimiter or quotechar,
            or which contain new-line characters.
        :param str encoding: csv file encoding.
        :raises ValueError: If the csv data is invalid.

        .. seealso::

            :py:meth:`.create_table_with_data`
            :py:func:`csv.reader`
         N/A csv N/A csv_reader N/A N/A csv reader N/A open csv_path r delimiter delimiter quotechar quotechar N/A data_matrix N/A N/A N/A N/A N/A N/A dataproperty is_float data N/A N/A N/A N/A six b data decode encoding ignore data N/A data row N/A row csv_reader N/A N/A N/A dataproperty is_empty_list_or_tuple attribute_name_list N/A N/A header_list N/A data_matrix N/A 0 N/A N/A any N/A N/A N/A dataproperty is_empty_string header N/A header header_list N/A N/A N/A ValueError the first line include empty string: the first line expected to contain header data. N/A data_matrix N/A data_matrix N/A 1 N/A N/A header_list attribute_name_list N/A N/A N/A dataproperty is_empty_string table_name N/A N/A table_name N/A N/A N/A N/A os path splitext N/A N/A N/A os path basename csv_path N/A 0 N/A N/A N/A self create_table_with_data table_name header_list data_matrix N/A rollback N/A N/A self N/A N/A N/A 
        .. seealso:: :py:meth:`sqlite3.Connection.rollback`
         N/A N/A N/A N/A N/A self check_connection N/A N/A N/A N/A simplesqlite NullDatabaseConnectionError N/A N/A N/A N/A N/A N/A self connection rollback N/A commit N/A N/A self N/A N/A N/A 
        .. seealso:: :py:meth:`sqlite3.Connection.commit`
         N/A N/A N/A N/A N/A self check_connection N/A N/A N/A N/A simplesqlite NullDatabaseConnectionError N/A N/A N/A N/A N/A N/A self connection commit N/A close N/A N/A self N/A N/A N/A 
        Commit and close the connection.

        .. seealso:: :py:meth:`sqlite3.Connection.close`
         N/A N/A N/A N/A N/A self check_connection N/A N/A N/A N/A simplesqlite NullDatabaseConnectionError N/A N/A N/A N/A N/A self commit N/A N/A N/A N/A self connection close N/A N/A N/A self __initialize_connection N/A __validate_db_path N/A N/A database_path N/A N/A N/A N/A N/A dataproperty is_empty_string database_path N/A N/A N/A ValueError null path N/A N/A database_path N/A simplesqlite MEMORY_DB_NAME N/A N/A N/A N/A N/A pathvalidate validate_filename N/A N/A N/A os path basename database_path N/A staticmethod __verify_sqlite_db_file N/A N/A self database_path N/A N/A N/A 
        :raises sqlite3.OperationalError: If unable to open database file.
         N/A N/A N/A self __validate_db_path database_path N/A N/A N/A N/A N/A os path isfile N/A N/A N/A os path realpath database_path N/A N/A N/A IOError N/A file not found:  database_path N/A connection N/A N/A sqlite3 connect database_path N/A N/A N/A connection close N/A __verify_value_matrix N/A N/A field_list value_matrix N/A N/A N/A 
        :param list/tuple field_list:
        :param list/tuple value_matrix: the list to test.
        :raises ValueError:
         N/A miss_match_idx_list N/A N/A list_idx N/A range N/A len value_matrix N/A N/A N/A N/A len field_list N/A len N/A value_matrix N/A list_idx N/A N/A N/A N/A N/A miss_match_idx_list append list_idx N/A N/A N/A len miss_match_idx_list 0 N/A N/A N/A sample_miss_match_list N/A value_matrix N/A N/A miss_match_idx_list N/A 0 N/A N/A ValueError N/A N/A N/A miss match header length and value length: N/A   header: %d %s
 N/A N/A len field_list N/A str field_list N/A   # of miss match line: %d ouf of %d
 N/A N/A len miss_match_idx_list N/A len value_matrix N/A   e.g. value at line=%d, len=%d: %s
 N/A N/A miss_match_idx_list N/A 0 N/A len sample_miss_match_list N/A str sample_miss_match_list N/A staticmethod __get_list_from_fetch N/A N/A result N/A N/A N/A 
        :params tuple result: Return value from a Cursor.fetchall()
        :rtype: list
         N/A N/A N/A record N/A 0 N/A record result N/A staticmethod __initialize_connection N/A N/A self N/A N/A N/A N/A self __database_path None N/A N/A self __connection None N/A N/A self __cursur None N/A N/A self __mode None N/A N/A self __dict_query_count N/A N/A N/A self __dict_query_totalexectime N/A N/A validate_access_permission N/A N/A self valid_permission_list N/A N/A N/A 
        :param valid_permission_list:
            List of permissions that access is allowed.
        :type valid_permission_list: |list|/|tuple|
        :raises ValueError: If the |attr_mode| is invalid.
        :raises IOError:
            If the |attr_mode| not in the ``valid_permission_list``.
        :raises simplesqlite.NullDatabaseConnectionError:
            |raises_check_connection|
         N/A N/A N/A self check_connection N/A N/A N/A dataproperty is_empty_string N/A self mode N/A N/A N/A ValueError mode is not set N/A N/A N/A self mode valid_permission_list N/A N/A N/A IOError N/A str valid_permission_list N/A __get_column_valuetype N/A N/A self data_matrix N/A N/A N/A 
        Get value type for each column.

        :param list/tuple data_matrix:
        :return: { column_number : value_type }
        :rtype: dictionary
         N/A TYPENAME_TABLE N/A N/A N/A dataproperty Typecode INT N/A N/A dataproperty Typecode FLOAT N/A N/A dataproperty Typecode STRING INTEGER REAL TEXT N/A prop_extractor N/A N/A dataproperty PropertyExtractor N/A N/A prop_extractor data_matrix data_matrix N/A col_prop_list N/A N/A prop_extractor extract_column_property_list N/A N/A dict N/A N/A col N/A TYPENAME_TABLE N/A N/A col_prop typecode N/A N/A col col_prop N/A enumerate col_prop_list N/A __convert_none N/A N/A self value N/A N/A N/A N/A value None N/A N/A NULL N/A value N/A __to_record N/A N/A self attr_name_list value N/A N/A N/A N/A N/A N/A N/A N/A self __convert_none N/A N/A value get attr_name N/A attr_name attr_name_list N/A N/A N/A AttributeError N/A N/A N/A N/A N/A dict_value N/A N/A value _asdict N/A N/A N/A N/A self __convert_none N/A N/A dict_value get attr_name N/A attr_name attr_name_list N/A N/A N/A AttributeError N/A N/A N/A N/A N/A dataproperty is_list_or_tuple value N/A N/A value N/A N/A ValueError cannot convert to list N/A __to_data_matrix N/A N/A self attr_name_list data_matrix N/A N/A N/A N/A N/A N/A self __to_record attr_name_list record N/A record data_matrix N/A N/A