New upstream version 0.13

16 files changed, 57 insertions, 33 deletions

diff --git a/Build.PL b/Build.PL
index 0e334eb..60f12b3 100644
--- a/Build.PL
+++ b/Build.PL
@@ -1,5 +1,5 @@
 
-# This file was automatically generated by Dist::Zilla::Plugin::ModuleBuild v6.012.
+# This file was automatically generated by Dist::Zilla::Plugin::ModuleBuild v6.031.
 use strict;
 use warnings;
 
@@ -18,7 +18,7 @@ my %module_build_args = (
     "Nicolas Franck"
   ],
   "dist_name" => "Catmandu-DBI",
-  "dist_version" => "0.12",
+  "dist_version" => "0.13",
   "license" => "perl",
   "module_name" => "Catmandu::DBI",
   "recursive_test_files" => 1,
diff --git a/Changes b/Changes
index 5bf9f6c..b8f8090 100644
--- a/Changes
+++ b/Changes
@@ -1,5 +1,8 @@
 Revision history for Catmandu-DBI
 
+0.13  2024-03-20 16:40:53 CET
+  - create indexes in the current schema
+
 0.12  2022-08-23 11:19:52 CEST
   - optimize bag generator by reducing number of queries by 1
 
diff --git a/LICENSE b/LICENSE
index 64ca3a6..e4f20f2 100644
--- a/LICENSE
+++ b/LICENSE
@@ -1,4 +1,4 @@
-This software is copyright (c) 2022 by Nicolas Steenlant.
+This software is copyright (c) 2024 by Nicolas Franck C<< <nicolas.franck at ugent.be> >>.
 
 This is free software; you can redistribute it and/or modify it under
 the same terms as the Perl 5 programming language system itself.
@@ -12,7 +12,7 @@ b) the "Artistic License"
 
 --- The GNU General Public License, Version 1, February 1989 ---
 
-This software is Copyright (c) 2022 by Nicolas Steenlant.
+This software is Copyright (c) 2024 by Nicolas Franck C<< <nicolas.franck at ugent.be> >>.
 
 This is free software, licensed under:
 
@@ -272,7 +272,7 @@ That's all there is to it!
 
 --- The Artistic License 1.0 ---
 
-This software is Copyright (c) 2022 by Nicolas Steenlant.
+This software is Copyright (c) 2024 by Nicolas Franck C<< <nicolas.franck at ugent.be> >>.
 
 This is free software, licensed under:
 
@@ -292,21 +292,21 @@ Definitions:
 
   - "Package" refers to the collection of files distributed by the Copyright
     Holder, and derivatives of that collection of files created through
-    textual modification. 
+    textual modification.
   - "Standard Version" refers to such a Package if it has not been modified,
     or has been modified in accordance with the wishes of the Copyright
-    Holder. 
+    Holder.
   - "Copyright Holder" is whoever is named in the copyright or copyrights for
-    the package. 
+    the package.
   - "You" is you, if you're thinking about copying or distributing this Package.
   - "Reasonable copying fee" is whatever you can justify on the basis of media
     cost, duplication charges, time of people involved, and so on. (You will
     not be required to justify it to the Copyright Holder, but only to the
-    computing community at large as a market that must bear the fee.) 
+    computing community at large as a market that must bear the fee.)
   - "Freely Available" means that no fee is charged for the item itself, though
     there may be fees involved in handling the item. It also means that
     recipients of the item may redistribute it under the same conditions they
-    received it. 
+    received it.
 
 1. You may make and give away verbatim copies of the source form of the
 Standard Version of this Package without restriction, provided that you
@@ -373,7 +373,7 @@ products derived from this software without specific prior written permission.
 
 9. THIS PACKAGE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
-MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
 
 The End
 
diff --git a/MANIFEST b/MANIFEST
index d94dce8..81cddb7 100644
--- a/MANIFEST
+++ b/MANIFEST
@@ -1,4 +1,4 @@
-# This file was automatically generated by Dist::Zilla::Plugin::Manifest v6.012.
+# This file was automatically generated by Dist::Zilla::Plugin::Manifest v6.031.
 Build.PL
 Changes
 LICENSE
diff --git a/META.json b/META.json
index ece5e5c..1098a0e 100644
--- a/META.json
+++ b/META.json
@@ -4,7 +4,7 @@
       "Nicolas Franck"
    ],
    "dynamic_config" : 0,
-   "generated_by" : "Dist::Milla version v1.0.20, Dist::Zilla version 6.012, CPAN::Meta::Converter version 2.150010",
+   "generated_by" : "Dist::Milla version v1.0.22, Dist::Zilla version 6.031, CPAN::Meta::Converter version 2.150001",
    "license" : [
       "perl_5"
    ],
@@ -36,7 +36,7 @@
       },
       "develop" : {
          "requires" : {
-            "Dist::Milla" : "v1.0.20",
+            "Dist::Milla" : "v1.0.22",
             "Test::Pod" : "1.41"
          }
       },
@@ -70,10 +70,10 @@
          "web" : "https://github.com/LibreCat/Catmandu-DBI"
       }
    },
-   "version" : "0.12",
+   "version" : "0.13",
    "x_contributors" : [
       "Jakob Voss <jakob@nichtich.de>",
-      "Nicolas Franck <Nicolas.Franck@ugent.be>",
+      "Nicolas Franck <nicolas.franck@ugent.be>",
       "Nicolas Franck <njfranck@ca20c526.ugent.be>",
       "Nicolas Franck <njfranck@ca20c533.ugent.be>",
       "Nicolas Steenlant <nicolas.steenlant@gmail.com>",
@@ -82,8 +82,9 @@
       "Patrick Hochstenbach <patrick.hochstenbach@ugent.be>",
       "vpeil <vitali.peil@uni-bielefeld.de>"
    ],
-   "x_generated_by_perl" : "v5.30.0",
-   "x_serialization_backend" : "Cpanel::JSON::XS version 4.27",
+   "x_generated_by_perl" : "v5.22.1",
+   "x_serialization_backend" : "Cpanel::JSON::XS version 4.36",
+   "x_spdx_expression" : "Artistic-1.0-Perl OR GPL-1.0-or-later",
    "x_static_install" : 0
 }
 
diff --git a/META.yml b/META.yml
index 2121b5f..dcce538 100644
--- a/META.yml
+++ b/META.yml
@@ -9,7 +9,7 @@ build_requires:
 configure_requires:
   Module::Build: '0.28'
 dynamic_config: 0
-generated_by: 'Dist::Milla version v1.0.20, Dist::Zilla version 6.012, CPAN::Meta::Converter version 2.150010'
+generated_by: 'Dist::Milla version v1.0.22, Dist::Zilla version 6.031, CPAN::Meta::Converter version 2.150001'
 license: perl
 meta-spec:
   url: http://module-build.sourceforge.net/META-spec-v1.4.html
@@ -35,10 +35,10 @@ resources:
   bugtracker: https://github.com/LibreCat/Catmandu-DBI/issues
   homepage: https://github.com/LibreCat/Catmandu-DBI
   repository: https://github.com/LibreCat/Catmandu-DBI.git
-version: '0.12'
+version: '0.13'
 x_contributors:
   - 'Jakob Voss <jakob@nichtich.de>'
-  - 'Nicolas Franck <Nicolas.Franck@ugent.be>'
+  - 'Nicolas Franck <nicolas.franck@ugent.be>'
   - 'Nicolas Franck <njfranck@ca20c526.ugent.be>'
   - 'Nicolas Franck <njfranck@ca20c533.ugent.be>'
   - 'Nicolas Steenlant <nicolas.steenlant@gmail.com>'
@@ -46,6 +46,7 @@ x_contributors:
   - 'njfranck <njfranck@ca20c521.ugent.be>'
   - 'Patrick Hochstenbach <patrick.hochstenbach@ugent.be>'
   - 'vpeil <vitali.peil@uni-bielefeld.de>'
-x_generated_by_perl: v5.30.0
+x_generated_by_perl: v5.22.1
 x_serialization_backend: 'YAML::Tiny version 1.73'
+x_spdx_expression: 'Artistic-1.0-Perl OR GPL-1.0-or-later'
 x_static_install: 0
diff --git a/README b/README
index e15653b..4ac23c8 100644
--- a/README
+++ b/README
@@ -54,6 +54,16 @@ AUTHORS
 
     Nicolas Steenlant <nicolas.steenlant at ugent.be>
 
+COPYRIGHT
+
+    Copyright 2024 - Nicolas Franck, Patrick Hochstenbach, Vitali Peil,
+    Nicolas Steenlant
+
+LICENSE
+
+    This library is free software; you can redistribute it and/or modify it
+    under the same terms as Perl itself.
+
 SEE ALSO
 
     Catmandu, Catmandu::Importer , Catmandu::Store::DBI
diff --git a/lib/Catmandu/DBI.pm b/lib/Catmandu/DBI.pm
index 8c997c8..7bfe6a3 100644
--- a/lib/Catmandu/DBI.pm
+++ b/lib/Catmandu/DBI.pm
@@ -1,6 +1,6 @@
 package Catmandu::DBI;
 
-our $VERSION = "0.12";
+our $VERSION = "0.13";
 
 =head1 NAME
 
@@ -58,6 +58,15 @@ Vitali Peil C<< <vitali.peil at uni-bielefeld.de> >>
 
 Nicolas Steenlant C<< <nicolas.steenlant at ugent.be> >>
 
+=head1 COPYRIGHT
+
+Copyright 2024 - Nicolas Franck, Patrick Hochstenbach, Vitali Peil, Nicolas Steenlant
+
+=head1 LICENSE
+
+This library is free software; you can redistribute it and/or modify
+it under the same terms as Perl itself.
+
 =head1 SEE ALSO
 
 L<Catmandu>, L<Catmandu::Importer> , L<Catmandu::Store::DBI>
diff --git a/lib/Catmandu/Importer/DBI.pm b/lib/Catmandu/Importer/DBI.pm
index b6e3e10..0cd310b 100644
--- a/lib/Catmandu/Importer/DBI.pm
+++ b/lib/Catmandu/Importer/DBI.pm
@@ -6,7 +6,7 @@ use Moo;
 use MooX::Aliases;
 use namespace::clean;
 
-our $VERSION = '0.12';
+our $VERSION = '0.13';
 
 with 'Catmandu::Importer';
 
diff --git a/lib/Catmandu/Store/DBI.pm b/lib/Catmandu/Store/DBI.pm
index 9cb48f9..df765b1 100644
--- a/lib/Catmandu/Store/DBI.pm
+++ b/lib/Catmandu/Store/DBI.pm
@@ -9,7 +9,7 @@ use MooX::Aliases;
 use Catmandu::Error;
 use namespace::clean;
 
-our $VERSION = "0.12";
+our $VERSION = "0.13";
 
 with 'Catmandu::Store';
 with 'Catmandu::Transactional';
diff --git a/lib/Catmandu/Store/DBI/Bag.pm b/lib/Catmandu/Store/DBI/Bag.pm
index 6307428..5a670e1 100644
--- a/lib/Catmandu/Store/DBI/Bag.pm
+++ b/lib/Catmandu/Store/DBI/Bag.pm
@@ -5,7 +5,7 @@ use Moo;
 use Catmandu::Store::DBI::Iterator;
 use namespace::clean;
 
-our $VERSION = "0.12";
+our $VERSION = "0.13";
 
 my $default_mapping = {
     _id => {
diff --git a/lib/Catmandu/Store/DBI/Handler.pm b/lib/Catmandu/Store/DBI/Handler.pm
index 823c3ff..4fad2de 100644
--- a/lib/Catmandu/Store/DBI/Handler.pm
+++ b/lib/Catmandu/Store/DBI/Handler.pm
@@ -4,7 +4,7 @@ use Catmandu::Sane;
 use Moo::Role;
 use namespace::clean;
 
-our $VERSION = "0.12";
+our $VERSION = "0.13";
 
 requires 'create_table';
 requires 'add_row';
diff --git a/lib/Catmandu/Store/DBI/Handler/MySQL.pm b/lib/Catmandu/Store/DBI/Handler/MySQL.pm
index be27ff9..a621f8a 100644
--- a/lib/Catmandu/Store/DBI/Handler/MySQL.pm
+++ b/lib/Catmandu/Store/DBI/Handler/MySQL.pm
@@ -4,7 +4,7 @@ use Catmandu::Sane;
 use Moo;
 use namespace::clean;
 
-our $VERSION = "0.12";
+our $VERSION = "0.13";
 
 with 'Catmandu::Store::DBI::Handler';
 
diff --git a/lib/Catmandu/Store/DBI/Handler/Pg.pm b/lib/Catmandu/Store/DBI/Handler/Pg.pm
index af6178a..eb9fdb8 100644
--- a/lib/Catmandu/Store/DBI/Handler/Pg.pm
+++ b/lib/Catmandu/Store/DBI/Handler/Pg.pm
@@ -5,7 +5,7 @@ use DBD::Pg ();
 use Moo;
 use namespace::clean;
 
-our $VERSION = "0.12";
+our $VERSION = "0.13";
 
 with 'Catmandu::Store::DBI::Handler';
 
@@ -66,10 +66,10 @@ IF NOT EXISTS (
     FROM   pg_class c
     JOIN   pg_namespace n ON n.oid = c.relnamespace
     WHERE  c.relname = '${name}_${col}_idx'
-    AND    n.nspname = 'public'
+    AND    n.nspname = (SELECT CURRENT_SCHEMA)
     ) THEN
 
-    CREATE INDEX ${name}_${col}_idx ON public.${name} (${q_col});
+    CREATE INDEX ${name}_${col}_idx ON ${name} (${q_col});
 END IF;
 
 END\$\$;
diff --git a/lib/Catmandu/Store/DBI/Handler/SQLite.pm b/lib/Catmandu/Store/DBI/Handler/SQLite.pm
index dba573f..c8c200c 100644
--- a/lib/Catmandu/Store/DBI/Handler/SQLite.pm
+++ b/lib/Catmandu/Store/DBI/Handler/SQLite.pm
@@ -4,7 +4,7 @@ use Catmandu::Sane;
 use Moo;
 use namespace::clean;
 
-our $VERSION = "0.12";
+our $VERSION = "0.13";
 
 with 'Catmandu::Store::DBI::Handler';
 
diff --git a/lib/Catmandu/Store/DBI/Iterator.pm b/lib/Catmandu/Store/DBI/Iterator.pm
index eb62164..c3ab471 100644
--- a/lib/Catmandu/Store/DBI/Iterator.pm
+++ b/lib/Catmandu/Store/DBI/Iterator.pm
@@ -5,7 +5,7 @@ use Catmandu::Util qw(is_value is_string is_array_ref);
 use Moo;
 use namespace::clean;
 
-our $VERSION = "0.12";
+our $VERSION = "0.13";
 
 with 'Catmandu::Iterable';