doctrine - Digital Craftsman

Digital Craftsman

Sign in Subscribe

doctrine

A collection of 15 posts

Import database from dump with Doctrine and Symfony

Import database from dump with Doctrine and Symfony

There are tickets where you have to import a database over and over again. For this it's awesome if you have some kind of automation going. Turns out there is one so easy in Symfony that you don't even think of it. A simple Symfony console

Order by list with Doctrine

Order by list with Doctrine

Ordering by values is super simple with Doctrine with build in functionality. But have you tried order by a specific list of statuses? Without having every status assigned a number and the number stored in the database? There is a function in MySQL that can do this. It's

You might not want to use entity manager / repository in a Doctrine migration

You might not want to use entity manager / repository in a Doctrine migration

But why? It's so appealing. The simple answer: You're going to loose the opportunity to run the migrations from the beginning. Let me explain: Usually you're able to put your initial database schema in the initial migration and with every change, create a new

Query for JSON list in MySQL with Doctrine

Query for JSON list in MySQL with Doctrine

Working with JSON is not as easy in MySQL as in other databases. But even in MySQL there are ways to add more complex queries through Doctrine. In this example we have an entity Change with a details field of type JSON in the database in MySQL and array in

Use inner join in doctrine query builder

Use inner join in doctrine query builder

Usually all joined entities are automatically joined and returned by Doctrine. Depending on the fetch (EAGER or LAZY). This is done directly or not. But when you want to filter depending on joined columns, you have to join manually. You can use strings for this or use the constants provided

Define default value in Doctrine annotation

Define default value in Doctrine annotation

Setting defaults on the database level makes a lot of sense to prevent the chance of issues arising in the application. Having the configuration for it in the Doctrine annotations makes things easier because you can also automatically generate migrations for it. In MySQL the keyword to use is DEFAULT.

Find JSON element in MySQL

Find JSON element in MySQL

MySQL isn't really build for searching through JSON data. PostgreSQL seems to be way better in this regard. Nether the less it is possible to search since MySQL 5.7. To do so use the MySQL function JSON_CONTAINS. In our example we have a table called client_

Flush entity manager on object when many objects are in use

Flush entity manager on object when many objects are in use

Update: The the meantime using an object as parameter for the flus method was deprecated. Turns out, it's also not a good idea to manage this on your own. What we do now for message queues is to manually clear the entity manager with $entityManager->clear() after

Search in Doctrine JSON Type

Search in Doctrine JSON Type

I'm working on an API project at the moment. The API is build with a simple Symfony / MySQL (through Doctrine) stack. One of the requirements added was a search function. Previously this wasn't an issue because all fields that had to be searched where MySQL columns.

Get translatable entity from repository with specific locale

Get translatable entity from repository with specific locale

I wanted to have translatable entities in my project. So I used Gedmo translatable through the doctrine extensions bundle for Symfony. When using any kind of entity repository, a listener automatically pulls the right translation according to the current locale (from request or the default one). This is a really

Multiple updates with one MySQL query

Working with a database with millions of rows poses a few challenges. One of them: Updating every row with unique data. Working with doctrine is basically impossible with such a big table as it's going to fill up your memory in no time. One possible solution is to

Doctrine flush listener with flush in it

A project I work on has the requirement to fire a webhook every time the status of an entity - lets call it Transaction - has changed. To have the system still scalable, the webhook is not triggered directly, but added as its own entity into the database (and triggered

"IS NOT NULL" expression with Symfony query builder

I searched for a easy way to get values that contain a not null in the where clause. That's what I came up with: $repo = $this->getDoctrine()->getRepository('LiplexBundle:User'); $query = $repo ->createQueryBuilder('u') ->where('u.

Doctrine ArrayCollection in a human readable format

I'm persisting a field of type ArrayCollection to a MySQL database which contains only stings. The database field is of type=array in the ORM definition and of type TEXT in the database. /** * @var ArrayCollection * * @ORM\Column(name="currencies", type="array") */ private $currencies; When

Get executed query in Doctrine

I created a complex native query which is populated with quite a few parameters. When executed it didn't deliver the expected result. To send the query to the database I use the following code: $this->getEntityManager() ->getConnection() ->executeQuery($query, $parameter, $types) ->