.. _SQLiteDBLoader:

SQLiteDBLoader
==============

**class SQLiteDBLoader(settings: Optional[dict] = None)**

Bases: :ref:`MetaDatabaseLoader`

Subclass of MetaDatabaseLoader for reading and querying SQLite database files.

Provides functionality to load metadata, event data, and other relevant
structures from a structured SQLite database generated by Poriscope.

Public Methods
--------------

.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.add_columns_to_table
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.alter_database
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.close_resources
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_channels_by_experiment
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_column_names_by_table
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_column_units
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_empty_settings
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_event_counts_by_experiment_and_channel
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_experiment_names
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_llm_prompt
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_samplerate_by_experiment_and_channel
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_table_by_column
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.get_table_names
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.reset_channel
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader.validate_filter_query

Private Methods
---------------

.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader._finalize_initialization
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader._get_sqlite_type
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader._init
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader._load_event_data
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader._load_metadata
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader._load_metadata_generator
.. automethod:: poriscope.plugins.db_loaders.SQLiteDBLoader.SQLiteDBLoader._validate_settings