Searched refs:sql (Results 1 - 25 of 27) sorted by relevance

12

/netgear-WNDR4500v2-V1.0.0.60_1.0.38/ap/gpl/minidlna/minidlna.07.26/
H A Dsql.c20 #include "sql.h"
28 char *sql; local
30 //DPRINTF(E_DEBUG, L_DB_SQL, "SQL: %s\n", sql);
34 sql = sqlite3_vmprintf(fmt, ap);
35 ret = sqlite3_exec(db, sql, 0, 0, &errMsg);
38 DPRINTF(E_ERROR, L_DB_SQL, "SQL ERROR %d [%s]\n%s\n", ret, errMsg, sql);
42 sqlite3_free(sql);
48 sql_get_table(sqlite3 *db, const char *sql, char ***pazResult, int *pnRow, int *pnColumn) argument
52 //DPRINTF(E_DEBUG, L_DB_SQL, "SQL: %s\n", sql);
54 ret = sqlite3_get_table(db, sql, pazResul
70 char *sql; local
[all...]
H A Dinotify.c42 #include "sql.h"
280 char * sql; local
341 sql = sqlite3_mprintf("SELECT TIMESTAMP from DETAILS where PATH = '%q'", path);
342 if( sql_get_table(db, sql, &result, &rows, NULL) == SQLITE_OK )
356 sqlite3_free(sql);
369 sqlite3_free(sql);
381 sql = sqlite3_mprintf("SELECT OBJECT_ID from OBJECTS o left join DETAILS d on (d.ID = o.DETAIL_ID)"
383 if( (sql_get_table(db, sql, &result, &rows, NULL) == SQLITE_OK) && rows )
387 sqlite3_free(sql);
402 sqlite3_free(sql);
437 char * sql; local
526 char * sql; local
605 char * sql; local
[all...]
H A Dscanner.c40 #include "sql.h"
56 char * sql; local
61 asprintf(&sql, "SELECT OBJECT_ID from %s where ID = "
63 ret = sql_get_table(db, sql, &result, &rows, NULL);
69 free(sql);
80 char *sql; local
85 sql = sqlite3_mprintf("SELECT OBJECT_ID from OBJECTS"
90 ret = sql_get_table(db, sql, &result, &rows, &cols);
91 sqlite3_free(sql);
102 sql
132 char *sql; local
392 char * sql; local
[all...]
H A Dtivo_commands.c30 #include "sql.h"
313 char *sql; local
322 asprintf(&sql, "SELECT o.OBJECT_ID, o.CLASS, o.DETAIL_ID, d.SIZE, d.TITLE,"
327 DPRINTF(E_DEBUG, L_TIVO, "%s\n", sql);
328 ret = sqlite3_exec(db, sql, callback, (void *) &args, &zErrMsg);
329 free(sql);
347 char *sql, *item, *saveptr; local
394 sql = sqlite3_mprintf("SELECT NAME from OBJECTS where OBJECT_ID = '%s'", objectID);
395 if( (sql_get_table(db, sql, &result, &ret, NULL) == SQLITE_OK) && ret )
399 sqlite3_free(sql);
[all...]
H A DMakefile54 sql.o utils.o metadata.o scanner.o inotify.o \
105 upnphttp.o: upnpevents.h image_utils.h sql.h log.h icons.c
108 upnpsoap.o: config.h upnpglobalvars.h minidlnatypes.h log.h utils.h sql.h
126 scanner.o: upnpglobalvars.h metadata.h utils.h sql.h scanner.h log.h playlist.h
127 metadata.o: upnpglobalvars.h metadata.h albumart.h utils.h sql.h log.h
128 albumart.o: upnpglobalvars.h albumart.h utils.h image_utils.h sql.h log.h
141 sql.o: sql.h
H A Dalbumart.c32 #include "sql.h"
343 char * sql; local
352 sql = sqlite3_mprintf("SELECT ID from ALBUM_ART where PATH = '%q'", album_art ? album_art : path);
353 if( (sql_get_table(db, sql, &result, &rows, &cols) == SQLITE_OK) && rows )
363 sqlite3_free(sql);
H A Dupnpsoap.c35 #include "sql.h"
872 char *sql, *ptr; local
953 sql = sqlite3_mprintf( SELECT_COLUMNS
957 ret = sqlite3_exec(db, sql, callback, (void *) &args, &zErrMsg);
989 sql = sqlite3_mprintf( SELECT_COLUMNS
993 DPRINTF(E_DEBUG, L_HTTP, "Browse SQL: %s\n", sql);
994 ret = sqlite3_exec(db, sql, callback, (void *) &args, &zErrMsg);
996 sqlite3_free(sql);
999 DPRINTF(E_WARN, L_HTTP, "SQL error: %s\nBAD SQL: %s\n", zErrMsg, sql);
1044 char *sql, *pt local
[all...]
H A Dmetadata.c43 #include "sql.h"
138 char * sql; local
149 sql = sqlite3_mprintf("SELECT ID from DETAILS where PATH glob '%q.*'"
151 ret = sql_get_table(db, sql, &result, &rows, NULL);
165 sqlite3_free(sql);
/netgear-WNDR4500v2-V1.0.0.60_1.0.38/ap/gpl/minidlna/minidlna/
H A Dsql.c20 #include "sql.h"
28 char *sql; local
30 //DPRINTF(E_DEBUG, L_DB_SQL, "SQL: %s\n", sql);
34 sql = sqlite3_vmprintf(fmt, ap);
35 ret = sqlite3_exec(db, sql, 0, 0, &errMsg);
38 DPRINTF(E_ERROR, L_DB_SQL, "SQL ERROR %d [%s]\n%s\n", ret, errMsg, sql);
42 sqlite3_free(sql);
48 sql_get_table(sqlite3 *db, const char *sql, char ***pazResult, int *pnRow, int *pnColumn) argument
52 //DPRINTF(E_DEBUG, L_DB_SQL, "SQL: %s\n", sql);
54 ret = sqlite3_get_table(db, sql, pazResul
70 char *sql; local
[all...]
H A Dinotify.c42 #include "sql.h"
280 char * sql; local
341 sql = sqlite3_mprintf("SELECT TIMESTAMP from DETAILS where PATH = '%q'", path);
342 if( sql_get_table(db, sql, &result, &rows, NULL) == SQLITE_OK )
356 sqlite3_free(sql);
369 sqlite3_free(sql);
381 sql = sqlite3_mprintf("SELECT OBJECT_ID from OBJECTS o left join DETAILS d on (d.ID = o.DETAIL_ID)"
383 if( (sql_get_table(db, sql, &result, &rows, NULL) == SQLITE_OK) && rows )
387 sqlite3_free(sql);
402 sqlite3_free(sql);
437 char * sql; local
527 char * sql; local
606 char * sql; local
[all...]
H A Dscanner.c35 #include "sql.h"
51 char * sql; local
56 asprintf(&sql, "SELECT OBJECT_ID from %s where ID = "
58 ret = sql_get_table(db, sql, &result, &rows, NULL);
64 free(sql);
75 char *sql; local
80 sql = sqlite3_mprintf("SELECT OBJECT_ID from OBJECTS"
85 ret = sql_get_table(db, sql, &result, &rows, &cols);
86 sqlite3_free(sql);
97 sql
127 char *sql; local
387 char * sql; local
[all...]
H A Dtivo_commands.c30 #include "sql.h"
293 char *sql; local
302 asprintf(&sql, "SELECT o.OBJECT_ID, o.CLASS, o.DETAIL_ID, d.SIZE, d.TITLE,"
307 DPRINTF(E_DEBUG, L_TIVO, "%s\n", sql);
308 ret = sqlite3_exec(db, sql, callback, (void *) &args, &zErrMsg);
309 free(sql);
327 char *sql, *item, *saveptr; local
374 sql = sqlite3_mprintf("SELECT NAME from OBJECTS where OBJECT_ID = '%s'", objectID);
375 if( (sql_get_table(db, sql, &result, &ret, NULL) == SQLITE_OK) && ret )
379 sqlite3_free(sql);
[all...]
H A DMakefile44 sql.o utils.o metadata.o scanner.o inotify.o \
97 upnphttp.o: upnpevents.h image_utils.h sql.h log.h icons.c
100 upnpsoap.o: config.h upnpglobalvars.h minidlnatypes.h log.h utils.h sql.h
118 scanner.o: upnpglobalvars.h metadata.h utils.h sql.h scanner.h log.h playlist.h
119 metadata.o: upnpglobalvars.h metadata.h albumart.h utils.h sql.h log.h
120 albumart.o: upnpglobalvars.h albumart.h utils.h image_utils.h sql.h log.h
133 sql.o: sql.h
H A Dalbumart.c32 #include "sql.h"
343 char * sql; local
352 sql = sqlite3_mprintf("SELECT ID from ALBUM_ART where PATH = '%q'", album_art ? album_art : path);
353 if( (sql_get_table(db, sql, &result, &rows, &cols) == SQLITE_OK) && rows )
363 sqlite3_free(sql);
H A Dupnpsoap.c35 #include "sql.h"
864 char *sql, *ptr; local
945 sql = sqlite3_mprintf( SELECT_COLUMNS
949 ret = sqlite3_exec(db, sql, callback, (void *) &args, &zErrMsg);
981 sql = sqlite3_mprintf( SELECT_COLUMNS
985 DPRINTF(E_DEBUG, L_HTTP, "Browse SQL: %s\n", sql);
986 ret = sqlite3_exec(db, sql, callback, (void *) &args, &zErrMsg);
988 sqlite3_free(sql);
991 DPRINTF(E_WARN, L_HTTP, "SQL error: %s\nBAD SQL: %s\n", zErrMsg, sql);
1036 char *sql, *pt local
[all...]
H A Dmetadata.c42 #include "sql.h"
128 char * sql; local
139 sql = sqlite3_mprintf("SELECT ID from DETAILS where PATH glob '%q.*'"
141 ret = sql_get_table(db, sql, &result, &rows, NULL);
155 sqlite3_free(sql);
/netgear-WNDR4500v2-V1.0.0.60_1.0.38/ap/gpl/minidlna/minidlna.03.14/
H A Dsql.c22 #include "sql.h"
31 char *sql; local
33 //DPRINTF(E_DEBUG, L_DB_SQL, "SQL: %s\n", sql);
37 sql = sqlite3_vmprintf(fmt, ap);
38 ret = sqlite3_exec(db, sql, 0, 0, &errMsg);
41 DPRINTF(E_ERROR, L_DB_SQL, "SQL ERROR %d [%s]\n%s\n", ret, errMsg, sql);
45 sqlite3_free(sql);
51 sql_get_table(sqlite3 *db, const char *sql, char ***pazResult, int *pnRow, int *pnColumn) argument
55 //DPRINTF(E_DEBUG, L_DB_SQL, "SQL: %s\n", sql);
57 ret = sqlite3_get_table(db, sql, pazResul
73 char *sql; local
133 char *sql; local
[all...]
H A DMakefile50 sql.o utils.o metadata.o scanner.o inotify.o \
103 upnphttp.o: upnpevents.h image_utils.h sql.h log.h icons.c
106 upnpsoap.o: config.h upnpglobalvars.h minidlnatypes.h log.h utils.h sql.h
124 scanner.o: upnpglobalvars.h metadata.h utils.h sql.h scanner.h log.h playlist.h
125 metadata.o: upnpglobalvars.h metadata.h albumart.h utils.h sql.h log.h
126 albumart.o: upnpglobalvars.h albumart.h utils.h image_utils.h sql.h log.h
139 sql.o: sql.h
H A Dtivo_commands.c31 #include "sql.h"
280 char *sql; local
293 asprintf(&sql, SELECT_COLUMNS
296 DPRINTF(E_DEBUG, L_TIVO, "%s\n", sql);
297 ret = sqlite3_exec(db, sql, callback, (void *) &args, &zErrMsg);
298 free(sql);
316 char *sql, *item, *saveptr; local
569 sql = sqlite3_mprintf("SELECT %s from OBJECTS o left join DETAILS d on (o.DETAIL_ID = d.ID)"
573 DPRINTF(E_DEBUG, L_TIVO, "%s\n", sql);
574 if( (sql_get_table(db, sql,
[all...]
H A Dinotify.c42 #include "sql.h"
515 char sql[128]; local
548 snprintf(sql, sizeof(sql), "SELECT PARENT_ID from OBJECTS where DETAIL_ID = %lld", detailID);
549 if( (sql_get_table(db, sql, &result, &rows, NULL) == SQLITE_OK) )
596 char * sql; local
604 sql = sqlite3_mprintf("SELECT ID from DETAILS where PATH glob '%q/*'"
606 if( (sql_get_table(db, sql, &result, &rows, NULL) == SQLITE_OK) )
620 sqlite3_free(sql);
H A Dalbumart.c33 #include "sql.h"
340 char *sql; local
348 sql = sqlite3_mprintf("SELECT ID from ALBUM_ART where PATH = '%q'", album_art ? album_art : path);
349 if( (sql_get_table(db, sql, &result, &rows, &cols) == SQLITE_OK) && rows )
359 sqlite3_free(sql);
H A Dupnpsoap.c70 #include "sql.h"
1306 char *sql, *ptr; local
1424 sql = sqlite3_mprintf("SELECT %s, " COLUMNS
1429 ret = sqlite3_exec(db, sql, callback, (void *) &args, &zErrMsg);
1475 sql = sqlite3_mprintf( SELECT_COLUMNS
1479 DPRINTF(E_DEBUG, L_HTTP, "Browse SQL: %s\n", sql);
1480 ret = sqlite3_exec(db, sql, callback, (void *) &args, &zErrMsg);
1484 DPRINTF(E_WARN, L_HTTP, "SQL error: %s\nBAD SQL: %s\n", zErrMsg, sql);
1489 sqlite3_free(sql);
1525 char *sql, *pt local
[all...]
H A Dscanner.c41 #include "sql.h"
132 char sql[128]; local
147 snprintf(sql, sizeof(sql), "SELECT DATE, CREATOR from DETAILS where ID = %lld", detailID);
148 ret = sql_get_table(db, sql, &result, &row, &cols);
230 snprintf(sql, sizeof(sql), "SELECT ALBUM, ARTIST, GENRE, ALBUM_ART from DETAILS where ID = %lld", detailID);
231 ret = sql_get_table(db, sql, &result, &row, &cols);
/netgear-WNDR4500v2-V1.0.0.60_1.0.38/ap/gpl/minidlna/sqlite-3.6.22/
H A Dsqlite3ext.h76 int (*complete)(const char*sql);
77 int (*complete16)(const void*sql);
192 const char *(*sql)(sqlite3_stmt*); member in struct:sqlite3_api_routines
371 #define sqlite3_sql sqlite3_api->sql
H A Dsqlite3.h335 const char *sql, /* SQL to be evaluated */
1505 SQLITE_API int sqlite3_complete(const char *sql);
1506 SQLITE_API int sqlite3_complete16(const void *sql);

Completed in 236 milliseconds

12