sweproj.com
/
openPilotLog
kopia lustrzana https://github.com/fiffty-50/openPilotLog


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566
							<!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: Db 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&amp;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&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('class_db.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="#pub-types">Public Types</a> &#124;
<a href="#pub-methods">Public Member Functions</a> &#124;
<a href="#pub-static-methods">Static Public Member Functions</a> &#124;
<a href="class_db-members.html">List of all members</a>  </div>
  <div class="headertitle">
<div class="title">Db Class Reference</div>  </div>
</div><!--header-->
<div class="contents">

<p>The <a class="el" href="class_db.html" title="The Db class provides a basic API for accessing the database programatically. It is used to set up th...">Db</a> class provides a basic API for accessing the database programatically. It is used to set up the initial connection and various basic queries can be executed using a set of static functions. When interfacing with the database for the purpose of adding, deleting or updating entries, the use of the entry class and its subclasses is recommended. This clas is not supposed to be instantiated, if you need a database object, use QSqlDatabase::database("qt_sql_default_connection");.  
 <a href="class_db.html#details">More...</a></p>

<p><code>#include &lt;<a class="el" href="db_8h_source.html">db.h</a>&gt;</code></p>
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-types"></a>
Public Types</h2></td></tr>
<tr class="memitem:a2eb74695b795bf25b6ddfd41c86bcc7b"><td class="memItemLeft" align="right" valign="top"><a id="a2eb74695b795bf25b6ddfd41c86bcc7b"></a>enum &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#a2eb74695b795bf25b6ddfd41c86bcc7b">editRole</a> { <b>createNew</b>, 
<b>editExisting</b>
 }</td></tr>
<tr class="memdesc:a2eb74695b795bf25b6ddfd41c86bcc7b"><td class="mdescLeft">&#160;</td><td class="mdescRight">The editRole enum {createNew, editExisting} is used to differentiate between creating a new entry in the database vs editing an existing one. <br /></td></tr>
<tr class="separator:a2eb74695b795bf25b6ddfd41c86bcc7b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8caadbd9713c345384823aa2f8cb951c"><td class="memItemLeft" align="right" valign="top"><a id="a8caadbd9713c345384823aa2f8cb951c"></a>enum &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">matchType</a> { <b>exactMatch</b>, 
<b>partialMatch</b>
 }</td></tr>
<tr class="memdesc:a8caadbd9713c345384823aa2f8cb951c"><td class="mdescLeft">&#160;</td><td class="mdescRight">The matchType enum {exactMatch, partialMatch} is used to determine the matching when using a WHERE sql statement. exactMatch results in a "=" operator, whereas partiasMatch results in a "LIKE" operator. <br /></td></tr>
<tr class="separator:a8caadbd9713c345384823aa2f8cb951c"><td class="memSeparator" colspan="2">&#160;</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:a5bc74f437d3ca0ebadcb13b185112e05"><td class="memItemLeft" align="right" valign="top"><a id="a5bc74f437d3ca0ebadcb13b185112e05"></a>
&#160;</td><td class="memItemRight" valign="bottom"><b>Db</b> (<a class="el" href="class_db.html">Db</a> const &amp;)=delete</td></tr>
<tr class="separator:a5bc74f437d3ca0ebadcb13b185112e05"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad0724c898deb1e33d5d091a870b58d30"><td class="memItemLeft" align="right" valign="top"><a id="ad0724c898deb1e33d5d091a870b58d30"></a>
void&#160;</td><td class="memItemRight" valign="bottom"><b>operator=</b> (<a class="el" href="class_db.html">Db</a> const &amp;)=delete</td></tr>
<tr class="separator:ad0724c898deb1e33d5d091a870b58d30"><td class="memSeparator" colspan="2">&#160;</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:ae50aad5630a4cc0f86b51bedb1f2d3f7"><td class="memItemLeft" align="right" valign="top"><a id="ae50aad5630a4cc0f86b51bedb1f2d3f7"></a>
static <a class="el" href="class_db.html">Db</a> &amp;&#160;</td><td class="memItemRight" valign="bottom"><b>get</b> ()</td></tr>
<tr class="separator:ae50aad5630a4cc0f86b51bedb1f2d3f7"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af9dd776816e7941fec7b631eb2ff40b7"><td class="memItemLeft" align="right" valign="top"><a id="af9dd776816e7941fec7b631eb2ff40b7"></a>
static void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#af9dd776816e7941fec7b631eb2ff40b7">connect</a> ()</td></tr>
<tr class="memdesc:af9dd776816e7941fec7b631eb2ff40b7"><td class="mdescLeft">&#160;</td><td class="mdescRight">connect establishes the database connection. Only needs to be called once within the application. Database is available thereafter, objects can be instantiated with QSqlDatabase::database("qt_sql_default_connection") as required. <br /></td></tr>
<tr class="separator:af9dd776816e7941fec7b631eb2ff40b7"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9bc721f0e6cd55a0dc4b6a690794f05a"><td class="memItemLeft" align="right" valign="top"><a id="a9bc721f0e6cd55a0dc4b6a690794f05a"></a>
static void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#a9bc721f0e6cd55a0dc4b6a690794f05a">disconnect</a> ()</td></tr>
<tr class="memdesc:a9bc721f0e6cd55a0dc4b6a690794f05a"><td class="mdescLeft">&#160;</td><td class="mdescRight">disconnect Closes and removes the default database connection. <br /></td></tr>
<tr class="separator:a9bc721f0e6cd55a0dc4b6a690794f05a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aca719513ddc25d3628761da143cfde9e"><td class="memItemLeft" align="right" valign="top">static QSqlDatabase&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#aca719513ddc25d3628761da143cfde9e">Database</a> ()</td></tr>
<tr class="memdesc:aca719513ddc25d3628761da143cfde9e"><td class="mdescLeft">&#160;</td><td class="mdescRight">Can be used to access the database connection.  <a href="class_db.html#aca719513ddc25d3628761da143cfde9e">More...</a><br /></td></tr>
<tr class="separator:aca719513ddc25d3628761da143cfde9e"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a05ccd0af0703255fc249e5cb9e2eb945"><td class="memItemLeft" align="right" valign="top">static bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#a05ccd0af0703255fc249e5cb9e2eb945">exists</a> (QString column, QString table, QString checkColumn, QString value, <a class="el" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match)</td></tr>
<tr class="memdesc:a05ccd0af0703255fc249e5cb9e2eb945"><td class="mdescLeft">&#160;</td><td class="mdescRight"><a class="el" href="class_db.html#a05ccd0af0703255fc249e5cb9e2eb945" title="Db::exists checks if a certain value exists in the database with a sqlite WHERE statement.">Db::exists</a> checks if a certain value exists in the database with a sqlite WHERE statement.  <a href="class_db.html#a05ccd0af0703255fc249e5cb9e2eb945">More...</a><br /></td></tr>
<tr class="separator:a05ccd0af0703255fc249e5cb9e2eb945"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a939456015e76b398af918656791e3951"><td class="memItemLeft" align="right" valign="top">static bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#a939456015e76b398af918656791e3951">singleUpdate</a> (QString table, QString column, QString value, QString checkColumn, QString checkvalue, <a class="el" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match)</td></tr>
<tr class="memdesc:a939456015e76b398af918656791e3951"><td class="mdescLeft">&#160;</td><td class="mdescRight"><a class="el" href="class_db.html#a939456015e76b398af918656791e3951" title="Db::singleUpdate Updates a single value in the database. Query format: UPDATE table SET column = valu...">Db::singleUpdate</a> Updates a single value in the database. Query format: UPDATE table SET column = value WHERE checkcolumn =/LIKE checkvalue.  <a href="class_db.html#a939456015e76b398af918656791e3951">More...</a><br /></td></tr>
<tr class="separator:a939456015e76b398af918656791e3951"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:addcbd285617f8ef82f79c276d7bddfe1"><td class="memItemLeft" align="right" valign="top">static QString&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#addcbd285617f8ef82f79c276d7bddfe1">singleSelect</a> (QString column, QString table, QString checkColumn, QString value, <a class="el" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match)</td></tr>
<tr class="memdesc:addcbd285617f8ef82f79c276d7bddfe1"><td class="mdescLeft">&#160;</td><td class="mdescRight">singleSelect Returns a single value from the database with a sqlite WHERE statement  <a href="class_db.html#addcbd285617f8ef82f79c276d7bddfe1">More...</a><br /></td></tr>
<tr class="separator:addcbd285617f8ef82f79c276d7bddfe1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8dcb618ebfe1ae337bb0972bec37cbd2"><td class="memItemLeft" align="right" valign="top">static QVector&lt; QString &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#a8dcb618ebfe1ae337bb0972bec37cbd2">multiSelect</a> (QVector&lt; QString &gt; columns, QString table, QString checkColumn, QString value, <a class="el" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a> match)</td></tr>
<tr class="memdesc:a8dcb618ebfe1ae337bb0972bec37cbd2"><td class="mdescLeft">&#160;</td><td class="mdescRight"><a class="el" href="class_db.html#a8dcb618ebfe1ae337bb0972bec37cbd2" title="Db::multiSelect Returns multiple values from the database with a sqlite WHERE statement.">Db::multiSelect</a> Returns multiple values from the database with a sqlite WHERE statement.  <a href="class_db.html#a8dcb618ebfe1ae337bb0972bec37cbd2">More...</a><br /></td></tr>
<tr class="separator:a8dcb618ebfe1ae337bb0972bec37cbd2"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa6c52eda14d37c9226b07e36fe6d0f86"><td class="memItemLeft" align="right" valign="top">static QVector&lt; QString &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#aa6c52eda14d37c9226b07e36fe6d0f86">multiSelect</a> (QVector&lt; QString &gt; columns, QString table)</td></tr>
<tr class="memdesc:aa6c52eda14d37c9226b07e36fe6d0f86"><td class="mdescLeft">&#160;</td><td class="mdescRight"><a class="el" href="class_db.html#a8dcb618ebfe1ae337bb0972bec37cbd2" title="Db::multiSelect Returns multiple values from the database with a sqlite WHERE statement.">Db::multiSelect</a> Returns a complete column(s) for a given table.  <a href="class_db.html#aa6c52eda14d37c9226b07e36fe6d0f86">More...</a><br /></td></tr>
<tr class="separator:aa6c52eda14d37c9226b07e36fe6d0f86"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aaccb09bc96d531bbc7019a7df81859ca"><td class="memItemLeft" align="right" valign="top">static QVector&lt; QString &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_db.html#aaccb09bc96d531bbc7019a7df81859ca">customQuery</a> (QString query, int returnValues)</td></tr>
<tr class="memdesc:aaccb09bc96d531bbc7019a7df81859ca"><td class="mdescLeft">&#160;</td><td class="mdescRight"><a class="el" href="class_db.html#aaccb09bc96d531bbc7019a7df81859ca" title="Db::customQuery Can be used to send a complex query to the database.">Db::customQuery</a> Can be used to send a complex query to the database.  <a href="class_db.html#aaccb09bc96d531bbc7019a7df81859ca">More...</a><br /></td></tr>
<tr class="separator:aaccb09bc96d531bbc7019a7df81859ca"><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="class_db.html" title="The Db class provides a basic API for accessing the database programatically. It is used to set up th...">Db</a> class provides a basic API for accessing the database programatically. It is used to set up the initial connection and various basic queries can be executed using a set of static functions. When interfacing with the database for the purpose of adding, deleting or updating entries, the use of the entry class and its subclasses is recommended. This clas is not supposed to be instantiated, if you need a database object, use QSqlDatabase::database("qt_sql_default_connection");. </p>
</div><h2 class="groupheader">Member Function Documentation</h2>
<a id="aaccb09bc96d531bbc7019a7df81859ca"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aaccb09bc96d531bbc7019a7df81859ca">&#9670;&nbsp;</a></span>customQuery()</h2>

<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">static QVector&lt;QString&gt; Db::customQuery </td>
          <td>(</td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>query</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>returnValues</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p><a class="el" href="class_db.html#aaccb09bc96d531bbc7019a7df81859ca" title="Db::customQuery Can be used to send a complex query to the database.">Db::customQuery</a> 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 expected return values </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>QVector&lt;QString&gt; of results </dd></dl>

</div>
</div>
<a id="aca719513ddc25d3628761da143cfde9e"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aca719513ddc25d3628761da143cfde9e">&#9670;&nbsp;</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">static QSqlDatabase Db::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">inline</span><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>a pointer to the default database connection </dd></dl>

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

<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">static bool Db::exists </td>
          <td>(</td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>column</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>table</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>checkColumn</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>value</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a>&#160;</td>
          <td class="paramname"><em>match</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p><a class="el" href="class_db.html#a05ccd0af0703255fc249e5cb9e2eb945" title="Db::exists checks if a certain value exists in the database with a sqlite WHERE statement.">Db::exists</a> checks if a certain value exists in the database with a sqlite WHERE statement. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">table</td><td>- Name of the table </td></tr>
    <tr><td class="paramname">column</td><td>- Name of the column </td></tr>
    <tr><td class="paramname">value</td><td>- The value to be checked </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd></dd></dl>

</div>
</div>
<a id="aa6c52eda14d37c9226b07e36fe6d0f86"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aa6c52eda14d37c9226b07e36fe6d0f86">&#9670;&nbsp;</a></span>multiSelect() <span class="overload">[1/2]</span></h2>

<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">static QVector&lt;QString&gt; Db::multiSelect </td>
          <td>(</td>
          <td class="paramtype">QVector&lt; QString &gt;&#160;</td>
          <td class="paramname"><em>columns</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>table</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p><a class="el" href="class_db.html#a8dcb618ebfe1ae337bb0972bec37cbd2" title="Db::multiSelect Returns multiple values from the database with a sqlite WHERE statement.">Db::multiSelect</a> Returns a complete column(s) for a given table. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">column</td><td>- QVector&lt;QString&gt; Names of the columns to be queried </td></tr>
    <tr><td class="paramname">table</td><td>- QString Name of the table </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd></dd></dl>

</div>
</div>
<a id="a8dcb618ebfe1ae337bb0972bec37cbd2"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a8dcb618ebfe1ae337bb0972bec37cbd2">&#9670;&nbsp;</a></span>multiSelect() <span class="overload">[2/2]</span></h2>

<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">static QVector&lt;QString&gt; Db::multiSelect </td>
          <td>(</td>
          <td class="paramtype">QVector&lt; QString &gt;&#160;</td>
          <td class="paramname"><em>columns</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>table</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>checkColumn</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>value</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a>&#160;</td>
          <td class="paramname"><em>match</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p><a class="el" href="class_db.html#a8dcb618ebfe1ae337bb0972bec37cbd2" title="Db::multiSelect Returns multiple values from the database with a sqlite WHERE statement.">Db::multiSelect</a> Returns multiple values from the database with a sqlite WHERE statement. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">table</td><td>- Name of the table </td></tr>
    <tr><td class="paramname">columns</td><td>- QVector&lt;QString&gt; Names of the columns to be queried </td></tr>
    <tr><td class="paramname">value</td><td>- Identifier for WHERE statement </td></tr>
    <tr><td class="paramname">checkColumn</td><td>- column to match value to </td></tr>
    <tr><td class="paramname">match</td><td>- enum Db::exactMatch or Db::partialMatch </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>QVector&lt;QString&gt; </dd></dl>

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

<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">static QString Db::singleSelect </td>
          <td>(</td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>column</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>table</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>checkColumn</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>value</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a>&#160;</td>
          <td class="paramname"><em>match</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>singleSelect Returns a single value from the database with a sqlite WHERE statement </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">table</td><td>- Name of the table </td></tr>
    <tr><td class="paramname">column</td><td>- Name of the column </td></tr>
    <tr><td class="paramname">value</td><td>- Identifier for WHERE statement </td></tr>
    <tr><td class="paramname">match</td><td>- enum Db::exactMatch or Db::partialMatch </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>QString </dd></dl>

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

<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">static bool Db::singleUpdate </td>
          <td>(</td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>table</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>column</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>value</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>checkColumn</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">QString&#160;</td>
          <td class="paramname"><em>checkvalue</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="class_db.html#a8caadbd9713c345384823aa2f8cb951c">Db::matchType</a>&#160;</td>
          <td class="paramname"><em>match</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p><a class="el" href="class_db.html#a939456015e76b398af918656791e3951" title="Db::singleUpdate Updates a single value in the database. Query format: UPDATE table SET column = valu...">Db::singleUpdate</a> Updates a single value in the database. Query format: UPDATE table SET column = value WHERE checkcolumn =/LIKE checkvalue. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">table</td><td>Name of the table to be updated </td></tr>
    <tr><td class="paramname">column</td><td>Name of the column to be updated </td></tr>
    <tr><td class="paramname">checkColumn</td><td>Name of the column for WHERE statement </td></tr>
    <tr><td class="paramname">value</td><td>The value to be set </td></tr>
    <tr><td class="paramname">checkvalue</td><td>The value for the WHERE statement </td></tr>
    <tr><td class="paramname">match</td><td>enum Db::exactMatch or Db::partialMatch </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>true on success, otherwise error messages in debug out </dd></dl>

</div>
</div>
<hr/>The documentation for this class was generated from the following files:<ul>
<li>src/database/<a class="el" href="db_8h_source.html">db.h</a></li>
<li>src/database/db.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="class_db.html">Db</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>