Accueil Explorer Aide
Connexion
sweproj.com
/
openPilotLog
miroir de https://github.com/fiffty-50/openPilotLog
2
0
Fork 0
Fichiers Tickets 0 Wiki
Aborescence: 83c20cc4fd
Branches Tags
openPilotLog
/
docs
/
html
/
adatabase_8h_source.html

adatabase_8h_source.html 55 KB
Historique Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361 
  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.9.1"/>
    7. 

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

  8. <title>openPilotLog: src/database/adatabase.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="projectlogo"><img alt="Logo" src="icon_main.png"/></td>
    29. 

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

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

  31.    </div>
    32. 

  32.   </td>
    33. 

  33.  </tr>
    34. 

  34.  </tbody>
    35. 

  35. </table>
    36. 

  36. </div>
    37. 

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

  38. <!-- Generated by Doxygen 1.9.1 -->
    39. 

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

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

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

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

  43. </script>
    44. 

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

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

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

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

  48. $(function() {
    49. 

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

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

  51. });
    52. 

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

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

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

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

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

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

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

  59.     </div>
    60. 

  60.   </div>
    61. 

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

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

  63.   </div>
    64. 

  64. </div>
    65. 

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

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

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

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

  69. </script>
    70. 

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

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

  72. <div id="MSearchSelectWindow"
    73. 

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

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

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

  76. </div>
    77. 

  77. 

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

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

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

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

  82. </iframe>
    83. 

  83. </div>
    84. 

  84. 

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

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

  87. <div class="title">adatabase.h</div>  </div>
    88. 

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

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

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

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

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

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

  94. <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>
    95. 

  95. <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>
    96. 

  96. <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>
    97. 

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

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

  99. <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>
    100. 

  100. <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>
    101. 

  101. <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>
    102. 

  102. <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>
    103. 

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

  104. <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>
    105. 

  105. <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>
    106. 

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

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

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

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

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

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

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

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

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

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

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

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

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

  119. <div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;<span class="preprocessor">#include &lt;QSqlQuery&gt;</span></div>
    120. 

  120. <div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;<span class="preprocessor">#include &lt;QSqlRecord&gt;</span></div>
    121. 

  121. <div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;<span class="preprocessor">#include &lt;QSqlField&gt;</span></div>
    122. 

  122. <div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160; </div>
    123. 

  123. <div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;<span class="preprocessor">#include &quot;src/database/adatabasetypes.h&quot;</span></div>
    124. 

  124. <div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;<span class="preprocessor">#include &quot;src/classes/aentry.h&quot;</span></div>
    125. 

  125. <div class="line"><a name="l00036"></a><span class="lineno">   36</span>&#160;<span class="preprocessor">#include &quot;src/classes/apilotentry.h&quot;</span></div>
    126. 

  126. <div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;<span class="preprocessor">#include &quot;src/classes/atailentry.h&quot;</span></div>
    127. 

  127. <div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;<span class="preprocessor">#include &quot;src/classes/aaircraftentry.h&quot;</span></div>
    128. 

  128. <div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;<span class="preprocessor">#include &quot;src/classes/aflightentry.h&quot;</span></div>
    129. 

  129. <div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;<span class="preprocessor">#include &quot;src/classes/astandardpaths.h&quot;</span></div>
    130. 

  130. <div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;<span class="preprocessor">#include &quot;src/classes/acurrencyentry.h&quot;</span></div>
    131. 

  131. <div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160; </div>
    132. 

  132. <div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;<span class="preprocessor">#define SQLITE_DRIVER QStringLiteral(&quot;QSQLITE&quot;</span>)</div>
    133. 

  133. <div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160; </div>
    134. 

  134. <div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160;<span class="preprocessor">#define aDB ADatabase::instance()</span></div>
    135. 

  135. <div class="line"><a name="l00053"></a><span class="lineno">   53</span>&#160; </div>
    136. 

  136. <div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;<span class="keyword">enum class</span> ADatabaseTarget</div>
    137. 

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

  138. <div class="line"><a name="l00060"></a><span class="lineno">   60</span>&#160;    airport_identifier_icao,</div>
    139. 

  139. <div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160;    airport_identifier_iata,</div>
    140. 

  140. <div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;    airport_identifier_all,</div>
    141. 

  141. <div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;    airport_names,</div>
    142. 

  142. <div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;    registrations,</div>
    143. 

  143. <div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;    companies,</div>
    144. 

  144. <div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;    tails,</div>
    145. 

  145. <div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;    pilots,</div>
    146. 

  146. <div class="line"><a name="l00068"></a><span class="lineno">   68</span>&#160;    aircraft</div>
    147. 

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

  148. <div class="line"><a name="l00070"></a><span class="lineno">   70</span>&#160; </div>
    149. 

  149. <div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;<span class="keyword">enum class</span> ADatabaseTable</div>
    150. 

  150. <div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;{</div>
    151. 

  151. <div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;    tails,</div>
    152. 

  152. <div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;    flights,</div>
    153. 

  153. <div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;    currencies,</div>
    154. 

  154. <div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;    aircraft,</div>
    155. 

  155. <div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160;    pilots,</div>
    156. 

  156. <div class="line"><a name="l00078"></a><span class="lineno">   78</span>&#160;};</div>
    157. 

  157. <div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160; </div>
    158. 

  158. <div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;<span class="keyword">enum class</span> ADatabaseSummaryKey {</div>
    159. 

  159. <div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160;    total_flights,</div>
    160. 

  160. <div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160;    total_tails,</div>
    161. 

  161. <div class="line"><a name="l00086"></a><span class="lineno">   86</span>&#160;    total_pilots,</div>
    162. 

  162. <div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;    last_flight,</div>
    163. 

  163. <div class="line"><a name="l00088"></a><span class="lineno">   88</span>&#160;    total_time,</div>
    164. 

  164. <div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;};</div>
    165. 

  165. <div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160; </div>
    166. 

  166. <div class="line"><a name="l00097"></a><span class="lineno"><a class="line" href="struct_user_data_state.html">   97</a></span>&#160;<span class="keyword">struct </span><a class="code" href="struct_user_data_state.html">UserDataState</a> {</div>
    167. 

  167. <div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160; </div>
    168. 

  168. <div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;    <a class="code" href="struct_user_data_state.html">UserDataState</a>(){numTails = 0; numPilots = 0;}</div>
    169. 

  169. <div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;    <a class="code" href="struct_user_data_state.html">UserDataState</a>(<span class="keywordtype">int</span> numTails_, <span class="keywordtype">int</span> numPilots_)</div>
    170. 

  170. <div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;        : numTails(numTails_), numPilots(numPilots_){}</div>
    171. 

  171. <div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160; </div>
    172. 

  172. <div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;    <span class="keywordtype">bool</span> operator==(<span class="keyword">const</span> <a class="code" href="struct_user_data_state.html">UserDataState</a>&amp; other)</div>
    173. 

  173. <div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160;    {</div>
    174. 

  174. <div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;        <span class="keywordflow">return</span> numTails == other.numTails &amp;&amp; numPilots == other.numPilots;</div>
    175. 

  175. <div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;    }</div>
    176. 

  176. <div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;    <span class="keywordtype">bool</span> operator!=(<span class="keyword">const</span> <a class="code" href="struct_user_data_state.html">UserDataState</a>&amp; other)</div>
    177. 

  177. <div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;    {</div>
    178. 

  178. <div class="line"><a name="l00109"></a><span class="lineno">  109</span>&#160;        <span class="keywordflow">return</span> numTails != other.numTails || numPilots != other.numPilots;</div>
    179. 

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

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

  181. <div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;    <span class="keywordtype">int</span> numTails;</div>
    182. 

  182. <div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;    <span class="keywordtype">int</span> numPilots;</div>
    183. 

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

  184. <div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160; </div>
    185. 

  185. <div class="line"><a name="l00123"></a><span class="lineno"><a class="line" href="class_a_database_error.html">  123</a></span>&#160;<span class="keyword">class </span><a class="code" href="class_a_database_error.html">ADatabaseError</a> : <span class="keyword">public</span> QSqlError {</div>
    186. 

  186. <div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;<span class="keyword">public</span>:</div>
    187. 

  187. <div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;    <a class="code" href="class_a_database_error.html">ADatabaseError</a>() = <span class="keywordflow">default</span>;</div>
    188. 

  188. <div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;    <a class="code" href="class_a_database_error.html">ADatabaseError</a>(QString msg);</div>
    189. 

  189. <div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;    QString text() <span class="keyword">const</span>;</div>
    190. 

  190. <div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;    <a class="code" href="class_a_database_error.html">ADatabaseError</a>(QSqlError);</div>
    191. 

  191. <div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;};</div>
    192. 

  192. <div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160; </div>
    193. 

  193. <div class="line"><a name="l00135"></a><span class="lineno"><a class="line" href="class_a_database.html">  135</a></span>&#160;<span class="keyword">class </span><a class="code" href="class_a_database.html">ADatabase</a> : <span class="keyword">public</span> QObject {</div>
    194. 

  194. <div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;    Q_OBJECT</div>
    195. 

  195. <div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160; </div>
    196. 

  196. <div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;<span class="keyword">private</span>:</div>
    197. 

  197. <div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;    <span class="keyword">static</span> <a class="code" href="class_a_database.html">ADatabase</a>* <span class="keyword">self</span>;</div>
    198. 

  198. <div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;    TableNames_T tableNames;</div>
    199. 

  199. <div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;    TableColumns_T tableColumns;</div>
    200. 

  200. <div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;    <span class="keywordtype">int</span> databaseRevision;</div>
    201. 

  201. <div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160; </div>
    202. 

  202. <div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;    <a class="code" href="class_a_database.html">ADatabase</a>();</div>
    203. 

  203. <div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;    <span class="keywordtype">int</span> checkDbVersion() <span class="keyword">const</span>;</div>
    204. 

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

  205. <div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;    <span class="keyword">const</span> <span class="keyword">static</span> QStringList userTableNames;</div>
    206. 

  206. <div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;    <span class="keyword">const</span> <span class="keyword">static</span> QStringList templateTableNames;</div>
    207. 

  207. <div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;    <span class="keyword">const</span> <span class="keyword">static</span> <span class="keywordtype">int</span> minimumDatabaseRevision;</div>
    208. 

  208. <div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;<span class="keyword">public</span>:</div>
    209. 

  209. <div class="line"><a name="l00159"></a><span class="lineno"><a class="line" href="class_a_database.html#a88c8cb3d573d46c1ee8e5af61cf63224">  159</a></span>&#160;    QSqlError <a class="code" href="class_a_database.html#a88c8cb3d573d46c1ee8e5af61cf63224">lastError</a>;</div>
    210. 

  210. <div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160; </div>
    211. 

  211. <div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;    <span class="keyword">const</span> QFileInfo databaseFile;</div>
    212. 

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

  213. <div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160;    <span class="comment">// Ensure DB is not copiable or assignable</span></div>
    214. 

  214. <div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;    <a class="code" href="class_a_database.html">ADatabase</a>(<span class="keyword">const</span> <a class="code" href="class_a_database.html">ADatabase</a>&amp;) = <span class="keyword">delete</span>;</div>
    215. 

  215. <div class="line"><a name="l00165"></a><span class="lineno">  165</span>&#160;    <span class="keywordtype">void</span> operator=(<span class="keyword">const</span> <a class="code" href="class_a_database.html">ADatabase</a>&amp;) = <span class="keyword">delete</span>;</div>
    216. 

  216. <div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;    <span class="keyword">static</span> <a class="code" href="class_a_database.html">ADatabase</a>* instance();</div>
    217. 

  217. <div class="line"><a name="l00167"></a><span class="lineno">  167</span>&#160; </div>
    218. 

  218. <div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160;    <span class="keywordtype">int</span> <a class="code" href="class_a_database.html#a1c026e7784b03fc5822077c7d0071330">dbRevision</a>() <span class="keyword">const</span>;</div>
    219. 

  219. <div class="line"><a name="l00174"></a><span class="lineno">  174</span>&#160; </div>
    220. 

  220. <div class="line"><a name="l00178"></a><span class="lineno">  178</span>&#160;    <span class="keyword">const</span> TableNames_T <a class="code" href="class_a_database.html#a3deb081c5abe832a65e1792c106eb083">getTableNames</a>() <span class="keyword">const</span>;</div>
    221. 

  221. <div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160; </div>
    222. 

  222. <div class="line"><a name="l00183"></a><span class="lineno">  183</span>&#160;    <span class="keyword">const</span> ColumnNames_T <a class="code" href="class_a_database.html#a9c0dcd8c35087c8256b75d8aafa64880">getTableColumns</a>(TableName_T table_name) <span class="keyword">const</span>;</div>
    223. 

  223. <div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160; </div>
    224. 

  224. <div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;    <span class="keywordtype">void</span> <a class="code" href="class_a_database.html#a3c0fdc84000ad397d61f0efabd032194">updateLayout</a>();</div>
    225. 

  225. <div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160; </div>
    226. 

  226. <div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;    <span class="keyword">const</span> QString <a class="code" href="class_a_database.html#a491415273a771dd7ea41452c331a34b0">sqliteVersion</a>() <span class="keyword">const</span>;</div>
    227. 

  227. <div class="line"><a name="l00196"></a><span class="lineno">  196</span>&#160; </div>
    228. 

  228. <div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#aa6080200aa3f229251480bc416755fed">connect</a>();</div>
    229. 

  229. <div class="line"><a name="l00201"></a><span class="lineno">  201</span>&#160; </div>
    230. 

  230. <div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;    <span class="keywordtype">void</span> <a class="code" href="class_a_database.html#abc461aaa66304ca638e546f67a694935">disconnect</a>();</div>
    231. 

  231. <div class="line"><a name="l00206"></a><span class="lineno">  206</span>&#160; </div>
    232. 

  232. <div class="line"><a name="l00211"></a><span class="lineno">  211</span>&#160;    <span class="keyword">static</span> QSqlDatabase <a class="code" href="class_a_database.html#a2379c9da900da8e96add932e4024389a">database</a>();</div>
    233. 

  233. <div class="line"><a name="l00212"></a><span class="lineno">  212</span>&#160; </div>
    234. 

  234. <div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;    QVector&lt;QVariant&gt; <a class="code" href="class_a_database.html#a2a43936d3ae28993f9f7eda0fdf4664d">customQuery</a>(QString statement, <span class="keywordtype">int</span> return_values);</div>
    235. 

  235. <div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160; </div>
    236. 

  236. <div class="line"><a name="l00223"></a><span class="lineno">  223</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a0c5a017dccf7bf5d4dcbfc29c8d20e12">exists</a>(<span class="keyword">const</span> <a class="code" href="class_a_entry.html">AEntry</a> &amp;entry);</div>
    237. 

  237. <div class="line"><a name="l00224"></a><span class="lineno">  224</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a0c5a017dccf7bf5d4dcbfc29c8d20e12">exists</a>(<a class="code" href="struct_data_position.html">DataPosition</a> data_position);</div>
    238. 

  238. <div class="line"><a name="l00225"></a><span class="lineno">  225</span>&#160; </div>
    239. 

  239. <div class="line"><a name="l00230"></a><span class="lineno">  230</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a73382f7e897f8381371cd3da458f72cc">clear</a>();</div>
    240. 

  240. <div class="line"><a name="l00231"></a><span class="lineno">  231</span>&#160; </div>
    241. 

  241. <div class="line"><a name="l00236"></a><span class="lineno">  236</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a7d57d7696814bd013fa35e068ad909c8">commit</a>(<span class="keyword">const</span> <a class="code" href="class_a_entry.html">AEntry</a> &amp;entry);</div>
    242. 

  242. <div class="line"><a name="l00237"></a><span class="lineno">  237</span>&#160; </div>
    243. 

  243. <div class="line"><a name="l00241"></a><span class="lineno">  241</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#aa69dcdf174e48653cdf1bef473dc5623">insert</a>(<span class="keyword">const</span> <a class="code" href="class_a_entry.html">AEntry</a> &amp;new_entry);</div>
    244. 

  244. <div class="line"><a name="l00242"></a><span class="lineno">  242</span>&#160; </div>
    245. 

  245. <div class="line"><a name="l00246"></a><span class="lineno">  246</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#ac73208ba1a70af19590d53f260e7cb8c">update</a>(<span class="keyword">const</span> <a class="code" href="class_a_entry.html">AEntry</a> &amp;updated_entry);</div>
    246. 

  246. <div class="line"><a name="l00247"></a><span class="lineno">  247</span>&#160; </div>
    247. 

  247. <div class="line"><a name="l00251"></a><span class="lineno">  251</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a4deda96cfb75518f98a4a0c9996920eb">remove</a>(<span class="keyword">const</span> <a class="code" href="class_a_entry.html">AEntry</a> &amp;entry);</div>
    248. 

  248. <div class="line"><a name="l00252"></a><span class="lineno">  252</span>&#160; </div>
    249. 

  249. <div class="line"><a name="l00257"></a><span class="lineno">  257</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a863d30e9e3a7c14adfe72787363618c8">removeMany</a>(QList&lt;DataPosition&gt;);</div>
    250. 

  250. <div class="line"><a name="l00258"></a><span class="lineno">  258</span>&#160; </div>
    251. 

  251. <div class="line"><a name="l00262"></a><span class="lineno">  262</span>&#160;    RowData_T <a class="code" href="class_a_database.html#afc39f6136fc822e0649964fa22b84bf9">getEntryData</a>(<a class="code" href="struct_data_position.html">DataPosition</a> data_position);</div>
    252. 

  252. <div class="line"><a name="l00263"></a><span class="lineno">  263</span>&#160; </div>
    253. 

  253. <div class="line"><a name="l00267"></a><span class="lineno">  267</span>&#160;    <a class="code" href="class_a_entry.html">AEntry</a> <a class="code" href="class_a_database.html#a8959b406b97d9520981890d92850b1ba">getEntry</a>(<a class="code" href="struct_data_position.html">DataPosition</a> data_position);</div>
    254. 

  254. <div class="line"><a name="l00268"></a><span class="lineno">  268</span>&#160; </div>
    255. 

  255. <div class="line"><a name="l00277"></a><span class="lineno">  277</span>&#160;    <a class="code" href="struct_a_pilot_entry.html">APilotEntry</a> <a class="code" href="class_a_database.html#a426026d641a594863995ec5db8312259">getPilotEntry</a>(RowId_T row_id);</div>
    256. 

  256. <div class="line"><a name="l00278"></a><span class="lineno">  278</span>&#160; </div>
    257. 

  257. <div class="line"><a name="l00287"></a><span class="lineno">  287</span>&#160;    <a class="code" href="struct_a_tail_entry.html">ATailEntry</a> <a class="code" href="class_a_database.html#a356df159542705635dc3898d90682039">getTailEntry</a>(RowId_T row_id);</div>
    258. 

  258. <div class="line"><a name="l00288"></a><span class="lineno">  288</span>&#160; </div>
    259. 

  259. <div class="line"><a name="l00297"></a><span class="lineno">  297</span>&#160;    <a class="code" href="struct_a_aircraft_entry.html">AAircraftEntry</a> <a class="code" href="class_a_database.html#ae0a3c9273431195df6295b9da24b3a3a">getAircraftEntry</a>(RowId_T row_id);</div>
    260. 

  260. <div class="line"><a name="l00298"></a><span class="lineno">  298</span>&#160; </div>
    261. 

  261. <div class="line"><a name="l00307"></a><span class="lineno">  307</span>&#160;    <a class="code" href="class_a_flight_entry.html">AFlightEntry</a> <a class="code" href="class_a_database.html#a7bb44738362582e4f54f68e3aa30d40a">getFlightEntry</a>(RowId_T row_id);</div>
    262. 

  262. <div class="line"><a name="l00308"></a><span class="lineno">  308</span>&#160; </div>
    263. 

  263. <div class="line"><a name="l00312"></a><span class="lineno">  312</span>&#160;    <a class="code" href="struct_a_currency_entry.html">ACurrencyEntry</a> <a class="code" href="class_a_database.html#a5abdf1f35468f788609252c7a3be7bc4">getCurrencyEntry</a>(ACurrencyEntry::CurrencyName currency_name);</div>
    264. 

  264. <div class="line"><a name="l00313"></a><span class="lineno">  313</span>&#160; </div>
    265. 

  265. <div class="line"><a name="l00318"></a><span class="lineno">  318</span>&#160;    <span class="keyword">const</span> QStringList <a class="code" href="class_a_database.html#a89de409c1828125363f46f384df47359">getCompletionList</a>(ADatabaseTarget target);</div>
    266. 

  266. <div class="line"><a name="l00319"></a><span class="lineno">  319</span>&#160; </div>
    267. 

  267. <div class="line"><a name="l00325"></a><span class="lineno">  325</span>&#160;    <span class="keyword">const</span> QMap&lt;RowId_T, QString&gt; <a class="code" href="class_a_database.html#afa8ce49693abf480f296d34dfc2969f0">getIdMap</a>(ADatabaseTarget target);</div>
    268. 

  268. <div class="line"><a name="l00326"></a><span class="lineno">  326</span>&#160; </div>
    269. 

  269. <div class="line"><a name="l00330"></a><span class="lineno">  330</span>&#160;    RowId_T <a class="code" href="class_a_database.html#a0497bb70998cea6cd60fa893880c9555">getLastEntry</a>(ADatabaseTable table);</div>
    270. 

  270. <div class="line"><a name="l00331"></a><span class="lineno">  331</span>&#160; </div>
    271. 

  271. <div class="line"><a name="l00336"></a><span class="lineno">  336</span>&#160;    QList&lt;RowId_T&gt; <a class="code" href="class_a_database.html#a0f88e121d421043f35e321d5dc49ba19">getForeignKeyConstraints</a>(RowId_T foreign_row_id, ADatabaseTable target);</div>
    272. 

  272. <div class="line"><a name="l00337"></a><span class="lineno">  337</span>&#160; </div>
    273. 

  273. <div class="line"><a name="l00342"></a><span class="lineno">  342</span>&#160;    <a class="code" href="struct_a_pilot_entry.html">APilotEntry</a> <a class="code" href="class_a_database.html#a4640a4348dad468a0ff65bad05b07227">resolveForeignPilot</a>(RowId_T foreign_key);</div>
    274. 

  274. <div class="line"><a name="l00343"></a><span class="lineno">  343</span>&#160; </div>
    275. 

  275. <div class="line"><a name="l00348"></a><span class="lineno">  348</span>&#160;    <a class="code" href="struct_a_tail_entry.html">ATailEntry</a> <a class="code" href="class_a_database.html#a5878bcd4bc19e4c3fc5275ca7252860d">resolveForeignTail</a>(RowId_T foreign_key);</div>
    276. 

  276. <div class="line"><a name="l00349"></a><span class="lineno">  349</span>&#160; </div>
    277. 

  277. <div class="line"><a name="l00358"></a><span class="lineno">  358</span>&#160;    QMap&lt;ADatabaseSummaryKey, QString&gt; <a class="code" href="class_a_database.html#a56baf4eaf25922030f3cfa6906963f7c">databaseSummary</a>(<span class="keyword">const</span> QString&amp; db_path);</div>
    278. 

  278. <div class="line"><a name="l00359"></a><span class="lineno">  359</span>&#160; </div>
    279. 

  279. <div class="line"><a name="l00363"></a><span class="lineno">  363</span>&#160;    <span class="keyword">const</span> QString <a class="code" href="class_a_database.html#a2c54b7506faf0f15f5323ed53ff12099">databaseSummaryString</a>(<span class="keyword">const</span> QString&amp; db_path);</div>
    280. 

  280. <div class="line"><a name="l00364"></a><span class="lineno">  364</span>&#160; </div>
    281. 

  281. <div class="line"><a name="l00365"></a><span class="lineno">  365</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a0bda52064f005f1463e56b60cd23b164">restoreBackup</a>(<span class="keyword">const</span> QString&amp; backup_file);</div>
    282. 

  282. <div class="line"><a name="l00366"></a><span class="lineno">  366</span>&#160;    <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a5ab838a62a83974f9e40c62f66adfa99">createBackup</a>(<span class="keyword">const</span> QString&amp; dest_file);</div>
    283. 

  283. <div class="line"><a name="l00367"></a><span class="lineno">  367</span>&#160; </div>
    284. 

  284. <div class="line"><a name="l00372"></a><span class="lineno">  372</span>&#160;    QVector&lt;RowData_T&gt; <a class="code" href="class_a_database.html#a8b38405b535d603cce2b36ca2d56368f">getTable</a>(ADatabaseTable table_name);</div>
    285. 

  285. <div class="line"><a name="l00373"></a><span class="lineno">  373</span>&#160; </div>
    286. 

  286. <div class="line"><a name="l00378"></a><span class="lineno">  378</span>&#160;    QStringList <a class="code" href="class_a_database.html#a692d7ba3abc763ee7c0d1a47236f021f">getUserTableNames</a>();</div>
    287. 

  287. <div class="line"><a name="l00379"></a><span class="lineno">  379</span>&#160; </div>
    288. 

  288. <div class="line"><a name="l00384"></a><span class="lineno">  384</span>&#160;    QStringList <a class="code" href="class_a_database.html#ad688f0e48bea4879a81e17a584f189b1">getTemplateTableNames</a>();</div>
    289. 

  289. <div class="line"><a name="l00385"></a><span class="lineno">  385</span>&#160; </div>
    290. 

  290. <div class="line"><a name="l00391"></a><span class="lineno">  391</span>&#160;    <a class="code" href="struct_user_data_state.html">UserDataState</a> <a class="code" href="class_a_database.html#a9da290c8488b35196ce4e49c4cfbe9f5">getUserDataState</a>();</div>
    291. 

  291. <div class="line"><a name="l00392"></a><span class="lineno">  392</span>&#160; </div>
    292. 

  292. <div class="line"><a name="l00396"></a><span class="lineno">  396</span>&#160;    <span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="class_a_database.html#ab99ccce4c67591f5f58832c26cf93fc8">getMinimumDatabaseRevision</a>();</div>
    293. 

  293. <div class="line"><a name="l00397"></a><span class="lineno">  397</span>&#160; </div>
    294. 

  294. <div class="line"><a name="l00398"></a><span class="lineno">  398</span>&#160;signals:</div>
    295. 

  295. <div class="line"><a name="l00405"></a><span class="lineno"><a class="line" href="class_a_database.html#a5ed8c010ccc022687ce903cfde8ae911">  405</a></span>&#160;    <span class="keywordtype">void</span> <a class="code" href="class_a_database.html#a5ed8c010ccc022687ce903cfde8ae911">dataBaseUpdated</a>();</div>
    296. 

  296. <div class="line"><a name="l00410"></a><span class="lineno"><a class="line" href="class_a_database.html#a0f0bffbb6cdd79975b7b5ca6c0db31a7">  410</a></span>&#160;    <span class="keywordtype">void</span> <a class="code" href="class_a_database.html#a0f0bffbb6cdd79975b7b5ca6c0db31a7">connectionReset</a>();</div>
    297. 

  297. <div class="line"><a name="l00411"></a><span class="lineno">  411</span>&#160;};</div>
    298. 

  298. <div class="line"><a name="l00412"></a><span class="lineno">  412</span>&#160; </div>
    299. 

  299. <div class="line"><a name="l00413"></a><span class="lineno">  413</span>&#160;<span class="preprocessor">#endif </span><span class="comment">// ADATABASE_H</span></div>
    300. 

  300. <div class="ttc" id="aclass_a_database_error_html"><div class="ttname"><a href="class_a_database_error.html">ADatabaseError</a></div><div class="ttdoc">Custom Database Error derived from QSqlError. Extends text() adding &quot;Database Error: &quot; before the tex...</div><div class="ttdef"><b>Definition:</b> adatabase.h:123</div></div>
    301. 

  301. <div class="ttc" id="aclass_a_database_html"><div class="ttname"><a href="class_a_database.html">ADatabase</a></div><div class="ttdoc">The DB class encapsulates the SQL database by providing fast access to hot database data.</div><div class="ttdef"><b>Definition:</b> adatabase.h:135</div></div>
    302. 

  302. <div class="ttc" id="aclass_a_database_html_a0497bb70998cea6cd60fa893880c9555"><div class="ttname"><a href="class_a_database.html#a0497bb70998cea6cd60fa893880c9555">ADatabase::getLastEntry</a></div><div class="ttdeci">RowId_T getLastEntry(ADatabaseTable table)</div><div class="ttdoc">returns the ROWID for the newest entry in the respective database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:600</div></div>
    303. 

  303. <div class="ttc" id="aclass_a_database_html_a0bda52064f005f1463e56b60cd23b164"><div class="ttname"><a href="class_a_database.html#a0bda52064f005f1463e56b60cd23b164">ADatabase::restoreBackup</a></div><div class="ttdeci">bool restoreBackup(const QString &amp;backup_file)</div><div class="ttdoc">ADatabase::restoreBackup restores the database from a given backup file and replaces the currently ac...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:848</div></div>
    304. 

  304. <div class="ttc" id="aclass_a_database_html_a0c5a017dccf7bf5d4dcbfc29c8d20e12"><div class="ttname"><a href="class_a_database.html#a0c5a017dccf7bf5d4dcbfc29c8d20e12">ADatabase::exists</a></div><div class="ttdeci">bool exists(const AEntry &amp;entry)</div><div class="ttdoc">Checks if an entry exists in the database, based on position data.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:253</div></div>
    305. 

  305. <div class="ttc" id="aclass_a_database_html_a0f0bffbb6cdd79975b7b5ca6c0db31a7"><div class="ttname"><a href="class_a_database.html#a0f0bffbb6cdd79975b7b5ca6c0db31a7">ADatabase::connectionReset</a></div><div class="ttdeci">void connectionReset()</div><div class="ttdoc">connectionReset is emitted whenever the database connection is reset, for example when creating or re...</div></div>
    306. 

  306. <div class="ttc" id="aclass_a_database_html_a0f88e121d421043f35e321d5dc49ba19"><div class="ttname"><a href="class_a_database.html#a0f88e121d421043f35e321d5dc49ba19">ADatabase::getForeignKeyConstraints</a></div><div class="ttdeci">QList&lt; RowId_T &gt; getForeignKeyConstraints(RowId_T foreign_row_id, ADatabaseTable target)</div><div class="ttdoc">returns a list of ROWID's in the flights table for which foreign key constraints exist.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:627</div></div>
    307. 

  307. <div class="ttc" id="aclass_a_database_html_a1c026e7784b03fc5822077c7d0071330"><div class="ttname"><a href="class_a_database.html#a1c026e7784b03fc5822077c7d0071330">ADatabase::dbRevision</a></div><div class="ttdeci">int dbRevision() const</div><div class="ttdoc">dbRevision returns the database Revision Number. The Revision refers to what iteration of the databas...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:45</div></div>
    308. 

  308. <div class="ttc" id="aclass_a_database_html_a2379c9da900da8e96add932e4024389a"><div class="ttname"><a href="class_a_database.html#a2379c9da900da8e96add932e4024389a">ADatabase::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> adatabase.cpp:168</div></div>
    309. 

  309. <div class="ttc" id="aclass_a_database_html_a2a43936d3ae28993f9f7eda0fdf4664d"><div class="ttname"><a href="class_a_database.html#a2a43936d3ae28993f9f7eda0fdf4664d">ADatabase::customQuery</a></div><div class="ttdeci">QVector&lt; QVariant &gt; customQuery(QString statement, int return_values)</div><div class="ttdoc">Can be used to send a complex query to the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:674</div></div>
    310. 

  310. <div class="ttc" id="aclass_a_database_html_a2c54b7506faf0f15f5323ed53ff12099"><div class="ttname"><a href="class_a_database.html#a2c54b7506faf0f15f5323ed53ff12099">ADatabase::databaseSummaryString</a></div><div class="ttdeci">const QString databaseSummaryString(const QString &amp;db_path)</div><div class="ttdoc">returns a short summary string of the database, containing total time and date of last flight.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:763</div></div>
    311. 

  311. <div class="ttc" id="aclass_a_database_html_a356df159542705635dc3898d90682039"><div class="ttname"><a href="class_a_database.html#a356df159542705635dc3898d90682039">ADatabase::getTailEntry</a></div><div class="ttdeci">ATailEntry getTailEntry(RowId_T row_id)</div><div class="ttdoc">retreives a TailEntry from the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:475</div></div>
    312. 

  312. <div class="ttc" id="aclass_a_database_html_a3c0fdc84000ad397d61f0efabd032194"><div class="ttname"><a href="class_a_database.html#a3c0fdc84000ad397d61f0efabd032194">ADatabase::updateLayout</a></div><div class="ttdeci">void updateLayout()</div><div class="ttdoc">Updates the member variables tableNames and tableColumns with up-to-date layout information if the da...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:98</div></div>
    313. 

  313. <div class="ttc" id="aclass_a_database_html_a3deb081c5abe832a65e1792c106eb083"><div class="ttname"><a href="class_a_database.html#a3deb081c5abe832a65e1792c106eb083">ADatabase::getTableNames</a></div><div class="ttdeci">const TableNames_T getTableNames() const</div><div class="ttdoc">Return the names of all tables in the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:93</div></div>
    314. 

  314. <div class="ttc" id="aclass_a_database_html_a426026d641a594863995ec5db8312259"><div class="ttname"><a href="class_a_database.html#a426026d641a594863995ec5db8312259">ADatabase::getPilotEntry</a></div><div class="ttdeci">APilotEntry getPilotEntry(RowId_T row_id)</div><div class="ttdoc">retreives a PilotEntry from the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:468</div></div>
    315. 

  315. <div class="ttc" id="aclass_a_database_html_a4640a4348dad468a0ff65bad05b07227"><div class="ttname"><a href="class_a_database.html#a4640a4348dad468a0ff65bad05b07227">ADatabase::resolveForeignPilot</a></div><div class="ttdeci">APilotEntry resolveForeignPilot(RowId_T foreign_key)</div><div class="ttdoc">Resolves the foreign key in a flight entry.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:664</div></div>
    316. 

  316. <div class="ttc" id="aclass_a_database_html_a491415273a771dd7ea41452c331a34b0"><div class="ttname"><a href="class_a_database.html#a491415273a771dd7ea41452c331a34b0">ADatabase::sqliteVersion</a></div><div class="ttdeci">const QString sqliteVersion() const</div><div class="ttdoc">ADatabase::sqliteVersion returns the database sqlite version. See also dbRevision()</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:124</div></div>
    317. 

  317. <div class="ttc" id="aclass_a_database_html_a4deda96cfb75518f98a4a0c9996920eb"><div class="ttname"><a href="class_a_database.html#a4deda96cfb75518f98a4a0c9996920eb">ADatabase::remove</a></div><div class="ttdeci">bool remove(const AEntry &amp;entry)</div><div class="ttdoc">deletes an entry from the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:182</div></div>
    318. 

  318. <div class="ttc" id="aclass_a_database_html_a56baf4eaf25922030f3cfa6906963f7c"><div class="ttname"><a href="class_a_database.html#a56baf4eaf25922030f3cfa6906963f7c">ADatabase::databaseSummary</a></div><div class="ttdeci">QMap&lt; ADatabaseSummaryKey, QString &gt; databaseSummary(const QString &amp;db_path)</div><div class="ttdoc">Return a summary of a database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:702</div></div>
    319. 

  319. <div class="ttc" id="aclass_a_database_html_a5878bcd4bc19e4c3fc5275ca7252860d"><div class="ttname"><a href="class_a_database.html#a5878bcd4bc19e4c3fc5275ca7252860d">ADatabase::resolveForeignTail</a></div><div class="ttdeci">ATailEntry resolveForeignTail(RowId_T foreign_key)</div><div class="ttdoc">Resolves the foreign key in a flight entry.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:669</div></div>
    320. 

  320. <div class="ttc" id="aclass_a_database_html_a5ab838a62a83974f9e40c62f66adfa99"><div class="ttname"><a href="class_a_database.html#a5ab838a62a83974f9e40c62f66adfa99">ADatabase::createBackup</a></div><div class="ttdeci">bool createBackup(const QString &amp;dest_file)</div><div class="ttdoc">ADatabase::createBackup copies the currently used database to an external backup location provided by...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:781</div></div>
    321. 

  321. <div class="ttc" id="aclass_a_database_html_a5abdf1f35468f788609252c7a3be7bc4"><div class="ttname"><a href="class_a_database.html#a5abdf1f35468f788609252c7a3be7bc4">ADatabase::getCurrencyEntry</a></div><div class="ttdeci">ACurrencyEntry getCurrencyEntry(ACurrencyEntry::CurrencyName currency_name)</div><div class="ttdoc">Retreives a currency entry from the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:496</div></div>
    322. 

  322. <div class="ttc" id="aclass_a_database_html_a5ed8c010ccc022687ce903cfde8ae911"><div class="ttname"><a href="class_a_database.html#a5ed8c010ccc022687ce903cfde8ae911">ADatabase::dataBaseUpdated</a></div><div class="ttdeci">void dataBaseUpdated()</div><div class="ttdoc">updated is emitted whenever the database contents have been updated. This can be either a commit,...</div></div>
    323. 

  323. <div class="ttc" id="aclass_a_database_html_a692d7ba3abc763ee7c0d1a47236f021f"><div class="ttname"><a href="class_a_database.html#a692d7ba3abc763ee7c0d1a47236f021f">ADatabase::getUserTableNames</a></div><div class="ttdeci">QStringList getUserTableNames()</div><div class="ttdoc">getUserTableNames returns a list of the table names of tables that contain user-created data (flights...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:83</div></div>
    324. 

  324. <div class="ttc" id="aclass_a_database_html_a73382f7e897f8381371cd3da458f72cc"><div class="ttname"><a href="class_a_database.html#a73382f7e897f8381371cd3da458f72cc">ADatabase::clear</a></div><div class="ttdeci">bool clear()</div><div class="ttdoc">clear resets the database, i.e. deletes all content in the tables containing userdata (pilots,...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:310</div></div>
    325. 

  325. <div class="ttc" id="aclass_a_database_html_a7bb44738362582e4f54f68e3aa30d40a"><div class="ttname"><a href="class_a_database.html#a7bb44738362582e4f54f68e3aa30d40a">ADatabase::getFlightEntry</a></div><div class="ttdeci">AFlightEntry getFlightEntry(RowId_T row_id)</div><div class="ttdoc">retreives a flight entry from the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:489</div></div>
    326. 

  326. <div class="ttc" id="aclass_a_database_html_a7d57d7696814bd013fa35e068ad909c8"><div class="ttname"><a href="class_a_database.html#a7d57d7696814bd013fa35e068ad909c8">ADatabase::commit</a></div><div class="ttdeci">bool commit(const AEntry &amp;entry)</div><div class="ttdoc">commits an entry to the database, calls either insert or update, based on position data</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:173</div></div>
    327. 

  327. <div class="ttc" id="aclass_a_database_html_a863d30e9e3a7c14adfe72787363618c8"><div class="ttname"><a href="class_a_database.html#a863d30e9e3a7c14adfe72787363618c8">ADatabase::removeMany</a></div><div class="ttdeci">bool removeMany(QList&lt; DataPosition &gt;)</div><div class="ttdoc">deletes a list of entries from the database. Optimised for speed when deleting many entries.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:210</div></div>
    328. 

  328. <div class="ttc" id="aclass_a_database_html_a88c8cb3d573d46c1ee8e5af61cf63224"><div class="ttname"><a href="class_a_database.html#a88c8cb3d573d46c1ee8e5af61cf63224">ADatabase::lastError</a></div><div class="ttdeci">QSqlError lastError</div><div class="ttdoc">Holds information about the last error that ocurred during a SQL operation. If the error type is QSql...</div><div class="ttdef"><b>Definition:</b> adatabase.h:159</div></div>
    329. 

  329. <div class="ttc" id="aclass_a_database_html_a8959b406b97d9520981890d92850b1ba"><div class="ttname"><a href="class_a_database.html#a8959b406b97d9520981890d92850b1ba">ADatabase::getEntry</a></div><div class="ttdeci">AEntry getEntry(DataPosition data_position)</div><div class="ttdoc">retreive an Entry from the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:461</div></div>
    330. 

  330. <div class="ttc" id="aclass_a_database_html_a89de409c1828125363f46f384df47359"><div class="ttname"><a href="class_a_database.html#a89de409c1828125363f46f384df47359">ADatabase::getCompletionList</a></div><div class="ttdeci">const QStringList getCompletionList(ADatabaseTarget target)</div><div class="ttdoc">getCompletionList returns a QStringList of values for a QCompleter based on database values</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:503</div></div>
    331. 

  331. <div class="ttc" id="aclass_a_database_html_a8b38405b535d603cce2b36ca2d56368f"><div class="ttname"><a href="class_a_database.html#a8b38405b535d603cce2b36ca2d56368f">ADatabase::getTable</a></div><div class="ttdeci">QVector&lt; RowData_T &gt; getTable(ADatabaseTable table_name)</div><div class="ttdoc">getTable returns all contents of a given table from the database</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:799</div></div>
    332. 

  332. <div class="ttc" id="aclass_a_database_html_a9c0dcd8c35087c8256b75d8aafa64880"><div class="ttname"><a href="class_a_database.html#a9c0dcd8c35087c8256b75d8aafa64880">ADatabase::getTableColumns</a></div><div class="ttdeci">const ColumnNames_T getTableColumns(TableName_T table_name) const</div><div class="ttdoc">Return the names of a given table in the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:88</div></div>
    333. 

  333. <div class="ttc" id="aclass_a_database_html_a9da290c8488b35196ce4e49c4cfbe9f5"><div class="ttname"><a href="class_a_database.html#a9da290c8488b35196ce4e49c4cfbe9f5">ADatabase::getUserDataState</a></div><div class="ttdeci">UserDataState getUserDataState()</div><div class="ttdoc">getUserDataState returns a struct containing the current amount of entries in the tails and pilots ta...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:67</div></div>
    334. 

  334. <div class="ttc" id="aclass_a_database_html_aa6080200aa3f229251480bc416755fed"><div class="ttname"><a href="class_a_database.html#aa6080200aa3f229251480bc416755fed">ADatabase::connect</a></div><div class="ttdeci">bool connect()</div><div class="ttdoc">Connect to the database and populate database information.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:133</div></div>
    335. 

  335. <div class="ttc" id="aclass_a_database_html_aa69dcdf174e48653cdf1bef473dc5623"><div class="ttname"><a href="class_a_database.html#aa69dcdf174e48653cdf1bef473dc5623">ADatabase::insert</a></div><div class="ttdeci">bool insert(const AEntry &amp;new_entry)</div><div class="ttdoc">Create new entry in the databse based on UserInput.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:360</div></div>
    336. 

  336. <div class="ttc" id="aclass_a_database_html_ab99ccce4c67591f5f58832c26cf93fc8"><div class="ttname"><a href="class_a_database.html#ab99ccce4c67591f5f58832c26cf93fc8">ADatabase::getMinimumDatabaseRevision</a></div><div class="ttdeci">static int getMinimumDatabaseRevision()</div><div class="ttdoc">getMinimumDatabaseRevision returns the minimum required database revision number required by the appl...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:57</div></div>
    337. 

  337. <div class="ttc" id="aclass_a_database_html_abc461aaa66304ca638e546f67a694935"><div class="ttname"><a href="class_a_database.html#abc461aaa66304ca638e546f67a694935">ADatabase::disconnect</a></div><div class="ttdeci">void disconnect()</div><div class="ttdoc">closes the database connection.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:161</div></div>
    338. 

  338. <div class="ttc" id="aclass_a_database_html_ac73208ba1a70af19590d53f260e7cb8c"><div class="ttname"><a href="class_a_database.html#ac73208ba1a70af19590d53f260e7cb8c">ADatabase::update</a></div><div class="ttdeci">bool update(const AEntry &amp;updated_entry)</div><div class="ttdoc">Updates entry in database from existing entry tweaked by the user.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:326</div></div>
    339. 

  339. <div class="ttc" id="aclass_a_database_html_ad688f0e48bea4879a81e17a584f189b1"><div class="ttname"><a href="class_a_database.html#ad688f0e48bea4879a81e17a584f189b1">ADatabase::getTemplateTableNames</a></div><div class="ttdeci">QStringList getTemplateTableNames()</div><div class="ttdoc">getTemplateTableNames returns a list of the table names of tables that contain template data (aiports...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:62</div></div>
    340. 

  340. <div class="ttc" id="aclass_a_database_html_ae0a3c9273431195df6295b9da24b3a3a"><div class="ttname"><a href="class_a_database.html#ae0a3c9273431195df6295b9da24b3a3a">ADatabase::getAircraftEntry</a></div><div class="ttdeci">AAircraftEntry getAircraftEntry(RowId_T row_id)</div><div class="ttdoc">retreives a TailEntry from the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:482</div></div>
    341. 

  341. <div class="ttc" id="aclass_a_database_html_afa8ce49693abf480f296d34dfc2969f0"><div class="ttname"><a href="class_a_database.html#afa8ce49693abf480f296d34dfc2969f0">ADatabase::getIdMap</a></div><div class="ttdeci">const QMap&lt; RowId_T, QString &gt; getIdMap(ADatabaseTarget target)</div><div class="ttdoc">returns a QMap of a human-readable database value and its row id. Used in the Dialogs to map user inp...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:552</div></div>
    342. 

  342. <div class="ttc" id="aclass_a_database_html_afc39f6136fc822e0649964fa22b84bf9"><div class="ttname"><a href="class_a_database.html#afc39f6136fc822e0649964fa22b84bf9">ADatabase::getEntryData</a></div><div class="ttdeci">RowData_T getEntryData(DataPosition data_position)</div><div class="ttdoc">retreive entry data from the database to create an entry object</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:404</div></div>
    343. 

  343. <div class="ttc" id="aclass_a_entry_html"><div class="ttname"><a href="class_a_entry.html">AEntry</a></div><div class="ttdoc">The Entry class encapsulates table metadata(table name, row id) and data for new and existing entries...</div><div class="ttdef"><b>Definition:</b> aentry.h:33</div></div>
    344. 

  344. <div class="ttc" id="aclass_a_flight_entry_html"><div class="ttname"><a href="class_a_flight_entry.html">AFlightEntry</a></div><div class="ttdef"><b>Definition:</b> aflightentry.h:23</div></div>
    345. 

  345. <div class="ttc" id="astruct_a_aircraft_entry_html"><div class="ttname"><a href="struct_a_aircraft_entry.html">AAircraftEntry</a></div><div class="ttdef"><b>Definition:</b> aaircraftentry.h:24</div></div>
    346. 

  346. <div class="ttc" id="astruct_a_currency_entry_html"><div class="ttname"><a href="struct_a_currency_entry.html">ACurrencyEntry</a></div><div class="ttdef"><b>Definition:</b> acurrencyentry.h:8</div></div>
    347. 

  347. <div class="ttc" id="astruct_a_pilot_entry_html"><div class="ttname"><a href="struct_a_pilot_entry.html">APilotEntry</a></div><div class="ttdef"><b>Definition:</b> apilotentry.h:24</div></div>
    348. 

  348. <div class="ttc" id="astruct_a_tail_entry_html"><div class="ttname"><a href="struct_a_tail_entry.html">ATailEntry</a></div><div class="ttdef"><b>Definition:</b> atailentry.h:24</div></div>
    349. 

  349. <div class="ttc" id="astruct_data_position_html"><div class="ttname"><a href="struct_data_position.html">DataPosition</a></div><div class="ttdef"><b>Definition:</b> adatabasetypes.h:44</div></div>
    350. 

  350. <div class="ttc" id="astruct_user_data_state_html"><div class="ttname"><a href="struct_user_data_state.html">UserDataState</a></div><div class="ttdoc">The UserDateState struct caches the current number of entries in relevant database tables for fast ac...</div><div class="ttdef"><b>Definition:</b> adatabase.h:97</div></div>
    351. 

  351. </div><!-- fragment --></div><!-- contents -->
    352. 

  352. </div><!-- doc-content -->
    353. 

  353. <!-- start footer part -->
    354. 

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

  355.   <ul>
    356. 

  356.     <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>adatabase.h</b></li>
    357. 

  357.     <li class="footer">Generated by <a href="https://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.9.1 </li>
    358. 

  358.   </ul>
    359. 

  359. </div>
    360. 

  360. </body>
    361. 

  361. </html>
    362.