From c3853f6dd796615f332fefcaaaf563794d867ee4 Mon Sep 17 00:00:00 2001 From: Richard Knight Date: Tue, 17 Mar 2020 18:47:36 +0000 Subject: initial --- include/postgresql.h | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 include/postgresql.h (limited to 'include/postgresql.h') diff --git a/include/postgresql.h b/include/postgresql.h new file mode 100644 index 0000000..d7db5d9 --- /dev/null +++ b/include/postgresql.h @@ -0,0 +1,44 @@ +/* + postgresql.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 POSTGRESQL_H +#define POSTGRESQL_H + +#include +#include +#include "connection.h" + +struct PostgresConnection { + pqxx::connection* conn; + void Init(csnd::Csound* csound, LoginData* login); + void Close(csnd::Csound* csound); + void Exec(char* sql); + pqxx::result Query(char *sql); + MYFLT Scalar(char* sql, int row, int col); + char* ScalarString(char* sql, int row, int col); + void ToArray(pqxx::result 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 /* POSTGRESQL_H */ + -- cgit v1.2.3