path: root/include/media_info_private.h

/*
* Copyright (c) 2011 Samsung Electronics Co., Ltd All Rights Reserved
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/


#ifndef __TIZEN_MEDIA_INFO_PRIVATE_H__
#define __TIZEN_MEDIA_INFO_PRIVATE_H__


#include <string.h>
#include <sqlite3.h>
#include <stdlib.h>
#include <stdio.h>
#include <glib.h>
#include <media-svc.h>
#include <media_content_type.h>
#include <dlog.h>

#ifdef __cplusplus
extern "C" {
#endif /* __cplusplus */

#ifdef LOG_TAG
#undef LOG_TAG
#endif

#define LOG_TAG "TIZEN_N_MEDIACONTENT"

#define SAFE_STRLCPY(dst, src, n)	((g_strlcpy(dst, src, n) < n) ? TRUE : FALSE)
#define SAFE_STRLCAT(dst, src, n)	g_strlcat(dst, src, n);
#define SAFE_FREE(src)		{if(src) {free(src); src = NULL;}}
#define STRING_VALID(str)		((str != NULL && strlen(str) > 0) ? TRUE : FALSE)
#define SQLITE3_FINALIZE(x)	{if(x != NULL) {sqlite3_finalize(x);}}

#define MEDIA_CONTENT_PATH_PHONE 	"/opt/media" 	/**< File path prefix of files stored in phone */
#define MEDIA_CONTENT_PATH_MMC 		"/mnt/mmc"		/**< File path prefix of files stored in mmc card */

#define MAX_QUERY_SIZE 4096
#define MIN_QUERY_SIZE 256
#define DEFAULT_QUERY_SIZE 1024
#define MAX_KEYWORD_SIZE 2048
#define COLLATE_STR_SIZE 32
#define MEDIA_CONTENT_UUID_SIZE	36

typedef enum {
	MEDIA_CONTENT_TYPE = 0,
	MEDIA_THUMBNAIL_TYPE,
	MEDIA_REGISTER_TYPE
} media_info_error_type_e;

typedef enum {
	Table_Media,
	Table_Folder,
	Table_Bookmark,
	Table_Tag,
	Table_TagMap,
} media_info_table_e;

typedef enum {
	MEDIA_TAG_ADD,
	MEDIA_TAG_REMOVE,
	MEDIA_TAG_UPDATE_TAG_NAME,
} tag_function_e;

typedef enum {
	MEDIA_PLAYLIST_ADD,
	MEDIA_PLAYLIST_REMOVE,
	MEDIA_PLAYLIST_UPDATE_PLAYLIST_NAME,
	MEDIA_PLAYLIST_UPDATE_PLAY_ORDER,
} playlist_function_e;

typedef enum {
	MEDIA_GROUP_NONE,
	MEDIA_GROUP_ALBUM,
	MEDIA_GROUP_FOLDER,
	MEDIA_GROUP_PLAYLIST,
	MEDIA_GROUP_TAG,
	MEDIA_GROUP_BOOKMARK,
	MEDIA_GROUP_TAG_BY_MEDIA_ID,
	MEDIA_GROUP_BOOKMARK_BY_MEDIA_ID,
} group_list_e;

typedef struct _filter_s
{
	char *condition;
	char *order_keyword;
	media_content_order_e order_type;
	media_content_collation_e condition_collate_type;
	media_content_collation_e order_collate_type;
	int offset;
	int count;
}filter_s;

typedef struct
{
	char *folder_id;				//image id, audio id, video id
	char *path;
	char *name;
	time_t modified_time;
	media_content_storage_e storage_type;
}media_folder_s;

typedef struct
{
	int tag_id;
	char *name;
}media_tag_s;

typedef struct
{
	int bookmark_id;
	char *media_id;
	time_t marked_time;
	char *thumbnail_path;
}media_bookmark_s;

typedef struct
{
	int album_id;
	char *name;
	char *artist;
	char *album_art_path;
}media_album_s;

typedef struct
{
	int playlist_id;	//playlist id
	char *name;		// playlist name
}media_playlist_s;

typedef struct
{
	char *media_id;
	int width;
	int height;
	char *date_taken;
	media_content_orientation_e orientation;
}image_meta_s;

typedef struct
{
	char *media_id;
	char *title;
	char *album;
	char *artist;
	char *genre;
	char *composer;
	char *year;
	char *recorded_date;
	char *copyright;
	char *track_num;
	int bitrate;
	int duration;
	int width;
	int height;
	int played_count;
	time_t played_time;
	int played_position;
}video_meta_s;

typedef struct
{
	char *media_id;
	char *title;
	char *album;
	char *artist;
	char *genre;
	char *composer;
	char *year;
	char *recorded_date;
	char *copyright;
	char *track_num;
	int bitrate;
	int samplerate;
	int channel;
	int duration;
	int played_count;
	time_t played_time;
	int played_position;
}audio_meta_s;

typedef struct
{
	char *media_id;				//image id, audio id, video id
	char *file_path;
	char *display_name;
	media_content_type_e media_type;
	char *mime_type;
	unsigned long long size;
	time_t added_time;
	time_t modified_time;
	char *thumbnail_path;
	char *description;
	double longitude;
	double latitude;
	double altitude;
	int rating;
	int favourite;
	char *author;
	char *provider;
	char *content_name;
	char *category;
	char *location_tag;
	char *age_rating;
	char *keyword;
	int is_drm;
	int storage_type;
	image_meta_s *image_meta;
	video_meta_s *video_meta;
	audio_meta_s *audio_meta;
}media_info_s;

typedef struct
{
	char *name;
}media_artist_s;

typedef struct
{
	char *name;
}media_genre_s;

typedef struct
{
	char *name;
}media_composer_s;

typedef struct
{
	char *name;
}media_year_s;

typedef struct
{
	char *media_id;		// media_uuid
	int function;			// Add, remove, modify
	char *tag_name;		// tag_name
}media_tag_item_s;

typedef struct
{
	char *media_id;		// media_uuid
	int function;			// Add, remove, modify
	char *playlist_name;	// playlist_name
	int playlist_member_id;	// playlist unique id of media. Same content which has same media_id can be added to Playlist
	int play_order;		//play_order
}media_playlist_item_s;

typedef struct _attribute_map_s
{
	GHashTable *attr_map;
}attribute_s;

typedef struct
{
	media_info_s *handle;
	void *user_data;
	media_thumbnail_completed_cb thumbnail_completed_cb;
}media_thumbnail_cb_s;

typedef struct attribute_s *attribute_h;

/* DB Table */
#define DB_TABLE_MEDIA			"media"
#define DB_TABLE_FOLDER		"folder"
#define DB_TABLE_ALBUM			"album"
#define DB_TABLE_TAG			"tag"
#define DB_TABLE_TAG_MAP		"tag_map"
#define DB_TABLE_PLAYLIST		"playlist"
#define DB_TABLE_PLAYLIST_MAP	"playlist_map"
#define DB_TABLE_BOOKMARK		"bookmark"

/* DB View */
#define DB_VIEW_PLAYLIST	"playlist_view"
#define DB_VIEW_TAG			"tag_view"

/* DB Table Alias */
#define DB_TABLE_ALIAS_MEDIA			"m"
#define DB_TABLE_ALIAS_FOLDER			"f"
#define DB_TABLE_ALIAS_PLAYLIST			"p"
#define DB_TABLE_ALIAS_PLAYLIST_MAP	"pm"
#define DB_TABLE_ALIAS_TAG				"t"
#define DB_TABLE_ALIAS_BOOKMARK		"b"
#define DB_TABLE_ALIAS_ALBUM			"a"

/* DB field for media */
#define DB_FIELD_MEDIA_ID					"media_uuid"
#define DB_FIELD_MEDIA_PATH				"path"
#define DB_FIELD_MEDIA_DISPLAY_NAME		"file_name"
#define DB_FIELD_MEDIA_TYPE					"media_type"
#define DB_FIELD_MEDIA_MIME_TYPE			"mime_type"
#define DB_FIELD_MEDIA_SIZE					"size"
#define DB_FIELD_MEDIA_ADDED_TIME			"added_time"
#define DB_FIELD_MEDIA_MODIFIED_TIME		"modified_time"
#define DB_FIELD_MEDIA_THUMBNAIL_PATH	"thumbnail_path"
#define DB_FIELD_MEDIA_TITLE				"title"
#define DB_FIELD_MEDIA_ALBUM				"album"
#define DB_FIELD_MEDIA_ARTIST				"artist"
#define DB_FIELD_MEDIA_GENRE				"genre"
#define DB_FIELD_MEDIA_COMPOSER			"composer"
#define DB_FIELD_MEDIA_YEAR				"year"
#define DB_FIELD_MEDIA_RECORDED_DATE		"recorded_date"
#define DB_FIELD_MEDIA_COPYRIGHT			"copyright"
#define DB_FIELD_MEDIA_TRACK_NUM			"track_num"
#define DB_FIELD_MEDIA_DESCRIPTION			"description"
#define DB_FIELD_MEDIA_BITRATE				"bitrate"
#define DB_FIELD_MEDIA_SAMPLERATE			"samplerate"
#define DB_FIELD_MEDIA_CHANNEL			"channel"
#define DB_FIELD_MEDIA_DURATION			"duration"
#define DB_FIELD_MEDIA_LONGITUDE			"longitude"
#define DB_FIELD_MEDIA_LATITUDE			"latitude"
#define DB_FIELD_MEDIA_ALTITUDE			"altitude"
#define DB_FIELD_MEDIA_WIDTH				"width"
#define DB_FIELD_MEDIA_HEIGHT				"height"
#define DB_FIELD_MEDIA_DATETAKEN			"datetaken"
#define DB_FIELD_MEDIA_ORIENTATION		"orientation"
#define DB_FIELD_MEDIA_PLAYED_COUNT		"played_count"
#define DB_FIELD_MEDIA_LAST_PLAYED_TIME		"last_played_time"
#define DB_FIELD_MEDIA_LAST_PLAYED_POSITION	"last_played_position"
#define DB_FIELD_MEDIA_RATING				"rating"
#define DB_FIELD_MEDIA_FAVOURITE			"favourite"
#define DB_FIELD_MEDIA_AUTHOR				"author"
#define DB_FIELD_MEDIA_PROVIDER			"provider"
#define DB_FIELD_MEDIA_CONTENT_NAME		"content_name"
#define DB_FIELD_MEDIA_CATEGORY			"category"
#define DB_FIELD_MEDIA_LOCATION_TAG		"location_tag"
#define DB_FIELD_MEDIA_AGE_RATING			"age_rating"
#define DB_FIELD_MEDIA_KEYWORD			"keyword"
#define DB_FIELD_MEDIA_IS_DRM				"is_drm"
#define DB_FIELD_MEDIA_STORAGE_TYPE		"storage_type"

/* DB field for folder */
#define DB_FIELD_FOLDER_ID				"folder_uuid"
#define DB_FIELD_FOLDER_PATH			"path"
#define DB_FIELD_FOLDER_NAME			"name"
#define DB_FIELD_FOLDER_MODIFIED_TIME	"modified_time"
#define DB_FIELD_FOLDER_STORAGE_TYPE	"storage_type"

/* DB field for playlist */
#define DB_FIELD_PLAYLIST_ID					"playlist_id"
#define DB_FIELD_PLAYLIST_NAME				"name"
#define DB_FIELD_PLAYLIST_MEMBER_ORDER	"play_order"
#define DB_FIELD_PLAYLIST_MEDIA_COUNT			"media_count"

/* DB field for tag */
#define DB_FIELD_TAG_ID			"tag_id"
#define DB_FIELD_TAG_NAME		"name"
#define DB_FIELD_TAG_MEDIA_COUNT			"media_count"

/* DB field for bookmark */
#define DB_FIELD_BOOKMARK_ID	"bookmark_id"
#define DB_FIELD_BOOKMARK_MARKED_TIME	"marked_time"

/* DB field for album*/
#define DB_FIELD_ALBUM_ID			"album_id"
#define DB_FIELD_ALBUM_NAME		"name"
#define DB_FIELD_ALBUM_ARTIST		"artist"

/* DB Query Keyword */
#define QUERY_KEYWORD_AND "AND"
#define QUERY_KEYWORD_OR "OR"
#define QUERY_KEYWORD_ORDER_BY "ORDER BY"
#define QUERY_KEYWORD_LIMIT "limit"
#define QUERY_KEYWORD_DESC "DESC"
#define QUERY_KEYWORD_SPACE " "
#define QUERY_KEYWORD_BRACKET ")"
#define UPDATE_SQL "UPDATE %s SET %s WHERE %s"

/* DB TABLE JOIN */
#define SELECT_EMPTY_PLAYLIST		"SELECT playlist_id, name FROM "DB_TABLE_PLAYLIST" WHERE playlist_id NOT IN (select playlist_id from "DB_TABLE_PLAYLIST_MAP")"
#define SELECT_EMPTY_TAG			"SELECT tag_id, name FROM "DB_TABLE_TAG" WHERE tag_id NOT IN (SELECT tag_id FROM "DB_TABLE_TAG_MAP")"
#define FOLDER_MEDIA_JOIN					"("DB_TABLE_FOLDER" AS f INNER JOIN "DB_TABLE_MEDIA" AS m ON f.folder_uuid=m.folder_uuid) WHERE m.validity=1"
#define PLAYLISTMAP_MEDIA_JOIN				"("DB_TABLE_PLAYLIST_MAP" AS pm INNER JOIN "DB_TABLE_MEDIA" AS m \
											ON (pm.media_uuid = m.media_uuid)) WHERE m.validity=1"
#define SELECT_PLAYLIST_FROM_PLAYLIST_PLAYLISTMAP_MEDIA_JOIN		"SELECT DISTINCT p.playlist_id, p.name FROM "DB_TABLE_PLAYLIST" AS p INNER JOIN "DB_TABLE_PLAYLIST_MAP" AS pm INNER JOIN "DB_TABLE_MEDIA" AS m \
											ON (p.playlist_id=pm.playlist_id AND pm.media_uuid = m.media_uuid) WHERE m.validity=1"
#define SELECT_TAG_FROM_TAG_TAGMAP_MEDIA_JOIN					"SELECT DISTINCT t.tag_id, t.name FROM "DB_TABLE_TAG" AS t INNER JOIN "DB_TABLE_MEDIA" AS m INNER JOIN "DB_TABLE_TAG_MAP" AS tm \
											ON (tm.media_uuid = m.media_uuid and tm.tag_id=t.tag_id) WHERE m.validity=1"
#define BOOKMARK_MEDIA_JOIN				"("DB_TABLE_BOOKMARK" AS b INNER JOIN "DB_TABLE_MEDIA" AS m \
											ON (b.media_uuid = m.media_uuid)) WHERE m.validity=1"
#define ALBUM_MEDIA_JOIN					"("DB_TABLE_ALBUM" AS a INNER JOIN "DB_TABLE_MEDIA" AS m \
											ON (a.album_id = m.album_id)) WHERE m.validity=1"

/* Get Group List */
#define SELECT_ALBUM_LIST			"SELECT DISTINCT a.album_id, a.name, a.artist, a.album_art FROM "ALBUM_MEDIA_JOIN
#define SELECT_ARTIST_LIST			"SELECT DISTINCT artist FROM "DB_TABLE_MEDIA" WHERE validity=1"
#define SELECT_GENRE_LIST			"SELECT DISTINCT genre FROM "DB_TABLE_MEDIA" WHERE validity=1"
#define SELECT_COMPOSER_LIST		"SELECT DISTINCT composer FROM "DB_TABLE_MEDIA" WHERE validity=1 "
#define SELECT_YEAR_LIST				"SELECT DISTINCT year FROM "DB_TABLE_MEDIA" WHERE validity=1 "
#define SELECT_MEDIA_GROUP_LIST	"SELECT DISTINCT %s FROM "DB_TABLE_MEDIA" WHERE validity=1 "

#define SELECT_FOLDER_LIST 			"SELECT DISTINCT f.folder_uuid, f.path, f.name, f.storage_type, f.modified_time FROM "FOLDER_MEDIA_JOIN
//#define SELECT_TAG_LIST				SELECT_EMPTY_TAG" UNION "SELECT_TAG_FROM_TAG_TAGMAP_MEDIA_JOIN
//#define SELECT_PLAYLIST_LIST			SELECT_EMPTY_PLAYLIST" UNION "SELECT_PLAYLIST_FROM_PLAYLIST_PLAYLISTMAP_MEDIA_JOIN
#define SELECT_TAG_LIST				"SELECT DISTINCT tag_id, name FROM "DB_VIEW_TAG" WHERE 1 "
#define SELECT_PLAYLIST_LIST		"SELECT DISTINCT playlist_id, name FROM "DB_VIEW_PLAYLIST" WHERE 1 "
#define SELECT_BOOKMARK_LIST		"SELECT DISTINCT b.bookmark_id, b.media_uuid, b.marked_time, b.thumbnail_path FROM "BOOKMARK_MEDIA_JOIN

/* Get Group Count */
#define SELECT_ALBUM_COUNT		"SELECT COUNT(DISTINCT a.album_id) FROM "ALBUM_MEDIA_JOIN
#define SELECT_ARTIST_COUNT		"SELECT COUNT(DISTINCT artist) FROM "DB_TABLE_MEDIA" WHERE validity=1"
#define SELECT_GENRE_COUNT			"SELECT COUNT(DISTINCT genre) FROM "DB_TABLE_MEDIA" WHERE validity=1"
#define SELECT_COMPOSER_COUNT	"SELECT COUNT(DISTINCT composer) FROM "DB_TABLE_MEDIA" WHERE validity=1"
#define SELECT_YEAR_COUNT			"SELECT COUNT(DISTINCT year) FROM "DB_TABLE_MEDIA" WHERE validity=1"
#define SELECT_FOLDER_COUNT		"SELECT COUNT(DISTINCT f.folder_uuid) FROM "FOLDER_MEDIA_JOIN
//#define SELECT_TAG_COUNT			"SELECT COUNT(*) FROM ("SELECT_TAG_LIST
//#define SELECT_PLAYLIST_COUNT		"SELECT COUNT(*) FROM ("SELECT_PLAYLIST_LIST
#define SELECT_TAG_COUNT			"SELECT COUNT(DISTINCT tag_id) FROM "DB_VIEW_TAG" WHERE 1 "
#define SELECT_PLAYLIST_COUNT		"SELECT COUNT(DISTINCT playlist_id) FROM "DB_VIEW_PLAYLIST" WHERE 1 "
#define SELECT_BOOKMARK_COUNT	"SELECT COUNT(DISTINCT b.bookmark_id) FROM "BOOKMARK_MEDIA_JOIN
#define SELECT_MEDIA_GROUP_COUNT	"SELECT COUNT(*) FROM ("SELECT_MEDIA_GROUP_LIST
/*count(distinct x) count only non-null values, but select distinct X returns include null. so sync the result of count and list, don't use count(distinct x)*/

/* Get Media Count of Group */
#define SELECT_MEDIA_COUNT_FROM_MEDIA			"SELECT COUNT(*) FROM ("SELECT_MEDIA_ITEM		//to apply limit condition. "SELECT COUNT(*) FROM "DB_TABLE_MEDIA" WHERE validity=1"
#define SELECT_MEDIA_COUNT_FROM_ALBUM			"SELECT COUNT(*) FROM "DB_TABLE_MEDIA" WHERE validity=1 AND album_id='%d'"
#define SELECT_MEDIA_COUNT_FROM_ARTIST			"SELECT COUNT(*) FROM "DB_TABLE_MEDIA" WHERE validity=1 AND artist='%q'"
#define SELECT_MEDIA_COUNT_FROM_GENRE			"SELECT COUNT(*) FROM "DB_TABLE_MEDIA" WHERE validity=1 AND genre='%q'"
#define SELECT_MEDIA_COUNT_FROM_COMPOSER		"SELECT COUNT(*) FROM "DB_TABLE_MEDIA" WHERE validity=1 AND composer='%q'"
#define SELECT_MEDIA_COUNT_FROM_YEAR				"SELECT COUNT(*) FROM "DB_TABLE_MEDIA" WHERE validity=1 AND year='%q'"
#define SELECT_MEDIA_COUNT_FROM_GROUP			"SELECT COUNT(*) FROM ("SELECT_MEDIA_FROM_GROUP		//to apply limit condition.
#define SELECT_MEDIA_COUNT_FROM_GROUP_NULL		"SELECT COUNT(*) FROM ("SELECT_MEDIA_FROM_GROUP_NULL	//to apply limit condition.
#define SELECT_MEDIA_COUNT_FROM_FOLDER			"SELECT COUNT(*) FROM "DB_TABLE_MEDIA" WHERE validity=1 AND folder_uuid='%q'"
//#define SELECT_MEDIA_COUNT_FROM_TAG				"SELECT COUNT(*) FROM "DB_TABLE_TAG_MAP" WHERE tag_id=%d AND media_uuid IN 													(SELECT media_uuid FROM "DB_TABLE_MEDIA" WHERE validity=1"
//#define SELECT_MEDIA_COUNT_FROM_PLAYLIST		"SELECT COUNT(*) FROM "DB_TABLE_PLAYLIST_MAP" WHERE playlist_id=%d AND media_uuid IN  													(SELECT media_uuid FROM "DB_TABLE_MEDIA" WHERE validity=1"
#define SELECT_MEDIA_COUNT_FROM_TAG				"SELECT COUNT(*) FROM "DB_VIEW_TAG" WHERE (tag_id=%d AND media_count>0) "
#define SELECT_MEDIA_COUNT_FROM_PLAYLIST		"SELECT COUNT(*) FROM "DB_VIEW_PLAYLIST" WHERE (playlist_id=%d and media_count>0) "

/* Get Group Info by Group ID*/
#define SELECT_ALBUM_FROM_ALBUM		"SELECT * FROM "DB_TABLE_ALBUM" WHERE album_id=%d"
#define SELECT_FOLDER_FROM_FOLDER		"SELECT * FROM "DB_TABLE_FOLDER" WHERE folder_uuid='%s'"
#define SELECT_FOLDER_BY_PATH			"SELECT * FROM "DB_TABLE_FOLDER" WHERE path='%q'"
#define SELECT_PLAYLIST_FROM_PLAYLIST	"SELECT * FROM "DB_TABLE_PLAYLIST" WHERE playlist_id=%d"
#define SELECT_TAG_FROM_TAG			"SELECT * FROM "DB_TABLE_TAG" WHERE tag_id=%d"
#define SELECT_TAG_BY_NAME				"SELECT * FROM "DB_TABLE_TAG" WHERE name='%q'"

/* Tag info*/
#define INSERT_TAG_TO_TAG						"INSERT INTO "DB_TABLE_TAG" (name) VALUES (%Q)"
#define REMOVE_TAG_ITEM_FROM_TAG_MAP		"DELETE FROM "DB_TABLE_TAG_MAP" WHERE tag_id=%d AND media_uuid='%q'"
#define UPDATE_TAG_NAME_FROM_TAG			"UPDATE "DB_TABLE_TAG" SET name='%q' WHERE tag_id=%d"
//#define SELECT_TAG_COUNT_BY_MEDIA_ID			"SELECT COUNT(*) FROM "DB_TABLE_TAG" WHERE tag_id IN (SELECT tag_id FROM "DB_TABLE_TAG_MAP" WHERE media_uuid = '%q')"
//#define SELECT_TAG_LIST_BY_MEDIA_ID				"SELECT * FROM "DB_TABLE_TAG" WHERE tag_id IN (SELECT tag_id FROM "DB_TABLE_TAG_MAP" WHERE media_uuid = '%s')"
#define SELECT_TAG_COUNT_BY_MEDIA_ID			"SELECT COUNT(*) FROM "DB_VIEW_TAG" WHERE media_uuid = '%q'"
#define SELECT_TAG_LIST_BY_MEDIA_ID				"SELECT tag_id, name FROM "DB_VIEW_TAG" WHERE media_uuid = '%s'"

/* Playlist Info */
#define INSERT_PLAYLIST_TO_PLAYLIST						"INSERT INTO "DB_TABLE_PLAYLIST" (name) VALUES (%Q)"
#define UPDATE_PLAYLIST_NAME_FROM_PLAYLIST			"UPDATE "DB_TABLE_PLAYLIST" SET name='%q' WHERE playlist_id=%d"
#define SELECT_PLAYLIST_ID_FROM_PLAYLIST				"SELECT playlist_id FROM "DB_TABLE_PLAYLIST" WHERE name='%q'"
//#define SELECT_PLAYLIST_ITEM_ID_FROM_PLAYLIST_MAP		"SELECT pm._id, pm.media_uuid FROM "PLAYLISTMAP_MEDIA_JOIN" AND pm.playlist_id=%d"
#define SELECT_PLAYLIST_ITEM_ID_FROM_PLAYLIST_VIEW		"SELECT pm_id, media_uuid FROM "DB_VIEW_PLAYLIST" WHERE playlist_id=%d "

//#define SELECT_PLAY_ORDER_FROM_PLAYLIST_MAP			"SELECT play_order FROM "DB_TABLE_PLAYLIST_MAP" WHERE playlist_id=%d and _id=%d"
#define SELECT_PLAY_ORDER_FROM_PLAYLIST_VIEW			"SELECT play_order FROM "DB_VIEW_PLAYLIST" WHERE playlist_id=%d and pm_id=%d"
//#define SELECT_MAX_PLAY_ORDER_FROM_PLAYLIST_MAP	"SELECT MAX(play_order) FROM "DB_TABLE_PLAYLIST_MAP" WHERE playlist_id=%d"
#define SELECT_MAX_PLAY_ORDER_FROM_PLAYLIST_VIEW	"SELECT MAX(play_order) FROM "DB_VIEW_PLAYLIST" WHERE playlist_id=%d"
#define REMOVE_PLAYLIST_ITEM_FROM_PLAYLIST_MAP		"DELETE FROM "DB_TABLE_PLAYLIST_MAP" WHERE playlist_id=%d AND _id=%d"
#define UPDATE_PLAYLIST_ORDER_FROM_PLAYLIST_MAP		"UPDATE "DB_TABLE_PLAYLIST_MAP" SET play_order=%d WHERE playlist_id=%d AND _id=%d"

/* Bookmark */
#define INSERT_BOOKMARK_TO_BOOKMARK	"INSERT INTO "DB_TABLE_BOOKMARK" (media_uuid, marked_time, thumbnail_path) VALUES ('%q', '%d', %Q)"
#define SELECT_BOOKMARK_COUNT_BY_MEDIA_ID	"SELECT COUNT(*) FROM "DB_TABLE_BOOKMARK" WHERE media_uuid='%q'"
#define SELECT_BOOKMARK_LIST_BY_MEDIA_ID	"SELECT * FROM "DB_TABLE_BOOKMARK" WHERE media_uuid='%q'"
#define SELECT_BOOKMARK_LIST_BY_MEDIA_ID_USUAL	"SELECT * FROM "DB_TABLE_BOOKMARK" WHERE media_uuid='%s'"

/* Get Meta */
#define MEDIA_AV_META			"media_uuid, title, album, artist, genre, composer, year, recorded_date, copyright, track_num, bitrate, duration, played_count, last_played_time, last_played_position"
#define MEDIA_IMAGE_META		"media_uuid, width, height, datetaken, orientation"
#define SELECT_IMAGE_FROM_MEDIA	"SELECT "MEDIA_IMAGE_META" FROM "DB_TABLE_MEDIA" WHERE media_uuid='%s'"
#define SELECT_AUDIO_FROM_MEDIA	"SELECT "MEDIA_AV_META", samplerate, channel FROM "DB_TABLE_MEDIA" WHERE media_uuid='%s'"
#define SELECT_VIDEO_FROM_MEDIA	"SELECT "MEDIA_AV_META", width, height FROM "DB_TABLE_MEDIA" WHERE media_uuid='%s'"

/* Update Meta*/
#define UPDATE_AV_META_FROM_MEDIA	"UPDATE "DB_TABLE_MEDIA" SET played_count=%d, last_played_time=%d, last_played_position=%d WHERE media_uuid='%q'"
#define UPDATE_IMAGE_META_FROM_MEDIA	"UPDATE "DB_TABLE_MEDIA" SET orientation=%d WHERE media_uuid='%q'"

/* Get Media list of Group */
//#define MEDIA_INFO_ITEM "media_uuid, path, file_name, media_type, mime_type, size, added_time, modified_time, thumbnail_path, description,
//							rating, favourite, author, provider, content_name, category, location_tag, age_rating, is_drm, storage_type"
#define MEDIA_INFO_ITEM "media_uuid, path, file_name, media_type, mime_type, size, added_time, modified_time, thumbnail_path, description, \
							rating, favourite, author, provider, content_name, category, location_tag, age_rating, keyword, is_drm, storage_type, longitude, latitude, altitude, width, height, datetaken, orientation, title, album, artist, genre, composer, year, recorded_date, copyright, track_num, bitrate, duration, played_count, last_played_time, last_played_position, samplerate, channel"

#define SELECT_MEDIA_ITEM 					"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1"
#define SELECT_MEDIA_FROM_MEDIA			"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND media_uuid='%s'"
#define SELECT_MEDIA_BY_PATH				"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND path='%q'"
#define SELECT_MEDIA_FROM_ALBUM			"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND album_id=%d"
#define SELECT_MEDIA_FROM_ARTIST			"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND artist='%q'"
#define SELECT_MEDIA_FROM_GENRE			"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND genre='%q'"
#define SELECT_MEDIA_FROM_COMPOSER		"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND author='%q'"
#define SELECT_MEDIA_FROM_YEAR			"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND year='%q'"
#define SELECT_MEDIA_FROM_GROUP			"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND %s='%q'"
#define SELECT_MEDIA_FROM_GROUP_NULL	"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND %s IS NULL"
#define SELECT_MEDIA_FROM_FOLDER			"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE validity=1 AND folder_uuid='%q'"
#define SELECT_MEDIA_FROM_TAG				"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE media_uuid IN (SELECT media_uuid FROM "DB_TABLE_TAG_MAP" WHERE tag_id=%d) AND validity=1"
#define SELECT_MEDIA_FROM_PLAYLIST		"SELECT "MEDIA_INFO_ITEM" FROM "DB_TABLE_MEDIA" WHERE media_uuid IN (SELECT media_uuid FROM "DB_TABLE_PLAYLIST_MAP" WHERE playlist_id=%d) AND validity=1"

/* Delete */
#define DELETE_MEDIA_FROM_MEDIA				"DELETE FROM "DB_TABLE_MEDIA" WHERE media_uuid='%q'"
#define DELETE_FOLDER_FROM_FOLDER			"DELETE FROM "DB_TABLE_FOLDER" WHERE folder_uuid='%q'"
#define DELETE_PLAYLIST_FROM_PLAYLIST			"DELETE FROM "DB_TABLE_PLAYLIST" WHERE playlist_id=%d"
#define DELETE_TAG_FROM_TAG					"DELETE FROM "DB_TABLE_TAG" WHERE tag_id=%d"
#define DELETE_BOOKMARK_FROM_BOOKMARK		"DELETE FROM "DB_TABLE_BOOKMARK" WHERE bookmark_id=%d"


/**
 *@internal
 */
int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query);

/**
 *@internal
 */
int _content_error_capi(int type, int cotent_error);

/**
 *@internal
 */
int _content_query_sql(char *query_str);

/**
 *@internal
 */
MediaSvcHandle* _content_get_db_handle(void);

/**
 *@internal
 */
attribute_h _content_get_attirbute_handle(void);

/**
 *@internal
 */
attribute_h _content_get_alias_attirbute_handle(void);

/**
 *@internal
 */
void _media_info_item_get_detail(sqlite3_stmt *stmt, media_info_h media);

/**
 *@internal
 */
int _media_db_get_group_count(filter_h filter, group_list_e group_type, int *group_count);

/**
 *@internal
 */
int _media_db_get_media_group_count(media_group_e group, filter_h filter, int *group_count);

/**
 *@internal
 */
int _media_db_get_media_group(media_group_e group, filter_h filter, media_group_cb callback, void *user_data);

/**
 *@internal
 */
int _media_db_get_album(filter_h filter, media_album_cb callback, void *user_data);

/**
 *@internal
 */
int _media_db_get_folder(filter_h filter, media_folder_cb callback, void *user_data);

/**
 *@internal
 */
int _media_db_get_playlist(filter_h filter, media_playlist_cb callback, void *user_data);

/**
 *@internal
 */
int _media_db_get_playlist_item(int playlist_id, filter_h filter, playlist_member_cb callback, void *user_data);

/**
 *@internal
 */
int _media_db_get_tag(const char *media_id, filter_h filter, media_tag_cb callback, void *user_data);

/**
 *@internal
 */
int _media_db_get_bookmark(const char *media_id, filter_h filter, media_bookmark_cb callback, void *user_data);

/**
 *@internal
 */
int _media_db_get_group_item_count_by_id(int group_id, filter_h filter, group_list_e group_type, int *item_count);

/**
 *@internal
 */
int _media_db_get_group_item_count(const char *group_name, filter_h filter, group_list_e group_type, int *item_count);

/**
 *@internal
 */
int _media_db_get_group_item_by_id(int group_id, filter_h filter, media_info_cb callback, void *user_data, group_list_e group_type);

/**
 *@internal
 */
int _media_db_get_group_item(const char *group_name, filter_h filter, media_info_cb callback, void *user_data, group_list_e group_type);

/**
 *@internal
 */
int _media_db_get_media_group_item_count(const char *group_name, media_group_e group, filter_h filter, int *item_count);

/**
 *@internal
 */
int _media_db_get_media_group_item(const char *group_name, media_group_e group, filter_h filter, media_info_cb callback, void *user_data);

/**
 * @brief Creates a media filter attribute handle.
 * @details This function creates a media filter attribute handle. The handle can be
 * used to convert to attributes of database from attributes of user.
 * @remarks The @a handle must be released with media_filter_attribute_destory() by you.
 * @param[out] filter A handle to media filter attribute
 * @return 0 on success, otherwise a negative error value.
 * @retval #MEDIA_CONTENT_ERROR_NONE Successful
 * @retval #MEDIA_CONTENT_ERROR_INVALID_PARAMETER Invalid parameter
 * @retval #MEDIA_CONTENT_ERROR_OUT_OF_MEMORY Out of memory
 * @see media_filter_attribute_destory()
 *
 */
int _media_filter_attribute_create(attribute_h *attr);

/**
 * @brief Add the attributes to the handle.
 * @details This function add the attribute to handle.
 * @param[in] filter The handle to media filter attribute
 * @param[in] user_attr The user attribute
 * @param[in] platform_attr The platform attribute
 * @return 0 on success, otherwise a negative error value.
 * @retval #MEDIA_CONTENT_ERROR_NONE Successful
 * @retval #MEDIA_CONTENT_ERROR_INVALID_PARAMETER Invalid parameter
 * @retval #MEDIA_CONTENT_ERROR_OUT_OF_MEMORY Out of memory
 * @see media_filter_attribute_remove()
 *
 */
int _media_filter_attribute_add(attribute_h atrr, char *user_attr, char *platform_attr);

/**
 * @brief Destroys a media filter attribute handle.
 * @details The function frees all resources related to the media filter attribute handle. The filter attribute
 * handle no longer can be used to perform any operation. A new handle
 * has to be created before the next usage.
 *
 * @param[in] filter The handle to media filter attribute
 * @return 0 on success, otherwise a negative error value.
 * @retval #MEDIA_CONTENT_ERROR_NONE Successful
 * @retval #MEDIA_CONTENT_ERROR_INVALID_PARAMETER Invalid parameter
 * @see media_filter_create()
 *
 */
int _media_filter_attribute_destory(attribute_h attr);

/**
 * @brief Replace to platform attributes from user attributes.
 * @details This function replace to platform attributes from user attributes to generate the WHERE clause
 * @param[in] filter The handle to media filter attribute
 * @param[in] user_attr The user attribute
 * @param[in] platform_attr The platform attribute
 * @return 0 on success, otherwise a negative error value.
 * @retval #MEDIA_CONTENT_ERROR_NONE Successful
 * @retval #MEDIA_CONTENT_ERROR_INVALID_PARAMETER Invalid parameter
 * @retval #MEDIA_CONTENT_ERROR_OUT_OF_MEMORY Out of memory
 * @see media_filter_attribute_create()
 * @see media_filter_attribute_destory()
 *
 */
int _media_filter_attribute_generate(attribute_h attr, char *condition, media_content_collation_e collate_type, char **generated_condition);
int _media_filter_attribute_option_generate(attribute_h attr, filter_h filter, char **generated_option);

#define media_content_retv_if(expr, val) do { \
			if(expr) { \
				LOGE("[%s-%d]", __FUNCTION__, __LINE__);    \
				return (val); \
			} \
		} while (0)

#define media_content_debug(fmt, arg...) do { \
			LOGD("[%s-%d]"fmt"", __FUNCTION__, __LINE__,##arg);     \
		} while (0)

#define media_content_error(fmt, arg...) do { \
			LOGE("[%s-%d]"fmt"", __FUNCTION__, __LINE__,##arg);     \
		} while (0)

#define media_content_debug_func() do { \
			LOGD("[%s-%d]", __FUNCTION__, __LINE__);     \
		} while (0)

#ifdef __cplusplus
}
#endif /* __cplusplus */
#endif /*__TIZEN_MEDIA_INFO_PRIVATE_H__*/