如何将Mojo::Pg db处理程序传递给控制器？(mojolicious)

use Mojo::Pg;

my $pg = Mojo::Pg->new('postgresql://username:password@localhost/database');

sub index {
    my $self = shift;
    my $pg = $self->app->pg;

    # 在控制器中使用$pg进行数据库操作
}

sub index {
    my $self = shift;
    my $pg = $self->app->pg;

    my $results = $pg->db->query('SELECT * FROM table');
    # 处理查询结果
}

sub create {
    my $self = shift;
    my $pg = $self->app->pg;

    $pg->db->insert('table', { column1 => 'value1', column2 => 'value2' });
    # 处理插入操作结果
}

sub update {
    my $self = shift;
    my $pg = $self->app->pg;

    $pg->db->update('table', { column1 => 'new_value' }, { id => 1 });
    # 处理更新操作结果
}

sub delete {
    my $self = shift;
    my $pg = $self->app->pg;

    $pg->db->delete('table', { id => 1 });
    # 处理删除操作结果
}