extensions/sqlite/driver/SqQuery.h
author Ruben Gonzalez <drifter01620@gmail.com>
Thu May 22 09:49:27 2014 -0400 (2014-05-22)
changeset 4378 568f4497ef4a
parent 4040 b6924c1a1d71
permissions -rw-r--r--
Update CS:GO team score gamedata.
     1 /**
     2  * vim: set ts=4 sw=4 tw=99 noet :
     3  * =============================================================================
     4  * SourceMod SQLite Extension
     5  * Copyright (C) 2004-2008 AlliedModders LLC.  All rights reserved.
     6  * =============================================================================
     7  *
     8  * This program is free software; you can redistribute it and/or modify it under
     9  * the terms of the GNU General Public License, version 3.0, as published by the
    10  * Free Software Foundation.
    11  * 
    12  * This program is distributed in the hope that it will be useful, but WITHOUT
    13  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
    14  * FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
    15  * details.
    16  *
    17  * You should have received a copy of the GNU General Public License along with
    18  * this program.  If not, see <http://www.gnu.org/licenses/>.
    19  *
    20  * As a special exception, AlliedModders LLC gives you permission to link the
    21  * code of this program (as well as its derivative works) to "Half-Life 2," the
    22  * "Source Engine," the "SourcePawn JIT," and any Game MODs that run on software
    23  * by the Valve Corporation.  You must obey the GNU General Public License in
    24  * all respects for all other code used.  Additionally, AlliedModders LLC grants
    25  * this exception to all derivative works.  AlliedModders LLC defines further
    26  * exceptions, found in LICENSE.txt (as of this writing, version JULY-31-2007),
    27  * or <http://www.sourcemod.net/license.php>.
    28  *
    29  * Version: $Id$
    30  */
    31 
    32 #ifndef _INCLUDE_SQLITE_SOURCEMOD_QUERY_H_
    33 #define _INCLUDE_SQLITE_SOURCEMOD_QUERY_H_
    34 
    35 #include <am-refcounting.h>
    36 #include "SqDatabase.h"
    37 #include "SqResults.h"
    38 
    39 class SqQuery : 
    40 	public IPreparedQuery
    41 {
    42 public:
    43 	SqQuery(SqDatabase *parent, sqlite3_stmt *stmt);
    44 	~SqQuery();
    45 public: //IQuery
    46 	IResultSet *GetResultSet();
    47 	bool FetchMoreResults();
    48 	void Destroy();
    49 public: //IPreparedQuery
    50 	bool BindParamInt(unsigned int param, int num, bool signd=true);
    51 	bool BindParamFloat(unsigned int param, float f);
    52 	bool BindParamNull(unsigned int param);
    53 	bool BindParamString(unsigned int param, const char *text, bool copy);
    54 	bool BindParamBlob(unsigned int param, const void *data, size_t length, bool copy);
    55 	bool Execute();
    56 	const char *GetError(int *errCode=NULL);
    57 	unsigned int GetAffectedRows();
    58 	unsigned int GetInsertID();
    59 public: //IResultSet
    60 	unsigned int GetRowCount();
    61 	unsigned int GetFieldCount();
    62 	const char *FieldNumToName(unsigned int columnId);
    63 	bool FieldNameToNum(const char *name, unsigned int *columnId);
    64 	bool MoreRows();
    65 	IResultRow *FetchRow();
    66 	IResultRow *CurrentRow();
    67 	bool Rewind();
    68 	DBType GetFieldType(unsigned int field);
    69 	DBType GetFieldDataType(unsigned int field);
    70 public: //IResultRow
    71 	DBResult GetString(unsigned int columnId, const char **pString, size_t *length);
    72 	DBResult CopyString(unsigned int columnId, 
    73 		char *buffer, 
    74 		size_t maxlength, 
    75 		size_t *written);
    76 	DBResult GetFloat(unsigned int columnId, float *pFloat);
    77 	DBResult GetInt(unsigned int columnId, int *pInt);
    78 	bool IsNull(unsigned int columnId);
    79 	size_t GetDataSize(unsigned int columnId);
    80 	DBResult GetBlob(unsigned int columnId, const void **pData, size_t *length);
    81 	DBResult CopyBlob(unsigned int columnId, void *buffer, size_t maxlength, size_t *written);
    82 public:
    83 	sqlite3_stmt *GetStmt();
    84 private:
    85 	ke::Ref<SqDatabase> m_pParent;
    86 	sqlite3_stmt *m_pStmt;
    87 	SqResults *m_pResults;
    88 	unsigned int m_ParamCount;
    89 	String m_LastError;
    90 	int m_LastErrorCode;
    91 	unsigned int m_AffectedRows;
    92 	unsigned int m_InsertID;
    93 	unsigned int m_ColCount;
    94 };
    95 
    96 #endif //_INCLUDE_SQLITE_SOURCEMOD_QUERY_H_