/** \fn ImageUtils::LoadFilesFromDB(QMap<QString, ImageMetadata *>*)
* \brief Loads all file information from the database
* \param dbList The list where the results are stored
* \return void
*/
void ImageUtils::LoadFilesFromDB(QMap<QString, ImageMetadata *>* dbList)
{
dbList->clear();
MSqlQuery query(MSqlQuery::InitCon());
query.prepare(
QString("SELECT "
"file_id, filename, name, path, dir_id, "
"type, modtime, size, extension, "
"angle, date, zoom, "
"hidden, orientation "
"FROM gallery_files"));
if (!query.exec())
LOG(VB_GENERAL, LOG_ERR, MythDB::DBErrorMessage(query.lastError()));
if (query.size() > 0)
{
while (query.next())
{
ImageMetadata *im = new ImageMetadata();
LoadFileValues(query, im);
dbList->insert(im->m_fileName, im);
}
}
}
/** \fn GalleryDatabaseHelper::LoadFiles(QList<ImageMetadata *>* , int)
* \brief Loads all file 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::LoadFiles(QList<ImageMetadata *>* dbList, int parentId)
{
dbList->clear();
MSqlQuery query(MSqlQuery::InitCon());
query.prepare("SELECT "
"file_id, CONCAT_WS('/', path, filename), name, path, dir_id, "
"type, modtime, size, extension, "
"angle, date, zoom, hidden, orientation "
"FROM gallery_files "
"WHERE (dir_id = :PARENTID) "
"AND (hidden = '0' OR hidden = :HIDDEN) "
"ORDER BY :ORDERBY");
query.bindValue(":PARENTID", parentId);
query.bindValue(":HIDDEN", gCoreContext->GetNumSetting("GalleryShowHiddenFiles"));
query.bindValue(":ORDERBY", GetSortOrder());
if (!query.exec())
LOG(VB_GENERAL, LOG_ERR, MythDB::DBErrorMessage(query.lastError()));
while (query.next())
{
ImageMetadata *im = new ImageMetadata();
LoadFileValues(query, im);
dbList->append(im);
}
}
/** \fn GalleryDatabaseHelper::LoadFiles(QList<ImageMetadata *>* , int)
* \brief Loads all file 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::LoadFiles(QList<ImageMetadata *>* dbList, int parentId)
{
dbList->clear();
MSqlQuery query(MSqlQuery::InitCon());
query.prepare(
QString("SELECT "
"file_id, filename, name, path, dir_id, "
"type, modtime, size, extension, "
"angle, date, zoom, "
"hidden, orientation "
"FROM gallery_files "
"WHERE (dir_id = '%1') "
"AND (hidden = '0' OR hidden = '%2') "
"ORDER BY %3;")
.arg(parentId)
.arg(gCoreContext->GetNumSetting("GalleryShowHiddenFiles"))
.arg(GetSortOrder()));
if (!query.exec())
LOG(VB_GENERAL, LOG_ERR, MythDB::DBErrorMessage(query.lastError()));
if (query.size() > 0)
{
while (query.next())
{
ImageMetadata *im = new ImageMetadata();
LoadFileValues(query, im);
dbList->append(im);
}
}
}
/** \fn GalleryDatabaseHelper::LoadFiles(QMap<QString, ImageMetadata *>*)
* \brief Loads all file information from the database
* \param dbList The list where the results are stored
* \return void
*/
void GalleryDatabaseHelper::LoadFiles(QMap<QString, ImageMetadata *>* dbList)
{
dbList->clear();
MSqlQuery query(MSqlQuery::InitCon());
query.prepare("SELECT "
"file_id, CONCAT_WS('/', path, filename), name, path, dir_id, "
"type, modtime, size, extension, "
"angle, date, zoom, hidden, orientation "
"FROM gallery_files");
if (!query.exec())
LOG(VB_GENERAL, LOG_ERR, MythDB::DBErrorMessage(query.lastError()));
while (query.next())
{
ImageMetadata *im = new ImageMetadata();
LoadFileValues(query, im);
dbList->insert(im->m_fileName, im);
}
}
/** \fn ImageUtils::LoadFileFromDB(ImageMetadata *, int)
* \brief Load the file information from the database given by the id
* \param im The image metadata which holds the information
* \return void
*/
void ImageUtils::LoadFileFromDB(ImageMetadata * im, int id)
{
MSqlQuery query(MSqlQuery::InitCon());
query.prepare(
QString("SELECT "
"file_id, filename, name, path, dir_id, "
"type, modtime, size, extension, "
"angle, date, zoom, "
"hidden, orientation "
"FROM gallery_files "
"WHERE file_id = :FILE_ID;"));
query.bindValue(":FILE_ID", id);
if (!query.exec())
LOG(VB_GENERAL, LOG_ERR, MythDB::DBErrorMessage(query.lastError()));
if (query.size() > 0)
{
while (query.next())
{
LoadFileValues(query, im);
}
}
}
