From c3853f6dd796615f332fefcaaaf563794d867ee4 Mon Sep 17 00:00:00 2001 From: Richard Knight Date: Tue, 17 Mar 2020 18:47:36 +0000 Subject: initial --- include/sqlite.h | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 include/sqlite.h (limited to 'include/sqlite.h') diff --git a/include/sqlite.h b/include/sqlite.h new file mode 100644 index 0000000..4e2b0c3 --- /dev/null +++ b/include/sqlite.h @@ -0,0 +1,44 @@ +/* + sqlite.h + Copyright (C) 2019 Richard Knight + + + This program is free software; you can redistribute it and/or + modify it under the terms of the GNU Lesser General Public + License as published by the Free Software Foundation; either + version 3 of the License, or (at your option) any later version. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + Lesser General Public License for more details. + + You should have received a copy of the GNU Lesser General Public License + along with this program; if not, write to the Free Software Foundation, + Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. + + */ + +#ifndef XSQLITE3_H +#define XSQLITE3_H + +#include +#include +#include "connection.h" + +struct SqliteConnection { + sqlite3* conn; + void Init(csnd::Csound* csound, LoginData* login); + void Close(csnd::Csound* csound); + void Exec(char* sql); + sqlite3_stmt* Query(char *sql); + MYFLT Scalar(char* sql, int row, int col); + char* ScalarString(char* sql, int row, int col); + int RowCount(sqlite3_stmt* stmt); + void ToArray(sqlite3_stmt* result, csnd::Csound* csound, ARRAYDAT* array, bool asString); + void ArrayQuery(char* sql, csnd::Csound* csound, ARRAYDAT* array); + void ArrayQueryString(char* sql, csnd::Csound* csound, ARRAYDAT* array); +}; + +#endif /* SQLITE3_H */ + -- cgit v1.2.3