1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
2 <html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
3 <title>Light Media Scanner: src/lib/lightmediascanner_db_common.c Source File</title>
4 <link href="doxygen.css" rel="stylesheet" type="text/css">
5 <link href="tabs.css" rel="stylesheet" type="text/css">
7 <!-- Generated by Doxygen 1.5.2 -->
10 <li><a href="index.html"><span>Main Page</span></a></li>
11 <li><a href="modules.html"><span>Modules</span></a></li>
12 <li><a href="classes.html"><span>Data Structures</span></a></li>
13 <li class="current"><a href="files.html"><span>Files</span></a></li>
18 <li><a href="files.html"><span>File List</span></a></li>
19 <li><a href="globals.html"><span>Globals</span></a></li>
22 <h1>src/lib/lightmediascanner_db_common.c</h1><a href="lightmediascanner__db__common_8c.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="preprocessor">#include "<a class="code" href="lightmediascanner__db__private_8h.html">lightmediascanner_db_private.h</a>"</span>
23 <a name="l00002"></a>00002 <span class="preprocessor">#include <stdlib.h></span>
24 <a name="l00003"></a>00003 <span class="preprocessor">#include <stdio.h></span>
25 <a name="l00004"></a>00004 <span class="preprocessor">#include <string.h></span>
26 <a name="l00005"></a>00005
27 <a name="l00006"></a>00006 <span class="preprocessor">#if SQLITE_VERSION_NUMBER < 3003009</span>
28 <a name="l00007"></a>00007 <span class="preprocessor"></span><span class="keywordtype">int</span>
29 <a name="l00008"></a><a class="code" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405">00008</a> <a class="code" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405">sqlite3_prepare_v2</a>(sqlite3 *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *sql, <span class="keywordtype">int</span> len, sqlite3_stmt **stmt, <span class="keyword">const</span> <span class="keywordtype">char</span> **tail)
30 <a name="l00009"></a>00009 {
31 <a name="l00010"></a>00010 <span class="keywordflow">return</span> sqlite3_prepare(db, sql, len, stmt, tail);
32 <a name="l00011"></a>00011 }
33 <a name="l00012"></a>00012 <span class="preprocessor">#endif </span><span class="comment">/* SQLITE_VERSION_NUMBER < 3003009 */</span>
34 <a name="l00013"></a>00013
35 <a name="l00014"></a>00014 <span class="preprocessor">#if SQLITE_VERSION_NUMBER < 3003007</span>
36 <a name="l00015"></a>00015 <span class="preprocessor"></span><span class="keywordtype">int</span>
37 <a name="l00016"></a><a class="code" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00">00016</a> <a class="code" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00">sqlite3_clear_bindings</a>(sqlite3_stmt *stmt)
38 <a name="l00017"></a>00017 {
39 <a name="l00018"></a>00018 <span class="keywordtype">int</span> i, last;
40 <a name="l00019"></a>00019 <span class="keywordtype">int</span> rc;
41 <a name="l00020"></a>00020
42 <a name="l00021"></a>00021 rc = SQLITE_OK;
43 <a name="l00022"></a>00022 last = sqlite3_bind_parameter_count(stmt);
44 <a name="l00023"></a>00023 <span class="keywordflow">for</span>(i = 1; rc == SQLITE_OK && i <= last; i++) {
45 <a name="l00024"></a>00024 rc = sqlite3_bind_null(stmt, i);
46 <a name="l00025"></a>00025 }
47 <a name="l00026"></a>00026 <span class="keywordflow">return</span> rc;
48 <a name="l00027"></a>00027 }
49 <a name="l00028"></a>00028 <span class="preprocessor">#endif </span><span class="comment">/* SQLITE_VERSION_NUMBER < 3003007 */</span>
50 <a name="l00029"></a>00029
51 <a name="l00030"></a>00030 <span class="preprocessor">#if SQLITE_VERSION_NUMBER < 3003008</span>
52 <a name="l00031"></a>00031 <span class="preprocessor"></span><span class="comment">/* Until 3.3.8 it doesn't support CREATE TRIGGER IF NOT EXISTS, so</span>
53 <a name="l00032"></a>00032 <span class="comment"> * just ignore errors :-(</span>
54 <a name="l00033"></a>00033 <span class="comment"> */</span>
55 <a name="l00034"></a>00034 <span class="keywordtype">int</span>
56 <a name="l00035"></a><a class="code" href="lightmediascanner__db__common_8c.html#822cae681398710b63c9af149fdacedb">00035</a> <a class="code" href="lightmediascanner__db__common_8c.html#822cae681398710b63c9af149fdacedb">lms_db_create_trigger_if_not_exists</a>(sqlite3 *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *sql)
57 <a name="l00036"></a>00036 {
58 <a name="l00037"></a>00037 <span class="keywordtype">char</span> *errmsg, *query;
59 <a name="l00038"></a>00038 <span class="keywordtype">int</span> r, sql_len, prefix_len;
60 <a name="l00039"></a>00039
61 <a name="l00040"></a>00040 prefix_len = <span class="keyword">sizeof</span>(<span class="stringliteral">"CREATE TRIGGER "</span>) - 1;
62 <a name="l00041"></a>00041 sql_len = strlen(sql);
63 <a name="l00042"></a>00042 query = malloc((prefix_len + sql_len + 1) * <span class="keyword">sizeof</span>(<span class="keywordtype">char</span>));
64 <a name="l00043"></a>00043 <span class="keywordflow">if</span> (!query)
65 <a name="l00044"></a>00044 <span class="keywordflow">return</span> -1;
66 <a name="l00045"></a>00045
67 <a name="l00046"></a>00046 memcpy(query, <span class="stringliteral">"CREATE TRIGGER "</span>, prefix_len);
68 <a name="l00047"></a>00047 memcpy(query + prefix_len, sql, sql_len + 1);
69 <a name="l00048"></a>00048 r = sqlite3_exec(db, query, NULL, NULL, &errmsg);
70 <a name="l00049"></a>00049 free(query);
71 <a name="l00050"></a>00050 <span class="keywordflow">if</span> (r != SQLITE_OK)
72 <a name="l00051"></a>00051 sqlite3_free(errmsg);
73 <a name="l00052"></a>00052 <span class="keywordflow">return</span> 0;
74 <a name="l00053"></a>00053 }
75 <a name="l00054"></a>00054 <span class="preprocessor">#else </span><span class="comment">/* SQLITE_VERSION_NUMBER < 3003008 */</span>
76 <a name="l00055"></a>00055 <span class="keywordtype">int</span>
77 <a name="l00056"></a>00056 <a class="code" href="lightmediascanner__db__common_8c.html#822cae681398710b63c9af149fdacedb">lms_db_create_trigger_if_not_exists</a>(sqlite3 *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *sql)
78 <a name="l00057"></a>00057 {
79 <a name="l00058"></a>00058 <span class="keywordtype">char</span> *errmsg, *query;
80 <a name="l00059"></a>00059 <span class="keywordtype">int</span> r, sql_len, prefix_len;
81 <a name="l00060"></a>00060
82 <a name="l00061"></a>00061 prefix_len = <span class="keyword">sizeof</span>(<span class="stringliteral">"CREATE TRIGGER IF NOT EXISTS "</span>) - 1;
83 <a name="l00062"></a>00062 sql_len = strlen(sql);
84 <a name="l00063"></a>00063 query = malloc((prefix_len + sql_len + 1) * <span class="keyword">sizeof</span>(<span class="keywordtype">char</span>));
85 <a name="l00064"></a>00064 <span class="keywordflow">if</span> (!query)
86 <a name="l00065"></a>00065 <span class="keywordflow">return</span> -1;
87 <a name="l00066"></a>00066
88 <a name="l00067"></a>00067 memcpy(query, <span class="stringliteral">"CREATE TRIGGER IF NOT EXISTS "</span>, prefix_len);
89 <a name="l00068"></a>00068 memcpy(query + prefix_len, sql, sql_len + 1);
90 <a name="l00069"></a>00069 r = sqlite3_exec(db, query, NULL, NULL, &errmsg);
91 <a name="l00070"></a>00070 free(query);
92 <a name="l00071"></a>00071 <span class="keywordflow">if</span> (r != SQLITE_OK) {
93 <a name="l00072"></a>00072 fprintf(stderr, <span class="stringliteral">"ERROR: could not create trigger: %s\n"</span>, errmsg);
94 <a name="l00073"></a>00073 sqlite3_free(errmsg);
95 <a name="l00074"></a>00074 <span class="keywordflow">return</span> -2;
96 <a name="l00075"></a>00075 }
97 <a name="l00076"></a>00076 <span class="keywordflow">return</span> 0;
98 <a name="l00077"></a>00077 }
99 <a name="l00078"></a>00078 <span class="preprocessor">#endif </span><span class="comment">/* SQLITE_VERSION_NUMBER < 3003008 */</span>
100 <a name="l00079"></a>00079
101 <a name="l00080"></a>00080 sqlite3_stmt *
102 <a name="l00081"></a><a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">00081</a> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(sqlite3 *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *sql)
103 <a name="l00082"></a>00082 {
104 <a name="l00083"></a>00083 sqlite3_stmt *stmt;
105 <a name="l00084"></a>00084
106 <a name="l00085"></a>00085 <span class="keywordflow">if</span> (<a class="code" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405">sqlite3_prepare_v2</a>(db, sql, -1, &stmt, NULL) != SQLITE_OK)
107 <a name="l00086"></a>00086 fprintf(stderr, <span class="stringliteral">"ERROR: could not prepare \"%s\": %s\n"</span>, sql,
108 <a name="l00087"></a>00087 sqlite3_errmsg(db));
109 <a name="l00088"></a>00088
110 <a name="l00089"></a>00089 <span class="keywordflow">return</span> stmt;
111 <a name="l00090"></a>00090 }
112 <a name="l00091"></a>00091
113 <a name="l00092"></a>00092 <span class="keywordtype">int</span>
114 <a name="l00093"></a><a class="code" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5">00093</a> <a class="code" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5">lms_db_finalize_stmt</a>(sqlite3_stmt *stmt, <span class="keyword">const</span> <span class="keywordtype">char</span> *name)
115 <a name="l00094"></a>00094 {
116 <a name="l00095"></a>00095 <span class="keywordtype">int</span> r;
117 <a name="l00096"></a>00096
118 <a name="l00097"></a>00097 r = sqlite3_finalize(stmt);
119 <a name="l00098"></a>00098 <span class="keywordflow">if</span> (r != SQLITE_OK) {
120 <a name="l00099"></a>00099 fprintf(stderr, <span class="stringliteral">"ERROR: could not finalize %s statement: #%d\n"</span>,
121 <a name="l00100"></a>00100 name, r);
122 <a name="l00101"></a>00101 <span class="keywordflow">return</span> -1;
123 <a name="l00102"></a>00102 }
124 <a name="l00103"></a>00103
125 <a name="l00104"></a>00104 <span class="keywordflow">return</span> 0;
126 <a name="l00105"></a>00105 }
127 <a name="l00106"></a>00106
128 <a name="l00107"></a>00107 <span class="keywordtype">int</span>
129 <a name="l00108"></a><a class="code" href="lightmediascanner__db__private_8h.html#ee78f418f0f3c9ead3023b1453c63556">00108</a> <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(sqlite3_stmt *stmt)
130 <a name="l00109"></a>00109 {
131 <a name="l00110"></a>00110 <span class="keywordtype">int</span> r, ret;
132 <a name="l00111"></a>00111
133 <a name="l00112"></a>00112 ret = r = sqlite3_reset(stmt);
134 <a name="l00113"></a>00113 <span class="keywordflow">if</span> (r != SQLITE_OK)
135 <a name="l00114"></a>00114 fprintf(stderr, <span class="stringliteral">"ERROR: could not reset SQL statement: #%d\n"</span>, r);
136 <a name="l00115"></a>00115
137 <a name="l00116"></a>00116 r = <a class="code" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00">sqlite3_clear_bindings</a>(stmt);
138 <a name="l00117"></a>00117 ret += r;
139 <a name="l00118"></a>00118 <span class="keywordflow">if</span> (r != SQLITE_OK)
140 <a name="l00119"></a>00119 fprintf(stderr, <span class="stringliteral">"ERROR: could not clear SQL: #%d\n"</span>, r);
141 <a name="l00120"></a>00120
142 <a name="l00121"></a>00121 <span class="keywordflow">return</span> ret;
143 <a name="l00122"></a>00122 }
144 <a name="l00123"></a>00123
145 <a name="l00124"></a>00124 <span class="keywordtype">int</span>
146 <a name="l00125"></a><a class="code" href="lightmediascanner__db__private_8h.html#14d56e02624ad6130bc59ae9bb950ac3">00125</a> <a class="code" href="lightmediascanner__db__common_8c.html#88c461ae88da3eb47987c5a0b15c5888">lms_db_bind_text</a>(sqlite3_stmt *stmt, <span class="keywordtype">int</span> col, <span class="keyword">const</span> <span class="keywordtype">char</span> *text, <span class="keywordtype">int</span> len)
147 <a name="l00126"></a>00126 {
148 <a name="l00127"></a>00127 <span class="keywordtype">int</span> r;
149 <a name="l00128"></a>00128
150 <a name="l00129"></a>00129 <span class="keywordflow">if</span> (text)
151 <a name="l00130"></a>00130 r = sqlite3_bind_text(stmt, col, text, len, SQLITE_STATIC);
152 <a name="l00131"></a>00131 <span class="keywordflow">else</span>
153 <a name="l00132"></a>00132 r = sqlite3_bind_null(stmt, col);
154 <a name="l00133"></a>00133
155 <a name="l00134"></a>00134 <span class="keywordflow">if</span> (r == SQLITE_OK)
156 <a name="l00135"></a>00135 <span class="keywordflow">return</span> 0;
157 <a name="l00136"></a>00136 <span class="keywordflow">else</span> {
158 <a name="l00137"></a>00137 sqlite3 *db;
159 <a name="l00138"></a>00138 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
160 <a name="l00139"></a>00139
161 <a name="l00140"></a>00140 db = sqlite3_db_handle(stmt);
162 <a name="l00141"></a>00141 err = sqlite3_errmsg(db);
163 <a name="l00142"></a>00142 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
164 <a name="l00143"></a>00143 <span class="keywordflow">return</span> -col;
165 <a name="l00144"></a>00144 }
166 <a name="l00145"></a>00145 }
167 <a name="l00146"></a>00146
168 <a name="l00147"></a>00147 <span class="keywordtype">int</span>
169 <a name="l00148"></a><a class="code" href="lightmediascanner__db__private_8h.html#7fd514b582578c18a25cdbf6c561243c">00148</a> <a class="code" href="lightmediascanner__db__common_8c.html#fee26461dbd6c89c82794c94aaeeaef6">lms_db_bind_blob</a>(sqlite3_stmt *stmt, <span class="keywordtype">int</span> col, <span class="keyword">const</span> <span class="keywordtype">void</span> *blob, <span class="keywordtype">int</span> len)
170 <a name="l00149"></a>00149 {
171 <a name="l00150"></a>00150 <span class="keywordtype">int</span> r;
172 <a name="l00151"></a>00151
173 <a name="l00152"></a>00152 <span class="keywordflow">if</span> (blob)
174 <a name="l00153"></a>00153 r = sqlite3_bind_blob(stmt, col, blob, len, SQLITE_STATIC);
175 <a name="l00154"></a>00154 <span class="keywordflow">else</span>
176 <a name="l00155"></a>00155 r = sqlite3_bind_null(stmt, col);
177 <a name="l00156"></a>00156
178 <a name="l00157"></a>00157 <span class="keywordflow">if</span> (r == SQLITE_OK)
179 <a name="l00158"></a>00158 <span class="keywordflow">return</span> 0;
180 <a name="l00159"></a>00159 <span class="keywordflow">else</span> {
181 <a name="l00160"></a>00160 sqlite3 *db;
182 <a name="l00161"></a>00161 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
183 <a name="l00162"></a>00162
184 <a name="l00163"></a>00163 db = sqlite3_db_handle(stmt);
185 <a name="l00164"></a>00164 err = sqlite3_errmsg(db);
186 <a name="l00165"></a>00165 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
187 <a name="l00166"></a>00166 <span class="keywordflow">return</span> -col;
188 <a name="l00167"></a>00167 }
189 <a name="l00168"></a>00168 }
190 <a name="l00169"></a>00169
191 <a name="l00170"></a>00170 <span class="keywordtype">int</span>
192 <a name="l00171"></a><a class="code" href="lightmediascanner__db__private_8h.html#bbb18d7cc44f7e363c0f240849d72c31">00171</a> <a class="code" href="lightmediascanner__db__common_8c.html#f2fe78bc45dc33d843313a846db5ce7c">lms_db_bind_int64</a>(sqlite3_stmt *stmt, <span class="keywordtype">int</span> col, int64_t value)
193 <a name="l00172"></a>00172 {
194 <a name="l00173"></a>00173 <span class="keywordtype">int</span> r;
195 <a name="l00174"></a>00174
196 <a name="l00175"></a>00175 r = sqlite3_bind_int64(stmt, col, value);
197 <a name="l00176"></a>00176 <span class="keywordflow">if</span> (r == SQLITE_OK)
198 <a name="l00177"></a>00177 <span class="keywordflow">return</span> 0;
199 <a name="l00178"></a>00178 <span class="keywordflow">else</span> {
200 <a name="l00179"></a>00179 sqlite3 *db;
201 <a name="l00180"></a>00180 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
202 <a name="l00181"></a>00181
203 <a name="l00182"></a>00182 db = sqlite3_db_handle(stmt);
204 <a name="l00183"></a>00183 err = sqlite3_errmsg(db);
205 <a name="l00184"></a>00184 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
206 <a name="l00185"></a>00185 <span class="keywordflow">return</span> -col;
207 <a name="l00186"></a>00186 }
208 <a name="l00187"></a>00187 }
209 <a name="l00188"></a>00188
210 <a name="l00189"></a>00189 <span class="keywordtype">int</span>
211 <a name="l00190"></a><a class="code" href="lightmediascanner__db__private_8h.html#cd7006f0271b9a47937dc2d2ae5480fe">00190</a> <a class="code" href="lightmediascanner__db__common_8c.html#2a0a5d3a27fdee8508b2b0cc59979417">lms_db_bind_int64_or_null</a>(sqlite3_stmt *stmt, <span class="keywordtype">int</span> col, int64_t *p_value)
212 <a name="l00191"></a>00191 {
213 <a name="l00192"></a>00192 <span class="keywordtype">int</span> r;
214 <a name="l00193"></a>00193
215 <a name="l00194"></a>00194 <span class="keywordflow">if</span> (p_value)
216 <a name="l00195"></a>00195 r = sqlite3_bind_int64(stmt, col, *p_value);
217 <a name="l00196"></a>00196 <span class="keywordflow">else</span>
218 <a name="l00197"></a>00197 r = sqlite3_bind_null(stmt, col);
219 <a name="l00198"></a>00198 <span class="keywordflow">if</span> (r == SQLITE_OK)
220 <a name="l00199"></a>00199 <span class="keywordflow">return</span> 0;
221 <a name="l00200"></a>00200 <span class="keywordflow">else</span> {
222 <a name="l00201"></a>00201 sqlite3 *db;
223 <a name="l00202"></a>00202 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
224 <a name="l00203"></a>00203
225 <a name="l00204"></a>00204 db = sqlite3_db_handle(stmt);
226 <a name="l00205"></a>00205 err = sqlite3_errmsg(db);
227 <a name="l00206"></a>00206 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
228 <a name="l00207"></a>00207 <span class="keywordflow">return</span> -col;
229 <a name="l00208"></a>00208 }
230 <a name="l00209"></a>00209 }
231 <a name="l00210"></a>00210
232 <a name="l00211"></a>00211 <span class="keywordtype">int</span>
233 <a name="l00212"></a><a class="code" href="lightmediascanner__db__private_8h.html#37815f859116b46089bea4ba84bb23d2">00212</a> <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(sqlite3_stmt *stmt, <span class="keywordtype">int</span> col, <span class="keywordtype">int</span> value)
234 <a name="l00213"></a>00213 {
235 <a name="l00214"></a>00214 <span class="keywordtype">int</span> r;
236 <a name="l00215"></a>00215
237 <a name="l00216"></a>00216 r = sqlite3_bind_int(stmt, col, value);
238 <a name="l00217"></a>00217 <span class="keywordflow">if</span> (r == SQLITE_OK)
239 <a name="l00218"></a>00218 <span class="keywordflow">return</span> 0;
240 <a name="l00219"></a>00219 <span class="keywordflow">else</span> {
241 <a name="l00220"></a>00220 sqlite3 *db;
242 <a name="l00221"></a>00221 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
243 <a name="l00222"></a>00222
244 <a name="l00223"></a>00223 db = sqlite3_db_handle(stmt);
245 <a name="l00224"></a>00224 err = sqlite3_errmsg(db);
246 <a name="l00225"></a>00225 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
247 <a name="l00226"></a>00226 <span class="keywordflow">return</span> -col;
248 <a name="l00227"></a>00227 }
249 <a name="l00228"></a>00228 }
250 <a name="l00229"></a>00229
251 <a name="l00230"></a>00230 <span class="keywordtype">int</span>
252 <a name="l00231"></a><a class="code" href="lightmediascanner__db__private_8h.html#9e78297037179998924354e73ca69349">00231</a> <a class="code" href="lightmediascanner__db__common_8c.html#4ae660a876f1e362d1ab2f8c68bdef3f">lms_db_bind_double</a>(sqlite3_stmt *stmt, <span class="keywordtype">int</span> col, <span class="keywordtype">double</span> value)
253 <a name="l00232"></a>00232 {
254 <a name="l00233"></a>00233 <span class="keywordtype">int</span> r;
255 <a name="l00234"></a>00234
256 <a name="l00235"></a>00235 r = sqlite3_bind_double(stmt, col, value);
257 <a name="l00236"></a>00236 <span class="keywordflow">if</span> (r == SQLITE_OK)
258 <a name="l00237"></a>00237 <span class="keywordflow">return</span> 0;
259 <a name="l00238"></a>00238 <span class="keywordflow">else</span> {
260 <a name="l00239"></a>00239 sqlite3 *db;
261 <a name="l00240"></a>00240 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
262 <a name="l00241"></a>00241
263 <a name="l00242"></a>00242 db = sqlite3_db_handle(stmt);
264 <a name="l00243"></a>00243 err = sqlite3_errmsg(db);
265 <a name="l00244"></a>00244 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
266 <a name="l00245"></a>00245 <span class="keywordflow">return</span> -col;
267 <a name="l00246"></a>00246 }
268 <a name="l00247"></a>00247 }
269 <a name="l00248"></a>00248
270 <a name="l00249"></a>00249 <span class="keywordtype">int</span>
271 <a name="l00250"></a><a class="code" href="lightmediascanner__db__common_8c.html#eba3215ee5981a73e9d0fed0a7e079cd">00250</a> <a class="code" href="lightmediascanner__db__common_8c.html#eba3215ee5981a73e9d0fed0a7e079cd">lms_db_table_version_get</a>(sqlite3 *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *table)
272 <a name="l00251"></a>00251 {
273 <a name="l00252"></a>00252 <span class="keywordtype">int</span> r, version;
274 <a name="l00253"></a>00253 sqlite3_stmt *stmt;
275 <a name="l00254"></a>00254
276 <a name="l00255"></a>00255 stmt = <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
277 <a name="l00256"></a>00256 <span class="stringliteral">"SELECT version FROM lms_internal WHERE tab = ?"</span>);
278 <a name="l00257"></a>00257 <span class="keywordflow">if</span> (!stmt)
279 <a name="l00258"></a>00258 <span class="keywordflow">return</span> -1;
280 <a name="l00259"></a>00259
281 <a name="l00260"></a>00260 <span class="keywordflow">if</span> (<a class="code" href="lightmediascanner__db__common_8c.html#88c461ae88da3eb47987c5a0b15c5888">lms_db_bind_text</a>(stmt, 1, table, -1) != 0) {
282 <a name="l00261"></a>00261 version = -1;
283 <a name="l00262"></a>00262 <span class="keywordflow">goto</span> done;
284 <a name="l00263"></a>00263 }
285 <a name="l00264"></a>00264
286 <a name="l00265"></a>00265 r = sqlite3_step(stmt);
287 <a name="l00266"></a>00266 <span class="keywordflow">if</span> (r == SQLITE_DONE)
288 <a name="l00267"></a>00267 version = 0;
289 <a name="l00268"></a>00268 <span class="keywordflow">else</span> <span class="keywordflow">if</span> (r == SQLITE_ROW)
290 <a name="l00269"></a>00269 version = sqlite3_column_int(stmt, 1);
291 <a name="l00270"></a>00270 <span class="keywordflow">else</span> {
292 <a name="l00271"></a>00271 version = -1;
293 <a name="l00272"></a>00272 fprintf(stderr, <span class="stringliteral">"ERROR: could not get table '%s' version: %s\n"</span>,
294 <a name="l00273"></a>00273 table, sqlite3_errmsg(db));
295 <a name="l00274"></a>00274 }
296 <a name="l00275"></a>00275
297 <a name="l00276"></a>00276 done:
298 <a name="l00277"></a>00277 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
299 <a name="l00278"></a>00278 <a class="code" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5">lms_db_finalize_stmt</a>(stmt, <span class="stringliteral">"table_version_get"</span>);
300 <a name="l00279"></a>00279
301 <a name="l00280"></a>00280 <span class="keywordflow">return</span> version;
302 <a name="l00281"></a>00281 }
303 <a name="l00282"></a>00282
304 <a name="l00283"></a>00283 <span class="keywordtype">int</span>
305 <a name="l00284"></a><a class="code" href="lightmediascanner__db__common_8c.html#46e6e318ea9bb4a7ffdfe40c842da4e7">00284</a> <a class="code" href="lightmediascanner__db__common_8c.html#46e6e318ea9bb4a7ffdfe40c842da4e7">lms_db_table_version_set</a>(sqlite3 *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *table, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> version)
306 <a name="l00285"></a>00285 {
307 <a name="l00286"></a>00286 <span class="keywordtype">int</span> r, ret;
308 <a name="l00287"></a>00287 sqlite3_stmt *stmt;
309 <a name="l00288"></a>00288
310 <a name="l00289"></a>00289 stmt = <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
311 <a name="l00290"></a>00290 <span class="stringliteral">"INSERT OR REPLACE INTO lms_internal (tab, version) VALUES (?, ?)"</span>);
312 <a name="l00291"></a>00291 <span class="keywordflow">if</span> (!stmt)
313 <a name="l00292"></a>00292 <span class="keywordflow">return</span> -1;
314 <a name="l00293"></a>00293
315 <a name="l00294"></a>00294 ret = <a class="code" href="lightmediascanner__db__common_8c.html#88c461ae88da3eb47987c5a0b15c5888">lms_db_bind_text</a>(stmt, 1, table, -1);
316 <a name="l00295"></a>00295 <span class="keywordflow">if</span> (ret != 0)
317 <a name="l00296"></a>00296 <span class="keywordflow">goto</span> done;
318 <a name="l00297"></a>00297
319 <a name="l00298"></a>00298 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 2, version);
320 <a name="l00299"></a>00299 <span class="keywordflow">if</span> (ret != 0)
321 <a name="l00300"></a>00300 <span class="keywordflow">goto</span> done;
322 <a name="l00301"></a>00301
323 <a name="l00302"></a>00302 r = sqlite3_step(stmt);
324 <a name="l00303"></a>00303 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
325 <a name="l00304"></a>00304 ret = -1;
326 <a name="l00305"></a>00305 fprintf(stderr, <span class="stringliteral">"ERROR: could not set table '%s' version: %s\n"</span>,
327 <a name="l00306"></a>00306 table, sqlite3_errmsg(db));
328 <a name="l00307"></a>00307 }
329 <a name="l00308"></a>00308
330 <a name="l00309"></a>00309 done:
331 <a name="l00310"></a>00310 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
332 <a name="l00311"></a>00311 <a class="code" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5">lms_db_finalize_stmt</a>(stmt, <span class="stringliteral">"table_version_set"</span>);
333 <a name="l00312"></a>00312
334 <a name="l00313"></a>00313 <span class="keywordflow">return</span> ret;
335 <a name="l00314"></a>00314 }
336 <a name="l00315"></a>00315
337 <a name="l00316"></a>00316 <span class="keywordtype">int</span>
338 <a name="l00317"></a><a class="code" href="lightmediascanner__db__common_8c.html#9bca88ae79959baff3accee8ce10b558">00317</a> <a class="code" href="lightmediascanner__db__common_8c.html#9bca88ae79959baff3accee8ce10b558">lms_db_table_update</a>(sqlite3 *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *table, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> current_version, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> last_version, <span class="keyword">const</span> <a class="code" href="lightmediascanner__db__private_8h.html#7964337689117d7dc6fb1822378b5848">lms_db_table_updater_t</a> *updaters)
339 <a name="l00318"></a>00318 {
340 <a name="l00319"></a>00319 <span class="keywordflow">if</span> (current_version == last_version)
341 <a name="l00320"></a>00320 <span class="keywordflow">return</span> 0;
342 <a name="l00321"></a>00321 <span class="keywordflow">else</span> <span class="keywordflow">if</span> (current_version > last_version) {
343 <a name="l00322"></a>00322 fprintf(stderr,
344 <a name="l00323"></a>00323 <span class="stringliteral">"WARNING: current version (%d) of table '%s' is greater than "</span>
345 <a name="l00324"></a>00324 <span class="stringliteral">"last known version (%d), no updates will be made.\n"</span>,
346 <a name="l00325"></a>00325 current_version, table, last_version);
347 <a name="l00326"></a>00326 <span class="keywordflow">return</span> 0;
348 <a name="l00327"></a>00327 }
349 <a name="l00328"></a>00328
350 <a name="l00329"></a>00329 <span class="keywordflow">for</span> (; current_version < last_version; current_version++) {
351 <a name="l00330"></a>00330 <span class="keywordtype">int</span> r, is_last_run;
352 <a name="l00331"></a>00331
353 <a name="l00332"></a>00332 is_last_run = current_version == (last_version - 1);
354 <a name="l00333"></a>00333 r = updaters[current_version](db, table, current_version, is_last_run);
355 <a name="l00334"></a>00334 <span class="keywordflow">if</span> (r != 0) {
356 <a name="l00335"></a>00335 fprintf(stderr,
357 <a name="l00336"></a>00336 <span class="stringliteral">"ERROR: could not update table '%s' from version %d->%d\n"</span>,
358 <a name="l00337"></a>00337 table, current_version, current_version + 1);
359 <a name="l00338"></a>00338 <span class="keywordflow">return</span> r;
360 <a name="l00339"></a>00339 }
361 <a name="l00340"></a>00340 <a class="code" href="lightmediascanner__db__common_8c.html#46e6e318ea9bb4a7ffdfe40c842da4e7">lms_db_table_version_set</a>(db, table, current_version + 1);
362 <a name="l00341"></a>00341 }
363 <a name="l00342"></a>00342
364 <a name="l00343"></a>00343 <span class="keywordflow">return</span> 0;
365 <a name="l00344"></a>00344 }
366 <a name="l00345"></a>00345
367 <a name="l00346"></a>00346 <span class="keywordtype">int</span>
368 <a name="l00347"></a><a class="code" href="lightmediascanner__db__common_8c.html#86b766535f9dc7895da7d0f606201700">00347</a> <a class="code" href="lightmediascanner__db__common_8c.html#86b766535f9dc7895da7d0f606201700">lms_db_table_update_if_required</a>(sqlite3 *db, <span class="keyword">const</span> <span class="keywordtype">char</span> *table, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> last_version, <a class="code" href="lightmediascanner__db__private_8h.html#7964337689117d7dc6fb1822378b5848">lms_db_table_updater_t</a> *updaters)
369 <a name="l00348"></a>00348 {
370 <a name="l00349"></a>00349 <span class="keywordtype">int</span> current_version;
371 <a name="l00350"></a>00350
372 <a name="l00351"></a>00351 current_version = <a class="code" href="lightmediascanner__db__common_8c.html#eba3215ee5981a73e9d0fed0a7e079cd">lms_db_table_version_get</a>(db, table);
373 <a name="l00352"></a>00352 <span class="keywordflow">if</span> (current_version < 0)
374 <a name="l00353"></a>00353 <span class="keywordflow">return</span> -1;
375 <a name="l00354"></a>00354 <span class="keywordflow">else</span>
376 <a name="l00355"></a>00355 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#9bca88ae79959baff3accee8ce10b558">lms_db_table_update</a>(db, table, current_version, last_version,
377 <a name="l00356"></a>00356 updaters);
378 <a name="l00357"></a>00357 }
379 <a name="l00358"></a>00358
380 <a name="l00359"></a>00359 <span class="keyword">static</span> <span class="keywordtype">int</span>
381 <a name="l00360"></a>00360 lms_db_cache_find_db(<span class="keyword">const</span> <span class="keyword">struct</span> <a class="code" href="structlms__db__cache.html">lms_db_cache</a> *cache, <span class="keyword">const</span> sqlite3 *db)
382 <a name="l00361"></a>00361 {
383 <a name="l00362"></a>00362 <span class="keywordtype">int</span> i;
384 <a name="l00363"></a>00363
385 <a name="l00364"></a>00364 <span class="keywordflow">for</span> (i = 0; i < cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a>; i++)
386 <a name="l00365"></a>00365 <span class="keywordflow">if</span> (cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a>[i].<a class="code" href="structlms__db__cache__entry.html#01aadf6d9a8161696019d39566b15760">db</a> == db)
387 <a name="l00366"></a>00366 <span class="keywordflow">return</span> i;
388 <a name="l00367"></a>00367
389 <a name="l00368"></a>00368 <span class="keywordflow">return</span> -1;
390 <a name="l00369"></a>00369 }
391 <a name="l00370"></a>00370
392 <a name="l00371"></a>00371 <span class="keyword">static</span> <span class="keywordtype">int</span>
393 <a name="l00372"></a>00372 lms_db_cache_resize(<span class="keyword">struct</span> <a class="code" href="structlms__db__cache.html">lms_db_cache</a> *cache, <span class="keywordtype">int</span> new_size)
394 <a name="l00373"></a>00373 {
395 <a name="l00374"></a>00374 cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> = new_size;
396 <a name="l00375"></a>00375 cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a> = realloc(cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a>,
397 <a name="l00376"></a>00376 cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> * <span class="keyword">sizeof</span>(*cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a>));
398 <a name="l00377"></a>00377 <span class="keywordflow">if</span> (cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> && !cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a>) {
399 <a name="l00378"></a>00378 perror(<span class="stringliteral">"realloc"</span>);
400 <a name="l00379"></a>00379 cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> = 0;
401 <a name="l00380"></a>00380 <span class="keywordflow">return</span> -1;
402 <a name="l00381"></a>00381 }
403 <a name="l00382"></a>00382
404 <a name="l00383"></a>00383 <span class="keywordflow">return</span> 0;
405 <a name="l00384"></a>00384 }
406 <a name="l00385"></a>00385
407 <a name="l00386"></a>00386 <span class="keywordtype">int</span>
408 <a name="l00387"></a><a class="code" href="lightmediascanner__db__common_8c.html#19b0458b9d7b76370588156e931a9c04">00387</a> <a class="code" href="lightmediascanner__db__common_8c.html#19b0458b9d7b76370588156e931a9c04">lms_db_cache_add</a>(<span class="keyword">struct</span> <a class="code" href="structlms__db__cache.html">lms_db_cache</a> *cache, <span class="keyword">const</span> sqlite3 *db, <span class="keywordtype">void</span> *data)
409 <a name="l00388"></a>00388 {
410 <a name="l00389"></a>00389 <span class="keyword">struct </span><a class="code" href="structlms__db__cache__entry.html">lms_db_cache_entry</a> *e;
411 <a name="l00390"></a>00390 <span class="keywordtype">int</span> idx;
412 <a name="l00391"></a>00391
413 <a name="l00392"></a>00392 idx = lms_db_cache_find_db(cache, db);
414 <a name="l00393"></a>00393 <span class="keywordflow">if</span> (idx >= 0) {
415 <a name="l00394"></a>00394 e = cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a> + idx;
416 <a name="l00395"></a>00395 <span class="keywordflow">if</span> (e-><a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a> == data)
417 <a name="l00396"></a>00396 <span class="keywordflow">return</span> 0;
418 <a name="l00397"></a>00397 <span class="keywordflow">else</span> {
419 <a name="l00398"></a>00398 fprintf(stderr,
420 <a name="l00399"></a>00399 <span class="stringliteral">"ERROR: cache %p for db %p has another data registered"</span>
421 <a name="l00400"></a>00400 <span class="stringliteral">": %p (current is %p)\n"</span>, cache, db, e-><a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a>, data);
422 <a name="l00401"></a>00401 <span class="keywordflow">return</span> -1;
423 <a name="l00402"></a>00402 }
424 <a name="l00403"></a>00403 }
425 <a name="l00404"></a>00404
426 <a name="l00405"></a>00405 idx = cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a>;
427 <a name="l00406"></a>00406 <span class="keywordflow">if</span> (lms_db_cache_resize(cache, cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> + 1) != 0) {
428 <a name="l00407"></a>00407 <span class="keywordflow">return</span> -2;
429 <a name="l00408"></a>00408 }
430 <a name="l00409"></a>00409
431 <a name="l00410"></a>00410 e = cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a> + idx;
432 <a name="l00411"></a>00411 e-><a class="code" href="structlms__db__cache__entry.html#01aadf6d9a8161696019d39566b15760">db</a> = db;
433 <a name="l00412"></a>00412 e-><a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a> = data;
434 <a name="l00413"></a>00413 <span class="keywordflow">return</span> 0;
435 <a name="l00414"></a>00414 }
436 <a name="l00415"></a>00415
437 <a name="l00416"></a>00416 <span class="keywordtype">int</span>
438 <a name="l00417"></a><a class="code" href="lightmediascanner__db__common_8c.html#296c81e4c64be1c7935ef31038aeb2c0">00417</a> <a class="code" href="lightmediascanner__db__common_8c.html#296c81e4c64be1c7935ef31038aeb2c0">lms_db_cache_del</a>(<span class="keyword">struct</span> <a class="code" href="structlms__db__cache.html">lms_db_cache</a> *cache, <span class="keyword">const</span> sqlite3 *db, <span class="keywordtype">void</span> *<a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a>)
439 <a name="l00418"></a>00418 {
440 <a name="l00419"></a>00419 <span class="keywordtype">int</span> idx;
441 <a name="l00420"></a>00420 <span class="keyword">struct </span><a class="code" href="structlms__db__cache__entry.html">lms_db_cache_entry</a> *e;
442 <a name="l00421"></a>00421
443 <a name="l00422"></a>00422 idx = lms_db_cache_find_db(cache, db);
444 <a name="l00423"></a>00423 <span class="keywordflow">if</span> (idx < 0) {
445 <a name="l00424"></a>00424 fprintf(stderr, <span class="stringliteral">"ERROR: no db %p found in cache %p\n"</span>, db, cache);
446 <a name="l00425"></a>00425 <span class="keywordflow">return</span> -1;
447 <a name="l00426"></a>00426 }
448 <a name="l00427"></a>00427
449 <a name="l00428"></a>00428 e = cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a> + idx;
450 <a name="l00429"></a>00429 <span class="keywordflow">if</span> (e-><a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a> != data) {
451 <a name="l00430"></a>00430 fprintf(stderr, <span class="stringliteral">"ERROR: data mismatch in request to delete from cache: "</span>
452 <a name="l00431"></a>00431 <span class="stringliteral">"want %p, has %p, cache %p, db %p\n"</span>, data, e-><a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a>, cache, db);
453 <a name="l00432"></a>00432 <span class="keywordflow">return</span> -2;
454 <a name="l00433"></a>00433 }
455 <a name="l00434"></a>00434
456 <a name="l00435"></a>00435 <span class="keywordflow">for</span> (; idx < cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> - 1; idx++)
457 <a name="l00436"></a>00436 cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a>[idx] = cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a>[idx + 1];
458 <a name="l00437"></a>00437
459 <a name="l00438"></a>00438 <span class="keywordflow">return</span> lms_db_cache_resize(cache, cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> - 1);
460 <a name="l00439"></a>00439 }
461 <a name="l00440"></a>00440
462 <a name="l00441"></a>00441 <span class="keywordtype">int</span>
463 <a name="l00442"></a><a class="code" href="lightmediascanner__db__common_8c.html#e7a672fa5760bae1a669c737648fe7d3">00442</a> <a class="code" href="lightmediascanner__db__common_8c.html#e7a672fa5760bae1a669c737648fe7d3">lms_db_cache_get</a>(<span class="keyword">struct</span> <a class="code" href="structlms__db__cache.html">lms_db_cache</a> *cache, <span class="keyword">const</span> sqlite3 *db, <span class="keywordtype">void</span> **pdata)
464 <a name="l00443"></a>00443 {
465 <a name="l00444"></a>00444 <span class="keywordtype">int</span> idx;
466 <a name="l00445"></a>00445
467 <a name="l00446"></a>00446 idx = lms_db_cache_find_db(cache, db);
468 <a name="l00447"></a>00447 <span class="keywordflow">if</span> (idx < 0)
469 <a name="l00448"></a>00448 <span class="keywordflow">return</span> -1;
470 <a name="l00449"></a>00449
471 <a name="l00450"></a>00450 *pdata = cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a>[idx].<a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a>;
472 <a name="l00451"></a>00451 <span class="keywordflow">return</span> 0;
473 <a name="l00452"></a>00452 }
474 <a name="l00453"></a>00453
475 <a name="l00454"></a>00454 <span class="keywordtype">int</span>
476 <a name="l00455"></a><a class="code" href="lightmediascanner__db__private_8h.html#13ca09c885535a2968e707120e935268">00455</a> <a class="code" href="lightmediascanner__db__common_8c.html#3798a46baaedc4d466879865456acc94">lms_db_create_core_tables_if_required</a>(sqlite3 *db)
477 <a name="l00456"></a>00456 {
478 <a name="l00457"></a>00457 <span class="keywordtype">char</span> *errmsg;
479 <a name="l00458"></a>00458 <span class="keywordtype">int</span> r;
480 <a name="l00459"></a>00459
481 <a name="l00460"></a>00460 errmsg = NULL;
482 <a name="l00461"></a>00461 r = sqlite3_exec(db,
483 <a name="l00462"></a>00462 <span class="stringliteral">"CREATE TABLE IF NOT EXISTS lms_internal ("</span>
484 <a name="l00463"></a>00463 <span class="stringliteral">"tab TEXT NOT NULL UNIQUE, "</span>
485 <a name="l00464"></a>00464 <span class="stringliteral">"version INTEGER NOT NULL"</span>
486 <a name="l00465"></a>00465 <span class="stringliteral">")"</span>,
487 <a name="l00466"></a>00466 NULL, NULL, &errmsg);
488 <a name="l00467"></a>00467 <span class="keywordflow">if</span> (r != SQLITE_OK) {
489 <a name="l00468"></a>00468 fprintf(stderr, <span class="stringliteral">"ERROR: could not create 'lms_internal' table: %s\n"</span>,
490 <a name="l00469"></a>00469 errmsg);
491 <a name="l00470"></a>00470 sqlite3_free(errmsg);
492 <a name="l00471"></a>00471 <span class="keywordflow">return</span> -1;
493 <a name="l00472"></a>00472 }
494 <a name="l00473"></a>00473
495 <a name="l00474"></a>00474 r = sqlite3_exec(db,
496 <a name="l00475"></a>00475 <span class="stringliteral">"CREATE TABLE IF NOT EXISTS files ("</span>
497 <a name="l00476"></a>00476 <span class="stringliteral">"id INTEGER PRIMARY KEY AUTOINCREMENT, "</span>
498 <a name="l00477"></a>00477 <span class="stringliteral">"path BLOB NOT NULL UNIQUE, "</span>
499 <a name="l00478"></a>00478 <span class="stringliteral">"mtime INTEGER NOT NULL, "</span>
500 <a name="l00479"></a>00479 <span class="stringliteral">"dtime INTEGER NOT NULL, "</span>
501 <a name="l00480"></a>00480 <span class="stringliteral">"size INTEGER NOT NULL"</span>
502 <a name="l00481"></a>00481 <span class="stringliteral">")"</span>,
503 <a name="l00482"></a>00482 NULL, NULL, &errmsg);
504 <a name="l00483"></a>00483 <span class="keywordflow">if</span> (r != SQLITE_OK) {
505 <a name="l00484"></a>00484 fprintf(stderr, <span class="stringliteral">"ERROR: could not create 'files' table: %s\n"</span>, errmsg);
506 <a name="l00485"></a>00485 sqlite3_free(errmsg);
507 <a name="l00486"></a>00486 <span class="keywordflow">return</span> -2;
508 <a name="l00487"></a>00487 }
509 <a name="l00488"></a>00488
510 <a name="l00489"></a>00489 r = sqlite3_exec(db,
511 <a name="l00490"></a>00490 <span class="stringliteral">"CREATE INDEX IF NOT EXISTS files_path_idx ON files ("</span>
512 <a name="l00491"></a>00491 <span class="stringliteral">"path"</span>
513 <a name="l00492"></a>00492 <span class="stringliteral">")"</span>,
514 <a name="l00493"></a>00493 NULL, NULL, &errmsg);
515 <a name="l00494"></a>00494 <span class="keywordflow">if</span> (r != SQLITE_OK) {
516 <a name="l00495"></a>00495 fprintf(stderr, <span class="stringliteral">"ERROR: could not create 'files_path_idx' index: %s\n"</span>,
517 <a name="l00496"></a>00496 errmsg);
518 <a name="l00497"></a>00497 sqlite3_free(errmsg);
519 <a name="l00498"></a>00498 <span class="keywordflow">return</span> -3;
520 <a name="l00499"></a>00499 }
521 <a name="l00500"></a>00500
522 <a name="l00501"></a>00501 <span class="keywordflow">return</span> 0;
523 <a name="l00502"></a>00502 }
524 <a name="l00503"></a>00503
525 <a name="l00504"></a>00504
526 <a name="l00505"></a>00505 sqlite3_stmt *
527 <a name="l00506"></a><a class="code" href="lightmediascanner__db__private_8h.html#073c254ca7b4d3f42e1be1854bcc42a3">00506</a> <a class="code" href="lightmediascanner__db__common_8c.html#1787fdaf148358c7a518e91dfd871ca1">lms_db_compile_stmt_begin_transaction</a>(sqlite3 *db)
528 <a name="l00507"></a>00507 {
529 <a name="l00508"></a>00508 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db, <span class="stringliteral">"BEGIN TRANSACTION"</span>);
530 <a name="l00509"></a>00509 }
531 <a name="l00510"></a>00510
532 <a name="l00511"></a>00511 <span class="keywordtype">int</span>
533 <a name="l00512"></a><a class="code" href="lightmediascanner__db__private_8h.html#3a7256cb653542bbf563feeb2aa2d0ea">00512</a> <a class="code" href="lightmediascanner__db__common_8c.html#5ff807216285c93325ffaf33361dd6fc">lms_db_begin_transaction</a>(sqlite3_stmt *stmt)
534 <a name="l00513"></a>00513 {
535 <a name="l00514"></a>00514 <span class="keywordtype">int</span> r, ret;
536 <a name="l00515"></a>00515
537 <a name="l00516"></a>00516 ret = 0;
538 <a name="l00517"></a>00517 r = sqlite3_step(stmt);
539 <a name="l00518"></a>00518 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
540 <a name="l00519"></a>00519 fprintf(stderr, <span class="stringliteral">"ERROR: could not begin transaction: %s\n"</span>,
541 <a name="l00520"></a>00520 sqlite3_errmsg(sqlite3_db_handle(stmt)));
542 <a name="l00521"></a>00521 ret = -1;
543 <a name="l00522"></a>00522 }
544 <a name="l00523"></a>00523
545 <a name="l00524"></a>00524 r = sqlite3_reset(stmt);
546 <a name="l00525"></a>00525 <span class="keywordflow">if</span> (r != SQLITE_OK)
547 <a name="l00526"></a>00526 fprintf(stderr, <span class="stringliteral">"ERROR: could not reset SQL statement: %s\n"</span>,
548 <a name="l00527"></a>00527 sqlite3_errmsg(sqlite3_db_handle(stmt)));
549 <a name="l00528"></a>00528
550 <a name="l00529"></a>00529 <span class="keywordflow">return</span> ret;
551 <a name="l00530"></a>00530 }
552 <a name="l00531"></a>00531
553 <a name="l00532"></a>00532 sqlite3_stmt *
554 <a name="l00533"></a><a class="code" href="lightmediascanner__db__private_8h.html#09feca4fbfde33d5647cdd5cc2de6500">00533</a> <a class="code" href="lightmediascanner__db__common_8c.html#bff1aa6077215f3d70d4d5b1a9b7a498">lms_db_compile_stmt_end_transaction</a>(sqlite3 *db)
555 <a name="l00534"></a>00534 {
556 <a name="l00535"></a>00535 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db, <span class="stringliteral">"COMMIT"</span>);
557 <a name="l00536"></a>00536 }
558 <a name="l00537"></a>00537
559 <a name="l00538"></a>00538 <span class="keywordtype">int</span>
560 <a name="l00539"></a><a class="code" href="lightmediascanner__db__private_8h.html#8ee7bfba83958b80f717a6ccbad2a84c">00539</a> <a class="code" href="lightmediascanner__db__common_8c.html#ffa877e4fa751f090e7af8c2025d245c">lms_db_end_transaction</a>(sqlite3_stmt *stmt)
561 <a name="l00540"></a>00540 {
562 <a name="l00541"></a>00541 <span class="keywordtype">int</span> r, ret;
563 <a name="l00542"></a>00542
564 <a name="l00543"></a>00543 ret = 0;
565 <a name="l00544"></a>00544 r = sqlite3_step(stmt);
566 <a name="l00545"></a>00545 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
567 <a name="l00546"></a>00546 fprintf(stderr, <span class="stringliteral">"ERROR: could not end transaction: %s\n"</span>,
568 <a name="l00547"></a>00547 sqlite3_errmsg(sqlite3_db_handle(stmt)));
569 <a name="l00548"></a>00548 ret = -1;
570 <a name="l00549"></a>00549 }
571 <a name="l00550"></a>00550
572 <a name="l00551"></a>00551 r = sqlite3_reset(stmt);
573 <a name="l00552"></a>00552 <span class="keywordflow">if</span> (r != SQLITE_OK)
574 <a name="l00553"></a>00553 fprintf(stderr, <span class="stringliteral">"ERROR: could not reset SQL statement: %s\n"</span>,
575 <a name="l00554"></a>00554 sqlite3_errmsg(sqlite3_db_handle(stmt)));
576 <a name="l00555"></a>00555
577 <a name="l00556"></a>00556 <span class="keywordflow">return</span> ret;
578 <a name="l00557"></a>00557 }
579 <a name="l00558"></a>00558
580 <a name="l00559"></a>00559 sqlite3_stmt *
581 <a name="l00560"></a><a class="code" href="lightmediascanner__db__private_8h.html#327d54a6dac083e356fd609298a0cbd5">00560</a> <a class="code" href="lightmediascanner__db__common_8c.html#b00a624bc01da9b796f7bc6e1d507cf8">lms_db_compile_stmt_get_file_info</a>(sqlite3 *db)
582 <a name="l00561"></a>00561 {
583 <a name="l00562"></a>00562 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
584 <a name="l00563"></a>00563 <span class="stringliteral">"SELECT id, mtime, dtime, size FROM files WHERE path = ?"</span>);
585 <a name="l00564"></a>00564 }
586 <a name="l00565"></a>00565
587 <a name="l00566"></a>00566 <span class="keywordtype">int</span>
588 <a name="l00567"></a><a class="code" href="lightmediascanner__db__common_8c.html#c0b7cf0b2eb0f55fbf8a4103bc9569d1">00567</a> <a class="code" href="lightmediascanner__db__common_8c.html#c0b7cf0b2eb0f55fbf8a4103bc9569d1">lms_db_get_file_info</a>(sqlite3_stmt *stmt, <span class="keyword">struct</span> <a class="code" href="structlms__file__info.html">lms_file_info</a> *finfo)
589 <a name="l00568"></a>00568 {
590 <a name="l00569"></a>00569 <span class="keywordtype">int</span> r, ret;
591 <a name="l00570"></a>00570
592 <a name="l00571"></a>00571 ret = <a class="code" href="lightmediascanner__db__common_8c.html#fee26461dbd6c89c82794c94aaeeaef6">lms_db_bind_blob</a>(stmt, 1, finfo-><a class="code" href="structlms__file__info.html#1fa6966afec95bbb00ee01f345948e44">path</a>, finfo-><a class="code" href="structlms__file__info.html#9d74df2696cfd0f516e61e9db2b35731">path_len</a>);
593 <a name="l00572"></a>00572 <span class="keywordflow">if</span> (ret != 0)
594 <a name="l00573"></a>00573 <span class="keywordflow">goto</span> done;
595 <a name="l00574"></a>00574
596 <a name="l00575"></a>00575 r = sqlite3_step(stmt);
597 <a name="l00576"></a>00576 <span class="keywordflow">if</span> (r == SQLITE_DONE) {
598 <a name="l00577"></a>00577 ret = 1;
599 <a name="l00578"></a>00578 finfo-><a class="code" href="structlms__file__info.html#d68ded5c64ae28a4976637f8483e9cfe">id</a> = -1;
600 <a name="l00579"></a>00579 <span class="keywordflow">goto</span> done;
601 <a name="l00580"></a>00580 }
602 <a name="l00581"></a>00581
603 <a name="l00582"></a>00582 <span class="keywordflow">if</span> (r != SQLITE_ROW) {
604 <a name="l00583"></a>00583 fprintf(stderr, <span class="stringliteral">"ERROR: could not get file info from table: %s\n"</span>,
605 <a name="l00584"></a>00584 sqlite3_errmsg(sqlite3_db_handle(stmt)));
606 <a name="l00585"></a>00585 ret = -2;
607 <a name="l00586"></a>00586 <span class="keywordflow">goto</span> done;
608 <a name="l00587"></a>00587 }
609 <a name="l00588"></a>00588
610 <a name="l00589"></a>00589 finfo-><a class="code" href="structlms__file__info.html#d68ded5c64ae28a4976637f8483e9cfe">id</a> = sqlite3_column_int64(stmt, 0);
611 <a name="l00590"></a>00590 finfo-><a class="code" href="structlms__file__info.html#4aa878eefdde84541021087192b9dacd">mtime</a> = sqlite3_column_int(stmt, 1);
612 <a name="l00591"></a>00591 finfo-><a class="code" href="structlms__file__info.html#570ae808983e67ae7b22a2fec892cffd">dtime</a> = sqlite3_column_int(stmt, 2);
613 <a name="l00592"></a>00592 finfo-><a class="code" href="structlms__file__info.html#b318b81fc934636a904f5d84efe8c1ee">size</a> = sqlite3_column_int(stmt, 3);
614 <a name="l00593"></a>00593 ret = 0;
615 <a name="l00594"></a>00594
616 <a name="l00595"></a>00595 done:
617 <a name="l00596"></a>00596 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
618 <a name="l00597"></a>00597
619 <a name="l00598"></a>00598 <span class="keywordflow">return</span> ret;
620 <a name="l00599"></a>00599 }
621 <a name="l00600"></a>00600
622 <a name="l00601"></a>00601 sqlite3_stmt *
623 <a name="l00602"></a><a class="code" href="lightmediascanner__db__private_8h.html#69eb9d9058d9432f7658f9adffb79ed6">00602</a> <a class="code" href="lightmediascanner__db__common_8c.html#1e6e76cfa9d6faa3c3b8035004eff1a0">lms_db_compile_stmt_update_file_info</a>(sqlite3 *db)
624 <a name="l00603"></a>00603 {
625 <a name="l00604"></a>00604 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
626 <a name="l00605"></a>00605 <span class="stringliteral">"UPDATE files SET mtime = ?, dtime = ?, size = ? WHERE id = ?"</span>);
627 <a name="l00606"></a>00606 }
628 <a name="l00607"></a>00607
629 <a name="l00608"></a>00608 <span class="keywordtype">int</span>
630 <a name="l00609"></a><a class="code" href="lightmediascanner__db__common_8c.html#0f727cd41bbb90af2e08b3ee7ca76de9">00609</a> <a class="code" href="lightmediascanner__db__common_8c.html#0f727cd41bbb90af2e08b3ee7ca76de9">lms_db_update_file_info</a>(sqlite3_stmt *stmt, <span class="keyword">const</span> <span class="keyword">struct</span> <a class="code" href="structlms__file__info.html">lms_file_info</a> *finfo)
631 <a name="l00610"></a>00610 {
632 <a name="l00611"></a>00611 <span class="keywordtype">int</span> r, ret;
633 <a name="l00612"></a>00612
634 <a name="l00613"></a>00613 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 1, finfo-><a class="code" href="structlms__file__info.html#4aa878eefdde84541021087192b9dacd">mtime</a>);
635 <a name="l00614"></a>00614 <span class="keywordflow">if</span> (ret != 0)
636 <a name="l00615"></a>00615 <span class="keywordflow">goto</span> done;
637 <a name="l00616"></a>00616
638 <a name="l00617"></a>00617 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 2, finfo-><a class="code" href="structlms__file__info.html#570ae808983e67ae7b22a2fec892cffd">dtime</a>);
639 <a name="l00618"></a>00618 <span class="keywordflow">if</span> (ret != 0)
640 <a name="l00619"></a>00619 <span class="keywordflow">goto</span> done;
641 <a name="l00620"></a>00620
642 <a name="l00621"></a>00621 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 3, finfo-><a class="code" href="structlms__file__info.html#b318b81fc934636a904f5d84efe8c1ee">size</a>);
643 <a name="l00622"></a>00622 <span class="keywordflow">if</span> (ret != 0)
644 <a name="l00623"></a>00623 <span class="keywordflow">goto</span> done;
645 <a name="l00624"></a>00624
646 <a name="l00625"></a>00625 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 4, finfo-><a class="code" href="structlms__file__info.html#d68ded5c64ae28a4976637f8483e9cfe">id</a>);
647 <a name="l00626"></a>00626 <span class="keywordflow">if</span> (ret != 0)
648 <a name="l00627"></a>00627 <span class="keywordflow">goto</span> done;
649 <a name="l00628"></a>00628
650 <a name="l00629"></a>00629 r = sqlite3_step(stmt);
651 <a name="l00630"></a>00630 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
652 <a name="l00631"></a>00631 fprintf(stderr, <span class="stringliteral">"ERROR: could not update file info: %s\n"</span>,
653 <a name="l00632"></a>00632 sqlite3_errmsg(sqlite3_db_handle(stmt)));
654 <a name="l00633"></a>00633 ret = -5;
655 <a name="l00634"></a>00634 <span class="keywordflow">goto</span> done;
656 <a name="l00635"></a>00635 }
657 <a name="l00636"></a>00636
658 <a name="l00637"></a>00637 ret = 0;
659 <a name="l00638"></a>00638
660 <a name="l00639"></a>00639 done:
661 <a name="l00640"></a>00640 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
662 <a name="l00641"></a>00641
663 <a name="l00642"></a>00642 <span class="keywordflow">return</span> ret;
664 <a name="l00643"></a>00643 }
665 <a name="l00644"></a>00644
666 <a name="l00645"></a>00645 sqlite3_stmt *
667 <a name="l00646"></a><a class="code" href="lightmediascanner__db__private_8h.html#bf21f88ddbe28a8290d0df32af0f079c">00646</a> <a class="code" href="lightmediascanner__db__common_8c.html#9a5886e755eb428ac811956144eee0dc">lms_db_compile_stmt_insert_file_info</a>(sqlite3 *db)
668 <a name="l00647"></a>00647 {
669 <a name="l00648"></a>00648 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
670 <a name="l00649"></a>00649 <span class="stringliteral">"INSERT INTO files (path, mtime, dtime, size) VALUES(?, ?, ?, ?)"</span>);
671 <a name="l00650"></a>00650 }
672 <a name="l00651"></a>00651
673 <a name="l00652"></a>00652 <span class="keywordtype">int</span>
674 <a name="l00653"></a><a class="code" href="lightmediascanner__db__common_8c.html#e529ad5c4478d53685c65ec69dc5b1f4">00653</a> <a class="code" href="lightmediascanner__db__common_8c.html#e529ad5c4478d53685c65ec69dc5b1f4">lms_db_insert_file_info</a>(sqlite3_stmt *stmt, <span class="keyword">struct</span> <a class="code" href="structlms__file__info.html">lms_file_info</a> *finfo)
675 <a name="l00654"></a>00654 {
676 <a name="l00655"></a>00655 <span class="keywordtype">int</span> r, ret;
677 <a name="l00656"></a>00656
678 <a name="l00657"></a>00657 ret = <a class="code" href="lightmediascanner__db__common_8c.html#fee26461dbd6c89c82794c94aaeeaef6">lms_db_bind_blob</a>(stmt, 1, finfo-><a class="code" href="structlms__file__info.html#1fa6966afec95bbb00ee01f345948e44">path</a>, finfo-><a class="code" href="structlms__file__info.html#9d74df2696cfd0f516e61e9db2b35731">path_len</a>);
679 <a name="l00658"></a>00658 <span class="keywordflow">if</span> (ret != 0)
680 <a name="l00659"></a>00659 <span class="keywordflow">goto</span> done;
681 <a name="l00660"></a>00660
682 <a name="l00661"></a>00661 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 2, finfo-><a class="code" href="structlms__file__info.html#4aa878eefdde84541021087192b9dacd">mtime</a>);
683 <a name="l00662"></a>00662 <span class="keywordflow">if</span> (ret != 0)
684 <a name="l00663"></a>00663 <span class="keywordflow">goto</span> done;
685 <a name="l00664"></a>00664
686 <a name="l00665"></a>00665 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 3, finfo-><a class="code" href="structlms__file__info.html#570ae808983e67ae7b22a2fec892cffd">dtime</a>);
687 <a name="l00666"></a>00666 <span class="keywordflow">if</span> (ret != 0)
688 <a name="l00667"></a>00667 <span class="keywordflow">goto</span> done;
689 <a name="l00668"></a>00668
690 <a name="l00669"></a>00669 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 4, finfo-><a class="code" href="structlms__file__info.html#b318b81fc934636a904f5d84efe8c1ee">size</a>);
691 <a name="l00670"></a>00670 <span class="keywordflow">if</span> (ret != 0)
692 <a name="l00671"></a>00671 <span class="keywordflow">goto</span> done;
693 <a name="l00672"></a>00672
694 <a name="l00673"></a>00673 r = sqlite3_step(stmt);
695 <a name="l00674"></a>00674 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
696 <a name="l00675"></a>00675 fprintf(stderr, <span class="stringliteral">"ERROR: could not insert file info: %s\n"</span>,
697 <a name="l00676"></a>00676 sqlite3_errmsg(sqlite3_db_handle(stmt)));
698 <a name="l00677"></a>00677 ret = -5;
699 <a name="l00678"></a>00678 <span class="keywordflow">goto</span> done;
700 <a name="l00679"></a>00679 }
701 <a name="l00680"></a>00680
702 <a name="l00681"></a>00681 finfo-><a class="code" href="structlms__file__info.html#d68ded5c64ae28a4976637f8483e9cfe">id</a> = sqlite3_last_insert_rowid(sqlite3_db_handle(stmt));
703 <a name="l00682"></a>00682 ret = 0;
704 <a name="l00683"></a>00683
705 <a name="l00684"></a>00684 done:
706 <a name="l00685"></a>00685 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
707 <a name="l00686"></a>00686
708 <a name="l00687"></a>00687 <span class="keywordflow">return</span> ret;
709 <a name="l00688"></a>00688 }
710 <a name="l00689"></a>00689
711 <a name="l00690"></a>00690 sqlite3_stmt *
712 <a name="l00691"></a><a class="code" href="lightmediascanner__db__private_8h.html#76941bdbbdb711fff821343e91c2cd97">00691</a> <a class="code" href="lightmediascanner__db__common_8c.html#559925f8e4d5bf61d1bcf44844a95699">lms_db_compile_stmt_delete_file_info</a>(sqlite3 *db)
713 <a name="l00692"></a>00692 {
714 <a name="l00693"></a>00693 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db, <span class="stringliteral">"DELETE FROM files WHERE id = ?"</span>);
715 <a name="l00694"></a>00694 }
716 <a name="l00695"></a>00695
717 <a name="l00696"></a>00696 <span class="keywordtype">int</span>
718 <a name="l00697"></a><a class="code" href="lightmediascanner__db__common_8c.html#bb2a9cdbbc7680d1ec85ef3f086b3f63">00697</a> <a class="code" href="lightmediascanner__db__common_8c.html#bb2a9cdbbc7680d1ec85ef3f086b3f63">lms_db_delete_file_info</a>(sqlite3_stmt *stmt, <span class="keyword">const</span> <span class="keyword">struct</span> <a class="code" href="structlms__file__info.html">lms_file_info</a> *finfo)
719 <a name="l00698"></a>00698 {
720 <a name="l00699"></a>00699 <span class="keywordtype">int</span> r, ret;
721 <a name="l00700"></a>00700
722 <a name="l00701"></a>00701 ret = <a class="code" href="lightmediascanner__db__common_8c.html#f2fe78bc45dc33d843313a846db5ce7c">lms_db_bind_int64</a>(stmt, 1, finfo-><a class="code" href="structlms__file__info.html#d68ded5c64ae28a4976637f8483e9cfe">id</a>);
723 <a name="l00702"></a>00702 <span class="keywordflow">if</span> (ret != 0)
724 <a name="l00703"></a>00703 <span class="keywordflow">goto</span> done;
725 <a name="l00704"></a>00704
726 <a name="l00705"></a>00705 r = sqlite3_step(stmt);
727 <a name="l00706"></a>00706 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
728 <a name="l00707"></a>00707 fprintf(stderr, <span class="stringliteral">"ERROR: could not delete file info: %s\n"</span>,
729 <a name="l00708"></a>00708 sqlite3_errmsg(sqlite3_db_handle(stmt)));
730 <a name="l00709"></a>00709 ret = -2;
731 <a name="l00710"></a>00710 <span class="keywordflow">goto</span> done;
732 <a name="l00711"></a>00711 }
733 <a name="l00712"></a>00712 ret = 0;
734 <a name="l00713"></a>00713
735 <a name="l00714"></a>00714 done:
736 <a name="l00715"></a>00715 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
737 <a name="l00716"></a>00716
738 <a name="l00717"></a>00717 <span class="keywordflow">return</span> ret;
739 <a name="l00718"></a>00718 }
740 <a name="l00719"></a>00719
741 <a name="l00720"></a>00720 sqlite3_stmt *
742 <a name="l00721"></a><a class="code" href="lightmediascanner__db__private_8h.html#08c34b5b1b6e927a696ff0ce66562f54">00721</a> <a class="code" href="lightmediascanner__db__common_8c.html#1b6950ca9e548670a4cb7fd0ec5220a8">lms_db_compile_stmt_set_file_dtime</a>(sqlite3 *db)
743 <a name="l00722"></a>00722 {
744 <a name="l00723"></a>00723 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db, <span class="stringliteral">"UPDATE files SET dtime = ? WHERE id = ?"</span>);
745 <a name="l00724"></a>00724 }
746 <a name="l00725"></a>00725
747 <a name="l00726"></a>00726 <span class="keywordtype">int</span>
748 <a name="l00727"></a><a class="code" href="lightmediascanner__db__common_8c.html#024e3bd9385fd740f75618716c90b04f">00727</a> <a class="code" href="lightmediascanner__db__common_8c.html#024e3bd9385fd740f75618716c90b04f">lms_db_set_file_dtime</a>(sqlite3_stmt *stmt, <span class="keyword">const</span> <span class="keyword">struct</span> <a class="code" href="structlms__file__info.html">lms_file_info</a> *finfo)
749 <a name="l00728"></a>00728 {
750 <a name="l00729"></a>00729 <span class="keywordtype">int</span> r, ret;
751 <a name="l00730"></a>00730
752 <a name="l00731"></a>00731 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 1, finfo-><a class="code" href="structlms__file__info.html#570ae808983e67ae7b22a2fec892cffd">dtime</a>);
753 <a name="l00732"></a>00732 <span class="keywordflow">if</span> (ret != 0)
754 <a name="l00733"></a>00733 <span class="keywordflow">goto</span> done;
755 <a name="l00734"></a>00734
756 <a name="l00735"></a>00735 ret = <a class="code" href="lightmediascanner__db__common_8c.html#f2fe78bc45dc33d843313a846db5ce7c">lms_db_bind_int64</a>(stmt, 1, finfo-><a class="code" href="structlms__file__info.html#d68ded5c64ae28a4976637f8483e9cfe">id</a>);
757 <a name="l00736"></a>00736 <span class="keywordflow">if</span> (ret != 0)
758 <a name="l00737"></a>00737 <span class="keywordflow">goto</span> done;
759 <a name="l00738"></a>00738
760 <a name="l00739"></a>00739 r = sqlite3_step(stmt);
761 <a name="l00740"></a>00740 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
762 <a name="l00741"></a>00741 fprintf(stderr, <span class="stringliteral">"ERROR: could not set file dtime: %s\n"</span>,
763 <a name="l00742"></a>00742 sqlite3_errmsg(sqlite3_db_handle(stmt)));
764 <a name="l00743"></a>00743 ret = -3;
765 <a name="l00744"></a>00744 <span class="keywordflow">goto</span> done;
766 <a name="l00745"></a>00745 }
767 <a name="l00746"></a>00746
768 <a name="l00747"></a>00747 ret = 0;
769 <a name="l00748"></a>00748
770 <a name="l00749"></a>00749 done:
771 <a name="l00750"></a>00750 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
772 <a name="l00751"></a>00751
773 <a name="l00752"></a>00752 <span class="keywordflow">return</span> ret;
774 <a name="l00753"></a>00753 }
775 <a name="l00754"></a>00754
776 <a name="l00755"></a>00755 sqlite3_stmt *
777 <a name="l00756"></a><a class="code" href="lightmediascanner__db__private_8h.html#1cc8a80961a0febdd099a028f3da9c30">00756</a> <a class="code" href="lightmediascanner__db__common_8c.html#73ae2cfd7babf80294cf31f02906223b">lms_db_compile_stmt_get_files</a>(sqlite3 *db)
778 <a name="l00757"></a>00757 {
779 <a name="l00758"></a>00758 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
780 <a name="l00759"></a>00759 <span class="stringliteral">"SELECT id, path, mtime, dtime, size FROM files WHERE path LIKE ?"</span>);
781 <a name="l00760"></a>00760 }
782 <a name="l00761"></a>00761
783 <a name="l00762"></a>00762 <span class="keywordtype">int</span>
784 <a name="l00763"></a><a class="code" href="lightmediascanner__db__common_8c.html#df572e74e0821a66ebd16f575b4fb7c4">00763</a> <a class="code" href="lightmediascanner__db__common_8c.html#df572e74e0821a66ebd16f575b4fb7c4">lms_db_get_files</a>(sqlite3_stmt *stmt, <span class="keyword">const</span> <span class="keywordtype">char</span> *path, <span class="keywordtype">int</span> len)
785 <a name="l00764"></a>00764 {
786 <a name="l00765"></a>00765 <span class="keywordtype">int</span> ret;
787 <a name="l00766"></a>00766
788 <a name="l00767"></a>00767 ret = <a class="code" href="lightmediascanner__db__common_8c.html#fee26461dbd6c89c82794c94aaeeaef6">lms_db_bind_blob</a>(stmt, 1, path, len);
789 <a name="l00768"></a>00768 <span class="keywordflow">return</span> ret;
790 <a name="l00769"></a>00769 }
791 </pre></div><hr size="1"><address style="text-align: right;"><small>Generated on Thu Dec 13 02:04:03 2007 for Light Media Scanner by
792 <a href="http://www.doxygen.org/index.html">
793 <img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.2 </small></address>
projects / lms / blob