--- /dev/null
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
+<title>Light Media Scanner: src/lib/lightmediascanner_db_common.c Source File</title>
+<link href="tabs.css" rel="stylesheet" type="text/css">
+<link href="doxygen.css" rel="stylesheet" type="text/css">
+</head><body>
+<!-- Generated by Doxygen 1.5.8 -->
+<div class="navigation" id="top">
+ <div class="tabs">
+ <ul>
+ <li><a href="index.html"><span>Main Page</span></a></li>
+ <li><a href="modules.html"><span>Modules</span></a></li>
+ <li><a href="annotated.html"><span>Data Structures</span></a></li>
+ <li class="current"><a href="files.html"><span>Files</span></a></li>
+ </ul>
+ </div>
+ <div class="tabs">
+ <ul>
+ <li><a href="files.html"><span>File List</span></a></li>
+ <li><a href="globals.html"><span>Globals</span></a></li>
+ </ul>
+ </div>
+<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
+<a name="l00021"></a>00021 <span class="preprocessor">#include "<a class="code" href="lightmediascanner__db__private_8h.html">lightmediascanner_db_private.h</a>"</span>
+<a name="l00022"></a>00022 <span class="preprocessor">#include <stdlib.h></span>
+<a name="l00023"></a>00023 <span class="preprocessor">#include <stdio.h></span>
+<a name="l00024"></a>00024 <span class="preprocessor">#include <string.h></span>
+<a name="l00025"></a>00025
+<a name="l00026"></a>00026 <span class="preprocessor">#if SQLITE_VERSION_NUMBER < 3003009</span>
+<a name="l00027"></a>00027 <span class="preprocessor"></span><span class="keywordtype">int</span>
+<a name="l00028"></a><a class="code" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405">00028</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)
+<a name="l00029"></a>00029 {
+<a name="l00030"></a>00030 <span class="keywordflow">return</span> sqlite3_prepare(db, sql, len, stmt, tail);
+<a name="l00031"></a>00031 }
+<a name="l00032"></a>00032 <span class="preprocessor">#endif </span><span class="comment">/* SQLITE_VERSION_NUMBER < 3003009 */</span>
+<a name="l00033"></a>00033
+<a name="l00034"></a>00034 <span class="preprocessor">#if SQLITE_VERSION_NUMBER < 3003007</span>
+<a name="l00035"></a>00035 <span class="preprocessor"></span><span class="keywordtype">int</span>
+<a name="l00036"></a><a class="code" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00">00036</a> <a class="code" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00">sqlite3_clear_bindings</a>(sqlite3_stmt *stmt)
+<a name="l00037"></a>00037 {
+<a name="l00038"></a>00038 <span class="keywordtype">int</span> i, last;
+<a name="l00039"></a>00039 <span class="keywordtype">int</span> rc;
+<a name="l00040"></a>00040
+<a name="l00041"></a>00041 rc = SQLITE_OK;
+<a name="l00042"></a>00042 last = sqlite3_bind_parameter_count(stmt);
+<a name="l00043"></a>00043 <span class="keywordflow">for</span>(i = 1; rc == SQLITE_OK && i <= last; i++) {
+<a name="l00044"></a>00044 rc = sqlite3_bind_null(stmt, i);
+<a name="l00045"></a>00045 }
+<a name="l00046"></a>00046 <span class="keywordflow">return</span> rc;
+<a name="l00047"></a>00047 }
+<a name="l00048"></a>00048 <span class="preprocessor">#endif </span><span class="comment">/* SQLITE_VERSION_NUMBER < 3003007 */</span>
+<a name="l00049"></a>00049
+<a name="l00050"></a>00050 <span class="preprocessor">#if SQLITE_VERSION_NUMBER < 3003008</span>
+<a name="l00051"></a>00051 <span class="preprocessor"></span><span class="comment">/* Until 3.3.8 it doesn't support CREATE TRIGGER IF NOT EXISTS, so</span>
+<a name="l00052"></a>00052 <span class="comment"> * just ignore errors :-(</span>
+<a name="l00053"></a>00053 <span class="comment"> */</span>
+<a name="l00054"></a>00054 <span class="keywordtype">int</span>
+<a name="l00055"></a><a class="code" href="lightmediascanner__db__common_8c.html#822cae681398710b63c9af149fdacedb">00055</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)
+<a name="l00056"></a>00056 {
+<a name="l00057"></a>00057 <span class="keywordtype">char</span> *errmsg, *query;
+<a name="l00058"></a>00058 <span class="keywordtype">int</span> r, sql_len, prefix_len;
+<a name="l00059"></a>00059
+<a name="l00060"></a>00060 prefix_len = <span class="keyword">sizeof</span>(<span class="stringliteral">"CREATE TRIGGER "</span>) - 1;
+<a name="l00061"></a>00061 sql_len = strlen(sql);
+<a name="l00062"></a>00062 query = malloc((prefix_len + sql_len + 1) * <span class="keyword">sizeof</span>(<span class="keywordtype">char</span>));
+<a name="l00063"></a>00063 <span class="keywordflow">if</span> (!query)
+<a name="l00064"></a>00064 <span class="keywordflow">return</span> -1;
+<a name="l00065"></a>00065
+<a name="l00066"></a>00066 memcpy(query, <span class="stringliteral">"CREATE TRIGGER "</span>, prefix_len);
+<a name="l00067"></a>00067 memcpy(query + prefix_len, sql, sql_len + 1);
+<a name="l00068"></a>00068 r = sqlite3_exec(db, query, NULL, NULL, &errmsg);
+<a name="l00069"></a>00069 free(query);
+<a name="l00070"></a>00070 <span class="keywordflow">if</span> (r != SQLITE_OK)
+<a name="l00071"></a>00071 sqlite3_free(errmsg);
+<a name="l00072"></a>00072 <span class="keywordflow">return</span> 0;
+<a name="l00073"></a>00073 }
+<a name="l00074"></a>00074 <span class="preprocessor">#else </span><span class="comment">/* SQLITE_VERSION_NUMBER < 3003008 */</span>
+<a name="l00075"></a>00075 <span class="keywordtype">int</span>
+<a name="l00076"></a>00076 <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)
+<a name="l00077"></a>00077 {
+<a name="l00078"></a>00078 <span class="keywordtype">char</span> *errmsg, *query;
+<a name="l00079"></a>00079 <span class="keywordtype">int</span> r, sql_len, prefix_len;
+<a name="l00080"></a>00080
+<a name="l00081"></a>00081 prefix_len = <span class="keyword">sizeof</span>(<span class="stringliteral">"CREATE TRIGGER IF NOT EXISTS "</span>) - 1;
+<a name="l00082"></a>00082 sql_len = strlen(sql);
+<a name="l00083"></a>00083 query = malloc((prefix_len + sql_len + 1) * <span class="keyword">sizeof</span>(<span class="keywordtype">char</span>));
+<a name="l00084"></a>00084 <span class="keywordflow">if</span> (!query)
+<a name="l00085"></a>00085 <span class="keywordflow">return</span> -1;
+<a name="l00086"></a>00086
+<a name="l00087"></a>00087 memcpy(query, <span class="stringliteral">"CREATE TRIGGER IF NOT EXISTS "</span>, prefix_len);
+<a name="l00088"></a>00088 memcpy(query + prefix_len, sql, sql_len + 1);
+<a name="l00089"></a>00089 r = sqlite3_exec(db, query, NULL, NULL, &errmsg);
+<a name="l00090"></a>00090 free(query);
+<a name="l00091"></a>00091 <span class="keywordflow">if</span> (r != SQLITE_OK) {
+<a name="l00092"></a>00092 fprintf(stderr, <span class="stringliteral">"ERROR: could not create trigger: %s\n"</span>, errmsg);
+<a name="l00093"></a>00093 sqlite3_free(errmsg);
+<a name="l00094"></a>00094 <span class="keywordflow">return</span> -2;
+<a name="l00095"></a>00095 }
+<a name="l00096"></a>00096 <span class="keywordflow">return</span> 0;
+<a name="l00097"></a>00097 }
+<a name="l00098"></a>00098 <span class="preprocessor">#endif </span><span class="comment">/* SQLITE_VERSION_NUMBER < 3003008 */</span>
+<a name="l00099"></a>00099
+<a name="l00100"></a>00100 sqlite3_stmt *
+<a name="l00101"></a><a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">00101</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)
+<a name="l00102"></a>00102 {
+<a name="l00103"></a>00103 sqlite3_stmt *stmt;
+<a name="l00104"></a>00104
+<a name="l00105"></a>00105 <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)
+<a name="l00106"></a>00106 fprintf(stderr, <span class="stringliteral">"ERROR: could not prepare \"%s\": %s\n"</span>, sql,
+<a name="l00107"></a>00107 sqlite3_errmsg(db));
+<a name="l00108"></a>00108
+<a name="l00109"></a>00109 <span class="keywordflow">return</span> stmt;
+<a name="l00110"></a>00110 }
+<a name="l00111"></a>00111
+<a name="l00112"></a>00112 <span class="keywordtype">int</span>
+<a name="l00113"></a><a class="code" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5">00113</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)
+<a name="l00114"></a>00114 {
+<a name="l00115"></a>00115 <span class="keywordtype">int</span> r;
+<a name="l00116"></a>00116
+<a name="l00117"></a>00117 r = sqlite3_finalize(stmt);
+<a name="l00118"></a>00118 <span class="keywordflow">if</span> (r != SQLITE_OK) {
+<a name="l00119"></a>00119 fprintf(stderr, <span class="stringliteral">"ERROR: could not finalize %s statement: #%d\n"</span>,
+<a name="l00120"></a>00120 name, r);
+<a name="l00121"></a>00121 <span class="keywordflow">return</span> -1;
+<a name="l00122"></a>00122 }
+<a name="l00123"></a>00123
+<a name="l00124"></a>00124 <span class="keywordflow">return</span> 0;
+<a name="l00125"></a>00125 }
+<a name="l00126"></a>00126
+<a name="l00127"></a>00127 <span class="keywordtype">int</span>
+<a name="l00128"></a><a class="code" href="lightmediascanner__db__private_8h.html#ee78f418f0f3c9ead3023b1453c63556">00128</a> <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(sqlite3_stmt *stmt)
+<a name="l00129"></a>00129 {
+<a name="l00130"></a>00130 <span class="keywordtype">int</span> r, ret;
+<a name="l00131"></a>00131
+<a name="l00132"></a>00132 ret = r = sqlite3_reset(stmt);
+<a name="l00133"></a>00133 <span class="keywordflow">if</span> (r != SQLITE_OK)
+<a name="l00134"></a>00134 fprintf(stderr, <span class="stringliteral">"ERROR: could not reset SQL statement: #%d\n"</span>, r);
+<a name="l00135"></a>00135
+<a name="l00136"></a>00136 r = <a class="code" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00">sqlite3_clear_bindings</a>(stmt);
+<a name="l00137"></a>00137 ret += r;
+<a name="l00138"></a>00138 <span class="keywordflow">if</span> (r != SQLITE_OK)
+<a name="l00139"></a>00139 fprintf(stderr, <span class="stringliteral">"ERROR: could not clear SQL: #%d\n"</span>, r);
+<a name="l00140"></a>00140
+<a name="l00141"></a>00141 <span class="keywordflow">return</span> ret;
+<a name="l00142"></a>00142 }
+<a name="l00143"></a>00143
+<a name="l00144"></a>00144 <span class="keywordtype">int</span>
+<a name="l00145"></a><a class="code" href="lightmediascanner__db__private_8h.html#14d56e02624ad6130bc59ae9bb950ac3">00145</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)
+<a name="l00146"></a>00146 {
+<a name="l00147"></a>00147 <span class="keywordtype">int</span> r;
+<a name="l00148"></a>00148
+<a name="l00149"></a>00149 <span class="keywordflow">if</span> (text)
+<a name="l00150"></a>00150 r = sqlite3_bind_text(stmt, col, text, len, SQLITE_STATIC);
+<a name="l00151"></a>00151 <span class="keywordflow">else</span>
+<a name="l00152"></a>00152 r = sqlite3_bind_null(stmt, col);
+<a name="l00153"></a>00153
+<a name="l00154"></a>00154 <span class="keywordflow">if</span> (r == SQLITE_OK)
+<a name="l00155"></a>00155 <span class="keywordflow">return</span> 0;
+<a name="l00156"></a>00156 <span class="keywordflow">else</span> {
+<a name="l00157"></a>00157 sqlite3 *db;
+<a name="l00158"></a>00158 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
+<a name="l00159"></a>00159
+<a name="l00160"></a>00160 db = sqlite3_db_handle(stmt);
+<a name="l00161"></a>00161 err = sqlite3_errmsg(db);
+<a name="l00162"></a>00162 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
+<a name="l00163"></a>00163 <span class="keywordflow">return</span> -col;
+<a name="l00164"></a>00164 }
+<a name="l00165"></a>00165 }
+<a name="l00166"></a>00166
+<a name="l00167"></a>00167 <span class="keywordtype">int</span>
+<a name="l00168"></a><a class="code" href="lightmediascanner__db__private_8h.html#7fd514b582578c18a25cdbf6c561243c">00168</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)
+<a name="l00169"></a>00169 {
+<a name="l00170"></a>00170 <span class="keywordtype">int</span> r;
+<a name="l00171"></a>00171
+<a name="l00172"></a>00172 <span class="keywordflow">if</span> (blob)
+<a name="l00173"></a>00173 r = sqlite3_bind_blob(stmt, col, blob, len, SQLITE_STATIC);
+<a name="l00174"></a>00174 <span class="keywordflow">else</span>
+<a name="l00175"></a>00175 r = sqlite3_bind_null(stmt, col);
+<a name="l00176"></a>00176
+<a name="l00177"></a>00177 <span class="keywordflow">if</span> (r == SQLITE_OK)
+<a name="l00178"></a>00178 <span class="keywordflow">return</span> 0;
+<a name="l00179"></a>00179 <span class="keywordflow">else</span> {
+<a name="l00180"></a>00180 sqlite3 *db;
+<a name="l00181"></a>00181 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
+<a name="l00182"></a>00182
+<a name="l00183"></a>00183 db = sqlite3_db_handle(stmt);
+<a name="l00184"></a>00184 err = sqlite3_errmsg(db);
+<a name="l00185"></a>00185 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
+<a name="l00186"></a>00186 <span class="keywordflow">return</span> -col;
+<a name="l00187"></a>00187 }
+<a name="l00188"></a>00188 }
+<a name="l00189"></a>00189
+<a name="l00190"></a>00190 <span class="keywordtype">int</span>
+<a name="l00191"></a><a class="code" href="lightmediascanner__db__private_8h.html#bbb18d7cc44f7e363c0f240849d72c31">00191</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)
+<a name="l00192"></a>00192 {
+<a name="l00193"></a>00193 <span class="keywordtype">int</span> r;
+<a name="l00194"></a>00194
+<a name="l00195"></a>00195 r = sqlite3_bind_int64(stmt, col, value);
+<a name="l00196"></a>00196 <span class="keywordflow">if</span> (r == SQLITE_OK)
+<a name="l00197"></a>00197 <span class="keywordflow">return</span> 0;
+<a name="l00198"></a>00198 <span class="keywordflow">else</span> {
+<a name="l00199"></a>00199 sqlite3 *db;
+<a name="l00200"></a>00200 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
+<a name="l00201"></a>00201
+<a name="l00202"></a>00202 db = sqlite3_db_handle(stmt);
+<a name="l00203"></a>00203 err = sqlite3_errmsg(db);
+<a name="l00204"></a>00204 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
+<a name="l00205"></a>00205 <span class="keywordflow">return</span> -col;
+<a name="l00206"></a>00206 }
+<a name="l00207"></a>00207 }
+<a name="l00208"></a>00208
+<a name="l00209"></a>00209 <span class="keywordtype">int</span>
+<a name="l00210"></a><a class="code" href="lightmediascanner__db__private_8h.html#cd7006f0271b9a47937dc2d2ae5480fe">00210</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)
+<a name="l00211"></a>00211 {
+<a name="l00212"></a>00212 <span class="keywordtype">int</span> r;
+<a name="l00213"></a>00213
+<a name="l00214"></a>00214 <span class="keywordflow">if</span> (p_value)
+<a name="l00215"></a>00215 r = sqlite3_bind_int64(stmt, col, *p_value);
+<a name="l00216"></a>00216 <span class="keywordflow">else</span>
+<a name="l00217"></a>00217 r = sqlite3_bind_null(stmt, col);
+<a name="l00218"></a>00218 <span class="keywordflow">if</span> (r == SQLITE_OK)
+<a name="l00219"></a>00219 <span class="keywordflow">return</span> 0;
+<a name="l00220"></a>00220 <span class="keywordflow">else</span> {
+<a name="l00221"></a>00221 sqlite3 *db;
+<a name="l00222"></a>00222 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
+<a name="l00223"></a>00223
+<a name="l00224"></a>00224 db = sqlite3_db_handle(stmt);
+<a name="l00225"></a>00225 err = sqlite3_errmsg(db);
+<a name="l00226"></a>00226 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
+<a name="l00227"></a>00227 <span class="keywordflow">return</span> -col;
+<a name="l00228"></a>00228 }
+<a name="l00229"></a>00229 }
+<a name="l00230"></a>00230
+<a name="l00231"></a>00231 <span class="keywordtype">int</span>
+<a name="l00232"></a><a class="code" href="lightmediascanner__db__private_8h.html#37815f859116b46089bea4ba84bb23d2">00232</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)
+<a name="l00233"></a>00233 {
+<a name="l00234"></a>00234 <span class="keywordtype">int</span> r;
+<a name="l00235"></a>00235
+<a name="l00236"></a>00236 r = sqlite3_bind_int(stmt, col, value);
+<a name="l00237"></a>00237 <span class="keywordflow">if</span> (r == SQLITE_OK)
+<a name="l00238"></a>00238 <span class="keywordflow">return</span> 0;
+<a name="l00239"></a>00239 <span class="keywordflow">else</span> {
+<a name="l00240"></a>00240 sqlite3 *db;
+<a name="l00241"></a>00241 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
+<a name="l00242"></a>00242
+<a name="l00243"></a>00243 db = sqlite3_db_handle(stmt);
+<a name="l00244"></a>00244 err = sqlite3_errmsg(db);
+<a name="l00245"></a>00245 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
+<a name="l00246"></a>00246 <span class="keywordflow">return</span> -col;
+<a name="l00247"></a>00247 }
+<a name="l00248"></a>00248 }
+<a name="l00249"></a>00249
+<a name="l00250"></a>00250 <span class="keywordtype">int</span>
+<a name="l00251"></a><a class="code" href="lightmediascanner__db__private_8h.html#9e78297037179998924354e73ca69349">00251</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)
+<a name="l00252"></a>00252 {
+<a name="l00253"></a>00253 <span class="keywordtype">int</span> r;
+<a name="l00254"></a>00254
+<a name="l00255"></a>00255 r = sqlite3_bind_double(stmt, col, value);
+<a name="l00256"></a>00256 <span class="keywordflow">if</span> (r == SQLITE_OK)
+<a name="l00257"></a>00257 <span class="keywordflow">return</span> 0;
+<a name="l00258"></a>00258 <span class="keywordflow">else</span> {
+<a name="l00259"></a>00259 sqlite3 *db;
+<a name="l00260"></a>00260 <span class="keyword">const</span> <span class="keywordtype">char</span> *err;
+<a name="l00261"></a>00261
+<a name="l00262"></a>00262 db = sqlite3_db_handle(stmt);
+<a name="l00263"></a>00263 err = sqlite3_errmsg(db);
+<a name="l00264"></a>00264 fprintf(stderr, <span class="stringliteral">"ERROR: could not bind SQL value %d: %s\n"</span>, col, err);
+<a name="l00265"></a>00265 <span class="keywordflow">return</span> -col;
+<a name="l00266"></a>00266 }
+<a name="l00267"></a>00267 }
+<a name="l00268"></a>00268
+<a name="l00269"></a>00269 <span class="keywordtype">int</span>
+<a name="l00270"></a><a class="code" href="lightmediascanner__db__common_8c.html#eba3215ee5981a73e9d0fed0a7e079cd">00270</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)
+<a name="l00271"></a>00271 {
+<a name="l00272"></a>00272 <span class="keywordtype">int</span> r, version;
+<a name="l00273"></a>00273 sqlite3_stmt *stmt;
+<a name="l00274"></a>00274
+<a name="l00275"></a>00275 stmt = <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
+<a name="l00276"></a>00276 <span class="stringliteral">"SELECT version FROM lms_internal WHERE tab = ?"</span>);
+<a name="l00277"></a>00277 <span class="keywordflow">if</span> (!stmt)
+<a name="l00278"></a>00278 <span class="keywordflow">return</span> -1;
+<a name="l00279"></a>00279
+<a name="l00280"></a>00280 <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) {
+<a name="l00281"></a>00281 version = -1;
+<a name="l00282"></a>00282 <span class="keywordflow">goto</span> done;
+<a name="l00283"></a>00283 }
+<a name="l00284"></a>00284
+<a name="l00285"></a>00285 r = sqlite3_step(stmt);
+<a name="l00286"></a>00286 <span class="keywordflow">if</span> (r == SQLITE_DONE)
+<a name="l00287"></a>00287 version = 0;
+<a name="l00288"></a>00288 <span class="keywordflow">else</span> <span class="keywordflow">if</span> (r == SQLITE_ROW)
+<a name="l00289"></a>00289 version = sqlite3_column_int(stmt, 0);
+<a name="l00290"></a>00290 <span class="keywordflow">else</span> {
+<a name="l00291"></a>00291 version = -1;
+<a name="l00292"></a>00292 fprintf(stderr, <span class="stringliteral">"ERROR: could not get table '%s' version: %s\n"</span>,
+<a name="l00293"></a>00293 table, sqlite3_errmsg(db));
+<a name="l00294"></a>00294 }
+<a name="l00295"></a>00295
+<a name="l00296"></a>00296 done:
+<a name="l00297"></a>00297 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
+<a name="l00298"></a>00298 <a class="code" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5">lms_db_finalize_stmt</a>(stmt, <span class="stringliteral">"table_version_get"</span>);
+<a name="l00299"></a>00299
+<a name="l00300"></a>00300 <span class="keywordflow">return</span> version;
+<a name="l00301"></a>00301 }
+<a name="l00302"></a>00302
+<a name="l00303"></a>00303 <span class="keywordtype">int</span>
+<a name="l00304"></a><a class="code" href="lightmediascanner__db__common_8c.html#46e6e318ea9bb4a7ffdfe40c842da4e7">00304</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)
+<a name="l00305"></a>00305 {
+<a name="l00306"></a>00306 <span class="keywordtype">int</span> r, ret;
+<a name="l00307"></a>00307 sqlite3_stmt *stmt;
+<a name="l00308"></a>00308
+<a name="l00309"></a>00309 stmt = <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
+<a name="l00310"></a>00310 <span class="stringliteral">"INSERT OR REPLACE INTO lms_internal (tab, version) VALUES (?, ?)"</span>);
+<a name="l00311"></a>00311 <span class="keywordflow">if</span> (!stmt)
+<a name="l00312"></a>00312 <span class="keywordflow">return</span> -1;
+<a name="l00313"></a>00313
+<a name="l00314"></a>00314 ret = <a class="code" href="lightmediascanner__db__common_8c.html#88c461ae88da3eb47987c5a0b15c5888">lms_db_bind_text</a>(stmt, 1, table, -1);
+<a name="l00315"></a>00315 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00316"></a>00316 <span class="keywordflow">goto</span> done;
+<a name="l00317"></a>00317
+<a name="l00318"></a>00318 ret = <a class="code" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a>(stmt, 2, version);
+<a name="l00319"></a>00319 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00320"></a>00320 <span class="keywordflow">goto</span> done;
+<a name="l00321"></a>00321
+<a name="l00322"></a>00322 r = sqlite3_step(stmt);
+<a name="l00323"></a>00323 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
+<a name="l00324"></a>00324 ret = -1;
+<a name="l00325"></a>00325 fprintf(stderr, <span class="stringliteral">"ERROR: could not set table '%s' version: %s\n"</span>,
+<a name="l00326"></a>00326 table, sqlite3_errmsg(db));
+<a name="l00327"></a>00327 }
+<a name="l00328"></a>00328
+<a name="l00329"></a>00329 done:
+<a name="l00330"></a>00330 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
+<a name="l00331"></a>00331 <a class="code" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5">lms_db_finalize_stmt</a>(stmt, <span class="stringliteral">"table_version_set"</span>);
+<a name="l00332"></a>00332
+<a name="l00333"></a>00333 <span class="keywordflow">return</span> ret;
+<a name="l00334"></a>00334 }
+<a name="l00335"></a>00335
+<a name="l00336"></a>00336 <span class="keywordtype">int</span>
+<a name="l00337"></a><a class="code" href="lightmediascanner__db__common_8c.html#9bca88ae79959baff3accee8ce10b558">00337</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#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> *updaters)
+<a name="l00338"></a>00338 {
+<a name="l00339"></a>00339 <span class="keywordflow">if</span> (current_version == last_version)
+<a name="l00340"></a>00340 <span class="keywordflow">return</span> 0;
+<a name="l00341"></a>00341 <span class="keywordflow">else</span> <span class="keywordflow">if</span> (current_version > last_version) {
+<a name="l00342"></a>00342 fprintf(stderr,
+<a name="l00343"></a>00343 <span class="stringliteral">"WARNING: current version (%d) of table '%s' is greater than "</span>
+<a name="l00344"></a>00344 <span class="stringliteral">"last known version (%d), no updates will be made.\n"</span>,
+<a name="l00345"></a>00345 current_version, table, last_version);
+<a name="l00346"></a>00346 <span class="keywordflow">return</span> 0;
+<a name="l00347"></a>00347 }
+<a name="l00348"></a>00348
+<a name="l00349"></a>00349 <span class="keywordflow">for</span> (; current_version < last_version; current_version++) {
+<a name="l00350"></a>00350 <span class="keywordtype">int</span> r, is_last_run;
+<a name="l00351"></a>00351
+<a name="l00352"></a>00352 is_last_run = current_version == (last_version - 1);
+<a name="l00353"></a>00353 r = updaters[current_version](db, table, current_version, is_last_run);
+<a name="l00354"></a>00354 <span class="keywordflow">if</span> (r != 0) {
+<a name="l00355"></a>00355 fprintf(stderr,
+<a name="l00356"></a>00356 <span class="stringliteral">"ERROR: could not update table '%s' from version %d->%d\n"</span>,
+<a name="l00357"></a>00357 table, current_version, current_version + 1);
+<a name="l00358"></a>00358 <span class="keywordflow">return</span> r;
+<a name="l00359"></a>00359 }
+<a name="l00360"></a>00360 <a class="code" href="lightmediascanner__db__common_8c.html#46e6e318ea9bb4a7ffdfe40c842da4e7">lms_db_table_version_set</a>(db, table, current_version + 1);
+<a name="l00361"></a>00361 }
+<a name="l00362"></a>00362
+<a name="l00363"></a>00363 <span class="keywordflow">return</span> 0;
+<a name="l00364"></a>00364 }
+<a name="l00365"></a>00365
+<a name="l00366"></a>00366 <span class="keywordtype">int</span>
+<a name="l00367"></a><a class="code" href="lightmediascanner__db__common_8c.html#86b766535f9dc7895da7d0f606201700">00367</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#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> *updaters)
+<a name="l00368"></a>00368 {
+<a name="l00369"></a>00369 <span class="keywordtype">int</span> current_version;
+<a name="l00370"></a>00370
+<a name="l00371"></a>00371 current_version = <a class="code" href="lightmediascanner__db__common_8c.html#eba3215ee5981a73e9d0fed0a7e079cd">lms_db_table_version_get</a>(db, table);
+<a name="l00372"></a>00372 <span class="keywordflow">if</span> (current_version < 0)
+<a name="l00373"></a>00373 <span class="keywordflow">return</span> -1;
+<a name="l00374"></a>00374 <span class="keywordflow">else</span>
+<a name="l00375"></a>00375 <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,
+<a name="l00376"></a>00376 updaters);
+<a name="l00377"></a>00377 }
+<a name="l00378"></a>00378
+<a name="l00379"></a>00379 <span class="keyword">static</span> <span class="keywordtype">int</span>
+<a name="l00380"></a>00380 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)
+<a name="l00381"></a>00381 {
+<a name="l00382"></a>00382 <span class="keywordtype">int</span> i;
+<a name="l00383"></a>00383
+<a name="l00384"></a>00384 <span class="keywordflow">for</span> (i = 0; i < cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a>; i++)
+<a name="l00385"></a>00385 <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)
+<a name="l00386"></a>00386 <span class="keywordflow">return</span> i;
+<a name="l00387"></a>00387
+<a name="l00388"></a>00388 <span class="keywordflow">return</span> -1;
+<a name="l00389"></a>00389 }
+<a name="l00390"></a>00390
+<a name="l00391"></a>00391 <span class="keyword">static</span> <span class="keywordtype">int</span>
+<a name="l00392"></a>00392 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)
+<a name="l00393"></a>00393 {
+<a name="l00394"></a>00394 cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> = new_size;
+<a name="l00395"></a>00395 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>,
+<a name="l00396"></a>00396 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>));
+<a name="l00397"></a>00397 <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>) {
+<a name="l00398"></a>00398 perror(<span class="stringliteral">"realloc"</span>);
+<a name="l00399"></a>00399 cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> = 0;
+<a name="l00400"></a>00400 <span class="keywordflow">return</span> -1;
+<a name="l00401"></a>00401 }
+<a name="l00402"></a>00402
+<a name="l00403"></a>00403 <span class="keywordflow">return</span> 0;
+<a name="l00404"></a>00404 }
+<a name="l00405"></a>00405
+<a name="l00406"></a>00406 <span class="keywordtype">int</span>
+<a name="l00407"></a><a class="code" href="lightmediascanner__db__common_8c.html#19b0458b9d7b76370588156e931a9c04">00407</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)
+<a name="l00408"></a>00408 {
+<a name="l00409"></a>00409 <span class="keyword">struct </span><a class="code" href="structlms__db__cache__entry.html">lms_db_cache_entry</a> *e;
+<a name="l00410"></a>00410 <span class="keywordtype">int</span> idx;
+<a name="l00411"></a>00411
+<a name="l00412"></a>00412 idx = lms_db_cache_find_db(cache, db);
+<a name="l00413"></a>00413 <span class="keywordflow">if</span> (idx >= 0) {
+<a name="l00414"></a>00414 e = cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a> + idx;
+<a name="l00415"></a>00415 <span class="keywordflow">if</span> (e-><a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a> == data)
+<a name="l00416"></a>00416 <span class="keywordflow">return</span> 0;
+<a name="l00417"></a>00417 <span class="keywordflow">else</span> {
+<a name="l00418"></a>00418 fprintf(stderr,
+<a name="l00419"></a>00419 <span class="stringliteral">"ERROR: cache %p for db %p has another data registered"</span>
+<a name="l00420"></a>00420 <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);
+<a name="l00421"></a>00421 <span class="keywordflow">return</span> -1;
+<a name="l00422"></a>00422 }
+<a name="l00423"></a>00423 }
+<a name="l00424"></a>00424
+<a name="l00425"></a>00425 idx = cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a>;
+<a name="l00426"></a>00426 <span class="keywordflow">if</span> (lms_db_cache_resize(cache, cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> + 1) != 0) {
+<a name="l00427"></a>00427 <span class="keywordflow">return</span> -2;
+<a name="l00428"></a>00428 }
+<a name="l00429"></a>00429
+<a name="l00430"></a>00430 e = cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a> + idx;
+<a name="l00431"></a>00431 e-><a class="code" href="structlms__db__cache__entry.html#01aadf6d9a8161696019d39566b15760">db</a> = db;
+<a name="l00432"></a>00432 e-><a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a> = data;
+<a name="l00433"></a>00433 <span class="keywordflow">return</span> 0;
+<a name="l00434"></a>00434 }
+<a name="l00435"></a>00435
+<a name="l00436"></a>00436 <span class="keywordtype">int</span>
+<a name="l00437"></a><a class="code" href="lightmediascanner__db__common_8c.html#296c81e4c64be1c7935ef31038aeb2c0">00437</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>)
+<a name="l00438"></a>00438 {
+<a name="l00439"></a>00439 <span class="keywordtype">int</span> idx;
+<a name="l00440"></a>00440 <span class="keyword">struct </span><a class="code" href="structlms__db__cache__entry.html">lms_db_cache_entry</a> *e;
+<a name="l00441"></a>00441
+<a name="l00442"></a>00442 idx = lms_db_cache_find_db(cache, db);
+<a name="l00443"></a>00443 <span class="keywordflow">if</span> (idx < 0) {
+<a name="l00444"></a>00444 fprintf(stderr, <span class="stringliteral">"ERROR: no db %p found in cache %p\n"</span>, db, cache);
+<a name="l00445"></a>00445 <span class="keywordflow">return</span> -1;
+<a name="l00446"></a>00446 }
+<a name="l00447"></a>00447
+<a name="l00448"></a>00448 e = cache-><a class="code" href="structlms__db__cache.html#0056bfe95b38863dc9b067d699230690">entries</a> + idx;
+<a name="l00449"></a>00449 <span class="keywordflow">if</span> (e-><a class="code" href="structlms__db__cache__entry.html#53488063740ff72c830be3103e7150fe">data</a> != data) {
+<a name="l00450"></a>00450 fprintf(stderr, <span class="stringliteral">"ERROR: data mismatch in request to delete from cache: "</span>
+<a name="l00451"></a>00451 <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);
+<a name="l00452"></a>00452 <span class="keywordflow">return</span> -2;
+<a name="l00453"></a>00453 }
+<a name="l00454"></a>00454
+<a name="l00455"></a>00455 <span class="keywordflow">for</span> (; idx < cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> - 1; idx++)
+<a name="l00456"></a>00456 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];
+<a name="l00457"></a>00457
+<a name="l00458"></a>00458 <span class="keywordflow">return</span> lms_db_cache_resize(cache, cache-><a class="code" href="structlms__db__cache.html#b325e01e42fd3b0f11d52328522c6414">size</a> - 1);
+<a name="l00459"></a>00459 }
+<a name="l00460"></a>00460
+<a name="l00461"></a>00461 <span class="keywordtype">int</span>
+<a name="l00462"></a><a class="code" href="lightmediascanner__db__common_8c.html#e7a672fa5760bae1a669c737648fe7d3">00462</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)
+<a name="l00463"></a>00463 {
+<a name="l00464"></a>00464 <span class="keywordtype">int</span> idx;
+<a name="l00465"></a>00465
+<a name="l00466"></a>00466 idx = lms_db_cache_find_db(cache, db);
+<a name="l00467"></a>00467 <span class="keywordflow">if</span> (idx < 0)
+<a name="l00468"></a>00468 <span class="keywordflow">return</span> -1;
+<a name="l00469"></a>00469
+<a name="l00470"></a>00470 *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>;
+<a name="l00471"></a>00471 <span class="keywordflow">return</span> 0;
+<a name="l00472"></a>00472 }
+<a name="l00473"></a>00473
+<a name="l00474"></a>00474 <span class="keywordtype">int</span>
+<a name="l00475"></a><a class="code" href="lightmediascanner__db__private_8h.html#13ca09c885535a2968e707120e935268">00475</a> <a class="code" href="lightmediascanner__db__common_8c.html#3798a46baaedc4d466879865456acc94">lms_db_create_core_tables_if_required</a>(sqlite3 *db)
+<a name="l00476"></a>00476 {
+<a name="l00477"></a>00477 <span class="keywordtype">char</span> *errmsg;
+<a name="l00478"></a>00478 <span class="keywordtype">int</span> r;
+<a name="l00479"></a>00479
+<a name="l00480"></a>00480 errmsg = NULL;
+<a name="l00481"></a>00481 r = sqlite3_exec(db,
+<a name="l00482"></a>00482 <span class="stringliteral">"CREATE TABLE IF NOT EXISTS lms_internal ("</span>
+<a name="l00483"></a>00483 <span class="stringliteral">"tab TEXT NOT NULL UNIQUE, "</span>
+<a name="l00484"></a>00484 <span class="stringliteral">"version INTEGER NOT NULL"</span>
+<a name="l00485"></a>00485 <span class="stringliteral">")"</span>,
+<a name="l00486"></a>00486 NULL, NULL, &errmsg);
+<a name="l00487"></a>00487 <span class="keywordflow">if</span> (r != SQLITE_OK) {
+<a name="l00488"></a>00488 fprintf(stderr, <span class="stringliteral">"ERROR: could not create 'lms_internal' table: %s\n"</span>,
+<a name="l00489"></a>00489 errmsg);
+<a name="l00490"></a>00490 sqlite3_free(errmsg);
+<a name="l00491"></a>00491 <span class="keywordflow">return</span> -1;
+<a name="l00492"></a>00492 }
+<a name="l00493"></a>00493
+<a name="l00494"></a>00494 r = sqlite3_exec(db,
+<a name="l00495"></a>00495 <span class="stringliteral">"CREATE TABLE IF NOT EXISTS files ("</span>
+<a name="l00496"></a>00496 <span class="stringliteral">"id INTEGER PRIMARY KEY AUTOINCREMENT, "</span>
+<a name="l00497"></a>00497 <span class="stringliteral">"path BLOB NOT NULL UNIQUE, "</span>
+<a name="l00498"></a>00498 <span class="stringliteral">"mtime INTEGER NOT NULL, "</span>
+<a name="l00499"></a>00499 <span class="stringliteral">"dtime INTEGER NOT NULL, "</span>
+<a name="l00500"></a>00500 <span class="stringliteral">"size INTEGER NOT NULL"</span>
+<a name="l00501"></a>00501 <span class="stringliteral">")"</span>,
+<a name="l00502"></a>00502 NULL, NULL, &errmsg);
+<a name="l00503"></a>00503 <span class="keywordflow">if</span> (r != SQLITE_OK) {
+<a name="l00504"></a>00504 fprintf(stderr, <span class="stringliteral">"ERROR: could not create 'files' table: %s\n"</span>, errmsg);
+<a name="l00505"></a>00505 sqlite3_free(errmsg);
+<a name="l00506"></a>00506 <span class="keywordflow">return</span> -2;
+<a name="l00507"></a>00507 }
+<a name="l00508"></a>00508
+<a name="l00509"></a>00509 r = sqlite3_exec(db,
+<a name="l00510"></a>00510 <span class="stringliteral">"CREATE INDEX IF NOT EXISTS files_path_idx ON files ("</span>
+<a name="l00511"></a>00511 <span class="stringliteral">"path"</span>
+<a name="l00512"></a>00512 <span class="stringliteral">")"</span>,
+<a name="l00513"></a>00513 NULL, NULL, &errmsg);
+<a name="l00514"></a>00514 <span class="keywordflow">if</span> (r != SQLITE_OK) {
+<a name="l00515"></a>00515 fprintf(stderr, <span class="stringliteral">"ERROR: could not create 'files_path_idx' index: %s\n"</span>,
+<a name="l00516"></a>00516 errmsg);
+<a name="l00517"></a>00517 sqlite3_free(errmsg);
+<a name="l00518"></a>00518 <span class="keywordflow">return</span> -3;
+<a name="l00519"></a>00519 }
+<a name="l00520"></a>00520
+<a name="l00521"></a>00521 <span class="keywordflow">return</span> 0;
+<a name="l00522"></a>00522 }
+<a name="l00523"></a>00523
+<a name="l00524"></a>00524
+<a name="l00525"></a>00525 sqlite3_stmt *
+<a name="l00526"></a><a class="code" href="lightmediascanner__db__private_8h.html#073c254ca7b4d3f42e1be1854bcc42a3">00526</a> <a class="code" href="lightmediascanner__db__common_8c.html#1787fdaf148358c7a518e91dfd871ca1">lms_db_compile_stmt_begin_transaction</a>(sqlite3 *db)
+<a name="l00527"></a>00527 {
+<a name="l00528"></a>00528 <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>);
+<a name="l00529"></a>00529 }
+<a name="l00530"></a>00530
+<a name="l00531"></a>00531 <span class="keywordtype">int</span>
+<a name="l00532"></a><a class="code" href="lightmediascanner__db__private_8h.html#3a7256cb653542bbf563feeb2aa2d0ea">00532</a> <a class="code" href="lightmediascanner__db__common_8c.html#5ff807216285c93325ffaf33361dd6fc">lms_db_begin_transaction</a>(sqlite3_stmt *stmt)
+<a name="l00533"></a>00533 {
+<a name="l00534"></a>00534 <span class="keywordtype">int</span> r, ret;
+<a name="l00535"></a>00535
+<a name="l00536"></a>00536 ret = 0;
+<a name="l00537"></a>00537 r = sqlite3_step(stmt);
+<a name="l00538"></a>00538 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
+<a name="l00539"></a>00539 fprintf(stderr, <span class="stringliteral">"ERROR: could not begin transaction: %s\n"</span>,
+<a name="l00540"></a>00540 sqlite3_errmsg(sqlite3_db_handle(stmt)));
+<a name="l00541"></a>00541 ret = -1;
+<a name="l00542"></a>00542 }
+<a name="l00543"></a>00543
+<a name="l00544"></a>00544 r = sqlite3_reset(stmt);
+<a name="l00545"></a>00545 <span class="keywordflow">if</span> (r != SQLITE_OK)
+<a name="l00546"></a>00546 fprintf(stderr, <span class="stringliteral">"ERROR: could not reset SQL statement: %s\n"</span>,
+<a name="l00547"></a>00547 sqlite3_errmsg(sqlite3_db_handle(stmt)));
+<a name="l00548"></a>00548
+<a name="l00549"></a>00549 <span class="keywordflow">return</span> ret;
+<a name="l00550"></a>00550 }
+<a name="l00551"></a>00551
+<a name="l00552"></a>00552 sqlite3_stmt *
+<a name="l00553"></a><a class="code" href="lightmediascanner__db__private_8h.html#09feca4fbfde33d5647cdd5cc2de6500">00553</a> <a class="code" href="lightmediascanner__db__common_8c.html#bff1aa6077215f3d70d4d5b1a9b7a498">lms_db_compile_stmt_end_transaction</a>(sqlite3 *db)
+<a name="l00554"></a>00554 {
+<a name="l00555"></a>00555 <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>);
+<a name="l00556"></a>00556 }
+<a name="l00557"></a>00557
+<a name="l00558"></a>00558 <span class="keywordtype">int</span>
+<a name="l00559"></a><a class="code" href="lightmediascanner__db__private_8h.html#8ee7bfba83958b80f717a6ccbad2a84c">00559</a> <a class="code" href="lightmediascanner__db__common_8c.html#ffa877e4fa751f090e7af8c2025d245c">lms_db_end_transaction</a>(sqlite3_stmt *stmt)
+<a name="l00560"></a>00560 {
+<a name="l00561"></a>00561 <span class="keywordtype">int</span> r, ret;
+<a name="l00562"></a>00562
+<a name="l00563"></a>00563 ret = 0;
+<a name="l00564"></a>00564 r = sqlite3_step(stmt);
+<a name="l00565"></a>00565 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
+<a name="l00566"></a>00566 fprintf(stderr, <span class="stringliteral">"ERROR: could not end transaction: %s\n"</span>,
+<a name="l00567"></a>00567 sqlite3_errmsg(sqlite3_db_handle(stmt)));
+<a name="l00568"></a>00568 ret = -1;
+<a name="l00569"></a>00569 }
+<a name="l00570"></a>00570
+<a name="l00571"></a>00571 r = sqlite3_reset(stmt);
+<a name="l00572"></a>00572 <span class="keywordflow">if</span> (r != SQLITE_OK)
+<a name="l00573"></a>00573 fprintf(stderr, <span class="stringliteral">"ERROR: could not reset SQL statement: %s\n"</span>,
+<a name="l00574"></a>00574 sqlite3_errmsg(sqlite3_db_handle(stmt)));
+<a name="l00575"></a>00575
+<a name="l00576"></a>00576 <span class="keywordflow">return</span> ret;
+<a name="l00577"></a>00577 }
+<a name="l00578"></a>00578
+<a name="l00579"></a>00579 sqlite3_stmt *
+<a name="l00580"></a><a class="code" href="lightmediascanner__db__private_8h.html#327d54a6dac083e356fd609298a0cbd5">00580</a> <a class="code" href="lightmediascanner__db__common_8c.html#b00a624bc01da9b796f7bc6e1d507cf8">lms_db_compile_stmt_get_file_info</a>(sqlite3 *db)
+<a name="l00581"></a>00581 {
+<a name="l00582"></a>00582 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
+<a name="l00583"></a>00583 <span class="stringliteral">"SELECT id, mtime, dtime, size FROM files WHERE path = ?"</span>);
+<a name="l00584"></a>00584 }
+<a name="l00585"></a>00585
+<a name="l00586"></a>00586 <span class="keywordtype">int</span>
+<a name="l00587"></a><a class="code" href="lightmediascanner__db__common_8c.html#c0b7cf0b2eb0f55fbf8a4103bc9569d1">00587</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)
+<a name="l00588"></a>00588 {
+<a name="l00589"></a>00589 <span class="keywordtype">int</span> r, ret;
+<a name="l00590"></a>00590
+<a name="l00591"></a>00591 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>);
+<a name="l00592"></a>00592 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00593"></a>00593 <span class="keywordflow">goto</span> done;
+<a name="l00594"></a>00594
+<a name="l00595"></a>00595 r = sqlite3_step(stmt);
+<a name="l00596"></a>00596 <span class="keywordflow">if</span> (r == SQLITE_DONE) {
+<a name="l00597"></a>00597 ret = 1;
+<a name="l00598"></a>00598 finfo-><a class="code" href="structlms__file__info.html#d68ded5c64ae28a4976637f8483e9cfe">id</a> = -1;
+<a name="l00599"></a>00599 <span class="keywordflow">goto</span> done;
+<a name="l00600"></a>00600 }
+<a name="l00601"></a>00601
+<a name="l00602"></a>00602 <span class="keywordflow">if</span> (r != SQLITE_ROW) {
+<a name="l00603"></a>00603 fprintf(stderr, <span class="stringliteral">"ERROR: could not get file info from table: %s\n"</span>,
+<a name="l00604"></a>00604 sqlite3_errmsg(sqlite3_db_handle(stmt)));
+<a name="l00605"></a>00605 ret = -2;
+<a name="l00606"></a>00606 <span class="keywordflow">goto</span> done;
+<a name="l00607"></a>00607 }
+<a name="l00608"></a>00608
+<a name="l00609"></a>00609 finfo-><a class="code" href="structlms__file__info.html#d68ded5c64ae28a4976637f8483e9cfe">id</a> = sqlite3_column_int64(stmt, 0);
+<a name="l00610"></a>00610 finfo-><a class="code" href="structlms__file__info.html#4aa878eefdde84541021087192b9dacd">mtime</a> = sqlite3_column_int(stmt, 1);
+<a name="l00611"></a>00611 finfo-><a class="code" href="structlms__file__info.html#570ae808983e67ae7b22a2fec892cffd">dtime</a> = sqlite3_column_int(stmt, 2);
+<a name="l00612"></a>00612 finfo-><a class="code" href="structlms__file__info.html#b318b81fc934636a904f5d84efe8c1ee">size</a> = sqlite3_column_int(stmt, 3);
+<a name="l00613"></a>00613 ret = 0;
+<a name="l00614"></a>00614
+<a name="l00615"></a>00615 done:
+<a name="l00616"></a>00616 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
+<a name="l00617"></a>00617
+<a name="l00618"></a>00618 <span class="keywordflow">return</span> ret;
+<a name="l00619"></a>00619 }
+<a name="l00620"></a>00620
+<a name="l00621"></a>00621 sqlite3_stmt *
+<a name="l00622"></a><a class="code" href="lightmediascanner__db__private_8h.html#69eb9d9058d9432f7658f9adffb79ed6">00622</a> <a class="code" href="lightmediascanner__db__common_8c.html#1e6e76cfa9d6faa3c3b8035004eff1a0">lms_db_compile_stmt_update_file_info</a>(sqlite3 *db)
+<a name="l00623"></a>00623 {
+<a name="l00624"></a>00624 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
+<a name="l00625"></a>00625 <span class="stringliteral">"UPDATE files SET mtime = ?, dtime = ?, size = ? WHERE id = ?"</span>);
+<a name="l00626"></a>00626 }
+<a name="l00627"></a>00627
+<a name="l00628"></a>00628 <span class="keywordtype">int</span>
+<a name="l00629"></a><a class="code" href="lightmediascanner__db__common_8c.html#0f727cd41bbb90af2e08b3ee7ca76de9">00629</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)
+<a name="l00630"></a>00630 {
+<a name="l00631"></a>00631 <span class="keywordtype">int</span> r, ret;
+<a name="l00632"></a>00632
+<a name="l00633"></a>00633 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>);
+<a name="l00634"></a>00634 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00635"></a>00635 <span class="keywordflow">goto</span> done;
+<a name="l00636"></a>00636
+<a name="l00637"></a>00637 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>);
+<a name="l00638"></a>00638 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00639"></a>00639 <span class="keywordflow">goto</span> done;
+<a name="l00640"></a>00640
+<a name="l00641"></a>00641 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>);
+<a name="l00642"></a>00642 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00643"></a>00643 <span class="keywordflow">goto</span> done;
+<a name="l00644"></a>00644
+<a name="l00645"></a>00645 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>);
+<a name="l00646"></a>00646 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00647"></a>00647 <span class="keywordflow">goto</span> done;
+<a name="l00648"></a>00648
+<a name="l00649"></a>00649 r = sqlite3_step(stmt);
+<a name="l00650"></a>00650 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
+<a name="l00651"></a>00651 fprintf(stderr, <span class="stringliteral">"ERROR: could not update file info: %s\n"</span>,
+<a name="l00652"></a>00652 sqlite3_errmsg(sqlite3_db_handle(stmt)));
+<a name="l00653"></a>00653 ret = -5;
+<a name="l00654"></a>00654 <span class="keywordflow">goto</span> done;
+<a name="l00655"></a>00655 }
+<a name="l00656"></a>00656
+<a name="l00657"></a>00657 ret = 0;
+<a name="l00658"></a>00658
+<a name="l00659"></a>00659 done:
+<a name="l00660"></a>00660 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
+<a name="l00661"></a>00661
+<a name="l00662"></a>00662 <span class="keywordflow">return</span> ret;
+<a name="l00663"></a>00663 }
+<a name="l00664"></a>00664
+<a name="l00665"></a>00665 sqlite3_stmt *
+<a name="l00666"></a><a class="code" href="lightmediascanner__db__private_8h.html#bf21f88ddbe28a8290d0df32af0f079c">00666</a> <a class="code" href="lightmediascanner__db__common_8c.html#9a5886e755eb428ac811956144eee0dc">lms_db_compile_stmt_insert_file_info</a>(sqlite3 *db)
+<a name="l00667"></a>00667 {
+<a name="l00668"></a>00668 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
+<a name="l00669"></a>00669 <span class="stringliteral">"INSERT INTO files (path, mtime, dtime, size) VALUES(?, ?, ?, ?)"</span>);
+<a name="l00670"></a>00670 }
+<a name="l00671"></a>00671
+<a name="l00672"></a>00672 <span class="keywordtype">int</span>
+<a name="l00673"></a><a class="code" href="lightmediascanner__db__common_8c.html#e529ad5c4478d53685c65ec69dc5b1f4">00673</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)
+<a name="l00674"></a>00674 {
+<a name="l00675"></a>00675 <span class="keywordtype">int</span> r, ret;
+<a name="l00676"></a>00676
+<a name="l00677"></a>00677 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>);
+<a name="l00678"></a>00678 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00679"></a>00679 <span class="keywordflow">goto</span> done;
+<a name="l00680"></a>00680
+<a name="l00681"></a>00681 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>);
+<a name="l00682"></a>00682 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00683"></a>00683 <span class="keywordflow">goto</span> done;
+<a name="l00684"></a>00684
+<a name="l00685"></a>00685 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>);
+<a name="l00686"></a>00686 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00687"></a>00687 <span class="keywordflow">goto</span> done;
+<a name="l00688"></a>00688
+<a name="l00689"></a>00689 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>);
+<a name="l00690"></a>00690 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00691"></a>00691 <span class="keywordflow">goto</span> done;
+<a name="l00692"></a>00692
+<a name="l00693"></a>00693 r = sqlite3_step(stmt);
+<a name="l00694"></a>00694 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
+<a name="l00695"></a>00695 fprintf(stderr, <span class="stringliteral">"ERROR: could not insert file info: %s\n"</span>,
+<a name="l00696"></a>00696 sqlite3_errmsg(sqlite3_db_handle(stmt)));
+<a name="l00697"></a>00697 ret = -5;
+<a name="l00698"></a>00698 <span class="keywordflow">goto</span> done;
+<a name="l00699"></a>00699 }
+<a name="l00700"></a>00700
+<a name="l00701"></a>00701 finfo-><a class="code" href="structlms__file__info.html#d68ded5c64ae28a4976637f8483e9cfe">id</a> = sqlite3_last_insert_rowid(sqlite3_db_handle(stmt));
+<a name="l00702"></a>00702 ret = 0;
+<a name="l00703"></a>00703
+<a name="l00704"></a>00704 done:
+<a name="l00705"></a>00705 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
+<a name="l00706"></a>00706
+<a name="l00707"></a>00707 <span class="keywordflow">return</span> ret;
+<a name="l00708"></a>00708 }
+<a name="l00709"></a>00709
+<a name="l00710"></a>00710 sqlite3_stmt *
+<a name="l00711"></a><a class="code" href="lightmediascanner__db__private_8h.html#76941bdbbdb711fff821343e91c2cd97">00711</a> <a class="code" href="lightmediascanner__db__common_8c.html#559925f8e4d5bf61d1bcf44844a95699">lms_db_compile_stmt_delete_file_info</a>(sqlite3 *db)
+<a name="l00712"></a>00712 {
+<a name="l00713"></a>00713 <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>);
+<a name="l00714"></a>00714 }
+<a name="l00715"></a>00715
+<a name="l00716"></a>00716 <span class="keywordtype">int</span>
+<a name="l00717"></a><a class="code" href="lightmediascanner__db__common_8c.html#bb2a9cdbbc7680d1ec85ef3f086b3f63">00717</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)
+<a name="l00718"></a>00718 {
+<a name="l00719"></a>00719 <span class="keywordtype">int</span> r, ret;
+<a name="l00720"></a>00720
+<a name="l00721"></a>00721 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>);
+<a name="l00722"></a>00722 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00723"></a>00723 <span class="keywordflow">goto</span> done;
+<a name="l00724"></a>00724
+<a name="l00725"></a>00725 r = sqlite3_step(stmt);
+<a name="l00726"></a>00726 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
+<a name="l00727"></a>00727 fprintf(stderr, <span class="stringliteral">"ERROR: could not delete file info: %s\n"</span>,
+<a name="l00728"></a>00728 sqlite3_errmsg(sqlite3_db_handle(stmt)));
+<a name="l00729"></a>00729 ret = -2;
+<a name="l00730"></a>00730 <span class="keywordflow">goto</span> done;
+<a name="l00731"></a>00731 }
+<a name="l00732"></a>00732 ret = 0;
+<a name="l00733"></a>00733
+<a name="l00734"></a>00734 done:
+<a name="l00735"></a>00735 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
+<a name="l00736"></a>00736
+<a name="l00737"></a>00737 <span class="keywordflow">return</span> ret;
+<a name="l00738"></a>00738 }
+<a name="l00739"></a>00739
+<a name="l00740"></a>00740 sqlite3_stmt *
+<a name="l00741"></a><a class="code" href="lightmediascanner__db__private_8h.html#08c34b5b1b6e927a696ff0ce66562f54">00741</a> <a class="code" href="lightmediascanner__db__common_8c.html#1b6950ca9e548670a4cb7fd0ec5220a8">lms_db_compile_stmt_set_file_dtime</a>(sqlite3 *db)
+<a name="l00742"></a>00742 {
+<a name="l00743"></a>00743 <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>);
+<a name="l00744"></a>00744 }
+<a name="l00745"></a>00745
+<a name="l00746"></a>00746 <span class="keywordtype">int</span>
+<a name="l00747"></a><a class="code" href="lightmediascanner__db__common_8c.html#024e3bd9385fd740f75618716c90b04f">00747</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)
+<a name="l00748"></a>00748 {
+<a name="l00749"></a>00749 <span class="keywordtype">int</span> r, ret;
+<a name="l00750"></a>00750
+<a name="l00751"></a>00751 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>);
+<a name="l00752"></a>00752 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00753"></a>00753 <span class="keywordflow">goto</span> done;
+<a name="l00754"></a>00754
+<a name="l00755"></a>00755 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>);
+<a name="l00756"></a>00756 <span class="keywordflow">if</span> (ret != 0)
+<a name="l00757"></a>00757 <span class="keywordflow">goto</span> done;
+<a name="l00758"></a>00758
+<a name="l00759"></a>00759 r = sqlite3_step(stmt);
+<a name="l00760"></a>00760 <span class="keywordflow">if</span> (r != SQLITE_DONE) {
+<a name="l00761"></a>00761 fprintf(stderr, <span class="stringliteral">"ERROR: could not set file dtime: %s\n"</span>,
+<a name="l00762"></a>00762 sqlite3_errmsg(sqlite3_db_handle(stmt)));
+<a name="l00763"></a>00763 ret = -3;
+<a name="l00764"></a>00764 <span class="keywordflow">goto</span> done;
+<a name="l00765"></a>00765 }
+<a name="l00766"></a>00766
+<a name="l00767"></a>00767 ret = 0;
+<a name="l00768"></a>00768
+<a name="l00769"></a>00769 done:
+<a name="l00770"></a>00770 <a class="code" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a>(stmt);
+<a name="l00771"></a>00771
+<a name="l00772"></a>00772 <span class="keywordflow">return</span> ret;
+<a name="l00773"></a>00773 }
+<a name="l00774"></a>00774
+<a name="l00775"></a>00775 sqlite3_stmt *
+<a name="l00776"></a><a class="code" href="lightmediascanner__db__private_8h.html#1cc8a80961a0febdd099a028f3da9c30">00776</a> <a class="code" href="lightmediascanner__db__common_8c.html#73ae2cfd7babf80294cf31f02906223b">lms_db_compile_stmt_get_files</a>(sqlite3 *db)
+<a name="l00777"></a>00777 {
+<a name="l00778"></a>00778 <span class="keywordflow">return</span> <a class="code" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a>(db,
+<a name="l00779"></a>00779 <span class="stringliteral">"SELECT id, path, mtime, dtime, size FROM files WHERE path LIKE ?"</span>);
+<a name="l00780"></a>00780 }
+<a name="l00781"></a>00781
+<a name="l00782"></a>00782 <span class="keywordtype">int</span>
+<a name="l00783"></a><a class="code" href="lightmediascanner__db__common_8c.html#df572e74e0821a66ebd16f575b4fb7c4">00783</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)
+<a name="l00784"></a>00784 {
+<a name="l00785"></a>00785 <span class="keywordtype">int</span> ret;
+<a name="l00786"></a>00786
+<a name="l00787"></a>00787 ret = <a class="code" href="lightmediascanner__db__common_8c.html#fee26461dbd6c89c82794c94aaeeaef6">lms_db_bind_blob</a>(stmt, 1, path, len);
+<a name="l00788"></a>00788 <span class="keywordflow">return</span> ret;
+<a name="l00789"></a>00789 }
+</pre></div></div>
+<hr size="1"><address style="text-align: right;"><small>Generated on Wed Apr 22 23:56:01 2009 for Light Media Scanner by
+<a href="http://www.doxygen.org/index.html">
+<img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.8 </small></address>
+</body>
+</html>
projects / lms / blobdiff