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