mmsplugintypedao.cpp

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 #include "mmsconfig/mmsplugintypedao.h"
00034 #include <stdlib.h>
00035 
00036 MMSPluginTypeDAO::MMSPluginTypeDAO(IMMSDB *myConnection) {
00037     MMSPluginTypeDAO::setMMSDBConnection(myConnection);
00038 }
00039 
00040 IMMSDB *MMSPluginTypeDAO::getMMSDBConnection() {
00041     return this->dbConnection;
00042 }
00043 
00044 void MMSPluginTypeDAO::setMMSDBConnection(IMMSDB *connection) {
00045     this->dbConnection = connection;
00046 }
00047 
00048 MMSPluginTypeData *MMSPluginTypeDAO::findTypeByName(string name) {
00049     MMSRecordSet            rs;
00050     MMSPluginTypeData   *type;
00051     /* do query */
00052     this->getMMSDBConnection()->query(
00053         "select * from PluginTypes where PluginTypeName = '" + name + "'", &rs);
00054 
00055     /* check if result is empty */
00056     if (rs.getCount()==0)
00057         return NULL;
00058 
00059     /* create object */
00060     type = new MMSPluginTypeData();
00061     type->setID(atoi(rs["ID"].c_str()));
00062     type->setName(rs["PluginTypeName"]);
00063 
00064     return type;
00065 }
00066 
00067 vector<MMSPluginTypeData *> MMSPluginTypeDAO::findAllTypes() {
00068     MMSRecordSet            rs;
00069     vector<MMSPluginTypeData   *> types;
00070     MMSPluginTypeData   *type;
00071 
00072     /* do query */
00073     this->getMMSDBConnection()->query(
00074         "select * from PluginTypes", &rs);
00075 
00076     /* check if result is empty */
00077     if (rs.getCount()==0)
00078         return types;
00079 
00080     /* create object */
00081     do {
00082 
00083         type = new MMSPluginTypeData;
00084         type->setID(atoi(rs["ID"].c_str()));
00085         type->setName(rs["PluginTypeName"]);
00086         types.push_back(type);
00087 
00088     } while (rs.next());
00089 
00090     return types;
00091 
00092 }