<!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 http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.8"/>
<title>VSQLite++: sqlite::view Struct 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="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>
<link href="doxygen.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 style="padding-left: 0.5em;">
<div id="projectname">VSQLite++
 <span id="projectnumber">0.3</span>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.8 -->
<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="namespaces.html"><span>Namespaces</span></a></li>
<li class="current"><a href="annotated.html"><span>Classes</span></a></li>
<li><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="annotated.html"><span>Class List</span></a></li>
<li><a href="classes.html"><span>Class Index</span></a></li>
<li><a href="inherits.html"><span>Class Hierarchy</span></a></li>
<li><a href="functions.html"><span>Class Members</span></a></li>
</ul>
</div>
<!-- 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></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 id="nav-path" class="navpath">
<ul>
<li class="navelem"><a class="el" href="namespacesqlite.html">sqlite</a></li><li class="navelem"><a class="el" href="structsqlite_1_1view.html">view</a></li> </ul>
</div>
</div><!-- top -->
<div class="header">
<div class="summary">
<a href="#pub-methods">Public Member Functions</a> |
<a href="#pri-attribs">Private Attributes</a> |
<a href="structsqlite_1_1view-members.html">List of all members</a> </div>
<div class="headertitle">
<div class="title">sqlite::view Struct Reference</div> </div>
</div><!--header-->
<div class="contents">
<p>view is used to create views. In SQLite a view can only be queried. INSERT, DELETE and UPDATE will fail on a view
<a href="structsqlite_1_1view.html#details">More...</a></p>
<p><code>#include <<a class="el" href="view_8hpp_source.html">view.hpp</a>></code></p>
<div class="dynheader">
Collaboration diagram for sqlite::view:</div>
<div class="dyncontent">
<div class="center"><img src="structsqlite_1_1view__coll__graph.png" border="0" usemap="#sqlite_1_1view_coll__map" alt="Collaboration graph"/></div>
<map name="sqlite_1_1view_coll__map" id="sqlite_1_1view_coll__map">
<area shape="rect" id="node2" href="structsqlite_1_1connection.html" title="connection is used to open, close, attach and detach a database. Further it has to be passed to all c..." alt="" coords="5,132,208,297"/></map>
</div>
<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:a8b242a5fd2405d1966fe9cd94f28f699"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1view.html#a8b242a5fd2405d1966fe9cd94f28f699">view</a> (<a class="el" href="structsqlite_1_1connection.html">connection</a> &con)</td></tr>
<tr class="memdesc:a8b242a5fd2405d1966fe9cd94f28f699"><td class="mdescLeft"> </td><td class="mdescRight">constructor <a href="#a8b242a5fd2405d1966fe9cd94f28f699">More...</a><br /></td></tr>
<tr class="separator:a8b242a5fd2405d1966fe9cd94f28f699"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:a5f50d2cd80106d35b0aee4d4eb62e3ed"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1view.html#a5f50d2cd80106d35b0aee4d4eb62e3ed">~view</a> ()</td></tr>
<tr class="memdesc:a5f50d2cd80106d35b0aee4d4eb62e3ed"><td class="mdescLeft"> </td><td class="mdescRight">destructor <a href="#a5f50d2cd80106d35b0aee4d4eb62e3ed">More...</a><br /></td></tr>
<tr class="separator:a5f50d2cd80106d35b0aee4d4eb62e3ed"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:ad67eebad6ace7b070002a639c1d7416f"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1view.html#ad67eebad6ace7b070002a639c1d7416f">create</a> (bool temporary, std::string const &alias, std::string const &sql_query)</td></tr>
<tr class="memdesc:ad67eebad6ace7b070002a639c1d7416f"><td class="mdescLeft"> </td><td class="mdescRight">creates a view <a href="#ad67eebad6ace7b070002a639c1d7416f">More...</a><br /></td></tr>
<tr class="separator:ad67eebad6ace7b070002a639c1d7416f"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:a1b9f12d8112ea979bc1a4397724c65e9"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1view.html#a1b9f12d8112ea979bc1a4397724c65e9">create</a> (bool temporary, std::string const &database, std::string const &alias, std::string const &sql_query)</td></tr>
<tr class="memdesc:a1b9f12d8112ea979bc1a4397724c65e9"><td class="mdescLeft"> </td><td class="mdescRight">creates a view <a href="#a1b9f12d8112ea979bc1a4397724c65e9">More...</a><br /></td></tr>
<tr class="separator:a1b9f12d8112ea979bc1a4397724c65e9"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:a1c04a78431a1b5a73f99653a1001c955"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1view.html#a1c04a78431a1b5a73f99653a1001c955">drop</a> (std::string const &alias)</td></tr>
<tr class="memdesc:a1c04a78431a1b5a73f99653a1001c955"><td class="mdescLeft"> </td><td class="mdescRight">drops a view <a href="#a1c04a78431a1b5a73f99653a1001c955">More...</a><br /></td></tr>
<tr class="separator:a1c04a78431a1b5a73f99653a1001c955"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:a57c0edce911ba52a43f8e91f87828624"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1view.html#a57c0edce911ba52a43f8e91f87828624">drop</a> (std::string const &database, std::string const &alias)</td></tr>
<tr class="memdesc:a57c0edce911ba52a43f8e91f87828624"><td class="mdescLeft"> </td><td class="mdescRight">drops a view <a href="#a57c0edce911ba52a43f8e91f87828624">More...</a><br /></td></tr>
<tr class="separator:a57c0edce911ba52a43f8e91f87828624"><td class="memSeparator" colspan="2"> </td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pri-attribs"></a>
Private Attributes</h2></td></tr>
<tr class="memitem:af661e2f55e0855b9a8891f59766e487b"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structsqlite_1_1connection.html">connection</a> & </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1view.html#af661e2f55e0855b9a8891f59766e487b">m_con</a></td></tr>
<tr class="separator:af661e2f55e0855b9a8891f59766e487b"><td class="memSeparator" colspan="2"> </td></tr>
</table>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<div class="textblock"><p>view is used to create views. In SQLite a view can only be queried. INSERT, DELETE and UPDATE will fail on a view </p>
<p>Definition at line <a class="el" href="view_8hpp_source.html#l00039">39</a> of file <a class="el" href="view_8hpp_source.html">view.hpp</a>.</p>
</div><h2 class="groupheader">Constructor & Destructor Documentation</h2>
<a class="anchor" id="a8b242a5fd2405d1966fe9cd94f28f699"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">sqlite::view::view </td>
<td>(</td>
<td class="paramtype"><a class="el" href="structsqlite_1_1connection.html">connection</a> & </td>
<td class="paramname"><em>con</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
<p>constructor </p>
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">con</td><td>a reference to the connection object which should be used </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a class="anchor" id="a5f50d2cd80106d35b0aee4d4eb62e3ed"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">sqlite::view::~view </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
<p>destructor </p>
</div>
</div>
<h2 class="groupheader">Member Function Documentation</h2>
<a class="anchor" id="ad67eebad6ace7b070002a639c1d7416f"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void sqlite::view::create </td>
<td>(</td>
<td class="paramtype">bool </td>
<td class="paramname"><em>temporary</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">std::string const & </td>
<td class="paramname"><em>alias</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">std::string const & </td>
<td class="paramname"><em>sql_query</em> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<p>creates a view </p>
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">temporary</td><td>if this parameter is true the view will be present until drop will be called or the database was closed </td></tr>
<tr><td class="paramname">alias</td><td>the name of this view which should be used </td></tr>
<tr><td class="paramname">sql_query</td><td>the SQL statement which represents the view </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a class="anchor" id="a1b9f12d8112ea979bc1a4397724c65e9"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void sqlite::view::create </td>
<td>(</td>
<td class="paramtype">bool </td>
<td class="paramname"><em>temporary</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">std::string const & </td>
<td class="paramname"><em>database</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">std::string const & </td>
<td class="paramname"><em>alias</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">std::string const & </td>
<td class="paramname"><em>sql_query</em> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<p>creates a view </p>
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">temporary</td><td>if this parameter is true the view will be present until drop will be called or the database was closed </td></tr>
<tr><td class="paramname">database</td><td>name of the database where the view should be created in </td></tr>
<tr><td class="paramname">alias</td><td>the name of this view which should be used </td></tr>
<tr><td class="paramname">sql_query</td><td>the SQL statement which represents the view </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a class="anchor" id="a1c04a78431a1b5a73f99653a1001c955"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void sqlite::view::drop </td>
<td>(</td>
<td class="paramtype">std::string const & </td>
<td class="paramname"><em>alias</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
<p>drops a view </p>
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">alias</td><td>name of the view which should be dropped </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a class="anchor" id="a57c0edce911ba52a43f8e91f87828624"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void sqlite::view::drop </td>
<td>(</td>
<td class="paramtype">std::string const & </td>
<td class="paramname"><em>database</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">std::string const & </td>
<td class="paramname"><em>alias</em> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<p>drops a view </p>
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">database</td><td>name of the database where the view was created in </td></tr>
<tr><td class="paramname">alias</td><td>name of the view which should be dropped </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<h2 class="groupheader">Member Data Documentation</h2>
<a class="anchor" id="af661e2f55e0855b9a8891f59766e487b"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
<tr>
<td class="mlabels-left">
<table class="memname">
<tr>
<td class="memname"><a class="el" href="structsqlite_1_1connection.html">connection</a>& sqlite::view::m_con</td>
</tr>
</table>
</td>
<td class="mlabels-right">
<span class="mlabels"><span class="mlabel">private</span></span> </td>
</tr>
</table>
</div><div class="memdoc">
<p>Definition at line <a class="el" href="view_8hpp_source.html#l00086">86</a> of file <a class="el" href="view_8hpp_source.html">view.hpp</a>.</p>
</div>
</div>
<hr/>The documentation for this struct was generated from the following file:<ul>
<li>include/sqlite/<a class="el" href="view_8hpp_source.html">view.hpp</a></li>
</ul>
</div><!-- contents -->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated on Fri Oct 31 2014 11:19:54 for VSQLite++ by  <a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.8
</small></address>
</body>
</html>
distrib
>
Mageia
>
5
>
x86_64
>
media
>
core-release
>
by-pkgid
>
37580327e17dbd29f07260d361df35e7
>
files
>
409
