<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.9.1"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>openPilotLog: src/database/adatabase.h Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtreedata.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="custom_dark_theme.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 56px;">
<td id="projectlogo"><img alt="Logo" src="icon_main.png"/></td>
<td id="projectalign" style="padding-left: 0.5em;">
<div id="projectname">openPilotLog
</div>
</td>
</tr>
</tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.9.1 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search','.html');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&dn=gpl-2.0.txt GPL-v2 */
$(function() {
initMenu('',true,false,'search.php','Search');
$(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
<div id="nav-tree">
<div id="nav-tree-contents">
<div id="nav-sync" class="sync"></div>
</div>
</div>
<div id="splitbar" style="-moz-user-select:none;"
class="ui-resizable-handle">
</div>
</div>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&dn=gpl-2.0.txt GPL-v2 */
$(document).ready(function(){initNavTree('adatabase_8h_source.html',''); initResizable(); });
/* @license-end */
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0"
name="MSearchResults" id="MSearchResults">
</iframe>
</div>
<div class="header">
<div class="headertitle">
<div class="title">adatabase.h</div> </div>
</div><!--header-->
<div class="contents">
<div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno"> 1</span> <span class="comment">/*</span></div>
<div class="line"><a name="l00002"></a><span class="lineno"> 2</span> <span class="comment"> *openPilotLog - A FOSS Pilot Logbook Application</span></div>
<div class="line"><a name="l00003"></a><span class="lineno"> 3</span> <span class="comment"> *Copyright (C) 2020-2021 Felix Turowsky</span></div>
<div class="line"><a name="l00004"></a><span class="lineno"> 4</span> <span class="comment"> *</span></div>
<div class="line"><a name="l00005"></a><span class="lineno"> 5</span> <span class="comment"> *This program is free software: you can redistribute it and/or modify</span></div>
<div class="line"><a name="l00006"></a><span class="lineno"> 6</span> <span class="comment"> *it under the terms of the GNU General Public License as published by</span></div>
<div class="line"><a name="l00007"></a><span class="lineno"> 7</span> <span class="comment"> *the Free Software Foundation, either version 3 of the License, or</span></div>
<div class="line"><a name="l00008"></a><span class="lineno"> 8</span> <span class="comment"> *(at your option) any later version.</span></div>
<div class="line"><a name="l00009"></a><span class="lineno"> 9</span> <span class="comment"> *</span></div>
<div class="line"><a name="l00010"></a><span class="lineno"> 10</span> <span class="comment"> *This program is distributed in the hope that it will be useful,</span></div>
<div class="line"><a name="l00011"></a><span class="lineno"> 11</span> <span class="comment"> *but WITHOUT ANY WARRANTY; without even the implied warranty of</span></div>
<div class="line"><a name="l00012"></a><span class="lineno"> 12</span> <span class="comment"> *MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the</span></div>
<div class="line"><a name="l00013"></a><span class="lineno"> 13</span> <span class="comment"> *GNU General Public License for more details.</span></div>
<div class="line"><a name="l00014"></a><span class="lineno"> 14</span> <span class="comment"> *</span></div>
<div class="line"><a name="l00015"></a><span class="lineno"> 15</span> <span class="comment"> *You should have received a copy of the GNU General Public License</span></div>
<div class="line"><a name="l00016"></a><span class="lineno"> 16</span> <span class="comment"> *along with this program. If not, see <https://www.gnu.org/licenses/>.</span></div>
<div class="line"><a name="l00017"></a><span class="lineno"> 17</span> <span class="comment"> */</span></div>
<div class="line"><a name="l00018"></a><span class="lineno"> 18</span> <span class="preprocessor">#ifndef ADATABASE_H</span></div>
<div class="line"><a name="l00019"></a><span class="lineno"> 19</span> <span class="preprocessor">#define ADATABASE_H</span></div>
<div class="line"><a name="l00020"></a><span class="lineno"> 20</span>  </div>
<div class="line"><a name="l00021"></a><span class="lineno"> 21</span> <span class="preprocessor">#include <QPair></span></div>
<div class="line"><a name="l00022"></a><span class="lineno"> 22</span> <span class="preprocessor">#include <QHash></span></div>
<div class="line"><a name="l00023"></a><span class="lineno"> 23</span> <span class="preprocessor">#include <QString></span></div>
<div class="line"><a name="l00024"></a><span class="lineno"> 24</span> <span class="preprocessor">#include <QDir></span></div>
<div class="line"><a name="l00025"></a><span class="lineno"> 25</span> <span class="preprocessor">#include <QSqlDatabase></span></div>
<div class="line"><a name="l00026"></a><span class="lineno"> 26</span> <span class="preprocessor">#include <QSqlDriver></span></div>
<div class="line"><a name="l00027"></a><span class="lineno"> 27</span> <span class="preprocessor">#include <QSqlQuery></span></div>
<div class="line"><a name="l00028"></a><span class="lineno"> 28</span> <span class="preprocessor">#include <QSqlError></span></div>
<div class="line"><a name="l00029"></a><span class="lineno"> 29</span> <span class="preprocessor">#include <QSqlTableModel></span></div>
<div class="line"><a name="l00030"></a><span class="lineno"> 30</span> <span class="preprocessor">#include <QSqlQuery></span></div>
<div class="line"><a name="l00031"></a><span class="lineno"> 31</span> <span class="preprocessor">#include <QSqlRecord></span></div>
<div class="line"><a name="l00032"></a><span class="lineno"> 32</span> <span class="preprocessor">#include <QSqlField></span></div>
<div class="line"><a name="l00033"></a><span class="lineno"> 33</span>  </div>
<div class="line"><a name="l00034"></a><span class="lineno"> 34</span> <span class="preprocessor">#include "src/database/adatabasetypes.h"</span></div>
<div class="line"><a name="l00035"></a><span class="lineno"> 35</span> <span class="preprocessor">#include "src/classes/aentry.h"</span></div>
<div class="line"><a name="l00036"></a><span class="lineno"> 36</span> <span class="preprocessor">#include "src/classes/apilotentry.h"</span></div>
<div class="line"><a name="l00037"></a><span class="lineno"> 37</span> <span class="preprocessor">#include "src/classes/atailentry.h"</span></div>
<div class="line"><a name="l00038"></a><span class="lineno"> 38</span> <span class="preprocessor">#include "src/classes/aaircraftentry.h"</span></div>
<div class="line"><a name="l00039"></a><span class="lineno"> 39</span> <span class="preprocessor">#include "src/classes/aflightentry.h"</span></div>
<div class="line"><a name="l00040"></a><span class="lineno"> 40</span> <span class="preprocessor">#include "src/classes/astandardpaths.h"</span></div>
<div class="line"><a name="l00041"></a><span class="lineno"> 41</span> <span class="preprocessor">#include "src/classes/acurrencyentry.h"</span></div>
<div class="line"><a name="l00042"></a><span class="lineno"> 42</span>  </div>
<div class="line"><a name="l00043"></a><span class="lineno"> 43</span> <span class="preprocessor">#define SQLITE_DRIVER QStringLiteral("QSQLITE"</span>)</div>
<div class="line"><a name="l00044"></a><span class="lineno"> 44</span>  </div>
<div class="line"><a name="l00052"></a><span class="lineno"> 52</span> <span class="preprocessor">#define aDB ADatabase::instance()</span></div>
<div class="line"><a name="l00053"></a><span class="lineno"> 53</span>  </div>
<div class="line"><a name="l00058"></a><span class="lineno"> 58</span> <span class="keyword">enum class</span> ADatabaseTarget</div>
<div class="line"><a name="l00059"></a><span class="lineno"> 59</span> {</div>
<div class="line"><a name="l00060"></a><span class="lineno"> 60</span>  airport_identifier_icao,</div>
<div class="line"><a name="l00061"></a><span class="lineno"> 61</span>  airport_identifier_iata,</div>
<div class="line"><a name="l00062"></a><span class="lineno"> 62</span>  airport_identifier_all,</div>
<div class="line"><a name="l00063"></a><span class="lineno"> 63</span>  airport_names,</div>
<div class="line"><a name="l00064"></a><span class="lineno"> 64</span>  registrations,</div>
<div class="line"><a name="l00065"></a><span class="lineno"> 65</span>  companies,</div>
<div class="line"><a name="l00066"></a><span class="lineno"> 66</span>  tails,</div>
<div class="line"><a name="l00067"></a><span class="lineno"> 67</span>  pilots,</div>
<div class="line"><a name="l00068"></a><span class="lineno"> 68</span>  aircraft</div>
<div class="line"><a name="l00069"></a><span class="lineno"> 69</span> };</div>
<div class="line"><a name="l00070"></a><span class="lineno"> 70</span>  </div>
<div class="line"><a name="l00071"></a><span class="lineno"> 71</span> <span class="keyword">enum class</span> ADatabaseTable</div>
<div class="line"><a name="l00072"></a><span class="lineno"> 72</span> {</div>
<div class="line"><a name="l00073"></a><span class="lineno"> 73</span>  tails,</div>
<div class="line"><a name="l00074"></a><span class="lineno"> 74</span>  flights,</div>
<div class="line"><a name="l00075"></a><span class="lineno"> 75</span>  currencies,</div>
<div class="line"><a name="l00076"></a><span class="lineno"> 76</span>  aircraft,</div>
<div class="line"><a name="l00077"></a><span class="lineno"> 77</span>  pilots,</div>
<div class="line"><a name="l00078"></a><span class="lineno"> 78</span> };</div>
<div class="line"><a name="l00079"></a><span class="lineno"> 79</span>  </div>
<div class="line"><a name="l00083"></a><span class="lineno"> 83</span> <span class="keyword">enum class</span> ADatabaseSummaryKey {</div>
<div class="line"><a name="l00084"></a><span class="lineno"> 84</span>  total_flights,</div>
<div class="line"><a name="l00085"></a><span class="lineno"> 85</span>  total_tails,</div>
<div class="line"><a name="l00086"></a><span class="lineno"> 86</span>  total_pilots,</div>
<div class="line"><a name="l00087"></a><span class="lineno"> 87</span>  last_flight,</div>
<div class="line"><a name="l00088"></a><span class="lineno"> 88</span>  total_time,</div>
<div class="line"><a name="l00089"></a><span class="lineno"> 89</span> };</div>
<div class="line"><a name="l00090"></a><span class="lineno"> 90</span>  </div>
<div class="line"><a name="l00097"></a><span class="lineno"><a class="line" href="struct_user_data_state.html"> 97</a></span> <span class="keyword">struct </span><a class="code" href="struct_user_data_state.html">UserDataState</a> {</div>
<div class="line"><a name="l00098"></a><span class="lineno"> 98</span>  </div>
<div class="line"><a name="l00099"></a><span class="lineno"> 99</span>  <a class="code" href="struct_user_data_state.html">UserDataState</a>(){numTails = 0; numPilots = 0;}</div>
<div class="line"><a name="l00100"></a><span class="lineno"> 100</span>  <a class="code" href="struct_user_data_state.html">UserDataState</a>(<span class="keywordtype">int</span> numTails_, <span class="keywordtype">int</span> numPilots_)</div>
<div class="line"><a name="l00101"></a><span class="lineno"> 101</span>  : numTails(numTails_), numPilots(numPilots_){}</div>
<div class="line"><a name="l00102"></a><span class="lineno"> 102</span>  </div>
<div class="line"><a name="l00103"></a><span class="lineno"> 103</span>  <span class="keywordtype">bool</span> operator==(<span class="keyword">const</span> <a class="code" href="struct_user_data_state.html">UserDataState</a>& other)</div>
<div class="line"><a name="l00104"></a><span class="lineno"> 104</span>  {</div>
<div class="line"><a name="l00105"></a><span class="lineno"> 105</span>  <span class="keywordflow">return</span> numTails == other.numTails && numPilots == other.numPilots;</div>
<div class="line"><a name="l00106"></a><span class="lineno"> 106</span>  }</div>
<div class="line"><a name="l00107"></a><span class="lineno"> 107</span>  <span class="keywordtype">bool</span> operator!=(<span class="keyword">const</span> <a class="code" href="struct_user_data_state.html">UserDataState</a>& other)</div>
<div class="line"><a name="l00108"></a><span class="lineno"> 108</span>  {</div>
<div class="line"><a name="l00109"></a><span class="lineno"> 109</span>  <span class="keywordflow">return</span> numTails != other.numTails || numPilots != other.numPilots;</div>
<div class="line"><a name="l00110"></a><span class="lineno"> 110</span>  }</div>
<div class="line"><a name="l00111"></a><span class="lineno"> 111</span>  </div>
<div class="line"><a name="l00112"></a><span class="lineno"> 112</span>  <span class="keywordtype">int</span> numTails;</div>
<div class="line"><a name="l00113"></a><span class="lineno"> 113</span>  <span class="keywordtype">int</span> numPilots;</div>
<div class="line"><a name="l00114"></a><span class="lineno"> 114</span> };</div>
<div class="line"><a name="l00115"></a><span class="lineno"> 115</span>  </div>
<div class="line"><a name="l00123"></a><span class="lineno"><a class="line" href="class_a_database_error.html"> 123</a></span> <span class="keyword">class </span><a class="code" href="class_a_database_error.html">ADatabaseError</a> : <span class="keyword">public</span> QSqlError {</div>
<div class="line"><a name="l00124"></a><span class="lineno"> 124</span> <span class="keyword">public</span>:</div>
<div class="line"><a name="l00125"></a><span class="lineno"> 125</span>  <a class="code" href="class_a_database_error.html">ADatabaseError</a>() = <span class="keywordflow">default</span>;</div>
<div class="line"><a name="l00126"></a><span class="lineno"> 126</span>  <a class="code" href="class_a_database_error.html">ADatabaseError</a>(QString msg);</div>
<div class="line"><a name="l00127"></a><span class="lineno"> 127</span>  QString text() <span class="keyword">const</span>;</div>
<div class="line"><a name="l00128"></a><span class="lineno"> 128</span>  <a class="code" href="class_a_database_error.html">ADatabaseError</a>(QSqlError);</div>
<div class="line"><a name="l00129"></a><span class="lineno"> 129</span> };</div>
<div class="line"><a name="l00130"></a><span class="lineno"> 130</span>  </div>
<div class="line"><a name="l00135"></a><span class="lineno"><a class="line" href="class_a_database.html"> 135</a></span> <span class="keyword">class </span><a class="code" href="class_a_database.html">ADatabase</a> : <span class="keyword">public</span> QObject {</div>
<div class="line"><a name="l00136"></a><span class="lineno"> 136</span>  Q_OBJECT</div>
<div class="line"><a name="l00137"></a><span class="lineno"> 137</span>  </div>
<div class="line"><a name="l00138"></a><span class="lineno"> 138</span> <span class="keyword">private</span>:</div>
<div class="line"><a name="l00139"></a><span class="lineno"> 139</span>  <span class="keyword">static</span> <a class="code" href="class_a_database.html">ADatabase</a>* <span class="keyword">self</span>;</div>
<div class="line"><a name="l00140"></a><span class="lineno"> 140</span>  TableNames_T tableNames;</div>
<div class="line"><a name="l00141"></a><span class="lineno"> 141</span>  TableColumns_T tableColumns;</div>
<div class="line"><a name="l00142"></a><span class="lineno"> 142</span>  <span class="keywordtype">int</span> databaseRevision;</div>
<div class="line"><a name="l00143"></a><span class="lineno"> 143</span>  </div>
<div class="line"><a name="l00144"></a><span class="lineno"> 144</span>  <a class="code" href="class_a_database.html">ADatabase</a>();</div>
<div class="line"><a name="l00145"></a><span class="lineno"> 145</span>  <span class="keywordtype">int</span> checkDbVersion() <span class="keyword">const</span>;</div>
<div class="line"><a name="l00146"></a><span class="lineno"> 146</span>  </div>
<div class="line"><a name="l00147"></a><span class="lineno"> 147</span>  <span class="keyword">const</span> <span class="keyword">static</span> QStringList userTableNames;</div>
<div class="line"><a name="l00148"></a><span class="lineno"> 148</span>  <span class="keyword">const</span> <span class="keyword">static</span> QStringList templateTableNames;</div>
<div class="line"><a name="l00149"></a><span class="lineno"> 149</span>  <span class="keyword">const</span> <span class="keyword">static</span> <span class="keywordtype">int</span> minimumDatabaseRevision;</div>
<div class="line"><a name="l00150"></a><span class="lineno"> 150</span> <span class="keyword">public</span>:</div>
<div class="line"><a name="l00159"></a><span class="lineno"><a class="line" href="class_a_database.html#a88c8cb3d573d46c1ee8e5af61cf63224"> 159</a></span>  QSqlError <a class="code" href="class_a_database.html#a88c8cb3d573d46c1ee8e5af61cf63224">lastError</a>;</div>
<div class="line"><a name="l00160"></a><span class="lineno"> 160</span>  </div>
<div class="line"><a name="l00161"></a><span class="lineno"> 161</span>  <span class="keyword">const</span> QFileInfo databaseFile;</div>
<div class="line"><a name="l00162"></a><span class="lineno"> 162</span>  </div>
<div class="line"><a name="l00163"></a><span class="lineno"> 163</span>  <span class="comment">// Ensure DB is not copiable or assignable</span></div>
<div class="line"><a name="l00164"></a><span class="lineno"> 164</span>  <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>&) = <span class="keyword">delete</span>;</div>
<div class="line"><a name="l00165"></a><span class="lineno"> 165</span>  <span class="keywordtype">void</span> operator=(<span class="keyword">const</span> <a class="code" href="class_a_database.html">ADatabase</a>&) = <span class="keyword">delete</span>;</div>
<div class="line"><a name="l00166"></a><span class="lineno"> 166</span>  <span class="keyword">static</span> <a class="code" href="class_a_database.html">ADatabase</a>* instance();</div>
<div class="line"><a name="l00167"></a><span class="lineno"> 167</span>  </div>
<div class="line"><a name="l00173"></a><span class="lineno"> 173</span>  <span class="keywordtype">int</span> <a class="code" href="class_a_database.html#a1c026e7784b03fc5822077c7d0071330">dbRevision</a>() <span class="keyword">const</span>;</div>
<div class="line"><a name="l00174"></a><span class="lineno"> 174</span>  </div>
<div class="line"><a name="l00178"></a><span class="lineno"> 178</span>  <span class="keyword">const</span> TableNames_T <a class="code" href="class_a_database.html#a3deb081c5abe832a65e1792c106eb083">getTableNames</a>() <span class="keyword">const</span>;</div>
<div class="line"><a name="l00179"></a><span class="lineno"> 179</span>  </div>
<div class="line"><a name="l00183"></a><span class="lineno"> 183</span>  <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>
<div class="line"><a name="l00184"></a><span class="lineno"> 184</span>  </div>
<div class="line"><a name="l00189"></a><span class="lineno"> 189</span>  <span class="keywordtype">void</span> <a class="code" href="class_a_database.html#a3c0fdc84000ad397d61f0efabd032194">updateLayout</a>();</div>
<div class="line"><a name="l00190"></a><span class="lineno"> 190</span>  </div>
<div class="line"><a name="l00195"></a><span class="lineno"> 195</span>  <span class="keyword">const</span> QString <a class="code" href="class_a_database.html#a491415273a771dd7ea41452c331a34b0">sqliteVersion</a>() <span class="keyword">const</span>;</div>
<div class="line"><a name="l00196"></a><span class="lineno"> 196</span>  </div>
<div class="line"><a name="l00200"></a><span class="lineno"> 200</span>  <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#aa6080200aa3f229251480bc416755fed">connect</a>();</div>
<div class="line"><a name="l00201"></a><span class="lineno"> 201</span>  </div>
<div class="line"><a name="l00205"></a><span class="lineno"> 205</span>  <span class="keywordtype">void</span> <a class="code" href="class_a_database.html#abc461aaa66304ca638e546f67a694935">disconnect</a>();</div>
<div class="line"><a name="l00206"></a><span class="lineno"> 206</span>  </div>
<div class="line"><a name="l00211"></a><span class="lineno"> 211</span>  <span class="keyword">static</span> QSqlDatabase <a class="code" href="class_a_database.html#a2379c9da900da8e96add932e4024389a">database</a>();</div>
<div class="line"><a name="l00212"></a><span class="lineno"> 212</span>  </div>
<div class="line"><a name="l00218"></a><span class="lineno"> 218</span>  QVector<QVariant> <a class="code" href="class_a_database.html#a2a43936d3ae28993f9f7eda0fdf4664d">customQuery</a>(QString statement, <span class="keywordtype">int</span> return_values);</div>
<div class="line"><a name="l00219"></a><span class="lineno"> 219</span>  </div>
<div class="line"><a name="l00223"></a><span class="lineno"> 223</span>  <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> &entry);</div>
<div class="line"><a name="l00224"></a><span class="lineno"> 224</span>  <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>
<div class="line"><a name="l00225"></a><span class="lineno"> 225</span>  </div>
<div class="line"><a name="l00230"></a><span class="lineno"> 230</span>  <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a73382f7e897f8381371cd3da458f72cc">clear</a>();</div>
<div class="line"><a name="l00231"></a><span class="lineno"> 231</span>  </div>
<div class="line"><a name="l00236"></a><span class="lineno"> 236</span>  <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> &entry);</div>
<div class="line"><a name="l00237"></a><span class="lineno"> 237</span>  </div>
<div class="line"><a name="l00241"></a><span class="lineno"> 241</span>  <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> &new_entry);</div>
<div class="line"><a name="l00242"></a><span class="lineno"> 242</span>  </div>
<div class="line"><a name="l00246"></a><span class="lineno"> 246</span>  <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> &updated_entry);</div>
<div class="line"><a name="l00247"></a><span class="lineno"> 247</span>  </div>
<div class="line"><a name="l00251"></a><span class="lineno"> 251</span>  <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> &entry);</div>
<div class="line"><a name="l00252"></a><span class="lineno"> 252</span>  </div>
<div class="line"><a name="l00257"></a><span class="lineno"> 257</span>  <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a863d30e9e3a7c14adfe72787363618c8">removeMany</a>(QList<DataPosition>);</div>
<div class="line"><a name="l00258"></a><span class="lineno"> 258</span>  </div>
<div class="line"><a name="l00262"></a><span class="lineno"> 262</span>  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>
<div class="line"><a name="l00263"></a><span class="lineno"> 263</span>  </div>
<div class="line"><a name="l00267"></a><span class="lineno"> 267</span>  <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>
<div class="line"><a name="l00268"></a><span class="lineno"> 268</span>  </div>
<div class="line"><a name="l00277"></a><span class="lineno"> 277</span>  <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>
<div class="line"><a name="l00278"></a><span class="lineno"> 278</span>  </div>
<div class="line"><a name="l00287"></a><span class="lineno"> 287</span>  <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>
<div class="line"><a name="l00288"></a><span class="lineno"> 288</span>  </div>
<div class="line"><a name="l00297"></a><span class="lineno"> 297</span>  <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>
<div class="line"><a name="l00298"></a><span class="lineno"> 298</span>  </div>
<div class="line"><a name="l00307"></a><span class="lineno"> 307</span>  <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>
<div class="line"><a name="l00308"></a><span class="lineno"> 308</span>  </div>
<div class="line"><a name="l00312"></a><span class="lineno"> 312</span>  <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>
<div class="line"><a name="l00313"></a><span class="lineno"> 313</span>  </div>
<div class="line"><a name="l00318"></a><span class="lineno"> 318</span>  <span class="keyword">const</span> QStringList <a class="code" href="class_a_database.html#a89de409c1828125363f46f384df47359">getCompletionList</a>(ADatabaseTarget target);</div>
<div class="line"><a name="l00319"></a><span class="lineno"> 319</span>  </div>
<div class="line"><a name="l00324"></a><span class="lineno"> 324</span>  <span class="keyword">const</span> QHash<RowId_T, QString> <a class="code" href="class_a_database.html#afaaaaf276d832833b0865db86de51ae5">getIdMap</a>(ADatabaseTarget target);</div>
<div class="line"><a name="l00325"></a><span class="lineno"> 325</span>  </div>
<div class="line"><a name="l00329"></a><span class="lineno"> 329</span>  RowId_T <a class="code" href="class_a_database.html#a0497bb70998cea6cd60fa893880c9555">getLastEntry</a>(ADatabaseTable table);</div>
<div class="line"><a name="l00330"></a><span class="lineno"> 330</span>  </div>
<div class="line"><a name="l00335"></a><span class="lineno"> 335</span>  QList<RowId_T> <a class="code" href="class_a_database.html#a0f88e121d421043f35e321d5dc49ba19">getForeignKeyConstraints</a>(RowId_T foreign_row_id, ADatabaseTable target);</div>
<div class="line"><a name="l00336"></a><span class="lineno"> 336</span>  </div>
<div class="line"><a name="l00341"></a><span class="lineno"> 341</span>  <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>
<div class="line"><a name="l00342"></a><span class="lineno"> 342</span>  </div>
<div class="line"><a name="l00347"></a><span class="lineno"> 347</span>  <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>
<div class="line"><a name="l00348"></a><span class="lineno"> 348</span>  </div>
<div class="line"><a name="l00357"></a><span class="lineno"> 357</span>  QMap<ADatabaseSummaryKey, QString> <a class="code" href="class_a_database.html#a56baf4eaf25922030f3cfa6906963f7c">databaseSummary</a>(<span class="keyword">const</span> QString& db_path);</div>
<div class="line"><a name="l00358"></a><span class="lineno"> 358</span>  </div>
<div class="line"><a name="l00362"></a><span class="lineno"> 362</span>  <span class="keyword">const</span> QString <a class="code" href="class_a_database.html#a2c54b7506faf0f15f5323ed53ff12099">databaseSummaryString</a>(<span class="keyword">const</span> QString& db_path);</div>
<div class="line"><a name="l00363"></a><span class="lineno"> 363</span>  </div>
<div class="line"><a name="l00364"></a><span class="lineno"> 364</span>  <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a0bda52064f005f1463e56b60cd23b164">restoreBackup</a>(<span class="keyword">const</span> QString& backup_file);</div>
<div class="line"><a name="l00365"></a><span class="lineno"> 365</span>  <span class="keywordtype">bool</span> <a class="code" href="class_a_database.html#a5ab838a62a83974f9e40c62f66adfa99">createBackup</a>(<span class="keyword">const</span> QString& dest_file);</div>
<div class="line"><a name="l00366"></a><span class="lineno"> 366</span>  </div>
<div class="line"><a name="l00371"></a><span class="lineno"> 371</span>  QVector<RowData_T> <a class="code" href="class_a_database.html#a8b38405b535d603cce2b36ca2d56368f">getTable</a>(ADatabaseTable table_name);</div>
<div class="line"><a name="l00372"></a><span class="lineno"> 372</span>  </div>
<div class="line"><a name="l00377"></a><span class="lineno"> 377</span>  QStringList <a class="code" href="class_a_database.html#a692d7ba3abc763ee7c0d1a47236f021f">getUserTableNames</a>();</div>
<div class="line"><a name="l00378"></a><span class="lineno"> 378</span>  </div>
<div class="line"><a name="l00383"></a><span class="lineno"> 383</span>  QStringList <a class="code" href="class_a_database.html#ad688f0e48bea4879a81e17a584f189b1">getTemplateTableNames</a>();</div>
<div class="line"><a name="l00384"></a><span class="lineno"> 384</span>  </div>
<div class="line"><a name="l00390"></a><span class="lineno"> 390</span>  <a class="code" href="struct_user_data_state.html">UserDataState</a> <a class="code" href="class_a_database.html#a9da290c8488b35196ce4e49c4cfbe9f5">getUserDataState</a>();</div>
<div class="line"><a name="l00391"></a><span class="lineno"> 391</span>  </div>
<div class="line"><a name="l00395"></a><span class="lineno"> 395</span>  <span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="class_a_database.html#ab99ccce4c67591f5f58832c26cf93fc8">getMinimumDatabaseRevision</a>();</div>
<div class="line"><a name="l00396"></a><span class="lineno"> 396</span>  </div>
<div class="line"><a name="l00397"></a><span class="lineno"> 397</span> signals:</div>
<div class="line"><a name="l00404"></a><span class="lineno"><a class="line" href="class_a_database.html#a5ed8c010ccc022687ce903cfde8ae911"> 404</a></span>  <span class="keywordtype">void</span> <a class="code" href="class_a_database.html#a5ed8c010ccc022687ce903cfde8ae911">dataBaseUpdated</a>();</div>
<div class="line"><a name="l00409"></a><span class="lineno"><a class="line" href="class_a_database.html#a0f0bffbb6cdd79975b7b5ca6c0db31a7"> 409</a></span>  <span class="keywordtype">void</span> <a class="code" href="class_a_database.html#a0f0bffbb6cdd79975b7b5ca6c0db31a7">connectionReset</a>();</div>
<div class="line"><a name="l00410"></a><span class="lineno"> 410</span> };</div>
<div class="line"><a name="l00411"></a><span class="lineno"> 411</span>  </div>
<div class="line"><a name="l00412"></a><span class="lineno"> 412</span> <span class="preprocessor">#endif </span><span class="comment">// ADATABASE_H</span></div>
<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 "Database Error: " before the tex...</div><div class="ttdef"><b>Definition:</b> adatabase.h:123</div></div>
<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>
<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>
<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 &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>
<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 &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>
<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>
<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< RowId_T > 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>
<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>
<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>
<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< QVariant > 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>
<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 &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>
<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>
<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>
<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>
<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>
<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>
<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>
<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 &entry)</div><div class="ttdoc">deletes an entry from the database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:182</div></div>
<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< ADatabaseSummaryKey, QString > databaseSummary(const QString &db_path)</div><div class="ttdoc">Return a summary of a database.</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:702</div></div>
<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>
<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 &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>
<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>
<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>
<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>
<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>
<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>
<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 &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>
<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< DataPosition >)</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>
<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>
<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>
<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>
<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< RowData_T > 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>
<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>
<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>
<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>
<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 &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>
<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>
<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>
<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 &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>
<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>
<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>
<div class="ttc" id="aclass_a_database_html_afaaaaf276d832833b0865db86de51ae5"><div class="ttname"><a href="class_a_database.html#afaaaaf276d832833b0865db86de51ae5">ADatabase::getIdMap</a></div><div class="ttdeci">const QHash< RowId_T, QString > getIdMap(ADatabaseTarget target)</div><div class="ttdoc">returns a QHash of a human-readable database value and its row id. Used in the Dialogs to map user in...</div><div class="ttdef"><b>Definition:</b> adatabase.cpp:552</div></div>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
</div><!-- fragment --></div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
<ul>
<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>
<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>
</ul>
</div>
</body>
</html>