extensions/sqlite/driver/SqResults.h
author David Anderson <dvander@alliedmods.net>
Sun Jul 29 01:29:27 2007 +0000 (2007-07-29)
changeset 1206 538a33346fad
parent 1203 633c25ce6405
child 1226 478550a4d5ec
permissions -rw-r--r--
import of linux sqlite build
dvander@1203
     1
/**
dvander@1203
     2
 * vim: set ts=4 :
dvander@1203
     3
 * ===============================================================
dvander@1203
     4
 * SourceMod SQLite Driver Extension
dvander@1203
     5
 * Copyright (C) 2004-2007 AlliedModders LLC. All rights reserved.
dvander@1203
     6
 * ===============================================================
dvander@1203
     7
 *
dvander@1203
     8
 * This program is free software; you can redistribute it and/or
dvander@1203
     9
 * modify it under the terms of the GNU General Public License
dvander@1203
    10
 * as published by the Free Software Foundation; either version 2
dvander@1203
    11
 * of the License, or (at your option) any later version.
dvander@1203
    12
 * This program is distributed in the hope that it will be useful,
dvander@1203
    13
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
dvander@1203
    14
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
dvander@1203
    15
 * GNU General Public License for more details.
dvander@1203
    16
 * 
dvander@1203
    17
 * You should have received a copy of the GNU General Public License
dvander@1203
    18
 * along with this program; if not, write to the Free Software
dvander@1203
    19
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
dvander@1203
    20
 *
dvander@1203
    21
 * Version: $Id$
dvander@1203
    22
 */
dvander@1203
    23
dvander@1203
    24
#ifndef _INCLUDE_SQLITE_SOURCEMOD_RESULT_SET_H_
dvander@1203
    25
#define _INCLUDE_SQLITE_SOURCEMOD_RESULT_SET_H_
dvander@1203
    26
dvander@1203
    27
#include "SqDriver.h"
dvander@1203
    28
#include "sm_memtable.h"
dvander@1203
    29
dvander@1203
    30
class SqQuery;
dvander@1203
    31
dvander@1203
    32
struct SqField
dvander@1203
    33
{
dvander@1203
    34
	int type;
dvander@1203
    35
	union
dvander@1203
    36
	{
dvander@1203
    37
		int idx;
dvander@1203
    38
		float f;
dvander@1203
    39
	} u;
dvander@1203
    40
	size_t size;
dvander@1203
    41
};
dvander@1203
    42
dvander@1203
    43
class SqResults : 
dvander@1203
    44
	public IResultSet,
dvander@1203
    45
	public IResultRow
dvander@1203
    46
{
dvander@1203
    47
	friend class SqQuery;
dvander@1203
    48
public:
dvander@1203
    49
	SqResults(SqQuery *query);
dvander@1203
    50
	~SqResults();
dvander@1203
    51
public: //IResultSet
dvander@1203
    52
	unsigned int GetRowCount();
dvander@1203
    53
	unsigned int GetFieldCount();
dvander@1203
    54
	const char *FieldNumToName(unsigned int columnId);
dvander@1203
    55
	bool FieldNameToNum(const char *name, unsigned int *columnId);
dvander@1203
    56
	bool MoreRows();
dvander@1203
    57
	IResultRow *FetchRow();
dvander@1203
    58
	IResultRow *CurrentRow();
dvander@1203
    59
	bool Rewind();
dvander@1203
    60
	DBType GetFieldType(unsigned int field);
dvander@1203
    61
	DBType GetFieldDataType(unsigned int field);
dvander@1203
    62
public: //IResultRow
dvander@1203
    63
	DBResult GetString(unsigned int columnId, const char **pString, size_t *length);
dvander@1203
    64
	DBResult CopyString(unsigned int columnId, 
dvander@1203
    65
		char *buffer, 
dvander@1203
    66
		size_t maxlength, 
dvander@1203
    67
		size_t *written);
dvander@1203
    68
	DBResult GetFloat(unsigned int columnId, float *pFloat);
dvander@1203
    69
	DBResult GetInt(unsigned int columnId, int *pInt);
dvander@1203
    70
	bool IsNull(unsigned int columnId);
dvander@1203
    71
	size_t GetDataSize(unsigned int columnId);
dvander@1203
    72
	DBResult GetBlob(unsigned int columnId, const void **pData, size_t *length);
dvander@1203
    73
	DBResult CopyBlob(unsigned int columnId, void *buffer, size_t maxlength, size_t *written);
dvander@1203
    74
public:
dvander@1203
    75
	void ResetResultCount();
dvander@1203
    76
	void PushResult();
dvander@1203
    77
private:
dvander@1203
    78
	SqField *GetField(unsigned int col);
dvander@1203
    79
private:
dvander@1203
    80
	sqlite3_stmt *m_pStmt;		/** DOES NOT CHANGE */
dvander@1203
    81
	String *m_ColNames;			/** DOES NOT CHANGE */
dvander@1203
    82
	unsigned int m_ColCount;	/** DOES NOT CHANGE */
dvander@1206
    83
	BaseStringTable m_Strings;	/** DOES NOT CHANGE */
dvander@1206
    84
	BaseMemTable *m_pMemory;	/** DOES NOT CHANGE */
dvander@1203
    85
	unsigned int m_RowCount;
dvander@1203
    86
	unsigned int m_MaxRows;
dvander@1203
    87
	SqField *m_Rows;
dvander@1203
    88
	unsigned int m_CurRow;
dvander@1203
    89
	unsigned int m_NextRow;
dvander@1203
    90
};
dvander@1203
    91
dvander@1203
    92
#endif //_INCLUDE_SQLITE_SOURCEMOD_RESULT_SET_H_