tribler.core.database.store
===========================
.. py:module:: tribler.core.database.store
Attributes
----------
.. autoapisummary::
tribler.core.database.store.BETA_DB_VERSIONS
tribler.core.database.store.CURRENT_DB_VERSION
tribler.core.database.store.MIN_BATCH_SIZE
tribler.core.database.store.MAX_BATCH_SIZE
tribler.core.database.store.POPULAR_TORRENTS_FRESHNESS_PERIOD
tribler.core.database.store.POPULAR_TORRENTS_COUNT
tribler.core.database.store.sql_create_fts_table
tribler.core.database.store.sql_add_fts_trigger_insert
tribler.core.database.store.sql_add_fts_trigger_delete
tribler.core.database.store.sql_add_fts_trigger_update
tribler.core.database.store.sql_add_torrentstate_trigger_after_insert
tribler.core.database.store.sql_add_torrentstate_trigger_after_update
tribler.core.database.store.sql_create_partial_index_torrentstate_last_check
Classes
-------
.. autoapisummary::
tribler.core.database.store.ObjState
tribler.core.database.store.ProcessingResult
tribler.core.database.store.MetadataStore
Module Contents
---------------
.. py:class:: ObjState(*args, **kwds)
Bases: :py:obj:`enum.Enum`
Different states of information in the store.
.. py:attribute:: UPDATED_LOCAL_VERSION
.. py:attribute:: LOCAL_VERSION_NEWER
.. py:attribute:: LOCAL_VERSION_SAME
.. py:attribute:: NEW_OBJECT
.. py:attribute:: DUPLICATE_OBJECT
.. py:class:: ProcessingResult
This class is used to return results of processing of a payload by process_payload.
It includes a dictionary of the metadata (data), the database rowid, and the
state of the object as indicated by the ObjState enum.
.. py:attribute:: data
:type: dict[str, Any]
.. py:attribute:: obj_state
:type: ObjState
.. py:attribute:: rowid
:type: list[int]
.. py:data:: BETA_DB_VERSIONS
:value: [0, 1, 2, 3, 4, 5]
.. py:data:: CURRENT_DB_VERSION
:value: 15
.. py:data:: MIN_BATCH_SIZE
:value: 10
.. py:data:: MAX_BATCH_SIZE
:value: 1000
.. py:data:: POPULAR_TORRENTS_FRESHNESS_PERIOD
:value: 86400
.. py:data:: POPULAR_TORRENTS_COUNT
:value: 100
.. py:data:: sql_create_fts_table
:value: Multiline-String
.. raw:: html
Show Value
.. code-block:: python
"""
CREATE VIRTUAL TABLE IF NOT EXISTS FtsIndex USING FTS5
(title, content='ChannelNode', prefix = '2 3 4 5',
tokenize='porter unicode61 remove_diacritics 1');"""
.. raw:: html
Show Value
.. code-block:: python
"""
CREATE TRIGGER IF NOT EXISTS fts_ai AFTER INSERT ON ChannelNode
BEGIN
INSERT INTO FtsIndex(rowid, title) VALUES (new.rowid, new.title);
END;"""
.. raw:: html
Show Value
.. code-block:: python
"""
CREATE TRIGGER IF NOT EXISTS fts_ad AFTER DELETE ON ChannelNode
BEGIN
DELETE FROM FtsIndex WHERE rowid = old.rowid;
END;"""
.. raw:: html
Show Value
.. code-block:: python
"""
CREATE TRIGGER IF NOT EXISTS fts_au AFTER UPDATE ON ChannelNode BEGIN
DELETE FROM FtsIndex WHERE rowid = old.rowid;
INSERT INTO FtsIndex(rowid, title) VALUES (new.rowid, new.title);
END;"""
.. raw:: html
Show Value
.. code-block:: python
"""
CREATE TRIGGER IF NOT EXISTS torrentstate_ai AFTER INSERT ON TorrentState
BEGIN
UPDATE "TorrentState" SET has_data = (last_check > 0) WHERE rowid = new.rowid;
END;
"""
.. raw:: html
Show Value
.. code-block:: python
"""
CREATE TRIGGER IF NOT EXISTS torrentstate_au AFTER UPDATE ON TorrentState
BEGIN
UPDATE "TorrentState" SET has_data = (last_check > 0) WHERE rowid = new.rowid;
END;
"""
.. raw:: html
Show Value
.. code-block:: python
"""
CREATE INDEX IF NOT EXISTS idx_torrentstate__last_check__partial
ON TorrentState (last_check, seeders, leechers, self_checked)
WHERE has_data = 1;
"""
.. raw:: html