Home Esplora Aiuto
Accedi
sweproj.com
/
openPilotLog
mirror da https://github.com/fiffty-50/openPilotLog
2
0
Forka 0
File Problemi 0 Wiki
Albero (Tree): 8b29e8b752
Rami (Branch) Tag
openPilotLog
/
docs
/
html
/
db_8h_source.html

db_8h_source.html 25 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204 
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    2. 

  2. <html xmlns="http://www.w3.org/1999/xhtml">
    3. 

  3. <head>
    4. 

  4. <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
    5. 

  5. <meta http-equiv="X-UA-Compatible" content="IE=9"/>
    6. 

  6. <meta name="generator" content="Doxygen 1.8.20"/>
    7. 

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

  8. <title>openPilotLog: src/database/db.h Source File</title>
    9. 

  9. <link href="tabs.css" rel="stylesheet" type="text/css"/>
    10. 

  10. <script type="text/javascript" src="jquery.js"></script>
    11. 

  11. <script type="text/javascript" src="dynsections.js"></script>
    12. 

  12. <link href="navtree.css" rel="stylesheet" type="text/css"/>
    13. 

  13. <script type="text/javascript" src="resize.js"></script>
    14. 

  14. <script type="text/javascript" src="navtreedata.js"></script>
    15. 

  15. <script type="text/javascript" src="navtree.js"></script>
    16. 

  16. <link href="search/search.css" rel="stylesheet" type="text/css"/>
    17. 

  17. <script type="text/javascript" src="search/searchdata.js"></script>
    18. 

  18. <script type="text/javascript" src="search/search.js"></script>
    19. 

  19. <link href="doxygen.css" rel="stylesheet" type="text/css" />
    20. 

  20. <link href="custom_dark_theme.css" rel="stylesheet" type="text/css"/>
    21. 

  21. </head>
    22. 

  22. <body>
    23. 

  23. <div id="top"><!-- do not remove this div, it is closed by doxygen! -->
    24. 

  24. <div id="titlearea">
    25. 

  25. <table cellspacing="0" cellpadding="0">
    26. 

  26.  <tbody>
    27. 

  27.  <tr style="height: 56px;">
    28. 

  28.   <td id="projectalign" style="padding-left: 0.5em;">
    29. 

  29.    <div id="projectname">openPilotLog
    30. 

  30.    </div>
    31. 

  31.   </td>
    32. 

  32.  </tr>
    33. 

  33.  </tbody>
    34. 

  34. </table>
    35. 

  35. </div>
    36. 

  36. <!-- end header part -->
    37. 

  37. <!-- Generated by Doxygen 1.8.20 -->
    38. 

  38. <script type="text/javascript">
    39. 

  39. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
    40. 

  40. var searchBox = new SearchBox("searchBox", "search",false,'Search');
    41. 

  41. /* @license-end */
    42. 

  42. </script>
    43. 

  43. <script type="text/javascript" src="menudata.js"></script>
    44. 

  44. <script type="text/javascript" src="menu.js"></script>
    45. 

  45. <script type="text/javascript">
    46. 

  46. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
    47. 

  47. $(function() {
    48. 

  48.   initMenu('',true,false,'search.php','Search');
    49. 

  49.   $(document).ready(function() { init_search(); });
    50. 

  50. });
    51. 

  51. /* @license-end */</script>
    52. 

  52. <div id="main-nav"></div>
    53. 

  53. </div><!-- top -->
    54. 

  54. <div id="side-nav" class="ui-resizable side-nav-resizable">
    55. 

  55.   <div id="nav-tree">
    56. 

  56.     <div id="nav-tree-contents">
    57. 

  57.       <div id="nav-sync" class="sync"></div>
    58. 

  58.     </div>
    59. 

  59.   </div>
    60. 

  60.   <div id="splitbar" style="-moz-user-select:none;" 
    61. 

  61.        class="ui-resizable-handle">
    62. 

  62.   </div>
    63. 

  63. </div>
    64. 

  64. <script type="text/javascript">
    65. 

  65. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
    66. 

  66. $(document).ready(function(){initNavTree('db_8h_source.html',''); initResizable(); });
    67. 

  67. /* @license-end */
    68. 

  68. </script>
    69. 

  69. <div id="doc-content">
    70. 

  70. <!-- window showing the filter options -->
    71. 

  71. <div id="MSearchSelectWindow"
    72. 

  72.      onmouseover="return searchBox.OnSearchSelectShow()"
    73. 

  73.      onmouseout="return searchBox.OnSearchSelectHide()"
    74. 

  74.      onkeydown="return searchBox.OnSearchSelectKey(event)">
    75. 

  75. </div>
    76. 

  76. 

  77. <!-- iframe showing the search results (closed by default) -->
    78. 

  78. <div id="MSearchResultsWindow">
    79. 

  79. <iframe src="javascript:void(0)" frameborder="0" 
    80. 

  80.         name="MSearchResults" id="MSearchResults">
    81. 

  81. </iframe>
    82. 

  82. </div>
    83. 

  83. 

  84. <div class="header">
    85. 

  85.   <div class="headertitle">
    86. 

  86. <div class="title">db.h</div>  </div>
    87. 

  87. </div><!--header-->
    88. 

  88. <div class="contents">
    89. 

  89. <div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;<span class="comment">/*</span></div>
    90. 

  90. <div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="comment"> *openPilot Log - A FOSS Pilot Logbook Application</span></div>
    91. 

  91. <div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;<span class="comment"> *Copyright (C) 2020  Felix Turowsky</span></div>
    92. 

  92. <div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="comment"> *</span></div>
    93. 

  93. <div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="comment"> *This program is free software: you can redistribute it and/or modify</span></div>
    94. 

  94. <div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="comment"> *it under the terms of the GNU General Public License as published by</span></div>
    95. 

  95. <div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="comment"> *the Free Software Foundation, either version 3 of the License, or</span></div>
    96. 

  96. <div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="comment"> *(at your option) any later version.</span></div>
    97. 

  97. <div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="comment"> *</span></div>
    98. 

  98. <div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="comment"> *This program is distributed in the hope that it will be useful,</span></div>
    99. 

  99. <div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="comment"> *but WITHOUT ANY WARRANTY; without even the implied warranty of</span></div>
    100. 

  100. <div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="comment"> *MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the</span></div>
    101. 

  101. <div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;<span class="comment"> *GNU General Public License for more details.</span></div>
    102. 

  102. <div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="comment"> *</span></div>
    103. 

  103. <div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="comment"> *You should have received a copy of the GNU General Public License</span></div>
    104. 

  104. <div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="comment"> *along with this program.  If not, see &lt;https://www.gnu.org/licenses/&gt;.</span></div>
    105. 

  105. <div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="comment"> */</span></div>
    106. 

  106. <div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="preprocessor">#ifndef DB_H</span></div>
    107. 

  107. <div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;<span class="preprocessor">#define DB_H</span></div>
    108. 

  108. <div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160; </div>
    109. 

  109. <div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;<span class="preprocessor">#include &lt;QCoreApplication&gt;</span></div>
    110. 

  110. <div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;<span class="preprocessor">#include &lt;QSqlDatabase&gt;</span></div>
    111. 

  111. <div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;<span class="preprocessor">#include &lt;QSqlDriver&gt;</span></div>
    112. 

  112. <div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="preprocessor">#include &lt;QSqlError&gt;</span></div>
    113. 

  113. <div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;<span class="preprocessor">#include &lt;QSqlQuery&gt;</span></div>
    114. 

  114. <div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;<span class="preprocessor">#include &lt;QSqlRecord&gt;</span></div>
    115. 

  115. <div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="preprocessor">#include &lt;QSqlField&gt;</span></div>
    116. 

  116. <div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;<span class="preprocessor">#include &lt;QDir&gt;</span></div>
    117. 

  117. <div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;<span class="preprocessor">#include &lt;QDebug&gt;</span></div>
    118. 

  118. <div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160; </div>
    119. 

  119. <div class="line"><a name="l00039"></a><span class="lineno"><a class="line" href="class_db.html">   39</a></span>&#160;<span class="keyword">class </span><a class="code" href="class_db.html">Db</a></div>
    120. 

  120. <div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;{</div>
    121. 

  121. <div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;    <span class="keyword">public</span>:</div>
    122. 

  122. <div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;        <span class="keyword">static</span> <a class="code" href="class_db.html">Db</a>&amp; get()</div>
    123. 

  123. <div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;        {</div>
    124. 

  124. <div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;            <span class="keyword">static</span> <a class="code" href="class_db.html">Db</a> instance;</div>
    125. 

  125. <div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160; </div>
    126. 

  126. <div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;            <span class="keywordflow">return</span> instance;</div>
    127. 

  127. <div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;        }</div>
    128. 

  128. <div class="line"><a name="l00052"></a><span class="lineno"><a class="line" href="class_db.html#a2eb74695b795bf25b6ddfd41c86bcc7b">   52</a></span>&#160;        <span class="keyword">enum</span> <a class="code" href="class_db.html#a2eb74695b795bf25b6ddfd41c86bcc7b">editRole</a> {createNew, editExisting};</div>
    129. 

  129. <div class="line"><a name="l00058"></a><span class="lineno"><a class="line" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">   58</a></span>&#160;        <span class="keyword">enum</span> <a class="code" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">matchType</a> {exactMatch, partialMatch};       </div>
    130. 

  130. <div class="line"><a name="l00064"></a><span class="lineno"><a class="line" href="class_db.html#af9dd776816e7941fec7b631eb2ff40b7">   64</a></span>&#160;        <span class="keyword">static</span> <span class="keywordtype">void</span>             <a class="code" href="class_db.html#af9dd776816e7941fec7b631eb2ff40b7">connect</a>(){get().iconnect();}</div>
    131. 

  131. <div class="line"><a name="l00068"></a><span class="lineno"><a class="line" href="class_db.html#a9bc721f0e6cd55a0dc4b6a690794f05a">   68</a></span>&#160;        <span class="keyword">static</span> <span class="keywordtype">void</span>             <a class="code" href="class_db.html#a9bc721f0e6cd55a0dc4b6a690794f05a">disconnect</a>(){get().idisconnect();}</div>
    132. 

  132. <div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160; </div>
    133. 

  133. <div class="line"><a name="l00074"></a><span class="lineno"><a class="line" href="class_db.html#aca719513ddc25d3628761da143cfde9e">   74</a></span>&#160;        <span class="keyword">static</span> QSqlDatabase     <a class="code" href="class_db.html#aca719513ddc25d3628761da143cfde9e">Database</a>(){<span class="keywordflow">return</span> get().iDatabase();}</div>
    134. 

  134. <div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160; </div>
    135. 

  135. <div class="line"><a name="l00083"></a><span class="lineno"><a class="line" href="class_db.html#a05ccd0af0703255fc249e5cb9e2eb945">   83</a></span>&#160;        <span class="keyword">static</span> <span class="keywordtype">bool</span>             <a class="code" href="class_db.html#a05ccd0af0703255fc249e5cb9e2eb945">exists</a>(QString column, QString table, QString checkColumn,</div>
    136. 

  136. <div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160;                                       QString value, <a class="code" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match)</div>
    137. 

  137. <div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160;        {</div>
    138. 

  138. <div class="line"><a name="l00086"></a><span class="lineno">   86</span>&#160;            <span class="keywordflow">return</span> get().iexists(column, table, checkColumn, value, match);</div>
    139. 

  139. <div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;        }</div>
    140. 

  140. <div class="line"><a name="l00099"></a><span class="lineno"><a class="line" href="class_db.html#a939456015e76b398af918656791e3951">   99</a></span>&#160;        <span class="keyword">static</span> <span class="keywordtype">bool</span>             <a class="code" href="class_db.html#a939456015e76b398af918656791e3951">singleUpdate</a>(QString table, QString column, QString value,</div>
    141. 

  141. <div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;                                             QString checkColumn, QString checkvalue, <a class="code" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match){</div>
    142. 

  142. <div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;            <span class="keywordflow">return</span> get().isingleUpdate(table,column,value,checkColumn,checkvalue,match);</div>
    143. 

  143. <div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;        }</div>
    144. 

  144. <div class="line"><a name="l00111"></a><span class="lineno"><a class="line" href="class_db.html#addcbd285617f8ef82f79c276d7bddfe1">  111</a></span>&#160;        <span class="keyword">static</span> QString          <a class="code" href="class_db.html#addcbd285617f8ef82f79c276d7bddfe1">singleSelect</a>(QString column, QString table, QString checkColumn,</div>
    145. 

  145. <div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;                                             QString value, <a class="code" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match){</div>
    146. 

  146. <div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;            <span class="keywordflow">return</span> get().isingleSelect(column,table,checkColumn,value,match);</div>
    147. 

  147. <div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;        }</div>
    148. 

  148. <div class="line"><a name="l00124"></a><span class="lineno"><a class="line" href="class_db.html#a8dcb618ebfe1ae337bb0972bec37cbd2">  124</a></span>&#160;        <span class="keyword">static</span> QVector&lt;QString&gt; <a class="code" href="class_db.html#a8dcb618ebfe1ae337bb0972bec37cbd2">multiSelect</a>(QVector&lt;QString&gt; columns, QString table,</div>
    149. 

  149. <div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;                                            QString checkColumn, QString value, <a class="code" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match){</div>
    150. 

  150. <div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;            <span class="keywordflow">return</span> get().imultiSelect(columns,table,checkColumn,value,match);</div>
    151. 

  151. <div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;        }</div>
    152. 

  152. <div class="line"><a name="l00134"></a><span class="lineno"><a class="line" href="class_db.html#aa6c52eda14d37c9226b07e36fe6d0f86">  134</a></span>&#160;        <span class="keyword">static</span> QVector&lt;QString&gt; <a class="code" href="class_db.html#aa6c52eda14d37c9226b07e36fe6d0f86">multiSelect</a>(QVector&lt;QString&gt; columns, QString table){</div>
    153. 

  153. <div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;            <span class="keywordflow">return</span> get().imultiSelect(columns, table);</div>
    154. 

  154. <div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;        }</div>
    155. 

  155. <div class="line"><a name="l00143"></a><span class="lineno"><a class="line" href="class_db.html#aaccb09bc96d531bbc7019a7df81859ca">  143</a></span>&#160;        <span class="keyword">static</span> QVector&lt;QString&gt; <a class="code" href="class_db.html#aaccb09bc96d531bbc7019a7df81859ca">customQuery</a>(QString query, <span class="keywordtype">int</span> returnValues){</div>
    156. 

  156. <div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;            <span class="keywordflow">return</span> get().icustomQuery(query, returnValues);</div>
    157. 

  157. <div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;        }</div>
    158. 

  158. <div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160; </div>
    159. 

  159. <div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;    <span class="keyword">private</span>:</div>
    160. 

  160. <div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;        <a class="code" href="class_db.html">Db</a>() {}</div>
    161. 

  161. <div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;        <span class="keywordtype">void</span>             iconnect();</div>
    162. 

  162. <div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;        <span class="keywordtype">void</span>             idisconnect();</div>
    163. 

  163. <div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;        QSqlDatabase     iDatabase();</div>
    164. 

  164. <div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;        <span class="keywordtype">bool</span>             iexists(QString column, QString table, QString checkColumn,</div>
    165. 

  165. <div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160;                                       QString value, <a class="code" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match);</div>
    166. 

  166. <div class="line"><a name="l00154"></a><span class="lineno">  154</span>&#160;        <span class="keywordtype">bool</span>             isingleUpdate(QString table, QString column, QString value,</div>
    167. 

  167. <div class="line"><a name="l00155"></a><span class="lineno">  155</span>&#160;                                             QString checkColumn, QString checkvalue, <a class="code" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match);</div>
    168. 

  168. <div class="line"><a name="l00156"></a><span class="lineno">  156</span>&#160;        QString          isingleSelect(QString column, QString table, QString checkColumn,</div>
    169. 

  169. <div class="line"><a name="l00157"></a><span class="lineno">  157</span>&#160;                                             QString value, <a class="code" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match);</div>
    170. 

  170. <div class="line"><a name="l00158"></a><span class="lineno">  158</span>&#160;        QVector&lt;QString&gt; imultiSelect(QVector&lt;QString&gt; columns, QString table,</div>
    171. 

  171. <div class="line"><a name="l00159"></a><span class="lineno">  159</span>&#160;                                            QString checkColumn, QString value, <a class="code" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match);</div>
    172. 

  172. <div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160;        QVector&lt;QString&gt; imultiSelect(QVector&lt;QString&gt; columns, QString table);</div>
    173. 

  173. <div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;        QVector&lt;QString&gt; icustomQuery(QString query, <span class="keywordtype">int</span> returnValues);</div>
    174. 

  174. <div class="line"><a name="l00162"></a><span class="lineno">  162</span>&#160; </div>
    175. 

  175. <div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160;    <span class="keyword">public</span>:</div>
    176. 

  176. <div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;        <span class="comment">// [George]: Why delete these in particular?</span></div>
    177. 

  177. <div class="line"><a name="l00165"></a><span class="lineno">  165</span>&#160;        <a class="code" href="class_db.html">Db</a>(<a class="code" href="class_db.html">Db</a> <span class="keyword">const</span>&amp;)              = <span class="keyword">delete</span>;</div>
    178. 

  178. <div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;        <span class="keywordtype">void</span> operator=(<a class="code" href="class_db.html">Db</a> <span class="keyword">const</span>&amp;)  = <span class="keyword">delete</span>;</div>
    179. 

  179. <div class="line"><a name="l00167"></a><span class="lineno">  167</span>&#160;};</div>
    180. 

  180. <div class="line"><a name="l00168"></a><span class="lineno">  168</span>&#160; </div>
    181. 

  181. <div class="line"><a name="l00169"></a><span class="lineno">  169</span>&#160;<span class="preprocessor">#endif // DB_H</span></div>
    182. 

  182. </div><!-- fragment --></div><!-- contents -->
    183. 

  183. </div><!-- doc-content -->
    184. 

  184. <div class="ttc" id="aclass_db_html"><div class="ttname"><a href="class_db.html">Db</a></div><div class="ttdoc">The Db class provides a basic API for accessing the database programatically. It is used to set up th...</div><div class="ttdef"><b>Definition:</b> db.h:40</div></div>
    185. 

  185. <div class="ttc" id="aclass_db_html_addcbd285617f8ef82f79c276d7bddfe1"><div class="ttname"><a href="class_db.html#addcbd285617f8ef82f79c276d7bddfe1">Db::singleSelect</a></div><div class="ttdeci">static QString singleSelect(QString column, QString table, QString checkColumn, QString value, Db::matchType match)</div><div class="ttdoc">singleSelect Returns a single value from the database with a sqlite WHERE statement</div><div class="ttdef"><b>Definition:</b> db.h:111</div></div>
    186. 

  186. <div class="ttc" id="aclass_db_html_aa6c52eda14d37c9226b07e36fe6d0f86"><div class="ttname"><a href="class_db.html#aa6c52eda14d37c9226b07e36fe6d0f86">Db::multiSelect</a></div><div class="ttdeci">static QVector&lt; QString &gt; multiSelect(QVector&lt; QString &gt; columns, QString table)</div><div class="ttdoc">Db::multiSelect Returns a complete column(s) for a given table.</div><div class="ttdef"><b>Definition:</b> db.h:134</div></div>
    187. 

  187. <div class="ttc" id="aclass_db_html_a9bc721f0e6cd55a0dc4b6a690794f05a"><div class="ttname"><a href="class_db.html#a9bc721f0e6cd55a0dc4b6a690794f05a">Db::disconnect</a></div><div class="ttdeci">static void disconnect()</div><div class="ttdoc">disconnect Closes and removes the default database connection.</div><div class="ttdef"><b>Definition:</b> db.h:68</div></div>
    188. 

  188. <div class="ttc" id="aclass_db_html_a8dcb618ebfe1ae337bb0972bec37cbd2"><div class="ttname"><a href="class_db.html#a8dcb618ebfe1ae337bb0972bec37cbd2">Db::multiSelect</a></div><div class="ttdeci">static QVector&lt; QString &gt; multiSelect(QVector&lt; QString &gt; columns, QString table, QString checkColumn, QString value, Db::matchType match)</div><div class="ttdoc">Db::multiSelect Returns multiple values from the database with a sqlite WHERE statement.</div><div class="ttdef"><b>Definition:</b> db.h:124</div></div>
    189. 

  189. <div class="ttc" id="aclass_db_html_a8caadbd9713c345384823aa2f8cb951c"><div class="ttname"><a href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a></div><div class="ttdeci">matchType</div><div class="ttdoc">The matchType enum {exactMatch, partialMatch} is used to determine the matching when using a WHERE sq...</div><div class="ttdef"><b>Definition:</b> db.h:58</div></div>
    190. 

  190. <div class="ttc" id="aclass_db_html_a939456015e76b398af918656791e3951"><div class="ttname"><a href="class_db.html#a939456015e76b398af918656791e3951">Db::singleUpdate</a></div><div class="ttdeci">static bool singleUpdate(QString table, QString column, QString value, QString checkColumn, QString checkvalue, Db::matchType match)</div><div class="ttdoc">Db::singleUpdate Updates a single value in the database. Query format: UPDATE table SET column = valu...</div><div class="ttdef"><b>Definition:</b> db.h:99</div></div>
    191. 

  191. <div class="ttc" id="aclass_db_html_a2eb74695b795bf25b6ddfd41c86bcc7b"><div class="ttname"><a href="class_db.html#a2eb74695b795bf25b6ddfd41c86bcc7b">Db::editRole</a></div><div class="ttdeci">editRole</div><div class="ttdoc">The editRole enum {createNew, editExisting} is used to differentiate between creating a new entry in ...</div><div class="ttdef"><b>Definition:</b> db.h:52</div></div>
    192. 

  192. <div class="ttc" id="aclass_db_html_aca719513ddc25d3628761da143cfde9e"><div class="ttname"><a href="class_db.html#aca719513ddc25d3628761da143cfde9e">Db::Database</a></div><div class="ttdeci">static QSqlDatabase Database()</div><div class="ttdoc">Can be used to access the database connection.</div><div class="ttdef"><b>Definition:</b> db.h:74</div></div>
    193. 

  193. <div class="ttc" id="aclass_db_html_af9dd776816e7941fec7b631eb2ff40b7"><div class="ttname"><a href="class_db.html#af9dd776816e7941fec7b631eb2ff40b7">Db::connect</a></div><div class="ttdeci">static void connect()</div><div class="ttdoc">connect establishes the database connection. Only needs to be called once within the application....</div><div class="ttdef"><b>Definition:</b> db.h:64</div></div>
    194. 

  194. <div class="ttc" id="aclass_db_html_a05ccd0af0703255fc249e5cb9e2eb945"><div class="ttname"><a href="class_db.html#a05ccd0af0703255fc249e5cb9e2eb945">Db::exists</a></div><div class="ttdeci">static bool exists(QString column, QString table, QString checkColumn, QString value, Db::matchType match)</div><div class="ttdoc">Db::exists checks if a certain value exists in the database with a sqlite WHERE statement.</div><div class="ttdef"><b>Definition:</b> db.h:83</div></div>
    195. 

  195. <div class="ttc" id="aclass_db_html_aaccb09bc96d531bbc7019a7df81859ca"><div class="ttname"><a href="class_db.html#aaccb09bc96d531bbc7019a7df81859ca">Db::customQuery</a></div><div class="ttdeci">static QVector&lt; QString &gt; customQuery(QString query, int returnValues)</div><div class="ttdoc">Db::customQuery Can be used to send a complex query to the database.</div><div class="ttdef"><b>Definition:</b> db.h:143</div></div>
    196. 

  196. <!-- start footer part -->
    197. 

  197. <div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
    198. 

  198.   <ul>
    199. 

  199.     <li class="navelem"><a class="el" href="dir_68267d1309a1af8e8297ef4c3efbcdba.html">src</a></li><li class="navelem"><a class="el" href="dir_803ee67260c130b45d29089798491ab2.html">database</a></li><li class="navelem"><b>db.h</b></li>
    200. 

  200.     <li class="footer">Generated by <a href="http://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.8.20 </li>
    201. 

  201.   </ul>
    202. 

  202. </div>
    203. 

  203. </body>
    204. 

  204. </html>
    205.