sqlite_resultset_metatdata.cpp

Go to the documentation of this file.

#include "wx/database/wxprec.h"

#if wxUSE_DATABASE_SQLITE

/* 
   SPECIAL NOTE:
    The sqlite3_column_* functions are 0-based, but the JDBC wxResultSetMetaData
    functions are 1-based.  To be consistent with the 1-based JDBC (and also
    wxPreparedStatement paramters, we are using a 1-based system here.)
 */

// ctor
wxSqliteResultSetMetaData::wxSqliteResultSetMetaData(sqlite3_stmt* pStmt)
{
  m_pSqliteStatement = pStmt;
}

int wxSqliteResultSetMetaData::GetColumnType(int i)
{
  int returnType = COLUMN_UNKNOWN;
  wxString columnTypeString = ConvertFromUnicodeStream(sqlite3_column_decltype(m_pSqliteStatement, i-1));
  columnTypeString.MakeUpper();
  if (columnTypeString.IsSameAs(_("INTEGER")) || columnTypeString.IsSameAs(_("INT")) || columnTypeString.IsSameAs(_("LONG")))
    returnType = COLUMN_INTEGER;
  else if (columnTypeString.IsSameAs(_("STRING")) || columnTypeString.StartsWith(_("VARCHAR")))
    returnType = COLUMN_STRING;
  else if (columnTypeString.IsSameAs(_("DOUBLE")) || columnTypeString.IsSameAs(_("FLOAT")))
    returnType = COLUMN_DOUBLE;
  else if (columnTypeString.IsSameAs(_("BOOL")))
    returnType = COLUMN_BOOL;
  else if (columnTypeString.IsSameAs(_("BLOB")))
    returnType = COLUMN_BLOB;
  else if (columnTypeString.IsSameAs(_("DATE")) || columnTypeString.IsSameAs(_("DATETIME")) || columnTypeString.IsSameAs(_("TIMESTAMP")))
    returnType = COLUMN_DATE;
  else
    returnType = COLUMN_UNKNOWN;

  if (returnType == COLUMN_UNKNOWN)
  {
    int columnType = sqlite3_column_type(m_pSqliteStatement, i-1);
    switch (columnType)
    {
      case SQLITE_INTEGER:
        puts("sqlite3_column_type returned SQLITE_INTEGER");
        returnType = COLUMN_INTEGER;
        break;
      case SQLITE_FLOAT:
        returnType = COLUMN_DOUBLE;
        break;
      case SQLITE_TEXT:
        returnType = COLUMN_STRING;
        break;
      case SQLITE_BLOB:
        returnType = COLUMN_BLOB;
        break;
      case SQLITE_NULL:
        returnType = COLUMN_NULL;
        break;
      default:
        returnType = COLUMN_UNKNOWN;
        break;
    };
  }

  return returnType;
}

int wxSqliteResultSetMetaData::GetColumnSize(int WXUNUSED(i))
{
  return -1;
}

wxString wxSqliteResultSetMetaData::GetColumnName(int i)
{
  wxString columnName = ConvertFromUnicodeStream(sqlite3_column_name(m_pSqliteStatement, i-1));
  return columnName;
}

int wxSqliteResultSetMetaData::GetColumnCount()
{
  return sqlite3_column_count(m_pSqliteStatement);
}

#endif//wxUSE_DATABASE_SQLITE