15537773485/temporary-db-pgsql

0.0.1 2022-08-28 17:06 UTC

Requires

• php: >=8.0
• hyperf/db: ^3.0

Requires (Dev)

• friendsofphp/php-cs-fixer: ^3.0
• hyperf/di: ^3.0
• hyperf/testing: ^3.0
• hyperf/utils: ^3.0
• mockery/mockery: ^1.0
• phpstan/phpstan: ^0.12|^1.8
• phpunit/phpunit: >=7.0
• swoole/ide-helper: dev-master
• symfony/var-dumper: ^5.1

MIT

• php
• hyperf

README

安装

hyperf/db 组件版本必须大于等于 v2.1.8

composer require hyperf/db-pgsql-incubator

配置

修改 autoload/db.php 配置

use Hyperf\DB\PgSQL\PgSQLPool;

return [
    'default' => [
        'driver' => PgSQLPool::class,
        'host' => '127.0.0.1',
        'port' => 5432,
        'database' => 'postgres',
        'username' => 'postgres',
        'password' => 'root',
        'pool' => [
            'min_connections' => 1,
            'max_connections' => 32,
            'connect_timeout' => 10.0,
            'wait_timeout' => 3.0,
            'heartbeat' => -1,
            'max_idle_time' => 60,
        ],
    ],
];

使用

具体使用方式与 PDO 一致，只不过需要注意，pgsql 中的变量使用 $1 而不是 ? 代表。

例如下述代码

<?php

use Hyperf\DB\DB;

$res = DB::query('SELECT * FROM USERS WHERE id = $1 AND nickname = $2;', [2, 'Hyperf']);