Gitee
\
app
bin
http
sR
db
tool
clisr

\sR\dbPgsql

Summary

Methods
Properties
Constants
__construct()
getDsn()
all()
row()
one()
query()
beginTransaction()
commit()
rollBack()
getPdo()
exec()
error()
qV()
qC()
builder()
table()
No public properties found
No constants found
mapToDsnStr()
connect()
prepareThenExec()
$quoteValue
$quoteColumn
$pdo
$options
$errorException
$driverOptions
$sth
N/A
No private methods found
No private properties found
N/A

Properties

$quoteValue

$quoteValue :

Type

$quoteColumn

$quoteColumn :

Type

$pdo

$pdo : \PDO

Type

\PDO

$options

$options :

Type

$errorException

$errorException : \Exception

Type

\Exception

$driverOptions

$driverOptions :

Type

$sth

$sth : \PDOStatement

Type

\PDOStatement

Methods

__construct()

__construct(  $options)

Parameters

$options

getDsn()

getDsn() : string

pgsql:host=localhost;port=5432;dbname=testdb;user=bruce;password=mypass

Returns

string

all()

all(string  $sql, array  $bind = array()) : array|null

获取查询结果集所有列

Parameters

string $sql
array $bind

Returns

array|null

row()

row(string  $sql, array  $bind = array()) : array|mixed|null

获取结果集单列

Parameters

string $sql
array $bind

Returns

array|mixed|null

one()

one(  $sql, array  $bind = array()) : mixed

获取结果集单值

Parameters

$sql
array $bind

Returns

mixed

query()

query(string  $sql, array  $bind = array()) : boolean|integer

数据查询，返回影响的结果

Parameters

string $sql
array $bind

Returns

boolean|integer

beginTransaction()

beginTransaction() : boolean

开启事务

Returns

boolean

commit()

commit() : boolean|mixed

事务提交

Returns

boolean|mixed

rollBack()

rollBack() : boolean|mixed

事务回滚

Returns

boolean|mixed

getPdo()

getPdo() : \PDO

Returns

\PDO

exec()

exec(  $sql) : integer

执行sql并返回影响的行

Parameters

$sql

Returns

integer

error()

error() : \Exception|null

Returns

\Exception|null

qV()

qV(null|string  $value = null) : string

Parameters

null|string $value

Returns

string

qC()

qC(null|string  $value = null) : string

Parameters

null|string $value

Returns

string

builder()

builder() : \sR\db\Builder

SQL 生成器

Returns

\sR\db\Builder

table()

table(string  $table, null  $alias = null) : \sR\db\Builder

表查询

Parameters

string $table
null $alias

Returns

\sR\db\Builder

mapToDsnStr()

mapToDsnStr(  $map) : string

字典转变为dsn连接字符串

Parameters

$map

Returns

string

connect()

connect()

数据库连接

prepareThenExec()

prepareThenExec(string  $sql, array  $bind = array(), boolean  $affect = false) : boolean|\PDOStatement

Parameters

string $sql
array $bind
boolean $affect

Returns

boolean|\PDOStatement