Blog

Details
Category: Databases

JSON format is becoming very popular for exchanging data between systems. Latest versions of MySQL supports json data types and here are some samples on how you can implement queries:

 

Assuming you have a table named users with a JSON column named data, and the data in the data column looks like this:

id name data
1 John {"age": 30, "email": "This email address is being protected from spambots. You need JavaScript enabled to view it."}
2 Jane {"age": 25, "email": "This email address is being protected from spambots. You need JavaScript enabled to view it."}
3 Michael {"age": 35, "email": "This email address is being protected from spambots. You need JavaScript enabled to view it."}

 

 

Select all rows where a specific key exists in the JSON data:

SELECT * FROM users WHERE JSON_CONTAINS(data, '{"email": "This email address is being protected from spambots. You need JavaScript enabled to view it."}');

This query will return the row with id 1, as it contains the specified email address in the JSON data.

 

Select all rows where a specific key exists and its value matches:

Details
Category: Symfony Framework

To interact with Elasticsearch from a service class using Symfony, you'll need to use the Elasticsearch PHP client, which provides a convenient way to perform CRUD operations on the Elasticsearch cluster. Here's an example of how you can achieve this:

 

Install the Elasticsearch PHP client via Composer:

composer require elasticsearch/elasticsearch

 

Create the Symfony service class that will interact with Elasticsearch:
Assuming you have a Symfony project set up, create a new service class (e.g., ElasticsearchService) under the src/Services directory:

Details
Category: Symfony Framework

To implement pub-sub with RabbitMQ in Symfony, you may follow these steps:

 

Set up RabbitMQ:

Install RabbitMQ on your system or use a hosted RabbitMQ service.
Make sure you have the necessary credentials (username, password) to connect to RabbitMQ.


Install RabbitMQ Bundle:

In your Symfony project, use the RabbitMQ Bundle to integrate RabbitMQ easily. Install the bundle using Composer:

composer require enqueue/amqp-bundle

 

Configuration:
Configure the RabbitMQ connection in the config/packages/enqueue.yaml file:

enqueue:
    transport:
        default: 'amqp://guest:guest@localhost/%2f' # Replace with your RabbitMQ connection details

Details
Category: Symfony Framework

It is a very common use case to upload a file along with other input data when dealing with Symfony forms. When you have a form that involves a one to many or many to many relationships, you may follow this example:

 

Prerequisites:

 

To allow users to upload a files in the previous example, we'll modify the AuthorType form to include a FileType field that will enable the uploading of files associated with each author. Additionally, we'll update the BookType form to enable file uploads for each author. Let's assume we want to add a file upload field for the "avatar" of each author.

 

Update the Author Entity:

Add a new property to the "Author" entity to store the avatar image filename.

// src/Entity/Author.php
namespace App\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 */
class Author
{
    // ... other properties and annotations ...

    /**
     * @ORM\Column(type="string", nullable=true)
     */
    private $avatarFilename;

    // ... getters and setters ...
}

 

Update the AuthorType Form:
Update the "AuthorType" form to include a FileType field for the avatar upload.