models/CSERDmodel/CSERDcomment.php5

<?php

class CSERDcomment extends CSERDModelBase {
    public static $ATTRIBUTES = array(
        'commentId' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_NEVER,
            'type' => 'int'
        ),
        'comment' => array(
            'type' => 'string'
        ),
        'timestamp' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_CHANGED,
            'type' => 'time',
            'default' => ''
        ),
        'reviewId' => array(
            'commit' => SModel2::COMMIT_FIRST,
            'type' => 'int',
            'default' => null,
            'foreign' => array('table' => 'review', 'on' => 'reviewId', 'object' => 'review')
        ),
        'ownerId' => array(
            'commit' => SModel2::COMMIT_FIRST,
            'type' => 'int',
            'default' => null,
            'foreign' => array('table' => 'user', 'on' => 'userId', 'object' => 'owner')
        ),
        'authorId' => array(
            'commit' => SModel2::COMMIT_FIRST,
            'type' => 'int',
            'default' => null,
            'foreign' => array('table' => 'user', 'on' => 'userId', 'object' => 'author')
        ),
        'review' => array(
            'commit' => SModel2::COMMIT_FOREIGN,
            'type' => 'CSERDreview'
        ),
        'owner' => array(
            'commit' => SModel2::COMMIT_FOREIGN,
            'type' => 'CSERDuser'
        ),
        'author' => array(
            'commit' => SModel2::COMMIT_FOREIGN,
            'type' => 'CSERDuser'
        )
    );

    public function __construct($constraints = null, $multi = false) {
        parent::__construct();

        $this->registerAttributes(self::$ATTRIBUTES);
        $this->registerTableName('comment');
        $this->registerPrimaryKey('commentId', true);

        if($constraints !== null)
            $this->populate($constraints, $multi);
    }

    public static function getAttributesStatic() {
        return self::$ATTRIBUTES;
    }

    public static function getTableNameStatic() {
        return 'comment';
    }

    public static function retrieve($constraints = array(), $checkOnly = false) {
        $list = self::getList($constraints, array(1), array(), $checkOnly);
        if(!$list || count($list) == 0)
            return $checkOnly ? false : null;
        else if($checkOnly)
            return $list > 0;
        else
            return $list[0];
    }

    public static function exists($constraints = array()) {
        return self::retrieve($constraints, true);
    }

    public static function retrieveMulti($constraints = array(), $checkOnly = false, $depth = 1) {
        $list = self::getListMulti($constraints, array(1), array(), $checkOnly, $depth);
        if(!$list || count($list) == 0)
            return $checkOnly ? false : null;
        else if($checkOnly)
            return $list > 0;
        else
            return $list[0];
    }

    public static function existsMulti($constraints = array()) {
        return self::retrieveMulti($constraints, true);
    }

    public static function getList($constraints = array(), $limit = array(), $order = array(), $count = false) {
        return parent::getListBase(self::getDBI(), $constraints, $limit, $order, $count, 'CSERDcomment', true);
    }

    public static function getListMulti($constraints = array(), $limit = array(), $order = array(), $count = false, $depth = 1) {
        return parent::getListBaseMulti(self::getDBI(), $constraints, $limit, $order, $count,
                                            'CSERDcomment', true, $depth);
    }


    public function getParentReview() {
        return CSERDreview::retrieve(array('reviewId' => $this->reviewId));
    }

    public function getParentReviewMulti($depth = 1) {
        return CSERDreview::retrieveMulti(array('Base.reviewId' => $this->reviewId), false, $depth);
    }

    public function getParentOwner() {
        return CSERDuser::retrieve(array('userId' => $this->ownerId));
    }

    public function getParentOwnerMulti($depth = 1) {
        return CSERDuser::retrieveMulti(array('Base.userId' => $this->ownerId), false, $depth);
    }

    public function getParentAuthor() {
        return CSERDuser::retrieve(array('userId' => $this->authorId));
    }

    public function getParentAuthorMulti($depth = 1) {
        return CSERDuser::retrieveMulti(array('Base.userId' => $this->authorId), false, $depth);
    }
}

?>

---