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="doxygen.css" rel="stylesheet" type="text/css">
5 <link href="tabs.css" rel="stylesheet" type="text/css">
7 <!-- Generated by Doxygen 1.5.6 -->
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="classes.html"><span>Data Structures</span></a></li>
14 <li class="current"><a href="files.html"><span>Files</span></a></li>
18 <div class="contents">
19 <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>
20 <code>#include <stdlib.h></code><br>
21 <code>#include <stdio.h></code><br>
22 <code>#include <string.h></code><br>
25 <div class="dynheader">
26 Include dependency graph for lightmediascanner_db_common.c:</div>
27 <div class="dynsection">
28 <p><center><img src="lightmediascanner__db__common_8c__incl.png" border="0" usemap="#src/lib/lightmediascanner_db_common.c_map" alt=""></center>
29 <map name="src/lib/lightmediascanner_db_common.c_map">
30 <area shape="rect" href="lightmediascanner__db__private_8h.html" title="lightmediascanner_db_private.h" alt="" coords="23,84,257,111"><area shape="rect" href="lightmediascanner__plugin_8h.html" title="lightmediascanner_plugin.h" alt="" coords="177,161,377,188"><area shape="rect" href="lightmediascanner_8h.html" title="lightmediascanner.h" alt="" coords="229,239,384,265"><area shape="rect" href="lightmediascanner__charset__conv_8h.html" title="lightmediascanner_charset_conv.h" alt="" coords="408,239,661,265"></map>
34 <a href="lightmediascanner__db__common_8c-source.html">Go to the source code of this file.</a><table border="0" cellpadding="0" cellspacing="0">
36 <tr><td colspan="2"><br><h2>Functions</h2></td></tr>
37 <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>
39 <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>
41 <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>
43 <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>
45 <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>
47 <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>
49 <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>
51 <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>
53 <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>
55 <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>
57 <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>
59 <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>
61 <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>
63 <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>
65 <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>
67 <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>
69 <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>
71 <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>
73 <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>
75 <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>
77 <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>
79 <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>
81 <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>
83 <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>
85 <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>
87 <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>
89 <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>
91 <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>
93 <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>
95 <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>
97 <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>
99 <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>
101 <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>
103 <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>
105 <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>
107 <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>
110 <hr><h2>Function Documentation</h2>
111 <a class="anchor" name="5ff807216285c93325ffaf33361dd6fc"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_begin_transaction" ref="5ff807216285c93325ffaf33361dd6fc" args="(sqlite3_stmt *stmt)" -->
112 <div class="memitem">
113 <div class="memproto">
114 <table class="memname">
116 <td class="memname">int lms_db_begin_transaction </td>
118 <td class="paramtype">sqlite3_stmt * </td>
119 <td class="paramname"> <em>stmt</em> </td>
120 <td> ) </td>
129 <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>
131 <p>Referenced by <a class="el" href="lightmediascanner__process_8c-source.html#l01044">lms_process_single_process()</a>.</p>
135 <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)" -->
136 <div class="memitem">
137 <div class="memproto">
138 <table class="memname">
140 <td class="memname">int lms_db_bind_blob </td>
142 <td class="paramtype">sqlite3_stmt * </td>
143 <td class="paramname"> <em>stmt</em>, </td>
146 <td class="paramkey"></td>
148 <td class="paramtype">int </td>
149 <td class="paramname"> <em>col</em>, </td>
152 <td class="paramkey"></td>
154 <td class="paramtype">const void * </td>
155 <td class="paramname"> <em>blob</em>, </td>
158 <td class="paramkey"></td>
160 <td class="paramtype">int </td>
161 <td class="paramname"> <em>len</em></td><td> </td>
166 <td></td><td></td><td></td>
174 <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>
176 <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>
180 <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)" -->
181 <div class="memitem">
182 <div class="memproto">
183 <table class="memname">
185 <td class="memname">int lms_db_bind_double </td>
187 <td class="paramtype">sqlite3_stmt * </td>
188 <td class="paramname"> <em>stmt</em>, </td>
191 <td class="paramkey"></td>
193 <td class="paramtype">int </td>
194 <td class="paramname"> <em>col</em>, </td>
197 <td class="paramkey"></td>
199 <td class="paramtype">double </td>
200 <td class="paramname"> <em>value</em></td><td> </td>
205 <td></td><td></td><td></td>
213 <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>
217 <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)" -->
218 <div class="memitem">
219 <div class="memproto">
220 <table class="memname">
222 <td class="memname">int lms_db_bind_int </td>
224 <td class="paramtype">sqlite3_stmt * </td>
225 <td class="paramname"> <em>stmt</em>, </td>
228 <td class="paramkey"></td>
230 <td class="paramtype">int </td>
231 <td class="paramname"> <em>col</em>, </td>
234 <td class="paramkey"></td>
236 <td class="paramtype">int </td>
237 <td class="paramname"> <em>value</em></td><td> </td>
242 <td></td><td></td><td></td>
250 <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>
252 <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>
256 <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)" -->
257 <div class="memitem">
258 <div class="memproto">
259 <table class="memname">
261 <td class="memname">int lms_db_bind_int64 </td>
263 <td class="paramtype">sqlite3_stmt * </td>
264 <td class="paramname"> <em>stmt</em>, </td>
267 <td class="paramkey"></td>
269 <td class="paramtype">int </td>
270 <td class="paramname"> <em>col</em>, </td>
273 <td class="paramkey"></td>
275 <td class="paramtype">int64_t </td>
276 <td class="paramname"> <em>value</em></td><td> </td>
281 <td></td><td></td><td></td>
289 <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>
291 <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>
295 <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)" -->
296 <div class="memitem">
297 <div class="memproto">
298 <table class="memname">
300 <td class="memname">int lms_db_bind_int64_or_null </td>
302 <td class="paramtype">sqlite3_stmt * </td>
303 <td class="paramname"> <em>stmt</em>, </td>
306 <td class="paramkey"></td>
308 <td class="paramtype">int </td>
309 <td class="paramname"> <em>col</em>, </td>
312 <td class="paramkey"></td>
314 <td class="paramtype">int64_t * </td>
315 <td class="paramname"> <em>p_value</em></td><td> </td>
320 <td></td><td></td><td></td>
328 <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>
332 <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)" -->
333 <div class="memitem">
334 <div class="memproto">
335 <table class="memname">
337 <td class="memname">int lms_db_bind_text </td>
339 <td class="paramtype">sqlite3_stmt * </td>
340 <td class="paramname"> <em>stmt</em>, </td>
343 <td class="paramkey"></td>
345 <td class="paramtype">int </td>
346 <td class="paramname"> <em>col</em>, </td>
349 <td class="paramkey"></td>
351 <td class="paramtype">const char * </td>
352 <td class="paramname"> <em>text</em>, </td>
355 <td class="paramkey"></td>
357 <td class="paramtype">int </td>
358 <td class="paramname"> <em>len</em></td><td> </td>
363 <td></td><td></td><td></td>
371 <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>
373 <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>
377 <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)" -->
378 <div class="memitem">
379 <div class="memproto">
380 <table class="memname">
382 <td class="memname">int lms_db_cache_add </td>
384 <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> * </td>
385 <td class="paramname"> <em>cache</em>, </td>
388 <td class="paramkey"></td>
390 <td class="paramtype">const sqlite3 * </td>
391 <td class="paramname"> <em>db</em>, </td>
394 <td class="paramkey"></td>
396 <td class="paramtype">void * </td>
397 <td class="paramname"> <em>data</em></td><td> </td>
402 <td></td><td></td><td></td>
410 <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>
412 <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>
414 <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>
418 <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)" -->
419 <div class="memitem">
420 <div class="memproto">
421 <table class="memname">
423 <td class="memname">int lms_db_cache_del </td>
425 <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> * </td>
426 <td class="paramname"> <em>cache</em>, </td>
429 <td class="paramkey"></td>
431 <td class="paramtype">const sqlite3 * </td>
432 <td class="paramname"> <em>db</em>, </td>
435 <td class="paramkey"></td>
437 <td class="paramtype">void * </td>
438 <td class="paramname"> <em>data</em></td><td> </td>
443 <td></td><td></td><td></td>
451 <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>
453 <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>
455 <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>
459 <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)" -->
460 <div class="memitem">
461 <div class="memproto">
462 <table class="memname">
464 <td class="memname">int lms_db_cache_get </td>
466 <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> * </td>
467 <td class="paramname"> <em>cache</em>, </td>
470 <td class="paramkey"></td>
472 <td class="paramtype">const sqlite3 * </td>
473 <td class="paramname"> <em>db</em>, </td>
476 <td class="paramkey"></td>
478 <td class="paramtype">void ** </td>
479 <td class="paramname"> <em>pdata</em></td><td> </td>
484 <td></td><td></td><td></td>
492 <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>
494 <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>
496 <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>
500 <a class="anchor" name="5fddf47521f83929b0c90a481fa01c5b"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt" ref="5fddf47521f83929b0c90a481fa01c5b" args="(sqlite3 *db, const char *sql)" -->
501 <div class="memitem">
502 <div class="memproto">
503 <table class="memname">
505 <td class="memname">sqlite3_stmt* lms_db_compile_stmt </td>
507 <td class="paramtype">sqlite3 * </td>
508 <td class="paramname"> <em>db</em>, </td>
511 <td class="paramkey"></td>
513 <td class="paramtype">const char * </td>
514 <td class="paramname"> <em>sql</em></td><td> </td>
519 <td></td><td></td><td></td>
527 <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>
529 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00028">sqlite3_prepare_v2()</a>.</p>
531 <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>
534 <div class="dynheader">
535 Here is the call graph for this function:</div>
536 <div class="dynsection">
537 <p><center><img src="lightmediascanner__db__common_8c_5fddf47521f83929b0c90a481fa01c5b_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_5fddf47521f83929b0c90a481fa01c5b_cgraph_map" alt=""></center>
538 <map name="lightmediascanner__db__common_8c_5fddf47521f83929b0c90a481fa01c5b_cgraph_map">
539 <area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="223,5,369,32"></map>
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">
570 <p><center><img src="lightmediascanner__db__common_8c_1787fdaf148358c7a518e91dfd871ca1_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_1787fdaf148358c7a518e91dfd871ca1_cgraph_map" alt=""></center>
571 <map name="lightmediascanner__db__common_8c_1787fdaf148358c7a518e91dfd871ca1_cgraph_map">
572 <area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="349,5,517,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="567,5,713,32"></map>
577 <a class="anchor" name="559925f8e4d5bf61d1bcf44844a95699"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_delete_file_info" ref="559925f8e4d5bf61d1bcf44844a95699" args="(sqlite3 *db)" -->
578 <div class="memitem">
579 <div class="memproto">
580 <table class="memname">
582 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_delete_file_info </td>
584 <td class="paramtype">sqlite3 * </td>
585 <td class="paramname"> <em>db</em> </td>
586 <td> ) </td>
595 <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>
597 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
600 <div class="dynheader">
601 Here is the call graph for this function:</div>
602 <div class="dynsection">
603 <p><center><img src="lightmediascanner__db__common_8c_559925f8e4d5bf61d1bcf44844a95699_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_559925f8e4d5bf61d1bcf44844a95699_cgraph_map" alt=""></center>
604 <map name="lightmediascanner__db__common_8c_559925f8e4d5bf61d1bcf44844a95699_cgraph_map">
605 <area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="331,5,499,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="548,5,695,32"></map>
610 <a class="anchor" name="bff1aa6077215f3d70d4d5b1a9b7a498"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_end_transaction" ref="bff1aa6077215f3d70d4d5b1a9b7a498" args="(sqlite3 *db)" -->
611 <div class="memitem">
612 <div class="memproto">
613 <table class="memname">
615 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_end_transaction </td>
617 <td class="paramtype">sqlite3 * </td>
618 <td class="paramname"> <em>db</em> </td>
619 <td> ) </td>
628 <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>
630 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
633 <div class="dynheader">
634 Here is the call graph for this function:</div>
635 <div class="dynsection">
636 <p><center><img src="lightmediascanner__db__common_8c_bff1aa6077215f3d70d4d5b1a9b7a498_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_bff1aa6077215f3d70d4d5b1a9b7a498_cgraph_map" alt=""></center>
637 <map name="lightmediascanner__db__common_8c_bff1aa6077215f3d70d4d5b1a9b7a498_cgraph_map">
638 <area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="339,5,507,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="556,5,703,32"></map>
643 <a class="anchor" name="b00a624bc01da9b796f7bc6e1d507cf8"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_get_file_info" ref="b00a624bc01da9b796f7bc6e1d507cf8" args="(sqlite3 *db)" -->
644 <div class="memitem">
645 <div class="memproto">
646 <table class="memname">
648 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_get_file_info </td>
650 <td class="paramtype">sqlite3 * </td>
651 <td class="paramname"> <em>db</em> </td>
652 <td> ) </td>
661 <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>
663 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
666 <div class="dynheader">
667 Here is the call graph for this function:</div>
668 <div class="dynsection">
669 <p><center><img src="lightmediascanner__db__common_8c_b00a624bc01da9b796f7bc6e1d507cf8_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_b00a624bc01da9b796f7bc6e1d507cf8_cgraph_map" alt=""></center>
670 <map name="lightmediascanner__db__common_8c_b00a624bc01da9b796f7bc6e1d507cf8_cgraph_map">
671 <area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="309,5,477,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="527,5,673,32"></map>
676 <a class="anchor" name="73ae2cfd7babf80294cf31f02906223b"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_get_files" ref="73ae2cfd7babf80294cf31f02906223b" args="(sqlite3 *db)" -->
677 <div class="memitem">
678 <div class="memproto">
679 <table class="memname">
681 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_get_files </td>
683 <td class="paramtype">sqlite3 * </td>
684 <td class="paramname"> <em>db</em> </td>
685 <td> ) </td>
694 <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>
696 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
699 <div class="dynheader">
700 Here is the call graph for this function:</div>
701 <div class="dynsection">
702 <p><center><img src="lightmediascanner__db__common_8c_73ae2cfd7babf80294cf31f02906223b_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_73ae2cfd7babf80294cf31f02906223b_cgraph_map" alt=""></center>
703 <map name="lightmediascanner__db__common_8c_73ae2cfd7babf80294cf31f02906223b_cgraph_map">
704 <area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="285,5,453,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="503,5,649,32"></map>
709 <a class="anchor" name="9a5886e755eb428ac811956144eee0dc"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_insert_file_info" ref="9a5886e755eb428ac811956144eee0dc" args="(sqlite3 *db)" -->
710 <div class="memitem">
711 <div class="memproto">
712 <table class="memname">
714 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_insert_file_info </td>
716 <td class="paramtype">sqlite3 * </td>
717 <td class="paramname"> <em>db</em> </td>
718 <td> ) </td>
727 <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>
729 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
732 <div class="dynheader">
733 Here is the call graph for this function:</div>
734 <div class="dynsection">
735 <p><center><img src="lightmediascanner__db__common_8c_9a5886e755eb428ac811956144eee0dc_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_9a5886e755eb428ac811956144eee0dc_cgraph_map" alt=""></center>
736 <map name="lightmediascanner__db__common_8c_9a5886e755eb428ac811956144eee0dc_cgraph_map">
737 <area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="325,5,493,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="543,5,689,32"></map>
742 <a class="anchor" name="1b6950ca9e548670a4cb7fd0ec5220a8"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_set_file_dtime" ref="1b6950ca9e548670a4cb7fd0ec5220a8" args="(sqlite3 *db)" -->
743 <div class="memitem">
744 <div class="memproto">
745 <table class="memname">
747 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_set_file_dtime </td>
749 <td class="paramtype">sqlite3 * </td>
750 <td class="paramname"> <em>db</em> </td>
751 <td> ) </td>
760 <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>
762 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
765 <div class="dynheader">
766 Here is the call graph for this function:</div>
767 <div class="dynsection">
768 <p><center><img src="lightmediascanner__db__common_8c_1b6950ca9e548670a4cb7fd0ec5220a8_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_1b6950ca9e548670a4cb7fd0ec5220a8_cgraph_map" alt=""></center>
769 <map name="lightmediascanner__db__common_8c_1b6950ca9e548670a4cb7fd0ec5220a8_cgraph_map">
770 <area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="325,5,493,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="543,5,689,32"></map>
775 <a class="anchor" name="1e6e76cfa9d6faa3c3b8035004eff1a0"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_compile_stmt_update_file_info" ref="1e6e76cfa9d6faa3c3b8035004eff1a0" args="(sqlite3 *db)" -->
776 <div class="memitem">
777 <div class="memproto">
778 <table class="memname">
780 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_update_file_info </td>
782 <td class="paramtype">sqlite3 * </td>
783 <td class="paramname"> <em>db</em> </td>
784 <td> ) </td>
793 <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>
795 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
798 <div class="dynheader">
799 Here is the call graph for this function:</div>
800 <div class="dynsection">
801 <p><center><img src="lightmediascanner__db__common_8c_1e6e76cfa9d6faa3c3b8035004eff1a0_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_1e6e76cfa9d6faa3c3b8035004eff1a0_cgraph_map" alt=""></center>
802 <map name="lightmediascanner__db__common_8c_1e6e76cfa9d6faa3c3b8035004eff1a0_cgraph_map">
803 <area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="333,5,501,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="551,5,697,32"></map>
808 <a class="anchor" name="3798a46baaedc4d466879865456acc94"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_create_core_tables_if_required" ref="3798a46baaedc4d466879865456acc94" args="(sqlite3 *db)" -->
809 <div class="memitem">
810 <div class="memproto">
811 <table class="memname">
813 <td class="memname">int lms_db_create_core_tables_if_required </td>
815 <td class="paramtype">sqlite3 * </td>
816 <td class="paramname"> <em>db</em> </td>
817 <td> ) </td>
826 <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>
830 <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)" -->
831 <div class="memitem">
832 <div class="memproto">
833 <table class="memname">
835 <td class="memname">int lms_db_create_trigger_if_not_exists </td>
837 <td class="paramtype">sqlite3 * </td>
838 <td class="paramname"> <em>db</em>, </td>
841 <td class="paramkey"></td>
843 <td class="paramtype">const char * </td>
844 <td class="paramname"> <em>sql</em></td><td> </td>
849 <td></td><td></td><td></td>
857 <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>
861 <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)" -->
862 <div class="memitem">
863 <div class="memproto">
864 <table class="memname">
866 <td class="memname">int lms_db_delete_file_info </td>
868 <td class="paramtype">sqlite3_stmt * </td>
869 <td class="paramname"> <em>stmt</em>, </td>
872 <td class="paramkey"></td>
874 <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
875 <td class="paramname"> <em>finfo</em></td><td> </td>
880 <td></td><td></td><td></td>
888 <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>
890 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00137">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>
893 <div class="dynheader">
894 Here is the call graph for this function:</div>
895 <div class="dynsection">
896 <p><center><img src="lightmediascanner__db__common_8c_bb2a9cdbbc7680d1ec85ef3f086b3f63_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_bb2a9cdbbc7680d1ec85ef3f086b3f63_cgraph_map" alt=""></center>
897 <map name="lightmediascanner__db__common_8c_bb2a9cdbbc7680d1ec85ef3f086b3f63_cgraph_map">
898 <area shape="rect" href="lightmediascanner__db__common_8c.html#f2fe78bc45dc33d843313a846db5ce7c" title="lms_db_bind_int64" alt="" coords="237,5,379,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419" title="lms_db_reset_stmt" alt="" coords="232,56,384,83"><area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="433,56,599,83"></map>
903 <a class="anchor" name="ffa877e4fa751f090e7af8c2025d245c"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_end_transaction" ref="ffa877e4fa751f090e7af8c2025d245c" args="(sqlite3_stmt *stmt)" -->
904 <div class="memitem">
905 <div class="memproto">
906 <table class="memname">
908 <td class="memname">int lms_db_end_transaction </td>
910 <td class="paramtype">sqlite3_stmt * </td>
911 <td class="paramname"> <em>stmt</em> </td>
912 <td> ) </td>
921 <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>
923 <p>Referenced by <a class="el" href="lightmediascanner__process_8c-source.html#l01044">lms_process_single_process()</a>.</p>
927 <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)" -->
928 <div class="memitem">
929 <div class="memproto">
930 <table class="memname">
932 <td class="memname">int lms_db_finalize_stmt </td>
934 <td class="paramtype">sqlite3_stmt * </td>
935 <td class="paramname"> <em>stmt</em>, </td>
938 <td class="paramkey"></td>
940 <td class="paramtype">const char * </td>
941 <td class="paramname"> <em>name</em></td><td> </td>
946 <td></td><td></td><td></td>
954 <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>
956 <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>
960 <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)" -->
961 <div class="memitem">
962 <div class="memproto">
963 <table class="memname">
965 <td class="memname">int lms_db_get_file_info </td>
967 <td class="paramtype">sqlite3_stmt * </td>
968 <td class="paramname"> <em>stmt</em>, </td>
971 <td class="paramkey"></td>
973 <td class="paramtype">struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
974 <td class="paramname"> <em>finfo</em></td><td> </td>
979 <td></td><td></td><td></td>
987 <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>
989 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00139">lms_file_info::dtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00137">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#l00138">lms_file_info::mtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00134">lms_file_info::path</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00135">lms_file_info::path_len</a>, and <a class="el" href="lightmediascanner__plugin_8h-source.html#l00140">lms_file_info::size</a>.</p>
992 <div class="dynheader">
993 Here is the call graph for this function:</div>
994 <div class="dynsection">
995 <p><center><img src="lightmediascanner__db__common_8c_c0b7cf0b2eb0f55fbf8a4103bc9569d1_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_c0b7cf0b2eb0f55fbf8a4103bc9569d1_cgraph_map" alt=""></center>
996 <map name="lightmediascanner__db__common_8c_c0b7cf0b2eb0f55fbf8a4103bc9569d1_cgraph_map">
997 <area shape="rect" href="lightmediascanner__db__common_8c.html#fee26461dbd6c89c82794c94aaeeaef6" title="lms_db_bind_blob" alt="" coords="219,5,355,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419" title="lms_db_reset_stmt" alt="" coords="211,56,363,83"><area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="412,56,577,83"></map>
1002 <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)" -->
1003 <div class="memitem">
1004 <div class="memproto">
1005 <table class="memname">
1007 <td class="memname">int lms_db_get_files </td>
1009 <td class="paramtype">sqlite3_stmt * </td>
1010 <td class="paramname"> <em>stmt</em>, </td>
1013 <td class="paramkey"></td>
1015 <td class="paramtype">const char * </td>
1016 <td class="paramname"> <em>path</em>, </td>
1019 <td class="paramkey"></td>
1021 <td class="paramtype">int </td>
1022 <td class="paramname"> <em>len</em></td><td> </td>
1027 <td></td><td></td><td></td>
1031 <div class="memdoc">
1035 <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>
1037 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00168">lms_db_bind_blob()</a>.</p>
1040 <div class="dynheader">
1041 Here is the call graph for this function:</div>
1042 <div class="dynsection">
1043 <p><center><img src="lightmediascanner__db__common_8c_df572e74e0821a66ebd16f575b4fb7c4_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_df572e74e0821a66ebd16f575b4fb7c4_cgraph_map" alt=""></center>
1044 <map name="lightmediascanner__db__common_8c_df572e74e0821a66ebd16f575b4fb7c4_cgraph_map">
1045 <area shape="rect" href="lightmediascanner__db__common_8c.html#fee26461dbd6c89c82794c94aaeeaef6" title="lms_db_bind_blob" alt="" coords="187,5,323,32"></map>
1050 <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)" -->
1051 <div class="memitem">
1052 <div class="memproto">
1053 <table class="memname">
1055 <td class="memname">int lms_db_insert_file_info </td>
1057 <td class="paramtype">sqlite3_stmt * </td>
1058 <td class="paramname"> <em>stmt</em>, </td>
1061 <td class="paramkey"></td>
1063 <td class="paramtype">struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
1064 <td class="paramname"> <em>finfo</em></td><td> </td>
1069 <td></td><td></td><td></td>
1073 <div class="memdoc">
1077 <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>
1079 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00139">lms_file_info::dtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00137">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#l00138">lms_file_info::mtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00134">lms_file_info::path</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00135">lms_file_info::path_len</a>, and <a class="el" href="lightmediascanner__plugin_8h-source.html#l00140">lms_file_info::size</a>.</p>
1082 <div class="dynheader">
1083 Here is the call graph for this function:</div>
1084 <div class="dynsection">
1085 <p><center><img src="lightmediascanner__db__common_8c_e529ad5c4478d53685c65ec69dc5b1f4_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_e529ad5c4478d53685c65ec69dc5b1f4_cgraph_map" alt=""></center>
1086 <map name="lightmediascanner__db__common_8c_e529ad5c4478d53685c65ec69dc5b1f4_cgraph_map">
1087 <area shape="rect" href="lightmediascanner__db__common_8c.html#fee26461dbd6c89c82794c94aaeeaef6" title="lms_db_bind_blob" alt="" coords="235,6,371,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f" title="lms_db_bind_int" alt="" coords="240,56,365,83"><area shape="rect" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419" title="lms_db_reset_stmt" alt="" coords="227,107,379,134"><area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="428,107,593,134"></map>
1092 <a class="anchor" name="226c6f7ab2e7923b747b7090357ea419"></a><!-- doxytag: member="lightmediascanner_db_common.c::lms_db_reset_stmt" ref="226c6f7ab2e7923b747b7090357ea419" args="(sqlite3_stmt *stmt)" -->
1093 <div class="memitem">
1094 <div class="memproto">
1095 <table class="memname">
1097 <td class="memname">int lms_db_reset_stmt </td>
1099 <td class="paramtype">sqlite3_stmt * </td>
1100 <td class="paramname"> <em>stmt</em> </td>
1101 <td> ) </td>
1106 <div class="memdoc">
1110 <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>
1112 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00036">sqlite3_clear_bindings()</a>.</p>
1114 <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>
1117 <div class="dynheader">
1118 Here is the call graph for this function:</div>
1119 <div class="dynsection">
1120 <p><center><img src="lightmediascanner__db__common_8c_226c6f7ab2e7923b747b7090357ea419_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_226c6f7ab2e7923b747b7090357ea419_cgraph_map" alt=""></center>
1121 <map name="lightmediascanner__db__common_8c_226c6f7ab2e7923b747b7090357ea419_cgraph_map">
1122 <area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="207,5,372,32"></map>
1127 <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)" -->
1128 <div class="memitem">
1129 <div class="memproto">
1130 <table class="memname">
1132 <td class="memname">int lms_db_set_file_dtime </td>
1134 <td class="paramtype">sqlite3_stmt * </td>
1135 <td class="paramname"> <em>stmt</em>, </td>
1138 <td class="paramkey"></td>
1140 <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
1141 <td class="paramname"> <em>finfo</em></td><td> </td>
1146 <td></td><td></td><td></td>
1150 <div class="memdoc">
1154 <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>
1156 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00139">lms_file_info::dtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00137">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>
1159 <div class="dynheader">
1160 Here is the call graph for this function:</div>
1161 <div class="dynsection">
1162 <p><center><img src="lightmediascanner__db__common_8c_024e3bd9385fd740f75618716c90b04f_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_024e3bd9385fd740f75618716c90b04f_cgraph_map" alt=""></center>
1163 <map name="lightmediascanner__db__common_8c_024e3bd9385fd740f75618716c90b04f_cgraph_map">
1164 <area shape="rect" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f" title="lms_db_bind_int" alt="" coords="240,6,365,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#f2fe78bc45dc33d843313a846db5ce7c" title="lms_db_bind_int64" alt="" coords="232,56,373,83"><area shape="rect" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419" title="lms_db_reset_stmt" alt="" coords="227,107,379,134"><area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="428,107,593,134"></map>
1169 <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)" -->
1170 <div class="memitem">
1171 <div class="memproto">
1172 <table class="memname">
1174 <td class="memname">int lms_db_table_update </td>
1176 <td class="paramtype">sqlite3 * </td>
1177 <td class="paramname"> <em>db</em>, </td>
1180 <td class="paramkey"></td>
1182 <td class="paramtype">const char * </td>
1183 <td class="paramname"> <em>table</em>, </td>
1186 <td class="paramkey"></td>
1188 <td class="paramtype">unsigned int </td>
1189 <td class="paramname"> <em>current_version</em>, </td>
1192 <td class="paramkey"></td>
1194 <td class="paramtype">unsigned int </td>
1195 <td class="paramname"> <em>last_version</em>, </td>
1198 <td class="paramkey"></td>
1200 <td class="paramtype">const <a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> * </td>
1201 <td class="paramname"> <em>updaters</em></td><td> </td>
1206 <td></td><td></td><td></td>
1210 <div class="memdoc">
1214 <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>
1216 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00304">lms_db_table_version_set()</a>.</p>
1218 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00367">lms_db_table_update_if_required()</a>.</p>
1221 <div class="dynheader">
1222 Here is the call graph for this function:</div>
1223 <div class="dynsection">
1224 <p><center><img src="lightmediascanner__db__common_8c_9bca88ae79959baff3accee8ce10b558_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_9bca88ae79959baff3accee8ce10b558_cgraph_map" alt=""></center>
1225 <map name="lightmediascanner__db__common_8c_9bca88ae79959baff3accee8ce10b558_cgraph_map">
1226 <area shape="rect" href="lightmediascanner__db__common_8c.html#46e6e318ea9bb4a7ffdfe40c842da4e7" title="lms_db_table_version_set" alt="" coords="219,107,413,133"><area shape="rect" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f" title="lms_db_bind_int" alt="" coords="483,5,608,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#88c461ae88da3eb47987c5a0b15c5888" title="lms_db_bind_text" alt="" coords="476,56,615,83"><area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="461,107,629,133"><area shape="rect" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5" title="lms_db_finalize_stmt" alt="" coords="464,157,627,184"><area shape="rect" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419" title="lms_db_reset_stmt" alt="" coords="469,208,621,235"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="688,107,835,133"><area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="679,208,844,235"></map>
1231 <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)" -->
1232 <div class="memitem">
1233 <div class="memproto">
1234 <table class="memname">
1236 <td class="memname">int lms_db_table_update_if_required </td>
1238 <td class="paramtype">sqlite3 * </td>
1239 <td class="paramname"> <em>db</em>, </td>
1242 <td class="paramkey"></td>
1244 <td class="paramtype">const char * </td>
1245 <td class="paramname"> <em>table</em>, </td>
1248 <td class="paramkey"></td>
1250 <td class="paramtype">unsigned int </td>
1251 <td class="paramname"> <em>last_version</em>, </td>
1254 <td class="paramkey"></td>
1256 <td class="paramtype"><a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> * </td>
1257 <td class="paramname"> <em>updaters</em></td><td> </td>
1262 <td></td><td></td><td></td>
1266 <div class="memdoc">
1270 <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>
1272 <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>
1275 <div class="dynheader">
1276 Here is the call graph for this function:</div>
1277 <div class="dynsection">
1278 <p><center><img src="lightmediascanner__db__common_8c_86b766535f9dc7895da7d0f606201700_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_86b766535f9dc7895da7d0f606201700_cgraph_map" alt=""></center>
1279 <map name="lightmediascanner__db__common_8c_86b766535f9dc7895da7d0f606201700_cgraph_map">
1280 <area shape="rect" href="lightmediascanner__db__common_8c.html#9bca88ae79959baff3accee8ce10b558" title="lms_db_table_update" alt="" coords="297,107,460,133"><area shape="rect" href="lightmediascanner__db__common_8c.html#eba3215ee5981a73e9d0fed0a7e079cd" title="lms_db_table_version_get" alt="" coords="511,157,705,184"><area shape="rect" href="lightmediascanner__db__common_8c.html#46e6e318ea9bb4a7ffdfe40c842da4e7" title="lms_db_table_version_set" alt="" coords="511,107,705,133"><area shape="rect" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f" title="lms_db_bind_int" alt="" coords="776,5,901,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#88c461ae88da3eb47987c5a0b15c5888" title="lms_db_bind_text" alt="" coords="769,107,908,133"><area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="755,56,923,83"><area shape="rect" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5" title="lms_db_finalize_stmt" alt="" coords="757,208,920,235"><area shape="rect" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419" title="lms_db_reset_stmt" alt="" coords="763,157,915,184"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="981,56,1128,83"><area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="972,157,1137,184"></map>
1285 <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)" -->
1286 <div class="memitem">
1287 <div class="memproto">
1288 <table class="memname">
1290 <td class="memname">int lms_db_table_version_get </td>
1292 <td class="paramtype">sqlite3 * </td>
1293 <td class="paramname"> <em>db</em>, </td>
1296 <td class="paramkey"></td>
1298 <td class="paramtype">const char * </td>
1299 <td class="paramname"> <em>table</em></td><td> </td>
1304 <td></td><td></td><td></td>
1308 <div class="memdoc">
1312 <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>
1314 <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>
1316 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00367">lms_db_table_update_if_required()</a>.</p>
1319 <div class="dynheader">
1320 Here is the call graph for this function:</div>
1321 <div class="dynsection">
1322 <p><center><img src="lightmediascanner__db__common_8c_eba3215ee5981a73e9d0fed0a7e079cd_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_eba3215ee5981a73e9d0fed0a7e079cd_cgraph_map" alt=""></center>
1323 <map name="lightmediascanner__db__common_8c_eba3215ee5981a73e9d0fed0a7e079cd_cgraph_map">
1324 <area shape="rect" href="lightmediascanner__db__common_8c.html#88c461ae88da3eb47987c5a0b15c5888" title="lms_db_bind_text" alt="" coords="265,5,404,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="251,56,419,82"><area shape="rect" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5" title="lms_db_finalize_stmt" alt="" coords="253,106,416,133"><area shape="rect" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419" title="lms_db_reset_stmt" alt="" coords="259,157,411,184"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="477,56,624,82"><area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="468,157,633,184"></map>
1329 <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)" -->
1330 <div class="memitem">
1331 <div class="memproto">
1332 <table class="memname">
1334 <td class="memname">int lms_db_table_version_set </td>
1336 <td class="paramtype">sqlite3 * </td>
1337 <td class="paramname"> <em>db</em>, </td>
1340 <td class="paramkey"></td>
1342 <td class="paramtype">const char * </td>
1343 <td class="paramname"> <em>table</em>, </td>
1346 <td class="paramkey"></td>
1348 <td class="paramtype">unsigned int </td>
1349 <td class="paramname"> <em>version</em></td><td> </td>
1354 <td></td><td></td><td></td>
1358 <div class="memdoc">
1362 <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>
1364 <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>
1366 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00337">lms_db_table_update()</a>.</p>
1369 <div class="dynheader">
1370 Here is the call graph for this function:</div>
1371 <div class="dynsection">
1372 <p><center><img src="lightmediascanner__db__common_8c_46e6e318ea9bb4a7ffdfe40c842da4e7_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_46e6e318ea9bb4a7ffdfe40c842da4e7_cgraph_map" alt=""></center>
1373 <map name="lightmediascanner__db__common_8c_46e6e318ea9bb4a7ffdfe40c842da4e7_cgraph_map">
1374 <area shape="rect" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f" title="lms_db_bind_int" alt="" coords="269,5,395,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#88c461ae88da3eb47987c5a0b15c5888" title="lms_db_bind_text" alt="" coords="263,56,401,83"><area shape="rect" href="lightmediascanner__db__common_8c.html#5fddf47521f83929b0c90a481fa01c5b" title="lms_db_compile_stmt" alt="" coords="248,107,416,133"><area shape="rect" href="lightmediascanner__db__common_8c.html#32110a4825e598ca6df329f55b0b62b5" title="lms_db_finalize_stmt" alt="" coords="251,157,413,184"><area shape="rect" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419" title="lms_db_reset_stmt" alt="" coords="256,208,408,235"><area shape="rect" href="lightmediascanner__db__common_8c.html#21da1a6588f354b758211583559ae405" title="sqlite3_prepare_v2" alt="" coords="475,107,621,133"><area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="465,208,631,235"></map>
1379 <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)" -->
1380 <div class="memitem">
1381 <div class="memproto">
1382 <table class="memname">
1384 <td class="memname">int lms_db_update_file_info </td>
1386 <td class="paramtype">sqlite3_stmt * </td>
1387 <td class="paramname"> <em>stmt</em>, </td>
1390 <td class="paramkey"></td>
1392 <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
1393 <td class="paramname"> <em>finfo</em></td><td> </td>
1398 <td></td><td></td><td></td>
1402 <div class="memdoc">
1406 <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>
1408 <p>References <a class="el" href="lightmediascanner__plugin_8h-source.html#l00139">lms_file_info::dtime</a>, <a class="el" href="lightmediascanner__plugin_8h-source.html#l00137">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#l00138">lms_file_info::mtime</a>, and <a class="el" href="lightmediascanner__plugin_8h-source.html#l00140">lms_file_info::size</a>.</p>
1411 <div class="dynheader">
1412 Here is the call graph for this function:</div>
1413 <div class="dynsection">
1414 <p><center><img src="lightmediascanner__db__common_8c_0f727cd41bbb90af2e08b3ee7ca76de9_cgraph.png" border="0" usemap="#lightmediascanner__db__common_8c_0f727cd41bbb90af2e08b3ee7ca76de9_cgraph_map" alt=""></center>
1415 <map name="lightmediascanner__db__common_8c_0f727cd41bbb90af2e08b3ee7ca76de9_cgraph_map">
1416 <area shape="rect" href="lightmediascanner__db__common_8c.html#de261036cf3228f0b6a79a9c68687c4f" title="lms_db_bind_int" alt="" coords="248,5,373,32"><area shape="rect" href="lightmediascanner__db__common_8c.html#226c6f7ab2e7923b747b7090357ea419" title="lms_db_reset_stmt" alt="" coords="235,56,387,83"><area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="436,56,601,83"></map>
1421 <a class="anchor" name="3f8fb8f31c1876b3579956b3d898cd00"></a><!-- doxytag: member="lightmediascanner_db_common.c::sqlite3_clear_bindings" ref="3f8fb8f31c1876b3579956b3d898cd00" args="(sqlite3_stmt *stmt)" -->
1422 <div class="memitem">
1423 <div class="memproto">
1424 <table class="memname">
1426 <td class="memname">int sqlite3_clear_bindings </td>
1428 <td class="paramtype">sqlite3_stmt * </td>
1429 <td class="paramname"> <em>stmt</em> </td>
1430 <td> ) </td>
1435 <div class="memdoc">
1439 <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>
1441 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00128">lms_db_reset_stmt()</a>.</p>
1445 <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)" -->
1446 <div class="memitem">
1447 <div class="memproto">
1448 <table class="memname">
1450 <td class="memname">int sqlite3_prepare_v2 </td>
1452 <td class="paramtype">sqlite3 * </td>
1453 <td class="paramname"> <em>db</em>, </td>
1456 <td class="paramkey"></td>
1458 <td class="paramtype">const char * </td>
1459 <td class="paramname"> <em>sql</em>, </td>
1462 <td class="paramkey"></td>
1464 <td class="paramtype">int </td>
1465 <td class="paramname"> <em>len</em>, </td>
1468 <td class="paramkey"></td>
1470 <td class="paramtype">sqlite3_stmt ** </td>
1471 <td class="paramname"> <em>stmt</em>, </td>
1474 <td class="paramkey"></td>
1476 <td class="paramtype">const char ** </td>
1477 <td class="paramname"> <em>tail</em></td><td> </td>
1482 <td></td><td></td><td></td>
1486 <div class="memdoc">
1489 Copyright (C) 2007 by INdT<p>
1490 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>
1491 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>
1492 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>
1493 <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>
1495 <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>
1497 <p>Referenced by <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
1502 <hr size="1"><address style="text-align: right;"><small>Generated on Sun Oct 5 12:24:56 2008 for Light Media Scanner by
1503 <a href="http://www.doxygen.org/index.html">
1504 <img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.6 </small></address>