announce project is moving outside of garage.maemo.org
[lms] / www / api / lightmediascanner__db__private_8h.html
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_private.h File Reference</title>
4 <link href="tabs.css" rel="stylesheet" type="text/css">
5 <link href="doxygen.css" rel="stylesheet" type="text/css">
6 </head><body>
7 <!-- Generated by Doxygen 1.5.8 -->
8 <div class="navigation" id="top">
9   <div class="tabs">
10     <ul>
11       <li><a href="index.html"><span>Main&nbsp;Page</span></a></li>
12       <li><a href="modules.html"><span>Modules</span></a></li>
13       <li><a href="annotated.html"><span>Data&nbsp;Structures</span></a></li>
14       <li class="current"><a href="files.html"><span>Files</span></a></li>
15     </ul>
16   </div>
17   <div class="tabs">
18     <ul>
19       <li><a href="files.html"><span>File&nbsp;List</span></a></li>
20       <li><a href="globals.html"><span>Globals</span></a></li>
21     </ul>
22   </div>
23 </div>
24 <div class="contents">
25 <h1>src/lib/lightmediascanner_db_private.h File Reference</h1><code>#include &lt;sqlite3.h&gt;</code><br>
26 <code>#include &lt;sys/types.h&gt;</code><br>
27 <code>#include &quot;<a class="el" href="lightmediascanner__plugin_8h-source.html">lightmediascanner_plugin.h</a>&quot;</code><br>
28
29 <p>
30 <div class="dynheader">
31 Include dependency graph for lightmediascanner_db_private.h:</div>
32 <div class="dynsection">
33 </div>
34
35 <p>
36 <div class="dynheader">
37 This graph shows which files directly or indirectly include this file:</div>
38 <div class="dynsection">
39 </div>
40
41 <p>
42 <a href="lightmediascanner__db__private_8h-source.html">Go to the source code of this file.</a><table border="0" cellpadding="0" cellspacing="0">
43 <tr><td></td></tr>
44 <tr><td colspan="2"><br><h2>Data Structures</h2></td></tr>
45 <tr><td class="memItemLeft" nowrap align="right" valign="top">struct &nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlms__db__cache__entry.html">lms_db_cache_entry</a></td></tr>
46
47 <tr><td class="memItemLeft" nowrap align="right" valign="top">struct &nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlms__db__cache.html">lms_db_cache</a></td></tr>
48
49 <tr><td colspan="2"><br><h2>Defines</h2></td></tr>
50 <tr><td class="memItemLeft" nowrap align="right" valign="top">#define&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#97d5ed207ef5b72f4fba0cab38594bb7">_LIGHTMEDIASCANNER_DB_PRIVATE_H_</a>&nbsp;&nbsp;&nbsp;1</td></tr>
51
52 <tr><td class="memItemLeft" nowrap align="right" valign="top">#define&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#6fe68cac0abf3e2ca61141920414e93a">GNUC_NON_NULL</a>(...)</td></tr>
53
54 <tr><td colspan="2"><br><h2>Functions</h2></td></tr>
55 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#6301bd096100f8adf24d2caff3aa0b75">lms_db_compile_stmt</a> (sqlite3 *db, const char *sql) GNUC_NON_NULL(1</td></tr>
56
57 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#2660f629fbdf3d4144a6143fee837a27">lms_db_finalize_stmt</a> (sqlite3_stmt *stmt, const char *name) GNUC_NON_NULL(1</td></tr>
58
59 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#ee78f418f0f3c9ead3023b1453c63556">lms_db_reset_stmt</a> (sqlite3_stmt *stmt) GNUC_NON_NULL(1)</td></tr>
60
61 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#14d56e02624ad6130bc59ae9bb950ac3">lms_db_bind_text</a> (sqlite3_stmt *stmt, int col, const char *text, int len) GNUC_NON_NULL(1)</td></tr>
62
63 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#7fd514b582578c18a25cdbf6c561243c">lms_db_bind_blob</a> (sqlite3_stmt *stmt, int col, const void *blob, int len) GNUC_NON_NULL(1)</td></tr>
64
65 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#bbb18d7cc44f7e363c0f240849d72c31">lms_db_bind_int64</a> (sqlite3_stmt *stmt, int col, int64_t value) GNUC_NON_NULL(1)</td></tr>
66
67 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#cd7006f0271b9a47937dc2d2ae5480fe">lms_db_bind_int64_or_null</a> (sqlite3_stmt *stmt, int col, int64_t *p_value) GNUC_NON_NULL(1)</td></tr>
68
69 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#37815f859116b46089bea4ba84bb23d2">lms_db_bind_int</a> (sqlite3_stmt *stmt, int col, int value) GNUC_NON_NULL(1)</td></tr>
70
71 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#9e78297037179998924354e73ca69349">lms_db_bind_double</a> (sqlite3_stmt *stmt, int col, double value) GNUC_NON_NULL(1)</td></tr>
72
73 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#f47d604dd4e11f81be1ad045ee723789">lms_db_create_trigger_if_not_exists</a> (sqlite3 *db, const char *sql) GNUC_NON_NULL(1</td></tr>
74
75 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#23cf7fff49641b39c017bdd076b112a7">lms_db_table_version_get</a> (sqlite3 *db, const char *table) GNUC_NON_NULL(1</td></tr>
76
77 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#1c57f68c64069575a36252816929e335">lms_db_table_version_set</a> (sqlite3 *db, const char *table, unsigned int version) GNUC_NON_NULL(1</td></tr>
78
79 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#3dcf825514196befd0a4575e4afd0b58">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) GNUC_NON_NULL(1</td></tr>
80
81 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#455c0e5d62094b01fc935c5db8f07352">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) GNUC_NON_NULL(1</td></tr>
82
83 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#f2c9e9154fff8b335c4fd5693fe45aa6">lms_db_cache_add</a> (struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> *cache, const sqlite3 *db, void *data) GNUC_NON_NULL(1</td></tr>
84
85 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#e3e18958c74ba988c2bfdf77a3793ceb">lms_db_cache_del</a> (struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> *cache, const sqlite3 *db, void *data) GNUC_NON_NULL(1</td></tr>
86
87 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#ec1ff2c5b629374611336d56871a8c0b">lms_db_cache_get</a> (struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> *cache, const sqlite3 *db, void **pdata) GNUC_NON_NULL(1</td></tr>
88
89 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#13ca09c885535a2968e707120e935268">lms_db_create_core_tables_if_required</a> (sqlite3 *db) GNUC_NON_NULL(1)</td></tr>
90
91 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#073c254ca7b4d3f42e1be1854bcc42a3">lms_db_compile_stmt_begin_transaction</a> (sqlite3 *db) GNUC_NON_NULL(1)</td></tr>
92
93 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#09feca4fbfde33d5647cdd5cc2de6500">lms_db_compile_stmt_end_transaction</a> (sqlite3 *db) GNUC_NON_NULL(1)</td></tr>
94
95 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#327d54a6dac083e356fd609298a0cbd5">lms_db_compile_stmt_get_file_info</a> (sqlite3 *db) GNUC_NON_NULL(1)</td></tr>
96
97 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#bf21f88ddbe28a8290d0df32af0f079c">lms_db_compile_stmt_insert_file_info</a> (sqlite3 *db) GNUC_NON_NULL(1)</td></tr>
98
99 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#69eb9d9058d9432f7658f9adffb79ed6">lms_db_compile_stmt_update_file_info</a> (sqlite3 *db) GNUC_NON_NULL(1)</td></tr>
100
101 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#76941bdbbdb711fff821343e91c2cd97">lms_db_compile_stmt_delete_file_info</a> (sqlite3 *db) GNUC_NON_NULL(1)</td></tr>
102
103 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#08c34b5b1b6e927a696ff0ce66562f54">lms_db_compile_stmt_set_file_dtime</a> (sqlite3 *db) GNUC_NON_NULL(1)</td></tr>
104
105 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#1cc8a80961a0febdd099a028f3da9c30">lms_db_compile_stmt_get_files</a> (sqlite3 *db) GNUC_NON_NULL(1)</td></tr>
106
107 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#3a7256cb653542bbf563feeb2aa2d0ea">lms_db_begin_transaction</a> (sqlite3_stmt *stmt) GNUC_NON_NULL(1)</td></tr>
108
109 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#8ee7bfba83958b80f717a6ccbad2a84c">lms_db_end_transaction</a> (sqlite3_stmt *stmt) GNUC_NON_NULL(1)</td></tr>
110
111 <tr><td class="memItemLeft" nowrap align="right" valign="top">int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#9cce62321be32274de720ec946473eeb">lms_db_update_file_info</a> (sqlite3_stmt *stmt, const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo) GNUC_NON_NULL(1</td></tr>
112
113 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#e1df123e8d894a49f740ec6429af8159">lms_db_get_file_info</a> (sqlite3_stmt *stmt, struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo) GNUC_NON_NULL(1</td></tr>
114
115 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#9353bf3cfbe2c0045023658597b0cf1d">lms_db_insert_file_info</a> (sqlite3_stmt *stmt, struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo) GNUC_NON_NULL(1</td></tr>
116
117 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#ec17baec1e001f67334b0265d465fb50">lms_db_delete_file_info</a> (sqlite3_stmt *stmt, const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo) GNUC_NON_NULL(1</td></tr>
118
119 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#0fa3bfe1fa3a01a4dd231b6f818122cb">lms_db_set_file_dtime</a> (sqlite3_stmt *stmt, const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *finfo) GNUC_NON_NULL(1</td></tr>
120
121 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int int int int&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#617b14b976ba1cde9fe639800f2eae71">lms_db_get_files</a> (sqlite3_stmt *stmt, const char *path, int len) GNUC_NON_NULL(1</td></tr>
122
123 <tr><td colspan="2"><br><h2>Variables</h2></td></tr>
124 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int typedef int(*&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> )(sqlite3 *db, const char *table, unsigned int current_version, int is_last_run)</td></tr>
125
126 </table>
127 <hr><h2>Define Documentation</h2>
128 <a class="anchor" name="97d5ed207ef5b72f4fba0cab38594bb7"></a><!-- doxytag: member="lightmediascanner_db_private.h::_LIGHTMEDIASCANNER_DB_PRIVATE_H_" ref="97d5ed207ef5b72f4fba0cab38594bb7" args="" -->
129 <div class="memitem">
130 <div class="memproto">
131       <table class="memname">
132         <tr>
133           <td class="memname">#define _LIGHTMEDIASCANNER_DB_PRIVATE_H_&nbsp;&nbsp;&nbsp;1          </td>
134         </tr>
135       </table>
136 </div>
137 <div class="memdoc">
138
139 <p>
140 Copyright (C) 2007 by INdT<p>
141 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>
142 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>
143 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>
144 <dl class="author" compact><dt><b>Author:</b></dt><dd>Gustavo Sverzut Barbieri &lt;<a href="mailto:gustavo.barbieri@openbossa.org">gustavo.barbieri@openbossa.org</a>&gt; </dd></dl>
145
146 <p>Definition at line <a class="el" href="lightmediascanner__db__private_8h-source.html#l00022">22</a> of file <a class="el" href="lightmediascanner__db__private_8h-source.html">lightmediascanner_db_private.h</a>.</p>
147
148 </div>
149 </div><p>
150 <a class="anchor" name="6fe68cac0abf3e2ca61141920414e93a"></a><!-- doxytag: member="lightmediascanner_db_private.h::GNUC_NON_NULL" ref="6fe68cac0abf3e2ca61141920414e93a" args="(...)" -->
151 <div class="memitem">
152 <div class="memproto">
153       <table class="memname">
154         <tr>
155           <td class="memname">#define GNUC_NON_NULL          </td>
156           <td>(</td>
157           <td class="paramtype"> <em>...</em>&nbsp;</td>
158           <td class="paramname">          </td>
159           <td>&nbsp;)&nbsp;</td>
160           <td></td>
161         </tr>
162       </table>
163 </div>
164 <div class="memdoc">
165
166 <p>
167
168 <p>Definition at line <a class="el" href="lightmediascanner__db__private_8h-source.html#l00031">31</a> of file <a class="el" href="lightmediascanner__db__private_8h-source.html">lightmediascanner_db_private.h</a>.</p>
169
170 </div>
171 </div><p>
172 <hr><h2>Function Documentation</h2>
173 <a class="anchor" name="3a7256cb653542bbf563feeb2aa2d0ea"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_begin_transaction" ref="3a7256cb653542bbf563feeb2aa2d0ea" args="(sqlite3_stmt *stmt) GNUC_NON_NULL(1)" -->
174 <div class="memitem">
175 <div class="memproto">
176       <table class="memname">
177         <tr>
178           <td class="memname">int lms_db_begin_transaction           </td>
179           <td>(</td>
180           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
181           <td class="paramname"> <em>stmt</em>          </td>
182           <td>&nbsp;)&nbsp;</td>
183           <td></td>
184         </tr>
185       </table>
186 </div>
187 <div class="memdoc">
188
189 <p>
190
191 <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>
192
193 <p>Referenced by <a class="el" href="lightmediascanner__process_8c-source.html#l01047">lms_process_single_process()</a>.</p>
194
195 </div>
196 </div><p>
197 <a class="anchor" name="7fd514b582578c18a25cdbf6c561243c"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_bind_blob" ref="7fd514b582578c18a25cdbf6c561243c" args="(sqlite3_stmt *stmt, int col, const void *blob, int len) GNUC_NON_NULL(1)" -->
198 <div class="memitem">
199 <div class="memproto">
200       <table class="memname">
201         <tr>
202           <td class="memname">int lms_db_bind_blob           </td>
203           <td>(</td>
204           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
205           <td class="paramname"> <em>stmt</em>, </td>
206         </tr>
207         <tr>
208           <td class="paramkey"></td>
209           <td></td>
210           <td class="paramtype">int&nbsp;</td>
211           <td class="paramname"> <em>col</em>, </td>
212         </tr>
213         <tr>
214           <td class="paramkey"></td>
215           <td></td>
216           <td class="paramtype">const void *&nbsp;</td>
217           <td class="paramname"> <em>blob</em>, </td>
218         </tr>
219         <tr>
220           <td class="paramkey"></td>
221           <td></td>
222           <td class="paramtype">int&nbsp;</td>
223           <td class="paramname"> <em>len</em></td><td>&nbsp;</td>
224         </tr>
225         <tr>
226           <td></td>
227           <td>)</td>
228           <td></td><td></td><td></td>
229         </tr>
230       </table>
231 </div>
232 <div class="memdoc">
233
234 <p>
235
236 <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>
237
238 <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>
239
240 </div>
241 </div><p>
242 <a class="anchor" name="9e78297037179998924354e73ca69349"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_bind_double" ref="9e78297037179998924354e73ca69349" args="(sqlite3_stmt *stmt, int col, double value) GNUC_NON_NULL(1)" -->
243 <div class="memitem">
244 <div class="memproto">
245       <table class="memname">
246         <tr>
247           <td class="memname">int lms_db_bind_double           </td>
248           <td>(</td>
249           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
250           <td class="paramname"> <em>stmt</em>, </td>
251         </tr>
252         <tr>
253           <td class="paramkey"></td>
254           <td></td>
255           <td class="paramtype">int&nbsp;</td>
256           <td class="paramname"> <em>col</em>, </td>
257         </tr>
258         <tr>
259           <td class="paramkey"></td>
260           <td></td>
261           <td class="paramtype">double&nbsp;</td>
262           <td class="paramname"> <em>value</em></td><td>&nbsp;</td>
263         </tr>
264         <tr>
265           <td></td>
266           <td>)</td>
267           <td></td><td></td><td></td>
268         </tr>
269       </table>
270 </div>
271 <div class="memdoc">
272
273 <p>
274
275 <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>
276
277 </div>
278 </div><p>
279 <a class="anchor" name="37815f859116b46089bea4ba84bb23d2"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_bind_int" ref="37815f859116b46089bea4ba84bb23d2" args="(sqlite3_stmt *stmt, int col, int value) GNUC_NON_NULL(1)" -->
280 <div class="memitem">
281 <div class="memproto">
282       <table class="memname">
283         <tr>
284           <td class="memname">int lms_db_bind_int           </td>
285           <td>(</td>
286           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
287           <td class="paramname"> <em>stmt</em>, </td>
288         </tr>
289         <tr>
290           <td class="paramkey"></td>
291           <td></td>
292           <td class="paramtype">int&nbsp;</td>
293           <td class="paramname"> <em>col</em>, </td>
294         </tr>
295         <tr>
296           <td class="paramkey"></td>
297           <td></td>
298           <td class="paramtype">int&nbsp;</td>
299           <td class="paramname"> <em>value</em></td><td>&nbsp;</td>
300         </tr>
301         <tr>
302           <td></td>
303           <td>)</td>
304           <td></td><td></td><td></td>
305         </tr>
306       </table>
307 </div>
308 <div class="memdoc">
309
310 <p>
311
312 <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>
313
314 <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>
315
316 </div>
317 </div><p>
318 <a class="anchor" name="bbb18d7cc44f7e363c0f240849d72c31"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_bind_int64" ref="bbb18d7cc44f7e363c0f240849d72c31" args="(sqlite3_stmt *stmt, int col, int64_t value) GNUC_NON_NULL(1)" -->
319 <div class="memitem">
320 <div class="memproto">
321       <table class="memname">
322         <tr>
323           <td class="memname">int lms_db_bind_int64           </td>
324           <td>(</td>
325           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
326           <td class="paramname"> <em>stmt</em>, </td>
327         </tr>
328         <tr>
329           <td class="paramkey"></td>
330           <td></td>
331           <td class="paramtype">int&nbsp;</td>
332           <td class="paramname"> <em>col</em>, </td>
333         </tr>
334         <tr>
335           <td class="paramkey"></td>
336           <td></td>
337           <td class="paramtype">int64_t&nbsp;</td>
338           <td class="paramname"> <em>value</em></td><td>&nbsp;</td>
339         </tr>
340         <tr>
341           <td></td>
342           <td>)</td>
343           <td></td><td></td><td></td>
344         </tr>
345       </table>
346 </div>
347 <div class="memdoc">
348
349 <p>
350
351 <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>
352
353 <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>
354
355 </div>
356 </div><p>
357 <a class="anchor" name="cd7006f0271b9a47937dc2d2ae5480fe"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_bind_int64_or_null" ref="cd7006f0271b9a47937dc2d2ae5480fe" args="(sqlite3_stmt *stmt, int col, int64_t *p_value) GNUC_NON_NULL(1)" -->
358 <div class="memitem">
359 <div class="memproto">
360       <table class="memname">
361         <tr>
362           <td class="memname">int lms_db_bind_int64_or_null           </td>
363           <td>(</td>
364           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
365           <td class="paramname"> <em>stmt</em>, </td>
366         </tr>
367         <tr>
368           <td class="paramkey"></td>
369           <td></td>
370           <td class="paramtype">int&nbsp;</td>
371           <td class="paramname"> <em>col</em>, </td>
372         </tr>
373         <tr>
374           <td class="paramkey"></td>
375           <td></td>
376           <td class="paramtype">int64_t *&nbsp;</td>
377           <td class="paramname"> <em>p_value</em></td><td>&nbsp;</td>
378         </tr>
379         <tr>
380           <td></td>
381           <td>)</td>
382           <td></td><td></td><td></td>
383         </tr>
384       </table>
385 </div>
386 <div class="memdoc">
387
388 <p>
389
390 <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>
391
392 </div>
393 </div><p>
394 <a class="anchor" name="14d56e02624ad6130bc59ae9bb950ac3"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_bind_text" ref="14d56e02624ad6130bc59ae9bb950ac3" args="(sqlite3_stmt *stmt, int col, const char *text, int len) GNUC_NON_NULL(1)" -->
395 <div class="memitem">
396 <div class="memproto">
397       <table class="memname">
398         <tr>
399           <td class="memname">int lms_db_bind_text           </td>
400           <td>(</td>
401           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
402           <td class="paramname"> <em>stmt</em>, </td>
403         </tr>
404         <tr>
405           <td class="paramkey"></td>
406           <td></td>
407           <td class="paramtype">int&nbsp;</td>
408           <td class="paramname"> <em>col</em>, </td>
409         </tr>
410         <tr>
411           <td class="paramkey"></td>
412           <td></td>
413           <td class="paramtype">const char *&nbsp;</td>
414           <td class="paramname"> <em>text</em>, </td>
415         </tr>
416         <tr>
417           <td class="paramkey"></td>
418           <td></td>
419           <td class="paramtype">int&nbsp;</td>
420           <td class="paramname"> <em>len</em></td><td>&nbsp;</td>
421         </tr>
422         <tr>
423           <td></td>
424           <td>)</td>
425           <td></td><td></td><td></td>
426         </tr>
427       </table>
428 </div>
429 <div class="memdoc">
430
431 <p>
432
433 <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>
434
435 <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>
436
437 </div>
438 </div><p>
439 <a class="anchor" name="f2c9e9154fff8b335c4fd5693fe45aa6"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_cache_add" ref="f2c9e9154fff8b335c4fd5693fe45aa6" args="(struct lms_db_cache *cache, const sqlite3 *db, void *data) GNUC_NON_NULL(1" -->
440 <div class="memitem">
441 <div class="memproto">
442       <table class="memname">
443         <tr>
444           <td class="memname">int lms_db_cache_add           </td>
445           <td>(</td>
446           <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> *&nbsp;</td>
447           <td class="paramname"> <em>cache</em>, </td>
448         </tr>
449         <tr>
450           <td class="paramkey"></td>
451           <td></td>
452           <td class="paramtype">const sqlite3 *&nbsp;</td>
453           <td class="paramname"> <em>db</em>, </td>
454         </tr>
455         <tr>
456           <td class="paramkey"></td>
457           <td></td>
458           <td class="paramtype">void *&nbsp;</td>
459           <td class="paramname"> <em>data</em></td><td>&nbsp;</td>
460         </tr>
461         <tr>
462           <td></td>
463           <td>)</td>
464           <td></td><td></td><td></td>
465         </tr>
466       </table>
467 </div>
468 <div class="memdoc">
469
470 <p>
471
472 </div>
473 </div><p>
474 <a class="anchor" name="e3e18958c74ba988c2bfdf77a3793ceb"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_cache_del" ref="e3e18958c74ba988c2bfdf77a3793ceb" args="(struct lms_db_cache *cache, const sqlite3 *db, void *data) GNUC_NON_NULL(1" -->
475 <div class="memitem">
476 <div class="memproto">
477       <table class="memname">
478         <tr>
479           <td class="memname">int int lms_db_cache_del           </td>
480           <td>(</td>
481           <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> *&nbsp;</td>
482           <td class="paramname"> <em>cache</em>, </td>
483         </tr>
484         <tr>
485           <td class="paramkey"></td>
486           <td></td>
487           <td class="paramtype">const sqlite3 *&nbsp;</td>
488           <td class="paramname"> <em>db</em>, </td>
489         </tr>
490         <tr>
491           <td class="paramkey"></td>
492           <td></td>
493           <td class="paramtype">void *&nbsp;</td>
494           <td class="paramname"> <em>data</em></td><td>&nbsp;</td>
495         </tr>
496         <tr>
497           <td></td>
498           <td>)</td>
499           <td></td><td></td><td></td>
500         </tr>
501       </table>
502 </div>
503 <div class="memdoc">
504
505 <p>
506
507 </div>
508 </div><p>
509 <a class="anchor" name="ec1ff2c5b629374611336d56871a8c0b"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_cache_get" ref="ec1ff2c5b629374611336d56871a8c0b" args="(struct lms_db_cache *cache, const sqlite3 *db, void **pdata) GNUC_NON_NULL(1" -->
510 <div class="memitem">
511 <div class="memproto">
512       <table class="memname">
513         <tr>
514           <td class="memname">int int int lms_db_cache_get           </td>
515           <td>(</td>
516           <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> *&nbsp;</td>
517           <td class="paramname"> <em>cache</em>, </td>
518         </tr>
519         <tr>
520           <td class="paramkey"></td>
521           <td></td>
522           <td class="paramtype">const sqlite3 *&nbsp;</td>
523           <td class="paramname"> <em>db</em>, </td>
524         </tr>
525         <tr>
526           <td class="paramkey"></td>
527           <td></td>
528           <td class="paramtype">void **&nbsp;</td>
529           <td class="paramname"> <em>pdata</em></td><td>&nbsp;</td>
530         </tr>
531         <tr>
532           <td></td>
533           <td>)</td>
534           <td></td><td></td><td></td>
535         </tr>
536       </table>
537 </div>
538 <div class="memdoc">
539
540 <p>
541
542 </div>
543 </div><p>
544 <a class="anchor" name="6301bd096100f8adf24d2caff3aa0b75"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_compile_stmt" ref="6301bd096100f8adf24d2caff3aa0b75" args="(sqlite3 *db, const char *sql) GNUC_NON_NULL(1" -->
545 <div class="memitem">
546 <div class="memproto">
547       <table class="memname">
548         <tr>
549           <td class="memname">sqlite3_stmt* lms_db_compile_stmt           </td>
550           <td>(</td>
551           <td class="paramtype">sqlite3 *&nbsp;</td>
552           <td class="paramname"> <em>db</em>, </td>
553         </tr>
554         <tr>
555           <td class="paramkey"></td>
556           <td></td>
557           <td class="paramtype">const char *&nbsp;</td>
558           <td class="paramname"> <em>sql</em></td><td>&nbsp;</td>
559         </tr>
560         <tr>
561           <td></td>
562           <td>)</td>
563           <td></td><td></td><td></td>
564         </tr>
565       </table>
566 </div>
567 <div class="memdoc">
568
569 <p>
570
571 </div>
572 </div><p>
573 <a class="anchor" name="073c254ca7b4d3f42e1be1854bcc42a3"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_compile_stmt_begin_transaction" ref="073c254ca7b4d3f42e1be1854bcc42a3" args="(sqlite3 *db) GNUC_NON_NULL(1)" -->
574 <div class="memitem">
575 <div class="memproto">
576       <table class="memname">
577         <tr>
578           <td class="memname">sqlite3_stmt* lms_db_compile_stmt_begin_transaction           </td>
579           <td>(</td>
580           <td class="paramtype">sqlite3 *&nbsp;</td>
581           <td class="paramname"> <em>db</em>          </td>
582           <td>&nbsp;)&nbsp;</td>
583           <td></td>
584         </tr>
585       </table>
586 </div>
587 <div class="memdoc">
588
589 <p>
590
591 <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>
592
593 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
594
595 <p>
596 <div class="dynheader">
597 Here is the call graph for this function:</div>
598 <div class="dynsection">
599 </div>
600
601 </div>
602 </div><p>
603 <a class="anchor" name="76941bdbbdb711fff821343e91c2cd97"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_compile_stmt_delete_file_info" ref="76941bdbbdb711fff821343e91c2cd97" args="(sqlite3 *db) GNUC_NON_NULL(1)" -->
604 <div class="memitem">
605 <div class="memproto">
606       <table class="memname">
607         <tr>
608           <td class="memname">sqlite3_stmt* lms_db_compile_stmt_delete_file_info           </td>
609           <td>(</td>
610           <td class="paramtype">sqlite3 *&nbsp;</td>
611           <td class="paramname"> <em>db</em>          </td>
612           <td>&nbsp;)&nbsp;</td>
613           <td></td>
614         </tr>
615       </table>
616 </div>
617 <div class="memdoc">
618
619 <p>
620
621 <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>
622
623 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
624
625 <p>
626 <div class="dynheader">
627 Here is the call graph for this function:</div>
628 <div class="dynsection">
629 </div>
630
631 </div>
632 </div><p>
633 <a class="anchor" name="09feca4fbfde33d5647cdd5cc2de6500"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_compile_stmt_end_transaction" ref="09feca4fbfde33d5647cdd5cc2de6500" args="(sqlite3 *db) GNUC_NON_NULL(1)" -->
634 <div class="memitem">
635 <div class="memproto">
636       <table class="memname">
637         <tr>
638           <td class="memname">sqlite3_stmt* lms_db_compile_stmt_end_transaction           </td>
639           <td>(</td>
640           <td class="paramtype">sqlite3 *&nbsp;</td>
641           <td class="paramname"> <em>db</em>          </td>
642           <td>&nbsp;)&nbsp;</td>
643           <td></td>
644         </tr>
645       </table>
646 </div>
647 <div class="memdoc">
648
649 <p>
650
651 <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>
652
653 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
654
655 <p>
656 <div class="dynheader">
657 Here is the call graph for this function:</div>
658 <div class="dynsection">
659 </div>
660
661 </div>
662 </div><p>
663 <a class="anchor" name="327d54a6dac083e356fd609298a0cbd5"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_compile_stmt_get_file_info" ref="327d54a6dac083e356fd609298a0cbd5" args="(sqlite3 *db) GNUC_NON_NULL(1)" -->
664 <div class="memitem">
665 <div class="memproto">
666       <table class="memname">
667         <tr>
668           <td class="memname">sqlite3_stmt* lms_db_compile_stmt_get_file_info           </td>
669           <td>(</td>
670           <td class="paramtype">sqlite3 *&nbsp;</td>
671           <td class="paramname"> <em>db</em>          </td>
672           <td>&nbsp;)&nbsp;</td>
673           <td></td>
674         </tr>
675       </table>
676 </div>
677 <div class="memdoc">
678
679 <p>
680
681 <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>
682
683 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
684
685 <p>
686 <div class="dynheader">
687 Here is the call graph for this function:</div>
688 <div class="dynsection">
689 </div>
690
691 </div>
692 </div><p>
693 <a class="anchor" name="1cc8a80961a0febdd099a028f3da9c30"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_compile_stmt_get_files" ref="1cc8a80961a0febdd099a028f3da9c30" args="(sqlite3 *db) GNUC_NON_NULL(1)" -->
694 <div class="memitem">
695 <div class="memproto">
696       <table class="memname">
697         <tr>
698           <td class="memname">sqlite3_stmt* lms_db_compile_stmt_get_files           </td>
699           <td>(</td>
700           <td class="paramtype">sqlite3 *&nbsp;</td>
701           <td class="paramname"> <em>db</em>          </td>
702           <td>&nbsp;)&nbsp;</td>
703           <td></td>
704         </tr>
705       </table>
706 </div>
707 <div class="memdoc">
708
709 <p>
710
711 <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>
712
713 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
714
715 <p>
716 <div class="dynheader">
717 Here is the call graph for this function:</div>
718 <div class="dynsection">
719 </div>
720
721 </div>
722 </div><p>
723 <a class="anchor" name="bf21f88ddbe28a8290d0df32af0f079c"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_compile_stmt_insert_file_info" ref="bf21f88ddbe28a8290d0df32af0f079c" args="(sqlite3 *db) GNUC_NON_NULL(1)" -->
724 <div class="memitem">
725 <div class="memproto">
726       <table class="memname">
727         <tr>
728           <td class="memname">sqlite3_stmt* lms_db_compile_stmt_insert_file_info           </td>
729           <td>(</td>
730           <td class="paramtype">sqlite3 *&nbsp;</td>
731           <td class="paramname"> <em>db</em>          </td>
732           <td>&nbsp;)&nbsp;</td>
733           <td></td>
734         </tr>
735       </table>
736 </div>
737 <div class="memdoc">
738
739 <p>
740
741 <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>
742
743 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
744
745 <p>
746 <div class="dynheader">
747 Here is the call graph for this function:</div>
748 <div class="dynsection">
749 </div>
750
751 </div>
752 </div><p>
753 <a class="anchor" name="08c34b5b1b6e927a696ff0ce66562f54"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_compile_stmt_set_file_dtime" ref="08c34b5b1b6e927a696ff0ce66562f54" args="(sqlite3 *db) GNUC_NON_NULL(1)" -->
754 <div class="memitem">
755 <div class="memproto">
756       <table class="memname">
757         <tr>
758           <td class="memname">sqlite3_stmt* lms_db_compile_stmt_set_file_dtime           </td>
759           <td>(</td>
760           <td class="paramtype">sqlite3 *&nbsp;</td>
761           <td class="paramname"> <em>db</em>          </td>
762           <td>&nbsp;)&nbsp;</td>
763           <td></td>
764         </tr>
765       </table>
766 </div>
767 <div class="memdoc">
768
769 <p>
770
771 <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>
772
773 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
774
775 <p>
776 <div class="dynheader">
777 Here is the call graph for this function:</div>
778 <div class="dynsection">
779 </div>
780
781 </div>
782 </div><p>
783 <a class="anchor" name="69eb9d9058d9432f7658f9adffb79ed6"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_compile_stmt_update_file_info" ref="69eb9d9058d9432f7658f9adffb79ed6" args="(sqlite3 *db) GNUC_NON_NULL(1)" -->
784 <div class="memitem">
785 <div class="memproto">
786       <table class="memname">
787         <tr>
788           <td class="memname">sqlite3_stmt* lms_db_compile_stmt_update_file_info           </td>
789           <td>(</td>
790           <td class="paramtype">sqlite3 *&nbsp;</td>
791           <td class="paramname"> <em>db</em>          </td>
792           <td>&nbsp;)&nbsp;</td>
793           <td></td>
794         </tr>
795       </table>
796 </div>
797 <div class="memdoc">
798
799 <p>
800
801 <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>
802
803 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
804
805 <p>
806 <div class="dynheader">
807 Here is the call graph for this function:</div>
808 <div class="dynsection">
809 </div>
810
811 </div>
812 </div><p>
813 <a class="anchor" name="13ca09c885535a2968e707120e935268"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_create_core_tables_if_required" ref="13ca09c885535a2968e707120e935268" args="(sqlite3 *db) GNUC_NON_NULL(1)" -->
814 <div class="memitem">
815 <div class="memproto">
816       <table class="memname">
817         <tr>
818           <td class="memname">int int int int lms_db_create_core_tables_if_required           </td>
819           <td>(</td>
820           <td class="paramtype">sqlite3 *&nbsp;</td>
821           <td class="paramname"> <em>db</em>          </td>
822           <td>&nbsp;)&nbsp;</td>
823           <td></td>
824         </tr>
825       </table>
826 </div>
827 <div class="memdoc">
828
829 <p>
830
831 <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>
832
833 </div>
834 </div><p>
835 <a class="anchor" name="f47d604dd4e11f81be1ad045ee723789"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_create_trigger_if_not_exists" ref="f47d604dd4e11f81be1ad045ee723789" args="(sqlite3 *db, const char *sql) GNUC_NON_NULL(1" -->
836 <div class="memitem">
837 <div class="memproto">
838       <table class="memname">
839         <tr>
840           <td class="memname">int lms_db_create_trigger_if_not_exists           </td>
841           <td>(</td>
842           <td class="paramtype">sqlite3 *&nbsp;</td>
843           <td class="paramname"> <em>db</em>, </td>
844         </tr>
845         <tr>
846           <td class="paramkey"></td>
847           <td></td>
848           <td class="paramtype">const char *&nbsp;</td>
849           <td class="paramname"> <em>sql</em></td><td>&nbsp;</td>
850         </tr>
851         <tr>
852           <td></td>
853           <td>)</td>
854           <td></td><td></td><td></td>
855         </tr>
856       </table>
857 </div>
858 <div class="memdoc">
859
860 <p>
861
862 </div>
863 </div><p>
864 <a class="anchor" name="ec17baec1e001f67334b0265d465fb50"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_delete_file_info" ref="ec17baec1e001f67334b0265d465fb50" args="(sqlite3_stmt *stmt, const struct lms_file_info *finfo) GNUC_NON_NULL(1" -->
865 <div class="memitem">
866 <div class="memproto">
867       <table class="memname">
868         <tr>
869           <td class="memname">int int int int lms_db_delete_file_info           </td>
870           <td>(</td>
871           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
872           <td class="paramname"> <em>stmt</em>, </td>
873         </tr>
874         <tr>
875           <td class="paramkey"></td>
876           <td></td>
877           <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *&nbsp;</td>
878           <td class="paramname"> <em>finfo</em></td><td>&nbsp;</td>
879         </tr>
880         <tr>
881           <td></td>
882           <td>)</td>
883           <td></td><td></td><td></td>
884         </tr>
885       </table>
886 </div>
887 <div class="memdoc">
888
889 <p>
890
891 </div>
892 </div><p>
893 <a class="anchor" name="8ee7bfba83958b80f717a6ccbad2a84c"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_end_transaction" ref="8ee7bfba83958b80f717a6ccbad2a84c" args="(sqlite3_stmt *stmt) GNUC_NON_NULL(1)" -->
894 <div class="memitem">
895 <div class="memproto">
896       <table class="memname">
897         <tr>
898           <td class="memname">int lms_db_end_transaction           </td>
899           <td>(</td>
900           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
901           <td class="paramname"> <em>stmt</em>          </td>
902           <td>&nbsp;)&nbsp;</td>
903           <td></td>
904         </tr>
905       </table>
906 </div>
907 <div class="memdoc">
908
909 <p>
910
911 <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>
912
913 <p>Referenced by <a class="el" href="lightmediascanner__process_8c-source.html#l01047">lms_process_single_process()</a>.</p>
914
915 </div>
916 </div><p>
917 <a class="anchor" name="2660f629fbdf3d4144a6143fee837a27"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_finalize_stmt" ref="2660f629fbdf3d4144a6143fee837a27" args="(sqlite3_stmt *stmt, const char *name) GNUC_NON_NULL(1" -->
918 <div class="memitem">
919 <div class="memproto">
920       <table class="memname">
921         <tr>
922           <td class="memname">sqlite3_stmt* int lms_db_finalize_stmt           </td>
923           <td>(</td>
924           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
925           <td class="paramname"> <em>stmt</em>, </td>
926         </tr>
927         <tr>
928           <td class="paramkey"></td>
929           <td></td>
930           <td class="paramtype">const char *&nbsp;</td>
931           <td class="paramname"> <em>name</em></td><td>&nbsp;</td>
932         </tr>
933         <tr>
934           <td></td>
935           <td>)</td>
936           <td></td><td></td><td></td>
937         </tr>
938       </table>
939 </div>
940 <div class="memdoc">
941
942 <p>
943
944 </div>
945 </div><p>
946 <a class="anchor" name="e1df123e8d894a49f740ec6429af8159"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_get_file_info" ref="e1df123e8d894a49f740ec6429af8159" args="(sqlite3_stmt *stmt, struct lms_file_info *finfo) GNUC_NON_NULL(1" -->
947 <div class="memitem">
948 <div class="memproto">
949       <table class="memname">
950         <tr>
951           <td class="memname">int int lms_db_get_file_info           </td>
952           <td>(</td>
953           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
954           <td class="paramname"> <em>stmt</em>, </td>
955         </tr>
956         <tr>
957           <td class="paramkey"></td>
958           <td></td>
959           <td class="paramtype">struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *&nbsp;</td>
960           <td class="paramname"> <em>finfo</em></td><td>&nbsp;</td>
961         </tr>
962         <tr>
963           <td></td>
964           <td>)</td>
965           <td></td><td></td><td></td>
966         </tr>
967       </table>
968 </div>
969 <div class="memdoc">
970
971 <p>
972
973 </div>
974 </div><p>
975 <a class="anchor" name="617b14b976ba1cde9fe639800f2eae71"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_get_files" ref="617b14b976ba1cde9fe639800f2eae71" args="(sqlite3_stmt *stmt, const char *path, int len) GNUC_NON_NULL(1" -->
976 <div class="memitem">
977 <div class="memproto">
978       <table class="memname">
979         <tr>
980           <td class="memname">int int int int int int lms_db_get_files           </td>
981           <td>(</td>
982           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
983           <td class="paramname"> <em>stmt</em>, </td>
984         </tr>
985         <tr>
986           <td class="paramkey"></td>
987           <td></td>
988           <td class="paramtype">const char *&nbsp;</td>
989           <td class="paramname"> <em>path</em>, </td>
990         </tr>
991         <tr>
992           <td class="paramkey"></td>
993           <td></td>
994           <td class="paramtype">int&nbsp;</td>
995           <td class="paramname"> <em>len</em></td><td>&nbsp;</td>
996         </tr>
997         <tr>
998           <td></td>
999           <td>)</td>
1000           <td></td><td></td><td></td>
1001         </tr>
1002       </table>
1003 </div>
1004 <div class="memdoc">
1005
1006 <p>
1007
1008 </div>
1009 </div><p>
1010 <a class="anchor" name="9353bf3cfbe2c0045023658597b0cf1d"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_insert_file_info" ref="9353bf3cfbe2c0045023658597b0cf1d" args="(sqlite3_stmt *stmt, struct lms_file_info *finfo) GNUC_NON_NULL(1" -->
1011 <div class="memitem">
1012 <div class="memproto">
1013       <table class="memname">
1014         <tr>
1015           <td class="memname">int int int lms_db_insert_file_info           </td>
1016           <td>(</td>
1017           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
1018           <td class="paramname"> <em>stmt</em>, </td>
1019         </tr>
1020         <tr>
1021           <td class="paramkey"></td>
1022           <td></td>
1023           <td class="paramtype">struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *&nbsp;</td>
1024           <td class="paramname"> <em>finfo</em></td><td>&nbsp;</td>
1025         </tr>
1026         <tr>
1027           <td></td>
1028           <td>)</td>
1029           <td></td><td></td><td></td>
1030         </tr>
1031       </table>
1032 </div>
1033 <div class="memdoc">
1034
1035 <p>
1036
1037 </div>
1038 </div><p>
1039 <a class="anchor" name="ee78f418f0f3c9ead3023b1453c63556"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_reset_stmt" ref="ee78f418f0f3c9ead3023b1453c63556" args="(sqlite3_stmt *stmt) GNUC_NON_NULL(1)" -->
1040 <div class="memitem">
1041 <div class="memproto">
1042       <table class="memname">
1043         <tr>
1044           <td class="memname">sqlite3_stmt* int int lms_db_reset_stmt           </td>
1045           <td>(</td>
1046           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
1047           <td class="paramname"> <em>stmt</em>          </td>
1048           <td>&nbsp;)&nbsp;</td>
1049           <td></td>
1050         </tr>
1051       </table>
1052 </div>
1053 <div class="memdoc">
1054
1055 <p>
1056
1057 <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>
1058
1059 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00036">sqlite3_clear_bindings()</a>.</p>
1060
1061 <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>
1062
1063 <p>
1064 <div class="dynheader">
1065 Here is the call graph for this function:</div>
1066 <div class="dynsection">
1067 </div>
1068
1069 </div>
1070 </div><p>
1071 <a class="anchor" name="0fa3bfe1fa3a01a4dd231b6f818122cb"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_set_file_dtime" ref="0fa3bfe1fa3a01a4dd231b6f818122cb" args="(sqlite3_stmt *stmt, const struct lms_file_info *finfo) GNUC_NON_NULL(1" -->
1072 <div class="memitem">
1073 <div class="memproto">
1074       <table class="memname">
1075         <tr>
1076           <td class="memname">int int int int int lms_db_set_file_dtime           </td>
1077           <td>(</td>
1078           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
1079           <td class="paramname"> <em>stmt</em>, </td>
1080         </tr>
1081         <tr>
1082           <td class="paramkey"></td>
1083           <td></td>
1084           <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *&nbsp;</td>
1085           <td class="paramname"> <em>finfo</em></td><td>&nbsp;</td>
1086         </tr>
1087         <tr>
1088           <td></td>
1089           <td>)</td>
1090           <td></td><td></td><td></td>
1091         </tr>
1092       </table>
1093 </div>
1094 <div class="memdoc">
1095
1096 <p>
1097
1098 </div>
1099 </div><p>
1100 <a class="anchor" name="3dcf825514196befd0a4575e4afd0b58"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_table_update" ref="3dcf825514196befd0a4575e4afd0b58" args="(sqlite3 *db, const char *table, unsigned int current_version, unsigned int last_version, const lms_db_table_updater_t *updaters) GNUC_NON_NULL(1" -->
1101 <div class="memitem">
1102 <div class="memproto">
1103       <table class="memname">
1104         <tr>
1105           <td class="memname">int lms_db_table_update           </td>
1106           <td>(</td>
1107           <td class="paramtype">sqlite3 *&nbsp;</td>
1108           <td class="paramname"> <em>db</em>, </td>
1109         </tr>
1110         <tr>
1111           <td class="paramkey"></td>
1112           <td></td>
1113           <td class="paramtype">const char *&nbsp;</td>
1114           <td class="paramname"> <em>table</em>, </td>
1115         </tr>
1116         <tr>
1117           <td class="paramkey"></td>
1118           <td></td>
1119           <td class="paramtype">unsigned int&nbsp;</td>
1120           <td class="paramname"> <em>current_version</em>, </td>
1121         </tr>
1122         <tr>
1123           <td class="paramkey"></td>
1124           <td></td>
1125           <td class="paramtype">unsigned int&nbsp;</td>
1126           <td class="paramname"> <em>last_version</em>, </td>
1127         </tr>
1128         <tr>
1129           <td class="paramkey"></td>
1130           <td></td>
1131           <td class="paramtype">const <a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> *&nbsp;</td>
1132           <td class="paramname"> <em>updaters</em></td><td>&nbsp;</td>
1133         </tr>
1134         <tr>
1135           <td></td>
1136           <td>)</td>
1137           <td></td><td></td><td></td>
1138         </tr>
1139       </table>
1140 </div>
1141 <div class="memdoc">
1142
1143 <p>
1144
1145 </div>
1146 </div><p>
1147 <a class="anchor" name="455c0e5d62094b01fc935c5db8f07352"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_table_update_if_required" ref="455c0e5d62094b01fc935c5db8f07352" args="(sqlite3 *db, const char *table, unsigned int last_version, lms_db_table_updater_t *updaters) GNUC_NON_NULL(1" -->
1148 <div class="memitem">
1149 <div class="memproto">
1150       <table class="memname">
1151         <tr>
1152           <td class="memname">int int lms_db_table_update_if_required           </td>
1153           <td>(</td>
1154           <td class="paramtype">sqlite3 *&nbsp;</td>
1155           <td class="paramname"> <em>db</em>, </td>
1156         </tr>
1157         <tr>
1158           <td class="paramkey"></td>
1159           <td></td>
1160           <td class="paramtype">const char *&nbsp;</td>
1161           <td class="paramname"> <em>table</em>, </td>
1162         </tr>
1163         <tr>
1164           <td class="paramkey"></td>
1165           <td></td>
1166           <td class="paramtype">unsigned int&nbsp;</td>
1167           <td class="paramname"> <em>last_version</em>, </td>
1168         </tr>
1169         <tr>
1170           <td class="paramkey"></td>
1171           <td></td>
1172           <td class="paramtype"><a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> *&nbsp;</td>
1173           <td class="paramname"> <em>updaters</em></td><td>&nbsp;</td>
1174         </tr>
1175         <tr>
1176           <td></td>
1177           <td>)</td>
1178           <td></td><td></td><td></td>
1179         </tr>
1180       </table>
1181 </div>
1182 <div class="memdoc">
1183
1184 <p>
1185
1186 </div>
1187 </div><p>
1188 <a class="anchor" name="23cf7fff49641b39c017bdd076b112a7"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_table_version_get" ref="23cf7fff49641b39c017bdd076b112a7" args="(sqlite3 *db, const char *table) GNUC_NON_NULL(1" -->
1189 <div class="memitem">
1190 <div class="memproto">
1191       <table class="memname">
1192         <tr>
1193           <td class="memname">int int lms_db_table_version_get           </td>
1194           <td>(</td>
1195           <td class="paramtype">sqlite3 *&nbsp;</td>
1196           <td class="paramname"> <em>db</em>, </td>
1197         </tr>
1198         <tr>
1199           <td class="paramkey"></td>
1200           <td></td>
1201           <td class="paramtype">const char *&nbsp;</td>
1202           <td class="paramname"> <em>table</em></td><td>&nbsp;</td>
1203         </tr>
1204         <tr>
1205           <td></td>
1206           <td>)</td>
1207           <td></td><td></td><td></td>
1208         </tr>
1209       </table>
1210 </div>
1211 <div class="memdoc">
1212
1213 <p>
1214
1215 </div>
1216 </div><p>
1217 <a class="anchor" name="1c57f68c64069575a36252816929e335"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_table_version_set" ref="1c57f68c64069575a36252816929e335" args="(sqlite3 *db, const char *table, unsigned int version) GNUC_NON_NULL(1" -->
1218 <div class="memitem">
1219 <div class="memproto">
1220       <table class="memname">
1221         <tr>
1222           <td class="memname">int int int lms_db_table_version_set           </td>
1223           <td>(</td>
1224           <td class="paramtype">sqlite3 *&nbsp;</td>
1225           <td class="paramname"> <em>db</em>, </td>
1226         </tr>
1227         <tr>
1228           <td class="paramkey"></td>
1229           <td></td>
1230           <td class="paramtype">const char *&nbsp;</td>
1231           <td class="paramname"> <em>table</em>, </td>
1232         </tr>
1233         <tr>
1234           <td class="paramkey"></td>
1235           <td></td>
1236           <td class="paramtype">unsigned int&nbsp;</td>
1237           <td class="paramname"> <em>version</em></td><td>&nbsp;</td>
1238         </tr>
1239         <tr>
1240           <td></td>
1241           <td>)</td>
1242           <td></td><td></td><td></td>
1243         </tr>
1244       </table>
1245 </div>
1246 <div class="memdoc">
1247
1248 <p>
1249
1250 </div>
1251 </div><p>
1252 <a class="anchor" name="9cce62321be32274de720ec946473eeb"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_update_file_info" ref="9cce62321be32274de720ec946473eeb" args="(sqlite3_stmt *stmt, const struct lms_file_info *finfo) GNUC_NON_NULL(1" -->
1253 <div class="memitem">
1254 <div class="memproto">
1255       <table class="memname">
1256         <tr>
1257           <td class="memname">int lms_db_update_file_info           </td>
1258           <td>(</td>
1259           <td class="paramtype">sqlite3_stmt *&nbsp;</td>
1260           <td class="paramname"> <em>stmt</em>, </td>
1261         </tr>
1262         <tr>
1263           <td class="paramkey"></td>
1264           <td></td>
1265           <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> *&nbsp;</td>
1266           <td class="paramname"> <em>finfo</em></td><td>&nbsp;</td>
1267         </tr>
1268         <tr>
1269           <td></td>
1270           <td>)</td>
1271           <td></td><td></td><td></td>
1272         </tr>
1273       </table>
1274 </div>
1275 <div class="memdoc">
1276
1277 <p>
1278
1279 </div>
1280 </div><p>
1281 <hr><h2>Variable Documentation</h2>
1282 <a class="anchor" name="31db275bbea4b156c8b4493dac818b73"></a><!-- doxytag: member="lightmediascanner_db_private.h::lms_db_table_updater_t" ref="31db275bbea4b156c8b4493dac818b73" args=")(sqlite3 *db, const char *table, unsigned int current_version, int is_last_run)" -->
1283 <div class="memitem">
1284 <div class="memproto">
1285       <table class="memname">
1286         <tr>
1287           <td class="memname">int int int typedef int(* <a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a>)(sqlite3 *db, const char *table, unsigned int current_version, int is_last_run)          </td>
1288         </tr>
1289       </table>
1290 </div>
1291 <div class="memdoc">
1292
1293 <p>
1294
1295 </div>
1296 </div><p>
1297 </div>
1298 <hr size="1"><address style="text-align: right;"><small>Generated on Wed Apr 22 23:56:01 2009 for Light Media Scanner by&nbsp;
1299 <a href="http://www.doxygen.org/index.html">
1300 <img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.8 </small></address>
1301 </body>
1302 </html>