#!/usr/bin/perl

# Creates /var/cpanel/databases/*.yaml for all user accounts

use strict;
use lib "/usr/local/cpanel";
use Cpanel::CPAN::Hash::Merge qw(merge);
use YAML qw( Load Dump LoadFile DumpFile);


my %dbs;
my %users;
opendir(USERS, "/var/cpanel/users");
foreach my $user (readdir(USERS)) {
    chomp $user;
    next if ($user =~ m/^(\.)/ || $user =~ m/^root$/);
    $users{$user}{'v'} = 1;
}
closedir USERS;
if ( !-d "/var/cpanel/databases" ) {
    print "\n\033[32;1mCreating /var/cpanel/databases...\033[0m\n";
    mkdir "/var/cpanel/databases" || die "Can't create /var/cpanel/databases: $!\n";
}
print "\n\033[32;1mFinding user databases...\033[0m\n";
my $u;
my $d;
foreach my $line (`psql -U postgres template1 --list`) {
    ($d,$u) = (undef,undef);
    $d = $1 if ($line =~ m/^\s*(\w+_\S+)\s/);
    next unless ($d);
    $u = $1 if ($d =~ m/\s*(\w+)_/);
    next unless ($u && $users{$u}{'v'});
    print "Mapping database $d to $u...\n";
    $users{$u}{$d} = 1;
}
print "\n\033[32;1mFinding subusers...\033[0m\n";
my %subusers;
foreach my $line (`psql -U postgres template1 -c '\\du'`) {
    ($d,$u) = (undef,undef);
    ($u,$d) = ($1,"$1_$2") if ($line =~ /^\s*(\w+)\_(\w+)\s/);
    if ($u && $d) {
        print "Adding $d subuser to $u...\n";
        $subusers{"$u"}{"$d"} = 1;
    }
}
my $yaml;
my $yfile;
my $ip;
my $sip = $1 if (`host \`hostname\`` =~ m/has address (\d+\.\d+\.\d+\.\d+)/);
die "\033[31;1mCan't determine shared host IP!\033[0m\n" if ($sip !~ m/\d+\.\d+\.\d+\.\d+/);
print "\n\033[32;1mMapping postgresql users to databases...\033[0m\n";
foreach my $user ( keys %users ) {
    print "\n\033[32;1mStarting user $user...\033[0m\n";
    $yaml = undef;
    $ip = undef;
    open(CPUSER, "/var/cpanel/users/$user");
    foreach (<CPUSER>) {
        $ip = $1 if (/^IP=(\d+\.\d+\.\d+\.\d+)$/);
    }
    close CPUSER;
    $ip = $sip unless ($ip);
    $yfile = "/var/cpanel/databases/$user.yaml";
    $yaml = LoadFile($yfile) if ( -e $yfile );
    $yaml = new YAML() unless ($yaml);
    $yaml->{'PGSQL'}->{'server'} = "$ip";
    $yaml->{'PGSQL'}->{'owner'} = "$user";
    foreach my $subuser (keys %{ $subusers{$user} } ) {
        print "Mapping $subuser to $user\n";
        $yaml->{'PGSQL'}->{'dbusers'}->{"$subuser"}->{'server'} = "$ip";
    }
    foreach my $db ( sort { {$a} cmp {$b} } keys %{ $users{$user} } ) {
        next if ($db eq 'v');
        $yaml->{'PGSQL'}->{'dbs'}->{"$db"} = "$ip";
        foreach my $line (`psql -U postgres -c "SELECT datacl FROM pg_database WHERE datname='$db';"`) {
            next if ($line !~ m/^\s*\{.*\}/);
            $line =~ s/.*{//;
            $line =~ s/}.*//;
            foreach my $entry (split(",", $line)) {
                next unless ($entry =~ m/^($user\_.*)=.*$/);
                print "Adding $1 tied to $db\n";
                $yaml->{'PGSQL'}->{'dbusers'}->{"$1"}->{'dbs'}->{"$db"} = "$ip";
            }
        }
    }
    print "\033[32;1mUser $user complete...\033[0m\n";
    DumpFile("/var/cpanel/databases/$user.yaml", $yaml);
}
print "\n\033[32;1mRemoving /var/cpanel/databases/*.cache...\033[0m\n";
system("rm -f /var/cpanel/databases/*.cache") == 0 or print "Failed to remove some: $!\n";
print "\n\033[32;1mComplete!\033[0m\n";
