view release on metacpan or  search on metacpan

example/pg.yml  view on Meta::CPAN

---
pg:
  connectors:
    main:
      host: 'db.example.com'
      port: 5432
      user: 'main'
      password: 'main'
      dbname: 'postgres'
      options:
        PrintWarn: 0
        PrintError: 0
        RaiseError: 1
        pg_enable_utf8: 1

lib/App/Environ/Mojo/Pg.pm  view on Meta::CPAN

  my ($connector) = validate_pos( @_, 1 );

  my $conf = App::Environ::Config->instance->{pg}{connectors}{$connector};

  my $url = URI->new();

  ## Non standart schema workaround
  ## For URI objects that do not belong to one of these, you can only use the common and generic methods.
  $url->scheme('https');

  $url->userinfo("$conf->{user}:$conf->{password}");
  $url->host( $conf->{host} );
  $url->port( $conf->{port} );
  $url->path( $conf->{dbname} );
  $url->query_form( %{ $conf->{options} } );

  $url->scheme('postgresql');

  return $url->as_string;
}