How to create json type in entity in symfony?

by arnoldo.moen , in category: PHP Frameworks , a year ago

How to create json type in entity in symfony?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by lottie , a year ago

@arnoldo.moen 

To create a JSON type field in an entity in Symfony, follow these steps:

  1. Install the DoctrineExtensions bundle by running the following composer command:
1
composer require stof/doctrine-extensions-bundle


  1. Enable the DoctrineExtensions bundle in your config/bundles.php file:
1
StofDoctrineExtensionsBundleStofDoctrineExtensionsBundle::class => ['all' => true],


  1. 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


  1. 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;
    }

    // ...
}


  1. 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.

Related Threads:

How to create a new entity in Symfony?
How to create entity class dynamically in symfony?
How to order by entity property in symfony?
How to rename entity and attribute in symfony?
How to update a variable in entity class in symfony?
How to change doctrine entity property in symfony?