/sqlite3cc

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