ramsey / uuid-doctrine Goto Github PK

/**
 * @param AbstractPlatform $platform
 *
 * @return array
 */
public function getMappedDatabaseTypes(AbstractPlatform $platform)
{
    return [self::NAME];
}

$ composer require ramsey/uuid-doctrine --ignore-platform-reqs
Using version ^1.4 for ramsey/uuid-doctrine
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)

Prefetching 2 packages 🎶 💨
  - Downloading (100%)

Package operations: 3 installs, 0 updates, 0 removals
  - Installing paragonie/random_compat (v2.0.15):
  - Installing ramsey/uuid (3.7.3):
  - Installing ramsey/uuid-doctrine (1.4.3):
Writing lock file
Generating autoload files
ocramius/package-versions:  Generating version class...
ocramius/package-versions: ...done generating version class
Symfony operations: 1 recipe (08ddea6376c012d806872174273e8704)
  -  WARNING  ramsey/uuid-doctrine (>=1.3): From github.com/symfony/recipes-contrib:master
    The recipe for this package comes from the "contrib" repository, which is open to community contributions.
    Review the recipe at https://github.com/symfony/recipes-contrib/tree/master/ramsey/uuid-doctrine/1.3

    Do you want to execute this recipe?
    [y] Yes
    [n] No
    [a] Yes for all packages, only for the current installation session
    [p] Yes permanently, never ask again for this project
    (defaults to n): y
  - Configuring ramsey/uuid-doctrine (>=1.3): From github.com/symfony/recipes-contrib:master
Executing script cache:clear [KO]
 [KO]
Script cache:clear returned with error code 1
!!  
!!  In ConnectionFactory.php line 87:
!!                                                                                 
!!    An exception occured while establishing a connection to figure out your pla  
!!    tform version.                                                               
!!    You can circumvent this by setting a 'server_version' configuration value    
!!                                                                                 
!!    For further information have a look at:                                      
!!    https://github.com/doctrine/DoctrineBundle/issues/673                        
!!                                                                                 
!!  
!!  In AbstractPostgreSQLDriver.php line 93:
!!                                                                                 
!!    An exception occurred in driver: SQLSTATE[08006] [7] FATAL:  role "root" do  
!!    es not exist                                                                 
!!                                                                                 
!!  
!!  In PDOConnection.php line 50:
!!                                                            
!!    SQLSTATE[08006] [7] FATAL:  role "root" does not exist  
!!                                                            
!!  
!!  In PDOConnection.php line 46:
!!                                                            
!!    SQLSTATE[08006] [7] FATAL:  role "root" does not exist  
!!                                                            
!!  
!!  
Script @auto-scripts was called via post-update-cmd

class Car
{
    /**
     * @var Uuid
     *
     * @ORM\Id()
     * @ORM\Column(type="uuid")
     */
    private $id;

    /**
     * @var Person
     *
     * @ORM\ManyToOne(targetEntity="Person")
     */
    private $owner;

    /**
     * @return Uuid
     */
    public function getId(): Uuid
    {
        return $this->id;
    }

    /**
     * @return Person
     */
    public function getOwner(): Person
    {
        return $this->owner;
    }
}

class Person
{
    /**
     * @var Uuid
     *
     * @ORM\Id()
     * @ORM\Column(type="uuid")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(type="string")
     */
    private $name;

    /**
     * @return Uuid
     */
    public function getId(): Uuid
    {
        return $this->id;
    }

    /**
     * @return string
     */
    public function getName(): string
    {
        return $this->name;
    }
}

$car = $this->carRepo->findOneById($id);
$car->getOwner()->getId();  /**  returns string */

$car = $this->carRepo->findOneById($id);
$car->getOwner()->getName();
$car->getOwner()->getId();  /** returns UUID */

 if(is_string($this->id))
 {
        $this->id = UUID::fromString($this->id);
 }

$ids = []
Doctrine\ORM\EntityRepository::findBy([
	'id' => $ids,
]);

    return $this
        ->createQueryBuilder('forum', 'forum.id')
        ->select('
            forum
        ')
        ->getQuery()
        ->getResult()
    ;

/**
 * @ORM\Entity
 * @Gedmo\Tree(type="nested")
 */
class Foo
{
    **
     * @ORM\Id
     * @ORM\Column(type="uuid_binary_ordered_time", unique=true)
     */
    protected $id;

    /**
     * @Gedmo\TreeParent
     * @ORM\ManyToOne(targetEntity="Foo", inversedBy="children")
     */
    private $parent = null;

    /**
     * @ORM\OneToMany(targetEntity="Foo", mappedBy="parent")
     */
    private $children;
    
    /**
     * @ORM\ManyToOne(targetEntity="Foo")
     */
    private $root;

    /**
     * @Gedmo\TreeLeft
     * @ORM\Column(type="integer")
     */
    private $lft = null;

    /**
     * @Gedmo\TreeRight
     * @ORM\Column(type="integer")
     */
    private $rgt = null;

    __construct()
    {
        $this->id = Uuid\Uuid::uuid1();
        $this->children = new ArrayCollection();
    }
}

[2020-03-06 23:40:38] doctrine.DEBUG: INSERT INTO foo (lft, rgt, name, id) VALUES (?, ?, ?, ?) {"1":0,"2":0,"3":"EG","4":"[object] (Ramsey\\Uuid\\Uuid: \"cb3bd9a0-602d-11ea-bf3f-0242be8c6bde\")"} []

[2020-03-06 23:40:38] doctrine.DEBUG: UPDATE foo SET root_id = ?, lft = 1, rgt = 2 WHERE id = ? ["[object] (Ramsey\\Uuid\\Uuid: \"cb3bfcb4-602d-11ea-982c-0242be8c6bde\")","[object] (Ramsey\\Uuid\\Uuid: \"cb3bfcb4-602d-11ea-982c-0242be8c6bde\")"] []

PHP Fatal error:  Call to undefined method Doctrine\DBAL\Platforms\MySqlPlatform::getBinaryTypeDeclarationSQL() in /vendor/ramsey/uuid-doctrine/src/UuidBinaryType.php on line 43

    /**
     * @var \Ramsey\Uuid\Uuid
     *
     * @ORM\Id
     * @ORM\Column(type="uuid", unique=true)
     * @ORM\GeneratedValue(strategy="CUSTOM")
     * @ORM\CustomIdGenerator(class="Ramsey\Uuid\Doctrine\UuidGenerator")
     */
    protected $id;

<?php
/**
 * @copyright   2016 Oversell. All rights reserved
 * @author      Oversell
 *
 * @link        http://oversell.tk
 */

namespace CoreMarketplaceBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * StoreMonitoredProducts
 *
 * @ORM\Table(name="Ubersell.StoreMonitoredProducts", indexes={@ORM\Index(name="storeMonitoredProductId", columns={"storeMonitoredProductId"})})
 * @ORM\Entity
 */
class StoreMonitoredProducts
{
    /**
	 * @var \Ramsey\Uuid\Uuid
	 *
	 * @ORM\Id
	 * @ORM\Column(type="uuid", unique=true)
	 * @ORM\GeneratedValue(strategy="CUSTOM")
	 * @ORM\CustomIdGenerator(class="Ramsey\Uuid\Doctrine\UuidGenerator")
     */
    private $storeMonitoredProductId;

	/**
	 * @var integer
	 *
	 * @ORM\Column(name="sourceMonitoredProductId", type="integer", nullable=false)
	 * @ORM\ManyToOne(targetEntity="SourceMonitoredProducts")
	 * @ORM\JoinColumn(name="sourceMonitoredProductId", referencedColumnName="sourceMonitoredProductId")
	 */
	private $sourceMonitoredProductId;

	/**
	 * @var \Ramsey\Uuid\Uuid
	 *
	 * @ORM\Id
	 * @ORM\Column(type="uuid", unique=true)
	 * @ORM\GeneratedValue(strategy="CUSTOM")
	 * @ORM\CustomIdGenerator(class="Ramsey\Uuid\Doctrine\UuidGenerator")
	 */
	private $apiAccessId;

	/**
	 * @var integer
	 *
	 * @ORM\Column(name="marketplaceId", type="integer", nullable=false)
	 */
	private $dropMarketplaceId;

	/**
	 * @var string
	 *
	 * @ORM\Column(name="siteId", type="string", nullable=false)
	 */
	private $dropSiteId;

	/**
	 * @var string
	 *
	 * @ORM\Column(name="itemName", type="string", nullable=false)
	 */
	private $itemName;

	/**
	 * @var integer
	 *
	 * @ORM\Column(name="quantity", type="integer", nullable=false)
	 */
	private $dropQuantity = 0;

	/**
	 * @var double
	 *
	 * @ORM\Column(name="price", type="decimal", precision=12, scale=2, nullable=false)
	 */
	private $dropPrice = 0;

	/**
	 * @var integer
	 *
	 * @ORM\Column(name="category", type="integer", nullable=false)
	 */
	private $dropCategory;

	/**
	 * @var double
	 *
	 * @ORM\Column(name="breakEven", type="decimal", precision=4, scale=2, nullable=false)
	 */
	private $breakEven = 21;

	/**
	 * @var double
	 *
	 * @ORM\Column(name="desiredProfit", type="decimal", precision=4, scale=2, nullable=false)
	 */
	private $desiredProfit = 10;

	/**
	 * @var \DateTime
	 *
	 * @ORM\Column(name="lastUpdate", type="datetime", nullable=true)
	 */
	private $lastUpdate;

	/**
	 * @var \Ramsey\Uuid\Uuid
	 *
	 * @ORM\Id
	 * @ORM\Column(type="uuid", unique=true)
	 * @ORM\GeneratedValue(strategy="CUSTOM")
	 * @ORM\CustomIdGenerator(class="Ramsey\Uuid\Doctrine\UuidGenerator")
	 */
	private $productDataId;

	/**
	 * @var double
	 *
	 * @ORM\Column(name="profit", type="decimal", precision=10, scale=2, nullable=false)
	 */
	private $profit = 0;

	/**
	 * @var integer
	 *
	 * @ORM\Column(name="views", type="integer", nullable=false)
	 */
	private $views = 0;

	/**
	 * @var integer
	 *
	 * @ORM\Column(name="watchers", type="integer", nullable=false)
	 */
	private $watchers = 0;

	/**
	 * @var integer
	 *
	 * @ORM\Column(name="sold", type="integer", nullable=false)
	 */
	private $sold = 0;

	/**
	 * @var double
	 *
	 * @ORM\Column(name="sellingRatio", type="decimal", precision=5, scale=2, nullable=false)
	 */
	private $sellingRatio = 0;

	/**
	 * @return \Ramsey\Uuid\Uuid
	 */
	public function getStoreMonitoredProductId()
	{
		return $this->storeMonitoredProductId;
	}

	/**
	 * @param \Ramsey\Uuid\Uuid $storeMonitoredProductId
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setStoreMonitoredProductId(\Ramsey\Uuid\Uuid $storeMonitoredProductId)
	{
		$this->storeMonitoredProductId = $storeMonitoredProductId;

		return $this;
	}

	/**
	 * @return int
	 */
	public function getSourceMonitoredProductId()
	{
		return $this->sourceMonitoredProductId;
	}

	/**
	 * @param int $sourceMonitoredProductId
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setSourceMonitoredProductId($sourceMonitoredProductId)
	{
		$this->sourceMonitoredProductId = $sourceMonitoredProductId;

		return $this;
	}

	/**
	 * @return \Ramsey\Uuid\Uuid
	 */
	public function getApiAccessId()
	{
		return $this->apiAccessId;
	}

	/**
	 * @param \Ramsey\Uuid\Uuid $apiAccessId
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setApiAccessId(\Ramsey\Uuid\Uuid $apiAccessId)
	{
		$this->apiAccessId = $apiAccessId;

		return $this;
	}

	/**
	 * @return int
	 */
	public function getDropMarketplaceId()
	{
		return $this->dropMarketplaceId;
	}

	/**
	 * @param int $dropMarketplaceId
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setDropMarketplaceId($dropMarketplaceId)
	{
		$this->dropMarketplaceId = $dropMarketplaceId;

		return $this;
	}

	/**
	 * @return string
	 */
	public function getDropSiteId()
	{
		return $this->dropSiteId;
	}

	/**
	 * @param string $dropSiteId
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setDropSiteId($dropSiteId)
	{
		$this->dropSiteId = $dropSiteId;

		return $this;
	}

	/**
	 * @return string
	 */
	public function getItemName()
	{
		return $this->itemName;
	}

	/**
	 * @param string $itemName
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setItemName($itemName)
	{
		$this->itemName = $itemName;

		return $this;
	}

	/**
	 * @return int
	 */
	public function getDropQuantity()
	{
		return $this->dropQuantity;
	}

	/**
	 * @param int $dropQuantity
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setDropQuantity($dropQuantity)
	{
		$this->dropQuantity = $dropQuantity;

		return $this;
	}

	/**
	 * @return float
	 */
	public function getDropPrice()
	{
		return $this->dropPrice;
	}

	/**
	 * @param float $dropPrice
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setDropPrice($dropPrice)
	{
		$this->dropPrice = $dropPrice;

		return $this;
	}

	/**
	 * @return int
	 */
	public function getDropCategory()
	{
		return $this->dropCategory;
	}

	/**
	 * @param int $dropCategory
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setDropCategory($dropCategory)
	{
		$this->dropCategory = $dropCategory;

		return $this;
	}

	/**
	 * @return float
	 */
	public function getBreakEven()
	{
		return $this->breakEven;
	}

	/**
	 * @param float $breakEven
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setBreakEven($breakEven)
	{
		$this->breakEven = $breakEven;

		return $this;
	}

	/**
	 * @return float
	 */
	public function getDesiredProfit()
	{
		return $this->desiredProfit;
	}

	/**
	 * @param float $desiredProfit
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setDesiredProfit($desiredProfit)
	{
		$this->desiredProfit = $desiredProfit;

		return $this;
	}

	/**
	 * @return mixed
	 */
	public function getLastUpdate()
	{
		return $this->lastUpdate;
	}

	/**
	 * @param mixed $lastUpdate
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setLastUpdate($lastUpdate)
	{
		$this->lastUpdate = $lastUpdate;

		return $this;
	}

	/**
	 * @return \Ramsey\Uuid\Uuid
	 */
	public function getProductDataId()
	{
		return $this->productDataId;
	}

	/**
	 * @param \Ramsey\Uuid\Uuid $productDataId
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setProductDataId(\Ramsey\Uuid\Uuid $productDataId)
	{
		$this->productDataId = $productDataId;

		return $this;
	}

	/**
	 * @return float
	 */
	public function getProfit()
	{
		return $this->profit;
	}

	/**
	 * @param float $profit
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setProfit($profit)
	{
		$this->profit = $profit;

		return $this;
	}

	/**
	 * @return int
	 */
	public function getViews()
	{
		return $this->views;
	}

	/**
	 * @param int $views
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setViews($views)
	{
		$this->views = $views;

		return $this;
	}

	/**
	 * @return int
	 */
	public function getWatchers()
	{
		return $this->watchers;
	}

	/**
	 * @param int $watchers
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setWatchers($watchers)
	{
		$this->watchers = $watchers;

		return $this;
	}

	/**
	 * @return int
	 */
	public function getSold()
	{
		return $this->sold;
	}

	/**
	 * @param int $sold
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setSold($sold)
	{
		$this->sold = $sold;

		return $this;
	}

	/**
	 * @return float
	 */
	public function getSellingRatio()
	{
		return $this->sellingRatio;
	}

	/**
	 * @param float $sellingRatio
	 *
	 * @return StoreMonitoredProducts
	 */
	public function setSellingRatio($sellingRatio)
	{
		$this->sellingRatio = $sellingRatio;

		return $this;
	}
}

Entity 'CoreMarketplaceBundle\\Entity\\StoreMonitoredProducts' has a composite identifier but uses an ID generator other than manually assigning (Identity, Sequence). This is not supported.

	 * @ORM\GeneratedValue(strategy="CUSTOM")
	 * @ORM\CustomIdGenerator(class="Ramsey\Uuid\Doctrine\UuidGenerator")

{
    "status": "success",
    "data": [
        {
            "storeMonitoredProductId": {
                "factory": {
                    "codec": {
                        "builder": {
                            "converter": {}
                        }
                    },
                    "nodeProvider": {
                        "nodeProviders": [
                            {},
                            {}
                        ]
                    },
                    "numberConverter": {},
                    "randomGenerator": {},
                    "timeGenerator": {
                        "nodeProvider": {
                            "nodeProviders": [
                                {},
                                {}
                            ]
                        },
                        "timeConverter": {},
                        "timeProvider": {}
                    },
                    "uuidBuilder": {
                        "converter": {}
                    }
                },
                "codec": {
                    "builder": {
                        "converter": {}
                    }
                },
                "fields": {
                    "time_low": "00532d60",
                    "time_mid": "6a9c",
                    "time_hi_and_version": "58b4",
                    "clock_seq_hi_and_reserved": "c9",
                    "clock_seq_low": "e7",
                    "node": "c566472cfc4c"
                },
                "converter": {}
            },
            "sourceMonitoredProductId": {
                "factory": {
                    "codec": {
                        "builder": {
                            "converter": {}
                        }
                    },
                    "nodeProvider": {
                        "nodeProviders": [
                            {},
                            {}
                        ]
                    },
                    "numberConverter": {},
                    "randomGenerator": {},
                    "timeGenerator": {
                        "nodeProvider": {
                            "nodeProviders": [
                                {},
                                {}
                            ]
                        },
                        "timeConverter": {},
                        "timeProvider": {}
                    },
                    "uuidBuilder": {
                        "converter": {}
                    }
                },
                "codec": {
                    "builder": {
                        "converter": {}
                    }
                },
                "fields": {
                    "time_low": "3fb56ce4",
                    "time_mid": "116e",
                    "time_hi_and_version": "4b74",
                    "clock_seq_hi_and_reserved": "1d",
                    "clock_seq_low": "c3",
                    "node": "55cb537ff992"
                },
                "converter": {}
            },
            "apiAccessId": {
                "factory": {
                    "codec": {
                        "builder": {
                            "converter": {}
                        }
                    },
                    "nodeProvider": {
                        "nodeProviders": [
                            {},
                            {}
                        ]
                    },
                    "numberConverter": {},
                    "randomGenerator": {},
                    "timeGenerator": {
                        "nodeProvider": {
                            "nodeProviders": [
                                {},
                                {}
                            ]
                        },
                        "timeConverter": {},
                        "timeProvider": {}
                    },
                    "uuidBuilder": {
                        "converter": {}
                    }
                },
                "codec": {
                    "builder": {
                        "converter": {}
                    }
                },
                "fields": {
                    "time_low": "00838830",
                    "time_mid": "4405",
                    "time_hi_and_version": "2de4",
                    "clock_seq_hi_and_reserved": "8d",
                    "clock_seq_low": "d3",
                    "node": "a4809a2fe56d"
                },
                "converter": {}
            },
            "dropMarketplaceId": 2,
            "dropMarketplaceName": "ebay",
            "dropSiteId": "110185928902",
            "itemName": "TP Link",
            "dropQuantity": 1,
            "dropPrice": "20.00",
            "breakEven": "21",
            "desiredProfit": "25",
            "lastUpdate": null,
            "sourceMarketplaceId": 1,
            "sourceMarketplaceName": "amazon",
            "sourceSiteId": "B01AK9TC0Y",
            "sourceQuantity": 1,
            "sourcePrice": "198.19",
            "lastScan": null,
            "profit": "0.00",
            "views": 0,
            "watchers": 0,
            "sold": 0,
            "sellingRatio": "0.00"
        },
        {
            "storeMonitoredProductId": {
                "factory": {
                    "codec": {
                        "builder": {
                            "converter": {}
                        }
                    },
                    "nodeProvider": {
                        "nodeProviders": [
                            {},
                            {}
                        ]
                    },
                    "numberConverter": {},
                    "randomGenerator": {},
                    "timeGenerator": {
                        "nodeProvider": {
                            "nodeProviders": [
                                {},
                                {}
                            ]
                        },
                        "timeConverter": {},
                        "timeProvider": {}
                    },
                    "uuidBuilder": {
                        "converter": {}
                    }
                },
                "codec": {
                    "builder": {
                        "converter": {}
                    }
                },
                "fields": {
                    "time_low": "00580116",
                    "time_mid": "6965",
                    "time_hi_and_version": "79d4",
                    "clock_seq_hi_and_reserved": "41",
                    "clock_seq_low": "8b",
                    "node": "a9ef9e948524"
                },
                "converter": {}
            },
            "sourceMonitoredProductId": {
                "factory": {
                    "codec": {
                        "builder": {
                            "converter": {}
                        }
                    },
                    "nodeProvider": {
                        "nodeProviders": [
                            {},
                            {}
                        ]
                    },
                    "numberConverter": {},
                    "randomGenerator": {},
                    "timeGenerator": {
                        "nodeProvider": {
                            "nodeProviders": [
                                {},
                                {}
                            ]
                        },
                        "timeConverter": {},
                        "timeProvider": {}
                    },
                    "uuidBuilder": {
                        "converter": {}
                    }
                },
                "codec": {
                    "builder": {
                        "converter": {}
                    }
                },
                "fields": {
                    "time_low": "7dc36e1a",
                    "time_mid": "a6fc",
                    "time_hi_and_version": "4144",
                    "clock_seq_hi_and_reserved": "79",
                    "clock_seq_low": "f6",
                    "node": "022f6808de57"
                },
                "converter": {}
            },
            "apiAccessId": {
                "factory": {
                    "codec": {
                        "builder": {
                            "converter": {}
                        }
                    },
                    "nodeProvider": {
                        "nodeProviders": [
                            {},
                            {}
                        ]
                    },
                    "numberConverter": {},
                    "randomGenerator": {},
                    "timeGenerator": {
                        "nodeProvider": {
                            "nodeProviders": [
                                {},
                                {}
                            ]
                        },
                        "timeConverter": {},
                        "timeProvider": {}
                    },
                    "uuidBuilder": {
                        "converter": {}
                    }
                },
                "codec": {
                    "builder": {
                        "converter": {}
                    }
                },
                "fields": {
                    "time_low": "00838830",
                    "time_mid": "4405",
                    "time_hi_and_version": "2de4",
                    "clock_seq_hi_and_reserved": "8d",
                    "clock_seq_low": "d3",
                    "node": "a4809a2fe56d"
                },
                "converter": {}
            },
            "dropMarketplaceId": 2,
            "dropMarketplaceName": "ebay",
            "dropSiteId": "110186189158",
            "itemName": "Sandisk",
            "dropQuantity": 1,
            "dropPrice": "20.00",
            "breakEven": "21",
            "desiredProfit": "16",
            "lastUpdate": null,
            "sourceMarketplaceId": 1,
            "sourceMarketplaceName": "amazon",
            "sourceSiteId": "B00VXMY262",
            "sourceQuantity": 1,
            "sourcePrice": "32.14",
            "lastScan": null,
            "profit": "0.00",
            "views": 0,
            "watchers": 0,
            "sold": 0,
            "sellingRatio": "0.00"
        }
    ],
    "draw": 3,
    "recordsTotal": 2,
    "recordsFiltered": 2
}

\Doctrine\DBAL\Types\Type::addType('uuid', 'Ramsey\Uuid\Doctrine\UuidType');
$entityManager->getConnection()->getDatabasePlatform()->registerDoctrineTypeMapping('uuid', 'uuid');

doctrine:
    dbal:
        driver:   pdo_pgsql
        host:     "%database_host%"
        port:     "%database_port%"
        dbname:   "%database_name%"
        user:     "%database_user%"
        password: "%database_password%"
        charset:  UTF8
        mapping_types:
                     citext: string
        types:
            uuid:  Ramsey\Uuid\Doctrine\UuidType

/**
     * @var Uuid
     *
     * @ORM\Column(name="id", type="uuid")
     * @ORM\Id
     * @Expose
     * @Groups({"api-add-chat","api-get-chat"})
     */
    private $id;

/**
     * Set Id
     *
     * @return Chat
     */
    public function setId($id)
    {
        $this->id = $id;

        return $this;
    }


    public function getId()
    {
        return $this->id;
    }

Column       |            Type             |               Modifiers                | Storage  | Stats target |  Description
 id                | uuid                        | not null                               | plain    |              | (DC2Type:uuid)

class Site
{
    /**
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="UUID")
     * @ORM\Column(type="uuid_binary")
     */
    private $id;

    ...
} 

$builder->add('site')

        $datatable = $this->get('training.datatables.training');
        $results = $datatable->createDatatable();

        $serializer = $this->get('sg_datatables.serializer');

        $datatable->setData($serializer->serialize($results, 'json'));

Could not normalize object of type Ramsey\Uuid\Converter\Number\DegradedNumberConverter, no supporting normalizer found.
500 Internal Server Error - UnexpectedValueException

 [Doctrine\DBAL\Exception\NotNullConstraintViolationException]
  An exception occurred while executing 'INSERT INTO wiki_page (id, project_home, title, project_id, current_version_id) VALUES (?, ?, ?, ?, ?)' with params ["ddc1f51a-f5d9-489f-89bb-cd79f3393af0", 1
  , "Technical Reviews Wiki", "5138b185-b10b-48ac-a102-bdea1139c911", null]:
  SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'current_version_id' cannot be null

Exception trace:
 () at /home/vagrant/hive/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:112
 Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() at /home/vagrant/hive/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
 Doctrine\DBAL\DBALException::driverExceptionDuringQuery() at /home/vagrant/hive/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:177
 Doctrine\DBAL\Statement->execute() at /home/vagrant/hive/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:281
 Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() at /home/vagrant/hive/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:1014
 Doctrine\ORM\UnitOfWork->executeInserts() at /home/vagrant/hive/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:378
 Doctrine\ORM\UnitOfWork->commit() at /home/vagrant/hive/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:356
 Doctrine\ORM\EntityManager->flush() at /home/vagrant/hive/src/Odev/Hive/Infrastructure/AppBundle/DataFixtures/ORM/LoadProjectData.php:89
 Odev\Hive\Infrastructure\AppBundle\DataFixtures\ORM\LoadProjectData->load() at /home/vagrant/hive/vendor/doctrine/data-fixtures/lib/Doctrine/Common/DataFixtures/Executor/AbstractExecutor.php:121
 Doctrine\Common\DataFixtures\Executor\AbstractExecutor->load() at /home/vagrant/hive/vendor/doctrine/data-fixtures/lib/Doctrine/Common/DataFixtures/Executor/ORMExecutor.php:88
 Doctrine\Common\DataFixtures\Executor\ORMExecutor->Doctrine\Common\DataFixtures\Executor\{closure}() at n/a:n/a
 call_user_func() at /home/vagrant/hive/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:233
 Doctrine\ORM\EntityManager->transactional() at /dev/shm/app/cache/dev/appDevDebugProjectContainer.php:5645
 DoctrineORMEntityManager_00000000015ce1f5000000002a2c79364ae5d79093a662a969d1540330e84087->transactional() at /home/vagrant/hive/vendor/doctrine/data-fixtures/lib/Doctrine/Common/DataFixtures/Executor/ORMExecutor.php:90
 Doctrine\Common\DataFixtures\Executor\ORMExecutor->execute() at /home/vagrant/hive/vendor/doctrine/doctrine-fixtures-bundle/Command/LoadDataFixturesDoctrineCommand.php:118
 Doctrine\Bundle\FixturesBundle\Command\LoadDataFixturesDoctrineCommand->execute() at /home/vagrant/hive/vendor/symfony/symfony/src/Symfony/Component/Console/Command/Command.php:262
 Symfony\Component\Console\Command\Command->run() at /home/vagrant/hive/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:848
 Symfony\Component\Console\Application->doRunCommand() at /home/vagrant/hive/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:189
 Symfony\Component\Console\Application->doRun() at /home/vagrant/hive/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:80
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /home/vagrant/hive/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:120
 Symfony\Component\Console\Application->run() at /home/vagrant/hive/bin/console:29

class Deuda
{
    use EntityIdTrait;

    /**
     * @var UuidInterface
     *
     * @ORM\Id
     * @ORM\Column(type="uuid", unique=true)
     * @ORM\GeneratedValue(strategy="CUSTOM")
     * @ORM\CustomIdGenerator(class="Ramsey\Uuid\Doctrine\UuidGenerator")
     */
    private $id;

    /**
     * The internal primary identity key.
     *
     * @var UuidInterface|null
     *
     * @ORM\Column(type="uuid", unique=true)
     */
    protected $uuid;

// The rest of the file contains boring getters and setters and more fields

types:
         uuid:  Ramsey\Uuid\Doctrine\UuidType

/**
 * @var \Ramsey\Uuid\UuidInterface
 *
 * @ORM\Id
 * @ORM\Column(type="uuid_binary_ordered_time", unique=true)
 * @ORM\GeneratedValue(strategy="CUSTOM")
 * @ORM\CustomIdGenerator(class="Ramsey\Uuid\Doctrine\UuidOrderedTimeGenerator")
 */
private $id;

public function findById(string $forumId): ?Forum
{
    return $this
        ->createQueryBuilder('forum')
        ->andWhere('forum.id = :forumId')
        ->setParameter('forumId', $forumId)
        ->select('
            forum
        ')
        ->getQuery()
        ->getOneOrNullResult()
    ;
}

findById('37b3c336-4b4d-11ea-ab15-309c23145bb0');
findById(Uuid::fromString('37b3c336-4b4d-11ea-ab15-309c23145bb0'));
findById(Uuid::fromString('37b3c336-4b4d-11ea-ab15-309c23145bb0')->getBytes());

type: entity
id:
    uuid:
        type: uuid_binary
        unique: true
        generator:
            strategy: CUSTOM
        customIdGenerator:
            class: '\Ramsey\Uuid\Doctrine\UuidGenerator'

id:
    uuid:
        type: uuid_binary
        unique: true
        generator:
            strategy: CUSTOM
        customIdGenerator:
            class: '\Ramsey\Uuid\Doctrine\UuidGenerator'
manyToOne:
    owner:
        targetEntity: Entity_1
        cascade: {  }
        fetch: LAZY
        mappedBy: null
        inversedBy: null
        joinColumns:
            owner_id:
                referencedColumnName: uuid
        orphanRemoval: false
lifecycleCallbacks: {  }