C# Class RPS.FileDatabase

Show file Open project: marijnkampf/Random-Photo-Screensaver Class Usage Examples

Public Properties

Property	Type	Description
readOnly	bool

Public Methods

Method	Description
CloseConnections ( ) : void
FileDatabase ( bool readOnly ) : System
addFileToDB ( FileInfo fi ) : void
addMetadataToDB ( long id, string metadata ) : bool
clearFilter ( ) : void
deleteFromDB ( long id ) : int
deleteFromDB ( string path ) : int
filterReady ( ) : string
filterReady ( bool force ) : string
getFirstImage ( string orderBy, SortOrder direction ) : DataRow
getFirstImage ( string orderBy, SortOrder direction, long offset ) : DataRow
getIdFromPath ( string path ) : long
getImageById ( long id, long offset ) : DataRow
getImageById ( long id, long offset, string sortByColumn, SortOrder sortByDirection ) : DataRow
getMetadataById ( long id ) : string
getRandomImage ( long offset ) : DataRow
nextMetadataLessImage ( ) : DataRow
nrImagesFilter ( ) : int
nrImagesInDB ( ) : int
nrMetadataImagesToProcess ( ) : int
purgeMatchingParentPaths ( string fullpath ) : int
purgeMediaDatabase ( ) : int
purgeMetadata ( ) : int
purgeNotMatchingParentFolders ( ConcurrentQueue folders, bool exactMatchFolders, List excludedSubfolders ) : int
renameFolderPaths ( string oldPath, string newPath ) : bool
resetFilter ( ) : void
resetIfChangedFilter ( ) : void
runSQLByPassFilter ( string subQuery ) : DataTable
setFilterSQL ( string sql ) : void
storePersistant ( ) : void
toggleMetadataTransaction ( ) : void
toggleMetadataTransaction ( bool closeOnly ) : void
updateFileNodesPath ( long id, string path ) : bool

Method Details

CloseConnections() public method

public CloseConnections ( ) : void
return	void

FileDatabase() public method

public FileDatabase ( bool readOnly ) : System
readOnly	bool
return	System

addFileToDB() public method

public addFileToDB ( FileInfo fi ) : void
fi	System.IO.FileInfo
return	void

addMetadataToDB() public method

public addMetadataToDB ( long id, string metadata ) : bool
id	long
metadata	string
return	bool

clearFilter() public method

public clearFilter ( ) : void
return	void

deleteFromDB() public method

public deleteFromDB ( long id ) : int
id	long
return	int

deleteFromDB() public method

public deleteFromDB ( string path ) : int
path	string
return	int

filterReady() public method

public filterReady ( ) : string
return	string

filterReady() public method

public filterReady ( bool force ) : string
force	bool
return	string

getFirstImage() public method

public getFirstImage ( string orderBy, SortOrder direction ) : DataRow
orderBy	string
direction	SortOrder
return	System.Data.DataRow

getFirstImage() public method

public getFirstImage ( string orderBy, SortOrder direction, long offset ) : DataRow
orderBy	string
direction	SortOrder
offset	long
return	System.Data.DataRow

getIdFromPath() public method

public getIdFromPath ( string path ) : long
path	string
return	long

getImageById() public method

public getImageById ( long id, long offset ) : DataRow
id	long
offset	long
return	System.Data.DataRow

getImageById() public method

public getImageById ( long id, long offset, string sortByColumn, SortOrder sortByDirection ) : DataRow
id	long
offset	long
sortByColumn	string
sortByDirection	SortOrder
return	System.Data.DataRow

getMetadataById() public method

public getMetadataById ( long id ) : string
id	long
return	string

getRandomImage() public method

public getRandomImage ( long offset ) : DataRow
offset	long
return	System.Data.DataRow

nextMetadataLessImage() public method

public nextMetadataLessImage ( ) : DataRow
return	System.Data.DataRow

nrImagesFilter() public method

public nrImagesFilter ( ) : int
return	int

nrImagesInDB() public method

public nrImagesInDB ( ) : int
return	int

nrMetadataImagesToProcess() public method

public nrMetadataImagesToProcess ( ) : int
return	int

purgeMatchingParentPaths() public method

public purgeMatchingParentPaths ( string fullpath ) : int
fullpath	string
return	int

purgeMediaDatabase() public method

public purgeMediaDatabase ( ) : int
return	int

purgeMetadata() public method

public purgeMetadata ( ) : int
return	int

purgeNotMatchingParentFolders() public method

public purgeNotMatchingParentFolders ( ConcurrentQueue folders, bool exactMatchFolders, List excludedSubfolders ) : int
folders	ConcurrentQueue
exactMatchFolders	bool
excludedSubfolders	List
return	int

renameFolderPaths() public method

public renameFolderPaths ( string oldPath, string newPath ) : bool
oldPath	string
newPath	string
return	bool

resetFilter() public method

public resetFilter ( ) : void
return	void

resetIfChangedFilter() public method

public resetIfChangedFilter ( ) : void
return	void

runSQLByPassFilter() public method

public runSQLByPassFilter ( string subQuery ) : DataTable
subQuery	string
return	System.Data.DataTable

setFilterSQL() public method

public setFilterSQL ( string sql ) : void
sql	string
return	void

storePersistant() public method

public storePersistant ( ) : void
return	void

toggleMetadataTransaction() public method

public toggleMetadataTransaction ( ) : void
return	void

toggleMetadataTransaction() public method

public toggleMetadataTransaction ( bool closeOnly ) : void
closeOnly	bool
return	void

updateFileNodesPath() public method

public updateFileNodesPath ( long id, string path ) : bool
id	long
path	string
return	bool

Property Details

readOnly public property

public bool readOnly
return	bool