<!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: experimental::ADatabase Class 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="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('classexperimental_1_1_a_database.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="#signals">Signals</a> | <a href="#pub-methods">Public Member Functions</a> | <a href="#pub-static-methods">Static Public Member Functions</a> | <a href="#pub-attribs">Public Attributes</a> | <a href="classexperimental_1_1_a_database-members.html">List of all members</a> </div> <div class="headertitle"> <div class="title">experimental::ADatabase Class Reference</div> </div> </div><!--header--> <div class="contents"> <p>The DB class encapsulates the SQL database by providing fast access to hot database data. <a href="classexperimental_1_1_a_database.html#details">More...</a></p> <p><code>#include <<a class="el" href="adatabase_8h_source.html">adatabase.h</a>></code></p> <div class="dynheader"> Inheritance diagram for experimental::ADatabase:</div> <div class="dyncontent"> <div class="center"> <img src="classexperimental_1_1_a_database.png" alt=""/> </div></div> <table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="signals"></a> Signals</h2></td></tr> <tr class="memitem:a202981d0d39b5b3dbc88af65e17ed42a"><td class="memItemLeft" align="right" valign="top"><a id="a202981d0d39b5b3dbc88af65e17ed42a"></a> void </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#a202981d0d39b5b3dbc88af65e17ed42a">dataBaseUpdated</a> ()</td></tr> <tr class="memdesc:a202981d0d39b5b3dbc88af65e17ed42a"><td class="mdescLeft"> </td><td class="mdescRight">updated is emitted whenever the database contents have been updated. This can be either a commit, update or remove. This signal should be used to trigger an update to the models of the views displaying database contents in the user interface so that a user is always presented with up-to-date information. <br /></td></tr> <tr class="separator:a202981d0d39b5b3dbc88af65e17ed42a"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a> Public Member Functions</h2></td></tr> <tr class="memitem:ad584737b6e8908efbe8c9d38bd350cec"><td class="memItemLeft" align="right" valign="top"><a id="ad584737b6e8908efbe8c9d38bd350cec"></a>  </td><td class="memItemRight" valign="bottom"><b>ADatabase</b> (const <a class="el" href="classexperimental_1_1_a_database.html">ADatabase</a> &)=delete</td></tr> <tr class="separator:ad584737b6e8908efbe8c9d38bd350cec"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a4b52c04cea57491d61624fd2213ea7e4"><td class="memItemLeft" align="right" valign="top"><a id="a4b52c04cea57491d61624fd2213ea7e4"></a> void </td><td class="memItemRight" valign="bottom"><b>operator=</b> (const <a class="el" href="classexperimental_1_1_a_database.html">ADatabase</a> &)=delete</td></tr> <tr class="separator:a4b52c04cea57491d61624fd2213ea7e4"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:aa45ad744482ae94d8f639e5837c9c221"><td class="memItemLeft" align="right" valign="top"><a id="aa45ad744482ae94d8f639e5837c9c221"></a> bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#aa45ad744482ae94d8f639e5837c9c221">connect</a> ()</td></tr> <tr class="memdesc:aa45ad744482ae94d8f639e5837c9c221"><td class="mdescLeft"> </td><td class="mdescRight">Connect to the database and populate database information. <br /></td></tr> <tr class="separator:aa45ad744482ae94d8f639e5837c9c221"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a5e331e329bc21980d3e2f63c7ca01559"><td class="memItemLeft" align="right" valign="top"><a id="a5e331e329bc21980d3e2f63c7ca01559"></a> void </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#a5e331e329bc21980d3e2f63c7ca01559">disconnect</a> ()</td></tr> <tr class="memdesc:a5e331e329bc21980d3e2f63c7ca01559"><td class="mdescLeft"> </td><td class="mdescRight">closes the database connection. <br /></td></tr> <tr class="separator:a5e331e329bc21980d3e2f63c7ca01559"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ae536aeb620c52f873f1f0943cfeb9db0"><td class="memItemLeft" align="right" valign="top">QVector< QString > </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#ae536aeb620c52f873f1f0943cfeb9db0">customQuery</a> (QString statement, int return_values)</td></tr> <tr class="memdesc:ae536aeb620c52f873f1f0943cfeb9db0"><td class="mdescLeft"> </td><td class="mdescRight">Can be used to send a complex query to the database. <a href="classexperimental_1_1_a_database.html#ae536aeb620c52f873f1f0943cfeb9db0">More...</a><br /></td></tr> <tr class="separator:ae536aeb620c52f873f1f0943cfeb9db0"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ad3fc7756ef3f032d252b02ed6867e0a5"><td class="memItemLeft" align="right" valign="top"><a id="ad3fc7756ef3f032d252b02ed6867e0a5"></a> bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#ad3fc7756ef3f032d252b02ed6867e0a5">exists</a> (<a class="el" href="classexperimental_1_1_a_entry.html">AEntry</a> entry)</td></tr> <tr class="memdesc:ad3fc7756ef3f032d252b02ed6867e0a5"><td class="mdescLeft"> </td><td class="mdescRight">Checks if an entry exists in the database, based on position data. <br /></td></tr> <tr class="separator:ad3fc7756ef3f032d252b02ed6867e0a5"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a12a0b931a72e078af0b7ddb0fde7bc0c"><td class="memItemLeft" align="right" valign="top"><a id="a12a0b931a72e078af0b7ddb0fde7bc0c"></a> bool </td><td class="memItemRight" valign="bottom"><b>exists</b> (<a class="el" href="structexperimental_1_1_data_position.html">DataPosition</a> data_position)</td></tr> <tr class="separator:a12a0b931a72e078af0b7ddb0fde7bc0c"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a041619c4931943406dff1be52eb77434"><td class="memItemLeft" align="right" valign="top"><a id="a041619c4931943406dff1be52eb77434"></a> bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#a041619c4931943406dff1be52eb77434">commit</a> (<a class="el" href="classexperimental_1_1_a_entry.html">AEntry</a> entry)</td></tr> <tr class="memdesc:a041619c4931943406dff1be52eb77434"><td class="mdescLeft"> </td><td class="mdescRight">commits an entry to the database, calls either insert or update, based on position data <br /></td></tr> <tr class="separator:a041619c4931943406dff1be52eb77434"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a328fb63a110c9ada4af7ff2e4b240dfe"><td class="memItemLeft" align="right" valign="top"><a id="a328fb63a110c9ada4af7ff2e4b240dfe"></a> bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#a328fb63a110c9ada4af7ff2e4b240dfe">insert</a> (<a class="el" href="classexperimental_1_1_a_entry.html">AEntry</a> new_entry)</td></tr> <tr class="memdesc:a328fb63a110c9ada4af7ff2e4b240dfe"><td class="mdescLeft"> </td><td class="mdescRight">Create new entry in the databse based on <a class="el" href="classexperimental_1_1_user_input.html" title="The EntryData struct. Contains ALL possible data. However depending on who is constructing it,...">UserInput</a>. <br /></td></tr> <tr class="separator:a328fb63a110c9ada4af7ff2e4b240dfe"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ada25b4b94ab41b5ec78925a0a52b14ca"><td class="memItemLeft" align="right" valign="top"><a id="ada25b4b94ab41b5ec78925a0a52b14ca"></a> bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#ada25b4b94ab41b5ec78925a0a52b14ca">update</a> (<a class="el" href="classexperimental_1_1_a_entry.html">AEntry</a> updated_entry)</td></tr> <tr class="memdesc:ada25b4b94ab41b5ec78925a0a52b14ca"><td class="mdescLeft"> </td><td class="mdescRight">Updates entry in database from existing entry tweaked by the user. <br /></td></tr> <tr class="separator:ada25b4b94ab41b5ec78925a0a52b14ca"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:aeeb82d8057f36436fd793a242627668e"><td class="memItemLeft" align="right" valign="top"><a id="aeeb82d8057f36436fd793a242627668e"></a> bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#aeeb82d8057f36436fd793a242627668e">remove</a> (<a class="el" href="classexperimental_1_1_a_entry.html">AEntry</a> entry)</td></tr> <tr class="memdesc:aeeb82d8057f36436fd793a242627668e"><td class="mdescLeft"> </td><td class="mdescRight">deletes an entry from the database. <br /></td></tr> <tr class="separator:aeeb82d8057f36436fd793a242627668e"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ab4fe26545b5fd05fa6b63486f2d234e3"><td class="memItemLeft" align="right" valign="top"><a id="ab4fe26545b5fd05fa6b63486f2d234e3"></a> bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#ab4fe26545b5fd05fa6b63486f2d234e3">removeMany</a> (QList< <a class="el" href="structexperimental_1_1_data_position.html">DataPosition</a> >)</td></tr> <tr class="memdesc:ab4fe26545b5fd05fa6b63486f2d234e3"><td class="mdescLeft"> </td><td class="mdescRight">deletes a list of entries from the database. Optimised for speed when deleting many entries. <br /></td></tr> <tr class="separator:ab4fe26545b5fd05fa6b63486f2d234e3"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ae71340a7dc2668e9ae6e65117b16d1bd"><td class="memItemLeft" align="right" valign="top"><a id="ae71340a7dc2668e9ae6e65117b16d1bd"></a> TableData </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#ae71340a7dc2668e9ae6e65117b16d1bd">getEntryData</a> (<a class="el" href="structexperimental_1_1_data_position.html">DataPosition</a> data_position)</td></tr> <tr class="memdesc:ae71340a7dc2668e9ae6e65117b16d1bd"><td class="mdescLeft"> </td><td class="mdescRight">retreive entry data from the database to create an entry object <br /></td></tr> <tr class="separator:ae71340a7dc2668e9ae6e65117b16d1bd"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ad273efb62d7829e5cef4440d78b53161"><td class="memItemLeft" align="right" valign="top"><a id="ad273efb62d7829e5cef4440d78b53161"></a> <a class="el" href="classexperimental_1_1_a_entry.html">AEntry</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#ad273efb62d7829e5cef4440d78b53161">getEntry</a> (<a class="el" href="structexperimental_1_1_data_position.html">DataPosition</a> data_position)</td></tr> <tr class="memdesc:ad273efb62d7829e5cef4440d78b53161"><td class="mdescLeft"> </td><td class="mdescRight">retreive an Entry from the database. <br /></td></tr> <tr class="separator:ad273efb62d7829e5cef4440d78b53161"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ae8fac5f877e2ab11eab07781ebcab4b1"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structexperimental_1_1_a_pilot_entry.html">APilotEntry</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#ae8fac5f877e2ab11eab07781ebcab4b1">getPilotEntry</a> (RowId row_id)</td></tr> <tr class="memdesc:ae8fac5f877e2ab11eab07781ebcab4b1"><td class="mdescLeft"> </td><td class="mdescRight">retreives a PilotEntry from the database. <a href="classexperimental_1_1_a_database.html#ae8fac5f877e2ab11eab07781ebcab4b1">More...</a><br /></td></tr> <tr class="separator:ae8fac5f877e2ab11eab07781ebcab4b1"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ad05071058f2706dddd9c681d6946ef6d"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structexperimental_1_1_a_tail_entry.html">ATailEntry</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#ad05071058f2706dddd9c681d6946ef6d">getTailEntry</a> (RowId row_id)</td></tr> <tr class="memdesc:ad05071058f2706dddd9c681d6946ef6d"><td class="mdescLeft"> </td><td class="mdescRight">retreives a TailEntry from the database. <a href="classexperimental_1_1_a_database.html#ad05071058f2706dddd9c681d6946ef6d">More...</a><br /></td></tr> <tr class="separator:ad05071058f2706dddd9c681d6946ef6d"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:aee75f906918935027d95b3e5d8e1ff75"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structexperimental_1_1_a_aircraft_entry.html">AAircraftEntry</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#aee75f906918935027d95b3e5d8e1ff75">getAircraftEntry</a> (RowId row_id)</td></tr> <tr class="memdesc:aee75f906918935027d95b3e5d8e1ff75"><td class="mdescLeft"> </td><td class="mdescRight">retreives a TailEntry from the database. <a href="classexperimental_1_1_a_database.html#aee75f906918935027d95b3e5d8e1ff75">More...</a><br /></td></tr> <tr class="separator:aee75f906918935027d95b3e5d8e1ff75"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ac613f3dd83524ef30dd6351e3b8a50f3"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classexperimental_1_1_a_flight_entry.html">AFlightEntry</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#ac613f3dd83524ef30dd6351e3b8a50f3">getFlightEntry</a> (RowId row_id)</td></tr> <tr class="memdesc:ac613f3dd83524ef30dd6351e3b8a50f3"><td class="mdescLeft"> </td><td class="mdescRight">retreives a flight entry from the database. <a href="classexperimental_1_1_a_database.html#ac613f3dd83524ef30dd6351e3b8a50f3">More...</a><br /></td></tr> <tr class="separator:ac613f3dd83524ef30dd6351e3b8a50f3"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a1e3fa80e9472325fa41f227319592b26"><td class="memItemLeft" align="right" valign="top"><a id="a1e3fa80e9472325fa41f227319592b26"></a> const QStringList </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#a1e3fa80e9472325fa41f227319592b26">getCompletionList</a> (<a class="el" href="namespaceexperimental.html#a4ae0b93d398c270c979a8eec17545b8a">ADatabaseTarget</a>)</td></tr> <tr class="memdesc:a1e3fa80e9472325fa41f227319592b26"><td class="mdescLeft"> </td><td class="mdescRight">getCompletionList returns a QStringList of values for a QCompleter based on database values <br /></td></tr> <tr class="separator:a1e3fa80e9472325fa41f227319592b26"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a74280b96dbf58580ed9b1485b5cdc200"><td class="memItemLeft" align="right" valign="top"><a id="a74280b96dbf58580ed9b1485b5cdc200"></a> const QMap< QString, int > </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#a74280b96dbf58580ed9b1485b5cdc200">getIdMap</a> (<a class="el" href="namespaceexperimental.html#a4ae0b93d398c270c979a8eec17545b8a">ADatabaseTarget</a>)</td></tr> <tr class="memdesc:a74280b96dbf58580ed9b1485b5cdc200"><td class="mdescLeft"> </td><td class="mdescRight">returns a QMap<QString, int> of a human-readable database value and its row id. Used in the Dialogs to map user input to unique database entries. <br /></td></tr> <tr class="separator:a74280b96dbf58580ed9b1485b5cdc200"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a391a945bf0bf3160045690319833edce"><td class="memItemLeft" align="right" valign="top"><a id="a391a945bf0bf3160045690319833edce"></a> int </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#a391a945bf0bf3160045690319833edce">getLastEntry</a> (<a class="el" href="namespaceexperimental.html#a4ae0b93d398c270c979a8eec17545b8a">ADatabaseTarget</a>)</td></tr> <tr class="memdesc:a391a945bf0bf3160045690319833edce"><td class="mdescLeft"> </td><td class="mdescRight">returns the ROWID for the newest entry in the respective database. <br /></td></tr> <tr class="separator:a391a945bf0bf3160045690319833edce"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:aaa6d9017e72693dd26a0ebd311dcef91"><td class="memItemLeft" align="right" valign="top"><a id="aaa6d9017e72693dd26a0ebd311dcef91"></a> QList< int > </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#aaa6d9017e72693dd26a0ebd311dcef91">getForeignKeyConstraints</a> (int foreign_row_id, <a class="el" href="namespaceexperimental.html#a4ae0b93d398c270c979a8eec17545b8a">ADatabaseTarget</a> target)</td></tr> <tr class="memdesc:aaa6d9017e72693dd26a0ebd311dcef91"><td class="mdescLeft"> </td><td class="mdescRight">returns a list of ROWID's in the flights table for which foreign key constraints exist. <br /></td></tr> <tr class="separator:aaa6d9017e72693dd26a0ebd311dcef91"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-static-methods"></a> Static Public Member Functions</h2></td></tr> <tr class="memitem:a98b08ace02b71a593a66bb296169d9e1"><td class="memItemLeft" align="right" valign="top"><a id="a98b08ace02b71a593a66bb296169d9e1"></a> static <a class="el" href="classexperimental_1_1_a_database.html">ADatabase</a> * </td><td class="memItemRight" valign="bottom"><b>getInstance</b> ()</td></tr> <tr class="separator:a98b08ace02b71a593a66bb296169d9e1"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a5a1d594fadb083e97aa8d50f736ab0ea"><td class="memItemLeft" align="right" valign="top">static QSqlDatabase </td><td class="memItemRight" valign="bottom"><a class="el" href="classexperimental_1_1_a_database.html#a5a1d594fadb083e97aa8d50f736ab0ea">database</a> ()</td></tr> <tr class="memdesc:a5a1d594fadb083e97aa8d50f736ab0ea"><td class="mdescLeft"> </td><td class="mdescRight">Can be used to access the database connection. <a href="classexperimental_1_1_a_database.html#a5a1d594fadb083e97aa8d50f736ab0ea">More...</a><br /></td></tr> <tr class="separator:a5a1d594fadb083e97aa8d50f736ab0ea"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-attribs"></a> Public Attributes</h2></td></tr> <tr class="memitem:a2027b0025f37125d03b0058acbe89485"><td class="memItemLeft" align="right" valign="top"><a id="a2027b0025f37125d03b0058acbe89485"></a> <a class="el" href="classexperimental_1_1_a_database_error.html">ADatabaseError</a> </td><td class="memItemRight" valign="bottom"><b>lastError</b></td></tr> <tr class="separator:a2027b0025f37125d03b0058acbe89485"><td class="memSeparator" colspan="2"> </td></tr> </table> <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2> <div class="textblock"><p>The DB class encapsulates the SQL database by providing fast access to hot database data. </p> </div><h2 class="groupheader">Member Function Documentation</h2> <a id="ae536aeb620c52f873f1f0943cfeb9db0"></a> <h2 class="memtitle"><span class="permalink"><a href="#ae536aeb620c52f873f1f0943cfeb9db0">◆ </a></span>customQuery()</h2> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">QVector< QString > experimental::ADatabase::customQuery </td> <td>(</td> <td class="paramtype">QString </td> <td class="paramname"><em>statement</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"><em>return_values</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Can be used to send a complex query to the database. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">query</td><td>- the full sql query statement </td></tr> <tr><td class="paramname">returnValues</td><td>- the number of return values </td></tr> </table> </dd> </dl> </div> </div> <a id="a5a1d594fadb083e97aa8d50f736ab0ea"></a> <h2 class="memtitle"><span class="permalink"><a href="#a5a1d594fadb083e97aa8d50f736ab0ea">◆ </a></span>database()</h2> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">QSqlDatabase experimental::ADatabase::database </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">static</span></span> </td> </tr> </table> </div><div class="memdoc"> <p>Can be used to access the database connection. </p> <dl class="section return"><dt>Returns</dt><dd>The QSqlDatabase object pertaining to the connection. </dd></dl> </div> </div> <a id="aee75f906918935027d95b3e5d8e1ff75"></a> <h2 class="memtitle"><span class="permalink"><a href="#aee75f906918935027d95b3e5d8e1ff75">◆ </a></span>getAircraftEntry()</h2> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structexperimental_1_1_a_aircraft_entry.html">AAircraftEntry</a> experimental::ADatabase::getAircraftEntry </td> <td>(</td> <td class="paramtype">RowId </td> <td class="paramname"><em>row_id</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>retreives a TailEntry from the database. </p> <p>This function is a wrapper for DataBase::getEntry(DataPosition), where the table is already set and which returns an <a class="el" href="structexperimental_1_1_a_aircraft_entry.html">AAircraftEntry</a> instead of an <a class="el" href="classexperimental_1_1_a_entry.html" title="The Entry class encapsulates table metadata(table name, row id) and data for new and existing entries...">AEntry</a>. It allows for easy access to an aircraft entry with only the RowId required as input. </p> </div> </div> <a id="ac613f3dd83524ef30dd6351e3b8a50f3"></a> <h2 class="memtitle"><span class="permalink"><a href="#ac613f3dd83524ef30dd6351e3b8a50f3">◆ </a></span>getFlightEntry()</h2> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classexperimental_1_1_a_flight_entry.html">AFlightEntry</a> experimental::ADatabase::getFlightEntry </td> <td>(</td> <td class="paramtype">RowId </td> <td class="paramname"><em>row_id</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>retreives a flight entry from the database. </p> <p>This function is a wrapper for DataBase::getEntry(DataPosition), where the table is already set and which returns an <a class="el" href="classexperimental_1_1_a_flight_entry.html">AFlightEntry</a> instead of an <a class="el" href="classexperimental_1_1_a_entry.html" title="The Entry class encapsulates table metadata(table name, row id) and data for new and existing entries...">AEntry</a>. It allows for easy access to a flight entry with only the RowId required as input. </p> </div> </div> <a id="ae8fac5f877e2ab11eab07781ebcab4b1"></a> <h2 class="memtitle"><span class="permalink"><a href="#ae8fac5f877e2ab11eab07781ebcab4b1">◆ </a></span>getPilotEntry()</h2> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structexperimental_1_1_a_pilot_entry.html">APilotEntry</a> experimental::ADatabase::getPilotEntry </td> <td>(</td> <td class="paramtype">RowId </td> <td class="paramname"><em>row_id</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>retreives a PilotEntry from the database. </p> <p>This function is a wrapper for DataBase::getEntry(DataPosition), where the table is already set and which returns a PilotEntry instead of an Entry. It allows for easy access to a pilot entry with only the RowId required as input. </p> </div> </div> <a id="ad05071058f2706dddd9c681d6946ef6d"></a> <h2 class="memtitle"><span class="permalink"><a href="#ad05071058f2706dddd9c681d6946ef6d">◆ </a></span>getTailEntry()</h2> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structexperimental_1_1_a_tail_entry.html">ATailEntry</a> experimental::ADatabase::getTailEntry </td> <td>(</td> <td class="paramtype">RowId </td> <td class="paramname"><em>row_id</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>retreives a TailEntry from the database. </p> <p>This function is a wrapper for DataBase::getEntry(DataPosition), where the table is already set and which returns a TailEntry instead of an Entry. It allows for easy access to a tail entry with only the RowId required as input. </p> </div> </div> <hr/>The documentation for this class was generated from the following files:<ul> <li>src/experimental/<a class="el" href="adatabase_8h_source.html">adatabase.h</a></li> <li>src/experimental/adatabase.cpp</li> </ul> </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="namespaceexperimental.html">experimental</a></li><li class="navelem"><a class="el" href="classexperimental_1_1_a_database.html">ADatabase</a></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>