src/include/util/media-thumb-db.h

   1 /*
   2  * libmedia-thumbnail
   3  *
   4  * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved.
   5  *
   6  * Contact: Hyunjun Ko <zzoon.ko@samsung.com>
   7  *
   8  * Licensed under the Apache License, Version 2.0 (the "License");
   9  * you may not use this file except in compliance with the License.
  10  * You may obtain a copy of the License at
  11  *
  12  * http://www.apache.org/licenses/LICENSE-2.0
  13  *
  14  * Unless required by applicable law or agreed to in writing, software
  15  * distributed under the License is distributed on an "AS IS" BASIS,
  16  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  17  * See the License for the specific language governing permissions and
  18  * limitations under the License.
  19  *
  20  */
  21
  22 #include <sqlite3.h>
  23 #include <media-util.h>
  24
  25 #ifndef _MEDIA_THUMB_DB_H_
  26 #define _MEDIA_THUMB_DB_H_
  27
  28 #define STRING_VALID(str)       \
  29         ((str != NULL && strlen(str) > 0) ? TRUE : FALSE)
  30
  31 #define SELECT_PATH_FROM_UNEXTRACTED_THUMB_MEDIA "SELECT path from media where thumbnail_path is null and validity=1 and (media_type=0 or media_type=1);"
  32 #define SELECT_PATH_FROM_UNEXTRACTED_THUMB_INTERNAL_MEDIA "SELECT path from media where thumbnail_path is null and validity=1 and (media_type=0 or media_type=1) and storage_type=0;"
  33 #define SELECT_MEDIA_BY_PATH "SELECT thumbnail_path FROM media WHERE path='%q';"
  34 #define SELECT_TYPE_BY_PATH "SELECT media_type FROM media WHERE path='%q';"
  35 #define SELECT_WH_BY_PATH "SELECT width, height FROM media WHERE path='%q';"
  36 #define UPDATE_THUMB_BY_PATH "UPDATE media SET thumbnail_path = '%q' WHERE path='%q';"
  37 #define UPDATE_WH_BY_PATH "UPDATE media SET width=%d,height=%d WHERE path='%q';"
  38 #define UPDATE_THUMB_WH_BY_PATH "UPDATE media SET thumbnail_path = '%q', width=%d,height=%d WHERE path='%q';"
  39
  40 sqlite3 *_media_thumb_db_get_handle();
  41
  42 int _media_thumb_db_connect(uid_t uid);
  43
  44 int _media_thumb_db_disconnect();
  45
  46 int _media_thumb_get_thumb_from_db_with_size(const char *origin_path,
  47                                                                 char *thumb_path,
  48                                                                 int max_length,
  49                                                                 int *need_update_db,
  50                                                                 int *width,
  51                                                                 int *height);
  52
  53 int _media_thumb_update_db(const char *origin_path,
  54                                                                         char *thumb_path,
  55                                                                         int width,
  56                                                                         int height,
  57                                                                         uid_t uid);
  58
  59 #endif /*_MEDIA_THUMB_DB_H_*/
  60