This bundle provides datatype convertions for SQLServer with Doctrine ORM and RealState
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(),
//...
);
//..
driver_class: \ACSEO\Bundle\SQLServerBundle\Driver\SQLServerDriver
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
Add post-install-cmd to add pdo_dblib line to Doctrine DBAL Driver Manager
"post-install-cmd": [
...
"ACSEO\\Bundle\\SQLServerBundle\\Composer\\ScriptHandler::updateDoctrineDriverManager",
...
],
- write tests
- introduce parameters for encoding text convertion
- explore other data type convertions needed