Domovská stránka Prehľadávať Pomoc
Prihlásiť sa
sebastian
/
CoffeePi
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Strom: 2fd59110f1
Branche Tagy
CoffeePi
/
CoffeeCode
/
html
/
database_8h.html

database_8h.html 24 KB
História Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516 
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    2. 

  2. <html xmlns="http://www.w3.org/1999/xhtml">
    3. 

  3. <head>
    4. 

  4. <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
    5. 

  5. <meta http-equiv="X-UA-Compatible" content="IE=9"/>
    6. 

  6. <meta name="generator" content="Doxygen 1.8.10"/>
    7. 

  7. <title>CoffeePi: database.h File Reference</title>
    8. 

  8. <link href="tabs.css" rel="stylesheet" type="text/css"/>
    9. 

  9. <script type="text/javascript" src="jquery.js"></script>
    10. 

  10. <script type="text/javascript" src="dynsections.js"></script>
    11. 

  11. <link href="search/search.css" rel="stylesheet" type="text/css"/>
    12. 

  12. <script type="text/javascript" src="search/searchdata.js"></script>
    13. 

  13. <script type="text/javascript" src="search/search.js"></script>
    14. 

  14. <script type="text/javascript">
    15. 

  15.   $(document).ready(function() { init_search(); });
    16. 

  16. </script>
    17. 

  17. <link href="doxygen.css" rel="stylesheet" type="text/css" />
    18. 

  18. </head>
    19. 

  19. <body>
    20. 

  20. <div id="top"><!-- do not remove this div, it is closed by doxygen! -->
    21. 

  21. <div id="titlearea">
    22. 

  22. <table cellspacing="0" cellpadding="0">
    23. 

  23.  <tbody>
    24. 

  24.  <tr style="height: 56px;">
    25. 

  25.   <td id="projectalign" style="padding-left: 0.5em;">
    26. 

  26.    <div id="projectname">CoffeePi
    27. 

  27.    </div>
    28. 

  28.    <div id="projectbrief">Coffee machine control for Raspberry Pi</div>
    29. 

  29.   </td>
    30. 

  30.  </tr>
    31. 

  31.  </tbody>
    32. 

  32. </table>
    33. 

  33. </div>
    34. 

  34. <!-- end header part -->
    35. 

  35. <!-- Generated by Doxygen 1.8.10 -->
    36. 

  36. <script type="text/javascript">
    37. 

  37. var searchBox = new SearchBox("searchBox", "search",false,'Search');
    38. 

  38. </script>
    39. 

  39.   <div id="navrow1" class="tabs">
    40. 

  40.     <ul class="tablist">
    41. 

  41.       <li><a href="index.html"><span>Main&#160;Page</span></a></li>
    42. 

  42.       <li><a href="annotated.html"><span>Data&#160;Structures</span></a></li>
    43. 

  43.       <li class="current"><a href="files.html"><span>Files</span></a></li>
    44. 

  44.       <li>
    45. 

  45.         <div id="MSearchBox" class="MSearchBoxInactive">
    46. 

  46.         <span class="left">
    47. 

  47.           <img id="MSearchSelect" src="search/mag_sel.png"
    48. 

  48.                onmouseover="return searchBox.OnSearchSelectShow()"
    49. 

  49.                onmouseout="return searchBox.OnSearchSelectHide()"
    50. 

  50.                alt=""/>
    51. 

  51.           <input type="text" id="MSearchField" value="Search" accesskey="S"
    52. 

  52.                onfocus="searchBox.OnSearchFieldFocus(true)" 
    53. 

  53.                onblur="searchBox.OnSearchFieldFocus(false)" 
    54. 

  54.                onkeyup="searchBox.OnSearchFieldChange(event)"/>
    55. 

  55.           </span><span class="right">
    56. 

  56.             <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
    57. 

  57.           </span>
    58. 

  58.         </div>
    59. 

  59.       </li>
    60. 

  60.     </ul>
    61. 

  61.   </div>
    62. 

  62.   <div id="navrow2" class="tabs2">
    63. 

  63.     <ul class="tablist">
    64. 

  64.       <li><a href="files.html"><span>File&#160;List</span></a></li>
    65. 

  65.       <li><a href="globals.html"><span>Globals</span></a></li>
    66. 

  66.     </ul>
    67. 

  67.   </div>
    68. 

  68. <!-- window showing the filter options -->
    69. 

  69. <div id="MSearchSelectWindow"
    70. 

  70.      onmouseover="return searchBox.OnSearchSelectShow()"
    71. 

  71.      onmouseout="return searchBox.OnSearchSelectHide()"
    72. 

  72.      onkeydown="return searchBox.OnSearchSelectKey(event)">
    73. 

  73. </div>
    74. 

  74. 

  75. <!-- iframe showing the search results (closed by default) -->
    76. 

  76. <div id="MSearchResultsWindow">
    77. 

  77. <iframe src="javascript:void(0)" frameborder="0" 
    78. 

  78.         name="MSearchResults" id="MSearchResults">
    79. 

  79. </iframe>
    80. 

  80. </div>
    81. 

  81. 

  82. </div><!-- top -->
    83. 

  83. <div class="header">
    84. 

  84.   <div class="summary">
    85. 

  85. <a href="#enum-members">Enumerations</a> &#124;
    86. 

  86. <a href="#func-members">Functions</a>  </div>
    87. 

  87.   <div class="headertitle">
    88. 

  88. <div class="title">database.h File Reference</div>  </div>
    89. 

  89. </div><!--header-->
    90. 

  90. <div class="contents">
    91. 

  91. <div class="textblock"><code>#include &lt;string&gt;</code><br />
    92. 

  92. <code>#include &lt;stdexcept&gt;</code><br />
    93. 

  93. <code>#include &lt;cstdio&gt;</code><br />
    94. 

  94. <code>#include &lt;stdlib.h&gt;</code><br />
    95. 

  95. <code>#include &lt;inttypes.h&gt;</code><br />
    96. 

  96. <code>#include &lt;cstdarg&gt;</code><br />
    97. 

  97. <code>#include &quot;sqlite/sqlite3.h&quot;</code><br />
    98. 

  98. </div>
    99. 

  99. <p><a href="database_8h_source.html">Go to the source code of this file.</a></p>
    100. 

  100. <table class="memberdecls">
    101. 

  101. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="enum-members"></a>
    102. 

  102. Enumerations</h2></td></tr>
    103. 

  103. <tr class="memitem:ae1822373f950fb4881633b7ec843f4df"><td class="memItemLeft" align="right" valign="top">enum &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4df">config_key_t</a> { <br />
    104. 

  104. &#160;&#160;<a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4dfaadc75f07a97300078de1c92bf6414827">CRC</a> = 1, 
    105. 

  105. <a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4dfababedca157bd5e1f8c299e61c197f62f">AliveCRC</a> = 2, 
    106. 

  106. <a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4dfa8408e147e8a938136f8a861d49dc9424">lastTC1</a> = 3, 
    107. 

  107. <a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4dfa59e22dd6cca23a1fc16c27b051e515b5">lastTC2</a> = 4, 
    108. 

  108. <br />
    109. 

  109. &#160;&#160;<a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4dfa3e3cdc9f9da298c1b6d46c49b1421848">lastTC3</a> = 5, 
    110. 

  110. <a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4dfa6e580e65e5c126a239a8e27157ec96a4">lastTerm</a> = 6, 
    111. 

  111. <a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4dfa221e2bd4755481003e8fe6ca37c66eb1">testSlowCnt</a> = 7
    112. 

  112. <br />
    113. 

  113.  }<tr class="separator:ae1822373f950fb4881633b7ec843f4df"><td class="memSeparator" colspan="2">&#160;</td></tr>
    114. 

  114. </td></tr>
    115. 

  115. </table><table class="memberdecls">
    116. 

  116. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a>
    117. 

  117. Functions</h2></td></tr>
    118. 

  118. <tr class="memitem:a1885a74e6af3ee510f30f98e60372e3e"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#a1885a74e6af3ee510f30f98e60372e3e">sqlOpen</a> ()</td></tr>
    119. 

  119. <tr class="memdesc:a1885a74e6af3ee510f30f98e60372e3e"><td class="mdescLeft">&#160;</td><td class="mdescRight">Opens and initializes a sqlite3 database connection.  <a href="#a1885a74e6af3ee510f30f98e60372e3e">More...</a><br /></td></tr>
    120. 

  120. <tr class="separator:a1885a74e6af3ee510f30f98e60372e3e"><td class="memSeparator" colspan="2">&#160;</td></tr>
    121. 

  121. <tr class="memitem:a7264f51f982e908b32635e91e6dc0062"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#a7264f51f982e908b32635e91e6dc0062">sqlClose</a> ()</td></tr>
    122. 

  122. <tr class="memdesc:a7264f51f982e908b32635e91e6dc0062"><td class="mdescLeft">&#160;</td><td class="mdescRight">Closes the database connection.  <a href="#a7264f51f982e908b32635e91e6dc0062">More...</a><br /></td></tr>
    123. 

  123. <tr class="separator:a7264f51f982e908b32635e91e6dc0062"><td class="memSeparator" colspan="2">&#160;</td></tr>
    124. 

  124. <tr class="memitem:aaed3fb776c9dc76d262df026803d3b8c"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#aaed3fb776c9dc76d262df026803d3b8c">sqlSetup</a> ()</td></tr>
    125. 

  125. <tr class="memdesc:aaed3fb776c9dc76d262df026803d3b8c"><td class="mdescLeft">&#160;</td><td class="mdescRight">Sets up the database and creates the needed structure.  <a href="#aaed3fb776c9dc76d262df026803d3b8c">More...</a><br /></td></tr>
    126. 

  126. <tr class="separator:aaed3fb776c9dc76d262df026803d3b8c"><td class="memSeparator" colspan="2">&#160;</td></tr>
    127. 

  127. <tr class="memitem:afd88a963f835215b8dad9ee9e49866dc"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#afd88a963f835215b8dad9ee9e49866dc">sqlExecute</a> (string query)</td></tr>
    128. 

  128. <tr class="memdesc:afd88a963f835215b8dad9ee9e49866dc"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes a SQL statement.  <a href="#afd88a963f835215b8dad9ee9e49866dc">More...</a><br /></td></tr>
    129. 

  129. <tr class="separator:afd88a963f835215b8dad9ee9e49866dc"><td class="memSeparator" colspan="2">&#160;</td></tr>
    130. 

  130. <tr class="memitem:a6ad9c375b101ce2cb461975eb2748b93"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#a6ad9c375b101ce2cb461975eb2748b93">sqlInsertNode</a> (uint8_t *guid, bool terminal)</td></tr>
    131. 

  131. <tr class="separator:a6ad9c375b101ce2cb461975eb2748b93"><td class="memSeparator" colspan="2">&#160;</td></tr>
    132. 

  132. <tr class="memitem:ae28580072312f213d923d9b145e3dc90"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#ae28580072312f213d923d9b145e3dc90">sqlReadNodes</a> ()</td></tr>
    133. 

  133. <tr class="separator:ae28580072312f213d923d9b145e3dc90"><td class="memSeparator" colspan="2">&#160;</td></tr>
    134. 

  134. <tr class="memitem:a437086982a7400d7205f3ab6600e6dcf"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#a437086982a7400d7205f3ab6600e6dcf">inttochar</a> (uint8_t *guid)</td></tr>
    135. 

  135. <tr class="memdesc:a437086982a7400d7205f3ab6600e6dcf"><td class="mdescLeft">&#160;</td><td class="mdescRight">Converts the GUID from int to char array.  <a href="#a437086982a7400d7205f3ab6600e6dcf">More...</a><br /></td></tr>
    136. 

  136. <tr class="separator:a437086982a7400d7205f3ab6600e6dcf"><td class="memSeparator" colspan="2">&#160;</td></tr>
    137. 

  137. <tr class="memitem:ad2d2a73c367513b8b71aff5546276a3c"><td class="memItemLeft" align="right" valign="top">uint8_t *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#ad2d2a73c367513b8b71aff5546276a3c">chartoint</a> (const unsigned char *guid)</td></tr>
    138. 

  138. <tr class="memdesc:ad2d2a73c367513b8b71aff5546276a3c"><td class="mdescLeft">&#160;</td><td class="mdescRight">Converts the GUID from char to int array.  <a href="#ad2d2a73c367513b8b71aff5546276a3c">More...</a><br /></td></tr>
    139. 

  139. <tr class="separator:ad2d2a73c367513b8b71aff5546276a3c"><td class="memSeparator" colspan="2">&#160;</td></tr>
    140. 

  140. <tr class="memitem:a28dbbb9e24e2035535645629105aea46"><td class="memItemLeft" align="right" valign="top">uint8_t *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#a28dbbb9e24e2035535645629105aea46">int64to8bit</a> (sqlite_int64 guid)</td></tr>
    141. 

  141. <tr class="memdesc:a28dbbb9e24e2035535645629105aea46"><td class="mdescLeft">&#160;</td><td class="mdescRight">Converts the GUID from int64 to int8 array.  <a href="#a28dbbb9e24e2035535645629105aea46">More...</a><br /></td></tr>
    142. 

  142. <tr class="separator:a28dbbb9e24e2035535645629105aea46"><td class="memSeparator" colspan="2">&#160;</td></tr>
    143. 

  143. <tr class="memitem:a99cc529fd785c752cd4b73ea7989521d"><td class="memItemLeft" align="right" valign="top">sqlite_int64&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#a99cc529fd785c752cd4b73ea7989521d">int8to64bit</a> (uint8_t *guid)</td></tr>
    144. 

  144. <tr class="separator:a99cc529fd785c752cd4b73ea7989521d"><td class="memSeparator" colspan="2">&#160;</td></tr>
    145. 

  145. <tr class="memitem:a5d0363e5d886e2c3e4bb5ca46d265ba7"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#a5d0363e5d886e2c3e4bb5ca46d265ba7">sqltest</a> ()</td></tr>
    146. 

  146. <tr class="separator:a5d0363e5d886e2c3e4bb5ca46d265ba7"><td class="memSeparator" colspan="2">&#160;</td></tr>
    147. 

  147. <tr class="memitem:a6c0bc3256310fd400a26243d8a8f1652"><td class="memItemLeft" align="right" valign="top">std::string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#a6c0bc3256310fd400a26243d8a8f1652">string_sprintf</a> (const char *format,...)</td></tr>
    148. 

  148. <tr class="memdesc:a6c0bc3256310fd400a26243d8a8f1652"><td class="mdescLeft">&#160;</td><td class="mdescRight">Allows the format of printf but returns a string Source: <a href="http://codereview.stackexchange.com/questions/52522/mimic-sprintf-with-stdstring-output">http://codereview.stackexchange.com/questions/52522/mimic-sprintf-with-stdstring-output</a>.  <a href="#a6c0bc3256310fd400a26243d8a8f1652">More...</a><br /></td></tr>
    149. 

  149. <tr class="separator:a6c0bc3256310fd400a26243d8a8f1652"><td class="memSeparator" colspan="2">&#160;</td></tr>
    150. 

  150. <tr class="memitem:aad0e803eda7a440a6063a447cfeca0cd"><td class="memItemLeft" align="right" valign="top">uint64_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#aad0e803eda7a440a6063a447cfeca0cd">sqlGetConf</a> (<a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4df">config_key_t</a> id)</td></tr>
    151. 

  151. <tr class="memdesc:aad0e803eda7a440a6063a447cfeca0cd"><td class="mdescLeft">&#160;</td><td class="mdescRight">Reads a configuration key from the database.  <a href="#aad0e803eda7a440a6063a447cfeca0cd">More...</a><br /></td></tr>
    152. 

  152. <tr class="separator:aad0e803eda7a440a6063a447cfeca0cd"><td class="memSeparator" colspan="2">&#160;</td></tr>
    153. 

  153. <tr class="memitem:a1ce0ac0c58916c138a92d3282f569784"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="database_8h.html#a1ce0ac0c58916c138a92d3282f569784">sqlSetConf</a> (<a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4df">config_key_t</a> id, uint64_t value)</td></tr>
    154. 

  154. <tr class="memdesc:a1ce0ac0c58916c138a92d3282f569784"><td class="mdescLeft">&#160;</td><td class="mdescRight">Saves a configuration key to the database.  <a href="#a1ce0ac0c58916c138a92d3282f569784">More...</a><br /></td></tr>
    155. 

  155. <tr class="separator:a1ce0ac0c58916c138a92d3282f569784"><td class="memSeparator" colspan="2">&#160;</td></tr>
    156. 

  156. </table>
    157. 

  157. <h2 class="groupheader">Enumeration Type Documentation</h2>
    158. 

  158. <a class="anchor" id="ae1822373f950fb4881633b7ec843f4df"></a>
    159. 

  159. <div class="memitem">
    160. 

  160. <div class="memproto">
    161. 

  161.       <table class="memname">
    162. 

  162.         <tr>
    163. 

  163.           <td class="memname">enum <a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4df">config_key_t</a></td>
    164. 

  164.         </tr>
    165. 

  165.       </table>
    166. 

  166. </div><div class="memdoc">
    167. 

  167. <table class="fieldtable">
    168. 

  168. <tr><th colspan="2">Enumerator</th></tr><tr><td class="fieldname"><a class="anchor" id="ae1822373f950fb4881633b7ec843f4dfaadc75f07a97300078de1c92bf6414827"></a>CRC&#160;</td><td class="fielddoc">
    169. 

  169. </td></tr>
    170. 

  170. <tr><td class="fieldname"><a class="anchor" id="ae1822373f950fb4881633b7ec843f4dfababedca157bd5e1f8c299e61c197f62f"></a>AliveCRC&#160;</td><td class="fielddoc">
    171. 

  171. </td></tr>
    172. 

  172. <tr><td class="fieldname"><a class="anchor" id="ae1822373f950fb4881633b7ec843f4dfa8408e147e8a938136f8a861d49dc9424"></a>lastTC1&#160;</td><td class="fielddoc">
    173. 

  173. </td></tr>
    174. 

  174. <tr><td class="fieldname"><a class="anchor" id="ae1822373f950fb4881633b7ec843f4dfa59e22dd6cca23a1fc16c27b051e515b5"></a>lastTC2&#160;</td><td class="fielddoc">
    175. 

  175. </td></tr>
    176. 

  176. <tr><td class="fieldname"><a class="anchor" id="ae1822373f950fb4881633b7ec843f4dfa3e3cdc9f9da298c1b6d46c49b1421848"></a>lastTC3&#160;</td><td class="fielddoc">
    177. 

  177. </td></tr>
    178. 

  178. <tr><td class="fieldname"><a class="anchor" id="ae1822373f950fb4881633b7ec843f4dfa6e580e65e5c126a239a8e27157ec96a4"></a>lastTerm&#160;</td><td class="fielddoc">
    179. 

  179. </td></tr>
    180. 

  180. <tr><td class="fieldname"><a class="anchor" id="ae1822373f950fb4881633b7ec843f4dfa221e2bd4755481003e8fe6ca37c66eb1"></a>testSlowCnt&#160;</td><td class="fielddoc">
    181. 

  181. </td></tr>
    182. 

  182. </table>
    183. 

  183. 

  184. </div>
    185. 

  185. </div>
    186. 

  186. <h2 class="groupheader">Function Documentation</h2>
    187. 

  187. <a class="anchor" id="ad2d2a73c367513b8b71aff5546276a3c"></a>
    188. 

  188. <div class="memitem">
    189. 

  189. <div class="memproto">
    190. 

  190.       <table class="memname">
    191. 

  191.         <tr>
    192. 

  192.           <td class="memname">uint8_t* chartoint </td>
    193. 

  193.           <td>(</td>
    194. 

  194.           <td class="paramtype">const unsigned char *&#160;</td>
    195. 

  195.           <td class="paramname"><em>guid</em></td><td>)</td>
    196. 

  196.           <td></td>
    197. 

  197.         </tr>
    198. 

  198.       </table>
    199. 

  199. </div><div class="memdoc">
    200. 

  200. 

  201. <p>Converts the GUID from char to int array. </p>
    202. 

  202. <dl class="params"><dt>Parameters</dt><dd>
    203. 

  203.   <table class="params">
    204. 

  204.     <tr><td class="paramname">*guid</td><td>Pointer to the char GUID </td></tr>
    205. 

  205.   </table>
    206. 

  206.   </dd>
    207. 

  207. </dl>
    208. 

  208. <dl class="section return"><dt>Returns</dt><dd>pointer to the converted int array </dd></dl>
    209. 

  209. 

  210. </div>
    211. 

  211. </div>
    212. 

  212. <a class="anchor" id="a28dbbb9e24e2035535645629105aea46"></a>
    213. 

  213. <div class="memitem">
    214. 

  214. <div class="memproto">
    215. 

  215.       <table class="memname">
    216. 

  216.         <tr>
    217. 

  217.           <td class="memname">uint8_t* int64to8bit </td>
    218. 

  218.           <td>(</td>
    219. 

  219.           <td class="paramtype">sqlite_int64&#160;</td>
    220. 

  220.           <td class="paramname"><em>guid</em></td><td>)</td>
    221. 

  221.           <td></td>
    222. 

  222.         </tr>
    223. 

  223.       </table>
    224. 

  224. </div><div class="memdoc">
    225. 

  225. 

  226. <p>Converts the GUID from int64 to int8 array. </p>
    227. 

  227. <dl class="params"><dt>Parameters</dt><dd>
    228. 

  228.   <table class="params">
    229. 

  229.     <tr><td class="paramname">guid</td><td>64bit GUID </td></tr>
    230. 

  230.   </table>
    231. 

  231.   </dd>
    232. 

  232. </dl>
    233. 

  233. <dl class="section return"><dt>Returns</dt><dd>pointer to the converted int array </dd></dl>
    234. 

  234. 

  235. </div>
    236. 

  236. </div>
    237. 

  237. <a class="anchor" id="a99cc529fd785c752cd4b73ea7989521d"></a>
    238. 

  238. <div class="memitem">
    239. 

  239. <div class="memproto">
    240. 

  240.       <table class="memname">
    241. 

  241.         <tr>
    242. 

  242.           <td class="memname">sqlite_int64 int8to64bit </td>
    243. 

  243.           <td>(</td>
    244. 

  244.           <td class="paramtype">uint8_t *&#160;</td>
    245. 

  245.           <td class="paramname"><em>guid</em></td><td>)</td>
    246. 

  246.           <td></td>
    247. 

  247.         </tr>
    248. 

  248.       </table>
    249. 

  249. </div><div class="memdoc">
    250. 

  250. 

  251. </div>
    252. 

  252. </div>
    253. 

  253. <a class="anchor" id="a437086982a7400d7205f3ab6600e6dcf"></a>
    254. 

  254. <div class="memitem">
    255. 

  255. <div class="memproto">
    256. 

  256.       <table class="memname">
    257. 

  257.         <tr>
    258. 

  258.           <td class="memname">char* inttochar </td>
    259. 

  259.           <td>(</td>
    260. 

  260.           <td class="paramtype">uint8_t *&#160;</td>
    261. 

  261.           <td class="paramname"><em>guid</em></td><td>)</td>
    262. 

  262.           <td></td>
    263. 

  263.         </tr>
    264. 

  264.       </table>
    265. 

  265. </div><div class="memdoc">
    266. 

  266. 

  267. <p>Converts the GUID from int to char array. </p>
    268. 

  268. <dl class="params"><dt>Parameters</dt><dd>
    269. 

  269.   <table class="params">
    270. 

  270.     <tr><td class="paramname">*guid</td><td>Pointer to the uint8_t GUID </td></tr>
    271. 

  271.   </table>
    272. 

  272.   </dd>
    273. 

  273. </dl>
    274. 

  274. <dl class="section return"><dt>Returns</dt><dd>pointer to the converted string </dd></dl>
    275. 

  275. 

  276. </div>
    277. 

  277. </div>
    278. 

  278. <a class="anchor" id="a7264f51f982e908b32635e91e6dc0062"></a>
    279. 

  279. <div class="memitem">
    280. 

  280. <div class="memproto">
    281. 

  281.       <table class="memname">
    282. 

  282.         <tr>
    283. 

  283.           <td class="memname">void sqlClose </td>
    284. 

  284.           <td>(</td>
    285. 

  285.           <td class="paramname"></td><td>)</td>
    286. 

  286.           <td></td>
    287. 

  287.         </tr>
    288. 

  288.       </table>
    289. 

  289. </div><div class="memdoc">
    290. 

  290. 

  291. <p>Closes the database connection. </p>
    292. 

  292. 

  293. </div>
    294. 

  294. </div>
    295. 

  295. <a class="anchor" id="afd88a963f835215b8dad9ee9e49866dc"></a>
    296. 

  296. <div class="memitem">
    297. 

  297. <div class="memproto">
    298. 

  298.       <table class="memname">
    299. 

  299.         <tr>
    300. 

  300.           <td class="memname">int sqlExecute </td>
    301. 

  301.           <td>(</td>
    302. 

  302.           <td class="paramtype">string&#160;</td>
    303. 

  303.           <td class="paramname"><em>query</em></td><td>)</td>
    304. 

  304.           <td></td>
    305. 

  305.         </tr>
    306. 

  306.       </table>
    307. 

  307. </div><div class="memdoc">
    308. 

  308. 

  309. <p>Executes a SQL statement. </p>
    310. 

  310. <dl class="params"><dt>Parameters</dt><dd>
    311. 

  311.   <table class="params">
    312. 

  312.     <tr><td class="paramname">*query</td><td>SQL query string </td></tr>
    313. 

  313.   </table>
    314. 

  314.   </dd>
    315. 

  315. </dl>
    316. 

  316. <dl class="section return"><dt>Returns</dt><dd>0 on success </dd></dl>
    317. 

  317. 

  318. </div>
    319. 

  319. </div>
    320. 

  320. <a class="anchor" id="aad0e803eda7a440a6063a447cfeca0cd"></a>
    321. 

  321. <div class="memitem">
    322. 

  322. <div class="memproto">
    323. 

  323.       <table class="memname">
    324. 

  324.         <tr>
    325. 

  325.           <td class="memname">uint64_t sqlGetConf </td>
    326. 

  326.           <td>(</td>
    327. 

  327.           <td class="paramtype"><a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4df">config_key_t</a>&#160;</td>
    328. 

  328.           <td class="paramname"><em>id</em></td><td>)</td>
    329. 

  329.           <td></td>
    330. 

  330.         </tr>
    331. 

  331.       </table>
    332. 

  332. </div><div class="memdoc">
    333. 

  333. 

  334. <p>Reads a configuration key from the database. </p>
    335. 

  335. <dl class="params"><dt>Parameters</dt><dd>
    336. 

  336.   <table class="params">
    337. 

  337.     <tr><td class="paramname">id</td><td>Config ID key </td></tr>
    338. 

  338.   </table>
    339. 

  339.   </dd>
    340. 

  340. </dl>
    341. 

  341. <dl class="section return"><dt>Returns</dt><dd>value as integer (up to 64bit), 0 for not found </dd></dl>
    342. 

  342. 

  343. </div>
    344. 

  344. </div>
    345. 

  345. <a class="anchor" id="a6ad9c375b101ce2cb461975eb2748b93"></a>
    346. 

  346. <div class="memitem">
    347. 

  347. <div class="memproto">
    348. 

  348.       <table class="memname">
    349. 

  349.         <tr>
    350. 

  350.           <td class="memname">int sqlInsertNode </td>
    351. 

  351.           <td>(</td>
    352. 

  352.           <td class="paramtype">uint8_t *&#160;</td>
    353. 

  353.           <td class="paramname"><em>guid</em>, </td>
    354. 

  354.         </tr>
    355. 

  355.         <tr>
    356. 

  356.           <td class="paramkey"></td>
    357. 

  357.           <td></td>
    358. 

  358.           <td class="paramtype">bool&#160;</td>
    359. 

  359.           <td class="paramname"><em>terminal</em>&#160;</td>
    360. 

  360.         </tr>
    361. 

  361.         <tr>
    362. 

  362.           <td></td>
    363. 

  363.           <td>)</td>
    364. 

  364.           <td></td><td></td>
    365. 

  365.         </tr>
    366. 

  366.       </table>
    367. 

  367. </div><div class="memdoc">
    368. 

  368. 

  369. </div>
    370. 

  370. </div>
    371. 

  371. <a class="anchor" id="a1885a74e6af3ee510f30f98e60372e3e"></a>
    372. 

  372. <div class="memitem">
    373. 

  373. <div class="memproto">
    374. 

  374.       <table class="memname">
    375. 

  375.         <tr>
    376. 

  376.           <td class="memname">int sqlOpen </td>
    377. 

  377.           <td>(</td>
    378. 

  378.           <td class="paramname"></td><td>)</td>
    379. 

  379.           <td></td>
    380. 

  380.         </tr>
    381. 

  381.       </table>
    382. 

  382. </div><div class="memdoc">
    383. 

  383. 

  384. <p>Opens and initializes a sqlite3 database connection. </p>
    385. 

  385. <dl class="section return"><dt>Returns</dt><dd>0 on success </dd></dl>
    386. 

  386. 

  387. </div>
    388. 

  388. </div>
    389. 

  389. <a class="anchor" id="ae28580072312f213d923d9b145e3dc90"></a>
    390. 

  390. <div class="memitem">
    391. 

  391. <div class="memproto">
    392. 

  392.       <table class="memname">
    393. 

  393.         <tr>
    394. 

  394.           <td class="memname">int sqlReadNodes </td>
    395. 

  395.           <td>(</td>
    396. 

  396.           <td class="paramname"></td><td>)</td>
    397. 

  397.           <td></td>
    398. 

  398.         </tr>
    399. 

  399.       </table>
    400. 

  400. </div><div class="memdoc">
    401. 

  401. 

  402. </div>
    403. 

  403. </div>
    404. 

  404. <a class="anchor" id="a1ce0ac0c58916c138a92d3282f569784"></a>
    405. 

  405. <div class="memitem">
    406. 

  406. <div class="memproto">
    407. 

  407.       <table class="memname">
    408. 

  408.         <tr>
    409. 

  409.           <td class="memname">int sqlSetConf </td>
    410. 

  410.           <td>(</td>
    411. 

  411.           <td class="paramtype"><a class="el" href="database_8h.html#ae1822373f950fb4881633b7ec843f4df">config_key_t</a>&#160;</td>
    412. 

  412.           <td class="paramname"><em>id</em>, </td>
    413. 

  413.         </tr>
    414. 

  414.         <tr>
    415. 

  415.           <td class="paramkey"></td>
    416. 

  416.           <td></td>
    417. 

  417.           <td class="paramtype">uint64_t&#160;</td>
    418. 

  418.           <td class="paramname"><em>value</em>&#160;</td>
    419. 

  419.         </tr>
    420. 

  420.         <tr>
    421. 

  421.           <td></td>
    422. 

  422.           <td>)</td>
    423. 

  423.           <td></td><td></td>
    424. 

  424.         </tr>
    425. 

  425.       </table>
    426. 

  426. </div><div class="memdoc">
    427. 

  427. 

  428. <p>Saves a configuration key to the database. </p>
    429. 

  429. <dl class="params"><dt>Parameters</dt><dd>
    430. 

  430.   <table class="params">
    431. 

  431.     <tr><td class="paramname">id</td><td>Config ID key </td></tr>
    432. 

  432.     <tr><td class="paramname">value</td><td>Integer value </td></tr>
    433. 

  433.   </table>
    434. 

  434.   </dd>
    435. 

  435. </dl>
    436. 

  436. <dl class="section return"><dt>Returns</dt><dd>0 on success </dd></dl>
    437. 

  437. 

  438. </div>
    439. 

  439. </div>
    440. 

  440. <a class="anchor" id="aaed3fb776c9dc76d262df026803d3b8c"></a>
    441. 

  441. <div class="memitem">
    442. 

  442. <div class="memproto">
    443. 

  443.       <table class="memname">
    444. 

  444.         <tr>
    445. 

  445.           <td class="memname">int sqlSetup </td>
    446. 

  446.           <td>(</td>
    447. 

  447.           <td class="paramname"></td><td>)</td>
    448. 

  448.           <td></td>
    449. 

  449.         </tr>
    450. 

  450.       </table>
    451. 

  451. </div><div class="memdoc">
    452. 

  452. 

  453. <p>Sets up the database and creates the needed structure. </p>
    454. 

  454. <dl class="section return"><dt>Returns</dt><dd>0 on success </dd></dl>
    455. 

  455. 

  456. </div>
    457. 

  457. </div>
    458. 

  458. <a class="anchor" id="a5d0363e5d886e2c3e4bb5ca46d265ba7"></a>
    459. 

  459. <div class="memitem">
    460. 

  460. <div class="memproto">
    461. 

  461.       <table class="memname">
    462. 

  462.         <tr>
    463. 

  463.           <td class="memname">void sqltest </td>
    464. 

  464.           <td>(</td>
    465. 

  465.           <td class="paramname"></td><td>)</td>
    466. 

  466.           <td></td>
    467. 

  467.         </tr>
    468. 

  468.       </table>
    469. 

  469. </div><div class="memdoc">
    470. 

  470. 

  471. </div>
    472. 

  472. </div>
    473. 

  473. <a class="anchor" id="a6c0bc3256310fd400a26243d8a8f1652"></a>
    474. 

  474. <div class="memitem">
    475. 

  475. <div class="memproto">
    476. 

  476.       <table class="memname">
    477. 

  477.         <tr>
    478. 

  478.           <td class="memname">std::string string_sprintf </td>
    479. 

  479.           <td>(</td>
    480. 

  480.           <td class="paramtype">const char *&#160;</td>
    481. 

  481.           <td class="paramname"><em>format</em>, </td>
    482. 

  482.         </tr>
    483. 

  483.         <tr>
    484. 

  484.           <td class="paramkey"></td>
    485. 

  485.           <td></td>
    486. 

  486.           <td class="paramtype">&#160;</td>
    487. 

  487.           <td class="paramname"><em>...</em>&#160;</td>
    488. 

  488.         </tr>
    489. 

  489.         <tr>
    490. 

  490.           <td></td>
    491. 

  491.           <td>)</td>
    492. 

  492.           <td></td><td></td>
    493. 

  493.         </tr>
    494. 

  494.       </table>
    495. 

  495. </div><div class="memdoc">
    496. 

  496. 

  497. <p>Allows the format of printf but returns a string Source: <a href="http://codereview.stackexchange.com/questions/52522/mimic-sprintf-with-stdstring-output">http://codereview.stackexchange.com/questions/52522/mimic-sprintf-with-stdstring-output</a>. </p>
    498. 

  498. <dl class="section return"><dt>Returns</dt><dd>printf formatted string </dd></dl>
    499. 

  499. <dl class="params"><dt>Parameters</dt><dd>
    500. 

  500.   <table class="params">
    501. 

  501.     <tr><td class="paramname">format</td><td>input string as char array </td></tr>
    502. 

  502.   </table>
    503. 

  503.   </dd>
    504. 

  504. </dl>
    505. 

  505. 

  506. </div>
    507. 

  507. </div>
    508. 

  508. </div><!-- contents -->
    509. 

  509. <!-- start footer part -->
    510. 

  510. <hr class="footer"/><address class="footer"><small>
    511. 

  511. Generated by &#160;<a href="http://www.doxygen.org/index.html">
    512. 

  512. <img class="footer" src="doxygen.png" alt="doxygen"/>
    513. 

  513. </a> 1.8.10
    514. 

  514. </small></address>
    515. 

  515. </body>
    516. 

  516. </html>
    517.