|
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
|
2 <html xmlns="http://www.w3.org/1999/xhtml"> |
|
3 <head> |
|
4 <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> |
|
5 <title>TB9.2 Example Applications: examples/SysLibs/SqlExample/sqlexample.cpp Source File</title> |
|
6 <link href="tabs.css" rel="stylesheet" type="text/css"/> |
|
7 <link href="doxygen.css" rel="stylesheet" type="text/css"/> |
|
8 </head> |
|
9 <body> |
|
10 <!-- Generated by Doxygen 1.6.2 --> |
|
11 <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> |
|
12 <a name="l00002"></a>00002 <span class="comment">// All rights reserved.</span> |
|
13 <a name="l00003"></a>00003 <span class="comment">// This component and the accompanying materials are made available</span> |
|
14 <a name="l00004"></a>00004 <span class="comment">// under the terms of "Eclipse Public License v1.0"</span> |
|
15 <a name="l00005"></a>00005 <span class="comment">// which accompanies this distribution, and is available</span> |
|
16 <a name="l00006"></a>00006 <span class="comment">// at the URL "http://www.eclipse.org/legal/epl-v10.html".</span> |
|
17 <a name="l00007"></a>00007 <span class="comment">//</span> |
|
18 <a name="l00008"></a>00008 <span class="comment">// Initial Contributors:</span> |
|
19 <a name="l00009"></a>00009 <span class="comment">// Nokia Corporation - initial contribution.</span> |
|
20 <a name="l00010"></a>00010 <span class="comment">//</span> |
|
21 <a name="l00011"></a>00011 <span class="comment">// Contributors:</span> |
|
22 <a name="l00012"></a>00012 <span class="comment">//</span> |
|
23 <a name="l00013"></a>00013 <span class="comment">// Description:</span> |
|
24 <a name="l00014"></a>00014 <span class="comment">// This example program demonstrates the use of SQL APIs. </span> |
|
25 <a name="l00015"></a>00015 <span class="comment">// The code demonstrates how to create non secure and secure databases on </span> |
|
26 <a name="l00016"></a>00016 <span class="comment">// the writable drive and perform basic operations on the databases.</span> |
|
27 <a name="l00017"></a>00017 <span class="comment">//</span> |
|
28 <a name="l00018"></a>00018 |
|
29 <a name="l00019"></a>00019 |
|
30 <a name="l00020"></a>00020 |
|
31 <a name="l00024"></a>00024 <span class="preprocessor">#include "<a class="code" href="sqlexample_8h.html">sqlexample.h</a>"</span> |
|
32 <a name="l00025"></a>00025 <span class="preprocessor">#include <e32cons.h></span> |
|
33 <a name="l00026"></a>00026 <span class="preprocessor">#include <sqldb.h></span> |
|
34 <a name="l00027"></a>00027 |
|
35 <a name="l00028"></a>00028 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTitle, <span class="stringliteral">"SQL example"</span>); |
|
36 <a name="l00029"></a>00029 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTextPressAKey, <span class="stringliteral">"\n\nPress any key to step through the example\n"</span>); |
|
37 <a name="l00030"></a>00030 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KExit,<span class="stringliteral">"Press any key to exit the application "</span>); |
|
38 <a name="l00031"></a>00031 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPressAKey,<span class="stringliteral">"Press any key to continue \n"</span>); |
|
39 <a name="l00032"></a>00032 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KNonSecure,<span class="stringliteral">"\nCreating a non secure database \n"</span>); |
|
40 <a name="l00033"></a>00033 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecure,<span class="stringliteral">"\nCreating a secure database \n"</span>); |
|
41 <a name="l00034"></a>00034 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KOpen,<span class="stringliteral">"Opening the secure database \n"</span>); |
|
42 <a name="l00035"></a>00035 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KDelete,<span class="stringliteral">"Deleting the database(s)\n"</span>); |
|
43 <a name="l00036"></a>00036 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KClose,<span class="stringliteral">"Closing the database(s)\n"</span>); |
|
44 <a name="l00037"></a>00037 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KCopyNonSec,<span class="stringliteral">"\nCopying a non secure database to another non secure one \n"</span>); |
|
45 <a name="l00038"></a>00038 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KCopySecure,<span class="stringliteral">"\nCopying a secure database to another secure database \n"</span>); |
|
46 <a name="l00039"></a>00039 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAttach,<span class="stringliteral">"\nOpen a secure database and attach another secure database\n"</span>); |
|
47 <a name="l00040"></a>00040 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KCreateTable,<span class="stringliteral">"\nCreating a table\n"</span>); |
|
48 <a name="l00041"></a>00041 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KInsert,<span class="stringliteral">"Inserting records into the table\n"</span>); |
|
49 <a name="l00042"></a>00042 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPrepare,<span class="stringliteral">"Preparing a query\n"</span>); |
|
50 <a name="l00043"></a>00043 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KExecute,<span class="stringliteral">"Executing a query\n"</span>); |
|
51 <a name="l00044"></a>00044 |
|
52 <a name="l00045"></a>00045 <span class="comment">// Names of the databases created, operated upon and later deleted.</span> |
|
53 <a name="l00046"></a>00046 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KDbName, <span class="stringliteral">"\\Example_db.db"</span>); |
|
54 <a name="l00047"></a>00047 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAnotherDbName, <span class="stringliteral">"\\Example_Anotherdb.db"</span>); |
|
55 <a name="l00048"></a>00048 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureDb1, <span class="stringliteral">"[E80000AF]db1.db"</span>); |
|
56 <a name="l00049"></a>00049 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureDb2, <span class="stringliteral">"[E80000AF]db2.db"</span>); |
|
57 <a name="l00050"></a>00050 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KDatabase, <span class="stringliteral">"\\Sqlscalarfullselect.db"</span>); |
|
58 <a name="l00051"></a>00051 |
|
59 <a name="l00052"></a>00052 <span class="comment">// Security policies used</span> |
|
60 <a name="l00053"></a>00053 <span class="keyword">const</span> TSecurityPolicy KPolicy1(ECapabilityReadUserData, ECapabilityNetworkControl, ECapabilityWriteUserData); |
|
61 <a name="l00054"></a>00054 <span class="keyword">const</span> TSecurityPolicy KPolicy2(ECapabilityReadUserData); |
|
62 <a name="l00055"></a>00055 |
|
63 <a name="l00061"></a><a class="code" href="class_c_sql_example.html#a8b115210a3fbfa19de5c7f6a0abf3e43">00061</a> <a class="code" href="class_c_sql_example.html">CSqlExample</a>* <a class="code" href="class_c_sql_example.html#a8b115210a3fbfa19de5c7f6a0abf3e43">CSqlExample::NewLC</a>() |
|
64 <a name="l00062"></a>00062 { |
|
65 <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>(); |
|
66 <a name="l00064"></a>00064 CleanupStack::PushL(rep); |
|
67 <a name="l00065"></a>00065 rep->ConstructL(); |
|
68 <a name="l00066"></a>00066 <span class="keywordflow">return</span> rep; |
|
69 <a name="l00067"></a>00067 } |
|
70 <a name="l00068"></a>00068 |
|
71 <a name="l00072"></a>00072 CSqlExample::CSqlExample() |
|
72 <a name="l00073"></a>00073 { |
|
73 <a name="l00074"></a>00074 } |
|
74 <a name="l00075"></a>00075 |
|
75 <a name="l00076"></a>00076 <span class="keywordtype">void</span> CSqlExample::ConstructL() |
|
76 <a name="l00077"></a>00077 { |
|
77 <a name="l00078"></a>00078 iConsole = Console::NewL(KTitle,TSize(KConsFullScreen,KConsFullScreen)); |
|
78 <a name="l00079"></a>00079 iConsole->Printf ( KTextPressAKey ); |
|
79 <a name="l00080"></a>00080 iConsole->Getch (); |
|
80 <a name="l00081"></a>00081 } |
|
81 <a name="l00082"></a>00082 |
|
82 <a name="l00086"></a><a class="code" href="class_c_sql_example.html#a81cffca804968549ed3523230f28408f">00086</a> <a class="code" href="class_c_sql_example.html#a81cffca804968549ed3523230f28408f">CSqlExample::~CSqlExample</a>() |
|
83 <a name="l00087"></a>00087 { |
|
84 <a name="l00088"></a>00088 iConsole->Printf(KExit); |
|
85 <a name="l00089"></a>00089 iConsole->Getch(); |
|
86 <a name="l00090"></a>00090 |
|
87 <a name="l00091"></a>00091 <span class="keyword">delete</span> iConsole; |
|
88 <a name="l00092"></a>00092 } |
|
89 <a name="l00093"></a>00093 |
|
90 <a name="l00100"></a><a class="code" href="class_c_sql_example.html#af0523fb9c7a711a2c7745e8d2e96faa7">00100</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#af0523fb9c7a711a2c7745e8d2e96faa7">CSqlExample::CreateNonSecureDBL</a>() |
|
91 <a name="l00101"></a>00101 { |
|
92 <a name="l00102"></a>00102 TBuf<200> buffer; |
|
93 <a name="l00103"></a>00103 RSqlDatabase db; |
|
94 <a name="l00104"></a>00104 |
|
95 <a name="l00105"></a>00105 <span class="comment">// Create non-secure database</span> |
|
96 <a name="l00106"></a>00106 iConsole->Printf(KNonSecure); |
|
97 <a name="l00107"></a>00107 TInt error; |
|
98 <a name="l00108"></a>00108 TRAP(error,db.Create(KDbName);); |
|
99 <a name="l00109"></a>00109 |
|
100 <a name="l00110"></a>00110 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTable,<span class="stringliteral">"CREATE TABLE A1(F1 INTEGER, F2 INTEGER)"</span>); |
|
101 <a name="l00111"></a>00111 User::LeaveIfError(error = db.Exec(KTable)); |
|
102 <a name="l00112"></a>00112 |
|
103 <a name="l00113"></a>00113 db.Close(); |
|
104 <a name="l00114"></a>00114 iConsole->Printf(KClose); |
|
105 <a name="l00115"></a>00115 iConsole->Printf(KPressAKey); |
|
106 <a name="l00116"></a>00116 iConsole->Getch(); |
|
107 <a name="l00117"></a>00117 } |
|
108 <a name="l00118"></a>00118 |
|
109 <a name="l00127"></a><a class="code" href="class_c_sql_example.html#a2d2358e96bba71900cedd067fe44192b">00127</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a2d2358e96bba71900cedd067fe44192b">CSqlExample::CreateAndOpenSecureDBL</a>() |
|
110 <a name="l00128"></a>00128 { |
|
111 <a name="l00129"></a>00129 RSqlDatabase db; |
|
112 <a name="l00130"></a>00130 RSqlSecurityPolicy securityPolicy; |
|
113 <a name="l00131"></a>00131 |
|
114 <a name="l00132"></a>00132 User::LeaveIfError(securityPolicy.Create(TSecurityPolicy(TSecurityPolicy::EAlwaysPass))); |
|
115 <a name="l00133"></a>00133 User::LeaveIfError(securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KPolicy1)); |
|
116 <a name="l00134"></a>00134 |
|
117 <a name="l00135"></a>00135 iConsole->Printf(KSecure); |
|
118 <a name="l00136"></a>00136 User::LeaveIfError(db.Create(KSecureDb1, securityPolicy)); |
|
119 <a name="l00137"></a>00137 |
|
120 <a name="l00138"></a>00138 securityPolicy.Close(); |
|
121 <a name="l00139"></a>00139 |
|
122 <a name="l00140"></a>00140 <span class="comment">// Check that the database security policy matches the policy used </span> |
|
123 <a name="l00141"></a>00141 <span class="comment">//when the database was created.</span> |
|
124 <a name="l00142"></a>00142 User::LeaveIfError(db.GetSecurityPolicy(securityPolicy)); |
|
125 <a name="l00143"></a>00143 |
|
126 <a name="l00144"></a>00144 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureCreate,<span class="stringliteral">"CREATE TABLE secure(int_fld integer, null_int_fld integer default null)"</span>); |
|
127 <a name="l00145"></a>00145 User::LeaveIfError(db.Exec(KSecureCreate)); |
|
128 <a name="l00146"></a>00146 |
|
129 <a name="l00147"></a>00147 <span class="comment">// Attempt to write to the secure database</span> |
|
130 <a name="l00148"></a>00148 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureInsert,<span class="stringliteral">"INSERT INTO secure(int_fld) values(200)"</span>); |
|
131 <a name="l00149"></a>00149 User::LeaveIfError(db.Exec(KSecureInsert)); |
|
132 <a name="l00150"></a>00150 db.Close(); |
|
133 <a name="l00151"></a>00151 |
|
134 <a name="l00152"></a>00152 iConsole->Printf(KOpen); |
|
135 <a name="l00153"></a>00153 <span class="comment">// Open the secure database </span> |
|
136 <a name="l00154"></a>00154 User::LeaveIfError(db.Open(KSecureDb1)); |
|
137 <a name="l00155"></a>00155 |
|
138 <a name="l00156"></a>00156 db.Close(); |
|
139 <a name="l00157"></a>00157 iConsole->Printf(KClose); |
|
140 <a name="l00158"></a>00158 iConsole->Printf(KPressAKey); |
|
141 <a name="l00159"></a>00159 iConsole->Getch(); |
|
142 <a name="l00160"></a>00160 securityPolicy.Close(); |
|
143 <a name="l00161"></a>00161 |
|
144 <a name="l00162"></a>00162 } |
|
145 <a name="l00163"></a>00163 |
|
146 <a name="l00171"></a><a class="code" href="class_c_sql_example.html#a1a6247133748297a2a8877381583e51c">00171</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a1a6247133748297a2a8877381583e51c">CSqlExample::CopyDatabaseL</a>() |
|
147 <a name="l00172"></a>00172 { |
|
148 <a name="l00173"></a>00173 RSqlDatabase db; |
|
149 <a name="l00174"></a>00174 |
|
150 <a name="l00175"></a>00175 <span class="comment">// Copy non-secure to non-secure database</span> |
|
151 <a name="l00176"></a>00176 iConsole->Printf(KCopyNonSec); |
|
152 <a name="l00177"></a>00177 User::LeaveIfError(RSqlDatabase::Copy(KDbName, KAnotherDbName)); |
|
153 <a name="l00178"></a>00178 |
|
154 <a name="l00179"></a>00179 <span class="comment">// Delete the source database</span> |
|
155 <a name="l00180"></a>00180 iConsole->Printf(KDelete); |
|
156 <a name="l00181"></a>00181 User::LeaveIfError(RSqlDatabase::Delete(KAnotherDbName)); |
|
157 <a name="l00182"></a>00182 |
|
158 <a name="l00183"></a>00183 <span class="comment">// Create another secure database with a different security policy,</span> |
|
159 <a name="l00184"></a>00184 <span class="comment">// KSecureDb1 is already created with KPolicy1.</span> |
|
160 <a name="l00185"></a>00185 RSqlSecurityPolicy securityPolicy; |
|
161 <a name="l00186"></a>00186 User::LeaveIfError(securityPolicy.Create(TSecurityPolicy(TSecurityPolicy::EAlwaysPass))); |
|
162 <a name="l00187"></a>00187 |
|
163 <a name="l00188"></a>00188 User::LeaveIfError(securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KPolicy2)); |
|
164 <a name="l00189"></a>00189 |
|
165 <a name="l00190"></a>00190 User::LeaveIfError(db.Create(KSecureDb2, securityPolicy)); |
|
166 <a name="l00191"></a>00191 |
|
167 <a name="l00192"></a>00192 User::LeaveIfError(db.GetSecurityPolicy(securityPolicy)); |
|
168 <a name="l00193"></a>00193 db.Close(); |
|
169 <a name="l00194"></a>00194 |
|
170 <a name="l00195"></a>00195 <span class="comment">// Copy secure to secure database. The application is the database owner.</span> |
|
171 <a name="l00196"></a>00196 iConsole->Printf(KCopySecure); |
|
172 <a name="l00197"></a>00197 User::LeaveIfError(RSqlDatabase::Copy(KSecureDb1, KSecureDb2)); |
|
173 <a name="l00198"></a>00198 |
|
174 <a name="l00199"></a>00199 <span class="comment">// Delete the source database</span> |
|
175 <a name="l00200"></a>00200 iConsole->Printf(KDelete); |
|
176 <a name="l00201"></a>00201 User::LeaveIfError(RSqlDatabase::Delete(KSecureDb1)); |
|
177 <a name="l00202"></a>00202 |
|
178 <a name="l00203"></a>00203 iConsole->Printf(KPressAKey); |
|
179 <a name="l00204"></a>00204 iConsole->Getch(); |
|
180 <a name="l00205"></a>00205 securityPolicy.Close(); |
|
181 <a name="l00206"></a>00206 db.Close(); |
|
182 <a name="l00207"></a>00207 |
|
183 <a name="l00208"></a>00208 } |
|
184 <a name="l00209"></a>00209 |
|
185 <a name="l00217"></a><a class="code" href="class_c_sql_example.html#adf02168d537e9e1650d5f379522a6b2e">00217</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#adf02168d537e9e1650d5f379522a6b2e">CSqlExample::AttachDatabasesL</a>() |
|
186 <a name="l00218"></a>00218 { |
|
187 <a name="l00219"></a>00219 RSqlDatabase db; |
|
188 <a name="l00220"></a>00220 RSqlSecurityPolicy securityPolicy; |
|
189 <a name="l00221"></a>00221 |
|
190 <a name="l00222"></a>00222 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAttachDb2, <span class="stringliteral">"Db2"</span>); |
|
191 <a name="l00223"></a>00223 |
|
192 <a name="l00224"></a>00224 User::LeaveIfError(db.Open(KSecureDb2)); |
|
193 <a name="l00225"></a>00225 iConsole->Printf(KAttach); |
|
194 <a name="l00226"></a>00226 |
|
195 <a name="l00227"></a>00227 User::LeaveIfError(db.Attach(KDbName, KAttachDb2)); |
|
196 <a name="l00228"></a>00228 |
|
197 <a name="l00229"></a>00229 <span class="comment">// Attempt to write to the attached non secure database</span> |
|
198 <a name="l00230"></a>00230 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabInsert,<span class="stringliteral">"INSERT INTO db2.a1(f1) valUES(10)"</span>); |
|
199 <a name="l00231"></a>00231 User::LeaveIfError(db.Exec(KTabInsert)); |
|
200 <a name="l00232"></a>00232 |
|
201 <a name="l00233"></a>00233 <span class="comment">// Attempt to read from the attached non secure database</span> |
|
202 <a name="l00234"></a>00234 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSelect,<span class="stringliteral">"SELECT * FROM db2.a1"</span>); |
|
203 <a name="l00235"></a>00235 User::LeaveIfError(db.Exec(KSelect)); |
|
204 <a name="l00236"></a>00236 |
|
205 <a name="l00237"></a>00237 <span class="comment">// Attempt to write to the main secure database</span> |
|
206 <a name="l00238"></a>00238 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAttachInsert,<span class="stringliteral">"INSERT INTO a1(f1) valUES(10)"</span>); |
|
207 <a name="l00239"></a>00239 User::LeaveIfError(db.Exec(KAttachInsert)); |
|
208 <a name="l00240"></a>00240 |
|
209 <a name="l00241"></a>00241 db.Close(); |
|
210 <a name="l00242"></a>00242 iConsole->Printf(KDelete); |
|
211 <a name="l00243"></a>00243 User::LeaveIfError(RSqlDatabase::Delete(KDbName)); |
|
212 <a name="l00244"></a>00244 |
|
213 <a name="l00245"></a>00245 User::LeaveIfError(RSqlDatabase::Delete(KSecureDb2)); |
|
214 <a name="l00246"></a>00246 |
|
215 <a name="l00247"></a>00247 securityPolicy.Close(); |
|
216 <a name="l00248"></a>00248 |
|
217 <a name="l00249"></a>00249 } |
|
218 <a name="l00250"></a>00250 |
|
219 <a name="l00257"></a><a class="code" href="class_c_sql_example.html#a49067abc75f826bfd43be44c07460c7b">00257</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a49067abc75f826bfd43be44c07460c7b">CSqlExample:: DataTypesQueryL</a>() |
|
220 <a name="l00258"></a>00258 { |
|
221 <a name="l00259"></a>00259 RSqlDatabase db; |
|
222 <a name="l00260"></a>00260 iConsole->Printf(KSecure); |
|
223 <a name="l00261"></a>00261 |
|
224 <a name="l00262"></a>00262 User::LeaveIfError(db.Create(KDbName)); |
|
225 <a name="l00263"></a>00263 |
|
226 <a name="l00264"></a>00264 <span class="comment">// Create a table with different numeric field types</span> |
|
227 <a name="l00265"></a>00265 iConsole->Printf(KCreateTable); |
|
228 <a name="l00266"></a>00266 iConsole->Printf(KExecute); |
|
229 <a name="l00267"></a>00267 |
|
230 <a name="l00268"></a>00268 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql1, <span class="stringliteral">"CREATE TABLE Tbl(A INTEGER, B SMALLINT, C REAL, D DOUBLE PRECISION, E FLOAT, \</span> |
|
231 <a name="l00269"></a>00269 <span class="stringliteral"> F DECIMAL)"</span>); |
|
232 <a name="l00270"></a>00270 User::LeaveIfError(db.Exec(KSql1)); |
|
233 <a name="l00271"></a>00271 |
|
234 <a name="l00272"></a>00272 <span class="comment">// Insert one record in to the created table</span> |
|
235 <a name="l00273"></a>00273 iConsole->Printf(KInsert); |
|
236 <a name="l00274"></a>00274 iConsole->Printf(KExecute); |
|
237 <a name="l00275"></a>00275 |
|
238 <a name="l00276"></a>00276 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql2, <span class="stringliteral">"INSERT INTO Tbl(A,B,C,D,E,F) VALUES(2000000000, 30000, 123.45, 0.912E+55,\</span> |
|
239 <a name="l00277"></a>00277 <span class="stringliteral"> 1.34E-14, 1234.5678)"</span>); |
|
240 <a name="l00278"></a>00278 User::LeaveIfError(db.Exec(KSql2)); |
|
241 <a name="l00279"></a>00279 |
|
242 <a name="l00280"></a>00280 <span class="comment">// Get the inserted record data</span> |
|
243 <a name="l00281"></a>00281 RSqlStatement stmt; |
|
244 <a name="l00282"></a>00282 iConsole->Printf(KPrepare); |
|
245 <a name="l00283"></a>00283 |
|
246 <a name="l00284"></a>00284 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPrepQuery,<span class="stringliteral">"SELECT * FROM Tbl"</span>); |
|
247 <a name="l00285"></a>00285 User::LeaveIfError(stmt.Prepare(db, KPrepQuery)); |
|
248 <a name="l00286"></a>00286 |
|
249 <a name="l00287"></a>00287 User::LeaveIfError(stmt.Next()); |
|
250 <a name="l00288"></a>00288 stmt.Close(); |
|
251 <a name="l00289"></a>00289 |
|
252 <a name="l00290"></a>00290 <span class="comment">// The statement object has to be closed before db.Exec() call, </span> |
|
253 <a name="l00291"></a>00291 <span class="comment">// otherwise the reported error is "database table is locked"</span> |
|
254 <a name="l00292"></a>00292 <span class="comment">// Insert second record in to the created table but inverse the column types.</span> |
|
255 <a name="l00293"></a>00293 iConsole->Printf(KExecute); |
|
256 <a name="l00294"></a>00294 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql3, <span class="stringliteral">"INSERT INTO Tbl(A, B, C, D, E, F) VALUES(\</span> |
|
257 <a name="l00295"></a>00295 <span class="stringliteral"> -2.5,1.1,12,23,45,111)"</span>); |
|
258 <a name="l00296"></a>00296 User::LeaveIfError(db.Exec(KSql3)); |
|
259 <a name="l00297"></a>00297 |
|
260 <a name="l00298"></a>00298 <span class="comment">// Get the inserted record data</span> |
|
261 <a name="l00299"></a>00299 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPrepQuery2,<span class="stringliteral">"SELECT * FROM Tbl"</span>); |
|
262 <a name="l00300"></a>00300 User::LeaveIfError(stmt.Prepare(db, KPrepQuery2)); |
|
263 <a name="l00301"></a>00301 |
|
264 <a name="l00302"></a>00302 User::LeaveIfError(stmt.Next()); |
|
265 <a name="l00303"></a>00303 |
|
266 <a name="l00304"></a>00304 stmt.Close(); |
|
267 <a name="l00305"></a>00305 |
|
268 <a name="l00306"></a>00306 <span class="comment">// Insert third record in to the created table</span> |
|
269 <a name="l00307"></a>00307 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql4, <span class="stringliteral">"INSERT INTO Tbl(A,B,C,D,E,F) VALUES(\</span> |
|
270 <a name="l00308"></a>00308 <span class="stringliteral"> 2,3,123.45,1.5,2.5,1.56)"</span>); |
|
271 <a name="l00309"></a>00309 User::LeaveIfError(db.Exec(KSql4)); |
|
272 <a name="l00310"></a>00310 |
|
273 <a name="l00311"></a>00311 stmt.Close(); |
|
274 <a name="l00312"></a>00312 db.Close(); |
|
275 <a name="l00313"></a>00313 User::LeaveIfError(RSqlDatabase::Delete(KDbName)); |
|
276 <a name="l00314"></a>00314 } |
|
277 <a name="l00315"></a>00315 |
|
278 <a name="l00316"></a>00316 |
|
279 <a name="l00328"></a><a class="code" href="class_c_sql_example.html#a7fac459ccd95278c1af4eb50e5453812">00328</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a7fac459ccd95278c1af4eb50e5453812">CSqlExample::ScalarFullSelectL</a>() |
|
280 <a name="l00329"></a>00329 { |
|
281 <a name="l00330"></a>00330 RSqlDatabase db; |
|
282 <a name="l00331"></a>00331 <span class="comment">//Create database.</span> |
|
283 <a name="l00332"></a>00332 User::LeaveIfError(db.Create(KDatabase)); |
|
284 <a name="l00333"></a>00333 |
|
285 <a name="l00334"></a>00334 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabCreateA,<span class="stringliteral">"CREATE TABLE A(F1 INTEGER, F2 INTEGER, F3 FLOAT, F4 TEXT, F5 BLOB)"</span>); |
|
286 <a name="l00335"></a>00335 User::LeaveIfError(db.Exec(KTabCreateA)); |
|
287 <a name="l00336"></a>00336 |
|
288 <a name="l00337"></a>00337 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabInsert1A,<span class="stringliteral">"INSERT INTO A(F1, F2, F3, F4, F5) VALUES(1, 10000000000, 2.54, 'NAME1234567890', NULL)"</span>); |
|
289 <a name="l00338"></a>00338 User::LeaveIfError(db.Exec(KTabInsert1A)); |
|
290 <a name="l00339"></a>00339 |
|
291 <a name="l00340"></a>00340 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabInsert2A,<span class="stringliteral">"INSERT INTO A(F1, F2, F3, F4) VALUES(2, 200, -1.11, 'ADDRESS')"</span>); |
|
292 <a name="l00341"></a>00341 User::LeaveIfError(db.Exec(KTabInsert2A)); |
|
293 <a name="l00342"></a>00342 |
|
294 <a name="l00343"></a>00343 RSqlStatement stmt; |
|
295 <a name="l00344"></a>00344 CleanupClosePushL(stmt); |
|
296 <a name="l00345"></a>00345 |
|
297 <a name="l00346"></a>00346 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KUpdate,<span class="stringliteral">"UPDATE A SET F5=:P WHERE F1 = 2"</span>); |
|
298 <a name="l00347"></a>00347 User::LeaveIfError(stmt.Prepare(db,KUpdate)); |
|
299 <a name="l00348"></a>00348 |
|
300 <a name="l00349"></a>00349 <span class="comment">// Open the parameter stream</span> |
|
301 <a name="l00350"></a>00350 RSqlParamWriteStream strm; |
|
302 <a name="l00351"></a>00351 CleanupClosePushL(strm); |
|
303 <a name="l00352"></a>00352 |
|
304 <a name="l00353"></a>00353 <span class="comment">// Prepare and set the parameter value (non-NULL value)</span> |
|
305 <a name="l00354"></a>00354 User::LeaveIfError(strm.BindBinary(stmt, 0)); |
|
306 <a name="l00355"></a>00355 |
|
307 <a name="l00356"></a>00356 <span class="keywordflow">for</span>(TInt i=0;i<100;++i) |
|
308 <a name="l00357"></a>00357 { |
|
309 <a name="l00358"></a>00358 strm << static_cast <TUint8> (i); |
|
310 <a name="l00359"></a>00359 } |
|
311 <a name="l00360"></a>00360 <span class="comment">// Write the buffered data into stream</span> |
|
312 <a name="l00361"></a>00361 strm.CommitL(); |
|
313 <a name="l00362"></a>00362 <span class="comment">// Execute the prepared SQL statement </span> |
|
314 <a name="l00363"></a>00363 User::LeaveIfError(stmt.Exec()); |
|
315 <a name="l00364"></a>00364 |
|
316 <a name="l00365"></a>00365 CleanupStack::PopAndDestroy(&strm); |
|
317 <a name="l00366"></a>00366 CleanupStack::PopAndDestroy(&stmt); |
|
318 <a name="l00367"></a>00367 |
|
319 <a name="l00368"></a>00368 TSqlScalarFullSelectQuery fullSelectQuery(db); |
|
320 <a name="l00369"></a>00369 |
|
321 <a name="l00370"></a>00370 TBuf<100> sql; |
|
322 <a name="l00371"></a>00371 |
|
323 <a name="l00372"></a>00372 <span class="comment">// Query with F2 column (64-bit integer column)</span> |
|
324 <a name="l00373"></a>00373 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAnotherSql, <span class="stringliteral">"SELECT F2 FROM A WHERE F1 = 1"</span>); |
|
325 <a name="l00374"></a>00374 sql.Copy(KAnotherSql); |
|
326 <a name="l00375"></a>00375 <span class="comment">// Read F2 as integer.</span> |
|
327 <a name="l00376"></a>00376 TInt valInt = fullSelectQuery.SelectIntL(sql); |
|
328 <a name="l00377"></a>00377 |
|
329 <a name="l00378"></a>00378 <span class="comment">// Read F2 as 64-bit integer. Expected value: 10000000000</span> |
|
330 <a name="l00379"></a>00379 TInt64 valInt64 = fullSelectQuery.SelectInt64L(sql); |
|
331 <a name="l00380"></a>00380 |
|
332 <a name="l00381"></a>00381 <span class="comment">// Read F2 as real. Expected value: 10000000000.0</span> |
|
333 <a name="l00382"></a>00382 TReal valReal = fullSelectQuery.SelectRealL(sql); |
|
334 <a name="l00383"></a>00383 |
|
335 <a name="l00384"></a>00384 <span class="comment">// Read F2 as text. Expected value: zero-length 16-bit descriptor.</span> |
|
336 <a name="l00385"></a>00385 TBuf<10> valText; |
|
337 <a name="l00386"></a>00386 TInt err = fullSelectQuery.SelectTextL(sql, valText); |
|
338 <a name="l00387"></a>00387 |
|
339 <a name="l00388"></a>00388 <span class="comment">// Read F2 as binary. Expected value: zero-length 8-bit descriptor.</span> |
|
340 <a name="l00389"></a>00389 TBuf8<10> valBinary; |
|
341 <a name="l00390"></a>00390 err = fullSelectQuery.SelectBinaryL(sql, valBinary); |
|
342 <a name="l00391"></a>00391 |
|
343 <a name="l00392"></a>00392 <span class="comment">// Query with F4 column (text column) </span> |
|
344 <a name="l00393"></a>00393 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql4, <span class="stringliteral">"SELECT F4 FROM A WHERE F1 = 1"</span>); |
|
345 <a name="l00394"></a>00394 sql.Copy(KSql4); |
|
346 <a name="l00395"></a>00395 <span class="comment">// Read F4 as integer. Expected value: 0.</span> |
|
347 <a name="l00396"></a>00396 valInt = fullSelectQuery.SelectIntL(sql); |
|
348 <a name="l00397"></a>00397 |
|
349 <a name="l00398"></a>00398 <span class="comment">//Read F4 as 64-bit integer. Expected value: 0.</span> |
|
350 <a name="l00399"></a>00399 valInt64 = fullSelectQuery.SelectInt64L(sql); |
|
351 <a name="l00400"></a>00400 |
|
352 <a name="l00401"></a>00401 <span class="comment">// Read F4 as real. Expected value: 0.0.</span> |
|
353 <a name="l00402"></a>00402 valReal = fullSelectQuery.SelectRealL(sql); |
|
354 <a name="l00403"></a>00403 |
|
355 <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> |
|
356 <a name="l00405"></a>00405 err = fullSelectQuery.SelectTextL(sql, valText); |
|
357 <a name="l00406"></a>00406 |
|
358 <a name="l00407"></a>00407 <span class="comment">// Read F4 as text. Big enough buffer. </span> |
|
359 <a name="l00408"></a>00408 TBuf<32> valText2; |
|
360 <a name="l00409"></a>00409 err = fullSelectQuery.SelectTextL(sql, valText2); |
|
361 <a name="l00410"></a>00410 |
|
362 <a name="l00411"></a>00411 <span class="comment">// Read F4 as binary. Expected error: KErrNone. Zero-length 8-bit descriptor.</span> |
|
363 <a name="l00412"></a>00412 err = fullSelectQuery.SelectBinaryL(sql, valBinary); |
|
364 <a name="l00413"></a>00413 |
|
365 <a name="l00414"></a>00414 <span class="comment">// Read F5 as binary. Big enough buffer.</span> |
|
366 <a name="l00415"></a>00415 TBuf8<100> valBinary2; |
|
367 <a name="l00416"></a>00416 err = fullSelectQuery.SelectBinaryL(sql, valBinary2); |
|
368 <a name="l00417"></a>00417 |
|
369 <a name="l00418"></a>00418 <span class="comment">// Text column value, small buffer, reallocation </span> |
|
370 <a name="l00419"></a>00419 HBufC* hbuf = <a class="code" href="class_c_sql_example.html#a8b115210a3fbfa19de5c7f6a0abf3e43">HBufC::NewLC</a>(10); |
|
371 <a name="l00420"></a>00420 TPtr name = hbuf->Des(); |
|
372 <a name="l00421"></a>00421 sql.Copy(KSql4); |
|
373 <a name="l00422"></a>00422 err = fullSelectQuery.SelectTextL(sql, name); |
|
374 <a name="l00423"></a>00423 |
|
375 <a name="l00424"></a>00424 <span class="keywordflow">if</span>(err > 0) |
|
376 <a name="l00425"></a>00425 { |
|
377 <a name="l00426"></a>00426 hbuf = hbuf->ReAllocL(err); |
|
378 <a name="l00427"></a>00427 CleanupStack::Pop(); |
|
379 <a name="l00428"></a>00428 CleanupStack::PushL(hbuf); |
|
380 <a name="l00429"></a>00429 name.Set(hbuf->Des()); |
|
381 <a name="l00430"></a>00430 err = fullSelectQuery.SelectTextL(sql, name); |
|
382 <a name="l00431"></a>00431 |
|
383 <a name="l00432"></a>00432 } |
|
384 <a name="l00433"></a>00433 CleanupStack::PopAndDestroy(); <span class="comment">// hbuf, can't be put as parameter, because may be reallocated</span> |
|
385 <a name="l00434"></a>00434 <span class="comment">//Close database, delete database file.</span> |
|
386 <a name="l00435"></a>00435 db.Close(); |
|
387 <a name="l00436"></a>00436 User::LeaveIfError(RSqlDatabase::Delete(KDatabase)); |
|
388 <a name="l00437"></a>00437 |
|
389 <a name="l00438"></a>00438 } |
|
390 <a name="l00439"></a>00439 |
|
391 <a name="l00447"></a><a class="code" href="class_c_sql_example.html#a12e036a57115aceb1c64545fc9dee052">00447</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a12e036a57115aceb1c64545fc9dee052">CSqlExample::ColumnBinaryStreamL</a>() |
|
392 <a name="l00448"></a>00448 { |
|
393 <a name="l00449"></a>00449 RSqlDatabase db; |
|
394 <a name="l00450"></a>00450 TInt error; |
|
395 <a name="l00451"></a>00451 User::LeaveIfError(db.Create(KDbName)); |
|
396 <a name="l00452"></a>00452 |
|
397 <a name="l00453"></a>00453 <span class="comment">// Create a table</span> |
|
398 <a name="l00454"></a>00454 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSqlStmt1, <span class="stringliteral">"CREATE TABLE A(Fld1 INTEGER, Fld2 BLOB);"</span>); |
|
399 <a name="l00455"></a>00455 |
|
400 <a name="l00456"></a>00456 User::LeaveIfError(error = db.Exec(KSqlStmt1)); |
|
401 <a name="l00457"></a>00457 <span class="keyword">const</span> TInt KDataLen = 100; |
|
402 <a name="l00458"></a>00458 |
|
403 <a name="l00459"></a>00459 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSqlStmt2, <span class="stringliteral">"INSERT INTO A(Fld1, Fld2) VALUES("</span>); |
|
404 <a name="l00460"></a>00460 |
|
405 <a name="l00461"></a>00461 <span class="comment">// Allocate a buffer for the SQL statement.</span> |
|
406 <a name="l00462"></a>00462 HBufC8* buf = HBufC8::New(KSqlStmt2().Length() + KDataLen * 2 + 10); |
|
407 <a name="l00463"></a>00463 |
|
408 <a name="l00464"></a>00464 TPtr8 sql = buf->Des(); |
|
409 <a name="l00465"></a>00465 |
|
410 <a name="l00466"></a>00466 <span class="comment">// Insert row 1</span> |
|
411 <a name="l00467"></a>00467 |
|
412 <a name="l00468"></a>00468 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KHexValStr1, <span class="stringliteral">"7E"</span>); |
|
413 <a name="l00469"></a>00469 sql.Copy(KSqlStmt2); |
|
414 <a name="l00470"></a>00470 |
|
415 <a name="l00471"></a>00471 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString1, <span class="stringliteral">"1, x'"</span>); |
|
416 <a name="l00472"></a>00472 sql.Append(KString1); |
|
417 <a name="l00473"></a>00473 TInt i; |
|
418 <a name="l00474"></a>00474 <span class="keywordflow">for</span>(i=0;i<KDataLen;++i) |
|
419 <a name="l00475"></a>00475 { |
|
420 <a name="l00476"></a>00476 sql.Append(KHexValStr1); |
|
421 <a name="l00477"></a>00477 } |
|
422 <a name="l00478"></a>00478 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString2, <span class="stringliteral">"')"</span>); |
|
423 <a name="l00479"></a>00479 sql.Append(KString2); |
|
424 <a name="l00480"></a>00480 |
|
425 <a name="l00481"></a>00481 User::LeaveIfError(db.Exec(sql)); |
|
426 <a name="l00482"></a>00482 |
|
427 <a name="l00483"></a>00483 <span class="comment">// Insert row 2</span> |
|
428 <a name="l00484"></a>00484 |
|
429 <a name="l00485"></a>00485 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KHexValStr2, <span class="stringliteral">"A3"</span>); |
|
430 <a name="l00486"></a>00486 sql.Copy(KSqlStmt2); |
|
431 <a name="l00487"></a>00487 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString3, <span class="stringliteral">"2, x'"</span>); |
|
432 <a name="l00488"></a>00488 sql.Append(KString3); |
|
433 <a name="l00489"></a>00489 <span class="keywordflow">for</span>(i=0;i<KDataLen;++i) |
|
434 <a name="l00490"></a>00490 { |
|
435 <a name="l00491"></a>00491 sql.Append(KHexValStr2); |
|
436 <a name="l00492"></a>00492 } |
|
437 <a name="l00493"></a>00493 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString4, <span class="stringliteral">"')"</span>); |
|
438 <a name="l00494"></a>00494 sql.Append(KString4); |
|
439 <a name="l00495"></a>00495 |
|
440 <a name="l00496"></a>00496 User::LeaveIfError(db.Exec(sql)); |
|
441 <a name="l00497"></a>00497 |
|
442 <a name="l00498"></a>00498 <span class="comment">// Prepare SELECT SQL statement</span> |
|
443 <a name="l00499"></a>00499 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSqlStmt3, <span class="stringliteral">"SELECT * FROM A"</span>); |
|
444 <a name="l00500"></a>00500 |
|
445 <a name="l00501"></a>00501 RSqlStatement stmt; |
|
446 <a name="l00502"></a>00502 User::LeaveIfError(error = stmt.Prepare(db, KSqlStmt3)); |
|
447 <a name="l00503"></a>00503 |
|
448 <a name="l00504"></a>00504 <span class="comment">// Move on row 1</span> |
|
449 <a name="l00505"></a>00505 User::LeaveIfError(error = stmt.Next()); |
|
450 <a name="l00506"></a>00506 |
|
451 <a name="l00507"></a>00507 <span class="comment">// Read the long binary column using a stream</span> |
|
452 <a name="l00508"></a>00508 RSqlColumnReadStream columnStream; |
|
453 <a name="l00509"></a>00509 error = columnStream.ColumnBinary(stmt, 1); |
|
454 <a name="l00510"></a>00510 |
|
455 <a name="l00511"></a>00511 |
|
456 <a name="l00512"></a>00512 TInt size = stmt.ColumnSize(1); |
|
457 <a name="l00513"></a>00513 TPtr8 colData = buf->Des(); |
|
458 <a name="l00514"></a>00514 TRAP(error, columnStream.ReadL(colData, size)); |
|
459 <a name="l00515"></a>00515 columnStream.Close(); |
|
460 <a name="l00516"></a>00516 |
|
461 <a name="l00517"></a>00517 User::LeaveIfError(stmt.Next()); |
|
462 <a name="l00518"></a>00518 |
|
463 <a name="l00519"></a>00519 <span class="comment">//Read row 2 using ColumnBinary(TInt aColumnIndex, TDes8& aDest).</span> |
|
464 <a name="l00520"></a>00520 error = stmt.ColumnBinary(1, colData); |
|
465 <a name="l00521"></a>00521 |
|
466 <a name="l00522"></a>00522 <span class="comment">//Read row 2 using a stream</span> |
|
467 <a name="l00523"></a>00523 colData.Zero(); |
|
468 <a name="l00524"></a>00524 error = columnStream.ColumnBinary(stmt, 1); |
|
469 <a name="l00525"></a>00525 |
|
470 <a name="l00526"></a>00526 size = stmt.ColumnSize(1); |
|
471 <a name="l00527"></a>00527 TRAP(error, columnStream.ReadL(colData, size)); |
|
472 <a name="l00528"></a>00528 columnStream.Close(); |
|
473 <a name="l00529"></a>00529 |
|
474 <a name="l00530"></a>00530 stmt.Close(); |
|
475 <a name="l00531"></a>00531 |
|
476 <a name="l00532"></a>00532 <span class="keyword">delete</span> buf; |
|
477 <a name="l00533"></a>00533 buf = NULL; |
|
478 <a name="l00534"></a>00534 |
|
479 <a name="l00535"></a>00535 db.Close(); |
|
480 <a name="l00536"></a>00536 |
|
481 <a name="l00537"></a>00537 error = RSqlDatabase::Delete(KDbName); |
|
482 <a name="l00538"></a>00538 |
|
483 <a name="l00539"></a>00539 } |
|
484 <a name="l00540"></a>00540 |
|
485 <a name="l00541"></a>00541 |
|
486 <a name="l00542"></a><a class="code" href="sqlexample_8cpp.html#a689e0bf9aa924a1d7dc108665d44736c">00542</a> LOCAL_C <span class="keywordtype">void</span> MainL() |
|
487 <a name="l00543"></a>00543 { |
|
488 <a name="l00544"></a>00544 <span class="comment">// Create an Active Scheduler to handle asychronous calls</span> |
|
489 <a name="l00545"></a>00545 CActiveScheduler* scheduler = <span class="keyword">new</span> (ELeave) CActiveScheduler; |
|
490 <a name="l00546"></a>00546 CleanupStack::PushL(scheduler); |
|
491 <a name="l00547"></a>00547 CActiveScheduler::Install( scheduler ); |
|
492 <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#a8b115210a3fbfa19de5c7f6a0abf3e43">CSqlExample::NewLC</a>(); |
|
493 <a name="l00549"></a>00549 |
|
494 <a name="l00550"></a>00550 <span class="comment">// Create a non secure database</span> |
|
495 <a name="l00551"></a>00551 app-><a class="code" href="class_c_sql_example.html#af0523fb9c7a711a2c7745e8d2e96faa7">CreateNonSecureDBL</a>(); |
|
496 <a name="l00552"></a>00552 |
|
497 <a name="l00553"></a>00553 <span class="comment">// Create and open a secure database</span> |
|
498 <a name="l00554"></a>00554 app-><a class="code" href="class_c_sql_example.html#a2d2358e96bba71900cedd067fe44192b">CreateAndOpenSecureDBL</a>(); |
|
499 <a name="l00555"></a>00555 |
|
500 <a name="l00556"></a>00556 <span class="comment">// Copy two databases</span> |
|
501 <a name="l00557"></a>00557 app-><a class="code" href="class_c_sql_example.html#a1a6247133748297a2a8877381583e51c">CopyDatabaseL</a>(); |
|
502 <a name="l00558"></a>00558 |
|
503 <a name="l00559"></a>00559 <span class="comment">// Attach two databases</span> |
|
504 <a name="l00560"></a>00560 app-><a class="code" href="class_c_sql_example.html#adf02168d537e9e1650d5f379522a6b2e">AttachDatabasesL</a>(); |
|
505 <a name="l00561"></a>00561 |
|
506 <a name="l00562"></a>00562 <span class="comment">// Simple query and query with paramaters</span> |
|
507 <a name="l00563"></a>00563 app-><a class="code" href="class_c_sql_example.html#a49067abc75f826bfd43be44c07460c7b">DataTypesQueryL</a>(); |
|
508 <a name="l00564"></a>00564 |
|
509 <a name="l00565"></a>00565 <span class="comment">//Prepares and executes a query with a large parameter</span> |
|
510 <a name="l00566"></a>00566 <span class="comment">// writing that parameter using streaming (RParamWriteStream)</span> |
|
511 <a name="l00567"></a>00567 app-><a class="code" href="class_c_sql_example.html#a7fac459ccd95278c1af4eb50e5453812">ScalarFullSelectL</a>(); |
|
512 <a name="l00568"></a>00568 |
|
513 <a name="l00569"></a>00569 <span class="comment">// Prepare and execute a query which returns data,</span> |
|
514 <a name="l00570"></a>00570 <span class="comment">// and read that data using streaming (RColumnReadStream)</span> |
|
515 <a name="l00571"></a>00571 app-><a class="code" href="class_c_sql_example.html#a12e036a57115aceb1c64545fc9dee052">ColumnBinaryStreamL</a>(); |
|
516 <a name="l00572"></a>00572 |
|
517 <a name="l00573"></a>00573 CleanupStack::PopAndDestroy(2); <span class="comment">//app, scheduler</span> |
|
518 <a name="l00574"></a>00574 |
|
519 <a name="l00575"></a>00575 } |
|
520 <a name="l00576"></a>00576 |
|
521 <a name="l00577"></a><a class="code" href="sqlexample_8cpp.html#a0f358e9c4355138f629b8c4f37310295">00577</a> GLDEF_C TInt E32Main() |
|
522 <a name="l00578"></a>00578 { |
|
523 <a name="l00579"></a>00579 __UHEAP_MARK; |
|
524 <a name="l00580"></a>00580 CTrapCleanup* cleanup = CTrapCleanup::New(); |
|
525 <a name="l00581"></a>00581 <span class="keywordflow">if</span>(cleanup == NULL) |
|
526 <a name="l00582"></a>00582 { |
|
527 <a name="l00583"></a>00583 <span class="keywordflow">return</span> KErrNoMemory; |
|
528 <a name="l00584"></a>00584 } |
|
529 <a name="l00585"></a>00585 TRAPD(err, MainL()); |
|
530 <a name="l00586"></a>00586 <span class="keywordflow">if</span>(err != KErrNone) |
|
531 <a name="l00587"></a>00587 { |
|
532 <a name="l00588"></a>00588 User::Panic(_L(<span class="stringliteral">"Failed to complete"</span>),err); |
|
533 <a name="l00589"></a>00589 } |
|
534 <a name="l00590"></a>00590 |
|
535 <a name="l00591"></a>00591 <span class="keyword">delete</span> cleanup; |
|
536 <a name="l00592"></a>00592 __UHEAP_MARKEND; |
|
537 <a name="l00593"></a>00593 <span class="keywordflow">return</span> KErrNone; |
|
538 <a name="l00594"></a>00594 } |
|
539 </pre></div></div> |
|
540 <hr size="1"/><address style="text-align: right;"><small>Generated by |
|
541 <a href="http://www.doxygen.org/index.html"> |
|
542 <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.2 </small></address> |
|
543 </body> |
|
544 </html> |