From Code to Community: Sponsoring The Perl and Raku Conference 2025 Learn more

FSEITZ / Quiq-1.225 / lib / Quiq / PostgreSql / PgDump.pm 

            

              
1
—
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
—
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
—
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196

              
# -----------------------------------------------------------------------------
=encoding utf8
=head1 NAME
Quiq::PostgreSql::PgDump - Wrapper für pg_dump
=head1 BASE CLASS
L<Quiq::Object>
=head1 SYNOPSIS
  use Quiq::PostgreSql::PgDump;
   
  Quiq::PostgreSql::PgDump->run($database,@opt);
=head1 DESCRIPTION
Die Klasse stellt einen Wrapper für den PostgreSQL-Client pg_dump dar.
=head1 EXAMPLE
  $ perl -MQuiq::PostgreSql::PgDump -E 'Quiq::PostgreSql::PgDump->run("prod","--table","p_muster.admviews","--schema-only","--debug")'
=cut
# -----------------------------------------------------------------------------
package Quiq::PostgreSql::PgDump;
use base qw/Quiq::Object/;
use v5.10;
use strict;
use warnings;
our $VERSION = '1.225';
use Quiq::Stopwatch;
use Quiq::Udl;
use Quiq::CommandLine;
use Expect ();
# -----------------------------------------------------------------------------
=head1 METHODS
=head2 Klassenmethoden
=head3 run() - Rufe pg_dump ohne Passwortabfrage auf
=head4 Synopsis
  $class->run($database,@opt);
=head4 Arguments
=over 4
=item $database
Name der Datenbank oder der Universal Database Locator (UDL).
Ist ein Name angegeben, muss in der Datenbank-Konfigurationsdatei
definiert sein.
=back
=head4 Options
Alle Optionen von C<pg_dump>, plus
=over 4
=item -debug => $bool (Default: 0)
Gib das ausgeführte pg_dump-Kommando auf STDOUT aus.
=back
=cut
# -----------------------------------------------------------------------------
sub run {
    my ($class,$database) = splice @_,0,2;
    # @_: @opt
    my $stw = Quiq::Stopwatch->new;
    # Options (alle anderen Argumente befinden sich auf @_)
    my $debug = 0;
    $class->parameters(1,\@_,
        -debug => \$debug,
    );
    # Führe Operation aus
    my $udl = Quiq::Udl->new($database);
    if ($udl->dbms ne 'postgresql') {
        $class->throw(
            'PSQL-00001: Not a PostgeSQL UDL',
            Udl => $udl->asString,
        );
    }
    my $c = Quiq::CommandLine->new('pg_dump');
    for my $opt (qw/user host port/) {
        if (my $val = $udl->$opt) {
            $c->addLongOption(
                "--$opt" => $val,
            );
        }
    }
    $c->addBoolOption('--schema-only'=>1);
    $c->addString("@_"); 
    if (my $database = $udl->db) {
        $c->addArgument($database);
    }
    my $cmd = $c->command;
    if ($debug) {
        say $cmd;
    }
    my $exp = Expect->new;
    $exp->spawn($cmd) || do {
        $class->throw(
            'EXPECT-00099: Cannot spawn command',
            Command => $cmd,
        );
    };
    # Anmeldung. Wir unterscheiden drei Fälle.
    my $interact = 0;
    $exp->expect(3,[
        # mit Passwort
        -re => 'Password.*?:',sub {
            my $exp = shift;
            $exp->send($udl->password."\n");
            $interact = 1;
        },
    ],
    #[
    #    # ohne Passwort
    #    -re => '^psql ',sub {
    #        $interact = 1;
    #    },
    #],
    [
        # Verbindung kommt nicht zustande
        -re => '^pg_dump:',sub {
            # Ende der Kommunikation
        },
    ]);
    if ($interact) {
        # Benutzer-Interaktion
        $exp->interact;
    }
    printf "Duration: %s\n",$stw->elapsedReadable;
    return;
}
# -----------------------------------------------------------------------------
=head1 VERSION
1.225
=head1 AUTHOR
Frank Seitz, L<http://fseitz.de/>
=head1 COPYRIGHT
Copyright (C) 2025 Frank Seitz
=head1 LICENSE
This code is free software; you can redistribute it and/or modify
it under the same terms as Perl itself.
=cut
# -----------------------------------------------------------------------------
1;
# eof