How to create json type in entity in symfony?
How to create json type in entity in symfony?
1 answer
by
lottie ,
a year ago
@arnoldo.moen
To create a JSON type field in an entity in Symfony, follow these steps:
- Install the DoctrineExtensions bundle by running the following composer command:
1
|
composer require stof/doctrine-extensions-bundle |
- Enable the DoctrineExtensions bundle in your config/bundles.php file:
1
|
StofDoctrineExtensionsBundleStofDoctrineExtensionsBundle::class => ['all' => true], |
- Configure the DoctrineExtensions bundle in your config/packages/stof_doctrine_extensions.yaml file:
1 2 3 4 5 |
stof_doctrine_extensions:
default_locale: en_US
orm:
default:
timestampable: true
|
- Add the JSON type field in your entity class by using the @ORMColumn annotation:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
use DoctrineORMMapping as ORM;
use StofDoctrineExtensionsBundleMappingAnnotation as Gedmo;
class YourEntity
{
// ...
/**
* @ORMColumn(type="json")
*/
private $jsonField;
// Getters and setters
public function getJsonField()
{
return $this->jsonField;
}
public function setJsonField($jsonField)
{
$this->jsonField = $jsonField;
}
// ...
}
|
- Update your database schema to reflect the changes by running the following command:
1
|
php bin/console doctrine:schema:update --force |
Now, you have successfully created a JSON type field in your entity in Symfony. You can now store and retrieve JSON data in this field.