src/shared/Database/QueryResultMysql.cpp

   1 /*
   2  * Copyright (C) 2005-2009 MaNGOS <http://getmangos.com/>
   3  *
   4  * This program is free software; you can redistribute it and/or modify
   5  * it under the terms of the GNU General Public License as published by
   6  * the Free Software Foundation; either version 2 of the License, or
   7  * (at your option) any later version.
   8  *
   9  * This program is distributed in the hope that it will be useful,
  10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  * GNU General Public License for more details.
  13  *
  14  * You should have received a copy of the GNU General Public License
  15  * along with this program; if not, write to the Free Software
  16  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  17  */
  18
  19 #ifndef DO_POSTGRESQL
  20
  21 #include "DatabaseEnv.h"
  22
  23 QueryResultMysql::QueryResultMysql(MYSQL_RES *result, MYSQL_FIELD *fields, uint64 rowCount, uint32 fieldCount) :
  24     QueryResult(rowCount, fieldCount), mResult(result)
  25 {
  26
  27     mCurrentRow = new Field[mFieldCount];
  28     ASSERT(mCurrentRow);
  29
  30     for (uint32 i = 0; i < mFieldCount; i++)
  31         mCurrentRow[i].SetType(ConvertNativeType(fields[i].type));
  32 }
  33
  34 QueryResultMysql::~QueryResultMysql()
  35 {
  36     EndQuery();
  37 }
  38
  39 bool QueryResultMysql::NextRow()
  40 {
  41     MYSQL_ROW row;
  42
  43     if (!mResult)
  44         return false;
  45
  46     row = mysql_fetch_row(mResult);
  47     if (!row)
  48     {
  49         EndQuery();
  50         return false;
  51     }
  52
  53     for (uint32 i = 0; i < mFieldCount; i++)
  54         mCurrentRow[i].SetValue(row[i]);
  55
  56     return true;
  57 }
  58
  59 void QueryResultMysql::EndQuery()
  60 {
  61     if (mCurrentRow)
  62     {
  63         delete [] mCurrentRow;
  64         mCurrentRow = 0;
  65     }
  66
  67     if (mResult)
  68     {
  69         mysql_free_result(mResult);
  70         mResult = 0;
  71     }
  72 }
  73
  74 enum Field::DataTypes QueryResultMysql::ConvertNativeType(enum_field_types mysqlType) const
  75 {
  76     switch (mysqlType)
  77     {
  78         case FIELD_TYPE_TIMESTAMP:
  79         case FIELD_TYPE_DATE:
  80         case FIELD_TYPE_TIME:
  81         case FIELD_TYPE_DATETIME:
  82         case FIELD_TYPE_YEAR:
  83         case FIELD_TYPE_STRING:
  84         case FIELD_TYPE_VAR_STRING:
  85         case FIELD_TYPE_BLOB:
  86         case FIELD_TYPE_SET:
  87         case FIELD_TYPE_NULL:
  88             return Field::DB_TYPE_STRING;
  89         case FIELD_TYPE_TINY:
  90
  91         case FIELD_TYPE_SHORT:
  92         case FIELD_TYPE_LONG:
  93         case FIELD_TYPE_INT24:
  94         case FIELD_TYPE_LONGLONG:
  95         case FIELD_TYPE_ENUM:
  96             return Field::DB_TYPE_INTEGER;
  97         case FIELD_TYPE_DECIMAL:
  98         case FIELD_TYPE_FLOAT:
  99         case FIELD_TYPE_DOUBLE:
 100             return Field::DB_TYPE_FLOAT;
 101         default:
 102             return Field::DB_TYPE_UNKNOWN;
 103     }
 104 }
 105 #endif