No unsigned columns in test suite tables about cakephp

10th Dec 2009, Predominant said:

---

(Comment by: mensler)

Changes:
version:1.2.5
type:bug
title:No unsigned columns in test suite tables

10th Dec 2009, Predominant said:

---

(Comment by: mark_story)

BIGINT() is not a supported integer length at this point in time. Only INT() is supported.

Moving to enhancement as this is a limitation of the underlying ORM.

Changes:
version:1.3-dev
type:enhancement

30th Aug 2012, Mark Story said:

---

Bigint support will be part of 2.3.0

30th Aug 2012, euromark said:

---

but does that solve the initial issue? with "unsigned" not being supported?

30th Aug 2012, Mark Story said:

---

I guess not. I missed the unsigned part, and only saw the references to bigint's.

30th Aug 2012, euromark said:

---

also, allowing unsigned columns outside of the test suite (in the app itself) would probably be outside the scope of this ticket but still quite interesting.

1st Aug 2013, luke83 said:

---

In the diff file attached there are little changes to handle unsigned in Mysql DboSource.

Using this code schema console is able to handle unsigned fields in generate/create/update feature.

AllDatabase test cases pass with no failure.

This patch should fix #17, #2396 and #278

PS: Another solution (waiting core fix) to avoid core touching is to use this (inefficient) class as DataSource:

<?php

App::uses('Mysql', 'Model/Datasource/Database');

class iMysql extends Mysql {
    public function describe($model) {
        $fields = parent::describe($model);
        $table = $this->fullTableName($model);

        $cols = $this->_execute('SHOW FULL COLUMNS FROM ' . $table);
        if (!$cols) {
            throw new CakeException(__d('cake_dev', 'Could not describe table for %s', $table));
        }

        while ($column = $cols->fetch(PDO::FETCH_OBJ)) {
            $fields[$column->Field]['unsigned'] = strpos($column->Type, 'unsigned') !== false;
        }

        return $fields;
    }

    protected function _buildFieldParameters($columnString, $columnData, $position) {
        if ($position == 'beforeDefault' && isset($columnData['unsigned']) && $columnData['unsigned']) {
            $columnString .= ' UNSIGNED';
        }
        return parent::_buildFieldParameters($columnString, $columnData, $position);
    }

}

[lorenzo]

I think that for schemas that are very database specific developers should use a different Fixture base class, there is no need for CakePHP to cover every mysql-ism when there are better options available for managing schemas like that. One example is this plugin https://github.com/lorenzo/cakephp-fixturize