sweproj.com
/
openPilotLog
mirror da https://github.com/fiffty-50/openPilotLog


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604
							<!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: aDbSetup Namespace Reference</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&amp;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&amp;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&amp;dn=gpl-2.0.txt GPL-v2 */
$(document).ready(function(){initNavTree('namespacea_db_setup.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="summary">
<a href="#func-members">Functions</a> &#124;
<a href="#var-members">Variables</a>  </div>
  <div class="headertitle">
<div class="title">aDbSetup Namespace Reference</div>  </div>
</div><!--header-->
<div class="contents">

<p>The <a class="el" href="namespacea_db_setup.html" title="The aDbSetup namespace is responsible for the inital setup of the database when the application is fi...">aDbSetup</a> namespace is responsible for the inital setup of the database when the application is first launched. It creates the database in the specified default location and creates all required tables and views.  
<a href="namespacea_db_setup.html#details">More...</a></p>
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a>
Functions</h2></td></tr>
<tr class="memitem:ae1411575e4c2773a578c78e8f02574ed"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="namespacea_db_setup.html#ae1411575e4c2773a578c78e8f02574ed">createDatabase</a> ()</td></tr>
<tr class="memdesc:ae1411575e4c2773a578c78e8f02574ed"><td class="mdescLeft">&#160;</td><td class="mdescRight">createDatabase runs a number of CREATE queries that create the database tables and columns.  <a href="namespacea_db_setup.html#ae1411575e4c2773a578c78e8f02574ed">More...</a><br /></td></tr>
<tr class="separator:ae1411575e4c2773a578c78e8f02574ed"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a6bc782f35cc58b815a1e01134c885839"><td class="memItemLeft" align="right" valign="top"><a id="a6bc782f35cc58b815a1e01134c885839"></a>
bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="namespacea_db_setup.html#a6bc782f35cc58b815a1e01134c885839">commitData</a> (const QJsonArray &amp;json_arr, const QString &amp;table_name)</td></tr>
<tr class="memdesc:a6bc782f35cc58b815a1e01134c885839"><td class="mdescLeft">&#160;</td><td class="mdescRight">commitData commits the data read from a JSON file into a table in the database. <br /></td></tr>
<tr class="separator:a6bc782f35cc58b815a1e01134c885839"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a97547c296b43543df163411cd423c945"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="namespacea_db_setup.html#a97547c296b43543df163411cd423c945">importTemplateData</a> (bool use_local_ressources)</td></tr>
<tr class="memdesc:a97547c296b43543df163411cd423c945"><td class="mdescLeft">&#160;</td><td class="mdescRight">importTemplateData fills an empty database with the template data (Aircraft, Airports, currencies, changelog) as read from the JSON templates.  <a href="namespacea_db_setup.html#a97547c296b43543df163411cd423c945">More...</a><br /></td></tr>
<tr class="separator:a97547c296b43543df163411cd423c945"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9bfda68f87c3558ca1a0590515ece3fa"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="namespacea_db_setup.html#a9bfda68f87c3558ca1a0590515ece3fa">resetUserData</a> ()</td></tr>
<tr class="memdesc:a9bfda68f87c3558ca1a0590515ece3fa"><td class="mdescLeft">&#160;</td><td class="mdescRight">Empties all user-generated content in the database.  <a href="namespacea_db_setup.html#a9bfda68f87c3558ca1a0590515ece3fa">More...</a><br /></td></tr>
<tr class="separator:a9bfda68f87c3558ca1a0590515ece3fa"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="var-members"></a>
Variables</h2></td></tr>
<tr class="memitem:ab42f6ad596e4ec9bd5606490eff9fffd"><td class="memItemLeft" align="right" valign="top"><a id="ab42f6ad596e4ec9bd5606490eff9fffd"></a>
const auto&#160;</td><td class="memItemRight" valign="bottom"><b>TEMPLATE_URL</b> = QStringLiteral(&quot;https://raw.githubusercontent.com/fiffty-50/openpilotlog/develop/assets/database/templates/&quot;)</td></tr>
<tr class="separator:ab42f6ad596e4ec9bd5606490eff9fffd"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a92853be9c8cfe9ae428e5d79d9d5ea95"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_TABLE_PILOTS</b></td></tr>
<tr class="separator:a92853be9c8cfe9ae428e5d79d9d5ea95"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1301f49be2056754da4635602c9fd4a6"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_TABLE_TAILS</b></td></tr>
<tr class="separator:a1301f49be2056754da4635602c9fd4a6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a7a78ba3087491fb861116899b39e0f09"><td class="memItemLeft" align="right" valign="top"><a id="a7a78ba3087491fb861116899b39e0f09"></a>
const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_TABLE_FLIGHTS</b></td></tr>
<tr class="separator:a7a78ba3087491fb861116899b39e0f09"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ae26691f30082a43c7391a38bc2f6beb4"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_TABLE_AIRPORTS</b></td></tr>
<tr class="separator:ae26691f30082a43c7391a38bc2f6beb4"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a6b372f962cbd0041aee66b872dca53c6"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_TABLE_AIRCRAFT</b></td></tr>
<tr class="separator:a6b372f962cbd0041aee66b872dca53c6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad8acdf028108423b3074874f0af7e7e9"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_TABLE_CHANGELOG</b></td></tr>
<tr class="separator:ad8acdf028108423b3074874f0af7e7e9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a07dfa851b369efb84edd11d62b383d2c"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_TABLE_CURRENCIES</b></td></tr>
<tr class="separator:a07dfa851b369efb84edd11d62b383d2c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aab709b285b4f9e1bdfa38f7326be9fa9"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_VIEW_DEFAULT</b></td></tr>
<tr class="separator:aab709b285b4f9e1bdfa38f7326be9fa9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a86ada1d82cb4f647502002861d8870de"><td class="memItemLeft" align="right" valign="top"><a id="a86ada1d82cb4f647502002861d8870de"></a>
const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_VIEW_EASA</b></td></tr>
<tr class="separator:a86ada1d82cb4f647502002861d8870de"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a91632c67cd4c2380f4b8e5db3d02ad06"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_VIEW_TAILS</b></td></tr>
<tr class="separator:a91632c67cd4c2380f4b8e5db3d02ad06"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a0ec8cecdd8579ad8595d9695a65fbda0"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_VIEW_PILOTS</b></td></tr>
<tr class="separator:a0ec8cecdd8579ad8595d9695a65fbda0"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a4510c99ccc63a6c3f2df852217fb49c5"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_VIEW_QCOMPLETER</b></td></tr>
<tr class="separator:a4510c99ccc63a6c3f2df852217fb49c5"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a92a9e9462f9ebb0659a6d963f9dba055"><td class="memItemLeft" align="right" valign="top">const auto&#160;</td><td class="memItemRight" valign="bottom"><b>CREATE_VIEW_TOTALS</b></td></tr>
<tr class="separator:a92a9e9462f9ebb0659a6d963f9dba055"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa652dda29984360bdc05d15bb18ab99d"><td class="memItemLeft" align="right" valign="top">const QList&lt; QLatin1String &gt;&#160;</td><td class="memItemRight" valign="bottom"><b>DATABASE_TABLES</b></td></tr>
<tr class="separator:aa652dda29984360bdc05d15bb18ab99d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a68c1e8239ce0a8ac921a8302a12a7f1e"><td class="memItemLeft" align="right" valign="top">const QList&lt; QLatin1String &gt;&#160;</td><td class="memItemRight" valign="bottom"><b>DATABASE_VIEWS</b></td></tr>
<tr class="separator:a68c1e8239ce0a8ac921a8302a12a7f1e"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:adf7f35dafacdf318978b8aefb8ae8198"><td class="memItemLeft" align="right" valign="top">const QList&lt; QLatin1String &gt;&#160;</td><td class="memItemRight" valign="bottom"><b>USER_TABLES</b></td></tr>
<tr class="separator:adf7f35dafacdf318978b8aefb8ae8198"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a161c7916698832075f4b63e92e5c273a"><td class="memItemLeft" align="right" valign="top">const QList&lt; QLatin1String &gt;&#160;</td><td class="memItemRight" valign="bottom"><b>TEMPLATE_TABLES</b></td></tr>
<tr class="separator:a161c7916698832075f4b63e92e5c273a"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<div class="textblock"><p>The <a class="el" href="namespacea_db_setup.html" title="The aDbSetup namespace is responsible for the inital setup of the database when the application is fi...">aDbSetup</a> namespace is responsible for the inital setup of the database when the application is first launched. It creates the database in the specified default location and creates all required tables and views. </p>
</div><h2 class="groupheader">Function Documentation</h2>
<a id="ae1411575e4c2773a578c78e8f02574ed"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ae1411575e4c2773a578c78e8f02574ed">&#9670;&nbsp;</a></span>createDatabase()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">bool aDbSetup::createDatabase </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>createDatabase runs a number of CREATE queries that create the database tables and columns. </p>
<dl class="section return"><dt>Returns</dt><dd></dd></dl>

</div>
</div>
<a id="a97547c296b43543df163411cd423c945"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a97547c296b43543df163411cd423c945">&#9670;&nbsp;</a></span>importTemplateData()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">bool aDbSetup::importTemplateData </td>
          <td>(</td>
          <td class="paramtype">bool&#160;</td>
          <td class="paramname"><em>use_local_ressources</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>importTemplateData fills an empty database with the template data (Aircraft, Airports, currencies, changelog) as read from the JSON templates. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">use_local_ressources</td><td>determines whether the included ressource files or a previously downloaded file should be used. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd></dd></dl>

</div>
</div>
<a id="a9bfda68f87c3558ca1a0590515ece3fa"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a9bfda68f87c3558ca1a0590515ece3fa">&#9670;&nbsp;</a></span>resetUserData()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">bool aDbSetup::resetUserData </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Empties all user-generated content in the database. </p>
<dl class="section return"><dt>Returns</dt><dd>true on success </dd></dl>

</div>
</div>
<h2 class="groupheader">Variable Documentation</h2>
<a id="a6b372f962cbd0041aee66b872dca53c6"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a6b372f962cbd0041aee66b872dca53c6">&#9670;&nbsp;</a></span>CREATE_TABLE_AIRCRAFT</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_TABLE_AIRCRAFT</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE TABLE aircraft (&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; aircraft_id   INTEGER NOT NULL,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; make          TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; model         TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; variant       TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; name          TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; iata          TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; icao          TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; multipilot    INTEGER,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; multiengine   INTEGER,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; engineType    INTEGER,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; weightClass   INTEGER,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; PRIMARY KEY(aircraft_id AUTOINCREMENT)&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot;)&quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="ae26691f30082a43c7391a38bc2f6beb4"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ae26691f30082a43c7391a38bc2f6beb4">&#9670;&nbsp;</a></span>CREATE_TABLE_AIRPORTS</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_TABLE_AIRPORTS</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE TABLE airports ( &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; airport_id     INTEGER NOT NULL, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; icao           TEXT NOT NULL, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; iata           TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; name           TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; lat            REAL, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; long           REAL, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; country        TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; alt            INTEGER, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; utcoffset      INTEGER, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; tzolson        TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; PRIMARY KEY(airport_id AUTOINCREMENT) &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot;)&quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="ad8acdf028108423b3074874f0af7e7e9"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ad8acdf028108423b3074874f0af7e7e9">&#9670;&nbsp;</a></span>CREATE_TABLE_CHANGELOG</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_TABLE_CHANGELOG</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE TABLE changelog ( &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; revision   INTEGER NOT NULL, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; comment    TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; date       NUMERIC, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; PRIMARY KEY(revision) &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot;)&quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="a07dfa851b369efb84edd11d62b383d2c"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a07dfa851b369efb84edd11d62b383d2c">&#9670;&nbsp;</a></span>CREATE_TABLE_CURRENCIES</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_TABLE_CURRENCIES</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE TABLE currencies ( &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; currency_id   INTEGER PRIMARY KEY AUTOINCREMENT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; description   TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; expiryDate     NUMERIC &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot;)&quot;</span></div>
<div class="line">            )</div>
</div><!-- fragment -->
</div>
</div>
<a id="a92853be9c8cfe9ae428e5d79d9d5ea95"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a92853be9c8cfe9ae428e5d79d9d5ea95">&#9670;&nbsp;</a></span>CREATE_TABLE_PILOTS</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_TABLE_PILOTS</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE TABLE pilots ( &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; pilot_id       INTEGER NOT NULL, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; lastname       TEXT    NOT NULL, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; firstname      TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; alias          TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; company        TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; employeeid     TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; phone          TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; email          TEXT, &quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; PRIMARY KEY(pilot_id AUTOINCREMENT)&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot;)&quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="a1301f49be2056754da4635602c9fd4a6"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a1301f49be2056754da4635602c9fd4a6">&#9670;&nbsp;</a></span>CREATE_TABLE_TAILS</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_TABLE_TAILS</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE TABLE tails (&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; tail_id        INTEGER NOT NULL,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; registration   TEXT NOT NULL,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; company        TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; make           TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; model          TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; variant        TEXT,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; multipilot     INTEGER,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; multiengine    INTEGER,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; engineType     INTEGER,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; weightClass    INTEGER,&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot; PRIMARY KEY(tail_id AUTOINCREMENT)&quot;</span></div>
<div class="line">            <span class="stringliteral">&quot;)&quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="aab709b285b4f9e1bdfa38f7326be9fa9"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aab709b285b4f9e1bdfa38f7326be9fa9">&#9670;&nbsp;</a></span>CREATE_VIEW_DEFAULT</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_VIEW_DEFAULT</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE VIEW viewDefault AS &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; SELECT flight_id, doft as &#39;Date&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; dept AS &#39;Dept&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(&#39;%02d&#39;,(tofb/60))||&#39;:&#39;||printf(&#39;%02d&#39;,(tofb%60)) AS &#39;Time&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; dest AS &#39;Dest&#39;, printf(&#39;%02d&#39;,(tonb/60))||&#39;:&#39;||printf(&#39;%02d&#39;,(tonb%60)) AS &#39;Time &#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(&#39;%02d&#39;,(tblk/60))||&#39;:&#39;||printf(&#39;%02d&#39;,(tblk%60)) AS &#39;Total&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; CASE &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; WHEN pilot_id = 1 THEN alias &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; ELSE lastname||&#39;, &#39;||substr(firstname, 1, 1)||&#39;.&#39; &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; END &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; AS &#39;Name PIC&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; CASE &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; WHEN variant IS NOT NULL THEN make||&#39; &#39;||model||&#39;-&#39;||variant &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; ELSE make||&#39; &#39;||model &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; END &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; AS &#39;Type&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; registration AS &#39;Registration&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; FlightNumber AS &#39;Flight #&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; remarks AS &#39;Remarks&#39;&quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; FROM flights &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; INNER JOIN pilots on flights.pic = pilots.pilot_id &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; INNER JOIN tails on flights.acft = tails.tail_id &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; ORDER BY date DESC &quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="a0ec8cecdd8579ad8595d9695a65fbda0"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a0ec8cecdd8579ad8595d9695a65fbda0">&#9670;&nbsp;</a></span>CREATE_VIEW_PILOTS</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_VIEW_PILOTS</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE VIEW viewPilots AS &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; SELECT &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; pilot_id AS &#39;ID&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; lastname AS &#39;Last Name&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; firstname AS &#39;First Name&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; company AS &#39;Company&#39; &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; FROM pilots&quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="a4510c99ccc63a6c3f2df852217fb49c5"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a4510c99ccc63a6c3f2df852217fb49c5">&#9670;&nbsp;</a></span>CREATE_VIEW_QCOMPLETER</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_VIEW_QCOMPLETER</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE VIEW viewQCompleter AS &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; SELECT airport_id, icao, iata, tail_id, registration, pilot_id, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; lastname||&#39;, &#39;||firstname AS &#39;pilot_name&#39;, alias &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; FROM airports &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; LEFT JOIN tails ON airports.airport_id = tails.tail_id &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; LEFT JOIN pilots ON airports.airport_id = pilots.pilot_id&quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="a91632c67cd4c2380f4b8e5db3d02ad06"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a91632c67cd4c2380f4b8e5db3d02ad06">&#9670;&nbsp;</a></span>CREATE_VIEW_TAILS</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_VIEW_TAILS</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE VIEW viewTails AS &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; SELECT &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; tail_id AS &#39;ID&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; registration AS &#39;Registration&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; make||&#39; &#39;||model AS &#39;Type&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; company AS &#39;Company&#39; &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; FROM tails WHERE model IS NOT NULL AND variant IS NULL &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; UNION &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; SELECT &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; tail_id AS &#39;ID&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; registration AS &#39;Registration&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; make||&#39; &#39;||model||&#39;-&#39;||variant AS &#39;Type&#39;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; company AS &#39;Company&#39; &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; FROM tails WHERE variant IS NOT NULL&quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="a92a9e9462f9ebb0659a6d963f9dba055"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a92a9e9462f9ebb0659a6d963f9dba055">&#9670;&nbsp;</a></span>CREATE_VIEW_TOTALS</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const auto aDbSetup::CREATE_VIEW_TOTALS</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= QLatin1String(<span class="stringliteral">&quot;CREATE VIEW viewTotals AS &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; SELECT &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tblk) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tblk) AS INT)%60) AS \&quot;TOTAL\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tSPSE) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tSPSE) AS INT)%60) AS \&quot;SP SE\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tSPME) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tSPME) AS INT)%60) AS \&quot;SP ME\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tNIGHT) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tNIGHT) AS INT)%60) AS \&quot;NIGHT\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tIFR) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tIFR) AS INT)%60) AS \&quot;IFR\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tPIC) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tPIC) AS INT)%60) AS \&quot;PIC\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tPICUS) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tPICUS) AS INT)%60) AS \&quot;PICUS\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tSIC) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tSIC) AS INT)%60) AS \&quot;SIC\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tDual) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tDual) AS INT)%60) AS \&quot;DUAL\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tFI) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tFI) AS INT)%60) AS \&quot;INSTRUCTOR\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tSIM) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tSIM) AS INT)%60) AS \&quot;SIMULATOR\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; printf(\&quot;%02d\&quot;,CAST(SUM(tMP) AS INT)/60)||\&quot;:\&quot;||printf(\&quot;%02d\&quot;,CAST(SUM(tMP) AS INT)%60) AS \&quot;MultPilot\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; CAST(SUM(toDay) AS INT) AS \&quot;TO Day\&quot;, CAST(SUM(toNight) AS INT) AS \&quot;TO Night\&quot;, &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; CAST(SUM(ldgDay) AS INT) AS \&quot;LDG Day\&quot;, CAST(SUM(ldgNight) AS INT) AS \&quot;LDG Night\&quot; &quot;</span></div>
<div class="line">        <span class="stringliteral">&quot; FROM flights&quot;</span>)</div>
</div><!-- fragment -->
</div>
</div>
<a id="aa652dda29984360bdc05d15bb18ab99d"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aa652dda29984360bdc05d15bb18ab99d">&#9670;&nbsp;</a></span>DATABASE_TABLES</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const QList&lt;QLatin1String&gt; aDbSetup::DATABASE_TABLES</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= {</div>
<div class="line">    CREATE_TABLE_PILOTS,</div>
<div class="line">    CREATE_TABLE_TAILS,</div>
<div class="line">    CREATE_TABLE_FLIGHTS,</div>
<div class="line">    CREATE_TABLE_AIRCRAFT,</div>
<div class="line">    CREATE_TABLE_AIRPORTS,</div>
<div class="line">    CREATE_TABLE_CURRENCIES,</div>
<div class="line">    CREATE_TABLE_CHANGELOG</div>
<div class="line">}</div>
</div><!-- fragment -->
</div>
</div>
<a id="a68c1e8239ce0a8ac921a8302a12a7f1e"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a68c1e8239ce0a8ac921a8302a12a7f1e">&#9670;&nbsp;</a></span>DATABASE_VIEWS</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const QList&lt;QLatin1String&gt; aDbSetup::DATABASE_VIEWS</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= {</div>
<div class="line">    CREATE_VIEW_DEFAULT,</div>
<div class="line">    CREATE_VIEW_EASA,</div>
<div class="line">    CREATE_VIEW_TAILS,</div>
<div class="line">    CREATE_VIEW_PILOTS,</div>
<div class="line">    CREATE_VIEW_TOTALS,</div>
<div class="line">    CREATE_VIEW_QCOMPLETER,</div>
<div class="line">}</div>
</div><!-- fragment -->
</div>
</div>
<a id="a161c7916698832075f4b63e92e5c273a"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a161c7916698832075f4b63e92e5c273a">&#9670;&nbsp;</a></span>TEMPLATE_TABLES</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const QList&lt;QLatin1String&gt; aDbSetup::TEMPLATE_TABLES</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= {</div>
<div class="line">    QLatin1String(<span class="stringliteral">&quot;aircraft&quot;</span>),</div>
<div class="line">    QLatin1String(<span class="stringliteral">&quot;airports&quot;</span>),</div>
<div class="line">    QLatin1String(<span class="stringliteral">&quot;currencies&quot;</span>),</div>
<div class="line">    QLatin1String(<span class="stringliteral">&quot;changelog&quot;</span>)</div>
<div class="line">}</div>
</div><!-- fragment -->
</div>
</div>
<a id="adf7f35dafacdf318978b8aefb8ae8198"></a>
<h2 class="memtitle"><span class="permalink"><a href="#adf7f35dafacdf318978b8aefb8ae8198">&#9670;&nbsp;</a></span>USER_TABLES</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">const QList&lt;QLatin1String&gt; aDbSetup::USER_TABLES</td>
        </tr>
      </table>
</div><div class="memdoc">
<b>Initial value:</b><div class="fragment"><div class="line">= {</div>
<div class="line">    QLatin1String(<span class="stringliteral">&quot;flights&quot;</span>),</div>
<div class="line">    QLatin1String(<span class="stringliteral">&quot;pilots&quot;</span>),</div>
<div class="line">    QLatin1String(<span class="stringliteral">&quot;tails&quot;</span>)</div>
<div class="line">}</div>
</div><!-- fragment -->
</div>
</div>
</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="namespacea_db_setup.html">aDbSetup</a></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>