Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.11.x will end 14 Nov 2022 (12 months plus 6 months extension).
  • Bug fixes for security issues in 3.11.x will end 13 Nov 2023 (18 months plus 12 months extension).
  • PHP version: minimum PHP 7.3.0 Note: minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is supported too.

Differences Between: [Versions 310 and 311] [Versions 311 and 400] [Versions 311 and 401] [Versions 311 and 402] [Versions 311 and 403] [Versions 39 and 311]

(no description)

File Size: 1152 lines (33 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 3 classes

ADODB_postgres64:: (33 methods):
  ServerInfo()
  IfNull()
  pg_insert_id()
  _insertid()
  _affectedrows()
  BeginTrans()
  RowLock()
  CommitTrans()
  RollbackTrans()
  MetaTables()
  qStr()
  SQLDate()
  UpdateBlobFile()
  BlobDelete()
  GuessOID()
  BlobDecode()
  BlobEncode()
  UpdateBlob()
  OffsetDate()
  _generateMetaColumnsSQL()
  MetaColumns()
  param()
  MetaIndexes()
  _connect()
  _nconnect()
  _pconnect()
  _query()
  _errconnect()
  ErrorMsg()
  ErrorNo()
  _close()
  CharMax()
  TextMax()

Name:: (0 methods):

ADORecordSet_postgres64:: (12 methods):
  __construct()
  GetRowAssoc()
  _initrs()
  Fields()
  FetchField()
  _seek()
  _decode()
  _fixblobs()
  MoveNext()
  _fetch()
  _close()
  MetaType()

Defines 12 functions


Class: ADODB_postgres64  - X-Ref

ServerInfo($detailed = true)   X-Ref
Retrieve Server information.
In addition to server version and description, the function also returns
the client version.

param: bool $detailed If true, retrieve detailed version string (executes
return: array|bool Server info or false if version could not be retrieved

IfNull( $field, $ifNull )   X-Ref
No description

pg_insert_id($tablename,$fieldname)   X-Ref
No description

_insertid($table,$column)   X-Ref
Warning from http://www.php.net/manual/function.pg-getlastoid.php:
Using a OID as a unique identifier is not generally wise.
Unless you are very careful, you might end up with a tuple having
a different OID if a database must be reloaded.


_affectedrows()   X-Ref
No description

BeginTrans()   X-Ref

return: true/false

RowLock($tables,$where,$col='1 as adodbignore')   X-Ref
No description

CommitTrans($ok=true)   X-Ref
No description

RollbackTrans()   X-Ref
No description

MetaTables($ttype=false,$showSchema=false,$mask=false)   X-Ref
No description

qStr($s, $magic_quotes=false)   X-Ref
Quotes a string to be sent to the database.

Relies on pg_escape_string()
param: string $s            The string to quote
param: bool   $magic_quotes This param is not used since 5.21.0.
return: string Quoted string

SQLDate($fmt, $col=false)   X-Ref
No description

UpdateBlobFile($table,$column,$path,$where,$blobtype='BLOB')   X-Ref
No description

BlobDelete( $blob )   X-Ref
No description

GuessOID($oid)   X-Ref
No description

BlobDecode($blob,$maxsize=false,$hastrans=true)   X-Ref
No description

BlobEncode($blob)   X-Ref
Encode binary value prior to DB storage.

See https://www.postgresql.org/docs/current/static/datatype-binary.html

NOTE: SQL string literals (input strings) must be preceded with two
backslashes due to the fact that they must pass through two parsers in
the PostgreSQL backend.

param: string $blob

UpdateBlob($table,$column,$val,$where,$blobtype='BLOB')   X-Ref
No description

OffsetDate($dayFraction,$date=false)   X-Ref
No description

_generateMetaColumnsSQL($table, $schema)   X-Ref
Generate the SQL to retrieve MetaColumns data

param: string $table Table name
param: string $schema Schema name (can be blank)
return: string SQL statement to execute

MetaColumns($table,$normalize=true)   X-Ref
No description

param($name, $type='C')   X-Ref
No description

MetaIndexes($table, $primary = FALSE, $owner = false)   X-Ref
No description

_connect($str,$user='',$pwd='',$db='',$ctype=0)   X-Ref
No description

_nconnect($argHostname, $argUsername, $argPassword, $argDatabaseName)   X-Ref
No description

_pconnect($str,$user='',$pwd='',$db='')   X-Ref
No description

_query($sql,$inputarr=false)   X-Ref
No description

_errconnect()   X-Ref
No description

ErrorMsg()   X-Ref
No description

ErrorNo()   X-Ref
No description

_close()   X-Ref
No description

CharMax()   X-Ref
No description

TextMax()   X-Ref
No description

Class: Name  - X-Ref

Class: ADORecordSet_postgres64  - X-Ref

__construct($queryID, $mode=false)   X-Ref
No description

GetRowAssoc($upper = ADODB_ASSOC_CASE)   X-Ref
No description

_initrs()   X-Ref
No description

Fields($colname)   X-Ref
No description

FetchField($off = 0)   X-Ref
No description

_seek($row)   X-Ref
No description

_decode($blob)   X-Ref
No description

_fixblobs()   X-Ref
No description

MoveNext()   X-Ref
No description

_fetch()   X-Ref
No description

_close()   X-Ref
No description

MetaType($t,$len=-1,$fieldobj=false)   X-Ref
No description

Functions that are not part of a class:

adodb_addslashes($s)   X-Ref
No description