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