/sqlite3cc

To get this branch, use:
bzr branch http://bzr.ed.am/sqlite3cc
1 by edam
- initial commit
1
/*
2 by edam
- further initial development
2
 * database.cc
1 by edam
- initial commit
3
 *
4
 * Copyright (C) 2009 Tim Marston <edam@waxworlds.org>
5
 *
2 by edam
- further initial development
6
 * This file is part of sqlite3cc (hereafter referred to as "this program").
7
 * See http://www.waxworlds.org/edam/software/sqlite3cc for more information.
1 by edam
- initial commit
8
 *
9
 * This program is free software: you can redistribute it and/or modify
10
 * it under the terms of the GNU Lesser General Public License as published
11
 * by the Free Software Foundation, either version 3 of the License, or
12
 * (at your option) any later version.
13
 *
14
 * This program is distributed in the hope that it will be useful,
15
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17
 * GNU Lesser General Public License for more details.
18
 *
19
 * You should have received a copy of the GNU Lesser General Public License
20
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
21
 */
22
2 by edam
- further initial development
23
#include <sqlite3cc/database.h>
24
#include <sqlite3cc/exception.h>
1 by edam
- initial commit
25
26
27
sqlite::database::database(
28
	const std::string &filename )
29
	:
30
	_handle( NULL )
31
{
13 by edam
- made basic_statement::step() protected, for use by query and command only
32
	int code = open( filename );
33
	if( code != SQLITE_OK ) throw sqlite_error( *this, code );
1 by edam
- initial commit
34
}
35
36
37
sqlite::database::database()
38
	:
39
	_handle( NULL )
40
{
41
}
42
43
9 by edam
- added NEWS
44
sqlite::database::~database()
1 by edam
- initial commit
45
{
46
	close();
47
}
48
49
50
int sqlite::database::open(
51
	const std::string &filename,
52
	int flags )
53
{
54
	close();
55
	return sqlite3_open_v2( filename.c_str(), &_handle, flags, NULL );
56
}
57
58
59
void sqlite::database::close()
60
{
61
	if( _handle ) {
62
		sqlite3_close( _handle );
63
		_handle = NULL;
64
	}
65
}
66
67
10 by edam
- cleaned up test-main
68
void sqlite::database::exec(
1 by edam
- initial commit
69
	const std::string &sql )
70
{
10 by edam
- cleaned up test-main
71
	int code = sqlite3_exec( _handle, sql.c_str(), NULL, NULL, NULL );
13 by edam
- made basic_statement::step() protected, for use by query and command only
72
	if( code ) throw sqlite_error( *this, code );
1 by edam
- initial commit
73
}
74
75
76
int sqlite::database::busy_timeout(
77
	int duration )
78
{
79
	return sqlite3_busy_timeout( _handle, duration );
80
}
13 by edam
- made basic_statement::step() protected, for use by query and command only
81
82
83
sqlite::database::database_mutex_guard::database_mutex_guard(
84
	database &database )
85
	:
86
	_mutex( sqlite3_db_mutex( database._handle ) )
87
{
88
	if( _mutex ) sqlite3_mutex_enter( _mutex );
89
}
90
91
92
sqlite::database::database_mutex_guard::~database_mutex_guard()
93
{
94
	leave();
95
}
96
97
void sqlite::database::database_mutex_guard::leave()
98
{
99
	if( _mutex ) {
100
		sqlite3_mutex_leave( _mutex );
101
		_mutex = NULL;
102
	}
103
}