extensions/sqlite/driver/SqDatabase.h
author David Anderson <dvander@alliedmods.net>
Sun Jul 29 14:56:24 2007 +0000 (2007-07-29)
changeset 1210 18e60c8737a2
parent 1203 633c25ce6405
child 1226 478550a4d5ec
permissions -rw-r--r--
fixed an sqlite bug where empty results would count as no result set
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_DATABASE_H_
dvander@1203
    25
#define _INCLUDE_SQLITE_SOURCEMOD_DATABASE_H_
dvander@1203
    26
dvander@1203
    27
#include <IThreader.h>
dvander@1203
    28
#include "SqDriver.h"
dvander@1203
    29
dvander@1203
    30
class SqDatabase : public IDatabase
dvander@1203
    31
{
dvander@1203
    32
public:
dvander@1203
    33
	SqDatabase(sqlite3 *sq3, bool persistent);
dvander@1203
    34
	~SqDatabase();
dvander@1203
    35
public:
dvander@1203
    36
	bool Close();
dvander@1203
    37
	const char *GetError(int *errorCode=NULL);
dvander@1203
    38
	bool DoSimpleQuery(const char *query);
dvander@1203
    39
	IQuery *DoQuery(const char *query);
dvander@1203
    40
	IPreparedQuery *PrepareQuery(const char *query, char *error, size_t maxlength, int *errCode=NULL);
dvander@1203
    41
	bool QuoteString(const char *str, char buffer[], size_t maxlen, size_t *newSize);
dvander@1203
    42
	unsigned int GetAffectedRows();
dvander@1203
    43
	unsigned int GetInsertID();
dvander@1203
    44
	bool LockForFullAtomicOperation();
dvander@1203
    45
	void UnlockFromFullAtomicOperation();
dvander@1203
    46
	void IncReferenceCount();
dvander@1203
    47
	IDBDriver *GetDriver();
dvander@1203
    48
public:
dvander@1203
    49
	sqlite3 *GetDb();
dvander@1203
    50
private:
dvander@1203
    51
	sqlite3 *m_sq3;
dvander@1203
    52
	unsigned int m_refcount;
dvander@1203
    53
	IMutex *m_pFullLock;
dvander@1203
    54
	IMutex *m_pRefLock;
dvander@1203
    55
	bool m_Persistent;
dvander@1203
    56
	String m_LastError;
dvander@1203
    57
	int m_LastErrorCode;
dvander@1203
    58
};
dvander@1203
    59
dvander@1203
    60
#endif //_INCLUDE_SQLITE_SOURCEMOD_DATABASE_H_