acseo/sql-server-bundle

There is no license information available for the latest version (dev-master) of this package.

Bundle used to provide data type convertion between Doctrine and MSSQLDriver

Installs: 76

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 4

Forks: 0

Open Issues: 0

Type:symfony-bundle

dev-master / 2.3.x-dev 2014-11-04 13:52 UTC

This package is not auto-updated.

Last update: 2024-11-05 08:37:22 UTC


README

This bundle provides datatype convertions for SQLServer with Doctrine ORM and RealState

Installation

Add the bundle in your composer.json:

{
    "require": {
        "acseo/sql-server-bundle": "dev-master"
    }
}

Now tell composer to download the bundle by running the command:

$ php composer.phar update acseo/sql-server-bundle

Composer will install the bundle to your project's vendor/ACSEO directory.

Enable the bundle in your project

<?php 
//app/AppKernel.php
class AppKernel extends Kernel
{
    public function registerBundles()
    {
        $bundles = array(
        //...
        new ACSEO\Bundle\SQLServerBundle\ACSEOSQLServerBundle(),
		//...
        );
//..

Configuration

In parameters.yml

driver_class: \ACSEO\Bundle\SQLServerBundle\Driver\SQLServerDriver

In app/config/config.yml

Override Doctrine data type, define the class that will perform data type convertions

types:
    string: ACSEO\Bundle\SQLServerBundle\Type\StringType
    datetime: ACSEO\Bundle\SQLServerBundle\Type\DateTimeType
    text: ACSEO\Bundle\SQLServerBundle\Type\TextType

In composer.json

Add post-install-cmd to add pdo_dblib line to Doctrine DBAL Driver Manager

"post-install-cmd": [
            ...
            "ACSEO\\Bundle\\SQLServerBundle\\Composer\\ScriptHandler::updateDoctrineDriverManager",
            ...
        ],

TODO

  • write tests
  • introduce parameters for encoding text convertion
  • explore other data type convertions needed