ImageDb< FS > Class Template Reference

Database API. More...

#include <imagemanager.h>

Inheritance diagram for ImageDb< FS >:

Collaboration diagram for ImageDb< FS >:

Public Member Functions
int	GetImages (const QString &ids, ImageList &files, ImageList &dirs, const QString &refine="") const
	Read database images/dirs by id. More...
bool	GetDescendants (const QString &ids, ImageList &files, ImageList &dirs) const
	Return images and all of their descendants. More...
int	InsertDbImage (ImageItemK &im, bool checkForDuplicate=false) const
	Adds new image to database, optionally checking for existing filepath. More...
bool	UpdateDbImage (ImageItemK &im) const
	Updates or creates database image or dir. More...
QStringList	RemoveFromDB (const ImageList &imList) const
	Remove images/dirs from database. More...
bool	SetHidden (bool hide, const QString &ids) const
	Sets hidden status of an image/dir in database. More...
bool	SetCover (int dir, int id) const
	Set the thumbnail(s) to be used for a dir. More...
bool	SetOrientation (int id, int orientation) const
	Sets image orientation in Db. More...
bool	ReadAllImages (ImageHash &files, ImageHash &dirs) const
	Read all database images and dirs as map. No filters or ordering applied. More...
void	ClearDb (int devId, const QString &action)
	Clear Db for device & remove device. More...
int	GetChildren (const QString &ids, ImageList &files, ImageList &dirs, const QString &refine="") const
	Read immediate children of a dir. More...
bool	GetImageTree (int id, ImageList &files, const QString &refine) const
	Returns all files in the sub-tree of a dir. More...
int	GetDirectory (int id, ImagePtr &parent, ImageList &files, ImageList &dirs, const QString &refine) const
	Read a dir and its immediate children from Db. More...
void	GetDescendantCount (int id, bool all, int &dirs, int &pics, int &videos, int &sizeKb) const
	Return counts of dirs, pics, videos and size in the subtree of a dir. More...

Protected Member Functions
	ImageDb (QString table)
ImageItem *	CreateImage (const MSqlQuery &query) const
	Create image from Db query data. More...
int	ReadImages (ImageList &dirs, ImageList &files, const QString &selector) const
	Read selected database images/dirs. More...

Protected Attributes
QString	m_table
	Db table name. More...

Detailed Description

template<class FS>
class ImageDb< FS >

Database API.

Requires a filesystem adapter Only handles a single id format, ie. local ids or remote ids Provides ordering & filters (SQL does the work)

Definition at line 277 of file imagemanager.h.

Constructor & Destructor Documentation

ImageDb()

template<class FS >

ImageDb< FS >::ImageDb ( QString  table )

inlineexplicitprotected

Definition at line 307 of file imagemanager.h.

Member Function Documentation

GetImages()

template<class FS >

int ImageDb< FS >::GetImages	(	const QString &	ids,
		ImageList &	files,
		ImageList &	dirs,
		const QString &	refine = ""
	)		const

Read database images/dirs by id.

Parameters

[in]	ids	Comma-separated list of ids
[in,out]	files	List of files
[in,out]	dirs	List of dirs
[in]	refine	SQL clause to refine selection & apply ordering

Returns

int Number of items matching query, -1 on SQL error

Definition at line 555 of file imagemanager.cpp.

Referenced by ImageDbReader::GetImages().

GetDescendants()

template<class FS >

bool ImageDb< FS >::GetDescendants	(	const QString &	ids,
		ImageList &	files,
		ImageList &	dirs
	)		const

Return images and all of their descendants.

Parameters

[in]	ids	Image ids
[in,out]	files	Ordered/filtered files
[in,out]	dirs	Ordered/filtered dirs

Definition at line 635 of file imagemanager.cpp.

Referenced by ImageDbReader::GetDescendants().

InsertDbImage()

template<class FS >

int ImageDb< FS >::InsertDbImage	(	ImageItemK &	im,
		bool	checkForDuplicate = false
	)		const

Adds new image to database, optionally checking for existing filepath.

Parameters

im	Image to add
checkForDuplicate	If true, the image will not be added if its filepath already exists in Db.

Returns

int Id of new image or the existing image with same filepath

Definition at line 771 of file imagemanager.cpp.

UpdateDbImage()

template<class FS >

bool ImageDb< FS >::UpdateDbImage

(

ImageItemK &

im

)

const

Updates or creates database image or dir.

Item does not need to pre-exist

Parameters

im	Image or dir

Definition at line 829 of file imagemanager.cpp.

RemoveFromDB()

template<class FS >

QStringList ImageDb< FS >::RemoveFromDB

(

const ImageList &

imList

)

const

Remove images/dirs from database.

Item does not need to exist in db

Parameters

imList

List of items to delete

Returns

QStringList List of ids that were successfully removed

Definition at line 872 of file imagemanager.cpp.

SetHidden()

template<class FS >

bool ImageDb< FS >::SetHidden	(	bool	hide,
		const QString &	ids
	)		const

Sets hidden status of an image/dir in database.

Parameters

hide	True = hidden, False = unhidden
ids	List of item ids

Returns

bool False if db update failed

Definition at line 902 of file imagemanager.cpp.

SetCover()

template<class FS >

bool ImageDb< FS >::SetCover	(	int	dir,
		int	id
	)		const

Set the thumbnail(s) to be used for a dir.

Parameters

dir	Dir id
id	Image id to use as cover/thumbnail

Definition at line 928 of file imagemanager.cpp.

SetOrientation()

template<class FS >

bool ImageDb< FS >::SetOrientation	(	int	id,
		int	orientation
	)		const

Sets image orientation in Db.

Parameters

id	Image id
orientation	Exif orientation code

Definition at line 952 of file imagemanager.cpp.

ReadAllImages()

template<class FS >

bool ImageDb< FS >::ReadAllImages	(	ImageHash &	files,
		ImageHash &	dirs
	)		const

Read all database images and dirs as map. No filters or ordering applied.

Parameters

[in,out]	files	Map <filepath, image>
[in,out]	dirs	Map <filepath, dir>

Definition at line 704 of file imagemanager.cpp.

ClearDb()

template<class FS >

void ImageDb< FS >::ClearDb	(	int	devId,
		const QString &	action
	)

Clear Db for device & remove device.

Parameters

devId	Device id, 0 to clear all devices
action	The myth protocol message. Determines whether/how much information is removed from the database.

Returns

Either list of ids that have been deleted or "ALL" with list of filepath prefixes that will remove device images from the UI image cache

Definition at line 735 of file imagemanager.cpp.

GetChildren()

template<class FS >

int ImageDb< FS >::GetChildren	(	const QString &	ids,
		ImageList &	files,
		ImageList &	dirs,
		const QString &	refine = ""
	)		const

Read immediate children of a dir.

Parameters

[in,out]	dirs	List of child subdirs
[in,out]	files	List of child files
[in]	ids	Comma-separated list of dir ids
[in]	refine	SQL clause to refine selection & apply ordering

Returns

int Number of items matching query, -1 on SQL error

Definition at line 575 of file imagemanager.cpp.

Referenced by ImageDbReader::GetChildren().

GetImageTree()

template<class FS >

bool ImageDb< FS >::GetImageTree	(	int	id,
		ImageList &	files,
		const QString &	refine
	)		const

Returns all files in the sub-tree of a dir.

Parameters

[in,out]	files	List of images within sub-tree. Direct children first, then depth-first traversal of peer sub-dirs. Each level ordered as per refine criteria
	id	Dir id
	refine	SQL clause defining filter & ordering criteria

Definition at line 684 of file imagemanager.cpp.

Referenced by ImageDbReader::GetImageTree().

GetDirectory()

template<class FS >

int ImageDb< FS >::GetDirectory	(	int	id,
		ImagePtr &	parent,
		ImageList &	files,
		ImageList &	dirs,
		const QString &	refine
	)		const

Read a dir and its immediate children from Db.

Parameters

[in]	id	Dir id
[out]	parent	Dir item
[in,out]	dirs	Ordered/filtered child subdirs
[in,out]	files	Ordered/filtered child files
[in]	refine	SQL clause for filtering/ordering child images

Returns

int Number of items matching query.

Definition at line 593 of file imagemanager.cpp.

Referenced by ImageDbReader::GetDirectory().

GetDescendantCount()

template<class FS >

void ImageDb< FS >::GetDescendantCount	(	int	id,
		bool	all,
		int &	dirs,
		int &	pics,
		int &	videos,
		int &	sizeKb
	)		const

Return counts of dirs, pics, videos and size in the subtree of a dir.

Parameters

[in]	id	Dir id
[in]	all	Sum whole table (without filtering on dir path)
[in,out]	dirs	Number of dirs in parent sub-tree
[in,out]	pics	Number of pictures in parent sub-tree
[in,out]	videos	Number of videos in parent sub-tree
[in,out]	sizeKb	Size in KiB of parent sub-tree

Definition at line 1013 of file imagemanager.cpp.

Referenced by ImageDbReader::GetDescendantCount().

CreateImage()

template<class FS >

ImageItem * ImageDb< FS >::CreateImage ( const MSqlQuery &  query ) const

protected

Create image from Db query data.

Parameters

query

Db query result

Returns

ImageItem An image object

Definition at line 512 of file imagemanager.cpp.

ReadImages()

template<class FS >

int ImageDb< FS >::ReadImages ( ImageList &  dirs, ImageList &  files, const QString &  selector  ) const

protected

Read selected database images/dirs.

Parameters

[out]	dirs	List of the dirs
[out]	files	List of the files
	selector	SQL clause specifying selection and ordering of images

Returns

int Number of items retreved

Definition at line 978 of file imagemanager.cpp.

Member Data Documentation

m_table

template<class FS >

QString ImageDb< FS >::m_table

protected

Db table name.

Definition at line 313 of file imagemanager.h.

---

The documentation for this class was generated from the following files:

• imagemanager.h
• imagemanager.cpp