3 # This file is part of Koha.
5 # Copyright 2016 Koha Development Team
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>.
28 use Koha::SearchEngine::Elasticsearch;
32 populate_db.pl - Load included sample data into the DB
36 populate_db.pl [--marcflavour MARCFLAVOUR]
39 --help Brief help message
40 --marcflavour m Specify the MARC flavour to use (MARC21|UNIMARC). Defaults
50 Prints a brief help message and exits.
52 =item B<--marcflavour>
54 Lets you choose the desired MARC flavour for the sample data. Valid options are MARC21 and UNIMARC.
55 It defaults to MARC21.
59 Make the output more verbose.
67 my $marcflavour = 'MARC21';
71 'verbose' => \$verbose,
72 'marcflavour=s' => \$marcflavour
79 $marcflavour = uc($marcflavour);
81 if ( $marcflavour ne 'MARC21'
82 and $marcflavour ne 'UNIMARC' ) {
83 say "Invalid MARC flavour '$marcflavour' passed.";
87 $ENV{KOHA_DB_DO_NOT_RAISE_OR_PRINT_ERROR} = 1;
88 my $dbh = C4::Context->dbh; # At the beginning to die if DB does not exist.
90 my ( $prefs_count ) = $dbh->selectrow_array(q|SELECT COUNT(*) FROM systempreferences|);
91 my ( $patrons_count ) = $dbh->selectrow_array(q|SELECT COUNT(*) FROM borrowers|);
92 if ( $prefs_count or $patrons_count ) {
93 die "Database is not empty!";
96 $ENV{KOHA_DB_DO_NOT_RAISE_OR_PRINT_ERROR} = 0;
98 our $root = C4::Context->config('intranetdir');
99 our $data_dir = "$root/installer/data/mysql";
100 our $installer = C4::Installer->new;
102 my $koha_structure_file = "$data_dir/kohastructure.sql";
103 my @sample_files_mandatory = (
104 glob("$data_dir/mandatory/*.sql"),
105 "$data_dir/audio_alerts.sql",
106 "$data_dir/sysprefs.sql",
107 "$data_dir/userflags.sql",
108 "$data_dir/userpermissions.sql",
110 my @sample_lang_files_mandatory = ( glob $root . "/installer/data/mysql/$lang/mandatory/*.sql" );
111 my @sample_lang_files_optional = ( glob $root . "/installer/data/mysql/$lang/optional/*.sql" );
112 my @marc21_sample_files_mandatory = ( glob $root . "/installer/data/mysql/$lang/marcflavour/marc21/*/*.sql" );
113 my @unimarc_sample_files_mandatory = ( glob $root . "/installer/data/mysql/$lang/marcflavour/unimarc/*/*.sql" );
115 my $version = get_version();
120 sub initialize_data {
121 say "Inserting koha db structure..."
123 my $error = $installer->load_db_schema;
124 die $error if $error;
126 for my $f (@sample_files_mandatory) {
130 for my $f (@sample_lang_files_mandatory) {
134 for my $f (@sample_lang_files_optional) {
138 if ( $marcflavour eq 'UNIMARC' ) {
139 for my $f (@unimarc_sample_files_mandatory) {
143 for my $f (@marc21_sample_files_mandatory) {
148 # set marcflavour (MARC21)
149 my $dbh = C4::Context->dbh;
151 say "Setting the MARC flavour on the sysprefs..."
154 INSERT INTO `systempreferences` (variable,value,explanation,options,type)
155 VALUES ('marcflavour',?,'Define global MARC flavor (MARC21 or UNIMARC) used for character encoding','MARC21|UNIMARC','Choice')
156 },undef,$marcflavour);
159 say "Setting Koha version to $version..."
162 INSERT INTO systempreferences(variable, value, options, explanation, type)
163 VALUES ('Version', '$version', NULL, 'The Koha database version. WARNING: Do not change this value manually, it is maintained by the webinstaller', NULL)
166 # Initialize ES mappings
167 Koha::SearchEngine::Elasticsearch->reset_elasticsearch_mappings;
170 sub execute_sqlfile {
172 say "Inserting $filepath..."
174 my $error = $installer->load_sql($filepath);
175 die $error if $error;
179 do $root . '/kohaversion.pl';
180 my $version = kohaversion();
181 $version =~ s/(\d)\.(\d{2})\.(\d{2})\.(\d{3})/$1.$2$3$4/;
185 sub update_database {
186 my $update_db_path = $root . '/installer/data/mysql/updatedatabase.pl';
187 say "Updating database..."
189 my $file = `cat $update_db_path`;
193 die "updatedatabase.pl process failed: $@";
195 say "updatedatabase.pl process succeeded.";