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