josueeek/doctrine-point-type

Package Point for doctrine

dev-master 2019-12-26 18:01 UTC

Requires

• php: >=7.1
• doctrine/dbal: ^2.5 || ^2.6 || ^2.9

Requires (Dev)

• phpunit/phpunit: ^6.0

MIT

• Josue

README

Versions:

Version	PHP Version
1.*	7.0
2.*	7.1 or higher

How to use

First, composer install:

composer require josueeek/doctrine-point-type

After, add in your bootstrap:

use Doctrine\DBAL\Types\Type;

$em = YourEntityManager();

Type::addType('point', 'Josue\PointType');

// in case silex :)
$em->getConnection()->getDatabasePlatform()->registerDoctrineTypeMapping('point', 'point');

Or add it in your app/config yml files

doctrine:
    dbal:
        types:
            point: Josue\PointType
        default_connection: default
        connections:
            default:
                driver: pdo_mysql
                host: '%database_host%'
                port: '%database_port%'
                dbname: '%database_name%'
                user: '%database_user%'
                password: '%database_password%'
                charset: UTF8
                mapping_types:
                    point: point

Exclusive to symfony 4

In your controller, below the namespace, call the file

namespace App\Controller;

use Josue\Point;
use App\Entity\GeoLocation;

In your entity create a point type file

   *  
   * @ORM\Column(name="GeoLocation", type="point")
   */
   private $GeoLocation;
   
   public function getGeoLocation()
   {
       return $this->GeoLocation;
   }
   public function setGeoLocation($GeoLocation)
   {
      $this->GeoLocation = $GeoLocation;
      return $this;
   }

You should now configure your file doctrine.yaml

    dbal:
        types:
            point: Josue\PointType
        mapping_types:
            point: point

Now it's just enjoy, and good young work!!!