| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190 | <!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.8.20"/><meta name="viewport" content="width=device-width, initial-scale=1"/><title>openPilotLog: src/database/tablecolumnliterals.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="projectalign" style="padding-left: 0.5em;">   <div id="projectname">openPilotLog   </div>  </td> </tr> </tbody></table></div><!-- end header part --><!-- Generated by Doxygen 1.8.20 --><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');/* @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('tablecolumnliterals_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">tablecolumnliterals.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="preprocessor">#ifndef TABLECOLUMNLITERALS_H</span></div><div class="line"><a name="l00002"></a><span class="lineno">    2</span> <span class="preprocessor">#define TABLECOLUMNLITERALS_H</span></div><div class="line"><a name="l00003"></a><span class="lineno">    3</span>  </div><div class="line"><a name="l00004"></a><span class="lineno">    4</span> <span class="preprocessor">#include <QString></span></div><div class="line"><a name="l00005"></a><span class="lineno">    5</span> <span class="preprocessor">#include <QStringLiteral></span></div><div class="line"><a name="l00006"></a><span class="lineno">    6</span>  </div><div class="line"><a name="l00007"></a><span class="lineno">    7</span> <span class="comment">// [F]: These constants deviate slightly from const naming convention to reflect their sql column name.</span></div><div class="line"><a name="l00008"></a><span class="lineno">    8</span> <span class="comment">// In many places throughout the application, we have to programatically access or write data</span></div><div class="line"><a name="l00009"></a><span class="lineno">    9</span> <span class="comment">// to or from the database using column names as identifiers, doing something like this:</span></div><div class="line"><a name="l00010"></a><span class="lineno">   10</span> <span class="comment">//</span></div><div class="line"><a name="l00011"></a><span class="lineno">   11</span> <span class="comment">// newData.insert("dept", ui->deptLocLineEdit->text());</span></div><div class="line"><a name="l00012"></a><span class="lineno">   12</span> <span class="comment">// newData.value("multipilot") // do stuff</span></div><div class="line"><a name="l00013"></a><span class="lineno">   13</span> <span class="comment">//</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">// Declaring the literals here avoids memory allocation at runtime for construction of temporary qstrings</span></div><div class="line"><a name="l00016"></a><span class="lineno">   16</span> <span class="comment">// like ("dept"). See https://doc.qt.io/qt-5/qstring.html#QStringLiteral</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>  </div><div class="line"><a name="l00019"></a><span class="lineno">   19</span> <span class="comment">// Table names</span></div><div class="line"><a name="l00020"></a><span class="lineno">   20</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TABLE_FLIGHTS  = QStringLiteral(<span class="stringliteral">"flights"</span>);</div><div class="line"><a name="l00021"></a><span class="lineno">   21</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TABLE_PILOTS   = QStringLiteral(<span class="stringliteral">"pilots"</span>);</div><div class="line"><a name="l00022"></a><span class="lineno">   22</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TABLE_TAILS    = QStringLiteral(<span class="stringliteral">"tails"</span>);</div><div class="line"><a name="l00023"></a><span class="lineno">   23</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TABLE_AIRCRAFT = QStringLiteral(<span class="stringliteral">"aircraft"</span>);</div><div class="line"><a name="l00024"></a><span class="lineno">   24</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TABLE_AIRPORTS = QStringLiteral(<span class="stringliteral">"airports"</span>);</div><div class="line"><a name="l00025"></a><span class="lineno">   25</span>  </div><div class="line"><a name="l00026"></a><span class="lineno">   26</span> <span class="comment">// Flights table</span></div><div class="line"><a name="l00027"></a><span class="lineno">   27</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_DOFT           = QStringLiteral(<span class="stringliteral">"doft"</span>);</div><div class="line"><a name="l00028"></a><span class="lineno">   28</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_DEPT           = QStringLiteral(<span class="stringliteral">"dept"</span>);</div><div class="line"><a name="l00029"></a><span class="lineno">   29</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_DEST           = QStringLiteral(<span class="stringliteral">"dest"</span>);</div><div class="line"><a name="l00030"></a><span class="lineno">   30</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TOFB           = QStringLiteral(<span class="stringliteral">"tofb"</span>);</div><div class="line"><a name="l00031"></a><span class="lineno">   31</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TONB           = QStringLiteral(<span class="stringliteral">"tonb"</span>);</div><div class="line"><a name="l00032"></a><span class="lineno">   32</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_PIC            = QStringLiteral(<span class="stringliteral">"pic"</span>);</div><div class="line"><a name="l00033"></a><span class="lineno">   33</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_ACFT           = QStringLiteral(<span class="stringliteral">"acft"</span>);</div><div class="line"><a name="l00034"></a><span class="lineno">   34</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TBLK           = QStringLiteral(<span class="stringliteral">"tblk"</span>);</div><div class="line"><a name="l00035"></a><span class="lineno">   35</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TSPSE          = QStringLiteral(<span class="stringliteral">"tSPSE"</span>);</div><div class="line"><a name="l00036"></a><span class="lineno">   36</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_SPME           = QStringLiteral(<span class="stringliteral">"tSPME"</span>);</div><div class="line"><a name="l00037"></a><span class="lineno">   37</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TMP            = QStringLiteral(<span class="stringliteral">"tMP"</span>);</div><div class="line"><a name="l00038"></a><span class="lineno">   38</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TNIGHT         = QStringLiteral(<span class="stringliteral">"tNIGHT"</span>);</div><div class="line"><a name="l00039"></a><span class="lineno">   39</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TIFR           = QStringLiteral(<span class="stringliteral">"tIFR"</span>);</div><div class="line"><a name="l00040"></a><span class="lineno">   40</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TPIC           = QStringLiteral(<span class="stringliteral">"tPIC"</span>);</div><div class="line"><a name="l00041"></a><span class="lineno">   41</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TPICUS         = QStringLiteral(<span class="stringliteral">"tPICUS"</span>);</div><div class="line"><a name="l00042"></a><span class="lineno">   42</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TSIC           = QStringLiteral(<span class="stringliteral">"tSIC"</span>);</div><div class="line"><a name="l00043"></a><span class="lineno">   43</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TDUAL          = QStringLiteral(<span class="stringliteral">"tDUAL"</span>);</div><div class="line"><a name="l00044"></a><span class="lineno">   44</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TFI            = QStringLiteral(<span class="stringliteral">"tFI"</span>);</div><div class="line"><a name="l00045"></a><span class="lineno">   45</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TSIM           = QStringLiteral(<span class="stringliteral">"tSIM"</span>);</div><div class="line"><a name="l00046"></a><span class="lineno">   46</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_PILOTFLYING    = QStringLiteral(<span class="stringliteral">"pilotFlying"</span>);</div><div class="line"><a name="l00047"></a><span class="lineno">   47</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TODAY          = QStringLiteral(<span class="stringliteral">"toDay"</span>);</div><div class="line"><a name="l00048"></a><span class="lineno">   48</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_TONIGHT        = QStringLiteral(<span class="stringliteral">"toNight"</span>);</div><div class="line"><a name="l00049"></a><span class="lineno">   49</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_LDGDAY         = QStringLiteral(<span class="stringliteral">"ldgDay"</span>);</div><div class="line"><a name="l00050"></a><span class="lineno">   50</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_LDGNIGHT       = QStringLiteral(<span class="stringliteral">"ldgNight"</span>);</div><div class="line"><a name="l00051"></a><span class="lineno">   51</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_AUTOLAND       = QStringLiteral(<span class="stringliteral">"autoland"</span>);</div><div class="line"><a name="l00052"></a><span class="lineno">   52</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_SECONDPILOT    = QStringLiteral(<span class="stringliteral">"secondPilot"</span>);</div><div class="line"><a name="l00053"></a><span class="lineno">   53</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_THIRDPILOT     = QStringLiteral(<span class="stringliteral">"thirdPilot"</span>);</div><div class="line"><a name="l00054"></a><span class="lineno">   54</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_APPROACHTYPE   = QStringLiteral(<span class="stringliteral">"approachType"</span>);</div><div class="line"><a name="l00055"></a><span class="lineno">   55</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_FLIGHTNUMBER   = QStringLiteral(<span class="stringliteral">"flightNumber"</span>);</div><div class="line"><a name="l00056"></a><span class="lineno">   56</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_FLIGHTS_REMARKS        = QStringLiteral(<span class="stringliteral">"remarks"</span>);</div><div class="line"><a name="l00057"></a><span class="lineno">   57</span>  </div><div class="line"><a name="l00058"></a><span class="lineno">   58</span> <span class="comment">// tails table</span></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> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TAILS_REGISTRATION   = QStringLiteral(<span class="stringliteral">"registration"</span>);</div><div class="line"><a name="l00061"></a><span class="lineno">   61</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TAILS_COMPANY        = QStringLiteral(<span class="stringliteral">"company"</span>);</div><div class="line"><a name="l00062"></a><span class="lineno">   62</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TAILS_MAKE           = QStringLiteral(<span class="stringliteral">"make"</span>);</div><div class="line"><a name="l00063"></a><span class="lineno">   63</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TAILS_MODEL          = QStringLiteral(<span class="stringliteral">"model"</span>);</div><div class="line"><a name="l00064"></a><span class="lineno">   64</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TAILS_VARIANT        = QStringLiteral(<span class="stringliteral">"variant"</span>);</div><div class="line"><a name="l00065"></a><span class="lineno">   65</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TAILS_MULTIPILOT     = QStringLiteral(<span class="stringliteral">"multipilot"</span>);</div><div class="line"><a name="l00066"></a><span class="lineno">   66</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TAILS_MULTIENGINE    = QStringLiteral(<span class="stringliteral">"multiengine"</span>);</div><div class="line"><a name="l00067"></a><span class="lineno">   67</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TAILS_ENGINETYPE     = QStringLiteral(<span class="stringliteral">"engineType"</span>);</div><div class="line"><a name="l00068"></a><span class="lineno">   68</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_TAILS_WEIGHTCLASS    = QStringLiteral(<span class="stringliteral">"weightClass"</span>);</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> <span class="comment">// pilots table</span></div><div class="line"><a name="l00071"></a><span class="lineno">   71</span>  </div><div class="line"><a name="l00072"></a><span class="lineno">   72</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_PILOTS_LASTNAME       = QStringLiteral(<span class="stringliteral">"lastname"</span>);</div><div class="line"><a name="l00073"></a><span class="lineno">   73</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_PILOTS_FIRSTNAME      = QStringLiteral(<span class="stringliteral">"firstname"</span>);</div><div class="line"><a name="l00074"></a><span class="lineno">   74</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_PILOTS_ALIAS          = QStringLiteral(<span class="stringliteral">"alias"</span>);</div><div class="line"><a name="l00075"></a><span class="lineno">   75</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_PILOTS_COMPANY        = QStringLiteral(<span class="stringliteral">"company"</span>);</div><div class="line"><a name="l00076"></a><span class="lineno">   76</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_PILOTS_EMPLOYEEID     = QStringLiteral(<span class="stringliteral">"employeeid"</span>);</div><div class="line"><a name="l00077"></a><span class="lineno">   77</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_PILOTS_PHONE          = QStringLiteral(<span class="stringliteral">"phone"</span>);</div><div class="line"><a name="l00078"></a><span class="lineno">   78</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_PILOTS_EMAIL          = QStringLiteral(<span class="stringliteral">"email"</span>);</div><div class="line"><a name="l00079"></a><span class="lineno">   79</span>  </div><div class="line"><a name="l00080"></a><span class="lineno">   80</span> <span class="comment">// all tables</span></div><div class="line"><a name="l00081"></a><span class="lineno">   81</span>  </div><div class="line"><a name="l00082"></a><span class="lineno">   82</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_ROWID          = QStringLiteral(<span class="stringliteral">"ROWID"</span>);</div><div class="line"><a name="l00083"></a><span class="lineno">   83</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_NULL           = QStringLiteral(<span class="stringliteral">""</span>);</div><div class="line"><a name="l00084"></a><span class="lineno">   84</span> <span class="keyword">static</span> <span class="keyword">const</span> <span class="keyword">auto</span> DB_NULL_hhmm      = QStringLiteral(<span class="stringliteral">"00:00"</span>);</div><div class="line"><a name="l00085"></a><span class="lineno">   85</span> <span class="comment">/*static const auto DB_               = QStringLiteral("");</span></div><div class="line"><a name="l00086"></a><span class="lineno">   86</span> <span class="comment">static const auto DB_               = QStringLiteral("");</span></div><div class="line"><a name="l00087"></a><span class="lineno">   87</span> <span class="comment">static const auto DB_               = QStringLiteral("");</span></div><div class="line"><a name="l00088"></a><span class="lineno">   88</span> <span class="comment">static const auto DB_               = QStringLiteral("");</span></div><div class="line"><a name="l00089"></a><span class="lineno">   89</span> <span class="comment">static const auto DB_               = QStringLiteral("");*/</span></div><div class="line"><a name="l00090"></a><span class="lineno">   90</span>  </div><div class="line"><a name="l00091"></a><span class="lineno">   91</span> <span class="preprocessor">#endif // TABLECOLUMNLITERALS_H</span></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>tablecolumnliterals.h</b></li>    <li class="footer">Generated by <a href="http://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.8.20 </li>  </ul></div></body></html>
 |