--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/Symbian3/Examples/guid-6013a680-57f9-415b-8851-c4fa63356636/sqlexample_8cpp-source.html Fri Jan 22 18:26:19 2010 +0000
@@ -0,0 +1,540 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
+<title>TB10.1 Example Applications: examples/SysLibs/SqlExample/sqlexample.cpp Source File</title>
+<link href="doxygen.css" rel="stylesheet" type="text/css">
+<link href="tabs.css" rel="stylesheet" type="text/css">
+</head><body>
+<!-- Generated by Doxygen 1.5.3 -->
+<h1>examples/SysLibs/SqlExample/sqlexample.cpp</h1><a href="sqlexample_8cpp.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="comment">// Copyright (c) 2006-2009 Nokia Corporation and/or its subsidiary(-ies).</span>
+<a name="l00002"></a>00002 <span class="comment">// All rights reserved.</span>
+<a name="l00003"></a>00003 <span class="comment">// This component and the accompanying materials are made available</span>
+<a name="l00004"></a>00004 <span class="comment">// under the terms of "Eclipse Public License v1.0"</span>
+<a name="l00005"></a>00005 <span class="comment">// which accompanies this distribution, and is available</span>
+<a name="l00006"></a>00006 <span class="comment">// at the URL "http://www.eclipse.org/legal/epl-v10.html".</span>
+<a name="l00007"></a>00007 <span class="comment">//</span>
+<a name="l00008"></a>00008 <span class="comment">// Initial Contributors:</span>
+<a name="l00009"></a>00009 <span class="comment">// Nokia Corporation - initial contribution.</span>
+<a name="l00010"></a>00010 <span class="comment">//</span>
+<a name="l00011"></a>00011 <span class="comment">// Contributors:</span>
+<a name="l00012"></a>00012 <span class="comment">//</span>
+<a name="l00013"></a>00013 <span class="comment">// Description:</span>
+<a name="l00014"></a>00014 <span class="comment">// This example program demonstrates the use of SQL APIs. </span>
+<a name="l00015"></a>00015 <span class="comment">// The code demonstrates how to create non secure and secure databases on </span>
+<a name="l00016"></a>00016 <span class="comment">// the writable drive and perform basic operations on the databases.</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
+<a name="l00024"></a>00024 <span class="preprocessor">#include "<a class="code" href="sqlexample_8h.html">sqlexample.h</a>"</span>
+<a name="l00025"></a>00025 <span class="preprocessor">#include <e32cons.h></span>
+<a name="l00026"></a>00026 <span class="preprocessor">#include <sqldb.h></span>
+<a name="l00027"></a>00027
+<a name="l00028"></a>00028 _LIT(KTitle, <span class="stringliteral">"SQL example"</span>);
+<a name="l00029"></a>00029 _LIT(KTextPressAKey, <span class="stringliteral">"\n\nPress any key to step through the example\n"</span>);
+<a name="l00030"></a>00030 _LIT(KExit,<span class="stringliteral">"Press any key to exit the application "</span>);
+<a name="l00031"></a>00031 _LIT(KPressAKey,<span class="stringliteral">"Press any key to continue \n"</span>);
+<a name="l00032"></a>00032 _LIT(KNonSecure,<span class="stringliteral">"\nCreating a non secure database \n"</span>);
+<a name="l00033"></a>00033 _LIT(KSecure,<span class="stringliteral">"\nCreating a secure database \n"</span>);
+<a name="l00034"></a>00034 _LIT(KOpen,<span class="stringliteral">"Opening the secure database \n"</span>);
+<a name="l00035"></a>00035 _LIT(KDelete,<span class="stringliteral">"Deleting the database(s)\n"</span>);
+<a name="l00036"></a>00036 _LIT(KClose,<span class="stringliteral">"Closing the database(s)\n"</span>);
+<a name="l00037"></a>00037 _LIT(KCopyNonSec,<span class="stringliteral">"\nCopying a non secure database to another non secure one \n"</span>);
+<a name="l00038"></a>00038 _LIT(KCopySecure,<span class="stringliteral">"\nCopying a secure database to another secure database \n"</span>);
+<a name="l00039"></a>00039 _LIT(KAttach,<span class="stringliteral">"\nOpen a secure database and attach another secure database\n"</span>);
+<a name="l00040"></a>00040 _LIT(KCreateTable,<span class="stringliteral">"\nCreating a table\n"</span>);
+<a name="l00041"></a>00041 _LIT(KInsert,<span class="stringliteral">"Inserting records into the table\n"</span>);
+<a name="l00042"></a>00042 _LIT(KPrepare,<span class="stringliteral">"Preparing a query\n"</span>);
+<a name="l00043"></a>00043 _LIT(KExecute,<span class="stringliteral">"Executing a query\n"</span>);
+<a name="l00044"></a>00044
+<a name="l00045"></a>00045 <span class="comment">// Names of the databases created, operated upon and later deleted.</span>
+<a name="l00046"></a>00046 _LIT(KDbName, <span class="stringliteral">"\\Example_db.db"</span>);
+<a name="l00047"></a>00047 _LIT(KAnotherDbName, <span class="stringliteral">"\\Example_Anotherdb.db"</span>);
+<a name="l00048"></a>00048 _LIT(KSecureDb1, <span class="stringliteral">"[E80000AF]db1.db"</span>);
+<a name="l00049"></a>00049 _LIT(KSecureDb2, <span class="stringliteral">"[E80000AF]db2.db"</span>);
+<a name="l00050"></a>00050 _LIT(KDatabase, <span class="stringliteral">"\\Sqlscalarfullselect.db"</span>);
+<a name="l00051"></a>00051
+<a name="l00052"></a>00052 <span class="comment">// Security policies used</span>
+<a name="l00053"></a>00053 <span class="keyword">const</span> TSecurityPolicy KPolicy1(ECapabilityReadUserData, ECapabilityNetworkControl, ECapabilityWriteUserData);
+<a name="l00054"></a>00054 <span class="keyword">const</span> TSecurityPolicy KPolicy2(ECapabilityReadUserData);
+<a name="l00055"></a>00055
+<a name="l00061"></a><a class="code" href="class_c_sql_example.html#8b115210a3fbfa19de5c7f6a0abf3e43">00061</a> <a class="code" href="class_c_sql_example.html">CSqlExample</a>* <a class="code" href="class_c_sql_example.html#8b115210a3fbfa19de5c7f6a0abf3e43">CSqlExample::NewLC</a>()
+<a name="l00062"></a>00062 {
+<a name="l00063"></a>00063 <a class="code" href="class_c_sql_example.html">CSqlExample</a>* rep = <span class="keyword">new</span>(ELeave) <a class="code" href="class_c_sql_example.html">CSqlExample</a>();
+<a name="l00064"></a>00064 CleanupStack::PushL(rep);
+<a name="l00065"></a>00065 rep-><a class="code" href="class_c_sql_example.html#b72dd945d05e8df150bdcecf74380169">ConstructL</a>();
+<a name="l00066"></a>00066 <span class="keywordflow">return</span> rep;
+<a name="l00067"></a>00067 }
+<a name="l00068"></a>00068
+<a name="l00072"></a>00072 CSqlExample::CSqlExample()
+<a name="l00073"></a>00073 {
+<a name="l00074"></a>00074 }
+<a name="l00075"></a>00075
+<a name="l00076"></a>00076 <span class="keywordtype">void</span> CSqlExample::ConstructL()
+<a name="l00077"></a>00077 {
+<a name="l00078"></a>00078 iConsole = Console::NewL(KTitle,TSize(KConsFullScreen,KConsFullScreen));
+<a name="l00079"></a>00079 iConsole->Printf ( KTextPressAKey );
+<a name="l00080"></a>00080 iConsole->Getch ();
+<a name="l00081"></a>00081 }
+<a name="l00082"></a>00082
+<a name="l00086"></a><a class="code" href="class_c_sql_example.html#81cffca804968549ed3523230f28408f">00086</a> <a class="code" href="class_c_sql_example.html#81cffca804968549ed3523230f28408f">CSqlExample::~CSqlExample</a>()
+<a name="l00087"></a>00087 {
+<a name="l00088"></a>00088 iConsole->Printf(KExit);
+<a name="l00089"></a>00089 iConsole->Getch();
+<a name="l00090"></a>00090
+<a name="l00091"></a>00091 <span class="keyword">delete</span> iConsole;
+<a name="l00092"></a>00092 }
+<a name="l00093"></a>00093
+<a name="l00100"></a><a class="code" href="class_c_sql_example.html#f0523fb9c7a711a2c7745e8d2e96faa7">00100</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#f0523fb9c7a711a2c7745e8d2e96faa7">CSqlExample::CreateNonSecureDBL</a>()
+<a name="l00101"></a>00101 {
+<a name="l00102"></a>00102 TBuf<200> buffer;
+<a name="l00103"></a>00103 RSqlDatabase db;
+<a name="l00104"></a>00104
+<a name="l00105"></a>00105 <span class="comment">// Create non-secure database</span>
+<a name="l00106"></a>00106 iConsole->Printf(KNonSecure);
+<a name="l00107"></a>00107 TInt <a class="code" href="_camera___app_ui_8cpp.html#711e7d3cb49b7e0de7880fed269134d3">error</a>;
+<a name="l00108"></a>00108 TRAP(error,db.Create(KDbName););
+<a name="l00109"></a>00109
+<a name="l00110"></a>00110 _LIT(KTable,<span class="stringliteral">"CREATE TABLE A1(F1 INTEGER, F2 INTEGER)"</span>);
+<a name="l00111"></a>00111 User::LeaveIfError(error = db.Exec(KTable));
+<a name="l00112"></a>00112
+<a name="l00113"></a>00113 db.Close();
+<a name="l00114"></a>00114 iConsole->Printf(KClose);
+<a name="l00115"></a>00115 iConsole->Printf(KPressAKey);
+<a name="l00116"></a>00116 iConsole->Getch();
+<a name="l00117"></a>00117 }
+<a name="l00118"></a>00118
+<a name="l00127"></a><a class="code" href="class_c_sql_example.html#2d2358e96bba71900cedd067fe44192b">00127</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#2d2358e96bba71900cedd067fe44192b">CSqlExample::CreateAndOpenSecureDBL</a>()
+<a name="l00128"></a>00128 {
+<a name="l00129"></a>00129 RSqlDatabase db;
+<a name="l00130"></a>00130 RSqlSecurityPolicy securityPolicy;
+<a name="l00131"></a>00131
+<a name="l00132"></a>00132 User::LeaveIfError(securityPolicy.Create(TSecurityPolicy(TSecurityPolicy::EAlwaysPass)));
+<a name="l00133"></a>00133 User::LeaveIfError(securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KPolicy1));
+<a name="l00134"></a>00134
+<a name="l00135"></a>00135 iConsole->Printf(KSecure);
+<a name="l00136"></a>00136 User::LeaveIfError(db.Create(KSecureDb1, securityPolicy));
+<a name="l00137"></a>00137
+<a name="l00138"></a>00138 securityPolicy.Close();
+<a name="l00139"></a>00139
+<a name="l00140"></a>00140 <span class="comment">// Check that the database security policy matches the policy used </span>
+<a name="l00141"></a>00141 <span class="comment">//when the database was created.</span>
+<a name="l00142"></a>00142 User::LeaveIfError(db.GetSecurityPolicy(securityPolicy));
+<a name="l00143"></a>00143
+<a name="l00144"></a>00144 _LIT(KSecureCreate,<span class="stringliteral">"CREATE TABLE secure(int_fld integer, null_int_fld integer default null)"</span>);
+<a name="l00145"></a>00145 User::LeaveIfError(db.Exec(KSecureCreate));
+<a name="l00146"></a>00146
+<a name="l00147"></a>00147 <span class="comment">// Attempt to write to the secure database</span>
+<a name="l00148"></a>00148 _LIT(KSecureInsert,<span class="stringliteral">"INSERT INTO secure(int_fld) values(200)"</span>);
+<a name="l00149"></a>00149 User::LeaveIfError(db.Exec(KSecureInsert));
+<a name="l00150"></a>00150 db.Close();
+<a name="l00151"></a>00151
+<a name="l00152"></a>00152 iConsole->Printf(KOpen);
+<a name="l00153"></a>00153 <span class="comment">// Open the secure database </span>
+<a name="l00154"></a>00154 User::LeaveIfError(db.Open(KSecureDb1));
+<a name="l00155"></a>00155
+<a name="l00156"></a>00156 db.Close();
+<a name="l00157"></a>00157 iConsole->Printf(KClose);
+<a name="l00158"></a>00158 iConsole->Printf(KPressAKey);
+<a name="l00159"></a>00159 iConsole->Getch();
+<a name="l00160"></a>00160 securityPolicy.Close();
+<a name="l00161"></a>00161
+<a name="l00162"></a>00162 }
+<a name="l00163"></a>00163
+<a name="l00171"></a><a class="code" href="class_c_sql_example.html#1a6247133748297a2a8877381583e51c">00171</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#1a6247133748297a2a8877381583e51c">CSqlExample::CopyDatabaseL</a>()
+<a name="l00172"></a>00172 {
+<a name="l00173"></a>00173 RSqlDatabase db;
+<a name="l00174"></a>00174
+<a name="l00175"></a>00175 <span class="comment">// Copy non-secure to non-secure database</span>
+<a name="l00176"></a>00176 iConsole->Printf(KCopyNonSec);
+<a name="l00177"></a>00177 User::LeaveIfError(RSqlDatabase::Copy(KDbName, KAnotherDbName));
+<a name="l00178"></a>00178
+<a name="l00179"></a>00179 <span class="comment">// Delete the source database</span>
+<a name="l00180"></a>00180 iConsole->Printf(KDelete);
+<a name="l00181"></a>00181 User::LeaveIfError(RSqlDatabase::Delete(KAnotherDbName));
+<a name="l00182"></a>00182
+<a name="l00183"></a>00183 <span class="comment">// Create another secure database with a different security policy,</span>
+<a name="l00184"></a>00184 <span class="comment">// KSecureDb1 is already created with KPolicy1.</span>
+<a name="l00185"></a>00185 RSqlSecurityPolicy securityPolicy;
+<a name="l00186"></a>00186 User::LeaveIfError(securityPolicy.Create(TSecurityPolicy(TSecurityPolicy::EAlwaysPass)));
+<a name="l00187"></a>00187
+<a name="l00188"></a>00188 User::LeaveIfError(securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KPolicy2));
+<a name="l00189"></a>00189
+<a name="l00190"></a>00190 User::LeaveIfError(db.Create(KSecureDb2, securityPolicy));
+<a name="l00191"></a>00191
+<a name="l00192"></a>00192 User::LeaveIfError(db.GetSecurityPolicy(securityPolicy));
+<a name="l00193"></a>00193 db.Close();
+<a name="l00194"></a>00194
+<a name="l00195"></a>00195 <span class="comment">// Copy secure to secure database. The application is the database owner.</span>
+<a name="l00196"></a>00196 iConsole->Printf(KCopySecure);
+<a name="l00197"></a>00197 User::LeaveIfError(RSqlDatabase::Copy(KSecureDb1, KSecureDb2));
+<a name="l00198"></a>00198
+<a name="l00199"></a>00199 <span class="comment">// Delete the source database</span>
+<a name="l00200"></a>00200 iConsole->Printf(KDelete);
+<a name="l00201"></a>00201 User::LeaveIfError(RSqlDatabase::Delete(KSecureDb1));
+<a name="l00202"></a>00202
+<a name="l00203"></a>00203 iConsole->Printf(KPressAKey);
+<a name="l00204"></a>00204 iConsole->Getch();
+<a name="l00205"></a>00205 securityPolicy.Close();
+<a name="l00206"></a>00206 db.Close();
+<a name="l00207"></a>00207
+<a name="l00208"></a>00208 }
+<a name="l00209"></a>00209
+<a name="l00217"></a><a class="code" href="class_c_sql_example.html#df02168d537e9e1650d5f379522a6b2e">00217</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#df02168d537e9e1650d5f379522a6b2e">CSqlExample::AttachDatabasesL</a>()
+<a name="l00218"></a>00218 {
+<a name="l00219"></a>00219 RSqlDatabase db;
+<a name="l00220"></a>00220 RSqlSecurityPolicy securityPolicy;
+<a name="l00221"></a>00221
+<a name="l00222"></a>00222 _LIT(KAttachDb2, <span class="stringliteral">"Db2"</span>);
+<a name="l00223"></a>00223
+<a name="l00224"></a>00224 User::LeaveIfError(db.Open(KSecureDb2));
+<a name="l00225"></a>00225 iConsole->Printf(KAttach);
+<a name="l00226"></a>00226
+<a name="l00227"></a>00227 User::LeaveIfError(db.Attach(KDbName, KAttachDb2));
+<a name="l00228"></a>00228
+<a name="l00229"></a>00229 <span class="comment">// Attempt to write to the attached non secure database</span>
+<a name="l00230"></a>00230 _LIT(KTabInsert,<span class="stringliteral">"INSERT INTO db2.a1(f1) valUES(10)"</span>);
+<a name="l00231"></a>00231 User::LeaveIfError(db.Exec(KTabInsert));
+<a name="l00232"></a>00232
+<a name="l00233"></a>00233 <span class="comment">// Attempt to read from the attached non secure database</span>
+<a name="l00234"></a>00234 _LIT(KSelect,<span class="stringliteral">"SELECT * FROM db2.a1"</span>);
+<a name="l00235"></a>00235 User::LeaveIfError(db.Exec(KSelect));
+<a name="l00236"></a>00236
+<a name="l00237"></a>00237 <span class="comment">// Attempt to write to the main secure database</span>
+<a name="l00238"></a>00238 _LIT(KAttachInsert,<span class="stringliteral">"INSERT INTO a1(f1) valUES(10)"</span>);
+<a name="l00239"></a>00239 User::LeaveIfError(db.Exec(KAttachInsert));
+<a name="l00240"></a>00240
+<a name="l00241"></a>00241 db.Close();
+<a name="l00242"></a>00242 iConsole->Printf(KDelete);
+<a name="l00243"></a>00243 User::LeaveIfError(RSqlDatabase::Delete(KDbName));
+<a name="l00244"></a>00244
+<a name="l00245"></a>00245 User::LeaveIfError(RSqlDatabase::Delete(KSecureDb2));
+<a name="l00246"></a>00246
+<a name="l00247"></a>00247 securityPolicy.Close();
+<a name="l00248"></a>00248
+<a name="l00249"></a>00249 }
+<a name="l00250"></a>00250
+<a name="l00257"></a><a class="code" href="class_c_sql_example.html#49067abc75f826bfd43be44c07460c7b">00257</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#49067abc75f826bfd43be44c07460c7b">CSqlExample:: DataTypesQueryL</a>()
+<a name="l00258"></a>00258 {
+<a name="l00259"></a>00259 RSqlDatabase db;
+<a name="l00260"></a>00260 iConsole->Printf(KSecure);
+<a name="l00261"></a>00261
+<a name="l00262"></a>00262 User::LeaveIfError(db.Create(KDbName));
+<a name="l00263"></a>00263
+<a name="l00264"></a>00264 <span class="comment">// Create a table with different numeric field types</span>
+<a name="l00265"></a>00265 iConsole->Printf(KCreateTable);
+<a name="l00266"></a>00266 iConsole->Printf(KExecute);
+<a name="l00267"></a>00267
+<a name="l00268"></a>00268 _LIT(KSql1, <span class="stringliteral">"CREATE TABLE Tbl(A INTEGER, B SMALLINT, C REAL, D DOUBLE PRECISION, E FLOAT, \</span>
+<a name="l00269"></a>00269 <span class="stringliteral"> F DECIMAL)"</span>);
+<a name="l00270"></a>00270 User::LeaveIfError(db.Exec(KSql1));
+<a name="l00271"></a>00271
+<a name="l00272"></a>00272 <span class="comment">// Insert one record in to the created table</span>
+<a name="l00273"></a>00273 iConsole->Printf(KInsert);
+<a name="l00274"></a>00274 iConsole->Printf(KExecute);
+<a name="l00275"></a>00275
+<a name="l00276"></a>00276 _LIT(KSql2, <span class="stringliteral">"INSERT INTO Tbl(A,B,C,D,E,F) VALUES(2000000000, 30000, 123.45, 0.912E+55,\</span>
+<a name="l00277"></a>00277 <span class="stringliteral"> 1.34E-14, 1234.5678)"</span>);
+<a name="l00278"></a>00278 User::LeaveIfError(db.Exec(KSql2));
+<a name="l00279"></a>00279
+<a name="l00280"></a>00280 <span class="comment">// Get the inserted record data</span>
+<a name="l00281"></a>00281 RSqlStatement stmt;
+<a name="l00282"></a>00282 iConsole->Printf(KPrepare);
+<a name="l00283"></a>00283
+<a name="l00284"></a>00284 _LIT(KPrepQuery,<span class="stringliteral">"SELECT * FROM Tbl"</span>);
+<a name="l00285"></a>00285 User::LeaveIfError(stmt.Prepare(db, KPrepQuery));
+<a name="l00286"></a>00286
+<a name="l00287"></a>00287 User::LeaveIfError(stmt.Next());
+<a name="l00288"></a>00288 stmt.Close();
+<a name="l00289"></a>00289
+<a name="l00290"></a>00290 <span class="comment">// The statement object has to be closed before db.Exec() call, </span>
+<a name="l00291"></a>00291 <span class="comment">// otherwise the reported error is "database table is locked"</span>
+<a name="l00292"></a>00292 <span class="comment">// Insert second record in to the created table but inverse the column types.</span>
+<a name="l00293"></a>00293 iConsole->Printf(KExecute);
+<a name="l00294"></a>00294 _LIT(KSql3, <span class="stringliteral">"INSERT INTO Tbl(A, B, C, D, E, F) VALUES(\</span>
+<a name="l00295"></a>00295 <span class="stringliteral"> -2.5,1.1,12,23,45,111)"</span>);
+<a name="l00296"></a>00296 User::LeaveIfError(db.Exec(KSql3));
+<a name="l00297"></a>00297
+<a name="l00298"></a>00298 <span class="comment">// Get the inserted record data</span>
+<a name="l00299"></a>00299 _LIT(KPrepQuery2,<span class="stringliteral">"SELECT * FROM Tbl"</span>);
+<a name="l00300"></a>00300 User::LeaveIfError(stmt.Prepare(db, KPrepQuery2));
+<a name="l00301"></a>00301
+<a name="l00302"></a>00302 User::LeaveIfError(stmt.Next());
+<a name="l00303"></a>00303
+<a name="l00304"></a>00304 stmt.Close();
+<a name="l00305"></a>00305
+<a name="l00306"></a>00306 <span class="comment">// Insert third record in to the created table</span>
+<a name="l00307"></a>00307 _LIT(KSql4, <span class="stringliteral">"INSERT INTO Tbl(A,B,C,D,E,F) VALUES(\</span>
+<a name="l00308"></a>00308 <span class="stringliteral"> 2,3,123.45,1.5,2.5,1.56)"</span>);
+<a name="l00309"></a>00309 User::LeaveIfError(db.Exec(KSql4));
+<a name="l00310"></a>00310
+<a name="l00311"></a>00311 stmt.Close();
+<a name="l00312"></a>00312 db.Close();
+<a name="l00313"></a>00313 User::LeaveIfError(RSqlDatabase::Delete(KDbName));
+<a name="l00314"></a>00314 }
+<a name="l00315"></a>00315
+<a name="l00316"></a>00316
+<a name="l00328"></a><a class="code" href="class_c_sql_example.html#7fac459ccd95278c1af4eb50e5453812">00328</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#7fac459ccd95278c1af4eb50e5453812">CSqlExample::ScalarFullSelectL</a>()
+<a name="l00329"></a>00329 {
+<a name="l00330"></a>00330 RSqlDatabase db;
+<a name="l00331"></a>00331 <span class="comment">//Create database.</span>
+<a name="l00332"></a>00332 User::LeaveIfError(db.Create(KDatabase));
+<a name="l00333"></a>00333
+<a name="l00334"></a>00334 _LIT(KTabCreateA,<span class="stringliteral">"CREATE TABLE A(F1 INTEGER, F2 INTEGER, F3 FLOAT, F4 TEXT, F5 BLOB)"</span>);
+<a name="l00335"></a>00335 User::LeaveIfError(db.Exec(KTabCreateA));
+<a name="l00336"></a>00336
+<a name="l00337"></a>00337 _LIT(KTabInsert1A,<span class="stringliteral">"INSERT INTO A(F1, F2, F3, F4, F5) VALUES(1, 10000000000, 2.54, 'NAME1234567890', NULL)"</span>);
+<a name="l00338"></a>00338 User::LeaveIfError(db.Exec(KTabInsert1A));
+<a name="l00339"></a>00339
+<a name="l00340"></a>00340 _LIT(KTabInsert2A,<span class="stringliteral">"INSERT INTO A(F1, F2, F3, F4) VALUES(2, 200, -1.11, 'ADDRESS')"</span>);
+<a name="l00341"></a>00341 User::LeaveIfError(db.Exec(KTabInsert2A));
+<a name="l00342"></a>00342
+<a name="l00343"></a>00343 RSqlStatement stmt;
+<a name="l00344"></a>00344 CleanupClosePushL(stmt);
+<a name="l00345"></a>00345
+<a name="l00346"></a>00346 _LIT(KUpdate,<span class="stringliteral">"UPDATE A SET F5=:P WHERE F1 = 2"</span>);
+<a name="l00347"></a>00347 User::LeaveIfError(stmt.Prepare(db,KUpdate));
+<a name="l00348"></a>00348
+<a name="l00349"></a>00349 <span class="comment">// Open the parameter stream</span>
+<a name="l00350"></a>00350 RSqlParamWriteStream strm;
+<a name="l00351"></a>00351 CleanupClosePushL(strm);
+<a name="l00352"></a>00352
+<a name="l00353"></a>00353 <span class="comment">// Prepare and set the parameter value (non-NULL value)</span>
+<a name="l00354"></a>00354 User::LeaveIfError(strm.BindBinary(stmt, 0));
+<a name="l00355"></a>00355
+<a name="l00356"></a>00356 <span class="keywordflow">for</span>(TInt i=0;i<100;++i)
+<a name="l00357"></a>00357 {
+<a name="l00358"></a>00358 strm << static_cast <TUint8> (i);
+<a name="l00359"></a>00359 }
+<a name="l00360"></a>00360 <span class="comment">// Write the buffered data into stream</span>
+<a name="l00361"></a>00361 strm.CommitL();
+<a name="l00362"></a>00362 <span class="comment">// Execute the prepared SQL statement </span>
+<a name="l00363"></a>00363 User::LeaveIfError(stmt.Exec());
+<a name="l00364"></a>00364
+<a name="l00365"></a>00365 CleanupStack::PopAndDestroy(&strm);
+<a name="l00366"></a>00366 CleanupStack::PopAndDestroy(&stmt);
+<a name="l00367"></a>00367
+<a name="l00368"></a>00368 TSqlScalarFullSelectQuery fullSelectQuery(db);
+<a name="l00369"></a>00369
+<a name="l00370"></a>00370 TBuf<100> sql;
+<a name="l00371"></a>00371
+<a name="l00372"></a>00372 <span class="comment">// Query with F2 column (64-bit integer column)</span>
+<a name="l00373"></a>00373 _LIT(KAnotherSql, <span class="stringliteral">"SELECT F2 FROM A WHERE F1 = 1"</span>);
+<a name="l00374"></a>00374 sql.Copy(KAnotherSql);
+<a name="l00375"></a>00375 <span class="comment">// Read F2 as integer.</span>
+<a name="l00376"></a>00376 TInt valInt = fullSelectQuery.SelectIntL(sql);
+<a name="l00377"></a>00377
+<a name="l00378"></a>00378 <span class="comment">// Read F2 as 64-bit integer. Expected value: 10000000000</span>
+<a name="l00379"></a>00379 TInt64 valInt64 = fullSelectQuery.SelectInt64L(sql);
+<a name="l00380"></a>00380
+<a name="l00381"></a>00381 <span class="comment">// Read F2 as real. Expected value: 10000000000.0</span>
+<a name="l00382"></a>00382 TReal valReal = fullSelectQuery.SelectRealL(sql);
+<a name="l00383"></a>00383
+<a name="l00384"></a>00384 <span class="comment">// Read F2 as text. Expected value: zero-length 16-bit descriptor.</span>
+<a name="l00385"></a>00385 TBuf<10> valText;
+<a name="l00386"></a>00386 TInt err = fullSelectQuery.SelectTextL(sql, valText);
+<a name="l00387"></a>00387
+<a name="l00388"></a>00388 <span class="comment">// Read F2 as binary. Expected value: zero-length 8-bit descriptor.</span>
+<a name="l00389"></a>00389 TBuf8<10> valBinary;
+<a name="l00390"></a>00390 err = fullSelectQuery.SelectBinaryL(sql, valBinary);
+<a name="l00391"></a>00391
+<a name="l00392"></a>00392 <span class="comment">// Query with F4 column (text column) </span>
+<a name="l00393"></a>00393 _LIT(KSql4, <span class="stringliteral">"SELECT F4 FROM A WHERE F1 = 1"</span>);
+<a name="l00394"></a>00394 sql.Copy(KSql4);
+<a name="l00395"></a>00395 <span class="comment">// Read F4 as integer. Expected value: 0.</span>
+<a name="l00396"></a>00396 valInt = fullSelectQuery.SelectIntL(sql);
+<a name="l00397"></a>00397
+<a name="l00398"></a>00398 <span class="comment">//Read F4 as 64-bit integer. Expected value: 0.</span>
+<a name="l00399"></a>00399 valInt64 = fullSelectQuery.SelectInt64L(sql);
+<a name="l00400"></a>00400
+<a name="l00401"></a>00401 <span class="comment">// Read F4 as real. Expected value: 0.0.</span>
+<a name="l00402"></a>00402 valReal = fullSelectQuery.SelectRealL(sql);
+<a name="l00403"></a>00403
+<a name="l00404"></a>00404 <span class="comment">// Read F4 as text. Small buffer. Expected return code: positive value, which is the column length in characters.</span>
+<a name="l00405"></a>00405 err = fullSelectQuery.SelectTextL(sql, valText);
+<a name="l00406"></a>00406
+<a name="l00407"></a>00407 <span class="comment">// Read F4 as text. Big enough buffer. </span>
+<a name="l00408"></a>00408 TBuf<32> valText2;
+<a name="l00409"></a>00409 err = fullSelectQuery.SelectTextL(sql, valText2);
+<a name="l00410"></a>00410
+<a name="l00411"></a>00411 <span class="comment">// Read F4 as binary. Expected error: KErrNone. Zero-length 8-bit descriptor.</span>
+<a name="l00412"></a>00412 err = fullSelectQuery.SelectBinaryL(sql, valBinary);
+<a name="l00413"></a>00413
+<a name="l00414"></a>00414 <span class="comment">// Read F5 as binary. Big enough buffer.</span>
+<a name="l00415"></a>00415 TBuf8<100> valBinary2;
+<a name="l00416"></a>00416 err = fullSelectQuery.SelectBinaryL(sql, valBinary2);
+<a name="l00417"></a>00417
+<a name="l00418"></a>00418 <span class="comment">// Text column value, small buffer, reallocation </span>
+<a name="l00419"></a>00419 HBufC* hbuf = HBufC::NewLC(10);
+<a name="l00420"></a>00420 TPtr name = hbuf->Des();
+<a name="l00421"></a>00421 sql.Copy(KSql4);
+<a name="l00422"></a>00422 err = fullSelectQuery.SelectTextL(sql, name);
+<a name="l00423"></a>00423
+<a name="l00424"></a>00424 <span class="keywordflow">if</span>(err > 0)
+<a name="l00425"></a>00425 {
+<a name="l00426"></a>00426 hbuf = hbuf->ReAllocL(err);
+<a name="l00427"></a>00427 CleanupStack::Pop();
+<a name="l00428"></a>00428 CleanupStack::PushL(hbuf);
+<a name="l00429"></a>00429 name.Set(hbuf->Des());
+<a name="l00430"></a>00430 err = fullSelectQuery.SelectTextL(sql, name);
+<a name="l00431"></a>00431
+<a name="l00432"></a>00432 }
+<a name="l00433"></a>00433 CleanupStack::PopAndDestroy(); <span class="comment">// hbuf, can't be put as parameter, because may be reallocated</span>
+<a name="l00434"></a>00434 <span class="comment">//Close database, delete database file.</span>
+<a name="l00435"></a>00435 db.Close();
+<a name="l00436"></a>00436 User::LeaveIfError(RSqlDatabase::Delete(KDatabase));
+<a name="l00437"></a>00437
+<a name="l00438"></a>00438 }
+<a name="l00439"></a>00439
+<a name="l00447"></a><a class="code" href="class_c_sql_example.html#12e036a57115aceb1c64545fc9dee052">00447</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#12e036a57115aceb1c64545fc9dee052">CSqlExample::ColumnBinaryStreamL</a>()
+<a name="l00448"></a>00448 {
+<a name="l00449"></a>00449 RSqlDatabase db;
+<a name="l00450"></a>00450 TInt <a class="code" href="_camera___app_ui_8cpp.html#711e7d3cb49b7e0de7880fed269134d3">error</a>;
+<a name="l00451"></a>00451 User::LeaveIfError(db.Create(KDbName));
+<a name="l00452"></a>00452
+<a name="l00453"></a>00453 <span class="comment">// Create a table</span>
+<a name="l00454"></a>00454 _LIT(KSqlStmt1, <span class="stringliteral">"CREATE TABLE A(Fld1 INTEGER, Fld2 BLOB);"</span>);
+<a name="l00455"></a>00455
+<a name="l00456"></a>00456 User::LeaveIfError(error = db.Exec(KSqlStmt1));
+<a name="l00457"></a>00457 <span class="keyword">const</span> TInt KDataLen = 100;
+<a name="l00458"></a>00458
+<a name="l00459"></a>00459 _LIT(KSqlStmt2, <span class="stringliteral">"INSERT INTO A(Fld1, Fld2) VALUES("</span>);
+<a name="l00460"></a>00460
+<a name="l00461"></a>00461 <span class="comment">// Allocate a buffer for the SQL statement.</span>
+<a name="l00462"></a>00462 HBufC8* buf = HBufC8::New(KSqlStmt2().Length() + KDataLen * 2 + 10);
+<a name="l00463"></a>00463
+<a name="l00464"></a>00464 TPtr8 sql = buf->Des();
+<a name="l00465"></a>00465
+<a name="l00466"></a>00466 <span class="comment">// Insert row 1</span>
+<a name="l00467"></a>00467
+<a name="l00468"></a>00468 _LIT(KHexValStr1, <span class="stringliteral">"7E"</span>);
+<a name="l00469"></a>00469 sql.Copy(KSqlStmt2);
+<a name="l00470"></a>00470
+<a name="l00471"></a>00471 _LIT(<a class="code" href="centrepexample_8cpp.html#9cac7b725e3b7db4f0996569491a8754">KString1</a>, <span class="stringliteral">"1, x'"</span>);
+<a name="l00472"></a>00472 sql.Append(<a class="code" href="centrepexample_8cpp.html#9cac7b725e3b7db4f0996569491a8754">KString1</a>);
+<a name="l00473"></a>00473 TInt i;
+<a name="l00474"></a>00474 <span class="keywordflow">for</span>(i=0;i<KDataLen;++i)
+<a name="l00475"></a>00475 {
+<a name="l00476"></a>00476 sql.Append(KHexValStr1);
+<a name="l00477"></a>00477 }
+<a name="l00478"></a>00478 _LIT(KString2, <span class="stringliteral">"')"</span>);
+<a name="l00479"></a>00479 sql.Append(KString2);
+<a name="l00480"></a>00480
+<a name="l00481"></a>00481 User::LeaveIfError(db.Exec(sql));
+<a name="l00482"></a>00482
+<a name="l00483"></a>00483 <span class="comment">// Insert row 2</span>
+<a name="l00484"></a>00484
+<a name="l00485"></a>00485 _LIT(KHexValStr2, <span class="stringliteral">"A3"</span>);
+<a name="l00486"></a>00486 sql.Copy(KSqlStmt2);
+<a name="l00487"></a>00487 _LIT(KString3, <span class="stringliteral">"2, x'"</span>);
+<a name="l00488"></a>00488 sql.Append(KString3);
+<a name="l00489"></a>00489 <span class="keywordflow">for</span>(i=0;i<KDataLen;++i)
+<a name="l00490"></a>00490 {
+<a name="l00491"></a>00491 sql.Append(KHexValStr2);
+<a name="l00492"></a>00492 }
+<a name="l00493"></a>00493 _LIT(KString4, <span class="stringliteral">"')"</span>);
+<a name="l00494"></a>00494 sql.Append(KString4);
+<a name="l00495"></a>00495
+<a name="l00496"></a>00496 User::LeaveIfError(db.Exec(sql));
+<a name="l00497"></a>00497
+<a name="l00498"></a>00498 <span class="comment">// Prepare SELECT SQL statement</span>
+<a name="l00499"></a>00499 _LIT(KSqlStmt3, <span class="stringliteral">"SELECT * FROM A"</span>);
+<a name="l00500"></a>00500
+<a name="l00501"></a>00501 RSqlStatement stmt;
+<a name="l00502"></a>00502 User::LeaveIfError(error = stmt.Prepare(db, KSqlStmt3));
+<a name="l00503"></a>00503
+<a name="l00504"></a>00504 <span class="comment">// Move on row 1</span>
+<a name="l00505"></a>00505 User::LeaveIfError(error = stmt.Next());
+<a name="l00506"></a>00506
+<a name="l00507"></a>00507 <span class="comment">// Read the long binary column using a stream</span>
+<a name="l00508"></a>00508 RSqlColumnReadStream columnStream;
+<a name="l00509"></a>00509 error = columnStream.ColumnBinary(stmt, 1);
+<a name="l00510"></a>00510
+<a name="l00511"></a>00511
+<a name="l00512"></a>00512 TInt size = stmt.ColumnSize(1);
+<a name="l00513"></a>00513 TPtr8 colData = buf->Des();
+<a name="l00514"></a>00514 TRAP(error, columnStream.ReadL(colData, size));
+<a name="l00515"></a>00515 columnStream.Close();
+<a name="l00516"></a>00516
+<a name="l00517"></a>00517 User::LeaveIfError(stmt.Next());
+<a name="l00518"></a>00518
+<a name="l00519"></a>00519 <span class="comment">//Read row 2 using ColumnBinary(TInt aColumnIndex, TDes8& aDest).</span>
+<a name="l00520"></a>00520 error = stmt.ColumnBinary(1, colData);
+<a name="l00521"></a>00521
+<a name="l00522"></a>00522 <span class="comment">//Read row 2 using a stream</span>
+<a name="l00523"></a>00523 colData.Zero();
+<a name="l00524"></a>00524 error = columnStream.ColumnBinary(stmt, 1);
+<a name="l00525"></a>00525
+<a name="l00526"></a>00526 size = stmt.ColumnSize(1);
+<a name="l00527"></a>00527 TRAP(error, columnStream.ReadL(colData, size));
+<a name="l00528"></a>00528 columnStream.Close();
+<a name="l00529"></a>00529
+<a name="l00530"></a>00530 stmt.Close();
+<a name="l00531"></a>00531
+<a name="l00532"></a>00532 <span class="keyword">delete</span> buf;
+<a name="l00533"></a>00533 buf = NULL;
+<a name="l00534"></a>00534
+<a name="l00535"></a>00535 db.Close();
+<a name="l00536"></a>00536
+<a name="l00537"></a>00537 error = RSqlDatabase::Delete(KDbName);
+<a name="l00538"></a>00538
+<a name="l00539"></a>00539 }
+<a name="l00540"></a>00540
+<a name="l00541"></a>00541
+<a name="l00542"></a><a class="code" href="sqlexample_8cpp.html#689e0bf9aa924a1d7dc108665d44736c">00542</a> LOCAL_C <span class="keywordtype">void</span> <a class="code" href="circularbuffer_8cpp.html#5fb473d4ee18739183215b04dcad6e12">MainL</a>()
+<a name="l00543"></a>00543 {
+<a name="l00544"></a>00544 <span class="comment">// Create an Active Scheduler to handle asychronous calls</span>
+<a name="l00545"></a>00545 CActiveScheduler* scheduler = <span class="keyword">new</span> (ELeave) CActiveScheduler;
+<a name="l00546"></a>00546 CleanupStack::PushL(scheduler);
+<a name="l00547"></a>00547 CActiveScheduler::Install( scheduler );
+<a name="l00548"></a>00548 <a class="code" href="class_c_sql_example.html">CSqlExample</a>* app = <a class="code" href="class_c_sql_example.html#8b115210a3fbfa19de5c7f6a0abf3e43">CSqlExample::NewLC</a>();
+<a name="l00549"></a>00549
+<a name="l00550"></a>00550 <span class="comment">// Create a non secure database</span>
+<a name="l00551"></a>00551 app-><a class="code" href="class_c_sql_example.html#f0523fb9c7a711a2c7745e8d2e96faa7">CreateNonSecureDBL</a>();
+<a name="l00552"></a>00552
+<a name="l00553"></a>00553 <span class="comment">// Create and open a secure database</span>
+<a name="l00554"></a>00554 app-><a class="code" href="class_c_sql_example.html#2d2358e96bba71900cedd067fe44192b">CreateAndOpenSecureDBL</a>();
+<a name="l00555"></a>00555
+<a name="l00556"></a>00556 <span class="comment">// Copy two databases</span>
+<a name="l00557"></a>00557 app-><a class="code" href="class_c_sql_example.html#1a6247133748297a2a8877381583e51c">CopyDatabaseL</a>();
+<a name="l00558"></a>00558
+<a name="l00559"></a>00559 <span class="comment">// Attach two databases</span>
+<a name="l00560"></a>00560 app-><a class="code" href="class_c_sql_example.html#df02168d537e9e1650d5f379522a6b2e">AttachDatabasesL</a>();
+<a name="l00561"></a>00561
+<a name="l00562"></a>00562 <span class="comment">// Simple query and query with paramaters</span>
+<a name="l00563"></a>00563 app-><a class="code" href="class_c_sql_example.html#49067abc75f826bfd43be44c07460c7b">DataTypesQueryL</a>();
+<a name="l00564"></a>00564
+<a name="l00565"></a>00565 <span class="comment">//Prepares and executes a query with a large parameter</span>
+<a name="l00566"></a>00566 <span class="comment">// writing that parameter using streaming (RParamWriteStream)</span>
+<a name="l00567"></a>00567 app-><a class="code" href="class_c_sql_example.html#7fac459ccd95278c1af4eb50e5453812">ScalarFullSelectL</a>();
+<a name="l00568"></a>00568
+<a name="l00569"></a>00569 <span class="comment">// Prepare and execute a query which returns data,</span>
+<a name="l00570"></a>00570 <span class="comment">// and read that data using streaming (RColumnReadStream)</span>
+<a name="l00571"></a>00571 app-><a class="code" href="class_c_sql_example.html#12e036a57115aceb1c64545fc9dee052">ColumnBinaryStreamL</a>();
+<a name="l00572"></a>00572
+<a name="l00573"></a>00573 CleanupStack::PopAndDestroy(2); <span class="comment">//app, scheduler</span>
+<a name="l00574"></a>00574
+<a name="l00575"></a>00575 }
+<a name="l00576"></a>00576
+<a name="l00577"></a><a class="code" href="sqlexample_8cpp.html#0f358e9c4355138f629b8c4f37310295">00577</a> GLDEF_C TInt <a class="code" href="dbllist_8cpp.html#0f358e9c4355138f629b8c4f37310295">E32Main</a>()
+<a name="l00578"></a>00578 {
+<a name="l00579"></a>00579 __UHEAP_MARK;
+<a name="l00580"></a>00580 CTrapCleanup* cleanup = CTrapCleanup::New();
+<a name="l00581"></a>00581 <span class="keywordflow">if</span>(cleanup == NULL)
+<a name="l00582"></a>00582 {
+<a name="l00583"></a>00583 <span class="keywordflow">return</span> KErrNoMemory;
+<a name="l00584"></a>00584 }
+<a name="l00585"></a>00585 TRAPD(err, <a class="code" href="circularbuffer_8cpp.html#5fb473d4ee18739183215b04dcad6e12">MainL</a>());
+<a name="l00586"></a>00586 <span class="keywordflow">if</span>(err != KErrNone)
+<a name="l00587"></a>00587 {
+<a name="l00588"></a>00588 User::Panic(_L(<span class="stringliteral">"Failed to complete"</span>),err);
+<a name="l00589"></a>00589 }
+<a name="l00590"></a>00590
+<a name="l00591"></a>00591 <span class="keyword">delete</span> cleanup;
+<a name="l00592"></a>00592 __UHEAP_MARKEND;
+<a name="l00593"></a>00593 <span class="keywordflow">return</span> KErrNone;
+<a name="l00594"></a>00594 }
+</pre></div><hr size="1"><address style="text-align: right;"><small>Generated on Thu Jan 21 10:33:00 2010 for TB10.1 Example Applications by
+<a href="http://www.doxygen.org/index.html">
+<img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.3 </small></address>
+</body>
+</html>