NTab仓库
fjmwkj
/
searxng
mirror of https://github.com/searxng/searxng
1
0
Fork 0
Files Issues 0 Wiki
Tree: c12baa5772
Branches Tags
searxng
/
src
/
searx.sqlitedb.html

searx.sqlitedb.html 43 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392 
  1. <!DOCTYPE html>
    2. 

  2. 

  3. <html lang="en" data-content_root="../">
    4. 

  4.   <head>
    5. 

  5.     <meta charset="utf-8" />
    6. 

  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    7. 

  7.   <meta name="viewport" content="width=device-width, initial-scale=1">
    8. 

  8.     <title>SQLite DB &#8212; SearXNG Documentation (2025.5.31+93751b637)</title>
    9. 

  9.     <link rel="stylesheet" type="text/css" href="../_static/pygments.css?v=6625fa76" />
    10. 

  10.     <link rel="stylesheet" type="text/css" href="../_static/searxng.css?v=52e4ff28" />
    11. 

  11.     <script src="../_static/documentation_options.js?v=275a1f99"></script>
    12. 

  12.     <script src="../_static/doctools.js?v=9a2dae69"></script>
    13. 

  13.     <script src="../_static/sphinx_highlight.js?v=dc90522c"></script>
    14. 

  14.     <script data-project="searxng" data-version="2025.5.31+93751b637" src="../_static/describe_version.js?v=fa7f30d0"></script>
    15. 

  15.     <link rel="index" title="Index" href="../genindex.html" />
    16. 

  16.     <link rel="search" title="Search" href="../search.html" />
    17. 

  17.     <link rel="next" title="Utility functions for the engines" href="searx.utils.html" />
    18. 

  18.     <link rel="prev" title="Settings Loader" href="searx.settings.html" /> 
    19. 

  19.   </head><body>
    20. 

  20.     <div class="related" role="navigation" aria-label="Related">
    21. 

  21.       <h3>Navigation</h3>
    22. 

  22.       <ul>
    23. 

  23.         <li class="right" style="margin-right: 10px">
    24. 

  24.           <a href="../genindex.html" title="General Index"
    25. 

  25.              accesskey="I">index</a></li>
    26. 

  26.         <li class="right" >
    27. 

  27.           <a href="../py-modindex.html" title="Python Module Index"
    28. 

  28.              >modules</a> |</li>
    29. 

  29.         <li class="right" >
    30. 

  30.           <a href="searx.utils.html" title="Utility functions for the engines"
    31. 

  31.              accesskey="N">next</a> |</li>
    32. 

  32.         <li class="right" >
    33. 

  33.           <a href="searx.settings.html" title="Settings Loader"
    34. 

  34.              accesskey="P">previous</a> |</li>
    35. 

  35.         <li class="nav-item nav-item-0"><a href="../index.html">SearXNG Documentation (2025.5.31+93751b637)</a> &#187;</li>
    36. 

  36.           <li class="nav-item nav-item-1"><a href="index.html" accesskey="U">Source-Code</a> &#187;</li>
    37. 

  37.         <li class="nav-item nav-item-this"><a href="">SQLite DB</a></li> 
    38. 

  38.       </ul>
    39. 

  39.     </div>  
    40. 

  40. 

  41.     <div class="document">
    42. 

  42.       <div class="documentwrapper">
    43. 

  43.         <div class="bodywrapper">
    44. 

  44.           <div class="body" role="main">
    45. 

  45.             
    46. 

  46.   <section id="sqlite-db">
    47. 

  47. <span id="id1"></span><h1>SQLite DB<a class="headerlink" href="#sqlite-db" title="Link to this heading">¶</a></h1>
    48. 

  48. <p id="module-searx.sqlitedb">Implementations to make access to SQLite databases a little more convenient.</p>
    49. 

  49. <dl class="simple">
    50. 

  50. <dt><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl" title="searx.sqlitedb.SQLiteAppl"><code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLiteAppl</span></code></a></dt><dd><p>Abstract class with which DB applications can be implemented.</p>
    51. 

  51. </dd>
    52. 

  52. <dt><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties" title="searx.sqlitedb.SQLiteProperties"><code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLiteProperties</span></code></a>:</dt><dd><p>Class to manage properties stored in a database.</p>
    53. 

  53. </dd>
    54. 

  54. </dl>
    55. 

  55. <p>Examplarical implementations based on <a class="reference internal" href="#searx.sqlitedb.SQLiteAppl" title="searx.sqlitedb.SQLiteAppl"><code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLiteAppl</span></code></a>:</p>
    56. 

  56. <dl class="simple">
    57. 

  57. <dt><a class="reference internal" href="searx.cache.html#searx.cache.ExpireCacheSQLite" title="searx.cache.ExpireCacheSQLite"><code class="xref py py-obj docutils literal notranslate"><span class="pre">searx.cache.ExpireCacheSQLite</span></code></a> :</dt><dd><p>Cache that manages key/value pairs in a SQLite DB, in which the key/value
    58. 

  58. pairs are deleted after an “expire” time.  This type of cache is used, for
    59. 

  59. example, for the engines, see <a class="reference internal" href="../dev/engines/enginelib.html#searx.enginelib.EngineCache" title="searx.enginelib.EngineCache"><code class="xref py py-obj docutils literal notranslate"><span class="pre">searx.enginelib.EngineCache</span></code></a>.</p>
    60. 

  60. </dd>
    61. 

  61. <dt><a class="reference internal" href="searx.favicons.html#searx.favicons.cache.FaviconCacheSQLite" title="searx.favicons.cache.FaviconCacheSQLite"><code class="xref py py-obj docutils literal notranslate"><span class="pre">searx.favicons.cache.FaviconCacheSQLite</span></code></a> :</dt><dd><p>Favicon cache that manages the favicon BLOBs in a SQLite DB.</p>
    62. 

  62. </dd>
    63. 

  63. </dl>
    64. 

  64. <hr class="docutils" />
    65. 

  65. <dl class="py class">
    66. 

  66. <dt class="sig sig-object py" id="searx.sqlitedb.DBSession">
    67. 

  67. <em class="property"><span class="pre">class</span><span class="w"> </span></em><span class="sig-prename descclassname"><span class="pre">searx.sqlitedb.</span></span><span class="sig-name descname"><span class="pre">DBSession</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">app</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl" title="searx.sqlitedb.SQLiteAppl"><span class="pre">SQLiteAppl</span></a></span></em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/searx/sqlitedb.html#DBSession"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.DBSession" title="Link to this definition">¶</a></dt>
    68. 

  68. <dd><p>A <em>thead-local</em> DB session</p>
    69. 

  69. <dl class="py method">
    70. 

  70. <dt class="sig sig-object py" id="searx.sqlitedb.DBSession.get_connect">
    71. 

  71. <em class="property"><span class="pre">classmethod</span><span class="w"> </span></em><span class="sig-name descname"><span class="pre">get_connect</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">app</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl" title="searx.sqlitedb.SQLiteAppl"><span class="pre">SQLiteAppl</span></a></span></em><span class="sig-paren">)</span> <span class="sig-return"><span class="sig-return-icon">&#x2192;</span> <span class="sig-return-typehint"><a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection" title="(in Python v3.13)"><span class="pre">Connection</span></a></span></span><a class="reference internal" href="../_modules/searx/sqlitedb.html#DBSession.get_connect"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.DBSession.get_connect" title="Link to this definition">¶</a></dt>
    72. 

  72. <dd><p>Returns a thread local DB connection.  The connection is only
    73. 

  73. established once per thread.</p>
    74. 

  74. </dd></dl>
    75. 

  75. 

  76. </dd></dl>
    77. 

  77. 

  78. <dl class="py class">
    79. 

  79. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteAppl">
    80. 

  80. <em class="property"><span class="pre">class</span><span class="w"> </span></em><span class="sig-prename descclassname"><span class="pre">searx.sqlitedb.</span></span><span class="sig-name descname"><span class="pre">SQLiteAppl</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">db_url</span></span></em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteAppl"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteAppl" title="Link to this definition">¶</a></dt>
    81. 

  81. <dd><p>Abstract base class for implementing convenient DB access in SQLite
    82. 

  82. applications.  In the constructor, a <a class="reference internal" href="#searx.sqlitedb.SQLiteProperties" title="searx.sqlitedb.SQLiteProperties"><code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLiteProperties</span></code></a> instance is
    83. 

  83. already aggregated under <code class="docutils literal notranslate"><span class="pre">self.properties</span></code>.</p>
    84. 

  84. <dl class="py attribute">
    85. 

  85. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteAppl.DB_SCHEMA">
    86. 

  86. <span class="sig-name descname"><span class="pre">DB_SCHEMA</span></span><em class="property"><span class="p"><span class="pre">:</span></span><span class="w"> </span><a class="reference external" href="https://docs.python.org/3/library/functions.html#int" title="(in Python v3.13)"><span class="pre">int</span></a></em><em class="property"><span class="w"> </span><span class="p"><span class="pre">=</span></span><span class="w"> </span><span class="pre">1</span></em><a class="headerlink" href="#searx.sqlitedb.SQLiteAppl.DB_SCHEMA" title="Link to this definition">¶</a></dt>
    87. 

  87. <dd><p>As soon as changes are made to the DB schema, the version number must be
    88. 

  88. increased.  Changes to the version number require the DB to be recreated (or
    89. 

  89. migrated / if an migration path exists and is implemented).</p>
    90. 

  90. </dd></dl>
    91. 

  91. 

  92. <dl class="py attribute">
    93. 

  93. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteAppl.SQLITE_THREADING_MODE">
    94. 

  94. <span class="sig-name descname"><span class="pre">SQLITE_THREADING_MODE</span></span><em class="property"><span class="w"> </span><span class="p"><span class="pre">=</span></span><span class="w"> </span><span class="pre">'serialized'</span></em><a class="headerlink" href="#searx.sqlitedb.SQLiteAppl.SQLITE_THREADING_MODE" title="Link to this definition">¶</a></dt>
    95. 

  95. <dd><p>Threading mode of the SQLite library.  Depends on the options used at
    96. 

  96. compile time and is different for different distributions and architectures.</p>
    97. 

  97. <p>Possible values are 0:<code class="docutils literal notranslate"><span class="pre">single-thread</span></code>, 1:<code class="docutils literal notranslate"><span class="pre">multi-thread</span></code>,
    98. 

  98. 3:<code class="docutils literal notranslate"><span class="pre">serialized</span></code> (see <a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3.threadsafety" title="(in Python v3.13)"><code class="xref py py-obj docutils literal notranslate"><span class="pre">sqlite3.threadsafety</span></code></a>).  Pre- Python 3.11
    99. 

  99. this value was hard coded to 1.</p>
    100. 

  100. <p>Depending on this value, optimizations are made, e.g. in “serialized” mode
    101. 

  101. it is not necessary to create a separate DB connector for each thread.</p>
    102. 

  102. </dd></dl>
    103. 

  103. 

  104. <dl class="py attribute">
    105. 

  105. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteAppl.SQLITE_JOURNAL_MODE">
    106. 

  106. <span class="sig-name descname"><span class="pre">SQLITE_JOURNAL_MODE</span></span><em class="property"><span class="w"> </span><span class="p"><span class="pre">=</span></span><span class="w"> </span><span class="pre">'WAL'</span></em><a class="headerlink" href="#searx.sqlitedb.SQLiteAppl.SQLITE_JOURNAL_MODE" title="Link to this definition">¶</a></dt>
    107. 

  107. <dd><p><code class="docutils literal notranslate"><span class="pre">SQLiteAppl</span></code> applications are optimized for <a class="reference external" href="https://sqlite.org/wal.html">WAL</a> mode, its not recommend
    108. 

  108. to change the journal mode (see <code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLiteAppl.tear_down</span></code>).</p>
    109. 

  109. </dd></dl>
    110. 

  110. 

  111. <dl class="py attribute">
    112. 

  112. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteAppl.SQLITE_CONNECT_ARGS">
    113. 

  113. <span class="sig-name descname"><span class="pre">SQLITE_CONNECT_ARGS</span></span><em class="property"><span class="w"> </span><span class="p"><span class="pre">=</span></span><span class="w"> </span><span class="pre">{'cached_statements':</span> <span class="pre">0,</span> <span class="pre">'check_same_thread':</span> <span class="pre">False,</span> <span class="pre">'isolation_level':</span> <span class="pre">None}</span></em><a class="headerlink" href="#searx.sqlitedb.SQLiteAppl.SQLITE_CONNECT_ARGS" title="Link to this definition">¶</a></dt>
    114. 

  114. <dd><p>Connection arguments (<a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3.connect" title="(in Python v3.13)"><code class="xref py py-obj docutils literal notranslate"><span class="pre">sqlite3.connect</span></code></a>)</p>
    115. 

  115. <dl>
    116. 

  116. <dt><code class="docutils literal notranslate"><span class="pre">check_same_thread</span></code>:</dt><dd><p>Is disabled by default when <a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.SQLITE_THREADING_MODE" title="searx.sqlitedb.SQLiteAppl.SQLITE_THREADING_MODE"><code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLITE_THREADING_MODE</span></code></a> is
    117. 

  117. <code class="docutils literal notranslate"><span class="pre">serialized</span></code>.  The check is more of a hindrance in this case because it
    118. 

  118. would prevent a DB connector from being used in multiple threads.</p>
    119. 

  119. </dd>
    120. 

  120. <dt><code class="docutils literal notranslate"><span class="pre">cached_statements</span></code>:</dt><dd><p>Is set to <code class="docutils literal notranslate"><span class="pre">0</span></code> by default.  Note: Python 3.12+ fetch result are not
    121. 

  121. consistent in multi-threading application and causing an API misuse error.</p>
    122. 

  122. <p>The multithreading use in SQLiteAppl is intended and supported if
    123. 

  123. threadsafety is set to 3 (aka “serialized”). CPython supports “serialized”
    124. 

  124. from version 3.12 on, but unfortunately only with errors:</p>
    125. 

  125. <ul class="simple">
    126. 

  126. <li><p><a class="reference external" href="https://github.com/python/cpython/issues/118172">https://github.com/python/cpython/issues/118172</a></p></li>
    127. 

  127. <li><p><a class="reference external" href="https://github.com/python/cpython/issues/123873">https://github.com/python/cpython/issues/123873</a></p></li>
    128. 

  128. </ul>
    129. 

  129. <p>The workaround for SQLite3 multithreading cache inconsistency is to set
    130. 

  130. option <code class="docutils literal notranslate"><span class="pre">cached_statements</span></code> to <code class="docutils literal notranslate"><span class="pre">0</span></code> by default.</p>
    131. 

  131. </dd>
    132. 

  132. </dl>
    133. 

  133. </dd></dl>
    134. 

  134. 

  135. <dl class="py method">
    136. 

  136. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteAppl.connect">
    137. 

  137. <span class="sig-name descname"><span class="pre">connect</span></span><span class="sig-paren">(</span><span class="sig-paren">)</span> <span class="sig-return"><span class="sig-return-icon">&#x2192;</span> <span class="sig-return-typehint"><a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection" title="(in Python v3.13)"><span class="pre">Connection</span></a></span></span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteAppl.connect"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteAppl.connect" title="Link to this definition">¶</a></dt>
    138. 

  138. <dd><p>Creates a new DB connection (<a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.SQLITE_CONNECT_ARGS" title="searx.sqlitedb.SQLiteAppl.SQLITE_CONNECT_ARGS"><code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLITE_CONNECT_ARGS</span></code></a>).  If not
    139. 

  139. already done, the DB schema is set up.  The caller must take care of
    140. 

  140. closing the resource.  Alternatively, <a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.DB" title="searx.sqlitedb.SQLiteAppl.DB"><code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLiteAppl.DB</span></code></a> can also
    141. 

  141. be used (the resource behind <cite>self.DB</cite> is automatically closed when the
    142. 

  142. process or thread is terminated).</p>
    143. 

  143. </dd></dl>
    144. 

  144. 

  145. <dl class="py method">
    146. 

  146. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteAppl.register_functions">
    147. 

  147. <span class="sig-name descname"><span class="pre">register_functions</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">conn</span></span></em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteAppl.register_functions"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteAppl.register_functions" title="Link to this definition">¶</a></dt>
    148. 

  148. <dd><p>Create <a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.create_function">user-defined</a> SQL functions.</p>
    149. 

  149. <dl>
    150. 

  150. <dt><code class="docutils literal notranslate"><span class="pre">REGEXP(&lt;pattern&gt;,</span> <span class="pre">&lt;field&gt;)</span></code><span class="classifier">0 | 1</span></dt><dd><p><a class="reference external" href="https://docs.python.org/3/library/re.html#re.search">re.search</a> returns (int) 1 for a match and 0 for none match of
    151. 

  151. <code class="docutils literal notranslate"><span class="pre">&lt;pattern&gt;</span></code> in <code class="docutils literal notranslate"><span class="pre">&lt;field&gt;</span></code>.</p>
    152. 

  152. <div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="s1">&#39;12&#39;</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">field</span><span class="w"> </span><span class="k">WHERE</span><span class="w"> </span><span class="n">REGEXP</span><span class="p">(</span><span class="s1">&#39;^[0-9][0-9]$&#39;</span><span class="p">,</span><span class="w"> </span><span class="n">field</span><span class="p">)</span>
    153. 

  153. <span class="c1">-- 12</span>
    154. 

  154. 

  155. <span class="k">SELECT</span><span class="w"> </span><span class="n">REGEXP</span><span class="p">(</span><span class="s1">&#39;[0-9][0-9]&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;X12Y&#39;</span><span class="p">)</span>
    156. 

  156. <span class="c1">-- 1</span>
    157. 

  157. <span class="k">SELECT</span><span class="w"> </span><span class="n">REGEXP</span><span class="p">(</span><span class="s1">&#39;[0-9][0-9]&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;X1Y&#39;</span><span class="p">)</span>
    158. 

  158. <span class="c1">-- 0</span>
    159. 

  159. </pre></div>
    160. 

  160. </div>
    161. 

  161. </dd>
    162. 

  162. </dl>
    163. 

  163. </dd></dl>
    164. 

  164. 

  165. <dl class="py property">
    166. 

  166. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteAppl.DB">
    167. 

  167. <em class="property"><span class="pre">property</span><span class="w"> </span></em><span class="sig-name descname"><span class="pre">DB</span></span><em class="property"><span class="p"><span class="pre">:</span></span><span class="w"> </span><a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection" title="(in Python v3.13)"><span class="pre">Connection</span></a></em><a class="headerlink" href="#searx.sqlitedb.SQLiteAppl.DB" title="Link to this definition">¶</a></dt>
    168. 

  168. <dd><p>Provides a DB connection.  The connection is a <em>singleton</em> and
    169. 

  169. therefore well suited for read access.  If
    170. 

  170. <a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.SQLITE_THREADING_MODE" title="searx.sqlitedb.SQLiteAppl.SQLITE_THREADING_MODE"><code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLITE_THREADING_MODE</span></code></a> is <code class="docutils literal notranslate"><span class="pre">serialized</span></code> only one DB connection
    171. 

  171. is created for all threads.</p>
    172. 

  172. <div class="admonition note">
    173. 

  173. <p class="admonition-title">Note</p>
    174. 

  174. <p>For dedicated <a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3-controlling-transactions">transaction control</a>, it is recommended to create a
    175. 

  175. new connection (<a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.connect" title="searx.sqlitedb.SQLiteAppl.connect"><code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLiteAppl.connect</span></code></a>).</p>
    176. 

  176. </div>
    177. 

  177. </dd></dl>
    178. 

  178. 

  179. <dl class="py method">
    180. 

  180. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteAppl.init">
    181. 

  181. <span class="sig-name descname"><span class="pre">init</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">conn</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection" title="(in Python v3.13)"><span class="pre">Connection</span></a></span></em><span class="sig-paren">)</span> <span class="sig-return"><span class="sig-return-icon">&#x2192;</span> <span class="sig-return-typehint"><a class="reference external" href="https://docs.python.org/3/library/functions.html#bool" title="(in Python v3.13)"><span class="pre">bool</span></a></span></span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteAppl.init"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteAppl.init" title="Link to this definition">¶</a></dt>
    182. 

  182. <dd><p>Initializes the DB schema and properties, is only executed once even
    183. 

  183. if called several times.</p>
    184. 

  184. <p>If the initialization has not yet taken place, it is carried out and a
    185. 

  185. <cite>True</cite> is returned to the caller at the end.  If the initialization has
    186. 

  186. already been carried out in the past, <cite>False</cite> is returned.</p>
    187. 

  187. </dd></dl>
    188. 

  188. 

  189. </dd></dl>
    190. 

  190. 

  191. <dl class="py class">
    192. 

  192. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteProperties">
    193. 

  193. <em class="property"><span class="pre">class</span><span class="w"> </span></em><span class="sig-prename descclassname"><span class="pre">searx.sqlitedb.</span></span><span class="sig-name descname"><span class="pre">SQLiteProperties</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">db_url</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference external" href="https://docs.python.org/3/library/stdtypes.html#str" title="(in Python v3.13)"><span class="pre">str</span></a></span></em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteProperties"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteProperties" title="Link to this definition">¶</a></dt>
    194. 

  194. <dd><p>Simple class to manage properties of a DB application in the DB.  The
    195. 

  195. object has its own DB connection and transaction area.</p>
    196. 

  196. <div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">CREATE</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="k">IF</span><span class="w"> </span><span class="k">NOT</span><span class="w"> </span><span class="k">EXISTS</span><span class="w"> </span><span class="n">properties</span><span class="w"> </span><span class="p">(</span>
    197. 

  197. <span class="w">  </span><span class="n">name</span><span class="w">       </span><span class="nb">TEXT</span><span class="p">,</span>
    198. 

  198. <span class="w">  </span><span class="n">value</span><span class="w">      </span><span class="nb">TEXT</span><span class="p">,</span>
    199. 

  199. <span class="w">  </span><span class="n">m_time</span><span class="w">     </span><span class="nb">INTEGER</span><span class="w"> </span><span class="k">DEFAULT</span><span class="w"> </span><span class="p">(</span><span class="n">strftime</span><span class="p">(</span><span class="s1">&#39;%s&#39;</span><span class="p">,</span><span class="w"> </span><span class="s1">&#39;now&#39;</span><span class="p">)),</span>
    200. 

  200. <span class="w">  </span><span class="k">PRIMARY</span><span class="w"> </span><span class="k">KEY</span><span class="w"> </span><span class="p">(</span><span class="n">name</span><span class="p">))</span>
    201. 

  201. </pre></div>
    202. 

  202. </div>
    203. 

  203. <dl class="py attribute">
    204. 

  204. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteProperties.SQLITE_JOURNAL_MODE">
    205. 

  205. <span class="sig-name descname"><span class="pre">SQLITE_JOURNAL_MODE</span></span><em class="property"><span class="w"> </span><span class="p"><span class="pre">=</span></span><span class="w"> </span><span class="pre">'WAL'</span></em><a class="headerlink" href="#searx.sqlitedb.SQLiteProperties.SQLITE_JOURNAL_MODE" title="Link to this definition">¶</a></dt>
    206. 

  206. <dd><p><code class="docutils literal notranslate"><span class="pre">SQLiteAppl</span></code> applications are optimized for <a class="reference external" href="https://sqlite.org/wal.html">WAL</a> mode, its not recommend
    207. 

  207. to change the journal mode (see <code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLiteAppl.tear_down</span></code>).</p>
    208. 

  208. </dd></dl>
    209. 

  209. 

  210. <dl class="py attribute">
    211. 

  211. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteProperties.DDL_PROPERTIES">
    212. 

  212. <span class="sig-name descname"><span class="pre">DDL_PROPERTIES</span></span><em class="property"><span class="w"> </span><span class="p"><span class="pre">=</span></span><span class="w"> </span><span class="pre">&quot;CREATE</span> <span class="pre">TABLE</span> <span class="pre">IF</span> <span class="pre">NOT</span> <span class="pre">EXISTS</span> <span class="pre">properties</span> <span class="pre">(\n</span>&#160; <span class="pre">name</span>&#160;&#160;&#160;&#160;&#160;&#160; <span class="pre">TEXT,\n</span>&#160; <span class="pre">value</span>&#160;&#160;&#160;&#160;&#160; <span class="pre">TEXT,\n</span>&#160; <span class="pre">m_time</span>&#160;&#160;&#160;&#160; <span class="pre">INTEGER</span> <span class="pre">DEFAULT</span> <span class="pre">(strftime('%s',</span> <span class="pre">'now')),</span>&#160; <span class="pre">--</span> <span class="pre">last</span> <span class="pre">modified</span> <span class="pre">(unix</span> <span class="pre">epoch)</span> <span class="pre">time</span> <span class="pre">in</span> <span class="pre">sec.\n</span>&#160; <span class="pre">PRIMARY</span> <span class="pre">KEY</span> <span class="pre">(name))&quot;</span></em><a class="headerlink" href="#searx.sqlitedb.SQLiteProperties.DDL_PROPERTIES" title="Link to this definition">¶</a></dt>
    213. 

  213. <dd><p>Table to store properties of the DB application</p>
    214. 

  214. </dd></dl>
    215. 

  215. 

  216. <dl class="py attribute">
    217. 

  217. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteProperties.SQLITE_CONNECT_ARGS">
    218. 

  218. <span class="sig-name descname"><span class="pre">SQLITE_CONNECT_ARGS</span></span><em class="property"><span class="w"> </span><span class="p"><span class="pre">=</span></span><span class="w"> </span><span class="pre">{'cached_statements':</span> <span class="pre">0,</span> <span class="pre">'check_same_thread':</span> <span class="pre">False,</span> <span class="pre">'isolation_level':</span> <span class="pre">None}</span></em><a class="headerlink" href="#searx.sqlitedb.SQLiteProperties.SQLITE_CONNECT_ARGS" title="Link to this definition">¶</a></dt>
    219. 

  219. <dd><p>Connection arguments (<a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3.connect" title="(in Python v3.13)"><code class="xref py py-obj docutils literal notranslate"><span class="pre">sqlite3.connect</span></code></a>)</p>
    220. 

  220. <dl>
    221. 

  221. <dt><code class="docutils literal notranslate"><span class="pre">check_same_thread</span></code>:</dt><dd><p>Is disabled by default when <code class="xref py py-obj docutils literal notranslate"><span class="pre">SQLITE_THREADING_MODE</span></code> is
    222. 

  222. <code class="docutils literal notranslate"><span class="pre">serialized</span></code>.  The check is more of a hindrance in this case because it
    223. 

  223. would prevent a DB connector from being used in multiple threads.</p>
    224. 

  224. </dd>
    225. 

  225. <dt><code class="docutils literal notranslate"><span class="pre">cached_statements</span></code>:</dt><dd><p>Is set to <code class="docutils literal notranslate"><span class="pre">0</span></code> by default.  Note: Python 3.12+ fetch result are not
    226. 

  226. consistent in multi-threading application and causing an API misuse error.</p>
    227. 

  227. <p>The multithreading use in SQLiteAppl is intended and supported if
    228. 

  228. threadsafety is set to 3 (aka “serialized”). CPython supports “serialized”
    229. 

  229. from version 3.12 on, but unfortunately only with errors:</p>
    230. 

  230. <ul class="simple">
    231. 

  231. <li><p><a class="reference external" href="https://github.com/python/cpython/issues/118172">https://github.com/python/cpython/issues/118172</a></p></li>
    232. 

  232. <li><p><a class="reference external" href="https://github.com/python/cpython/issues/123873">https://github.com/python/cpython/issues/123873</a></p></li>
    233. 

  233. </ul>
    234. 

  234. <p>The workaround for SQLite3 multithreading cache inconsistency is to set
    235. 

  235. option <code class="docutils literal notranslate"><span class="pre">cached_statements</span></code> to <code class="docutils literal notranslate"><span class="pre">0</span></code> by default.</p>
    236. 

  236. </dd>
    237. 

  237. </dl>
    238. 

  238. </dd></dl>
    239. 

  239. 

  240. <dl class="py method">
    241. 

  241. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteProperties.init">
    242. 

  242. <span class="sig-name descname"><span class="pre">init</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">conn</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference external" href="https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection" title="(in Python v3.13)"><span class="pre">Connection</span></a></span></em><span class="sig-paren">)</span> <span class="sig-return"><span class="sig-return-icon">&#x2192;</span> <span class="sig-return-typehint"><a class="reference external" href="https://docs.python.org/3/library/functions.html#bool" title="(in Python v3.13)"><span class="pre">bool</span></a></span></span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteProperties.init"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteProperties.init" title="Link to this definition">¶</a></dt>
    243. 

  243. <dd><p>Initializes DB schema of the properties in the DB.</p>
    244. 

  244. </dd></dl>
    245. 

  245. 

  246. <dl class="py method">
    247. 

  247. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteProperties.set">
    248. 

  248. <span class="sig-name descname"><span class="pre">set</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">name</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference external" href="https://docs.python.org/3/library/stdtypes.html#str" title="(in Python v3.13)"><span class="pre">str</span></a></span></em>, <em class="sig-param"><span class="n"><span class="pre">value</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference external" href="https://docs.python.org/3/library/stdtypes.html#str" title="(in Python v3.13)"><span class="pre">str</span></a><span class="w"> </span><span class="p"><span class="pre">|</span></span><span class="w"> </span><a class="reference external" href="https://docs.python.org/3/library/functions.html#int" title="(in Python v3.13)"><span class="pre">int</span></a></span></em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteProperties.set"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteProperties.set" title="Link to this definition">¶</a></dt>
    249. 

  249. <dd><p>Set <code class="docutils literal notranslate"><span class="pre">value</span></code> of property <code class="docutils literal notranslate"><span class="pre">name</span></code> in DB.  If property already
    250. 

  250. exists, update the <code class="docutils literal notranslate"><span class="pre">m_time</span></code> (and the value).</p>
    251. 

  251. </dd></dl>
    252. 

  252. 

  253. <dl class="py method">
    254. 

  254. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteProperties.delete">
    255. 

  255. <span class="sig-name descname"><span class="pre">delete</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">name</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference external" href="https://docs.python.org/3/library/stdtypes.html#str" title="(in Python v3.13)"><span class="pre">str</span></a></span></em><span class="sig-paren">)</span> <span class="sig-return"><span class="sig-return-icon">&#x2192;</span> <span class="sig-return-typehint"><a class="reference external" href="https://docs.python.org/3/library/functions.html#int" title="(in Python v3.13)"><span class="pre">int</span></a></span></span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteProperties.delete"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteProperties.delete" title="Link to this definition">¶</a></dt>
    256. 

  256. <dd><p>Delete of property <code class="docutils literal notranslate"><span class="pre">name</span></code> from DB.</p>
    257. 

  257. </dd></dl>
    258. 

  258. 

  259. <dl class="py method">
    260. 

  260. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteProperties.row">
    261. 

  261. <span class="sig-name descname"><span class="pre">row</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">name</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference external" href="https://docs.python.org/3/library/stdtypes.html#str" title="(in Python v3.13)"><span class="pre">str</span></a></span></em>, <em class="sig-param"><span class="n"><span class="pre">default</span></span><span class="o"><span class="pre">=</span></span><span class="default_value"><span class="pre">None</span></span></em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteProperties.row"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteProperties.row" title="Link to this definition">¶</a></dt>
    262. 

  262. <dd><p>Returns the DB row of property <code class="docutils literal notranslate"><span class="pre">name</span></code> or <code class="docutils literal notranslate"><span class="pre">default</span></code> if property
    263. 

  263. not exists in DB.</p>
    264. 

  264. </dd></dl>
    265. 

  265. 

  266. <dl class="py method">
    267. 

  267. <dt class="sig sig-object py" id="searx.sqlitedb.SQLiteProperties.m_time">
    268. 

  268. <span class="sig-name descname"><span class="pre">m_time</span></span><span class="sig-paren">(</span><em class="sig-param"><span class="n"><span class="pre">name</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference external" href="https://docs.python.org/3/library/stdtypes.html#str" title="(in Python v3.13)"><span class="pre">str</span></a></span></em>, <em class="sig-param"><span class="n"><span class="pre">default</span></span><span class="p"><span class="pre">:</span></span><span class="w"> </span><span class="n"><a class="reference external" href="https://docs.python.org/3/library/functions.html#int" title="(in Python v3.13)"><span class="pre">int</span></a></span><span class="w"> </span><span class="o"><span class="pre">=</span></span><span class="w"> </span><span class="default_value"><span class="pre">0</span></span></em><span class="sig-paren">)</span> <span class="sig-return"><span class="sig-return-icon">&#x2192;</span> <span class="sig-return-typehint"><a class="reference external" href="https://docs.python.org/3/library/functions.html#int" title="(in Python v3.13)"><span class="pre">int</span></a></span></span><a class="reference internal" href="../_modules/searx/sqlitedb.html#SQLiteProperties.m_time"><span class="viewcode-link"><span class="pre">[source]</span></span></a><a class="headerlink" href="#searx.sqlitedb.SQLiteProperties.m_time" title="Link to this definition">¶</a></dt>
    269. 

  269. <dd><p>Last modification time of this property.</p>
    270. 

  270. </dd></dl>
    271. 

  271. 

  272. </dd></dl>
    273. 

  273. 

  274. </section>
    275. 

  275. 

  276. 

  277.             <div class="clearer"></div>
    278. 

  278.           </div>
    279. 

  279.         </div>
    280. 

  280.       </div>
    281. 

  281.   <span id="sidebar-top"></span>
    282. 

  282.       <div class="sphinxsidebar" role="navigation" aria-label="Main">
    283. 

  283.         <div class="sphinxsidebarwrapper">
    284. 

  284.   
    285. 

  285.     
    286. 

  286.             <p class="logo"><a href="../index.html">
    287. 

  287.               <img class="logo" src="../_static/searxng-wordmark.svg" alt="Logo of SearXNG"/>
    288. 

  288.             </a></p>
    289. 

  289.   
    290. 

  290. 

  291. <h3><a href="../index.html">Table of Contents</a></h3>
    292. 

  292. <ul class="current">
    293. 

  293. <li class="toctree-l1"><a class="reference internal" href="../user/index.html">User information</a></li>
    294. 

  294. <li class="toctree-l1"><a class="reference internal" href="../own-instance.html">Why use a private instance?</a></li>
    295. 

  295. <li class="toctree-l1"><a class="reference internal" href="../admin/index.html">Administrator documentation</a></li>
    296. 

  296. <li class="toctree-l1"><a class="reference internal" href="../dev/index.html">Developer documentation</a></li>
    297. 

  297. <li class="toctree-l1"><a class="reference internal" href="../utils/index.html">DevOps tooling box</a></li>
    298. 

  298. <li class="toctree-l1 current"><a class="reference internal" href="index.html">Source-Code</a><ul class="current">
    299. 

  299. <li class="toctree-l2"><a class="reference internal" href="searx.babel_extract.html">Custom message extractor (i18n)</a></li>
    300. 

  300. <li class="toctree-l2"><a class="reference internal" href="searx.botdetection.html">Bot Detection</a></li>
    301. 

  301. <li class="toctree-l2"><a class="reference internal" href="searx.cache.html">Caches</a></li>
    302. 

  302. <li class="toctree-l2"><a class="reference internal" href="searx.exceptions.html">SearXNG Exceptions</a></li>
    303. 

  303. <li class="toctree-l2"><a class="reference internal" href="searx.favicons.html">Favicons (source)</a></li>
    304. 

  304. <li class="toctree-l2"><a class="reference internal" href="searx.infopage.html">Online <code class="docutils literal notranslate"><span class="pre">/info</span></code></a></li>
    305. 

  305. <li class="toctree-l2"><a class="reference internal" href="searx.locales.html">Locales</a></li>
    306. 

  306. <li class="toctree-l2"><a class="reference internal" href="searx.redisdb.html">Redis DB</a></li>
    307. 

  307. <li class="toctree-l2"><a class="reference internal" href="searx.redislib.html">Redis Library</a></li>
    308. 

  308. <li class="toctree-l2"><a class="reference internal" href="searx.search.html">Search</a></li>
    309. 

  309. <li class="toctree-l2"><a class="reference internal" href="searx.search.processors.html">Search processors</a></li>
    310. 

  310. <li class="toctree-l2"><a class="reference internal" href="searx.settings.html">Settings Loader</a></li>
    311. 

  311. <li class="toctree-l2 current"><a class="current reference internal" href="#">SQLite DB</a><ul>
    312. 

  312. <li class="toctree-l3"><a class="reference internal" href="#searx.sqlitedb.DBSession"><code class="docutils literal notranslate"><span class="pre">DBSession</span></code></a><ul>
    313. 

  313. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.DBSession.get_connect"><code class="docutils literal notranslate"><span class="pre">DBSession.get_connect()</span></code></a></li>
    314. 

  314. </ul>
    315. 

  315. </li>
    316. 

  316. <li class="toctree-l3"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl"><code class="docutils literal notranslate"><span class="pre">SQLiteAppl</span></code></a><ul>
    317. 

  317. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.DB_SCHEMA"><code class="docutils literal notranslate"><span class="pre">SQLiteAppl.DB_SCHEMA</span></code></a></li>
    318. 

  318. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.SQLITE_THREADING_MODE"><code class="docutils literal notranslate"><span class="pre">SQLiteAppl.SQLITE_THREADING_MODE</span></code></a></li>
    319. 

  319. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.SQLITE_JOURNAL_MODE"><code class="docutils literal notranslate"><span class="pre">SQLiteAppl.SQLITE_JOURNAL_MODE</span></code></a></li>
    320. 

  320. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.SQLITE_CONNECT_ARGS"><code class="docutils literal notranslate"><span class="pre">SQLiteAppl.SQLITE_CONNECT_ARGS</span></code></a></li>
    321. 

  321. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.connect"><code class="docutils literal notranslate"><span class="pre">SQLiteAppl.connect()</span></code></a></li>
    322. 

  322. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.register_functions"><code class="docutils literal notranslate"><span class="pre">SQLiteAppl.register_functions()</span></code></a></li>
    323. 

  323. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.DB"><code class="docutils literal notranslate"><span class="pre">SQLiteAppl.DB</span></code></a></li>
    324. 

  324. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteAppl.init"><code class="docutils literal notranslate"><span class="pre">SQLiteAppl.init()</span></code></a></li>
    325. 

  325. </ul>
    326. 

  326. </li>
    327. 

  327. <li class="toctree-l3"><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties"><code class="docutils literal notranslate"><span class="pre">SQLiteProperties</span></code></a><ul>
    328. 

  328. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties.SQLITE_JOURNAL_MODE"><code class="docutils literal notranslate"><span class="pre">SQLiteProperties.SQLITE_JOURNAL_MODE</span></code></a></li>
    329. 

  329. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties.DDL_PROPERTIES"><code class="docutils literal notranslate"><span class="pre">SQLiteProperties.DDL_PROPERTIES</span></code></a></li>
    330. 

  330. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties.SQLITE_CONNECT_ARGS"><code class="docutils literal notranslate"><span class="pre">SQLiteProperties.SQLITE_CONNECT_ARGS</span></code></a></li>
    331. 

  331. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties.init"><code class="docutils literal notranslate"><span class="pre">SQLiteProperties.init()</span></code></a></li>
    332. 

  332. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties.set"><code class="docutils literal notranslate"><span class="pre">SQLiteProperties.set()</span></code></a></li>
    333. 

  333. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties.delete"><code class="docutils literal notranslate"><span class="pre">SQLiteProperties.delete()</span></code></a></li>
    334. 

  334. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties.row"><code class="docutils literal notranslate"><span class="pre">SQLiteProperties.row()</span></code></a></li>
    335. 

  335. <li class="toctree-l4"><a class="reference internal" href="#searx.sqlitedb.SQLiteProperties.m_time"><code class="docutils literal notranslate"><span class="pre">SQLiteProperties.m_time()</span></code></a></li>
    336. 

  336. </ul>
    337. 

  337. </li>
    338. 

  338. </ul>
    339. 

  339. </li>
    340. 

  340. <li class="toctree-l2"><a class="reference internal" href="searx.utils.html">Utility functions for the engines</a></li>
    341. 

  341. <li class="toctree-l2"><a class="reference internal" href="searx.weather.html">Weather</a></li>
    342. 

  342. </ul>
    343. 

  343. </li>
    344. 

  344. </ul>
    345. 

  345. 

  346.   <h3>Project Links</h3>
    347. 

  347.   <ul>
    348. 

  348.     <li><a href="https://github.com/searxng/searxng/tree/master">Source</a>
    349. 

  349.   
    350. 

  350.     <li><a href="https://github.com/searxng/searxng/wiki">Wiki</a>
    351. 

  351.   
    352. 

  352.     <li><a href="https://searx.space">Public instances</a>
    353. 

  353.   
    354. 

  354.     <li><a href="https://github.com/searxng/searxng/issues">Issue Tracker</a>
    355. 

  355.   </ul><h3>Navigation</h3>
    356. 

  356. <ul>
    357. 

  357.   <li><a href="../index.html">Overview</a>
    358. 

  358.     <ul>
    359. 

  359.       <li><a href="index.html">Source-Code</a>
    360. 

  360.         <ul>
    361. 

  361.           <li>Previous: <a href="searx.settings.html" title="previous chapter">Settings Loader</a>
    362. 

  362.           <li>Next: <a href="searx.utils.html" title="next chapter">Utility functions for the engines</a></ul>
    363. 

  363.       </li>
    364. 

  364.     </ul>
    365. 

  365.   </li>
    366. 

  366. </ul>
    367. 

  367. <search id="searchbox" style="display: none" role="search">
    368. 

  368.   <h3 id="searchlabel">Quick search</h3>
    369. 

  369.     <div class="searchformwrapper">
    370. 

  370.     <form class="search" action="../search.html" method="get">
    371. 

  371.       <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
    372. 

  372.       <input type="submit" value="Go" />
    373. 

  373.     </form>
    374. 

  374.     </div>
    375. 

  375. </search>
    376. 

  376. <script>document.getElementById('searchbox').style.display = "block"</script>
    377. 

  377.   <div role="note" aria-label="source link">
    378. 

  378.     <h3>This Page</h3>
    379. 

  379.     <ul class="this-page-menu">
    380. 

  380.       <li><a href="../_sources/src/searx.sqlitedb.rst.txt"
    381. 

  381.             rel="nofollow">Show Source</a></li>
    382. 

  382.     </ul>
    383. 

  383.    </div>
    384. 

  384.         </div>
    385. 

  385.       </div>
    386. 

  386.       <div class="clearer"></div>
    387. 

  387.     </div>
    388. 

  388.     <div class="footer" role="contentinfo">
    389. 

  389.     &#169; Copyright SearXNG team.
    390. 

  390.     </div>
    391. 

  391.   </body>
    392. 

  392. </html>
    393.
© 2025 NTab仓库
Page: 407ms Template: 1ms 微信 微信二维码 哔哩哔哩 Sina Weibo Javascript Licenses Website