3 # Copyright 2008 BibLibre
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 #use warnings; FIXME - Bug 2505
26 use vars qw(@ISA @EXPORT);
31 # only export API methods
40 # Returns all informations about a given csv profile
43 my $dbh = C4::Context->dbh;
44 my $query = "SELECT * FROM export_format WHERE export_format_id=?";
46 $sth = $dbh->prepare($query);
49 return ($sth->fetchrow_hashref);
52 # Returns id of csv profile about a given csv profile name
55 my $dbh = C4::Context->dbh;
56 my $query = "SELECT export_format_id FROM export_format WHERE profile=?";
58 $sth = $dbh->prepare($query);
61 return ( $sth->fetchrow );
64 # Returns fields to extract for the given csv profile
65 sub GetMarcFieldsForCsv {
68 my $dbh = C4::Context->dbh;
69 my $query = "SELECT content FROM export_format WHERE export_format_id=?";
71 $sth = $dbh->prepare($query);
74 return ($sth->fetchrow_hashref)->{content};