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 File Reference</title>
4 <link href="tabs.css" rel="stylesheet" type="text/css">
5 <link href="doxygen.css" rel="stylesheet" type="text/css">
7 <!-- Generated by Doxygen 1.5.8 -->
8 <div class="navigation" id="top">
11 <li><a href="index.html"><span>Main Page</span></a></li>
12 <li><a href="modules.html"><span>Modules</span></a></li>
13 <li><a href="annotated.html"><span>Data Structures</span></a></li>
14 <li class="current"><a href="files.html"><span>Files</span></a></li>
19 <li><a href="files.html"><span>File List</span></a></li>
20 <li><a href="globals.html"><span>Globals</span></a></li>
24 <div class="contents">
25 <h1>src/lib/lightmediascanner_db_common.c File Reference</h1><code>#include "<a class="el" href="lightmediascanner__db__private_8h-source.html">lightmediascanner_db_private.h</a>"</code><br>
26 <code>#include <stdlib.h></code><br>
27 <code>#include <stdio.h></code><br>
28 <code>#include <string.h></code><br>
31 <div class="dynheader">
32 Include dependency graph for lightmediascanner_db_common.c:</div>
33 <div class="dynsection">
37 <a href="lightmediascanner__db__common_8c-source.html">Go to the source code of this file.</a><table border="0" cellpadding="0" cellspacing="0">
39 <tr><td colspan="2"><br><h2>Functions</h2></td></tr>
40 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405">sqlite3_prepare_v2</a> (sqlite3 *db, const char *sql, int len, sqlite3_stmt **stmt, const char **tail)</td></tr>
42 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00">sqlite3_clear_bindings</a> (sqlite3_stmt *stmt)</td></tr>
44 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#822cae681398710b63c9af149fdacedb">lms_db_create_trigger_if_not_exists</a> (sqlite3 *db, const char *sql)</td></tr>
46 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b">lms_db_compile_stmt</a> (sqlite3 *db, const char *sql)</td></tr>
48 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5">lms_db_finalize_stmt</a> (sqlite3_stmt *stmt, const char *name)</td></tr>
50 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419">lms_db_reset_stmt</a> (sqlite3_stmt *stmt)</td></tr>
52 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#88c461ae88da3eb47987c5a0b15c5888">lms_db_bind_text</a> (sqlite3_stmt *stmt, int col, const char *text, int len)</td></tr>
54 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#fee26461dbd6c89c82794c94aaeeaef6">lms_db_bind_blob</a> (sqlite3_stmt *stmt, int col, const void *blob, int len)</td></tr>
56 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#f2fe78bc45dc33d843313a846db5ce7c">lms_db_bind_int64</a> (sqlite3_stmt *stmt, int col, int64_t value)</td></tr>
58 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#2a0a5d3a27fdee8508b2b0cc59979417">lms_db_bind_int64_or_null</a> (sqlite3_stmt *stmt, int col, int64_t *p_value)</td></tr>
60 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f">lms_db_bind_int</a> (sqlite3_stmt *stmt, int col, int value)</td></tr>
62 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#4ae660a876f1e362d1ab2f8c68bdef3f">lms_db_bind_double</a> (sqlite3_stmt *stmt, int col, double value)</td></tr>
64 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#eba3215ee5981a73e9d0fed0a7e079cd">lms_db_table_version_get</a> (sqlite3 *db, const char *table)</td></tr>
66 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#46e6e318ea9bb4a7ffdfe40c842da4e7">lms_db_table_version_set</a> (sqlite3 *db, const char *table, unsigned int version)</td></tr>
68 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#9bca88ae79959baff3accee8ce10b558">lms_db_table_update</a> (sqlite3 *db, const char *table, unsigned int current_version, unsigned int last_version, const <a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> *updaters)</td></tr>
70 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#86b766535f9dc7895da7d0f606201700">lms_db_table_update_if_required</a> (sqlite3 *db, const char *table, unsigned int last_version, <a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> *updaters)</td></tr>
72 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#19b0458b9d7b76370588156e931a9c04">lms_db_cache_add</a> (struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> *cache, const sqlite3 *db, void *data)</td></tr>
74 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#296c81e4c64be1c7935ef31038aeb2c0">lms_db_cache_del</a> (struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> *cache, const sqlite3 *db, void *data)</td></tr>
76 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#e7a672fa5760bae1a669c737648fe7d3">lms_db_cache_get</a> (struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> *cache, const sqlite3 *db, void **pdata)</td></tr>
78 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#3798a46baaedc4d466879865456acc94">lms_db_create_core_tables_if_required</a> (sqlite3 *db)</td></tr>
80 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#1787fdaf148358c7a518e91dfd871ca1">lms_db_compile_stmt_begin_transaction</a> (sqlite3 *db)</td></tr>
82 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#5ff807216285c93325ffaf33361dd6fc">lms_db_begin_transaction</a> (sqlite3_stmt *stmt)</td></tr>
84 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#bff1aa6077215f3d70d4d5b1a9b7a498">lms_db_compile_stmt_end_transaction</a> (sqlite3 *db)</td></tr>
86 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#ffa877e4fa751f090e7af8c2025d245c">lms_db_end_transaction</a> (sqlite3_stmt *stmt)</td></tr>
88 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#b00a624bc01da9b796f7bc6e1d507cf8">lms_db_compile_stmt_get_file_info</a> (sqlite3 *db)</td></tr>
90 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#c0b7cf0b2eb0f55fbf8a4103bc9569d1">lms_db_get_file_info</a> (sqlite3_stmt *stmt, struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo)</td></tr>
92 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#1e6e76cfa9d6faa3c3b8035004eff1a0">lms_db_compile_stmt_update_file_info</a> (sqlite3 *db)</td></tr>
94 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#0f727cd41bbb90af2e08b3ee7ca76de9">lms_db_update_file_info</a> (sqlite3_stmt *stmt, const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo)</td></tr>
96 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#9a5886e755eb428ac811956144eee0dc">lms_db_compile_stmt_insert_file_info</a> (sqlite3 *db)</td></tr>
98 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#e529ad5c4478d53685c65ec69dc5b1f4">lms_db_insert_file_info</a> (sqlite3_stmt *stmt, struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo)</td></tr>
100 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#559925f8e4d5bf61d1bcf44844a95699">lms_db_compile_stmt_delete_file_info</a> (sqlite3 *db)</td></tr>
102 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#bb2a9cdbbc7680d1ec85ef3f086b3f63">lms_db_delete_file_info</a> (sqlite3_stmt *stmt, const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo)</td></tr>
104 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#1b6950ca9e548670a4cb7fd0ec5220a8">lms_db_compile_stmt_set_file_dtime</a> (sqlite3 *db)</td></tr>
106 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#024e3bd9385fd740f75618716c90b04f">lms_db_set_file_dtime</a> (sqlite3_stmt *stmt, const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo)</td></tr>
108 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#73ae2cfd7babf80294cf31f02906223b">lms_db_compile_stmt_get_files</a> (sqlite3 *db)</td></tr>
110 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__common_8c.html#df572e74e0821a66ebd16f575b4fb7c4">lms_db_get_files</a> (sqlite3_stmt *stmt, const char *path, int len)</td></tr>
113 <hr><h2>Function Documentation</h2>
114 <a class="anchor" name="5ff807216285c93325ffaf33361dd6fc"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_begin_transaction" ref="5ff807216285c93325ffaf33361dd6fc" args="(sqlite3_stmt *stmt)" -->
115 <div class="memitem">
116 <div class="memproto">
117 <table class="memname">
119 <td class="memname">int lms_db_begin_transaction </td>
121 <td class="paramtype">sqlite3_stmt * </td>
122 <td class="paramname"> <em>stmt</em> </td>
123 <td> ) </td>
132 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00532">532</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
134 <p>Referenced by <a class="el" href="lightmediascanner__process_8c-source.html#l01047">lms_process_single_process()</a>.</p>
138 <a class="anchor" name="fee26461dbd6c89c82794c94aaeeaef6"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_bind_blob" ref="fee26461dbd6c89c82794c94aaeeaef6" args="(sqlite3_stmt *stmt, int col, const void *blob, int len)" -->
139 <div class="memitem">
140 <div class="memproto">
141 <table class="memname">
143 <td class="memname">int lms_db_bind_blob </td>
145 <td class="paramtype">sqlite3_stmt * </td>
146 <td class="paramname"> <em>stmt</em>, </td>
149 <td class="paramkey"></td>
151 <td class="paramtype">int </td>
152 <td class="paramname"> <em>col</em>, </td>
155 <td class="paramkey"></td>
157 <td class="paramtype">const void * </td>
158 <td class="paramname"> <em>blob</em>, </td>
161 <td class="paramkey"></td>
163 <td class="paramtype">int </td>
164 <td class="paramname"> <em>len</em></td><td> </td>
169 <td></td><td></td><td></td>
177 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00168">168</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
179 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00587">lms_db_get_file_info()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00783">lms_db_get_files()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00673">lms_db_insert_file_info()</a>.</p>
183 <a class="anchor" name="4ae660a876f1e362d1ab2f8c68bdef3f"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_bind_double" ref="4ae660a876f1e362d1ab2f8c68bdef3f" args="(sqlite3_stmt *stmt, int col, double value)" -->
184 <div class="memitem">
185 <div class="memproto">
186 <table class="memname">
188 <td class="memname">int lms_db_bind_double </td>
190 <td class="paramtype">sqlite3_stmt * </td>
191 <td class="paramname"> <em>stmt</em>, </td>
194 <td class="paramkey"></td>
196 <td class="paramtype">int </td>
197 <td class="paramname"> <em>col</em>, </td>
200 <td class="paramkey"></td>
202 <td class="paramtype">double </td>
203 <td class="paramname"> <em>value</em></td><td> </td>
208 <td></td><td></td><td></td>
216 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00251">251</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
220 <a class="anchor" name="de261036cf3228f0b6a79a9c68687c4f"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_bind_int" ref="de261036cf3228f0b6a79a9c68687c4f" args="(sqlite3_stmt *stmt, int col, int value)" -->
221 <div class="memitem">
222 <div class="memproto">
223 <table class="memname">
225 <td class="memname">int lms_db_bind_int </td>
227 <td class="paramtype">sqlite3_stmt * </td>
228 <td class="paramname"> <em>stmt</em>, </td>
231 <td class="paramkey"></td>
233 <td class="paramtype">int </td>
234 <td class="paramname"> <em>col</em>, </td>
237 <td class="paramkey"></td>
239 <td class="paramtype">int </td>
240 <td class="paramname"> <em>value</em></td><td> </td>
245 <td></td><td></td><td></td>
253 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00232">232</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
255 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00673">lms_db_insert_file_info()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00747">lms_db_set_file_dtime()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00304">lms_db_table_version_set()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00629">lms_db_update_file_info()</a>.</p>
259 <a class="anchor" name="f2fe78bc45dc33d843313a846db5ce7c"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_bind_int64" ref="f2fe78bc45dc33d843313a846db5ce7c" args="(sqlite3_stmt *stmt, int col, int64_t value)" -->
260 <div class="memitem">
261 <div class="memproto">
262 <table class="memname">
264 <td class="memname">int lms_db_bind_int64 </td>
266 <td class="paramtype">sqlite3_stmt * </td>
267 <td class="paramname"> <em>stmt</em>, </td>
270 <td class="paramkey"></td>
272 <td class="paramtype">int </td>
273 <td class="paramname"> <em>col</em>, </td>
276 <td class="paramkey"></td>
278 <td class="paramtype">int64_t </td>
279 <td class="paramname"> <em>value</em></td><td> </td>
284 <td></td><td></td><td></td>
292 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00191">191</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
294 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00717">lms_db_delete_file_info()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00747">lms_db_set_file_dtime()</a>.</p>
298 <a class="anchor" name="2a0a5d3a27fdee8508b2b0cc59979417"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_bind_int64_or_null" ref="2a0a5d3a27fdee8508b2b0cc59979417" args="(sqlite3_stmt *stmt, int col, int64_t *p_value)" -->
299 <div class="memitem">
300 <div class="memproto">
301 <table class="memname">
303 <td class="memname">int lms_db_bind_int64_or_null </td>
305 <td class="paramtype">sqlite3_stmt * </td>
306 <td class="paramname"> <em>stmt</em>, </td>
309 <td class="paramkey"></td>
311 <td class="paramtype">int </td>
312 <td class="paramname"> <em>col</em>, </td>
315 <td class="paramkey"></td>
317 <td class="paramtype">int64_t * </td>
318 <td class="paramname"> <em>p_value</em></td><td> </td>
323 <td></td><td></td><td></td>
331 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00210">210</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
335 <a class="anchor" name="88c461ae88da3eb47987c5a0b15c5888"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_bind_text" ref="88c461ae88da3eb47987c5a0b15c5888" args="(sqlite3_stmt *stmt, int col, const char *text, int len)" -->
336 <div class="memitem">
337 <div class="memproto">
338 <table class="memname">
340 <td class="memname">int lms_db_bind_text </td>
342 <td class="paramtype">sqlite3_stmt * </td>
343 <td class="paramname"> <em>stmt</em>, </td>
346 <td class="paramkey"></td>
348 <td class="paramtype">int </td>
349 <td class="paramname"> <em>col</em>, </td>
352 <td class="paramkey"></td>
354 <td class="paramtype">const char * </td>
355 <td class="paramname"> <em>text</em>, </td>
358 <td class="paramkey"></td>
360 <td class="paramtype">int </td>
361 <td class="paramname"> <em>len</em></td><td> </td>
366 <td></td><td></td><td></td>
374 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00145">145</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
376 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00270">lms_db_table_version_get()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00304">lms_db_table_version_set()</a>.</p>
380 <a class="anchor" name="19b0458b9d7b76370588156e931a9c04"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_cache_add" ref="19b0458b9d7b76370588156e931a9c04" args="(struct lms_db_cache *cache, const sqlite3 *db, void *data)" -->
381 <div class="memitem">
382 <div class="memproto">
383 <table class="memname">
385 <td class="memname">int lms_db_cache_add </td>
387 <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> * </td>
388 <td class="paramname"> <em>cache</em>, </td>
391 <td class="paramkey"></td>
393 <td class="paramtype">const sqlite3 * </td>
394 <td class="paramname"> <em>db</em>, </td>
397 <td class="paramkey"></td>
399 <td class="paramtype">void * </td>
400 <td class="paramname"> <em>data</em></td><td> </td>
405 <td></td><td></td><td></td>
413 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00407">407</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
415 <p>References <a class="el" href="lightmediascanner__db__private_8h-source.html#l00059">lms_db_cache_entry::data</a>, <a class="el" href="lightmediascanner__db__private_8h-source.html#l00058">lms_db_cache_entry::db</a>, <a class="el" href="lightmediascanner__db__private_8h-source.html#l00064">lms_db_cache::entries</a>, and <a class="el" href="lightmediascanner__db__private_8h-source.html#l00063">lms_db_cache::size</a>.</p>
417 <p>Referenced by <a class="el" href="lightmediascanner__db__audio_8c-source.html#l00297">lms_db_audio_new()</a>, <a class="el" href="lightmediascanner__db__image_8c-source.html#l00117">lms_db_image_new()</a>, <a class="el" href="lightmediascanner__db__playlist_8c-source.html#l00111">lms_db_playlist_new()</a>, and <a class="el" href="lightmediascanner__db__video_8c-source.html#l00124">lms_db_video_new()</a>.</p>
421 <a class="anchor" name="296c81e4c64be1c7935ef31038aeb2c0"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_cache_del" ref="296c81e4c64be1c7935ef31038aeb2c0" args="(struct lms_db_cache *cache, const sqlite3 *db, void *data)" -->
422 <div class="memitem">
423 <div class="memproto">
424 <table class="memname">
426 <td class="memname">int lms_db_cache_del </td>
428 <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> * </td>
429 <td class="paramname"> <em>cache</em>, </td>
432 <td class="paramkey"></td>
434 <td class="paramtype">const sqlite3 * </td>
435 <td class="paramname"> <em>db</em>, </td>
438 <td class="paramkey"></td>
440 <td class="paramtype">void * </td>
441 <td class="paramname"> <em>data</em></td><td> </td>
446 <td></td><td></td><td></td>
454 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00437">437</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
456 <p>References <a class="el" href="lightmediascanner__db__private_8h-source.html#l00059">lms_db_cache_entry::data</a>, <a class="el" href="lightmediascanner__db__private_8h-source.html#l00064">lms_db_cache::entries</a>, and <a class="el" href="lightmediascanner__db__private_8h-source.html#l00063">lms_db_cache::size</a>.</p>
458 <p>Referenced by <a class="el" href="lightmediascanner__db__audio_8c-source.html#l00402">lms_db_audio_free()</a>, <a class="el" href="lightmediascanner__db__image_8c-source.html#l00193">lms_db_image_free()</a>, <a class="el" href="lightmediascanner__db__playlist_8c-source.html#l00185">lms_db_playlist_free()</a>, and <a class="el" href="lightmediascanner__db__video_8c-source.html#l00197">lms_db_video_free()</a>.</p>
462 <a class="anchor" name="e7a672fa5760bae1a669c737648fe7d3"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_cache_get" ref="e7a672fa5760bae1a669c737648fe7d3" args="(struct lms_db_cache *cache, const sqlite3 *db, void **pdata)" -->
463 <div class="memitem">
464 <div class="memproto">
465 <table class="memname">
467 <td class="memname">int lms_db_cache_get </td>
469 <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> * </td>
470 <td class="paramname"> <em>cache</em>, </td>
473 <td class="paramkey"></td>
475 <td class="paramtype">const sqlite3 * </td>
476 <td class="paramname"> <em>db</em>, </td>
479 <td class="paramkey"></td>
481 <td class="paramtype">void ** </td>
482 <td class="paramname"> <em>pdata</em></td><td> </td>
487 <td></td><td></td><td></td>
495 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00462">462</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
497 <p>References <a class="el" href="lightmediascanner__db__private_8h-source.html#l00059">lms_db_cache_entry::data</a>, and <a class="el" href="lightmediascanner__db__private_8h-source.html#l00064">lms_db_cache::entries</a>.</p>
499 <p>Referenced by <a class="el" href="lightmediascanner__db__audio_8c-source.html#l00297">lms_db_audio_new()</a>, <a class="el" href="lightmediascanner__db__image_8c-source.html#l00117">lms_db_image_new()</a>, <a class="el" href="lightmediascanner__db__playlist_8c-source.html#l00111">lms_db_playlist_new()</a>, and <a class="el" href="lightmediascanner__db__video_8c-source.html#l00124">lms_db_video_new()</a>.</p>
503 <a class="anchor" name="5fddf47521f83929b0c90a481fa01c5b"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt" ref="5fddf47521f83929b0c90a481fa01c5b" args="(sqlite3 *db, const char *sql)" -->
504 <div class="memitem">
505 <div class="memproto">
506 <table class="memname">
508 <td class="memname">sqlite3_stmt* lms_db_compile_stmt </td>
510 <td class="paramtype">sqlite3 * </td>
511 <td class="paramname"> <em>db</em>, </td>
514 <td class="paramkey"></td>
516 <td class="paramtype">const char * </td>
517 <td class="paramname"> <em>sql</em></td><td> </td>
522 <td></td><td></td><td></td>
530 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">101</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
532 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00028">sqlite3_prepare_v2()</a>.</p>
534 <p>Referenced by <a class="el" href="lightmediascanner__db__audio_8c-source.html#l00341">lms_db_audio_start()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00526">lms_db_compile_stmt_begin_transaction()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00711">lms_db_compile_stmt_delete_file_info()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00553">lms_db_compile_stmt_end_transaction()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00580">lms_db_compile_stmt_get_file_info()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00776">lms_db_compile_stmt_get_files()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00666">lms_db_compile_stmt_insert_file_info()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00741">lms_db_compile_stmt_set_file_dtime()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00622">lms_db_compile_stmt_update_file_info()</a>, <a class="el" href="lightmediascanner__db__image_8c-source.html#l00161">lms_db_image_start()</a>, <a class="el" href="lightmediascanner__db__playlist_8c-source.html#l00155">lms_db_playlist_start()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00270">lms_db_table_version_get()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00304">lms_db_table_version_set()</a>, and <a class="el" href="lightmediascanner__db__video_8c-source.html#l00168">lms_db_video_start()</a>.</p>
537 <div class="dynheader">
538 Here is the call graph for this function:</div>
539 <div class="dynsection">
544 <a class="anchor" name="1787fdaf148358c7a518e91dfd871ca1"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_begin_transaction" ref="1787fdaf148358c7a518e91dfd871ca1" args="(sqlite3 *db)" -->
545 <div class="memitem">
546 <div class="memproto">
547 <table class="memname">
549 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_begin_transaction </td>
551 <td class="paramtype">sqlite3 * </td>
552 <td class="paramname"> <em>db</em> </td>
553 <td> ) </td>
562 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00526">526</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
564 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
567 <div class="dynheader">
568 Here is the call graph for this function:</div>
569 <div class="dynsection">
574 <a class="anchor" name="559925f8e4d5bf61d1bcf44844a95699"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_delete_file_info" ref="559925f8e4d5bf61d1bcf44844a95699" args="(sqlite3 *db)" -->
575 <div class="memitem">
576 <div class="memproto">
577 <table class="memname">
579 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_delete_file_info </td>
581 <td class="paramtype">sqlite3 * </td>
582 <td class="paramname"> <em>db</em> </td>
583 <td> ) </td>
592 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00711">711</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
594 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
597 <div class="dynheader">
598 Here is the call graph for this function:</div>
599 <div class="dynsection">
604 <a class="anchor" name="bff1aa6077215f3d70d4d5b1a9b7a498"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_end_transaction" ref="bff1aa6077215f3d70d4d5b1a9b7a498" args="(sqlite3 *db)" -->
605 <div class="memitem">
606 <div class="memproto">
607 <table class="memname">
609 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_end_transaction </td>
611 <td class="paramtype">sqlite3 * </td>
612 <td class="paramname"> <em>db</em> </td>
613 <td> ) </td>
622 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00553">553</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
624 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
627 <div class="dynheader">
628 Here is the call graph for this function:</div>
629 <div class="dynsection">
634 <a class="anchor" name="b00a624bc01da9b796f7bc6e1d507cf8"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_get_file_info" ref="b00a624bc01da9b796f7bc6e1d507cf8" args="(sqlite3 *db)" -->
635 <div class="memitem">
636 <div class="memproto">
637 <table class="memname">
639 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_get_file_info </td>
641 <td class="paramtype">sqlite3 * </td>
642 <td class="paramname"> <em>db</em> </td>
643 <td> ) </td>
652 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00580">580</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
654 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
657 <div class="dynheader">
658 Here is the call graph for this function:</div>
659 <div class="dynsection">
664 <a class="anchor" name="73ae2cfd7babf80294cf31f02906223b"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_get_files" ref="73ae2cfd7babf80294cf31f02906223b" args="(sqlite3 *db)" -->
665 <div class="memitem">
666 <div class="memproto">
667 <table class="memname">
669 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_get_files </td>
671 <td class="paramtype">sqlite3 * </td>
672 <td class="paramname"> <em>db</em> </td>
673 <td> ) </td>
682 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00776">776</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
684 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
687 <div class="dynheader">
688 Here is the call graph for this function:</div>
689 <div class="dynsection">
694 <a class="anchor" name="9a5886e755eb428ac811956144eee0dc"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_insert_file_info" ref="9a5886e755eb428ac811956144eee0dc" args="(sqlite3 *db)" -->
695 <div class="memitem">
696 <div class="memproto">
697 <table class="memname">
699 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_insert_file_info </td>
701 <td class="paramtype">sqlite3 * </td>
702 <td class="paramname"> <em>db</em> </td>
703 <td> ) </td>
712 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00666">666</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
714 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
717 <div class="dynheader">
718 Here is the call graph for this function:</div>
719 <div class="dynsection">
724 <a class="anchor" name="1b6950ca9e548670a4cb7fd0ec5220a8"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_set_file_dtime" ref="1b6950ca9e548670a4cb7fd0ec5220a8" args="(sqlite3 *db)" -->
725 <div class="memitem">
726 <div class="memproto">
727 <table class="memname">
729 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_set_file_dtime </td>
731 <td class="paramtype">sqlite3 * </td>
732 <td class="paramname"> <em>db</em> </td>
733 <td> ) </td>
742 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00741">741</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
744 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
747 <div class="dynheader">
748 Here is the call graph for this function:</div>
749 <div class="dynsection">
754 <a class="anchor" name="1e6e76cfa9d6faa3c3b8035004eff1a0"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_update_file_info" ref="1e6e76cfa9d6faa3c3b8035004eff1a0" args="(sqlite3 *db)" -->
755 <div class="memitem">
756 <div class="memproto">
757 <table class="memname">
759 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_update_file_info </td>
761 <td class="paramtype">sqlite3 * </td>
762 <td class="paramname"> <em>db</em> </td>
763 <td> ) </td>
772 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00622">622</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
774 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
777 <div class="dynheader">
778 Here is the call graph for this function:</div>
779 <div class="dynsection">
784 <a class="anchor" name="3798a46baaedc4d466879865456acc94"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_create_core_tables_if_required" ref="3798a46baaedc4d466879865456acc94" args="(sqlite3 *db)" -->
785 <div class="memitem">
786 <div class="memproto">
787 <table class="memname">
789 <td class="memname">int lms_db_create_core_tables_if_required </td>
791 <td class="paramtype">sqlite3 * </td>
792 <td class="paramname"> <em>db</em> </td>
793 <td> ) </td>
802 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00475">475</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
806 <a class="anchor" name="822cae681398710b63c9af149fdacedb"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_create_trigger_if_not_exists" ref="822cae681398710b63c9af149fdacedb" args="(sqlite3 *db, const char *sql)" -->
807 <div class="memitem">
808 <div class="memproto">
809 <table class="memname">
811 <td class="memname">int lms_db_create_trigger_if_not_exists </td>
813 <td class="paramtype">sqlite3 * </td>
814 <td class="paramname"> <em>db</em>, </td>
817 <td class="paramkey"></td>
819 <td class="paramtype">const char * </td>
820 <td class="paramname"> <em>sql</em></td><td> </td>
825 <td></td><td></td><td></td>
833 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00055">55</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
837 <a class="anchor" name="bb2a9cdbbc7680d1ec85ef3f086b3f63"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_delete_file_info" ref="bb2a9cdbbc7680d1ec85ef3f086b3f63" args="(sqlite3_stmt *stmt, const struct lms_file_info *finfo)" -->
838 <div class="memitem">
839 <div class="memproto">
840 <table class="memname">
842 <td class="memname">int lms_db_delete_file_info </td>
844 <td class="paramtype">sqlite3_stmt * </td>
845 <td class="paramname"> <em>stmt</em>, </td>
848 <td class="paramkey"></td>
850 <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
851 <td class="paramname"> <em>finfo</em></td><td> </td>
856 <td></td><td></td><td></td>
864 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00717">717</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
866 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00149">lms_file_info::id</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00191">lms_db_bind_int64()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">lms_db_reset_stmt()</a>.</p>
869 <div class="dynheader">
870 Here is the call graph for this function:</div>
871 <div class="dynsection">
876 <a class="anchor" name="ffa877e4fa751f090e7af8c2025d245c"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_end_transaction" ref="ffa877e4fa751f090e7af8c2025d245c" args="(sqlite3_stmt *stmt)" -->
877 <div class="memitem">
878 <div class="memproto">
879 <table class="memname">
881 <td class="memname">int lms_db_end_transaction </td>
883 <td class="paramtype">sqlite3_stmt * </td>
884 <td class="paramname"> <em>stmt</em> </td>
885 <td> ) </td>
894 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00559">559</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
896 <p>Referenced by <a class="el" href="lightmediascanner__process_8c-source.html#l01047">lms_process_single_process()</a>.</p>
900 <a class="anchor" name="32110a4825e598ca6df329f55b0b62b5"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_finalize_stmt" ref="32110a4825e598ca6df329f55b0b62b5" args="(sqlite3_stmt *stmt, const char *name)" -->
901 <div class="memitem">
902 <div class="memproto">
903 <table class="memname">
905 <td class="memname">int lms_db_finalize_stmt </td>
907 <td class="paramtype">sqlite3_stmt * </td>
908 <td class="paramname"> <em>stmt</em>, </td>
911 <td class="paramkey"></td>
913 <td class="paramtype">const char * </td>
914 <td class="paramname"> <em>name</em></td><td> </td>
919 <td></td><td></td><td></td>
927 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00113">113</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
929 <p>Referenced by <a class="el" href="lightmediascanner__db__audio_8c-source.html#l00402">lms_db_audio_free()</a>, <a class="el" href="lightmediascanner__db__image_8c-source.html#l00193">lms_db_image_free()</a>, <a class="el" href="lightmediascanner__db__playlist_8c-source.html#l00185">lms_db_playlist_free()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00270">lms_db_table_version_get()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00304">lms_db_table_version_set()</a>, and <a class="el" href="lightmediascanner__db__video_8c-source.html#l00197">lms_db_video_free()</a>.</p>
933 <a class="anchor" name="c0b7cf0b2eb0f55fbf8a4103bc9569d1"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_get_file_info" ref="c0b7cf0b2eb0f55fbf8a4103bc9569d1" args="(sqlite3_stmt *stmt, struct lms_file_info *finfo)" -->
934 <div class="memitem">
935 <div class="memproto">
936 <table class="memname">
938 <td class="memname">int lms_db_get_file_info </td>
940 <td class="paramtype">sqlite3_stmt * </td>
941 <td class="paramname"> <em>stmt</em>, </td>
944 <td class="paramkey"></td>
946 <td class="paramtype">struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
947 <td class="paramname"> <em>finfo</em></td><td> </td>
952 <td></td><td></td><td></td>
960 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00587">587</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
962 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00151">lms_file_info::dtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00149">lms_file_info::id</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00168">lms_db_bind_blob()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">lms_db_reset_stmt()</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00150">lms_file_info::mtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00146">lms_file_info::path</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00147">lms_file_info::path_len</a>, and <a class="el" href="lightmediascanner__plugin_8h-source.html#l00152">lms_file_info::size</a>.</p>
965 <div class="dynheader">
966 Here is the call graph for this function:</div>
967 <div class="dynsection">
972 <a class="anchor" name="df572e74e0821a66ebd16f575b4fb7c4"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_get_files" ref="df572e74e0821a66ebd16f575b4fb7c4" args="(sqlite3_stmt *stmt, const char *path, int len)" -->
973 <div class="memitem">
974 <div class="memproto">
975 <table class="memname">
977 <td class="memname">int lms_db_get_files </td>
979 <td class="paramtype">sqlite3_stmt * </td>
980 <td class="paramname"> <em>stmt</em>, </td>
983 <td class="paramkey"></td>
985 <td class="paramtype">const char * </td>
986 <td class="paramname"> <em>path</em>, </td>
989 <td class="paramkey"></td>
991 <td class="paramtype">int </td>
992 <td class="paramname"> <em>len</em></td><td> </td>
997 <td></td><td></td><td></td>
1001 <div class="memdoc">
1005 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00783">783</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1007 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00168">lms_db_bind_blob()</a>.</p>
1010 <div class="dynheader">
1011 Here is the call graph for this function:</div>
1012 <div class="dynsection">
1017 <a class="anchor" name="e529ad5c4478d53685c65ec69dc5b1f4"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_insert_file_info" ref="e529ad5c4478d53685c65ec69dc5b1f4" args="(sqlite3_stmt *stmt, struct lms_file_info *finfo)" -->
1018 <div class="memitem">
1019 <div class="memproto">
1020 <table class="memname">
1022 <td class="memname">int lms_db_insert_file_info </td>
1024 <td class="paramtype">sqlite3_stmt * </td>
1025 <td class="paramname"> <em>stmt</em>, </td>
1028 <td class="paramkey"></td>
1030 <td class="paramtype">struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
1031 <td class="paramname"> <em>finfo</em></td><td> </td>
1036 <td></td><td></td><td></td>
1040 <div class="memdoc">
1044 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00673">673</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1046 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00151">lms_file_info::dtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00149">lms_file_info::id</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00168">lms_db_bind_blob()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00232">lms_db_bind_int()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">lms_db_reset_stmt()</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00150">lms_file_info::mtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00146">lms_file_info::path</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00147">lms_file_info::path_len</a>, and <a class="el" href="lightmediascanner__plugin_8h-source.html#l00152">lms_file_info::size</a>.</p>
1049 <div class="dynheader">
1050 Here is the call graph for this function:</div>
1051 <div class="dynsection">
1056 <a class="anchor" name="226c6f7ab2e7923b747b7090357ea419"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_reset_stmt" ref="226c6f7ab2e7923b747b7090357ea419" args="(sqlite3_stmt *stmt)" -->
1057 <div class="memitem">
1058 <div class="memproto">
1059 <table class="memname">
1061 <td class="memname">int lms_db_reset_stmt </td>
1063 <td class="paramtype">sqlite3_stmt * </td>
1064 <td class="paramname"> <em>stmt</em> </td>
1065 <td> ) </td>
1070 <div class="memdoc">
1074 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">128</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1076 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00036">sqlite3_clear_bindings()</a>.</p>
1078 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00717">lms_db_delete_file_info()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00587">lms_db_get_file_info()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00673">lms_db_insert_file_info()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00747">lms_db_set_file_dtime()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00270">lms_db_table_version_get()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00304">lms_db_table_version_set()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00629">lms_db_update_file_info()</a>.</p>
1081 <div class="dynheader">
1082 Here is the call graph for this function:</div>
1083 <div class="dynsection">
1088 <a class="anchor" name="024e3bd9385fd740f75618716c90b04f"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_set_file_dtime" ref="024e3bd9385fd740f75618716c90b04f" args="(sqlite3_stmt *stmt, const struct lms_file_info *finfo)" -->
1089 <div class="memitem">
1090 <div class="memproto">
1091 <table class="memname">
1093 <td class="memname">int lms_db_set_file_dtime </td>
1095 <td class="paramtype">sqlite3_stmt * </td>
1096 <td class="paramname"> <em>stmt</em>, </td>
1099 <td class="paramkey"></td>
1101 <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
1102 <td class="paramname"> <em>finfo</em></td><td> </td>
1107 <td></td><td></td><td></td>
1111 <div class="memdoc">
1115 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00747">747</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1117 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00151">lms_file_info::dtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00149">lms_file_info::id</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00232">lms_db_bind_int()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00191">lms_db_bind_int64()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">lms_db_reset_stmt()</a>.</p>
1120 <div class="dynheader">
1121 Here is the call graph for this function:</div>
1122 <div class="dynsection">
1127 <a class="anchor" name="9bca88ae79959baff3accee8ce10b558"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_table_update" ref="9bca88ae79959baff3accee8ce10b558" args="(sqlite3 *db, const char *table, unsigned int current_version, unsigned int last_version, const lms_db_table_updater_t *updaters)" -->
1128 <div class="memitem">
1129 <div class="memproto">
1130 <table class="memname">
1132 <td class="memname">int lms_db_table_update </td>
1134 <td class="paramtype">sqlite3 * </td>
1135 <td class="paramname"> <em>db</em>, </td>
1138 <td class="paramkey"></td>
1140 <td class="paramtype">const char * </td>
1141 <td class="paramname"> <em>table</em>, </td>
1144 <td class="paramkey"></td>
1146 <td class="paramtype">unsigned int </td>
1147 <td class="paramname"> <em>current_version</em>, </td>
1150 <td class="paramkey"></td>
1152 <td class="paramtype">unsigned int </td>
1153 <td class="paramname"> <em>last_version</em>, </td>
1156 <td class="paramkey"></td>
1158 <td class="paramtype">const <a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> * </td>
1159 <td class="paramname"> <em>updaters</em></td><td> </td>
1164 <td></td><td></td><td></td>
1168 <div class="memdoc">
1172 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00337">337</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1174 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00304">lms_db_table_version_set()</a>.</p>
1176 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00367">lms_db_table_update_if_required()</a>.</p>
1179 <div class="dynheader">
1180 Here is the call graph for this function:</div>
1181 <div class="dynsection">
1186 <a class="anchor" name="86b766535f9dc7895da7d0f606201700"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_table_update_if_required" ref="86b766535f9dc7895da7d0f606201700" args="(sqlite3 *db, const char *table, unsigned int last_version, lms_db_table_updater_t *updaters)" -->
1187 <div class="memitem">
1188 <div class="memproto">
1189 <table class="memname">
1191 <td class="memname">int lms_db_table_update_if_required </td>
1193 <td class="paramtype">sqlite3 * </td>
1194 <td class="paramname"> <em>db</em>, </td>
1197 <td class="paramkey"></td>
1199 <td class="paramtype">const char * </td>
1200 <td class="paramname"> <em>table</em>, </td>
1203 <td class="paramkey"></td>
1205 <td class="paramtype">unsigned int </td>
1206 <td class="paramname"> <em>last_version</em>, </td>
1209 <td class="paramkey"></td>
1211 <td class="paramtype"><a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> * </td>
1212 <td class="paramname"> <em>updaters</em></td><td> </td>
1217 <td></td><td></td><td></td>
1221 <div class="memdoc">
1225 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00367">367</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1227 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00337">lms_db_table_update()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00270">lms_db_table_version_get()</a>.</p>
1230 <div class="dynheader">
1231 Here is the call graph for this function:</div>
1232 <div class="dynsection">
1237 <a class="anchor" name="eba3215ee5981a73e9d0fed0a7e079cd"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_table_version_get" ref="eba3215ee5981a73e9d0fed0a7e079cd" args="(sqlite3 *db, const char *table)" -->
1238 <div class="memitem">
1239 <div class="memproto">
1240 <table class="memname">
1242 <td class="memname">int lms_db_table_version_get </td>
1244 <td class="paramtype">sqlite3 * </td>
1245 <td class="paramname"> <em>db</em>, </td>
1248 <td class="paramkey"></td>
1250 <td class="paramtype">const char * </td>
1251 <td class="paramname"> <em>table</em></td><td> </td>
1256 <td></td><td></td><td></td>
1260 <div class="memdoc">
1264 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00270">270</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1266 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00145">lms_db_bind_text()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00113">lms_db_finalize_stmt()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">lms_db_reset_stmt()</a>.</p>
1268 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00367">lms_db_table_update_if_required()</a>.</p>
1271 <div class="dynheader">
1272 Here is the call graph for this function:</div>
1273 <div class="dynsection">
1278 <a class="anchor" name="46e6e318ea9bb4a7ffdfe40c842da4e7"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_table_version_set" ref="46e6e318ea9bb4a7ffdfe40c842da4e7" args="(sqlite3 *db, const char *table, unsigned int version)" -->
1279 <div class="memitem">
1280 <div class="memproto">
1281 <table class="memname">
1283 <td class="memname">int lms_db_table_version_set </td>
1285 <td class="paramtype">sqlite3 * </td>
1286 <td class="paramname"> <em>db</em>, </td>
1289 <td class="paramkey"></td>
1291 <td class="paramtype">const char * </td>
1292 <td class="paramname"> <em>table</em>, </td>
1295 <td class="paramkey"></td>
1297 <td class="paramtype">unsigned int </td>
1298 <td class="paramname"> <em>version</em></td><td> </td>
1303 <td></td><td></td><td></td>
1307 <div class="memdoc">
1311 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00304">304</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1313 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00232">lms_db_bind_int()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00145">lms_db_bind_text()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00113">lms_db_finalize_stmt()</a>, and <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">lms_db_reset_stmt()</a>.</p>
1315 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00337">lms_db_table_update()</a>.</p>
1318 <div class="dynheader">
1319 Here is the call graph for this function:</div>
1320 <div class="dynsection">
1325 <a class="anchor" name="0f727cd41bbb90af2e08b3ee7ca76de9"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_update_file_info" ref="0f727cd41bbb90af2e08b3ee7ca76de9" args="(sqlite3_stmt *stmt, const struct lms_file_info *finfo)" -->
1326 <div class="memitem">
1327 <div class="memproto">
1328 <table class="memname">
1330 <td class="memname">int lms_db_update_file_info </td>
1332 <td class="paramtype">sqlite3_stmt * </td>
1333 <td class="paramname"> <em>stmt</em>, </td>
1336 <td class="paramkey"></td>
1338 <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
1339 <td class="paramname"> <em>finfo</em></td><td> </td>
1344 <td></td><td></td><td></td>
1348 <div class="memdoc">
1352 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00629">629</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1354 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00151">lms_file_info::dtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00149">lms_file_info::id</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00232">lms_db_bind_int()</a>, <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">lms_db_reset_stmt()</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00150">lms_file_info::mtime</a>, and <a class="el" href="lightmediascanner__plugin_8h-source.html#l00152">lms_file_info::size</a>.</p>
1357 <div class="dynheader">
1358 Here is the call graph for this function:</div>
1359 <div class="dynsection">
1364 <a class="anchor" name="3f8fb8f31c1876b3579956b3d898cd00"></a><!-- doxytag: member="lightmediascanner_db_common.c::sqlite3_clear_bindings" ref="3f8fb8f31c1876b3579956b3d898cd00" args="(sqlite3_stmt *stmt)" -->
1365 <div class="memitem">
1366 <div class="memproto">
1367 <table class="memname">
1369 <td class="memname">int sqlite3_clear_bindings </td>
1371 <td class="paramtype">sqlite3_stmt * </td>
1372 <td class="paramname"> <em>stmt</em> </td>
1373 <td> ) </td>
1378 <div class="memdoc">
1382 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00036">36</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1384 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">lms_db_reset_stmt()</a>.</p>
1388 <a class="anchor" name="21da1a6588f354b758211583559ae405"></a><!-- doxytag: member="lightmediascanner_db_common.c::sqlite3_prepare_v2" ref="21da1a6588f354b758211583559ae405" args="(sqlite3 *db, const char *sql, int len, sqlite3_stmt **stmt, const char **tail)" -->
1389 <div class="memitem">
1390 <div class="memproto">
1391 <table class="memname">
1393 <td class="memname">int sqlite3_prepare_v2 </td>
1395 <td class="paramtype">sqlite3 * </td>
1396 <td class="paramname"> <em>db</em>, </td>
1399 <td class="paramkey"></td>
1401 <td class="paramtype">const char * </td>
1402 <td class="paramname"> <em>sql</em>, </td>
1405 <td class="paramkey"></td>
1407 <td class="paramtype">int </td>
1408 <td class="paramname"> <em>len</em>, </td>
1411 <td class="paramkey"></td>
1413 <td class="paramtype">sqlite3_stmt ** </td>
1414 <td class="paramname"> <em>stmt</em>, </td>
1417 <td class="paramkey"></td>
1419 <td class="paramtype">const char ** </td>
1420 <td class="paramname"> <em>tail</em></td><td> </td>
1425 <td></td><td></td><td></td>
1429 <div class="memdoc">
1432 Copyright (C) 2007 by INdT<p>
1433 This program is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.<p>
1434 This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.<p>
1435 You should have received a copy of the GNU Lesser General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.<p>
1436 <dl class="author" compact><dt><b>Author:</b></dt><dd>Gustavo Sverzut Barbieri <<a href="mailto:gustavo.barbieri@openbossa.org">gustavo.barbieri@openbossa.org</a>> </dd></dl>
1438 <p>Definition at line <a class="el" href="lightmediascanner__db__common_8c-source.html#l00028">28</a> of file <a class="el" href="lightmediascanner__db__common_8c-source.html">lightmediascanner_db_common.c</a>.</p>
1440 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
1445 <hr size="1"><address style="text-align: right;"><small>Generated on Wed Apr 22 23:56:01 2009 for Light Media Scanner by
1446 <a href="http://www.doxygen.org/index.html">
1447 <img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.8 </small></address>