|
|
- <!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"/>
- <title>WORM: src/sql/drivers/wsqlitedriver.h Source File</title>
- <link href="tabs.css" rel="stylesheet" type="text/css"/>
- <link href="search/search.css" rel="stylesheet" type="text/css"/>
- <script type="text/javascript" src="search/search.js"></script>
- <link href="doxygen.css" rel="stylesheet" type="text/css"/>
- </head>
- <body onload='searchBox.OnSelectItem(0);'>
- <!-- Generated by Doxygen 1.7.3 -->
- <script type="text/javascript"><!--
- var searchBox = new SearchBox("searchBox", "search",false,'Search');
- --></script>
- <script type="text/javascript">
- function hasClass(ele,cls) {
- return ele.className.match(new RegExp('(\\s|^)'+cls+'(\\s|$)'));
- }
-
- function addClass(ele,cls) {
- if (!this.hasClass(ele,cls)) ele.className += " "+cls;
- }
-
- function removeClass(ele,cls) {
- if (hasClass(ele,cls)) {
- var reg = new RegExp('(\\s|^)'+cls+'(\\s|$)');
- ele.className=ele.className.replace(reg,' ');
- }
- }
-
- function toggleVisibility(linkObj) {
- var base = linkObj.getAttribute('id');
- var summary = document.getElementById(base + '-summary');
- var content = document.getElementById(base + '-content');
- var trigger = document.getElementById(base + '-trigger');
- if ( hasClass(linkObj,'closed') ) {
- summary.style.display = 'none';
- content.style.display = 'block';
- trigger.src = 'open.png';
- removeClass(linkObj,'closed');
- addClass(linkObj,'opened');
- } else if ( hasClass(linkObj,'opened') ) {
- summary.style.display = 'block';
- content.style.display = 'none';
- trigger.src = 'closed.png';
- removeClass(linkObj,'opened');
- addClass(linkObj,'closed');
- }
- return false;
- }
- </script>
- <div id="top">
- <div id="titlearea">
- <table cellspacing="0" cellpadding="0">
- <tbody>
- <tr style="height: 56px;">
- <td id="projectlogo"><img alt="Logo" src="worm_sm.png"></td>
- <td style="padding-left: 0.5em;">
- <div id="projectname">WORM <span id="projectnumber">0.2</span></div>
- <div id="projectbrief">A C++ DAL/ORM code generation framework</div>
- </td>
- </tr>
- </tbody>
- </table>
- </div>
- <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 id="searchli">
- <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 class="header">
- <div class="headertitle">
- <h1>src/sql/drivers/wsqlitedriver.h</h1> </div>
- </div>
- <div class="contents">
- <a href="wsqlitedriver_8h.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="comment">/*</span>
- <a name="l00002"></a>00002 <span class="comment"> WORM - a DAL/ORM code generation framework</span>
- <a name="l00003"></a>00003 <span class="comment"> Copyright (C) 2011 Erik Winn <erikwinnmail@yahoo.com></span>
- <a name="l00004"></a>00004 <span class="comment"></span>
- <a name="l00005"></a>00005 <span class="comment"> This program is free software: you can redistribute it and/or modify</span>
- <a name="l00006"></a>00006 <span class="comment"> it under the terms of the GNU General Public License as published by</span>
- <a name="l00007"></a>00007 <span class="comment"> the Free Software Foundation, either version 3 of the License, or</span>
- <a name="l00008"></a>00008 <span class="comment"> (at your option) any later version.</span>
- <a name="l00009"></a>00009 <span class="comment"></span>
- <a name="l00010"></a>00010 <span class="comment"> This program is distributed in the hope that it will be useful,</span>
- <a name="l00011"></a>00011 <span class="comment"> but WITHOUT ANY WARRANTY; without even the implied warranty of</span>
- <a name="l00012"></a>00012 <span class="comment"> MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the</span>
- <a name="l00013"></a>00013 <span class="comment"> GNU General Public License for more details.</span>
- <a name="l00014"></a>00014 <span class="comment"></span>
- <a name="l00015"></a>00015 <span class="comment"> You should have received a copy of the GNU General Public License</span>
- <a name="l00016"></a>00016 <span class="comment"> along with this program. If not, see <http://www.gnu.org/licenses/>.</span>
- <a name="l00017"></a>00017 <span class="comment"> */</span>
- <a name="l00018"></a>00018
- <a name="l00019"></a>00019
- <a name="l00020"></a>00020 <span class="preprocessor">#ifndef WSQLITEDRIVER_H</span>
- <a name="l00021"></a>00021 <span class="preprocessor"></span><span class="preprocessor">#define WSQLITEDRIVER_H</span>
- <a name="l00022"></a>00022 <span class="preprocessor"></span>
- <a name="l00023"></a>00023 <span class="preprocessor">#include "wsqldriver.h"</span>
- <a name="l00024"></a>00024 <span class="preprocessor">#include <map></span>
- <a name="l00025"></a>00025
- <a name="l00026"></a>00026 <span class="preprocessor">#include <sqlite3.h></span>
- <a name="l00027"></a>00027
- <a name="l00028"></a>00028 <span class="keyword">namespace </span>WSql
- <a name="l00029"></a>00029 {
- <a name="l00030"></a>00030
- <a name="l00031"></a>00031 <span class="keyword">class </span>WSqlDatabase;
- <a name="l00032"></a>00032
- <a name="l00033"></a><a class="code" href="class_w_sql_1_1_w_sqlite_driver.html">00033</a> <span class="keyword">class </span><a class="code" href="class_w_sql_1_1_w_sqlite_driver.html">WSqliteDriver</a> : <span class="keyword">public</span> <a class="code" href="class_w_sql_1_1_w_sql_driver.html" title="The WSqlDriver class is an abstract base class for database drivers.">WSqlDriver</a>
- <a name="l00034"></a>00034 {
- <a name="l00035"></a>00035 <span class="keyword">public</span>:
- <a name="l00036"></a>00036 <span class="comment">// WSqliteDriver();</span>
- <a name="l00037"></a>00037 <a class="code" href="class_w_sql_1_1_w_sqlite_driver.html#a9c3c650f052fe64490b0c0607c75a379">WSqliteDriver</a>( <a class="code" href="class_w_sql_1_1_w_sql_database.html" title="The WSqlDatabase class represents a single database.">WSqlDatabase</a>* db );
- <a name="l00038"></a>00038 <a class="code" href="class_w_sql_1_1_w_sqlite_driver.html#aedc78f4e6972c7df4388f8e960424d53">~WSqliteDriver</a>();
- <a name="l00039"></a>00039 <span class="keywordtype">bool</span> <a class="code" href="class_w_sql_1_1_w_sqlite_driver.html#a401f5a03ca5d1e288ade6598c5379a20">open</a>();
- <a name="l00040"></a>00040 <span class="keywordtype">void</span> <a class="code" href="class_w_sql_1_1_w_sqlite_driver.html#ac80543216d537dab91b382488042c416">close</a>();
- <a name="l00041"></a>00041 <span class="keywordtype">bool</span> <a class="code" href="class_w_sql_1_1_w_sqlite_driver.html#a4ba7ea260dd263e74d9c16c58e655434" title="Send the query sql to the database.">query</a>( std::string sql );
- <a name="l00042"></a>00042 <a class="code" href="class_w_sql_1_1_w_sql_result.html" title="The WSqlResult class provides a representation of the result set from a query.">WSqlResult</a>* <a class="code" href="class_w_sql_1_1_w_sqlite_driver.html#a1cf0f135668cdd8299995c1ffff72724">result</a>(<span class="keywordtype">bool</span> iscached=<span class="keyword">true</span>);
- <a name="l00043"></a>00043
- <a name="l00044"></a>00044 std::vector<std::string> <a class="code" href="class_w_sql_1_1_w_sqlite_driver.html#aa7796f2d18f519f24016a9fa1f9e2f0b">tableNames</a>();
- <a name="l00045"></a>00045 <a class="code" href="class_w_sql_1_1_w_sql_table.html" title="WSqlTable is an abstraction for a single table, collection or view in a database.">WSqlTable</a> <a class="code" href="class_w_sql_1_1_w_sqlite_driver.html#aa74cc6840682c0ae5fe9bb2e4aa76a4d">tableMetaData</a>( <span class="keyword">const</span> std::string &tableName );
- <a name="l00046"></a>00046
- <a name="l00047"></a>00047 <span class="keyword">private</span>:
- <a name="l00048"></a>00048 <span class="keywordtype">bool</span> _isUtf8;
- <a name="l00049"></a>00049 sqlite3 *_objSqlite;
- <a name="l00050"></a>00050
- <a name="l00051"></a>00051 <span class="keywordtype">bool</span> init();
- <a name="l00052"></a>00052
- <a name="l00053"></a>00053 <a class="code" href="namespace_w_sql_1_1_w_sql_data_type.html#aa234580d74e3dfc10946a4ec8e317d11">WSqlDataType::Type</a> sqlite3TypeToWSqlType( std::string tname) <span class="keyword">const</span>;
- <a name="l00054"></a>00054 <a class="code" href="namespace_w_sql_1_1_w_sql_data_type.html#aa234580d74e3dfc10946a4ec8e317d11">WSqlDataType::Type</a> sqlite3TypeToWSqlType(<span class="keywordtype">int</span> dtype)<span class="keyword">const</span>;
- <a name="l00055"></a>00055 std::string fetchTableCreateStatement(<span class="keyword">const</span> std::string& tablename)<span class="keyword">const</span>;
- <a name="l00056"></a>00056 std::string extractStatement(<span class="keyword">const</span> std::string& sql, <span class="keyword">const</span> <span class="keywordtype">char</span> start=<span class="charliteral">'('</span>, <span class="keyword">const</span> <span class="keywordtype">char</span> end=<span class="charliteral">')'</span>) <span class="keyword">const</span>;
- <a name="l00057"></a>00057 <span class="keywordtype">void</span> parseSchema( std::string& sql);
- <a name="l00058"></a>00058 <span class="keywordtype">bool</span> columnIsAutoIncrement(<span class="keyword">const</span> std::string& columnname)<span class="keyword">const</span>;
- <a name="l00059"></a>00059 <span class="keywordtype">void</span> mapColumns(std::vector<std::string> &column_definitions);
- <a name="l00060"></a>00060 <span class="comment">//temporary buffers; cleared after each metatable init ..</span>
- <a name="l00061"></a>00061 std::map<std::string, std::string> _columns_map;
- <a name="l00062"></a>00062 std::vector<WSqlForeignKey> _foreign_keys;
- <a name="l00063"></a>00063 };
- <a name="l00064"></a>00064
- <a name="l00065"></a>00065 }<span class="comment">//namespace WSql</span>
- <a name="l00066"></a>00066
- <a name="l00067"></a>00067 <span class="preprocessor">#endif // WSQLITEDRIVER_H</span>
- </pre></div></div>
- </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>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Friends</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(9)"><span class="SelectionMark"> </span>Defines</a></div>
-
- <!-- iframe showing the search results (closed by default) -->
- <div id="MSearchResultsWindow">
- <iframe src="" frameborder="0"
- name="MSearchResults" id="MSearchResults">
- </iframe>
- </div>
-
- <hr class="footer"/><address class="footer"><small>Generated on Fri Nov 18 2011 21:01:45 for WORM by 
- <a href="http://www.doxygen.org/index.html">
- <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.3 </small></address>
- </body>
- </html>
|
