<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://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 name="robots" content="index,follow"/>
<title>stdair/command/DBManagerForAirlines.cpp Source File</title>
<link rel="shortcut icon" href="favicon.ico">
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="stdair.css" rel="stylesheet" type="text/css"/>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
$(document).ready(initResizable);
$(window).load(resizeHeight);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
$(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
<script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-24867310-1']);
_gaq.push(['_setDomainName', 'none']);
_gaq.push(['_setAllowLinker', true]);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script>
<script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script>
</head>
<body>
<div id="top"><!-- do not remove this div! -->
<div id="titlearea">
<table width="100%">
<tbody>
<tr style="height: 56px;">
<td style="padding-left: 0.5em;">
<div id="projectname"><a href="http://stdair.sourceforge.net"><img height="45px" alt="StdAir Logo" src="stdair_logo.png"></a>
 <span id="projectnumber">1.00.1</span>
</div>
<div id="projectbrief">C++ Standard Airline IT Object Library</div>
</td>
<!-- begin SOURCEFORGE_CUSTOM-->
<td>
<div id="sflogo"><a href="http://stdair.sourceforge.net"><img height="45px" alt="SourceForge Logo" src="sfx_logo.png"></a></div>
</td>
<!-- end SOURCEFORGE_CUSTOM-->
</tr>
</tbody>
</table>
</div>
<!-- Generated by Doxygen 1.8.3.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
<div id="navrow1" class="tabs">
<ul class="tablist">
<li><a href="index.html"><span>Main Page</span></a></li>
<li><a href="pages.html"><span>Related Pages</span></a></li>
<li><a href="namespaces.html"><span>Namespaces</span></a></li>
<li><a href="annotated.html"><span>Classes</span></a></li>
<li class="current"><a href="files.html"><span>Files</span></a></li>
<li>
<div id="MSearchBox" class="MSearchBoxInactive">
<span class="left">
<img id="MSearchSelect" src="search/mag_sel.png"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
alt=""/>
<input type="text" id="MSearchField" value="Search" accesskey="S"
onfocus="searchBox.OnSearchFieldFocus(true)"
onblur="searchBox.OnSearchFieldFocus(false)"
onkeyup="searchBox.OnSearchFieldChange(event)"/>
</span><span class="right">
<a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
</span>
</div>
</li>
</ul>
</div>
<div id="navrow2" class="tabs2">
<ul class="tablist">
<li><a href="files.html"><span>File List</span></a></li>
<li><a href="globals.html"><span>File Members</span></a></li>
</ul>
</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">
$(document).ready(function(){initNavTree('a00477_source.html','');});
</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)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(9)"><span class="SelectionMark"> </span>Friends</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(10)"><span class="SelectionMark"> </span>Macros</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(11)"><span class="SelectionMark"> </span>Pages</a></div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0"
name="MSearchResults" id="MSearchResults">
</iframe>
</div>
<div class="header">
<div class="headertitle">
<div class="title">DBManagerForAirlines.cpp</div> </div>
</div><!--header-->
<div class="contents">
<a href="a00477.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno"> 1</span> <span class="comment">// //////////////////////////////////////////////////////////////////////</span></div>
<div class="line"><a name="l00002"></a><span class="lineno"> 2</span> <span class="comment">// Import section</span></div>
<div class="line"><a name="l00003"></a><span class="lineno"> 3</span> <span class="comment">// //////////////////////////////////////////////////////////////////////</span></div>
<div class="line"><a name="l00004"></a><span class="lineno"> 4</span> <span class="comment">// STL</span></div>
<div class="line"><a name="l00005"></a><span class="lineno"> 5</span> <span class="preprocessor">#include <cassert></span></div>
<div class="line"><a name="l00006"></a><span class="lineno"> 6</span> <span class="comment">// SOCI</span></div>
<div class="line"><a name="l00007"></a><span class="lineno"> 7</span> <span class="preprocessor">#if defined(SOCI_HEADERS_BURIED)</span></div>
<div class="line"><a name="l00008"></a><span class="lineno"> 8</span> <span class="preprocessor"></span><span class="preprocessor">#include <soci/core/soci.h></span></div>
<div class="line"><a name="l00009"></a><span class="lineno"> 9</span> <span class="preprocessor">#include <soci/backends/mysql/soci-mysql.h></span></div>
<div class="line"><a name="l00010"></a><span class="lineno"> 10</span> <span class="preprocessor">#else // SOCI_HEADERS_BURIED</span></div>
<div class="line"><a name="l00011"></a><span class="lineno"> 11</span> <span class="preprocessor"></span><span class="preprocessor">#include <soci.h></span></div>
<div class="line"><a name="l00012"></a><span class="lineno"> 12</span> <span class="preprocessor">#include <mysql/soci-mysql.h></span></div>
<div class="line"><a name="l00013"></a><span class="lineno"> 13</span> <span class="preprocessor">#endif // SOCI_HEADERS_BURIED</span></div>
<div class="line"><a name="l00014"></a><span class="lineno"> 14</span> <span class="preprocessor"></span><span class="comment">// StdAir</span></div>
<div class="line"><a name="l00015"></a><span class="lineno"> 15</span> <span class="preprocessor">#include <<a class="code" href="a00505.html">stdair/stdair_basic_types.hpp</a>></span></div>
<div class="line"><a name="l00016"></a><span class="lineno"> 16</span> <span class="preprocessor">#include <<a class="code" href="a00510.html">stdair/stdair_exceptions.hpp</a>></span></div>
<div class="line"><a name="l00017"></a><span class="lineno"> 17</span> <span class="preprocessor">#include <<a class="code" href="a00283.html">stdair/bom/AirlineStruct.hpp</a>></span></div>
<div class="line"><a name="l00018"></a><span class="lineno"> 18</span> <span class="preprocessor">#include <<a class="code" href="a00483.html">stdair/dbadaptor/DbaAirline.hpp</a>></span></div>
<div class="line"><a name="l00019"></a><span class="lineno"> 19</span> <span class="preprocessor">#include <<a class="code" href="a00478.html">stdair/command/DBManagerForAirlines.hpp</a>></span></div>
<div class="line"><a name="l00020"></a><span class="lineno"> 20</span> <span class="preprocessor">#include <<a class="code" href="a00499.html">stdair/service/Logger.hpp</a>></span></div>
<div class="line"><a name="l00021"></a><span class="lineno"> 21</span> </div>
<div class="line"><a name="l00022"></a><span class="lineno"> 22</span> <span class="keyword">namespace </span>stdair {</div>
<div class="line"><a name="l00023"></a><span class="lineno"> 23</span> </div>
<div class="line"><a name="l00024"></a><span class="lineno"> 24</span>  <span class="comment">// //////////////////////////////////////////////////////////////////////</span></div>
<div class="line"><a name="l00025"></a><span class="lineno"> 25</span>  <span class="keywordtype">void</span> <a class="code" href="a00075.html#a55667f58ee75bdcb87793fe3262814df">DBManagerForAirlines::</a></div>
<div class="line"><a name="l00026"></a><span class="lineno"><a class="code" href="a00075.html#a55667f58ee75bdcb87793fe3262814df"> 26</a></span> <a class="code" href="a00075.html#a55667f58ee75bdcb87793fe3262814df"> prepareSelectStatement</a> (<a class="code" href="a00535.html#af9885c4dbd3b05a275c49b96aadd7165">DBSession_T</a>& ioSociSession,</div>
<div class="line"><a name="l00027"></a><span class="lineno"> 27</span>  <a class="code" href="a00535.html#a29d5eb8225d8560ae8ee69a8a2a01cb6">DBRequestStatement_T</a>& ioSelectStatement,</div>
<div class="line"><a name="l00028"></a><span class="lineno"> 28</span>  <a class="code" href="a00030.html">AirlineStruct</a>& ioAirline) {</div>
<div class="line"><a name="l00029"></a><span class="lineno"> 29</span>  </div>
<div class="line"><a name="l00030"></a><span class="lineno"> 30</span>  <span class="keywordflow">try</span> {</div>
<div class="line"><a name="l00031"></a><span class="lineno"> 31</span>  </div>
<div class="line"><a name="l00032"></a><span class="lineno"> 32</span>  <span class="comment">// Instanciate a SQL statement (no request is performed at that stage)</span></div>
<div class="line"><a name="l00038"></a><span class="lineno"> 38</span> <span class="comment"></span> ioSelectStatement = (ioSociSession.prepare</div>
<div class="line"><a name="l00039"></a><span class="lineno"> 39</span>  << <span class="stringliteral">"select iata_code, name "</span></div>
<div class="line"><a name="l00040"></a><span class="lineno"> 40</span>  << <span class="stringliteral">"from airlines "</span>, soci::into (ioAirline));</div>
<div class="line"><a name="l00041"></a><span class="lineno"> 41</span> </div>
<div class="line"><a name="l00042"></a><span class="lineno"> 42</span>  <span class="comment">// Execute the SQL query</span></div>
<div class="line"><a name="l00043"></a><span class="lineno"> 43</span>  ioSelectStatement.execute();</div>
<div class="line"><a name="l00044"></a><span class="lineno"> 44</span> </div>
<div class="line"><a name="l00045"></a><span class="lineno"> 45</span>  } <span class="keywordflow">catch</span> (std::exception <span class="keyword">const</span>& lException) {</div>
<div class="line"><a name="l00046"></a><span class="lineno"> 46</span>  <span class="keywordflow">throw</span> <a class="code" href="a00177.html">SQLDatabaseException</a> (lException.what());</div>
<div class="line"><a name="l00047"></a><span class="lineno"> 47</span>  }</div>
<div class="line"><a name="l00048"></a><span class="lineno"> 48</span>  }</div>
<div class="line"><a name="l00049"></a><span class="lineno"> 49</span> </div>
<div class="line"><a name="l00050"></a><span class="lineno"> 50</span>  <span class="comment">// //////////////////////////////////////////////////////////////////////</span></div>
<div class="line"><a name="l00051"></a><span class="lineno"> 51</span>  <span class="keywordtype">void</span> DBManagerForAirlines::</div>
<div class="line"><a name="l00052"></a><span class="lineno"> 52</span>  prepareSelectOnAirlineCodeStatement (<a class="code" href="a00535.html#af9885c4dbd3b05a275c49b96aadd7165">DBSession_T</a>& ioSociSession,</div>
<div class="line"><a name="l00053"></a><span class="lineno"> 53</span>  <a class="code" href="a00535.html#a29d5eb8225d8560ae8ee69a8a2a01cb6">DBRequestStatement_T</a>& ioSelectStatement,</div>
<div class="line"><a name="l00054"></a><span class="lineno"> 54</span>  <span class="keyword">const</span> <a class="code" href="a00535.html#ac0ab9f765621de3140cc27d6472f5581">AirlineCode_T</a>& iAirlineCode,</div>
<div class="line"><a name="l00055"></a><span class="lineno"> 55</span>  <a class="code" href="a00030.html">AirlineStruct</a>& ioAirline) {</div>
<div class="line"><a name="l00056"></a><span class="lineno"> 56</span>  </div>
<div class="line"><a name="l00057"></a><span class="lineno"> 57</span>  <span class="keywordflow">try</span> {</div>
<div class="line"><a name="l00058"></a><span class="lineno"> 58</span>  </div>
<div class="line"><a name="l00059"></a><span class="lineno"> 59</span>  <span class="comment">// Instanciate a SQL statement (no request is performed at that stage)</span></div>
<div class="line"><a name="l00066"></a><span class="lineno"> 66</span> <span class="comment"></span> ioSelectStatement = (ioSociSession.prepare</div>
<div class="line"><a name="l00067"></a><span class="lineno"> 67</span>  << <span class="stringliteral">"select iata_code, name "</span></div>
<div class="line"><a name="l00068"></a><span class="lineno"> 68</span>  << <span class="stringliteral">"from airlines "</span></div>
<div class="line"><a name="l00069"></a><span class="lineno"> 69</span>  << <span class="stringliteral">"where iata_code = :airline_code "</span>,</div>
<div class="line"><a name="l00070"></a><span class="lineno"> 70</span>  soci::into (ioAirline), soci::use (iAirlineCode));</div>
<div class="line"><a name="l00071"></a><span class="lineno"> 71</span> </div>
<div class="line"><a name="l00072"></a><span class="lineno"> 72</span>  <span class="comment">// Execute the SQL query</span></div>
<div class="line"><a name="l00073"></a><span class="lineno"> 73</span>  ioSelectStatement.execute();</div>
<div class="line"><a name="l00074"></a><span class="lineno"> 74</span> </div>
<div class="line"><a name="l00075"></a><span class="lineno"> 75</span>  } <span class="keywordflow">catch</span> (std::exception <span class="keyword">const</span>& lException) {</div>
<div class="line"><a name="l00076"></a><span class="lineno"> 76</span>  <span class="keywordflow">throw</span> SQLDatabaseException (lException.what());</div>
<div class="line"><a name="l00077"></a><span class="lineno"> 77</span>  }</div>
<div class="line"><a name="l00078"></a><span class="lineno"> 78</span>  }</div>
<div class="line"><a name="l00079"></a><span class="lineno"> 79</span> </div>
<div class="line"><a name="l00080"></a><span class="lineno"> 80</span>  <span class="comment">// //////////////////////////////////////////////////////////////////////</span></div>
<div class="line"><a name="l00081"></a><span class="lineno"> 81</span>  <span class="keywordtype">bool</span> <a class="code" href="a00075.html#aac370aa0b9bcdae2fbea716e83bf463b">DBManagerForAirlines::</a></div>
<div class="line"><a name="l00082"></a><span class="lineno"><a class="code" href="a00075.html#aac370aa0b9bcdae2fbea716e83bf463b"> 82</a></span> <a class="code" href="a00075.html#aac370aa0b9bcdae2fbea716e83bf463b"> iterateOnStatement</a> (<a class="code" href="a00535.html#a29d5eb8225d8560ae8ee69a8a2a01cb6">DBRequestStatement_T</a>& ioStatement,</div>
<div class="line"><a name="l00083"></a><span class="lineno"> 83</span>  <a class="code" href="a00030.html">AirlineStruct</a>& ioAirline) {</div>
<div class="line"><a name="l00084"></a><span class="lineno"> 84</span>  <span class="keywordtype">bool</span> hasStillData = <span class="keyword">false</span>;</div>
<div class="line"><a name="l00085"></a><span class="lineno"> 85</span>  </div>
<div class="line"><a name="l00086"></a><span class="lineno"> 86</span>  <span class="keywordflow">try</span> {</div>
<div class="line"><a name="l00087"></a><span class="lineno"> 87</span> </div>
<div class="line"><a name="l00088"></a><span class="lineno"> 88</span>  <span class="comment">// Retrieve the next row of Airline object</span></div>
<div class="line"><a name="l00089"></a><span class="lineno"> 89</span>  hasStillData = ioStatement.fetch();</div>
<div class="line"><a name="l00090"></a><span class="lineno"> 90</span>  </div>
<div class="line"><a name="l00091"></a><span class="lineno"> 91</span>  } <span class="keywordflow">catch</span> (std::exception <span class="keyword">const</span>& lException) {</div>
<div class="line"><a name="l00092"></a><span class="lineno"> 92</span>  <span class="keywordflow">throw</span> <a class="code" href="a00177.html">SQLDatabaseException</a> (lException.what());</div>
<div class="line"><a name="l00093"></a><span class="lineno"> 93</span>  }</div>
<div class="line"><a name="l00094"></a><span class="lineno"> 94</span> </div>
<div class="line"><a name="l00095"></a><span class="lineno"> 95</span>  <span class="keywordflow">return</span> hasStillData;</div>
<div class="line"><a name="l00096"></a><span class="lineno"> 96</span>  }</div>
<div class="line"><a name="l00097"></a><span class="lineno"> 97</span> </div>
<div class="line"><a name="l00098"></a><span class="lineno"> 98</span>  <span class="comment">// //////////////////////////////////////////////////////////////////////</span></div>
<div class="line"><a name="l00099"></a><span class="lineno"><a class="code" href="a00075.html#a3f1509f70fc5dd81f0586810ef97dc9b"> 99</a></span>  <span class="keywordtype">void</span> <a class="code" href="a00075.html#a3f1509f70fc5dd81f0586810ef97dc9b">DBManagerForAirlines::updateAirlineInDB</a> (<a class="code" href="a00535.html#af9885c4dbd3b05a275c49b96aadd7165">DBSession_T</a>& ioSociSession,</div>
<div class="line"><a name="l00100"></a><span class="lineno"> 100</span>  <span class="keyword">const</span> <a class="code" href="a00030.html">AirlineStruct</a>& iAirline) {</div>
<div class="line"><a name="l00101"></a><span class="lineno"> 101</span>  <span class="keywordflow">try</span> {</div>
<div class="line"><a name="l00102"></a><span class="lineno"> 102</span>  <span class="comment">// Begin a transaction on the database</span></div>
<div class="line"><a name="l00103"></a><span class="lineno"> 103</span>  ioSociSession.begin();</div>
<div class="line"><a name="l00104"></a><span class="lineno"> 104</span> </div>
<div class="line"><a name="l00105"></a><span class="lineno"> 105</span>  <span class="comment">// Retrieve the airline code</span></div>
<div class="line"><a name="l00106"></a><span class="lineno"> 106</span>  <span class="keyword">const</span> std::string& lAirlineCode = iAirline.<a class="code" href="a00030.html#a51979824d380648aff488097ea12e29c">getAirlineCode</a>();</div>
<div class="line"><a name="l00107"></a><span class="lineno"> 107</span>  </div>
<div class="line"><a name="l00108"></a><span class="lineno"> 108</span>  <span class="comment">// Retrieve the airline name</span></div>
<div class="line"><a name="l00109"></a><span class="lineno"> 109</span>  <span class="keyword">const</span> std::string& lAirlineName = iAirline.<a class="code" href="a00030.html#a5f13968fb97e237b5a95e5b3ce347ac6">getAirlineName</a>();</div>
<div class="line"><a name="l00110"></a><span class="lineno"> 110</span>  </div>
<div class="line"><a name="l00111"></a><span class="lineno"> 111</span>  <span class="comment">// Instanciate a SQL statement (no request is performed at that stage)</span></div>
<div class="line"><a name="l00112"></a><span class="lineno"> 112</span>  <a class="code" href="a00535.html#a29d5eb8225d8560ae8ee69a8a2a01cb6">DBRequestStatement_T</a> lUpdateStatement =</div>
<div class="line"><a name="l00113"></a><span class="lineno"> 113</span>  (ioSociSession.prepare</div>
<div class="line"><a name="l00114"></a><span class="lineno"> 114</span>  << <span class="stringliteral">"update airlines "</span></div>
<div class="line"><a name="l00115"></a><span class="lineno"> 115</span>  << <span class="stringliteral">"set name = :name "</span></div>
<div class="line"><a name="l00116"></a><span class="lineno"> 116</span>  << <span class="stringliteral">"where iata_code = :iata_code"</span>,</div>
<div class="line"><a name="l00117"></a><span class="lineno"> 117</span>  soci::use (lAirlineName), soci::use (lAirlineCode));</div>
<div class="line"><a name="l00118"></a><span class="lineno"> 118</span>  </div>
<div class="line"><a name="l00119"></a><span class="lineno"> 119</span>  <span class="comment">// Execute the SQL query</span></div>
<div class="line"><a name="l00120"></a><span class="lineno"> 120</span>  lUpdateStatement.execute (<span class="keyword">true</span>);</div>
<div class="line"><a name="l00121"></a><span class="lineno"> 121</span>  </div>
<div class="line"><a name="l00122"></a><span class="lineno"> 122</span>  <span class="comment">// Commit the transaction on the database</span></div>
<div class="line"><a name="l00123"></a><span class="lineno"> 123</span>  ioSociSession.commit();</div>
<div class="line"><a name="l00124"></a><span class="lineno"> 124</span>  </div>
<div class="line"><a name="l00125"></a><span class="lineno"> 125</span>  <span class="comment">// Debug</span></div>
<div class="line"><a name="l00126"></a><span class="lineno"> 126</span>  <span class="comment">// STDAIR_LOG_DEBUG ("[" << lAirlineCode << "] " << iAirline);</span></div>
<div class="line"><a name="l00127"></a><span class="lineno"> 127</span>  </div>
<div class="line"><a name="l00128"></a><span class="lineno"> 128</span>  } <span class="keywordflow">catch</span> (std::exception <span class="keyword">const</span>& lException) {</div>
<div class="line"><a name="l00129"></a><span class="lineno"> 129</span>  <span class="keywordflow">throw</span> <a class="code" href="a00177.html">SQLDatabaseException</a> (lException.what());</div>
<div class="line"><a name="l00130"></a><span class="lineno"> 130</span>  }</div>
<div class="line"><a name="l00131"></a><span class="lineno"> 131</span>  }</div>
<div class="line"><a name="l00132"></a><span class="lineno"> 132</span> </div>
<div class="line"><a name="l00133"></a><span class="lineno"> 133</span>  <span class="comment">// //////////////////////////////////////////////////////////////////////</span></div>
<div class="line"><a name="l00134"></a><span class="lineno"><a class="code" href="a00075.html#ad6eaaa2d89386b172a25abb267d770ca"> 134</a></span>  <span class="keywordtype">bool</span> <a class="code" href="a00075.html#ad6eaaa2d89386b172a25abb267d770ca">DBManagerForAirlines::retrieveAirline</a> (<a class="code" href="a00535.html#af9885c4dbd3b05a275c49b96aadd7165">DBSession_T</a>& ioSociSession,</div>
<div class="line"><a name="l00135"></a><span class="lineno"> 135</span>  <span class="keyword">const</span> <a class="code" href="a00535.html#ac0ab9f765621de3140cc27d6472f5581">AirlineCode_T</a>& iAirlineCode,</div>
<div class="line"><a name="l00136"></a><span class="lineno"> 136</span>  <a class="code" href="a00030.html">AirlineStruct</a>& ioAirline) {</div>
<div class="line"><a name="l00137"></a><span class="lineno"> 137</span>  <span class="keywordtype">bool</span> oHasRetrievedAirline = <span class="keyword">false</span>;</div>
<div class="line"><a name="l00138"></a><span class="lineno"> 138</span>  </div>
<div class="line"><a name="l00139"></a><span class="lineno"> 139</span>  <span class="keywordflow">try</span> {</div>
<div class="line"><a name="l00140"></a><span class="lineno"> 140</span>  <span class="comment">// Prepare the SQL request corresponding to the select statement</span></div>
<div class="line"><a name="l00141"></a><span class="lineno"> 141</span>  <a class="code" href="a00535.html#a29d5eb8225d8560ae8ee69a8a2a01cb6">DBRequestStatement_T</a> lSelectStatement (ioSociSession);</div>
<div class="line"><a name="l00142"></a><span class="lineno"> 142</span>  prepareSelectOnAirlineCodeStatement (ioSociSession, lSelectStatement,</div>
<div class="line"><a name="l00143"></a><span class="lineno"> 143</span>  iAirlineCode, ioAirline);</div>
<div class="line"><a name="l00144"></a><span class="lineno"> 144</span>  </div>
<div class="line"><a name="l00145"></a><span class="lineno"> 145</span>  <span class="comment">// const bool shouldDoReset = true;</span></div>
<div class="line"><a name="l00146"></a><span class="lineno"> 146</span>  <span class="keywordtype">bool</span> hasStillData = <a class="code" href="a00075.html#aac370aa0b9bcdae2fbea716e83bf463b">iterateOnStatement</a> (lSelectStatement, ioAirline);</div>
<div class="line"><a name="l00147"></a><span class="lineno"> 147</span>  <span class="keywordflow">if</span> (hasStillData == <span class="keyword">true</span>) {</div>
<div class="line"><a name="l00148"></a><span class="lineno"> 148</span>  oHasRetrievedAirline = <span class="keyword">true</span>;</div>
<div class="line"><a name="l00149"></a><span class="lineno"> 149</span>  }</div>
<div class="line"><a name="l00150"></a><span class="lineno"> 150</span> </div>
<div class="line"><a name="l00151"></a><span class="lineno"> 151</span>  <span class="comment">// Sanity check</span></div>
<div class="line"><a name="l00152"></a><span class="lineno"> 152</span>  <span class="comment">// const bool shouldNotDoReset = false;</span></div>
<div class="line"><a name="l00153"></a><span class="lineno"> 153</span>  hasStillData = <a class="code" href="a00075.html#aac370aa0b9bcdae2fbea716e83bf463b">iterateOnStatement</a> (lSelectStatement, ioAirline);</div>
<div class="line"><a name="l00154"></a><span class="lineno"> 154</span>  </div>
<div class="line"><a name="l00155"></a><span class="lineno"> 155</span>  <span class="comment">// Debug</span></div>
<div class="line"><a name="l00156"></a><span class="lineno"> 156</span>  <span class="comment">// STDAIR_LOG_DEBUG ("[" << iDocID << "] " << ioAirline);</span></div>
<div class="line"><a name="l00157"></a><span class="lineno"> 157</span>  </div>
<div class="line"><a name="l00158"></a><span class="lineno"> 158</span>  } <span class="keywordflow">catch</span> (std::exception <span class="keyword">const</span>& lException) {</div>
<div class="line"><a name="l00159"></a><span class="lineno"> 159</span>  <span class="keywordflow">throw</span> <a class="code" href="a00177.html">SQLDatabaseException</a> (lException.what());</div>
<div class="line"><a name="l00160"></a><span class="lineno"> 160</span>  }</div>
<div class="line"><a name="l00161"></a><span class="lineno"> 161</span> </div>
<div class="line"><a name="l00162"></a><span class="lineno"> 162</span>  <span class="keywordflow">return</span> oHasRetrievedAirline;</div>
<div class="line"><a name="l00163"></a><span class="lineno"> 163</span>  }</div>
<div class="line"><a name="l00164"></a><span class="lineno"> 164</span> </div>
<div class="line"><a name="l00165"></a><span class="lineno"> 165</span> }</div>
</div><!-- fragment --></div><!-- contents -->
</div><!-- doc-content -->
<li class="footer">Generated on Wed May 22 2013 10:51:57 for StdAir by
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a>
1.8.3.1
</li>
<li class="footer">
<a href="http://sourceforge.net/projects/stdair"><img class="footer" src="http://sflogo.sourceforge.net/sflogo.php?group_id=267760&type=12&format=.png" alt="SourceForge Logo"></a>
</li>
</ul>
</div>
</body>
</html>
