Docs For Class miSqlComplexPKRecord

Description

SQL Record managerment class for records with complex primary keys

copyright: Copyright (c) 2006 Mirchev Ideas Ltd. All rights reserved.

Located in /model/SqlComplexPKRecord.php (line 20)

miSqlRecord
   |
   --miSqlComplexPKRecord

Method Summary

miSqlComplexPKRecord __construct (string $table, array $primaryKey)

void delete ()

string getPKWhereSql ( $values)

void insert ()

void readPK (array $values)

void update ()

Variables

Inherited Variables

Inherited from miSqlRecord

miSqlRecord::$_primaryKey
miSqlRecord::$_row
miSqlRecord::$_table

Methods

Constructor __construct (line 29)

Creates miSqlComplexPKRecord object

access: public

miSqlComplexPKRecord __construct (string $table, array $primaryKey)

string $table: the table name
array $primaryKey: array of the primary key columns

Redefinition of:

miSqlRecord::__construct(): miSqlRecord constructor. It takes two parameters table name and table primary key

delete (line 91)

Delete a record in the db table

access: public

void delete ()

Redefinition of:

miSqlRecord::delete(): Delete a record in the db table

getPKWhereSql (line 103)

Returns the where sql clauses for selecting by primary key

return: the sql code
access: protected

string getPKWhereSql ( $values)

$values

insert (line 58)

Inserts the record into the db

throws: miDBException
access: public

void insert ()

Redefinition of:

miSqlRecord::insert(): Insert a record in the db table It also updates the the PK value of the inserted row

readPK (line 40)

Reads the record from the db by primary key

throws: miDBException
access: public

void readPK (array $values)

array $values: an associative array with the values of each of the primary key columns

Redefinition of:

miSqlRecord::readPK(): Read a record using the specified primary key value

update (line 70)

Updates the record in the db

throws: miDBException
access: public

void update ()

Redefinition of:

miSqlRecord::update(): Update a record in the db table

Inherited Methods

Inherited From miSqlRecord

miSqlRecord::__construct()
miSqlRecord::delete()
miSqlRecord::get()
miSqlRecord::getPK()
miSqlRecord::getPrimaryKeyColumn()
miSqlRecord::getRow()
miSqlRecord::getTableName()
miSqlRecord::insert()
miSqlRecord::read()
miSqlRecord::readPK()
miSqlRecord::set()
miSqlRecord::setRow()
miSqlRecord::update()