diff cpack/dml/lib/odbcutils.pl @ 0:718306e29690 tip

commiting public release

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/cpack/dml/lib/odbcutils.pl	Tue Feb 09 21:05:06 2016 +0100
@@ -0,0 +1,32 @@
+/* Part of DML (Digital Music Laboratory)
+	Copyright 2014-2015 Samer Abdallah, University of London
+	 
+	This program is free software; you can redistribute it and/or
+	modify it under the terms of the GNU General Public License
+	as published by the Free Software Foundation; either version 2
+	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 General Public License for more details.
+
+	You should have received a copy of the GNU General Public
+	License along with this library; if not, write to the Free Software
+	Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
+*/
+
+:- module(odbcutils, [with_odbc/2, qsql/4]).
+
+:- meta_predicate with_odbc(+,0).
+:- use_module(library(odbc)).
+
+with_odbc(DBName,Goal) :- 
+   setup_call_cleanup(
+      odbc_connect(DBName,_,[alias(DBName)]), Goal,
+      odbc_disconnect(DBName)).
+
+qsql(DB,Fmt,Args,Result) :- !, 
+   format(string(Q),Fmt,Args),
+   debug(odbcutils,'SQL query: ~s',[Q]),
+   odbc_query(DB,Q,Result).