# Copyright (C) 2020 all contributors
# License: AGPL-3.0+
# dumps using the ".dump" command of sqlite3(1)
package PublicInbox::WwwAltId;
use strict;
use PublicInbox::Qspawn;
use PublicInbox::WwwStream qw(html_oneshot);
use PublicInbox::AltId;
use PublicInbox::Spawn qw(which);
use PublicInbox::GzipFilter;
our $sqlite3 = $ENV{SQLITE3};
sub check_output {
my ($r, $bref, $ctx) = @_;
return html_oneshot($ctx, 500) if !defined($r);
if ($r == 0) {
my $err = eval { $ctx->{env}->{'psgi.errors'} } // \*STDERR;
$err->print("unexpected EOF from sqlite3\n");
return html_oneshot($ctx, 501);
}
[200, [ qw(Content-Type application/gzip), 'Content-Disposition',
"inline; filename=$ctx->{altid_pfx}.sql.gz" ] ]
}
# POST $INBOX/$prefix.sql.gz
# we use the sqlite3(1) binary here since that's where the ".dump"
# command is implemented, not (AFAIK) in the libsqlite3 library
# and thus not usable from DBD::SQLite.
sub sqldump ($$) {
my ($ctx, $altid_pfx) = @_;
my $env = $ctx->{env};
my $ibx = $ctx->{-inbox};
my $altid_map = $ibx->altid_map;
my $fn = $altid_map->{$altid_pfx};
unless (defined $fn) {
return html_oneshot($ctx, 404, \<`$altid_pfx' is not a valid altid for this inbox
EOF
}
if ($env->{REQUEST_METHOD} ne 'POST') {
my $url = $ibx->base_url($ctx->{env}) . "$altid_pfx.sql.gz";
return html_oneshot($ctx, 405, \<A POST request required to retrieve $altid_pfx.sql.gz
curl -XPOST -O $url
or
curl -XPOST $url | \\
gzip -dc | \\
sqlite3 /path/to/$altid_pfx.sqlite3
EOF
}
$sqlite3 //= which('sqlite3') // return html_oneshot($ctx, 501, \<sqlite3 not available
The administrator needs to install the sqlite3(1) binary
to support gzipped sqlite3 dumps.
EOF
# setup stdin, POSIX requires writes <= 512 bytes to succeed so
# we can close the pipe right away.
pipe(my ($r, $w)) or die "pipe: $!";
syswrite($w, ".dump\n") == 6 or die "write: $!";
close($w) or die "close: $!";
# TODO: use -readonly if available with newer sqlite3(1)
my $qsp = PublicInbox::Qspawn->new([$sqlite3, $fn], undef, { 0 => $r });
$ctx->{altid_pfx} = $altid_pfx;
$env->{'qspawn.filter'} = PublicInbox::GzipFilter->new;
$qsp->psgi_return($env, undef, \&check_output, $ctx);
}
1;