SQLServer2008Platform.php 3.67 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
<?php
/*
 * 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
Benjamin Eberlei's avatar
Benjamin Eberlei committed
16
 * and is licensed under the MIT license. For more information, see
17 18 19 20 21 22
 * <http://www.doctrine-project.org>.
 */

namespace Doctrine\DBAL\Platforms;

/**
23
 * Platform to ensure compatibility of Doctrine with Microsoft SQL Server 2008 version.
24 25 26 27 28 29
 *
 * Differences to SQL Server 2005 and before are that a new DATETIME2 type was
 * introduced that has a higher precision.
 */
class SQLServer2008Platform extends SQLServer2005Platform
{
30 31 32 33 34 35 36 37 38 39
    /**
     * {@inheritDoc}
     */
    public function getListTablesSQL()
    {
        // "sysdiagrams" table must be ignored as it's internal SQL Server table for Database Diagrams
        // Category 2 must be ignored as it is "MS SQL Server 'pseudo-system' object[s]" for replication
        return "SELECT name, SCHEMA_NAME (uid) AS schema_name FROM sysobjects WHERE type = 'U' AND name != 'sysdiagrams' AND category != 2 ORDER BY name";
    }

40
    /**
41
     * {@inheritDoc}
42 43 44 45 46 47 48 49 50
     */
    public function getDateTimeTypeDeclarationSQL(array $fieldDeclaration)
    {
        // 3 - microseconds precision length
        // http://msdn.microsoft.com/en-us/library/ms187819.aspx
        return 'DATETIME2(6)';
    }

    /**
51
     * {@inheritDoc}
52 53 54 55 56 57 58
     */
    public function getDateTypeDeclarationSQL(array $fieldDeclaration)
    {
        return 'DATE';
    }

    /**
59
     * {@inheritDoc}
60 61 62 63 64
     */
    public function getTimeTypeDeclarationSQL(array $fieldDeclaration)
    {
        return 'TIME(0)';
    }
Steve Müller's avatar
Steve Müller committed
65

66 67 68 69 70 71 72
    /**
     * {@inheritDoc}
     */
    public function getDateTimeTzTypeDeclarationSQL(array $fieldDeclaration)
    {
        return 'DATETIMEOFFSET(6)';
    }
73

74
    /**
75
     * {@inheritDoc}
76 77 78 79 80
     */
    public function getDateTimeFormatString()
    {
        return 'Y-m-d H:i:s.u';
    }
81

82
    /**
83
     * {@inheritDoc}
84 85 86 87 88 89
     */
    public function getDateTimeTzFormatString()
    {
        return 'Y-m-d H:i:s.u P';
    }

90
    /**
91 92
     * {@inheritDoc}
     */
93 94 95 96 97 98
    public function getDateFormatString()
    {
        return 'Y-m-d';
    }

    /**
99 100
     * {@inheritDoc}
     */
101 102 103 104
    public function getTimeFormatString()
    {
        return 'H:i:s';
    }
105 106

    /**
107 108
     * {@inheritDoc}
     *
109 110 111 112 113
     * Adding Datetime2 Type
     */
    protected function initializeDoctrineTypeMappings()
    {
        parent::initializeDoctrineTypeMappings();
114
        $this->doctrineTypeMapping['datetime2'] = 'datetime';
115 116
        $this->doctrineTypeMapping['date'] = 'date';
        $this->doctrineTypeMapping['time'] = 'time';
117
        $this->doctrineTypeMapping['datetimeoffset'] = 'datetimetz';
118
    }
119 120 121 122 123 124 125 126

    /**
     * {@inheritdoc}
     *
     * Returns Microsoft SQL Server 2008 specific keywords class
     */
    protected function getReservedKeywordsClass()
    {
127
        return Keywords\SQLServer2008Keywords::class;
128
    }
129

130
    protected function getLikeWildcardCharacters() : string
131
    {
132
        return parent::getLikeWildcardCharacters() . '[]^';
133
    }
134
}