Lines Matching defs:title
83 { mfi_offsetof(title), DB_TYPE_STRING },
146 { pli_offsetof(title), DB_TYPE_STRING },
167 dbmfi_offsetof(title),
230 dbpli_offsetof(title),
277 "ORDER BY f.type DESC, f.special_id ASC, f.title ASC",
346 if (mfi->title)
347 free(mfi->title);
452 if (pli->title)
453 free(pli->title);
684 #define Q_TMPL "UPDATE playlists SET title = '%q' WHERE type = 1 AND special_id = %d;"
689 char *title;
698 title = cfg_getstr(lib, cfg_item[i]);
699 if (!title)
706 query = sqlite3_mprintf(Q_TMPL, title, special_id[i]);
717 DPRINTF(E_LOG, L_DB, "Error setting playlist title, query %s, error: %s\n", query, errmsg);
722 DPRINTF(E_DBG, L_DB, "Playlist title for config item '%s' set with query '%s'\n", cfg_item[i], query);
2365 #define Q_TMPL "INSERT INTO files (id, path, fname, title, artist, album, genre, comment, type, composer," \
2401 STR(mfi->path), STR(mfi->fname), mfi->title, mfi->artist, mfi->album,
2446 #define Q_TMPL "UPDATE files SET path = '%q', fname = '%q', title = TRIM(%Q), artist = TRIM(%Q), album = TRIM(%Q), genre = TRIM(%Q)," \
2476 STR(mfi->path), STR(mfi->fname), mfi->title, mfi->artist, mfi->album, mfi->genre,
2893 db_pl_fetch_bytitlepath(char *title, char *path)
2895 #define Q_TMPL "SELECT p.* FROM playlists p WHERE p.title = '%q' AND p.path = '%q';"
2899 query = sqlite3_mprintf(Q_TMPL, title, path);
2917 db_pl_add(char *title, char *path, int *id)
2919 #define QDUP_TMPL "SELECT COUNT(*) FROM playlists p WHERE p.title = '%q' AND p.path = '%q';"
2920 #define QADD_TMPL "INSERT INTO playlists (title, type, query, db_timestamp, disabled, path, idx, special_id)" \
2927 query = sqlite3_mprintf(QDUP_TMPL, title, path);
2940 DPRINTF(E_WARN, L_DB, "Duplicate playlist with title '%s' path '%s'\n", title, path);
2945 query = sqlite3_mprintf(QADD_TMPL, title, (int64_t)time(NULL), path);
2973 DPRINTF(E_DBG, L_DB, "Added playlist %s (path %s) with id %d\n", title, path, *id);
3006 db_pl_update(char *title, char *path, int id)
3008 #define Q_TMPL "UPDATE playlists SET title = '%q', db_timestamp = %" PRIi64 ", disabled = 0, path = '%q' WHERE id = %d;"
3011 query = sqlite3_mprintf(Q_TMPL, title, (int64_t)time(NULL), path, id);
4225 " title VARCHAR(1024) DEFAULT NULL COLLATE DAAP," \
4284 " title VARCHAR(255) NOT NULL COLLATE DAAP," \
4346 "INSERT INTO playlists (id, title, type, query, db_timestamp, path, idx, special_id)" \
4350 "INSERT INTO playlists (id, title, type, query, db_timestamp, path, idx, special_id)" \
4354 "INSERT INTO playlists (id, title, type, query, db_timestamp, path, idx, special_id)" \
4358 "INSERT INTO playlists (id, title, type, query, db_timestamp, path, idx, special_id)" \
4362 "INSERT INTO playlists (id, title, type, query, db_timestamp, path, idx, special_id)" \
4366 "INSERT INTO playlists (id, title, type, query, db_timestamp, path, idx, special_id)" \
4487 { I_TITLE, "create title index" },
5015 " title VARCHAR(1024) DEFAULT NULL COLLATE DAAP," \
5095 "(id, path, fname, title, artist, album, genre, comment, type, composer," \
5102 " VALUES (' || id || ', ' || QUOTE(path) || ', ' || QUOTE(fname) || ', ' || QUOTE(title) || ', '" \
5114 " || songalbumid || ', ' || QUOTE(title) || ', ' || QUOTE(artist) || ', ' || QUOTE(album) || ', '" \
5154 " title VARCHAR(1024) DEFAULT NULL COLLATE DAAP," \
5236 "INSERT OR IGNORE INTO playlists (id, title, type, query, db_timestamp, path, idx, special_id)" \
5240 "INSERT OR IGNORE INTO playlists (id, title, type, query, db_timestamp, path, idx, special_id)" \
5266 "(id, path, fname, title, artist, album, genre, comment, type, composer," \
5274 " VALUES (' || id || ', ' || QUOTE(path) || ', ' || QUOTE(fname) || ', ' || QUOTE(title) || ', '" \
5303 " title VARCHAR(1024) DEFAULT NULL COLLATE DAAP," \
5388 "(id, path, fname, title, artist, album, genre, comment, type, composer," \
5396 " VALUES (' || id || ', ' || QUOTE(path) || ', ' || QUOTE(fname) || ', ' || QUOTE(title) || ', '" \