sharedkv: split out index_values

[public-inbox.git] / lib / PublicInbox / SharedKV.pm

diff --git a/lib/PublicInbox/SharedKV.pm b/lib/PublicInbox/SharedKV.pm
index 52a7424eb19fe8a733c153b2ca94988942f84165..983952f59a961a08867aa25bed5f55543d00ba01 100644 (file)
--- a/lib/PublicInbox/SharedKV.pm
+++ b/lib/PublicInbox/SharedKV.pm
@@ -36,7 +36,6 @@ CREATE TABLE IF NOT EXISTS kv (
        UNIQUE (k)
 )
 
-               $dbh->do('CREATE INDEX IF NOT EXISTS idx_v ON kv (v)');
                $dbh;
        }
 }
@@ -59,6 +58,12 @@ sub new {
        $self;
 }
 
+sub index_values {
+       my ($self) = @_;
+       my $lock = $self->lock_for_scope;
+       $self->dbh($lock)->do('CREATE INDEX IF NOT EXISTS idx_v ON kv (v)');
+}
+
 sub set_maybe {
        my ($self, $key, $val, $lock) = @_;
        $lock //= $self->lock_for_scope;