Doctrine\DBAL: How to add data types when using Xethron/migrations-generator

Hi @mehany,

I also have the same problem.

Do you found the solution?

I use the pack https://github.com/phaza/laravel-postgis for work with PostGis.

I appreciate for your opinion, please, share your experience with us.

Best regards.

Marcio

@marciocar I wish someone more experienced to answer this! what I did does not answer my question the right way! Given that I had a lot of tables, I really needed to get this going, so I end up modifying the vendor file itself right here. I needed to just reverse-generate the modules's attributes for those tables and that served my purpose.

Hi @mehany,

Very thanks,

Your tip was crucial for the solution this problem.

I added GeometryType.php, created by Rauni Lillemets, in vendor\doctrine\dbal\lib\Doctrine\DBAL\Types

I added the geometry type on array doctrineTypeMapping in vendor\doctrine\dbal\lib\Doctrine\DBAL\Platforms\PostgreSqlPlatform.php

   protected function initializeDoctrineTypeMappings()
    {
        $this->doctrineTypeMapping = array(
            ...
            'geometry'  => 'geometry',
        );
    }
    

I altered the file Type.php in vendor\doctrine\dbal\lib\Doctrine\DBAL\Types

Add the constant

const GEOMETRY = 'geometry';

I chanded the const GEOMETRY in array _typesMap

private static $_typesMap = array(
    ...
    self::GEOMETRY => 'Doctrine\DBAL\Types\GeometryType',
);

Run command

php artisan migrate:generate

The result on my migration generated

public function up()
{
    Schema::create('private_area', function(Blueprint $table)
    {
        $table->integer('id', true);
        $table->string('name')->nullable();
        $table->geometry('geom')->nullable()->index('idx_private_area_geom');
    });
}   

Very very thanks @mehany,

GeometryType.php

namespace Doctrine\DBAL\Types;

use Doctrine\DBAL\Platforms\AbstractPlatform;

/**
 * Class for database column "geometry".
 *
 * @author Rauni Lillemets
 */
class GeometryType extends Type {
    const GEOMETRY = 'geometry';
    const SRID = 3301;
    public function getSqlDeclaration(array $fieldDeclaration, AbstractPlatform $platform) {
        return 'geometry';
    }
//Should create WKT object from WKT string. (or leave as WKT string)
    public function convertToPHPValue($value, AbstractPlatform $platform) {
        return $value; //+
    }
//Should create WKT string from WKT object. (or leave as WKT string)
    public function convertToDatabaseValue($value, AbstractPlatform $platform) {
        return $value; //+
    }
    public function getName() {
        return self::GEOMETRY;
    }
    public function canRequireSQLConversion() {
        return true;
    }
//Should give WKT
    public function convertToPHPValueSQL($sqlExpr, $platform) {
        return 'ST_AsText(\''.$sqlExpr.'\') '; //+
    }
//Should create WKB
    public function convertToDatabaseValueSQL($sqlExpr, AbstractPlatform $platform) {
        return 'ST_GeomFromText(\''.$sqlExpr.'\', '.self::SRID.')'; //+
    }
}

I have submitted a pull request at https://github.com/doctrine/dbal/pull/920 with this fix

@marciocar great work putting this together here, I selected your answer as the correct answer because there is a pull request to solve this on DBAL package which should actually contain Geometry data type mapping.

P.S

Pull request was not accepted because:

this type isn't portable across different vendors and thus cannot be added to the core.

So as of now, the type should be written some where then registered like this

     <?php
// in bootstrapping code

// ...

use Doctrine\DBAL\Types\Type;

// ...

// Register my type
Type::addType('mytype', 'My\Project\Types\MyType');

To convert the underlying database type of your new “mytype” directly into an instance of MyType when performing schema operations, the type has to be registered with the database platform as well - I will look into this and refer to https://laracasts.com/discuss/channels/laravel/adding-custom-dbal-to-laravel-5 answer to his own question and update this thread :

<?php
$conn = $em->getConnection();
$conn->getDatabasePlatform()->registerDoctrineTypeMapping('db_mytype', 'mytype');

http://doctrine-orm.readthedocs.org/projects/doctrine-orm/en/latest/cookbook/custom-mapping-types.html

@mehany where is "some where" in bootstrapping code? And where does the second code snippet go?