libdb/libdb.c

   1 /* -*- Mode: C ; c-basic-offset: 2 -*- */
   2 /*****************************************************************************
   3  *
   4  * $Id: libdb.c,v 1.3 2004/05/02 20:12:11 nedko Exp $
   5  *
   6  * DESCRIPTION:
   7  *  Unified access to database.
   8  *
   9  * AUTHOR:
  10  *  Nedko Arnaudov <nedko@users.sourceforge.net>
  11  *
  12  * LICENSE:
  13  *  GNU GENERAL PUBLIC LICENSE version 2
  14  *
  15  *****************************************************************************/
  16
  17 #include <stdlib.h>
  18 #include <assert.h>
  19
  20 #include "internal.h"
  21 #include "memory.h"
  22
  23 mediadb_result
  24 mediadb_open(
  25   unsigned int nDBType,
  26   const char *pszHost,
  27   const char *pszUser,
  28   const char *pszPass,
  29   const char *pszDB,
  30   mediadb *phDB)
  31 {
  32   mediadb_result r;
  33   mediadb_impl *pImpl;
  34
  35   pImpl = malloc(sizeof(mediadb_impl));
  36   if (pImpl == NULL)
  37   {
  38     r = MEDIADB_MEM;
  39     goto Fail;
  40   }
  41
  42   pImpl->nDBType = nDBType;
  43
  44   if (nDBType == MEDIADB_DBTYPE_MYSQL)
  45   {
  46     r = mediadb_mysql_open(
  47       &pImpl->data.mysql,
  48       pszHost,
  49       pszUser,
  50       pszPass,
  51       pszDB);
  52     if (MEDIADB_IS_ERROR(r))
  53     {
  54       goto FailFreeMem;
  55     }
  56   }
  57   else if (nDBType == MEDIADB_DBTYPE_SQLITE)
  58   {
  59     r = mediadb_sqlite_open(
  60       &pImpl->data.sqlite,
  61       pszHost,
  62       pszUser,
  63       pszPass,
  64       pszDB);
  65     if (MEDIADB_IS_ERROR(r))
  66     {
  67       goto FailFreeMem;
  68     }
  69   }
  70   else
  71   {
  72     r = MEDIADB_NOT_IMPL;
  73     goto FailFreeMem;
  74   }
  75
  76   *phDB = (mediadb)pImpl;
  77
  78   return MEDIADB_OK;
  79
  80 FailFreeMem:
  81   free(pImpl);
  82 Fail:
  83   return r;
  84 }
  85
  86 #define pDB ((mediadb_impl *)hDB)
  87
  88 mediadb_result
  89 mediadb_media_add_new(
  90   mediadb hDB,
  91   const char *pszName,
  92   const char *pszComment,
  93   mediadb_mediatype nType,
  94   mediadb_uint *pnNewMediaID)
  95 {
  96   mediadb_result r;
  97
  98   if (pDB->nDBType == MEDIADB_DBTYPE_MYSQL)
  99   {
 100     r = mediadb_mysql_media_add_new(
 101       &pDB->data.mysql,
 102       pszName,
 103       pszComment,
 104       nType,
 105       pnNewMediaID);
 106   }
 107   else if (pDB->nDBType == MEDIADB_DBTYPE_SQLITE)
 108   {
 109     r = mediadb_sqlite_media_add_new(
 110       &pDB->data.sqlite,
 111       pszName,
 112       pszComment,
 113       nType,
 114       pnNewMediaID);
 115   }
 116   else
 117   {
 118     r = MEDIADB_INVAL_ARG;
 119     assert(0);
 120   }
 121
 122   return r;
 123 }
 124
 125 mediadb_result
 126 mediadb_media_update_properties(
 127   mediadb hDB,
 128   mediadb_uint nMediaID,
 129   mediadb_uint nTimeAdded,
 130   mediadb_uint nTotalFiles,
 131   mediadb_uint nTotalSize)
 132 {
 133   mediadb_result r;
 134
 135   if (pDB->nDBType == MEDIADB_DBTYPE_MYSQL)
 136   {
 137     r = mediadb_mysql_media_update_properties(
 138       &pDB->data.mysql,
 139       nMediaID,
 140       nTimeAdded,
 141       nTotalFiles,
 142       nTotalSize);
 143   }
 144   else if (pDB->nDBType == MEDIADB_DBTYPE_SQLITE)
 145   {
 146     r = mediadb_sqlite_media_update_properties(
 147       &pDB->data.sqlite,
 148       nMediaID,
 149       nTimeAdded,
 150       nTotalFiles,
 151       nTotalSize);
 152   }
 153   else
 154   {
 155     r = MEDIADB_INVAL_ARG;
 156     assert(0);
 157   }
 158
 159   return r;
 160 }
 161
 162 mediadb_result
 163 mediadb_file_add_new(
 164   mediadb hDB,
 165   mediadb_uint nMediaID,
 166   mediadb_filetype Filetype,
 167   const char *pszPath,
 168   const char *pszName,
 169   mediadb_uint nFileSize,
 170   mediadb_uint nFileTime)
 171 {
 172   mediadb_result r;
 173
 174   if (pDB->nDBType == MEDIADB_DBTYPE_MYSQL)
 175   {
 176     r = mediadb_mysql_file_add_new(
 177       &pDB->data.mysql,
 178       nMediaID,
 179       Filetype,
 180       pszPath,
 181       pszName,
 182       nFileSize,
 183       nFileTime);
 184   }
 185   else if (pDB->nDBType == MEDIADB_DBTYPE_SQLITE)
 186   {
 187     r = mediadb_sqlite_file_add_new(
 188       &pDB->data.sqlite,
 189       nMediaID,
 190       Filetype,
 191       pszPath,
 192       pszName,
 193       nFileSize,
 194       nFileTime);
 195   }
 196   else
 197   {
 198     r = MEDIADB_INVAL_ARG;
 199     assert(0);
 200   }
 201
 202   return r;
 203 }
 204
 205 mediadb_result
 206 mediadb_close(
 207   mediadb hDB)
 208 {
 209   mediadb_result r;
 210
 211   if (pDB->nDBType == MEDIADB_DBTYPE_MYSQL)
 212   {
 213     r = mediadb_mysql_close(
 214       &pDB->data.mysql);
 215   }
 216   else if (pDB->nDBType == MEDIADB_DBTYPE_SQLITE)
 217   {
 218     r = mediadb_sqlite_close(
 219       &pDB->data.sqlite);
 220   }
 221   else
 222   {
 223     r = MEDIADB_INVAL_ARG;
 224     assert(0);
 225   }
 226
 227   if (MEDIADB_IS_ERROR(r))
 228   {
 229     return r;
 230   }
 231
 232   free(pDB);
 233
 234   return r;
 235 }
 236
 237 const char *
 238 mediadb_get_error_message(
 239   mediadb hDB)
 240 {
 241   if (pDB->nDBType == MEDIADB_DBTYPE_MYSQL)
 242   {
 243     return mediadb_mysql_get_error_message(&pDB->data.mysql);
 244   }
 245
 246   if (pDB->nDBType == MEDIADB_DBTYPE_SQLITE)
 247   {
 248     return mediadb_sqlite_get_error_message(&pDB->data.sqlite);
 249   }
 250
 251   assert(0);
 252   return "enexpected behaviour";
 253 }
 254
 255 /*****************************************************************************
 256  *
 257  * Modifications log:
 258  *
 259  * !!! WARNING !!! Following lines are automatically updated by the CVS system.
 260  *
 261  *   $Log: libdb.c,v $
 262  *   Revision 1.3  2004/05/02 20:12:11  nedko
 263  *   Improve error dumps.
 264  *
 265  *   Revision 1.2  2004/05/02 13:16:58  nedko
 266  *   Supply filetype when adding new file
 267  *
 268  *   Revision 1.1  2004/04/27 09:12:28  nedko
 269  *   Initial revision.
 270  *
 271  *****************************************************************************/