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

commiting public release

/* 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).