mmsdbsqlite.h

00001 /***************************************************************************
00002  *   Copyright (C) 2005-2007 Stefan Schwarzer, Jens Schneider,             *
00003  *                           Matthias Hardt, Guido Madaus                  *
00004  *                                                                         *
00005  *   Copyright (C) 2007-2008 BerLinux Solutions GbR                        *
00006  *                           Stefan Schwarzer & Guido Madaus               *
00007  *                                                                         *
00008  *   Copyright (C) 2009-2013 BerLinux Solutions GmbH                       *
00009  *                                                                         *
00010  *   Authors:                                                              *
00011  *      Stefan Schwarzer   <stefan.schwarzer@diskohq.org>,                 *
00012  *      Matthias Hardt     <matthias.hardt@diskohq.org>,                   *
00013  *      Jens Schneider     <jens.schneider@diskohq.org>,                   *
00014  *      Guido Madaus       <guido.madaus@diskohq.org>,                     *
00015  *      Patrick Helterhoff <patrick.helterhoff@diskohq.org>,               *
00016  *      René Bählkow       <rene.baehlkow@diskohq.org>                     *
00017  *                                                                         *
00018  *   This library is free software; you can redistribute it and/or         *
00019  *   modify it under the terms of the GNU Lesser General Public            *
00020  *   License version 2.1 as published by the Free Software Foundation.     *
00021  *                                                                         *
00022  *   This library is distributed in the hope that it will be useful,       *
00023  *   but WITHOUT ANY WARRANTY; without even the implied warranty of        *
00024  *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU     *
00025  *   Lesser General Public License for more details.                       *
00026  *                                                                         *
00027  *   You should have received a copy of the GNU Lesser General Public      *
00028  *   License along with this library; if not, write to the                 *
00029  *   Free Software Foundation, Inc.,                                       *
00030  *   51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA            *
00031  **************************************************************************/
00032 
00033 /**
00034  * @file  mmsdbsqlite.h
00035  *
00036  * @brief Header file for sqlite3 database functions.
00037  *
00038  * @author Stefan Schwarzer <stefan.schwarzer@diskohq.org>
00039  * @author Guido Madaus     <guido.madaus@diskohq.org>
00040  * @author Jens Schneider   <pupeider@gmx.de>
00041  *
00042  * @ingroup mmstools
00043  */
00044 #ifndef MMSDBSQLITE3_H_
00045 #define MMSDBSQLITE3_H_
00046 
00047 #ifdef __ENABLE_SQLITE__
00048 
00049 #include "mmstools/mmserror.h"
00050 #include "mmstools/interfaces/immsdb.h"
00051 
00052 #include <sqlite3.h>
00053 
00054 class MMSDBSQLite : public IMMSDB {
00055     private:
00056         sqlite3    *dbhandle;
00057         static int getResults(void *rs, int numCols, char **results, char **columnNames);
00058 
00059     public:
00060         MMSDBSQLite(DataSource *datasource = NULL);
00061         virtual ~MMSDBSQLite();
00062 
00063         void connect();
00064         void disconnect();
00065         void startTransaction();
00066         void commitTransaction();
00067         void rollbackTransaction();
00068         int query(string statement, MMSRecordSet *rs);
00069         int query(string statement);
00070         int getLastInsertedID();
00071 };
00072 
00073 #endif /*__ENABLE_SQLITE__*/
00074 
00075 #endif /*MMSDBSQLITE3_H_*/