Class mssqlDbConnection

Description

Located in /plugins/db/mssql/mssql.dbconnection.php (line 16)

jDbConnection
   |
   --mssqlDbConnection
Method Summary
unknown_type __construct (array $profile)
void commit ()
void errorCode ()
void errorInfo ()
string getAttribute (integer $id)
void lastInsertId ([ $fromSequence = ''])
void prepare ( $query)
void rollback ()
void setAttribute (integer $id, string $value)
void _autoCommitNotify (boolean $state)
void _connect ()
void _disconnect ()
void _doExec ( $query)
void _doLimitQuery ( $queryString,  $offset,  $number)
void _doQuery ( $query)
void _quote ( $text,  $binary)
Variables
Methods
Constructor __construct (line 23)

Default constructor

unknown_type __construct (array $profile)
  • array $profile: profile de connexion

Redefinition of:
jDbConnection::__construct()
do a connection to the database, using properties of the given profile
beginTransaction (line 33)

begin a transaction

  • access: public
void beginTransaction ()

Redefinition of:
jDbConnection::beginTransaction()
begin a transaction. Call it before query, limitQuery, exec
commit (line 41)

Commit since the last begin

  • access: public
void commit ()

Redefinition of:
jDbConnection::commit()
validate all queries and close a transaction
errorCode (line 65)
  • access: public
void errorCode ()

Redefinition of:
jDbConnection::errorCode()
errorInfo (line 61)
  • access: public
void errorInfo ()

Redefinition of:
jDbConnection::errorInfo()
getAttribute (line 222)
  • return: the attribute value
  • see: PDO::getAttribute()
  • access: public
string getAttribute (integer $id)
  • integer $id: the attribut id

Redefinition of:
jDbConnection::getAttribute()
lastInsertId (line 189)

(non-PHPdoc)

return the last inserted ID incremented in database

  • see: lastInsertId()
  • access: public
void lastInsertId ([ $fromSequence = ''])
  • $fromSequence

Redefinition of:
jDbConnection::lastInsertId()
return the id value of the last inserted row.
prepare (line 57)
  • access: public
void prepare ( $query)
  • $query

Redefinition of:
jDbConnection::prepare()
prepare a query
rollback (line 49)

Rollback since the last BEGIN

  • access: public
void rollback ()

Redefinition of:
jDbConnection::rollback()
cancel all queries of a transaction and close the transaction
setAttribute (line 232)
  • see: PDO::setAttribute()
  • access: public
void setAttribute (integer $id, string $value)
  • integer $id: the attribut id
  • string $value: the attribute value

Redefinition of:
jDbConnection::setAttribute()
_autoCommitNotify (line 200)

tell mssql to be implicit commit or not

  • access: protected
void _autoCommitNotify (boolean $state)
  • boolean $state: the state of the autocommit value

Redefinition of:
jDbConnection::_autoCommitNotify()
Notify the changes on autocommit
_connect (line 73)

initialize the connection to the database

  • see: _connect()
  • access: protected
void _connect ()

Redefinition of:
jDbConnection::_connect()
return a connection identifier or false/null if there is an error
_disconnect (line 90)

close the connection to the database

  • see: _disconnect()
  • access: protected
void _disconnect ()

Redefinition of:
jDbConnection::_disconnect()
do a disconnection
_doExec (line 117)
  • see: _doExec()
  • access: protected
void _doExec ( $query)
  • $query

Redefinition of:
jDbConnection::_doExec()
do a query which return nothing
_doLimitQuery (line 130)
  • see: _doLimitQuery()
  • access: protected
void _doLimitQuery ( $queryString,  $offset,  $number)
  • $queryString
  • $offset
  • $number

Redefinition of:
jDbConnection::_doLimitQuery()
do a query which return a limited number of results
_doQuery (line 98)

execute an SQL instruction

  • see: _doQuery()
  • access: protected
void _doQuery ( $query)
  • $query

Redefinition of:
jDbConnection::_doQuery()
do a query which return results
_quote (line 212)

escape special characters

  • todo: support of binary strings
  • access: protected
void _quote ( $text,  $binary)
  • $text
  • $binary

Redefinition of:
jDbConnection::_quote()
do the escaping of a string.

Inherited Methods

Inherited From jDbConnection

jDbConnection::__construct()
jDbConnection::beginTransaction()
jDbConnection::commit()
jDbConnection::encloseFieldName()
jDbConnection::encloseName()
jDbConnection::errorCode()
jDbConnection::errorInfo()
jDbConnection::exec()
jDbConnection::getAttribute()
jDbConnection::hasTablePrefix()
jDbConnection::lastIdInTable()
jDbConnection::lastInsertId()
jDbConnection::limitQuery()
jDbConnection::prefixTable()
jDbConnection::prepare()
jDbConnection::query()
jDbConnection::quote()
jDbConnection::quote2()
jDbConnection::rollback()
jDbConnection::schema()
jDbConnection::setAttribute()
jDbConnection::setAutoCommit()
jDbConnection::tools()
jDbConnection::_autoCommitNotify()
jDbConnection::_connect()
jDbConnection::_disconnect()
jDbConnection::_doExec()
jDbConnection::_doLimitQuery()
jDbConnection::_doQuery()
jDbConnection::_quote()
jDbConnection::__destruct()
Class Constants

Documentation generated on Mon, 19 Sep 2011 14:14:00 +0200 by phpDocumentor 1.4.3