ctb/src/db.c File Reference

#include "db.h"
#include "ctb_log.h"

Include dependency graph for ctb/src/db.c:

Go to the source code of this file.

Functions
erMetadb	get_database ()
int	open_global_database (const gchar *directory)
void	close_database ()
int	db_query_create (int column1,...)
static const gchar *	get_sort_order_name (int sort_order, gboolean show_filenames)
int	db_query_execute (int sort_order, gboolean sort_asc, metadata_table **values, const gchar *tag_filter)
int	db_query_execute_recent (metadata_table **values, int limit)
int	db_query_execute_search_filter (int sort_order, gboolean sort_asc, metadata_table **values, const gchar *search_filter)
int	db_query_execute_path_filter (int sort_order, gboolean sort_asc, metadata_table **values, const gchar *path_filter, gboolean show_filenames)
int	db_query_get_metadata (const gchar *filename, const gchar *dirpath, metadata_table **values)
int	db_query_update_lastread (const GString *filename, const GString *directory, int value)
Variables
static const char *	MDB_COLUMN_NAMES []
static const int	SORT_COLUMN_NAME_IDX [N_CTB_SORT_ORDER]
static const int	MAX_WAIT_DATABASE = 30
static erMetadb	g_metadb = NULL
metadata_table *	g_query_names = NULL
gboolean	g_query_in_progress = FALSE

---

Function Documentation

void close_database

(

)

Definition at line 98 of file ctb/src/db.c.

References ermetadb_close(), and g_metadb.

Referenced by do_example_db_actions(), filemodel_chdir(), filemodel_quit(), and open_global_database().

{
    if (g_metadb)
    {
        ermetadb_close(g_metadb);
        g_metadb = NULL;
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

int db_query_create	(	int	column1,
			...
	)

Definition at line 108 of file ctb/src/db.c.

References ER_FAIL, ER_OK, g_query_in_progress, MDB_COLUMN_NAMES, metadata_table_add_column(), metadata_table_free, metadata_table_new(), and WARNPRINTF.

Referenced by create_query().

{
    va_list ap;
    int col;

    if (g_query_in_progress)
    {
        WARNPRINTF("trying to start a new query mid-query");
        if (g_query_names)
            metadata_table_free(g_query_names);
    }

    g_query_in_progress = TRUE;
    g_query_names = metadata_table_new();
    if (!g_query_names)
        return ER_FAIL;

    va_start(ap, column1);
    for (col = column1; col!=-1; col = va_arg(ap, int))
    {
        int rc = metadata_table_add_column(g_query_names, MDB_COLUMN_NAMES[col]);
        if (rc!=ER_OK)
        {
            va_end(ap);
            return rc;
        }
    }
    va_end(ap);
    return ER_OK;
}

Here is the call graph for this function:

Here is the caller graph for this function:

int db_query_execute	(	int	sort_order,
		gboolean	sort_asc,
		metadata_table **	values,
		const gchar *	tag_filter
	)

Definition at line 148 of file ctb/src/db.c.

References ermetadb_global_select_files(), g_metadb, g_query_in_progress, get_sort_order_name(), and metadata_table_free.

Referenced by load_dir_from_metadb().

{
    int rc = ermetadb_global_select_files( g_metadb,
                                           get_sort_order_name(sort_order, FALSE),
                                           sort_asc,
                                           g_query_names,
                                           values,
                                           tag_filter );
    metadata_table_free(g_query_names);
    g_query_in_progress = FALSE;
    return rc;
}

Here is the call graph for this function:

Here is the caller graph for this function:

int db_query_execute_path_filter	(	int	sort_order,
		gboolean	sort_asc,
		metadata_table **	values,
		const gchar *	path_filter,
		gboolean	show_filenames
	)

Definition at line 195 of file ctb/src/db.c.

References ermetadb_global_select_subdir(), g_metadb, g_query_in_progress, get_sort_order_name(), and metadata_table_free.

Referenced by load_dir_from_metadb().

{
    int rc = ermetadb_global_select_subdir( g_metadb,
                                            get_sort_order_name(sort_order, show_filenames),
                                            sort_asc,
                                            g_query_names,
                                            values,
                                            path_filter);
    metadata_table_free(g_query_names);
    g_query_in_progress = FALSE;
    return rc;
}

Here is the call graph for this function:

Here is the caller graph for this function:

int db_query_execute_recent	(	metadata_table **	values,
		int	limit
	)

Definition at line 165 of file ctb/src/db.c.

References CTB_SORT_BY_DATE_ADDED, ermetadb_global_select_recent(), g_metadb, g_query_in_progress, get_sort_order_name(), and metadata_table_free.

Referenced by load_dir_from_metadb().

{
    int rc = ermetadb_global_select_recent( g_metadb,
                                            get_sort_order_name(CTB_SORT_BY_DATE_ADDED, FALSE),
                                            limit,
                                            g_query_names,
                                            values);
    metadata_table_free(g_query_names);
    g_query_in_progress = FALSE;
    return rc;
}

Here is the call graph for this function:

Here is the caller graph for this function:

int db_query_execute_search_filter	(	int	sort_order,
		gboolean	sort_asc,
		metadata_table **	values,
		const gchar *	search_filter
	)

Definition at line 178 of file ctb/src/db.c.

References ermetadb_global_select_search(), g_metadb, g_query_in_progress, get_sort_order_name(), and metadata_table_free.

Referenced by load_dir_from_metadb().

{
    int rc = ermetadb_global_select_search( g_metadb,
                                            get_sort_order_name(sort_order, FALSE),
                                            sort_asc,
                                            g_query_names,
                                            values,
                                            search_filter);
    metadata_table_free(g_query_names);
    g_query_in_progress = FALSE;
    return rc;
}

Here is the call graph for this function:

Here is the caller graph for this function:

int db_query_get_metadata	(	const gchar *	filename,
		const gchar *	dirpath,
		metadata_table **	values
	)

Definition at line 213 of file ctb/src/db.c.

References ermetadb_global_get_file(), g_metadb, g_query_in_progress, and metadata_table_free.

{
    int rc = ermetadb_global_get_file( g_metadb,
                                       dirpath,
                                       filename,
                                       g_query_names,
                                       values);
    metadata_table_free(g_query_names);
    g_query_in_progress = FALSE;
    return rc;
}

Here is the call graph for this function:

int db_query_update_lastread	(	const GString *	filename,
		const GString *	directory,
		int	value
	)

Definition at line 228 of file ctb/src/db.c.

References COL_FILETIME_LASTREAD, ER_OK, ermetadb_global_change_file(), g_metadb, MDB_COLUMN_NAMES, metadata_table_add_column(), metadata_table_free, metadata_table_new(), and metadata_table_set_int64().

{
    metadata_table *query = metadata_table_new();

    int rc = metadata_table_add_column(query, MDB_COLUMN_NAMES[COL_FILETIME_LASTREAD]);
    if (rc == ER_OK) rc = metadata_table_set_int64(query, 0, value);
    if (rc == ER_OK) rc = ermetadb_global_change_file(g_metadb,
                                                      directory->str,
                                                      filename->str,
                                                      query);
    metadata_table_free(query);
    return rc;
}

Here is the call graph for this function:

erMetadb get_database

(

)

Definition at line 75 of file ctb/src/db.c.

References g_metadb.

Referenced by filemodel_get_database().

{
    return g_metadb;
}

Here is the caller graph for this function:

static const gchar* get_sort_order_name	(	int	sort_order,
		gboolean	show_filenames
	)			[static]

Definition at line 140 of file ctb/src/db.c.

References COL_FILENAME, CTB_SORT_BY_NAME, MDB_COLUMN_NAMES, and SORT_COLUMN_NAME_IDX.

Referenced by db_query_execute(), db_query_execute_path_filter(), db_query_execute_recent(), and db_query_execute_search_filter().

{
    int sort_column = SORT_COLUMN_NAME_IDX[sort_order];
    if (show_filenames && sort_order == CTB_SORT_BY_NAME) sort_column = COL_FILENAME;
    return MDB_COLUMN_NAMES[sort_column];
}

Here is the caller graph for this function:

int open_global_database

(

const gchar *

directory

)

Definition at line 81 of file ctb/src/db.c.

References close_database(), ER_FAIL, ER_OK, ermetadb_get_dir(), ermetadb_global_open(), ERRORPRINTF, and g_metadb.

Referenced by filemodel_chdir().

{
    if (g_metadb && strcmp(directory, ermetadb_get_dir(g_metadb)) == 0 )
    {
        return ER_OK;
    }

    close_database();
    g_metadb = ermetadb_global_open(directory, FALSE);
    if (!g_metadb) {
        ERRORPRINTF("error opening global database in at [%s]", directory);
        return ER_FAIL;
    }
    return ER_OK;
}

Here is the call graph for this function:

Here is the caller graph for this function:

---

Variable Documentation

erMetadb g_metadb = NULL [static]

Definition at line 70 of file ctb/src/db.c.

Referenced by close_database(), db_query_execute(), db_query_execute_path_filter(), db_query_execute_recent(), db_query_execute_search_filter(), db_query_get_metadata(), db_query_update_lastread(), get_database(), and open_global_database().

gboolean g_query_in_progress = FALSE

Definition at line 72 of file ctb/src/db.c.

Referenced by db_query_create(), db_query_execute(), db_query_execute_path_filter(), db_query_execute_recent(), db_query_execute_search_filter(), and db_query_get_metadata().

metadata_table* g_query_names = NULL

Definition at line 71 of file ctb/src/db.c.

const int MAX_WAIT_DATABASE = 30 [static]

Definition at line 68 of file ctb/src/db.c.

const char* MDB_COLUMN_NAMES[] [static]

Initial value:

{
        [COL_FILENAME]          = "filename"           ,
        [COL_DIRECTORY_PATH]    = "directory_path"     ,
        [COL_SORT_PRIORITY]     = "sort_priority"      ,
        [COL_IS_DIRECTORY]      = "is_directory"       ,
        [COL_FILETYPE]          = "file_type"          ,
        [COL_FILESIZE]          = "file_size"          ,
        [COL_FILETIME_MODIFIED] = "file_time_modified" ,
        [COL_FILETIME_LASTREAD] = "file_time_lastread" ,
        [COL_FILETIME_ADDED]    = "file_time_added"    ,
        [COL_TITLE]             = "title"              ,
        [COL_AUTHOR]            = "author"             ,
        [COL_THUMB_MINI]        = "thumb_data_mini"    ,
        [COL_THUMB_SMALL]       = "thumb_data_small"   ,
        [COL_THUMB_MEDIUM]      = "thumb_data_medium"  ,
        [COL_THUMB_LARGE]       = "thumb_data_large"   ,
        [N_METADATA_COLUMNS]    = NULL
}

Copyright (C) 2008 iRex Technologies B.V. All rights reserved.

Definition at line 32 of file ctb/src/db.c.

Referenced by db_query_create(), db_query_update_lastread(), and get_sort_order_name().

const int SORT_COLUMN_NAME_IDX[N_CTB_SORT_ORDER] [static]

Initial value:

{
        [CTB_SORT_BY_NAME]       = COL_TITLE,
        [CTB_SORT_BY_TYPE]       = COL_FILETYPE,
        [CTB_SORT_BY_SIZE]       = COL_FILESIZE,
        [CTB_SORT_BY_DATE_ADDED] = COL_FILETIME_ADDED,
        [CTB_SORT_BY_DATE_READ]  = COL_FILETIME_LASTREAD,
        [CTB_SORT_BY_AUTHOR]     = COL_AUTHOR,
}

Definition at line 56 of file ctb/src/db.c.

Referenced by get_sort_order_name().