relpipe/relpipe-tr-sql.cpp: src/Connection.cpp@9441a517fa1f (annotated)

0 c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	1	/**
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	2	* Relational pipes
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	3	* Copyright © 2019 František Kučera (Frantovo.cz, GlobalCode.info)
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	4	*
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	5	* This program is free software: you can redistribute it and/or modify
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	6	* it under the terms of the GNU General Public License as published by
10 7da7173d84b0 fix license version: GNU GPLv3 František Kučera <franta-hg@frantovo.cz> parents: 8 diff changeset	7	* the Free Software Foundation, version 3.
0 c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	8	*
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	9	* This program is distributed in the hope that it will be useful,
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	10	* but WITHOUT ANY WARRANTY; without even the implied warranty of
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	11	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	12	* GNU General Public License for more details.
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	13	*
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	14	* You should have received a copy of the GNU General Public License
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	15	* along with this program. If not, see <http://www.gnu.org/licenses/>.
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	16	*/
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	17
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	18	#include "Connection.h"
0 c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	19
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	20	namespace relpipe {
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	21	namespace tr {
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	22	namespace sql {
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	23
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	24	void Connection::begin() {
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	25	sqlite3_exec(db, "BEGIN", nullptr, nullptr, nullptr);
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	26	}
3 0b932e05aa9f sqlite wrapper objects + execute query František Kučera <franta-hg@frantovo.cz> parents: 1 diff changeset	27
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	28	Connection::Connection(const char* filename) {
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	29	int result = sqlite3_open(filename, &db);
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	30	if (result != SQLITE_OK) {
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	31	sqlite3_close(db);
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	32	throw SqlException(L"Unable to open SQLite database.");
15 0ecde5272f8e process SQL input in the relpipe-in-sql mode František Kučera <franta-hg@frantovo.cz> parents: 14 diff changeset	33	}
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	34	begin();
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	35	}
24 884ece10575d add --type-cast to allow explicit specification of type for given output attributes František Kučera <franta-hg@frantovo.cz> parents: 23 diff changeset	36
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	37	Connection::~Connection() {
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	38	sqlite3_close(db);
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	39	}
14 eacacf060755 add --dump option: allow pass through of relation specified by a regular expression František Kučera <franta-hg@frantovo.cz> parents: 12 diff changeset	40
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	41	PreparedStatement* Connection::prepareStatement(const char* sql) {
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	42	const char* remaining;
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	43	sqlite3_stmt *stmt;
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	44	int result = sqlite3_prepare(db, sql, -1, &stmt, &remaining);
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	45	if (result == SQLITE_OK) return new PreparedStatement(stmt);
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	46	else throw SqlException(L"Unable to prepare SQLite statement.");
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	47	}
12 0b38339b871b improve --keep-file option: default is auto = file will be kept, if it was present before the transformation František Kučera <franta-hg@frantovo.cz> parents: 11 diff changeset	48
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	49	bool Connection::getAutoCommit() {
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	50	return sqlite3_get_autocommit(db);
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	51	}
7 9119b29d1e7c insert records František Kučera <franta-hg@frantovo.cz> parents: 6 diff changeset	52
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	53	void Connection::setAutoCommit(bool autoCommit) {
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	54	bool autoCommitOld = getAutoCommit();
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	55	if (autoCommit && !autoCommitOld) commit();
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	56	else if (!autoCommit && autoCommitOld) begin();
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	57	}
8 3e076cc76c89 data types František Kučera <franta-hg@frantovo.cz> parents: 7 diff changeset	58
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	59	void Connection::commit() {
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	60	sqlite3_exec(db, "COMMIT", nullptr, nullptr, nullptr);
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	61	}
12 0b38339b871b improve --keep-file option: default is auto = file will be kept, if it was present before the transformation František Kučera <franta-hg@frantovo.cz> parents: 11 diff changeset	62
27 9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	63	void Connection::rollback() {
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	64	sqlite3_exec(db, "ROLLBACK", nullptr, nullptr, nullptr);
9441a517fa1f move Connection class to separate .h and .cpp files František Kučera <franta-hg@frantovo.cz> parents: 26 diff changeset	65	}
0 c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	66
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	67	}
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	68	}
c205f5d06418 project skeleton František Kučera <franta-hg@frantovo.cz> parents: diff changeset	69	}

author	František Kučera <franta-hg@frantovo.cz>
	Wed, 25 Dec 2019 01:07:41 +0100
branch	v_0
changeset 27	9441a517fa1f
parent 26	src/SqlHandler.h@49919a60c747
child 29	b0ef1e1dc9c8
permissions	-rw-r--r--