Digital Craftsman

Digital Craftsman

Sign in Subscribe

Read models with native queries and the Symfony serializer

Read models with native queries and the Symfony serializer

UPDATE: I've released a package to handle those cases: https://github.com/digital-craftsman-de/deserializing-connection I'm using CQRS in all my projects. It enables me to have processes that are very easy to understand and are independent from each other. As every endpoint has separate read models,

Using Nowdoc instead of single or double quotes for Postgres queries in PHP

Using Nowdoc instead of single or double quotes for Postgres queries in PHP

When using aliases in a Postgres SQL query, you need to use double quotes in your query. $sql = ' SELECT facility.facility_id AS "facilityId" FROM facility '; When using strings (for example to build JSON objects), you need to use single quotes in your query. $sql = "

Automatically register doctrine types in Symfony with compiler pass

Automatically register doctrine types in Symfony with compiler pass

I'm using more and more value objects in my projects. To integrate them with doctrine, I also create custom doctrine types. Usually you have to register them manually one by one. But you can also register them through a compiler pass to make your live easier. To register

Add XDebug to unstable PHP version

Add XDebug to unstable PHP version

My packages support the two latest minor versions of PHP. As the first alpha of PHP 8.3 was just released, I'm upgrading the packages to PHP 8.3 and dropping PHP 8.1 from them. This way I'm able to use readonly for my classes.

Reduce input of functions to improve readability

Reduce input of functions to improve readability

One of the elements we evaluate when reading a function call are the parameters given to it. To understand what's happening inside (not how, just what) it's necessary to see the relevant data as part of the function call. Counterintuitiv, this sometimes means to increase the

Where and how to use abstraction

Where and how to use abstraction

Abstraction is one if the first things a developer learns when starting programming. It's repeated again and again from "Clean Code" to every other introduction book. It's so ingrained, that we don't really question why. As most developers I also started to

Delete JSON property in Postgres

Delete JSON property in Postgres

When migrating JSON data in Postgres, it's often necessary to delete properties within a JSON object. There's a neat operator for it #-. In this example the property comment was stored as an empty string instead of the property just missing. So we delete the property

Beware of adding or subtracting a month from DateTime

Beware of adding or subtracting a month from DateTime

When subtracting a month from 31.03.2022, what should be the result? There isn't really a "right" answer, because it's kind of an invalid query without additional context. Do you want to receive the end of the previous month? Do you want to

Remove unnecessary polyfills from composer

Remove unnecessary polyfills from composer

Frameworks like Symfony and packages include a lot of polyfills. Not just for extensions but also for older PHP versions. It's not really a bad thing, I use it myself in one of my packages. As far as I'm aware, having them installed has no measurable

Working with time

Working with time

When working with time in general, there are a few concepts that can be used and might make sense. There are "dates", "time of day" and "moments in time". Unfortunately PHP only contains one construct (DateTime) to handle "moments in time" but

Reduced complexity in HandlerWrapper of CQRS bundle

Reduced complexity in HandlerWrapper of CQRS bundle

Two days ago I released a new version (0.5.0) of the CQRS bundle for Symfony. It contains the following changes. Reduced complexity in the HandlerWrapper Previously the HandlerWrapper contained 4 steps: * prepare * catch * then * finally When looking through the implementations, I realized that there are no cases that

Package for Id and IdList value objects with Symfony

Package for Id and IdList value objects with Symfony

Just recently I wrote about how I handle ids and id lists as value objects in my projects. Shortly after, I realised that the version I'm using isn't the same in all the projects and decided to streamline them and move them into an open source

Using id value objects for better readability and type safety

Using id value objects for better readability and type safety

When I stared my development career, the usual identifiers for any entity was an unsigned integer. After a while this was replaced by UUIDs which limit the amount of syncing necessary and meant that it's possible to fill an entity with all data including the id without the

Explicit code to reduce cost of change

Explicit code to reduce cost of change

I came to realize that most problems (bugs, higher costs of change, wrong estimations) in the projects I'm involved with, where due to implicit logic in the business domain. What do I mean with implicit logic in the business domain? Things like the following: class ProjectController { public function

Using CQRS in Symfony

Using CQRS in Symfony

Symfony is really great for building APIs very fast. Especially when using a CRUD / REST methodology. Simply because there are a lot of resources and tools build-in (API platform, request parameter converter, dependency injection into controller methods, ...). There is not that much support for building apps with CQRS. On the

Overwrite APP_ENV in PHPUnit

Overwrite APP_ENV in PHPUnit

Important when you're using something like Docker where you inject the env variables directly into the environment rather than just pulling them from a .env file with a PHP dotenv component. Make sure to use force="true" in your phpunit.xml.dist like: <phpunit ...>

Login throttling with Symfony and multiple server instances

Login throttling with Symfony and multiple server instances

Login throttling is possible with Symfony out of the box since 5.2. But the default configuration doesn't work as soon as you have multiple server instances. Why? Because it stores the relevant data on the local filesystem. So all we need to do is to exchange the

Use Vue modifiers to make form handling with Vuetify easier

Use Vue modifiers to make form handling with Vuetify easier

Vue contains two very convenient v-model modifiers for trim and number. Using them means that the models are only updated after the trim or number conversion are done, which means we don't have to do those things ourself anymore. As an example let's say we have

Typed constants with Record in Typescript

Typed constants with Record in Typescript

When I define types in Typescript, I also define a list of valid options as an object so that I can reference it in the rest of my code. A type definition for a currency would for example with a list would look like the following. export type Currency = '

Reuse custom PHP Docker image for job queue in Docker compose

Reuse custom PHP Docker image for job queue in Docker compose

Depending on your setup, most likely you want to run the job queue container with the same image as the php container. Most time I see people executing the running php container and starting a job queue directly in there. A nicer way is to simply run a copy of

Beware of APP_DEBUG='false'

Beware of APP_DEBUG='false'

Symfony contains a great way to use environment variables in the service configuration. With the environment processor it's possible to supply bool variables the following way. # Subscribers App\EventSubscriber\ExceptionSubscriber: arguments: $areAllExceptionsTranslated: '%env(bool:ARE_ALL_EXCEPTIONS_TRANSLATED)%' tags: [kernel.event_subscriber] The related configuration in

Format localized Vuetify datepicker value with Vue mixin

Format localized Vuetify datepicker value with Vue mixin

The example for showing a formatted date in a datepicker with Vuetify uses a computed property to format the value in the text field. Something like this: <v-menu> <template v-slot:activator="{ on }"> <v-text-field :value="formattedDate" :label="$t('domain.manageFunds.

Add color to your bash script

Add color to your bash script

Longer scripts with a lot of output get confusing fast. A nice change of pace is working with colors there. For this you can use ANSI escape codes [https://en.wikipedia.org/wiki/ANSI_escape_code#Colors]. In a script this might look like this: RED='\033[0;31m&

Type cast value objects in twig

Type cast value objects in twig

When working with value objects, it might make sense to typecast them within a twig template. Out of the box twig doesn't offer typecasting. But it's quite easy to offer it with a custom filter. Here is an example how the most basic castings would look

Switch between major composer versions

Switch between major composer versions

We all should be on composer 2 now for a while, but apparently not everybody is yet. It's very simple to upgrade, but also to downgrade. Upgrade with: composer self-update --2 And the downgrade is basically the same: composer self-update --1 I guess this will stay the same