DataIntegrityTestDefaultEntries

Complexity

Total Complexity

9

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	5

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	update()	0	31	9

<?php


class DataIntegrityTestDefaultEntries extends Object
{
    public static function update($baseTable, $field, $value, $id = 0, $replace = false, $addLive = false)

The parameter $addLive is not used and could be removed.

    {
        $object = DataObject::get_one($baseTable);
        if ($object) {
            $tableArray = array($baseTable);
            if ($object instanceof SiteTree) {
                $tableArray[] = $baseTable."_Live";
            }
            foreach ($tableArray as $table) {
                $value = Convert::raw2sql($value);
                $sql = "UPDATE \"$table\" SET \"$table\".\"$field\" = '$value'";
                $where = array();
                if ($id) {
                    $where[] = "  \"$table\".\"ID\" = ".$id;
                }
                if (!$replace) {
                    $where[] = " \"$table\".\"$field\" IS NULL OR \"$table\".\"$field\" = '' OR \"$table\".\"$field\" = 0 ";
                }
                $wherePhrase = '';
                if (count($where)) {
                    $wherePhrase = " WHERE ( " . implode(") AND (", $where) . " )";
                }
                $result = DB::query("SELECT COUNT(\"$table\".\"ID\") C FROM \"$table\" ".$wherePhrase);
                if ($result && $result->value()) {
                    $sql .= $wherePhrase;
                    DB::query($sql);
                    DB::alteration_message("Updated $field in $table to $value ", "added");
                }
            }
        }
    }
}