AbstractAsset.php 4.52 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
<?php
/*
 *  $Id$
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information, see
 * <http://www.doctrine-project.org>.
 */

namespace Doctrine\DBAL\Schema;

24 25
use Doctrine\DBAL\Platforms\AbstractPlatform;

26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
/**
 * The abstract asset allows to reset the name of all assets without publishing this to the public userland.
 *
 * This encapsulation hack is necessary to keep a consistent state of the database schema. Say we have a list of tables
 * array($tableName => Table($tableName)); if you want to rename the table, you have to make sure
 *
 * @license http://www.opensource.org/licenses/lgpl-license.php LGPL
 * @link    www.doctrine-project.org
 * @since   2.0
 * @version $Revision$
 * @author  Benjamin Eberlei <kontakt@beberlei.de>
 */
abstract class AbstractAsset
{
    /**
     * @var string
     */
    protected $_name;

45 46
    protected $_quoted = false;

47 48 49 50 51 52 53
    /**
     * Set name of this asset
     *
     * @param string $name
     */
    protected function _setName($name)
    {
54 55 56
        if ($this->isQuoted($name)) {
            $this->_quoted = true;
            $name = $this->trimQuotes($name);
57
        }
58 59 60
        $this->_name = $name;
    }

61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
    /**
     * Check if this identifier is quoted.
     *
     * @param  string $identifier
     * @return bool
     */
    protected function isQuoted($identifier)
    {
        return (isset($identifier[0]) && ($identifier[0] == '`' || $identifier[0] == '"'));
    }

    /**
     * Trim quotes from the identifier.
     * 
     * @param  string $identifier
     * @return string
     */
    protected function trimQuotes($identifier)
    {
        return trim($identifier, '`"');
    }

83 84 85 86 87 88 89
    /**
     * Return name of this schema asset.
     * 
     * @return string
     */
    public function getName()
    {
90
        return $this->_name;
91
    }
92

93 94 95 96 97 98 99 100 101 102 103 104
    /**
     * Get the quoted representation of this asset but only if it was defined with one. Otherwise
     * return the plain unquoted value as inserted.
     *
     * @param AbstractPlatform $platform
     * @return string
     */
    public function getQuotedName(AbstractPlatform $platform)
    {
        return ($this->_quoted) ? $platform->quoteIdentifier($this->_name) : $this->_name;
    }

105 106 107 108 109 110 111 112
    /**
     * Generate an identifier from a list of column names obeying a certain string length.
     *
     * This is especially important for Oracle, since it does not allow identifiers larger than 30 chars,
     * however building idents automatically for foreign keys, composite keys or such can easily create
     * very long names.
     *
     * @param  array $columnNames
113
     * @param  string $prefix
114 115 116
     * @param  int $maxSize
     * @return string
     */
117
    protected function _generateIdentifierName($columnNames, $prefix='', $maxSize=30)
118
    {
119
        /*$columnCount = count($columnNames);
120 121
        $postfixLen = strlen($postfix);
        $parts = array_map(function($columnName) use($columnCount, $postfixLen, $maxSize) {
122
            return substr($columnName, -floor(($maxSize-$postfixLen)/$columnCount - 1));
123 124
        }, $columnNames);
        $parts[] = $postfix;
125

126 127 128
        $identifier = trim(implode("_", $parts), '_');
        // using implicit schema support of DB2 and Postgres there might be dots in the auto-generated
        // identifier names which can easily be replaced by underscores.
129
        $identifier = str_replace(".", "_", $identifier);
130 131 132 133 134

        if (is_numeric(substr($identifier, 0, 1))) {
            $identifier = "i" . substr($identifier, 0, strlen($identifier)-1);
        }

135 136 137 138 139 140 141
        return $identifier;*/


        $hash = implode("", array_map(function($column) {
            return dechex(crc32($column));
        }, $columnNames));
        return substr(strtoupper($prefix . "_" . $hash), 0, $maxSize);
142
    }
143
}