/** \fn GalleryDatabaseHelper::LoadDirectories(QList<ImageMetadata *>* , int)
* \brief Loads all subdirectory information from the database for a given directory
* \param dbList The list where the results are stored
* \param parentId The id of the given directory
* \return void
*/
void GalleryDatabaseHelper::LoadDirectories(QList<ImageMetadata *>* dbList, int parentId)
{
dbList->clear();
MSqlQuery query(MSqlQuery::InitCon());
query.prepare("SELECT "
"dir_id, filename, name, path, parent_id, "
"dir_count, file_count, "
"hidden "
"FROM gallery_directories "
"WHERE (parent_id = :PARENTID) "
"AND (hidden = '0' OR hidden = :HIDDEN) "
"ORDER BY name ASC;");
query.bindValue(":PARENTID", parentId);
query.bindValue(":HIDDEN", gCoreContext->GetNumSetting("GalleryShowHiddenFiles"));
if (!query.exec())
LOG(VB_GENERAL, LOG_ERR, MythDB::DBErrorMessage(query.lastError()));
while (query.next())
{
ImageMetadata *im = new ImageMetadata();
LoadDirectoryValues(query, im);
dbList->append(im);
}
}
/** \fn ImageUtils::LoadDirectoryFromDB(QMap<QString, ImageMetadata *>*)
* \brief Loads all directory information from the database
* \param dbList The list where the results are stored
* \return void
*/
void ImageUtils::LoadDirectoriesFromDB(QMap<QString, ImageMetadata *>* dbList)
{
dbList->clear();
MSqlQuery query(MSqlQuery::InitCon());
query.prepare(
QString("SELECT "
"dir_id, filename, name, path, parent_id, "
"dir_count, file_count, "
"hidden "
"FROM gallery_directories"));
if (!query.exec())
LOG(VB_GENERAL, LOG_ERR, MythDB::DBErrorMessage(query.lastError()));
if (query.size() > 0)
{
while (query.next())
{
ImageMetadata *im = new ImageMetadata();
LoadDirectoryValues(query, im);
dbList->insert(im->m_fileName, im);
}
}
}
/** \fn GalleryDatabaseHelper::LoadParentDirectory(QList<ImageMetadata *>* , int)
* \brief Loads the information from the database for a given directory
* \param dbList The list where the results are stored
* \param parentId The id of the given directory
* \return void
*/
void GalleryDatabaseHelper::LoadParentDirectory(QList<ImageMetadata *>* dbList, int parentId)
{
dbList->clear();
MSqlQuery query(MSqlQuery::InitCon());
query.prepare("SELECT "
"dir_id, filename, name, path, parent_id, "
"dir_count, file_count, "
"hidden "
"FROM gallery_directories "
"WHERE dir_id = :PARENTID;");
query.bindValue(":PARENTID", parentId);
if (!query.exec())
LOG(VB_GENERAL, LOG_ERR, MythDB::DBErrorMessage(query.lastError()));
while (query.next())
{
ImageMetadata *im = new ImageMetadata();
LoadDirectoryValues(query, im);
// Overwrite the folder type
im->m_type = kUpDirectory;
dbList->append(im);
}
}
