DBresult.h

#pragma once


#include <libutl/BitArray.h>
#include <libutl/DBfield.h>
#include <libutl/Decimal.h>


UTL_NS_BEGIN;


enum db_result_status_t
{
    dbr_ok,             
    dbr_nonfatal_error, 
    dbr_fatal_error,    
    dbr_undefined       
};



class DBresult : public Object
{
    UTL_CLASS_DECL(DBresult, Object);

public:
    void initialize(uint_t numRows, uint_t numFields, DBfield** fields);

    void clear();

    uint_t
    status() const
    {
        return _status;
    }

    uint_t&
    status()
    {
        return _status;
    }

    uint_t
    numRows() const
    {
        return _numRows;
    }

    uint_t
    numFields() const
    {
        return _numFields;
    }

    const DBfield&
    field(uint_t idx) const
    {
        return (const DBfield&)*_fields[idx];
    }

    uint_t
    rowIndex(uint_t rowIdx) const
    {
        ASSERTD(rowIdx < _numRows);
        return (rowIdx * _numFields);
    }

    const uint64_t*
    values() const
    {
        return _values;
    }

    uint64_t*
    values()
    {
        return _values;
    }

    char* getString(uint_t rowIdx, uint_t fieldIdx) const;

    bool getBool(uint_t rowIdx, uint_t fieldIdx) const;

    int getInt32(uint_t rowIdx, uint_t fieldIdx) const;

    int64_t getInt64(uint_t rowIdx, uint_t fieldIdx) const;

    double getDouble(uint_t rowIdx, uint_t fieldIdx) const;

    char* getDecimal(uint_t rowIdx, uint_t fieldIdx) const;

    time_t getDateTime(uint_t rowIdx, uint_t fieldIdx) const;

    bool
    isNull(uint_t rowIdx, uint_t fieldIdx) const
    {
        ASSERTD(rowIdx < _numRows);
        ASSERTD(fieldIdx < _numFields);
        uint_t valueIdx = (rowIdx * _numFields) + fieldIdx;
        return _nullArray.get(valueIdx);
    }

    void
    setNull(uint_t rowIdx, uint_t fieldIdx)
    {
        ASSERTD(rowIdx < _numRows);
        ASSERTD(fieldIdx < _numFields);
        uint_t valueIdx = (rowIdx * _numFields) + fieldIdx;
        _nullArray.set(valueIdx, 1);
    }

    const BitArray&
    nullArray() const
    {
        return _nullArray;
    }

    const String&
    errorMsg() const
    {
        return _errorMsg;
    }

    String&
    errorMsg()
    {
        return _errorMsg;
    }

private:
    void init();
    void deInit();

private:
    uint_t _status;
    uint_t _numRows;
    uint_t _numFields;
    String _errorMsg;

    DBfield** _fields;
    uint64_t* _values;
    size_t _valuesSize;
    BitArray _nullArray;
};


UTL_NS_END;