NTab仓库
fjmwkj
/
searxng
mirror of https://github.com/searxng/searxng
1
0
Fork 0
Files Issues 0 Wiki
Branch: gh-pages
Branches Tags
searxng
/
_modules
/
searx
/
sqlitedb.html

sqlitedb.html 43 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454 
  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>searx.sqlitedb &#8212; SearXNG Documentation (2025.4.30+fd33559cf)</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=b12b0e12"></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.4.30+fd33559cf" 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.   </head><body>
    18. 

  18.     <div class="related" role="navigation" aria-label="Related">
    19. 

  19.       <h3>Navigation</h3>
    20. 

  20.       <ul>
    21. 

  21.         <li class="right" style="margin-right: 10px">
    22. 

  22.           <a href="../../genindex.html" title="General Index"
    23. 

  23.              accesskey="I">index</a></li>
    24. 

  24.         <li class="right" >
    25. 

  25.           <a href="../../py-modindex.html" title="Python Module Index"
    26. 

  26.              >modules</a> |</li>
    27. 

  27.         <li class="nav-item nav-item-0"><a href="../../index.html">SearXNG Documentation (2025.4.30+fd33559cf)</a> &#187;</li>
    28. 

  28.           <li class="nav-item nav-item-1"><a href="../index.html" accesskey="U">Module code</a> &#187;</li>
    29. 

  29.         <li class="nav-item nav-item-this"><a href="">searx.sqlitedb</a></li> 
    30. 

  30.       </ul>
    31. 

  31.     </div>  
    32. 

  32. 

  33.     <div class="document">
    34. 

  34.       <div class="documentwrapper">
    35. 

  35.         <div class="bodywrapper">
    36. 

  36.           <div class="body" role="main">
    37. 

  37.             
    38. 

  38.   <h1>Source code for searx.sqlitedb</h1><div class="highlight"><pre>
    39. 

  39. <span></span><span class="c1"># SPDX-License-Identifier: AGPL-3.0-or-later</span>
    40. 

  40. <span class="sd">&quot;&quot;&quot;Implementations to make access to SQLite databases a little more convenient.</span>
    41. 

  41. 

  42. <span class="sd">:py:obj:`SQLiteAppl`</span>
    43. 

  43. <span class="sd">  Abstract class with which DB applications can be implemented.</span>
    44. 

  44. 

  45. <span class="sd">:py:obj:`SQLiteProperties`:</span>
    46. 

  46. <span class="sd">  Class to manage properties stored in a database.</span>
    47. 

  47. 

  48. <span class="sd">----</span>
    49. 

  49. 

  50. <span class="sd">&quot;&quot;&quot;</span>
    51. 

  51. <span class="kn">from</span><span class="w"> </span><span class="nn">__future__</span><span class="w"> </span><span class="kn">import</span> <span class="n">annotations</span>
    52. 

  52. 

  53. <span class="kn">import</span><span class="w"> </span><span class="nn">sys</span>
    54. 

  54. <span class="kn">import</span><span class="w"> </span><span class="nn">re</span>
    55. 

  55. <span class="kn">import</span><span class="w"> </span><span class="nn">sqlite3</span>
    56. 

  56. <span class="kn">import</span><span class="w"> </span><span class="nn">threading</span>
    57. 

  57. <span class="kn">import</span><span class="w"> </span><span class="nn">abc</span>
    58. 

  58. 

  59. <span class="kn">from</span><span class="w"> </span><span class="nn">searx</span><span class="w"> </span><span class="kn">import</span> <span class="n">logger</span>
    60. 

  60. 

  61. <span class="n">logger</span> <span class="o">=</span> <span class="n">logger</span><span class="o">.</span><span class="n">getChild</span><span class="p">(</span><span class="s1">&#39;sqlitedb&#39;</span><span class="p">)</span>
    62. 

  62. 

  63. 

  64. <div class="viewcode-block" id="SQLiteAppl">
    65. 

  65. <a class="viewcode-back" href="../../src/searx.sqlitedb.html#searx.sqlitedb.SQLiteAppl">[docs]</a>
    66. 

  66. <span class="k">class</span><span class="w"> </span><span class="nc">SQLiteAppl</span><span class="p">(</span><span class="n">abc</span><span class="o">.</span><span class="n">ABC</span><span class="p">):</span>
    67. 

  67. <span class="w">    </span><span class="sd">&quot;&quot;&quot;Abstract base class for implementing convenient DB access in SQLite</span>
    68. 

  68. <span class="sd">    applications.  In the constructor, a :py:obj:`SQLiteProperties` instance is</span>
    69. 

  69. <span class="sd">    already aggregated under ``self.properties``.&quot;&quot;&quot;</span>
    70. 

  70. 

  71.     <span class="n">DDL_CREATE_TABLES</span><span class="p">:</span> <span class="nb">dict</span><span class="p">[</span><span class="nb">str</span><span class="p">,</span> <span class="nb">str</span><span class="p">]</span> <span class="o">=</span> <span class="p">{}</span>
    72. 

  72. 

  73.     <span class="n">DB_SCHEMA</span><span class="p">:</span> <span class="nb">int</span> <span class="o">=</span> <span class="mi">1</span>
    74. 

  74. <span class="w">    </span><span class="sd">&quot;&quot;&quot;As soon as changes are made to the DB schema, the version number must be</span>
    75. 

  75. <span class="sd">    increased.  Changes to the version number require the DB to be recreated (or</span>
    76. 

  76. <span class="sd">    migrated / if an migration path exists and is implemented).&quot;&quot;&quot;</span>
    77. 

  77. 

  78.     <span class="n">SQLITE_THREADING_MODE</span> <span class="o">=</span> <span class="p">{</span>
    79. 

  79.         <span class="mi">0</span><span class="p">:</span> <span class="s2">&quot;single-thread&quot;</span><span class="p">,</span>
    80. 

  80.         <span class="mi">1</span><span class="p">:</span> <span class="s2">&quot;multi-thread&quot;</span><span class="p">,</span>
    81. 

  81.         <span class="mi">3</span><span class="p">:</span> <span class="s2">&quot;serialized&quot;</span><span class="p">}[</span><span class="n">sqlite3</span><span class="o">.</span><span class="n">threadsafety</span><span class="p">]</span>  <span class="c1"># fmt:skip</span>
    82. 

  82. <span class="w">    </span><span class="sd">&quot;&quot;&quot;Threading mode of the SQLite library.  Depends on the options used at</span>
    83. 

  83. <span class="sd">    compile time and is different for different distributions and architectures.</span>
    84. 

  84. 

  85. <span class="sd">    Possible values are 0:``single-thread``, 1:``multi-thread``,</span>
    86. 

  86. <span class="sd">    3:``serialized`` (see :py:obj:`sqlite3.threadsafety`).  Pre- Python 3.11</span>
    87. 

  87. <span class="sd">    this value was hard coded to 1.</span>
    88. 

  88. 

  89. <span class="sd">    Depending on this value, optimizations are made, e.g. in “serialized” mode</span>
    90. 

  90. <span class="sd">    it is not necessary to create a separate DB connector for each thread.</span>
    91. 

  91. <span class="sd">    &quot;&quot;&quot;</span>
    92. 

  92. 

  93.     <span class="n">SQLITE_JOURNAL_MODE</span> <span class="o">=</span> <span class="s2">&quot;WAL&quot;</span>
    94. 

  94.     <span class="n">SQLITE_CONNECT_ARGS</span> <span class="o">=</span> <span class="p">{</span>
    95. 

  95.         <span class="c1"># &quot;timeout&quot;: 5.0,</span>
    96. 

  96.         <span class="c1"># &quot;detect_types&quot;: 0,</span>
    97. 

  97.         <span class="s2">&quot;check_same_thread&quot;</span><span class="p">:</span> <span class="nb">bool</span><span class="p">(</span><span class="n">SQLITE_THREADING_MODE</span> <span class="o">!=</span> <span class="s2">&quot;serialized&quot;</span><span class="p">),</span>
    98. 

  98.         <span class="s2">&quot;cached_statements&quot;</span><span class="p">:</span> <span class="mi">0</span><span class="p">,</span>  <span class="c1"># https://github.com/python/cpython/issues/118172</span>
    99. 

  99.         <span class="c1"># &quot;uri&quot;: False,</span>
    100. 

  100.         <span class="s2">&quot;autocommit&quot;</span><span class="p">:</span> <span class="kc">False</span><span class="p">,</span>
    101. 

  101.     <span class="p">}</span>  <span class="c1"># fmt:skip</span>
    102. 

  102. <span class="w">    </span><span class="sd">&quot;&quot;&quot;Connection arguments (:py:obj:`sqlite3.connect`)</span>
    103. 

  103. 

  104. <span class="sd">    ``check_same_thread``:</span>
    105. 

  105. <span class="sd">      Is disabled by default when :py:obj:`SQLITE_THREADING_MODE` is</span>
    106. 

  106. <span class="sd">      ``serialized``.  The check is more of a hindrance in this case because it</span>
    107. 

  107. <span class="sd">      would prevent a DB connector from being used in multiple threads.</span>
    108. 

  108. 

  109. <span class="sd">    ``autocommit``:</span>
    110. 

  110. <span class="sd">      Is disabled by default.  Note: autocommit option has been added in Python</span>
    111. 

  111. <span class="sd">      3.12.</span>
    112. 

  112. 

  113. <span class="sd">    ``cached_statements``:</span>
    114. 

  114. <span class="sd">      Is set to ``0`` by default.  Note: Python 3.12+ fetch result are not</span>
    115. 

  115. <span class="sd">      consistent in multi-threading application and causing an API misuse error.</span>
    116. 

  116. 

  117. <span class="sd">      The multithreading use in SQLiteAppl is intended and supported if</span>
    118. 

  118. <span class="sd">      threadsafety is set to 3 (aka &quot;serialized&quot;). CPython supports “serialized”</span>
    119. 

  119. <span class="sd">      from version 3.12 on, but unfortunately only with errors:</span>
    120. 

  120. 

  121. <span class="sd">      - https://github.com/python/cpython/issues/118172</span>
    122. 

  122. <span class="sd">      - https://github.com/python/cpython/issues/123873</span>
    123. 

  123. 

  124. <span class="sd">      The workaround for SQLite3 multithreading cache inconsistency ist to set</span>
    125. 

  125. <span class="sd">      option ``cached_statements`` to ``0`` by default.</span>
    126. 

  126. <span class="sd">    &quot;&quot;&quot;</span>
    127. 

  127. 

  128.     <span class="k">def</span><span class="w"> </span><span class="fm">__init__</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">db_url</span><span class="p">):</span>
    129. 

  129. 

  130.         <span class="bp">self</span><span class="o">.</span><span class="n">db_url</span> <span class="o">=</span> <span class="n">db_url</span>
    131. 

  131.         <span class="bp">self</span><span class="o">.</span><span class="n">properties</span> <span class="o">=</span> <span class="n">SQLiteProperties</span><span class="p">(</span><span class="n">db_url</span><span class="p">)</span>
    132. 

  132.         <span class="bp">self</span><span class="o">.</span><span class="n">thread_local</span> <span class="o">=</span> <span class="n">threading</span><span class="o">.</span><span class="n">local</span><span class="p">()</span>
    133. 

  133.         <span class="bp">self</span><span class="o">.</span><span class="n">_init_done</span> <span class="o">=</span> <span class="kc">False</span>
    134. 

  134.         <span class="bp">self</span><span class="o">.</span><span class="n">_compatibility</span><span class="p">()</span>
    135. 

  135. 

  136.     <span class="k">def</span><span class="w"> </span><span class="nf">_compatibility</span><span class="p">(</span><span class="bp">self</span><span class="p">):</span>
    137. 

  137. 

  138.         <span class="k">if</span> <span class="bp">self</span><span class="o">.</span><span class="n">SQLITE_THREADING_MODE</span> <span class="o">==</span> <span class="s2">&quot;serialized&quot;</span><span class="p">:</span>
    139. 

  139.             <span class="bp">self</span><span class="o">.</span><span class="n">_DB</span> <span class="o">=</span> <span class="kc">None</span>
    140. 

  140.         <span class="k">else</span><span class="p">:</span>
    141. 

  141.             <span class="n">msg</span> <span class="o">=</span> <span class="p">(</span>
    142. 

  142.                 <span class="sa">f</span><span class="s2">&quot;SQLite library is compiled with </span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">SQLITE_THREADING_MODE</span><span class="si">}</span><span class="s2"> mode,&quot;</span>
    143. 

  143.                 <span class="s2">&quot; read https://docs.python.org/3/library/sqlite3.html#sqlite3.threadsafety&quot;</span>
    144. 

  144.             <span class="p">)</span>
    145. 

  145.             <span class="k">if</span> <span class="n">threading</span><span class="o">.</span><span class="n">active_count</span><span class="p">()</span> <span class="o">&gt;</span> <span class="mi">1</span><span class="p">:</span>
    146. 

  146.                 <span class="n">logger</span><span class="o">.</span><span class="n">error</span><span class="p">(</span><span class="n">msg</span><span class="p">)</span>
    147. 

  147.             <span class="k">else</span><span class="p">:</span>
    148. 

  148.                 <span class="n">logger</span><span class="o">.</span><span class="n">warning</span><span class="p">(</span><span class="n">msg</span><span class="p">)</span>
    149. 

  149. 

  150.         <span class="k">if</span> <span class="n">sqlite3</span><span class="o">.</span><span class="n">sqlite_version_info</span> <span class="o">&lt;=</span> <span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="mi">35</span><span class="p">):</span>
    151. 

  151.             <span class="c1"># See &quot;Generalize UPSERT:&quot; in https://sqlite.org/releaselog/3_35_0.html</span>
    152. 

  152.             <span class="n">logger</span><span class="o">.</span><span class="n">critical</span><span class="p">(</span>
    153. 

  153.                 <span class="s2">&quot;SQLite runtime library version </span><span class="si">%s</span><span class="s2"> is not supported (require &gt;= 3.35)&quot;</span><span class="p">,</span> <span class="n">sqlite3</span><span class="o">.</span><span class="n">sqlite_version</span>
    154. 

  154.             <span class="p">)</span>
    155. 

  155. 

  156. <div class="viewcode-block" id="SQLiteAppl.connect">
    157. 

  157. <a class="viewcode-back" href="../../src/searx.sqlitedb.html#searx.sqlitedb.SQLiteAppl.connect">[docs]</a>
    158. 

  158.     <span class="k">def</span><span class="w"> </span><span class="nf">connect</span><span class="p">(</span><span class="bp">self</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="n">sqlite3</span><span class="o">.</span><span class="n">Connection</span><span class="p">:</span>
    159. 

  159. <span class="w">        </span><span class="sd">&quot;&quot;&quot;Creates a new DB connection (:py:obj:`SQLITE_CONNECT_ARGS`).  If not</span>
    160. 

  160. <span class="sd">        already done, the DB schema is set up</span>
    161. 

  161. <span class="sd">        &quot;&quot;&quot;</span>
    162. 

  162.         <span class="k">if</span> <span class="n">sys</span><span class="o">.</span><span class="n">version_info</span> <span class="o">&lt;</span> <span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="mi">12</span><span class="p">):</span>
    163. 

  163.             <span class="c1"># Prior Python 3.12 there is no &quot;autocommit&quot; option</span>
    164. 

  164.             <span class="bp">self</span><span class="o">.</span><span class="n">SQLITE_CONNECT_ARGS</span><span class="o">.</span><span class="n">pop</span><span class="p">(</span><span class="s2">&quot;autocommit&quot;</span><span class="p">,</span> <span class="kc">None</span><span class="p">)</span>
    165. 

  165. 

  166.         <span class="bp">self</span><span class="o">.</span><span class="n">init</span><span class="p">()</span>
    167. 

  167.         <span class="n">logger</span><span class="o">.</span><span class="n">debug</span><span class="p">(</span><span class="s2">&quot;</span><span class="si">%s</span><span class="s2">: connect to DB: </span><span class="si">%s</span><span class="s2"> // </span><span class="si">%s</span><span class="s2">&quot;</span><span class="p">,</span> <span class="bp">self</span><span class="o">.</span><span class="vm">__class__</span><span class="o">.</span><span class="vm">__name__</span><span class="p">,</span> <span class="bp">self</span><span class="o">.</span><span class="n">db_url</span><span class="p">,</span> <span class="bp">self</span><span class="o">.</span><span class="n">SQLITE_CONNECT_ARGS</span><span class="p">)</span>
    168. 

  168.         <span class="n">conn</span> <span class="o">=</span> <span class="n">sqlite3</span><span class="o">.</span><span class="n">Connection</span><span class="p">(</span><span class="bp">self</span><span class="o">.</span><span class="n">db_url</span><span class="p">,</span> <span class="o">**</span><span class="bp">self</span><span class="o">.</span><span class="n">SQLITE_CONNECT_ARGS</span><span class="p">)</span>  <span class="c1"># type: ignore</span>
    169. 

  169.         <span class="n">conn</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="sa">f</span><span class="s2">&quot;PRAGMA journal_mode=</span><span class="si">{</span><span class="bp">self</span><span class="o">.</span><span class="n">SQLITE_JOURNAL_MODE</span><span class="si">}</span><span class="s2">&quot;</span><span class="p">)</span>
    170. 

  170.         <span class="bp">self</span><span class="o">.</span><span class="n">register_functions</span><span class="p">(</span><span class="n">conn</span><span class="p">)</span>
    171. 

  171.         <span class="k">return</span> <span class="n">conn</span></div>
    172. 

  172. 

  173. 

  174. <div class="viewcode-block" id="SQLiteAppl.register_functions">
    175. 

  175. <a class="viewcode-back" href="../../src/searx.sqlitedb.html#searx.sqlitedb.SQLiteAppl.register_functions">[docs]</a>
    176. 

  176.     <span class="k">def</span><span class="w"> </span><span class="nf">register_functions</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">conn</span><span class="p">):</span>
    177. 

  177. <span class="w">        </span><span class="sd">&quot;&quot;&quot;Create user-defined_ SQL functions.</span>
    178. 

  178. 

  179. <span class="sd">        ``REGEXP(&lt;pattern&gt;, &lt;field&gt;)`` : 0 | 1</span>
    180. 

  180. <span class="sd">           `re.search`_ returns (int) 1 for a match and 0 for none match of</span>
    181. 

  181. <span class="sd">           ``&lt;pattern&gt;`` in ``&lt;field&gt;``.</span>
    182. 

  182. 

  183. <span class="sd">           .. code:: sql</span>
    184. 

  184. 

  185. <span class="sd">              SELECT &#39;12&#39; AS field WHERE REGEXP(&#39;^[0-9][0-9]$&#39;, field)</span>
    186. 

  186. <span class="sd">              -- 12</span>
    187. 

  187. 

  188. <span class="sd">              SELECT REGEXP(&#39;[0-9][0-9]&#39;, &#39;X12Y&#39;)</span>
    189. 

  189. <span class="sd">              -- 1</span>
    190. 

  190. <span class="sd">              SELECT REGEXP(&#39;[0-9][0-9]&#39;, &#39;X1Y&#39;)</span>
    191. 

  191. <span class="sd">              -- 0</span>
    192. 

  192. 

  193. <span class="sd">        .. _user-defined: https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.create_function</span>
    194. 

  194. <span class="sd">        .. _deterministic: https://sqlite.org/deterministic.html</span>
    195. 

  195. <span class="sd">        .. _re.search: https://docs.python.org/3/library/re.html#re.search</span>
    196. 

  196. <span class="sd">        &quot;&quot;&quot;</span>
    197. 

  197. 

  198.         <span class="n">conn</span><span class="o">.</span><span class="n">create_function</span><span class="p">(</span><span class="s1">&#39;regexp&#39;</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span> <span class="k">lambda</span> <span class="n">x</span><span class="p">,</span> <span class="n">y</span><span class="p">:</span> <span class="mi">1</span> <span class="k">if</span> <span class="n">re</span><span class="o">.</span><span class="n">search</span><span class="p">(</span><span class="n">x</span><span class="p">,</span> <span class="n">y</span><span class="p">)</span> <span class="k">else</span> <span class="mi">0</span><span class="p">,</span> <span class="n">deterministic</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span></div>
    199. 

  199. 

  200. 

  201.     <span class="nd">@property</span>
    202. 

  202.     <span class="k">def</span><span class="w"> </span><span class="nf">DB</span><span class="p">(</span><span class="bp">self</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="n">sqlite3</span><span class="o">.</span><span class="n">Connection</span><span class="p">:</span>
    203. 

  203. <span class="w">        </span><span class="sd">&quot;&quot;&quot;Provides a DB connection.  The connection is a *singleton* and</span>
    204. 

  204. <span class="sd">        therefore well suited for read access.  If</span>
    205. 

  205. <span class="sd">        :py:obj:`SQLITE_THREADING_MODE` is ``serialized`` only one DB connection</span>
    206. 

  206. <span class="sd">        is created for all threads.</span>
    207. 

  207. 

  208. <span class="sd">        .. note::</span>
    209. 

  209. 

  210. <span class="sd">           For dedicated `transaction control`_, it is recommended to create a</span>
    211. 

  211. <span class="sd">           new connection (:py:obj:`SQLiteAppl.connect`).</span>
    212. 

  212. 

  213. <span class="sd">        .. _transaction control:</span>
    214. 

  214. <span class="sd">            https://docs.python.org/3/library/sqlite3.html#sqlite3-controlling-transactions</span>
    215. 

  215. <span class="sd">        &quot;&quot;&quot;</span>
    216. 

  216. 

  217.         <span class="k">if</span> <span class="nb">getattr</span><span class="p">(</span><span class="bp">self</span><span class="o">.</span><span class="n">thread_local</span><span class="p">,</span> <span class="s1">&#39;DB&#39;</span><span class="p">,</span> <span class="kc">None</span><span class="p">)</span> <span class="ow">is</span> <span class="kc">None</span><span class="p">:</span>
    218. 

  218.             <span class="bp">self</span><span class="o">.</span><span class="n">thread_local</span><span class="o">.</span><span class="n">DB</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">connect</span><span class="p">()</span>
    219. 

  219. 

  220.         <span class="c1"># Theoretically it is possible to reuse the DB cursor across threads as</span>
    221. 

  221.         <span class="c1"># of Python 3.12, in practice the threading of the cursor seems to me to</span>
    222. 

  222.         <span class="c1"># be so faulty that I prefer to establish one connection per thread</span>
    223. 

  223. 

  224.         <span class="bp">self</span><span class="o">.</span><span class="n">thread_local</span><span class="o">.</span><span class="n">DB</span><span class="o">.</span><span class="n">commit</span><span class="p">()</span>
    225. 

  225.         <span class="k">return</span> <span class="bp">self</span><span class="o">.</span><span class="n">thread_local</span><span class="o">.</span><span class="n">DB</span>
    226. 

  226. 

  227.         <span class="c1"># In &quot;serialized&quot; mode, SQLite can be safely used by multiple threads</span>
    228. 

  228.         <span class="c1"># with no restriction.</span>
    229. 

  229.         <span class="c1">#</span>
    230. 

  230.         <span class="c1"># if self.SQLITE_THREADING_MODE != &quot;serialized&quot;:</span>
    231. 

  231.         <span class="c1">#     if getattr(self.thread_local, &#39;DB&#39;, None) is None:</span>
    232. 

  232.         <span class="c1">#         self.thread_local.DB = self.connect()</span>
    233. 

  233.         <span class="c1">#     return self.thread_local.DB</span>
    234. 

  234.         <span class="c1">#</span>
    235. 

  235.         <span class="c1"># if self._DB is None:</span>
    236. 

  236.         <span class="c1">#     self._DB = self.connect()  # pylint: disable=attribute-defined-outside-init</span>
    237. 

  237.         <span class="c1"># return self._DB</span>
    238. 

  238. 

  239. <div class="viewcode-block" id="SQLiteAppl.init">
    240. 

  240. <a class="viewcode-back" href="../../src/searx.sqlitedb.html#searx.sqlitedb.SQLiteAppl.init">[docs]</a>
    241. 

  241.     <span class="k">def</span><span class="w"> </span><span class="nf">init</span><span class="p">(</span><span class="bp">self</span><span class="p">):</span>
    242. 

  242. <span class="w">        </span><span class="sd">&quot;&quot;&quot;Initializes the DB schema and properties, is only executed once even</span>
    243. 

  243. <span class="sd">        if called several times.&quot;&quot;&quot;</span>
    244. 

  244. 

  245.         <span class="k">if</span> <span class="bp">self</span><span class="o">.</span><span class="n">_init_done</span><span class="p">:</span>
    246. 

  246.             <span class="k">return</span>
    247. 

  247.         <span class="bp">self</span><span class="o">.</span><span class="n">_init_done</span> <span class="o">=</span> <span class="kc">True</span>
    248. 

  248. 

  249.         <span class="n">logger</span><span class="o">.</span><span class="n">debug</span><span class="p">(</span><span class="s2">&quot;init DB: </span><span class="si">%s</span><span class="s2">&quot;</span><span class="p">,</span> <span class="bp">self</span><span class="o">.</span><span class="n">db_url</span><span class="p">)</span>
    250. 

  250.         <span class="bp">self</span><span class="o">.</span><span class="n">properties</span><span class="o">.</span><span class="n">init</span><span class="p">()</span>
    251. 

  251.         <span class="n">ver</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">properties</span><span class="p">(</span><span class="s2">&quot;DB_SCHEMA&quot;</span><span class="p">)</span>
    252. 

  252.         <span class="k">if</span> <span class="n">ver</span> <span class="ow">is</span> <span class="kc">None</span><span class="p">:</span>
    253. 

  253.             <span class="k">with</span> <span class="bp">self</span><span class="o">.</span><span class="n">properties</span><span class="o">.</span><span class="n">DB</span><span class="p">:</span>
    254. 

  254.                 <span class="bp">self</span><span class="o">.</span><span class="n">create_schema</span><span class="p">(</span><span class="bp">self</span><span class="o">.</span><span class="n">properties</span><span class="o">.</span><span class="n">DB</span><span class="p">)</span>
    255. 

  255.         <span class="k">else</span><span class="p">:</span>
    256. 

  256.             <span class="n">ver</span> <span class="o">=</span> <span class="nb">int</span><span class="p">(</span><span class="n">ver</span><span class="p">)</span>
    257. 

  257.             <span class="k">if</span> <span class="n">ver</span> <span class="o">!=</span> <span class="bp">self</span><span class="o">.</span><span class="n">DB_SCHEMA</span><span class="p">:</span>
    258. 

  258.                 <span class="k">raise</span> <span class="n">sqlite3</span><span class="o">.</span><span class="n">DatabaseError</span><span class="p">(</span><span class="s2">&quot;Expected DB schema v</span><span class="si">%s</span><span class="s2">, DB schema is v</span><span class="si">%s</span><span class="s2">&quot;</span> <span class="o">%</span> <span class="p">(</span><span class="bp">self</span><span class="o">.</span><span class="n">DB_SCHEMA</span><span class="p">,</span> <span class="n">ver</span><span class="p">))</span>
    259. 

  259.             <span class="n">logger</span><span class="o">.</span><span class="n">debug</span><span class="p">(</span><span class="s2">&quot;DB_SCHEMA = </span><span class="si">%s</span><span class="s2">&quot;</span><span class="p">,</span> <span class="n">ver</span><span class="p">)</span></div>
    260. 

  260. 

  261. 

  262.     <span class="k">def</span><span class="w"> </span><span class="nf">create_schema</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">conn</span><span class="p">):</span>
    263. 

  263. 

  264.         <span class="n">logger</span><span class="o">.</span><span class="n">debug</span><span class="p">(</span><span class="s2">&quot;create schema ..&quot;</span><span class="p">)</span>
    265. 

  265.         <span class="k">with</span> <span class="n">conn</span><span class="p">:</span>
    266. 

  266.             <span class="k">for</span> <span class="n">table_name</span><span class="p">,</span> <span class="n">sql</span> <span class="ow">in</span> <span class="bp">self</span><span class="o">.</span><span class="n">DDL_CREATE_TABLES</span><span class="o">.</span><span class="n">items</span><span class="p">():</span>
    267. 

  267.                 <span class="n">conn</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="n">sql</span><span class="p">)</span>
    268. 

  268.                 <span class="bp">self</span><span class="o">.</span><span class="n">properties</span><span class="o">.</span><span class="n">set</span><span class="p">(</span><span class="sa">f</span><span class="s2">&quot;Table </span><span class="si">{</span><span class="n">table_name</span><span class="si">}</span><span class="s2"> created&quot;</span><span class="p">,</span> <span class="n">table_name</span><span class="p">)</span>
    269. 

  269.                 <span class="bp">self</span><span class="o">.</span><span class="n">properties</span><span class="o">.</span><span class="n">set</span><span class="p">(</span><span class="s2">&quot;DB_SCHEMA&quot;</span><span class="p">,</span> <span class="bp">self</span><span class="o">.</span><span class="n">DB_SCHEMA</span><span class="p">)</span>
    270. 

  270.                 <span class="bp">self</span><span class="o">.</span><span class="n">properties</span><span class="o">.</span><span class="n">set</span><span class="p">(</span><span class="s2">&quot;LAST_MAINTENANCE&quot;</span><span class="p">,</span> <span class="s2">&quot;&quot;</span><span class="p">)</span></div>
    271. 

  271. 

  272. 

  273. 

  274. <div class="viewcode-block" id="SQLiteProperties">
    275. 

  275. <a class="viewcode-back" href="../../src/searx.sqlitedb.html#searx.sqlitedb.SQLiteProperties">[docs]</a>
    276. 

  276. <span class="k">class</span><span class="w"> </span><span class="nc">SQLiteProperties</span><span class="p">(</span><span class="n">SQLiteAppl</span><span class="p">):</span>
    277. 

  277. <span class="w">    </span><span class="sd">&quot;&quot;&quot;Simple class to manage properties of a DB application in the DB.  The</span>
    278. 

  278. <span class="sd">    object has its own DB connection and transaction area.</span>
    279. 

  279. 

  280. <span class="sd">    .. code:: sql</span>
    281. 

  281. 

  282. <span class="sd">       CREATE TABLE IF NOT EXISTS properties (</span>
    283. 

  283. <span class="sd">         name       TEXT,</span>
    284. 

  284. <span class="sd">         value      TEXT,</span>
    285. 

  285. <span class="sd">         m_time     INTEGER DEFAULT (strftime(&#39;%s&#39;, &#39;now&#39;)),</span>
    286. 

  286. <span class="sd">         PRIMARY KEY (name))</span>
    287. 

  287. 

  288. <span class="sd">    &quot;&quot;&quot;</span>
    289. 

  289. 

  290.     <span class="n">SQLITE_JOURNAL_MODE</span> <span class="o">=</span> <span class="s2">&quot;WAL&quot;</span>
    291. 

  291. 

  292.     <span class="n">DDL_PROPERTIES</span> <span class="o">=</span> <span class="s2">&quot;&quot;&quot;</span><span class="se">\</span>
    293. 

  293. <span class="s2">CREATE TABLE IF NOT EXISTS properties (</span>
    294. 

  294. <span class="s2">  name       TEXT,</span>
    295. 

  295. <span class="s2">  value      TEXT,</span>
    296. 

  296. <span class="s2">  m_time     INTEGER DEFAULT (strftime(&#39;</span><span class="si">%s</span><span class="s2">&#39;, &#39;now&#39;)),  -- last modified (unix epoch) time in sec.</span>
    297. 

  297. <span class="s2">  PRIMARY KEY (name))&quot;&quot;&quot;</span>
    298. 

  298. 

  299. <span class="w">    </span><span class="sd">&quot;&quot;&quot;Table to store properties of the DB application&quot;&quot;&quot;</span>
    300. 

  300. 

  301.     <span class="n">SQL_GET</span> <span class="o">=</span> <span class="s2">&quot;SELECT value FROM properties WHERE name = ?&quot;</span>
    302. 

  302.     <span class="n">SQL_M_TIME</span> <span class="o">=</span> <span class="s2">&quot;SELECT m_time FROM properties WHERE name = ?&quot;</span>
    303. 

  303.     <span class="n">SQL_SET</span> <span class="o">=</span> <span class="p">(</span>
    304. 

  304.         <span class="s2">&quot;INSERT INTO properties (name, value) VALUES (?, ?)&quot;</span>
    305. 

  305.         <span class="s2">&quot;    ON CONFLICT(name) DO UPDATE&quot;</span>
    306. 

  306.         <span class="s2">&quot;   SET value=excluded.value, m_time=strftime(&#39;</span><span class="si">%s</span><span class="s2">&#39;, &#39;now&#39;)&quot;</span>
    307. 

  307.     <span class="p">)</span>
    308. 

  308.     <span class="n">SQL_TABLE_EXISTS</span> <span class="o">=</span> <span class="p">(</span>
    309. 

  309.         <span class="s2">&quot;SELECT name FROM sqlite_master&quot;</span>
    310. 

  310.         <span class="s2">&quot; WHERE type=&#39;table&#39; AND name=&#39;properties&#39;&quot;</span>
    311. 

  311.     <span class="p">)</span>  <span class="c1"># fmt:skip</span>
    312. 

  312.     <span class="n">SQLITE_CONNECT_ARGS</span> <span class="o">=</span> <span class="nb">dict</span><span class="p">(</span><span class="n">SQLiteAppl</span><span class="o">.</span><span class="n">SQLITE_CONNECT_ARGS</span><span class="p">)</span>
    313. 

  313.     <span class="n">SQLITE_CONNECT_ARGS</span><span class="p">[</span><span class="s2">&quot;autocommit&quot;</span><span class="p">]</span> <span class="o">=</span> <span class="kc">True</span>  <span class="c1"># This option has no effect before Python 3.12</span>
    314. 

  314. 

  315.     <span class="k">def</span><span class="w"> </span><span class="fm">__init__</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">db_url</span><span class="p">:</span> <span class="nb">str</span><span class="p">):</span>  <span class="c1"># pylint: disable=super-init-not-called</span>
    316. 

  316. 

  317.         <span class="bp">self</span><span class="o">.</span><span class="n">db_url</span> <span class="o">=</span> <span class="n">db_url</span>
    318. 

  318.         <span class="bp">self</span><span class="o">.</span><span class="n">thread_local</span> <span class="o">=</span> <span class="n">threading</span><span class="o">.</span><span class="n">local</span><span class="p">()</span>
    319. 

  319.         <span class="bp">self</span><span class="o">.</span><span class="n">_init_done</span> <span class="o">=</span> <span class="kc">False</span>
    320. 

  320.         <span class="bp">self</span><span class="o">.</span><span class="n">_compatibility</span><span class="p">()</span>
    321. 

  321. 

  322. <div class="viewcode-block" id="SQLiteProperties.init">
    323. 

  323. <a class="viewcode-back" href="../../src/searx.sqlitedb.html#searx.sqlitedb.SQLiteProperties.init">[docs]</a>
    324. 

  324.     <span class="k">def</span><span class="w"> </span><span class="nf">init</span><span class="p">(</span><span class="bp">self</span><span class="p">):</span>
    325. 

  325. <span class="w">        </span><span class="sd">&quot;&quot;&quot;Initializes DB schema of the properties in the DB.&quot;&quot;&quot;</span>
    326. 

  326. 

  327.         <span class="k">if</span> <span class="bp">self</span><span class="o">.</span><span class="n">_init_done</span><span class="p">:</span>
    328. 

  328.             <span class="k">return</span>
    329. 

  329.         <span class="bp">self</span><span class="o">.</span><span class="n">_init_done</span> <span class="o">=</span> <span class="kc">True</span>
    330. 

  330.         <span class="n">logger</span><span class="o">.</span><span class="n">debug</span><span class="p">(</span><span class="s2">&quot;init properties of DB: </span><span class="si">%s</span><span class="s2">&quot;</span><span class="p">,</span> <span class="bp">self</span><span class="o">.</span><span class="n">db_url</span><span class="p">)</span>
    331. 

  331.         <span class="k">with</span> <span class="bp">self</span><span class="o">.</span><span class="n">DB</span> <span class="k">as</span> <span class="n">conn</span><span class="p">:</span>
    332. 

  332.             <span class="n">res</span> <span class="o">=</span> <span class="n">conn</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="bp">self</span><span class="o">.</span><span class="n">SQL_TABLE_EXISTS</span><span class="p">)</span>
    333. 

  333.             <span class="k">if</span> <span class="n">res</span><span class="o">.</span><span class="n">fetchone</span><span class="p">()</span> <span class="ow">is</span> <span class="kc">None</span><span class="p">:</span>  <span class="c1"># DB schema needs to be be created</span>
    334. 

  334.                 <span class="bp">self</span><span class="o">.</span><span class="n">create_schema</span><span class="p">(</span><span class="n">conn</span><span class="p">)</span></div>
    335. 

  335. 

  336. 

  337.     <span class="k">def</span><span class="w"> </span><span class="fm">__call__</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">name</span><span class="p">,</span> <span class="n">default</span><span class="o">=</span><span class="kc">None</span><span class="p">):</span>
    338. 

  338. <span class="w">        </span><span class="sd">&quot;&quot;&quot;Returns the value of the property ``name`` or ``default`` if property</span>
    339. 

  339. <span class="sd">        not exists in DB.&quot;&quot;&quot;</span>
    340. 

  340. 

  341.         <span class="n">res</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">DB</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="bp">self</span><span class="o">.</span><span class="n">SQL_GET</span><span class="p">,</span> <span class="p">(</span><span class="n">name</span><span class="p">,))</span><span class="o">.</span><span class="n">fetchone</span><span class="p">()</span>
    342. 

  342.         <span class="k">if</span> <span class="n">res</span> <span class="ow">is</span> <span class="kc">None</span><span class="p">:</span>
    343. 

  343.             <span class="k">return</span> <span class="n">default</span>
    344. 

  344.         <span class="k">return</span> <span class="n">res</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span>
    345. 

  345. 

  346. <div class="viewcode-block" id="SQLiteProperties.set">
    347. 

  347. <a class="viewcode-back" href="../../src/searx.sqlitedb.html#searx.sqlitedb.SQLiteProperties.set">[docs]</a>
    348. 

  348.     <span class="k">def</span><span class="w"> </span><span class="nf">set</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">name</span><span class="p">,</span> <span class="n">value</span><span class="p">):</span>
    349. 

  349. <span class="w">        </span><span class="sd">&quot;&quot;&quot;Set ``value`` of property ``name`` in DB.  If property already</span>
    350. 

  350. <span class="sd">        exists, update the ``m_time`` (and the value).&quot;&quot;&quot;</span>
    351. 

  351. 

  352.         <span class="bp">self</span><span class="o">.</span><span class="n">DB</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="bp">self</span><span class="o">.</span><span class="n">SQL_SET</span><span class="p">,</span> <span class="p">(</span><span class="n">name</span><span class="p">,</span> <span class="n">value</span><span class="p">))</span>
    353. 

  353. 

  354.         <span class="k">if</span> <span class="n">sys</span><span class="o">.</span><span class="n">version_info</span> <span class="o">&lt;=</span> <span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="mi">12</span><span class="p">):</span>
    355. 

  355.             <span class="c1"># Prior Python 3.12 there is no &quot;autocommit&quot; option / lets commit</span>
    356. 

  356.             <span class="c1"># explicitely.</span>
    357. 

  357.             <span class="bp">self</span><span class="o">.</span><span class="n">DB</span><span class="o">.</span><span class="n">commit</span><span class="p">()</span></div>
    358. 

  358. 

  359. 

  360. <div class="viewcode-block" id="SQLiteProperties.row">
    361. 

  361. <a class="viewcode-back" href="../../src/searx.sqlitedb.html#searx.sqlitedb.SQLiteProperties.row">[docs]</a>
    362. 

  362.     <span class="k">def</span><span class="w"> </span><span class="nf">row</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">name</span><span class="p">,</span> <span class="n">default</span><span class="o">=</span><span class="kc">None</span><span class="p">):</span>
    363. 

  363. <span class="w">        </span><span class="sd">&quot;&quot;&quot;Returns the DB row of property ``name`` or ``default`` if property</span>
    364. 

  364. <span class="sd">        not exists in DB.&quot;&quot;&quot;</span>
    365. 

  365. 

  366.         <span class="n">cur</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">DB</span><span class="o">.</span><span class="n">cursor</span><span class="p">()</span>
    367. 

  367.         <span class="n">cur</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="s2">&quot;SELECT * FROM properties WHERE name = ?&quot;</span><span class="p">,</span> <span class="p">(</span><span class="n">name</span><span class="p">,))</span>
    368. 

  368.         <span class="n">res</span> <span class="o">=</span> <span class="n">cur</span><span class="o">.</span><span class="n">fetchone</span><span class="p">()</span>
    369. 

  369.         <span class="k">if</span> <span class="n">res</span> <span class="ow">is</span> <span class="kc">None</span><span class="p">:</span>
    370. 

  370.             <span class="k">return</span> <span class="n">default</span>
    371. 

  371.         <span class="n">col_names</span> <span class="o">=</span> <span class="p">[</span><span class="n">column</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="k">for</span> <span class="n">column</span> <span class="ow">in</span> <span class="n">cur</span><span class="o">.</span><span class="n">description</span><span class="p">]</span>
    372. 

  372.         <span class="k">return</span> <span class="nb">dict</span><span class="p">(</span><span class="nb">zip</span><span class="p">(</span><span class="n">col_names</span><span class="p">,</span> <span class="n">res</span><span class="p">))</span></div>
    373. 

  373. 

  374. 

  375. <div class="viewcode-block" id="SQLiteProperties.m_time">
    376. 

  376. <a class="viewcode-back" href="../../src/searx.sqlitedb.html#searx.sqlitedb.SQLiteProperties.m_time">[docs]</a>
    377. 

  377.     <span class="k">def</span><span class="w"> </span><span class="nf">m_time</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">name</span><span class="p">,</span> <span class="n">default</span><span class="p">:</span> <span class="nb">int</span> <span class="o">=</span> <span class="mi">0</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="nb">int</span><span class="p">:</span>
    378. 

  378. <span class="w">        </span><span class="sd">&quot;&quot;&quot;Last modification time of this property.&quot;&quot;&quot;</span>
    379. 

  379.         <span class="n">res</span> <span class="o">=</span> <span class="bp">self</span><span class="o">.</span><span class="n">DB</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="bp">self</span><span class="o">.</span><span class="n">SQL_M_TIME</span><span class="p">,</span> <span class="p">(</span><span class="n">name</span><span class="p">,))</span><span class="o">.</span><span class="n">fetchone</span><span class="p">()</span>
    380. 

  380.         <span class="k">if</span> <span class="n">res</span> <span class="ow">is</span> <span class="kc">None</span><span class="p">:</span>
    381. 

  381.             <span class="k">return</span> <span class="n">default</span>
    382. 

  382.         <span class="k">return</span> <span class="nb">int</span><span class="p">(</span><span class="n">res</span><span class="p">[</span><span class="mi">0</span><span class="p">])</span></div>
    383. 

  383. 

  384. 

  385.     <span class="k">def</span><span class="w"> </span><span class="nf">create_schema</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">conn</span><span class="p">):</span>
    386. 

  386.         <span class="k">with</span> <span class="n">conn</span><span class="p">:</span>
    387. 

  387.             <span class="n">conn</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="bp">self</span><span class="o">.</span><span class="n">DDL_PROPERTIES</span><span class="p">)</span></div>
    388. 

  388. 

  389. </pre></div>
    390. 

  390. 

  391.             <div class="clearer"></div>
    392. 

  392.           </div>
    393. 

  393.         </div>
    394. 

  394.       </div>
    395. 

  395.   <span id="sidebar-top"></span>
    396. 

  396.       <div class="sphinxsidebar" role="navigation" aria-label="Main">
    397. 

  397.         <div class="sphinxsidebarwrapper">
    398. 

  398.   
    399. 

  399.     
    400. 

  400.             <p class="logo"><a href="../../index.html">
    401. 

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

  402.             </a></p>
    403. 

  403.   
    404. 

  404. 

  405. <h3><a href="../../index.html">Table of Contents</a></h3>
    406. 

  406. <ul>
    407. 

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

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

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

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

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

  412. <li class="toctree-l1"><a class="reference internal" href="../../src/index.html">Source-Code</a></li>
    413. 

  413. </ul>
    414. 

  414. 

  415.   <h3>Project Links</h3>
    416. 

  416.   <ul>
    417. 

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

  418.   
    419. 

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

  420.   
    421. 

  421.     <li><a href="https://searx.space">Public instances</a>
    422. 

  422.   
    423. 

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

  424.   </ul><h3>Navigation</h3>
    425. 

  425. <ul>
    426. 

  426.   <li><a href="../../index.html">Overview</a>
    427. 

  427.     <ul>
    428. 

  428.       <li><a href="../index.html">Module code</a>
    429. 

  429.         
    430. 

  430.           
    431. 

  431.           </ul>
    432. 

  432.       </li>
    433. 

  433.     </ul>
    434. 

  434.   </li>
    435. 

  435. </ul>
    436. 

  436. <search id="searchbox" style="display: none" role="search">
    437. 

  437.   <h3 id="searchlabel">Quick search</h3>
    438. 

  438.     <div class="searchformwrapper">
    439. 

  439.     <form class="search" action="../../search.html" method="get">
    440. 

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

  441.       <input type="submit" value="Go" />
    442. 

  442.     </form>
    443. 

  443.     </div>
    444. 

  444. </search>
    445. 

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

  446.         </div>
    447. 

  447.       </div>
    448. 

  448.       <div class="clearer"></div>
    449. 

  449.     </div>
    450. 

  450.     <div class="footer" role="contentinfo">
    451. 

  451.     &#169; Copyright SearXNG team.
    452. 

  452.     </div>
    453. 

  453.   </body>
    454. 

  454. </html>
    455.
© 2025 NTab仓库
Page: 33ms Template: 0ms 微信 微信二维码 哔哩哔哩 Sina Weibo Javascript Licenses Website