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="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_private.h File Reference</h1><code>#include <sqlite3.h></code><br>
20 <code>#include <sys/types.h></code><br>
21 <code>#include "<a class="el" href="lightmediascanner__plugin_8h-source.html">lightmediascanner_plugin.h</a>"</code><br>
24 <div class="dynheader">
25 Include dependency graph for lightmediascanner_db_private.h:</div>
26 <div class="dynsection">
27 <p><center><img src="lightmediascanner__db__private_8h__incl.png" border="0" usemap="#src/lib/lightmediascanner_db_private.h_map" alt=""></center>
28 <map name="src/lib/lightmediascanner_db_private.h_map">
29 <area shape="rect" href="lightmediascanner__plugin_8h.html" title="lightmediascanner_plugin.h" alt="" coords="180,84,380,111"><area shape="rect" href="lightmediascanner_8h.html" title="lightmediascanner.h" alt="" coords="232,162,387,188"><area shape="rect" href="lightmediascanner__charset__conv_8h.html" title="lightmediascanner_charset_conv.h" alt="" coords="411,162,664,188"></map>
33 <div class="dynheader">
34 This graph shows which files directly or indirectly include this file:</div>
35 <div class="dynsection">
36 <p><center><img src="lightmediascanner__db__private_8h__dep__incl.png" border="0" usemap="#src/lib/lightmediascanner_db_private.hdep_map" alt=""></center>
37 <map name="src/lib/lightmediascanner_db_private.hdep_map">
38 <area shape="rect" href="lightmediascanner__check_8c.html" title="src/lib/lightmediascanner_check.c" alt="" coords="5,84,251,110"><area shape="rect" href="lightmediascanner__db__audio_8c.html" title="src/lib/lightmediascanner_db_audio.c" alt="" coords="275,84,539,110"><area shape="rect" href="lightmediascanner__db__common_8c.html" title="src/lib/lightmediascanner_db_common.c" alt="" coords="563,84,848,110"><area shape="rect" href="lightmediascanner__db__image_8c.html" title="src/lib/lightmediascanner_db_image.c" alt="" coords="872,84,1141,110"><area shape="rect" href="lightmediascanner__db__playlist_8c.html" title="src/lib/lightmediascanner_db_playlist.c" alt="" coords="1165,84,1440,110"><area shape="rect" href="lightmediascanner__db__video_8c.html" title="src/lib/lightmediascanner_db_video.c" alt="" coords="1464,84,1728,110"><area shape="rect" href="lightmediascanner__process_8c.html" title="src/lib/lightmediascanner_process.c" alt="" coords="1752,84,2008,110"></map>
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">
44 <tr><td colspan="2"><br><h2>Data Structures</h2></td></tr>
45 <tr><td class="memItemLeft" nowrap align="right" valign="top">struct </td><td class="memItemRight" valign="bottom"><a class="el" href="structlms__db__cache__entry.html">lms_db_cache_entry</a></td></tr>
47 <tr><td class="memItemLeft" nowrap align="right" valign="top">struct </td><td class="memItemRight" valign="bottom"><a class="el" href="structlms__db__cache.html">lms_db_cache</a></td></tr>
49 <tr><td colspan="2"><br><h2>Defines</h2></td></tr>
50 <tr><td class="memItemLeft" nowrap align="right" valign="top">#define </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#97d5ed207ef5b72f4fba0cab38594bb7">_LIGHTMEDIASCANNER_DB_PRIVATE_H_</a> 1</td></tr>
52 <tr><td class="memItemLeft" nowrap align="right" valign="top">#define </td><td class="memItemRight" valign="bottom"><a class="el" href="lightmediascanner__db__private_8h.html#6fe68cac0abf3e2ca61141920414e93a">GNUC_NON_NULL</a>(...)</td></tr>
54 <tr><td colspan="2"><br><h2>Functions</h2></td></tr>
55 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </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>
57 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *int </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>
59 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt *int int </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>
61 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
63 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
65 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
67 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
69 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
71 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
73 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
75 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int </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>
77 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int </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>
79 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
81 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int </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>
83 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
85 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int </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>
87 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int </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>
89 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int int </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>
91 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </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>
93 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </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>
95 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </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>
97 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </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>
99 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </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>
101 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </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>
103 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </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>
105 <tr><td class="memItemLeft" nowrap align="right" valign="top">sqlite3_stmt * </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>
107 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
109 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
111 <tr><td class="memItemLeft" nowrap align="right" valign="top">int </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>
113 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int </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>
115 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int </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>
117 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int int </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>
119 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int int int </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>
121 <tr><td class="memItemLeft" nowrap align="right" valign="top">int int int int int int </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>
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(* </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>
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">
133 <td class="memname">#define _LIGHTMEDIASCANNER_DB_PRIVATE_H_ 1 </td>
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 <<a href="mailto:gustavo.barbieri@openbossa.org">gustavo.barbieri@openbossa.org</a>> </dd></dl>
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>
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">
155 <td class="memname">#define GNUC_NON_NULL </td>
157 <td class="paramtype"> <em>...</em> </td>
158 <td class="paramname"> </td>
159 <td> ) </td>
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>
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">
178 <td class="memname">int lms_db_begin_transaction </td>
180 <td class="paramtype">sqlite3_stmt * </td>
181 <td class="paramname"> <em>stmt</em> </td>
182 <td> ) </td>
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>
193 <p>Referenced by <a class="el" href="lightmediascanner__process_8c-source.html#l01044">lms_process_single_process()</a>.</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">
202 <td class="memname">int lms_db_bind_blob </td>
204 <td class="paramtype">sqlite3_stmt * </td>
205 <td class="paramname"> <em>stmt</em>, </td>
208 <td class="paramkey"></td>
210 <td class="paramtype">int </td>
211 <td class="paramname"> <em>col</em>, </td>
214 <td class="paramkey"></td>
216 <td class="paramtype">const void * </td>
217 <td class="paramname"> <em>blob</em>, </td>
220 <td class="paramkey"></td>
222 <td class="paramtype">int </td>
223 <td class="paramname"> <em>len</em></td><td> </td>
228 <td></td><td></td><td></td>
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>
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>
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">
247 <td class="memname">int lms_db_bind_double </td>
249 <td class="paramtype">sqlite3_stmt * </td>
250 <td class="paramname"> <em>stmt</em>, </td>
253 <td class="paramkey"></td>
255 <td class="paramtype">int </td>
256 <td class="paramname"> <em>col</em>, </td>
259 <td class="paramkey"></td>
261 <td class="paramtype">double </td>
262 <td class="paramname"> <em>value</em></td><td> </td>
267 <td></td><td></td><td></td>
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>
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">
284 <td class="memname">int lms_db_bind_int </td>
286 <td class="paramtype">sqlite3_stmt * </td>
287 <td class="paramname"> <em>stmt</em>, </td>
290 <td class="paramkey"></td>
292 <td class="paramtype">int </td>
293 <td class="paramname"> <em>col</em>, </td>
296 <td class="paramkey"></td>
298 <td class="paramtype">int </td>
299 <td class="paramname"> <em>value</em></td><td> </td>
304 <td></td><td></td><td></td>
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>
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>
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">
323 <td class="memname">int lms_db_bind_int64 </td>
325 <td class="paramtype">sqlite3_stmt * </td>
326 <td class="paramname"> <em>stmt</em>, </td>
329 <td class="paramkey"></td>
331 <td class="paramtype">int </td>
332 <td class="paramname"> <em>col</em>, </td>
335 <td class="paramkey"></td>
337 <td class="paramtype">int64_t </td>
338 <td class="paramname"> <em>value</em></td><td> </td>
343 <td></td><td></td><td></td>
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>
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>
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">
362 <td class="memname">int lms_db_bind_int64_or_null </td>
364 <td class="paramtype">sqlite3_stmt * </td>
365 <td class="paramname"> <em>stmt</em>, </td>
368 <td class="paramkey"></td>
370 <td class="paramtype">int </td>
371 <td class="paramname"> <em>col</em>, </td>
374 <td class="paramkey"></td>
376 <td class="paramtype">int64_t * </td>
377 <td class="paramname"> <em>p_value</em></td><td> </td>
382 <td></td><td></td><td></td>
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>
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">
399 <td class="memname">int lms_db_bind_text </td>
401 <td class="paramtype">sqlite3_stmt * </td>
402 <td class="paramname"> <em>stmt</em>, </td>
405 <td class="paramkey"></td>
407 <td class="paramtype">int </td>
408 <td class="paramname"> <em>col</em>, </td>
411 <td class="paramkey"></td>
413 <td class="paramtype">const char * </td>
414 <td class="paramname"> <em>text</em>, </td>
417 <td class="paramkey"></td>
419 <td class="paramtype">int </td>
420 <td class="paramname"> <em>len</em></td><td> </td>
425 <td></td><td></td><td></td>
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>
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>
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">
444 <td class="memname">int lms_db_cache_add </td>
446 <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> * </td>
447 <td class="paramname"> <em>cache</em>, </td>
450 <td class="paramkey"></td>
452 <td class="paramtype">const sqlite3 * </td>
453 <td class="paramname"> <em>db</em>, </td>
456 <td class="paramkey"></td>
458 <td class="paramtype">void * </td>
459 <td class="paramname"> <em>data</em></td><td> </td>
464 <td></td><td></td><td></td>
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">
479 <td class="memname">int int lms_db_cache_del </td>
481 <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> * </td>
482 <td class="paramname"> <em>cache</em>, </td>
485 <td class="paramkey"></td>
487 <td class="paramtype">const sqlite3 * </td>
488 <td class="paramname"> <em>db</em>, </td>
491 <td class="paramkey"></td>
493 <td class="paramtype">void * </td>
494 <td class="paramname"> <em>data</em></td><td> </td>
499 <td></td><td></td><td></td>
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">
514 <td class="memname">int int int lms_db_cache_get </td>
516 <td class="paramtype">struct <a class="el" href="structlms__db__cache.html">lms_db_cache</a> * </td>
517 <td class="paramname"> <em>cache</em>, </td>
520 <td class="paramkey"></td>
522 <td class="paramtype">const sqlite3 * </td>
523 <td class="paramname"> <em>db</em>, </td>
526 <td class="paramkey"></td>
528 <td class="paramtype">void ** </td>
529 <td class="paramname"> <em>pdata</em></td><td> </td>
534 <td></td><td></td><td></td>
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">
549 <td class="memname">sqlite3_stmt* lms_db_compile_stmt </td>
551 <td class="paramtype">sqlite3 * </td>
552 <td class="paramname"> <em>db</em>, </td>
555 <td class="paramkey"></td>
557 <td class="paramtype">const char * </td>
558 <td class="paramname"> <em>sql</em></td><td> </td>
563 <td></td><td></td><td></td>
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">
578 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_begin_transaction </td>
580 <td class="paramtype">sqlite3 * </td>
581 <td class="paramname"> <em>db</em> </td>
582 <td> ) </td>
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>
593 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
596 <div class="dynheader">
597 Here is the call graph for this function:</div>
598 <div class="dynsection">
599 <p><center><img src="lightmediascanner__db__private_8h_073c254ca7b4d3f42e1be1854bcc42a3_cgraph.png" border="0" usemap="#lightmediascanner__db__private_8h_073c254ca7b4d3f42e1be1854bcc42a3_cgraph_map" alt=""></center>
600 <map name="lightmediascanner__db__private_8h_073c254ca7b4d3f42e1be1854bcc42a3_cgraph_map">
601 <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>
606 <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)" -->
607 <div class="memitem">
608 <div class="memproto">
609 <table class="memname">
611 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_delete_file_info </td>
613 <td class="paramtype">sqlite3 * </td>
614 <td class="paramname"> <em>db</em> </td>
615 <td> ) </td>
624 <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>
626 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
629 <div class="dynheader">
630 Here is the call graph for this function:</div>
631 <div class="dynsection">
632 <p><center><img src="lightmediascanner__db__private_8h_76941bdbbdb711fff821343e91c2cd97_cgraph.png" border="0" usemap="#lightmediascanner__db__private_8h_76941bdbbdb711fff821343e91c2cd97_cgraph_map" alt=""></center>
633 <map name="lightmediascanner__db__private_8h_76941bdbbdb711fff821343e91c2cd97_cgraph_map">
634 <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>
639 <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)" -->
640 <div class="memitem">
641 <div class="memproto">
642 <table class="memname">
644 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_end_transaction </td>
646 <td class="paramtype">sqlite3 * </td>
647 <td class="paramname"> <em>db</em> </td>
648 <td> ) </td>
657 <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>
659 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
662 <div class="dynheader">
663 Here is the call graph for this function:</div>
664 <div class="dynsection">
665 <p><center><img src="lightmediascanner__db__private_8h_09feca4fbfde33d5647cdd5cc2de6500_cgraph.png" border="0" usemap="#lightmediascanner__db__private_8h_09feca4fbfde33d5647cdd5cc2de6500_cgraph_map" alt=""></center>
666 <map name="lightmediascanner__db__private_8h_09feca4fbfde33d5647cdd5cc2de6500_cgraph_map">
667 <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>
672 <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)" -->
673 <div class="memitem">
674 <div class="memproto">
675 <table class="memname">
677 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_get_file_info </td>
679 <td class="paramtype">sqlite3 * </td>
680 <td class="paramname"> <em>db</em> </td>
681 <td> ) </td>
690 <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>
692 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
695 <div class="dynheader">
696 Here is the call graph for this function:</div>
697 <div class="dynsection">
698 <p><center><img src="lightmediascanner__db__private_8h_327d54a6dac083e356fd609298a0cbd5_cgraph.png" border="0" usemap="#lightmediascanner__db__private_8h_327d54a6dac083e356fd609298a0cbd5_cgraph_map" alt=""></center>
699 <map name="lightmediascanner__db__private_8h_327d54a6dac083e356fd609298a0cbd5_cgraph_map">
700 <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>
705 <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)" -->
706 <div class="memitem">
707 <div class="memproto">
708 <table class="memname">
710 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_get_files </td>
712 <td class="paramtype">sqlite3 * </td>
713 <td class="paramname"> <em>db</em> </td>
714 <td> ) </td>
723 <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>
725 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
728 <div class="dynheader">
729 Here is the call graph for this function:</div>
730 <div class="dynsection">
731 <p><center><img src="lightmediascanner__db__private_8h_1cc8a80961a0febdd099a028f3da9c30_cgraph.png" border="0" usemap="#lightmediascanner__db__private_8h_1cc8a80961a0febdd099a028f3da9c30_cgraph_map" alt=""></center>
732 <map name="lightmediascanner__db__private_8h_1cc8a80961a0febdd099a028f3da9c30_cgraph_map">
733 <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>
738 <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)" -->
739 <div class="memitem">
740 <div class="memproto">
741 <table class="memname">
743 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_insert_file_info </td>
745 <td class="paramtype">sqlite3 * </td>
746 <td class="paramname"> <em>db</em> </td>
747 <td> ) </td>
756 <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>
758 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
761 <div class="dynheader">
762 Here is the call graph for this function:</div>
763 <div class="dynsection">
764 <p><center><img src="lightmediascanner__db__private_8h_bf21f88ddbe28a8290d0df32af0f079c_cgraph.png" border="0" usemap="#lightmediascanner__db__private_8h_bf21f88ddbe28a8290d0df32af0f079c_cgraph_map" alt=""></center>
765 <map name="lightmediascanner__db__private_8h_bf21f88ddbe28a8290d0df32af0f079c_cgraph_map">
766 <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>
771 <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)" -->
772 <div class="memitem">
773 <div class="memproto">
774 <table class="memname">
776 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_set_file_dtime </td>
778 <td class="paramtype">sqlite3 * </td>
779 <td class="paramname"> <em>db</em> </td>
780 <td> ) </td>
789 <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>
791 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
794 <div class="dynheader">
795 Here is the call graph for this function:</div>
796 <div class="dynsection">
797 <p><center><img src="lightmediascanner__db__private_8h_08c34b5b1b6e927a696ff0ce66562f54_cgraph.png" border="0" usemap="#lightmediascanner__db__private_8h_08c34b5b1b6e927a696ff0ce66562f54_cgraph_map" alt=""></center>
798 <map name="lightmediascanner__db__private_8h_08c34b5b1b6e927a696ff0ce66562f54_cgraph_map">
799 <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>
804 <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)" -->
805 <div class="memitem">
806 <div class="memproto">
807 <table class="memname">
809 <td class="memname">sqlite3_stmt* lms_db_compile_stmt_update_file_info </td>
811 <td class="paramtype">sqlite3 * </td>
812 <td class="paramname"> <em>db</em> </td>
813 <td> ) </td>
822 <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>
824 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00101">lms_db_compile_stmt()</a>.</p>
827 <div class="dynheader">
828 Here is the call graph for this function:</div>
829 <div class="dynsection">
830 <p><center><img src="lightmediascanner__db__private_8h_69eb9d9058d9432f7658f9adffb79ed6_cgraph.png" border="0" usemap="#lightmediascanner__db__private_8h_69eb9d9058d9432f7658f9adffb79ed6_cgraph_map" alt=""></center>
831 <map name="lightmediascanner__db__private_8h_69eb9d9058d9432f7658f9adffb79ed6_cgraph_map">
832 <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>
837 <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)" -->
838 <div class="memitem">
839 <div class="memproto">
840 <table class="memname">
842 <td class="memname">int int int int lms_db_create_core_tables_if_required </td>
844 <td class="paramtype">sqlite3 * </td>
845 <td class="paramname"> <em>db</em> </td>
846 <td> ) </td>
855 <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>
859 <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" -->
860 <div class="memitem">
861 <div class="memproto">
862 <table class="memname">
864 <td class="memname">int lms_db_create_trigger_if_not_exists </td>
866 <td class="paramtype">sqlite3 * </td>
867 <td class="paramname"> <em>db</em>, </td>
870 <td class="paramkey"></td>
872 <td class="paramtype">const char * </td>
873 <td class="paramname"> <em>sql</em></td><td> </td>
878 <td></td><td></td><td></td>
888 <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" -->
889 <div class="memitem">
890 <div class="memproto">
891 <table class="memname">
893 <td class="memname">int int int int lms_db_delete_file_info </td>
895 <td class="paramtype">sqlite3_stmt * </td>
896 <td class="paramname"> <em>stmt</em>, </td>
899 <td class="paramkey"></td>
901 <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
902 <td class="paramname"> <em>finfo</em></td><td> </td>
907 <td></td><td></td><td></td>
917 <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)" -->
918 <div class="memitem">
919 <div class="memproto">
920 <table class="memname">
922 <td class="memname">int lms_db_end_transaction </td>
924 <td class="paramtype">sqlite3_stmt * </td>
925 <td class="paramname"> <em>stmt</em> </td>
926 <td> ) </td>
935 <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>
937 <p>Referenced by <a class="el" href="lightmediascanner__process_8c-source.html#l01044">lms_process_single_process()</a>.</p>
941 <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" -->
942 <div class="memitem">
943 <div class="memproto">
944 <table class="memname">
946 <td class="memname">sqlite3_stmt* int lms_db_finalize_stmt </td>
948 <td class="paramtype">sqlite3_stmt * </td>
949 <td class="paramname"> <em>stmt</em>, </td>
952 <td class="paramkey"></td>
954 <td class="paramtype">const char * </td>
955 <td class="paramname"> <em>name</em></td><td> </td>
960 <td></td><td></td><td></td>
970 <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" -->
971 <div class="memitem">
972 <div class="memproto">
973 <table class="memname">
975 <td class="memname">int int lms_db_get_file_info </td>
977 <td class="paramtype">sqlite3_stmt * </td>
978 <td class="paramname"> <em>stmt</em>, </td>
981 <td class="paramkey"></td>
983 <td class="paramtype">struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
984 <td class="paramname"> <em>finfo</em></td><td> </td>
989 <td></td><td></td><td></td>
999 <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" -->
1000 <div class="memitem">
1001 <div class="memproto">
1002 <table class="memname">
1004 <td class="memname">int int int int int int lms_db_get_files </td>
1006 <td class="paramtype">sqlite3_stmt * </td>
1007 <td class="paramname"> <em>stmt</em>, </td>
1010 <td class="paramkey"></td>
1012 <td class="paramtype">const char * </td>
1013 <td class="paramname"> <em>path</em>, </td>
1016 <td class="paramkey"></td>
1018 <td class="paramtype">int </td>
1019 <td class="paramname"> <em>len</em></td><td> </td>
1024 <td></td><td></td><td></td>
1028 <div class="memdoc">
1034 <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" -->
1035 <div class="memitem">
1036 <div class="memproto">
1037 <table class="memname">
1039 <td class="memname">int int int lms_db_insert_file_info </td>
1041 <td class="paramtype">sqlite3_stmt * </td>
1042 <td class="paramname"> <em>stmt</em>, </td>
1045 <td class="paramkey"></td>
1047 <td class="paramtype">struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
1048 <td class="paramname"> <em>finfo</em></td><td> </td>
1053 <td></td><td></td><td></td>
1057 <div class="memdoc">
1063 <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)" -->
1064 <div class="memitem">
1065 <div class="memproto">
1066 <table class="memname">
1068 <td class="memname">sqlite3_stmt* int int lms_db_reset_stmt </td>
1070 <td class="paramtype">sqlite3_stmt * </td>
1071 <td class="paramname"> <em>stmt</em> </td>
1072 <td> ) </td>
1077 <div class="memdoc">
1081 <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>
1083 <p>References <a class="el" href="lightmediascanner__db__common_8c-source.html#l00036">sqlite3_clear_bindings()</a>.</p>
1085 <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>
1088 <div class="dynheader">
1089 Here is the call graph for this function:</div>
1090 <div class="dynsection">
1091 <p><center><img src="lightmediascanner__db__private_8h_ee78f418f0f3c9ead3023b1453c63556_cgraph.png" border="0" usemap="#lightmediascanner__db__private_8h_ee78f418f0f3c9ead3023b1453c63556_cgraph_map" alt=""></center>
1092 <map name="lightmediascanner__db__private_8h_ee78f418f0f3c9ead3023b1453c63556_cgraph_map">
1093 <area shape="rect" href="lightmediascanner__db__common_8c.html#3f8fb8f31c1876b3579956b3d898cd00" title="sqlite3_clear_bindings" alt="" coords="207,5,372,32"></map>
1098 <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" -->
1099 <div class="memitem">
1100 <div class="memproto">
1101 <table class="memname">
1103 <td class="memname">int int int int int lms_db_set_file_dtime </td>
1105 <td class="paramtype">sqlite3_stmt * </td>
1106 <td class="paramname"> <em>stmt</em>, </td>
1109 <td class="paramkey"></td>
1111 <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
1112 <td class="paramname"> <em>finfo</em></td><td> </td>
1117 <td></td><td></td><td></td>
1121 <div class="memdoc">
1127 <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" -->
1128 <div class="memitem">
1129 <div class="memproto">
1130 <table class="memname">
1132 <td class="memname">int lms_db_table_update </td>
1134 <td class="paramtype">sqlite3 * </td>
1135 <td class="paramname"> <em>db</em>, </td>
1138 <td class="paramkey"></td>
1140 <td class="paramtype">const char * </td>
1141 <td class="paramname"> <em>table</em>, </td>
1144 <td class="paramkey"></td>
1146 <td class="paramtype">unsigned int </td>
1147 <td class="paramname"> <em>current_version</em>, </td>
1150 <td class="paramkey"></td>
1152 <td class="paramtype">unsigned int </td>
1153 <td class="paramname"> <em>last_version</em>, </td>
1156 <td class="paramkey"></td>
1158 <td class="paramtype">const <a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> * </td>
1159 <td class="paramname"> <em>updaters</em></td><td> </td>
1164 <td></td><td></td><td></td>
1168 <div class="memdoc">
1174 <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" -->
1175 <div class="memitem">
1176 <div class="memproto">
1177 <table class="memname">
1179 <td class="memname">int int lms_db_table_update_if_required </td>
1181 <td class="paramtype">sqlite3 * </td>
1182 <td class="paramname"> <em>db</em>, </td>
1185 <td class="paramkey"></td>
1187 <td class="paramtype">const char * </td>
1188 <td class="paramname"> <em>table</em>, </td>
1191 <td class="paramkey"></td>
1193 <td class="paramtype">unsigned int </td>
1194 <td class="paramname"> <em>last_version</em>, </td>
1197 <td class="paramkey"></td>
1199 <td class="paramtype"><a class="el" href="lightmediascanner__db__private_8h.html#31db275bbea4b156c8b4493dac818b73">lms_db_table_updater_t</a> * </td>
1200 <td class="paramname"> <em>updaters</em></td><td> </td>
1205 <td></td><td></td><td></td>
1209 <div class="memdoc">
1215 <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" -->
1216 <div class="memitem">
1217 <div class="memproto">
1218 <table class="memname">
1220 <td class="memname">int int lms_db_table_version_get </td>
1222 <td class="paramtype">sqlite3 * </td>
1223 <td class="paramname"> <em>db</em>, </td>
1226 <td class="paramkey"></td>
1228 <td class="paramtype">const char * </td>
1229 <td class="paramname"> <em>table</em></td><td> </td>
1234 <td></td><td></td><td></td>
1238 <div class="memdoc">
1244 <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" -->
1245 <div class="memitem">
1246 <div class="memproto">
1247 <table class="memname">
1249 <td class="memname">int int int lms_db_table_version_set </td>
1251 <td class="paramtype">sqlite3 * </td>
1252 <td class="paramname"> <em>db</em>, </td>
1255 <td class="paramkey"></td>
1257 <td class="paramtype">const char * </td>
1258 <td class="paramname"> <em>table</em>, </td>
1261 <td class="paramkey"></td>
1263 <td class="paramtype">unsigned int </td>
1264 <td class="paramname"> <em>version</em></td><td> </td>
1269 <td></td><td></td><td></td>
1273 <div class="memdoc">
1279 <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" -->
1280 <div class="memitem">
1281 <div class="memproto">
1282 <table class="memname">
1284 <td class="memname">int lms_db_update_file_info </td>
1286 <td class="paramtype">sqlite3_stmt * </td>
1287 <td class="paramname"> <em>stmt</em>, </td>
1290 <td class="paramkey"></td>
1292 <td class="paramtype">const struct <a class="el" href="structlms__file__info.html">lms_file_info</a> * </td>
1293 <td class="paramname"> <em>finfo</em></td><td> </td>
1298 <td></td><td></td><td></td>
1302 <div class="memdoc">
1308 <hr><h2>Variable Documentation</h2>
1309 <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)" -->
1310 <div class="memitem">
1311 <div class="memproto">
1312 <table class="memname">
1314 <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>
1318 <div class="memdoc">
1325 <hr size="1"><address style="text-align: right;"><small>Generated on Sun Oct 5 12:24:56 2008 for Light Media Scanner by
1326 <a href="http://www.doxygen.org/index.html">
1327 <img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.6 </small></address>