/*
 * libmedia-thumbnail
 *
 * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved.
 *
 * Contact: Hyunjun Ko <zzoon.ko@samsung.com>
 *
 * 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.
 *
 */

#include "media-thumb-db.h"
#include "media-thumb-util.h"
#include "media-thumb-debug.h"

#include <glib.h>
#include <string.h>
#include <unistd.h>

static __thread MediaDBHandle *db_handle;

sqlite3 *_media_thumb_db_get_handle()
{
	return db_handle;
}

int _media_thumb_db_connect(uid_t uid)
{
	int err = MS_MEDIA_ERR_NONE;

	err = media_db_connect(&db_handle, uid, FALSE);
	if (err != MS_MEDIA_ERR_NONE) {
		thumb_err("media_db_connect failed: %d", err);
		db_handle = NULL;
		return err;
	}

	return MS_MEDIA_ERR_NONE;
}

int _media_thumb_db_disconnect()
{
	int err = MS_MEDIA_ERR_NONE;

	err = media_db_disconnect(db_handle);
	if (err != MS_MEDIA_ERR_NONE) {
		thumb_err("media_db_disconnect failed: %d", err);
	}

	db_handle = NULL;
	return err;
}

int _media_thumb_get_thumb_from_db_with_size(const char *origin_path, char *thumb_path, int max_length, int *width, int *height)
{
	int err = MS_MEDIA_ERR_NONE;
	char *query_string = NULL;
	sqlite3_stmt *stmt = NULL;

	thumb_retvm_if(db_handle == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "DB handle is NULL");
	thumb_retvm_if(!STRING_VALID(origin_path), MS_MEDIA_ERR_INVALID_PARAMETER, "Invalid origin_path");

	query_string = sqlite3_mprintf(SELECT_THUMB_BY_PATH, origin_path);
	thumb_retvm_if(!STRING_VALID(query_string), MS_MEDIA_ERR_OUT_OF_MEMORY, "Memory allocation is failed");
	thumb_dbg_slog("Query: %s", query_string);

	err = sqlite3_prepare_v2(db_handle, query_string, strlen(query_string), &stmt, NULL);
	SQLITE3_SAFE_FREE(query_string);
	thumb_retvm_if(SQLITE_OK != err, MS_MEDIA_ERR_DB_INTERNAL, "prepare error [%s]", sqlite3_errmsg(db_handle));

	if (sqlite3_step(stmt) == SQLITE_ROW) {
		strncpy(thumb_path, (const char *)sqlite3_column_text(stmt, 0), max_length);
		*width = sqlite3_column_int(stmt, 1);
		*height = sqlite3_column_int(stmt, 2);
	} else {
		thumb_err("end of row [%s]", sqlite3_errmsg(db_handle));
		SQLITE3_FINALIZE(stmt);
		return MS_MEDIA_ERR_DB_INTERNAL;
	}

	SQLITE3_FINALIZE(stmt);

	thumb_retvm_if(!g_file_test(thumb_path, G_FILE_TEST_EXISTS), MS_MEDIA_ERR_INTERNAL, "thumb path doesn't exist in file system");

	return MS_MEDIA_ERR_NONE;
}

int _media_thumb_update_db(const char *origin_path, char *thumb_path, int width, int height, uid_t uid)
{
	int err = MS_MEDIA_ERR_NONE;
	char *query_string = NULL;

	thumb_retvm_if(!STRING_VALID(origin_path), MS_MEDIA_ERR_INVALID_PARAMETER, "Invalid origin_path");

	if (width > 0 && height > 0)
		query_string = sqlite3_mprintf(UPDATE_THUMB_WH_BY_PATH, thumb_path, width, height, origin_path);
	else
		query_string = sqlite3_mprintf(UPDATE_THUMB_BY_PATH, thumb_path, origin_path);

	thumb_retvm_if(!STRING_VALID(query_string), MS_MEDIA_ERR_OUT_OF_MEMORY, "Memory allocation is failed");

	err = media_db_request_update_db(query_string, uid);
	SQLITE3_SAFE_FREE(query_string);

	return err;
}