Daniel@0: /* Part of DML (Digital Music Laboratory)
Daniel@0: 	Copyright 2014-2015 Samer Abdallah, University of London
Daniel@0: 	 
Daniel@0: 	This program is free software; you can redistribute it and/or
Daniel@0: 	modify it under the terms of the GNU General Public License
Daniel@0: 	as published by the Free Software Foundation; either version 2
Daniel@0: 	of the License, or (at your option) any later version.
Daniel@0: 
Daniel@0: 	This program is distributed in the hope that it will be useful,
Daniel@0: 	but WITHOUT ANY WARRANTY; without even the implied warranty of
Daniel@0: 	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
Daniel@0: 	GNU General Public License for more details.
Daniel@0: 
Daniel@0: 	You should have received a copy of the GNU General Public
Daniel@0: 	License along with this library; if not, write to the Free Software
Daniel@0: 	Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
Daniel@0: */
Daniel@0: 
Daniel@0: :- module(odbcutils, [with_odbc/2, qsql/4]).
Daniel@0: 
Daniel@0: :- meta_predicate with_odbc(+,0).
Daniel@0: :- use_module(library(odbc)).
Daniel@0: 
Daniel@0: with_odbc(DBName,Goal) :- 
Daniel@0:    setup_call_cleanup(
Daniel@0:       odbc_connect(DBName,_,[alias(DBName)]), Goal,
Daniel@0:       odbc_disconnect(DBName)).
Daniel@0: 
Daniel@0: qsql(DB,Fmt,Args,Result) :- !, 
Daniel@0:    format(string(Q),Fmt,Args),
Daniel@0:    debug(odbcutils,'SQL query: ~s',[Q]),
Daniel@0:    odbc_query(DB,Q,Result).