I replaced another CMS powered site with an Astro powered static site the other day.
Here is why:
Import data into MySql with docker-compose
Having a docker-compose setup which involves a Database like Mysql or MariaDB, then at some point you might want to import data into those Databases.
There are several ways to import the data in your docker-compose setup.
- Using a volume for import data
- Using mysql client from commandline with docker-compose exec
- Using phpmyadmin in docker-compose setup
- Using a mysql GUI client on the host and connect to the DB in the Docker container
So let’s see how we can do this:
Continue reading “Import data into MySql with docker-compose”Nerdpress on Mastodon
We follow the PHP community and are now also Mastodon! Yay!
Follow us here: https://phpc.social/@nerdpress_org
All our Blog posts will be announced there as on Twitter.
Since we blog a lot about PHP in general and Symfony in particular https://phpc.social seems like a good choice for us as our Mastodon instance.
Continue reading “Nerdpress on Mastodon”Symfony deprecation log channel
Are you annoyed of too many deprecation warnings in you logs of your symfony app?
Probably yes because it is really a lot of noise.
However deprecation logs are still useful to ensure future compatibility of your app.
So since version 5.1 symfony will log deprecations to a dedicated log channel when it exists and ships with this monolog config:
monolog:
channels:
- deprecation # Deprecations are logged in the dedicated "deprecation" channel when it existsCode language: PHP (php)This is added already in the recipe and ships when installing symfony.
Ok, but the handler for this deprecation channel is not configured, so you have to do this yourself.
How? Add this to your monolog config:
Disable SilverStripe deprecation warnings in PHP8.1
Since SilverStripe 4.10 is not yet fully ready for PHP8.1 you wil receive quite some deprecation warnings in dev mode when you are brave and run it nonetheless on PHP8.1.
Deprecated: SilverStripe\Config\Collections\MemoryConfigCollection implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /var/www/html/vendor/silverstripe/config/src/Collections/MemoryConfigCollection.php on line 13
Unfortunatly we can’t control the error_reporting from SilverStripe since it is set in the kernel of the framework.
So we are forced to hack the Kernel which is rather unfortunate.
In the SilverStripe Slack channel someone proposed to use composer-patch which will apply a patch to a given vendor dependency during composer install.
This is quite cool because you don’t need to fork the dependency and take care of getting upstream changes.
So i went this path down and it looks like in this gist:
https://gist.github.com/ivoba/d8c4379236149a8c42e1922ae98a93e3
Testing Deprecations with PHPUnit
When testing deprecations with PHPUnit greater than 9.5.10 you might encounter this error:
Failed asserting that exception of type "PHPUnit\Framework\Error\Deprecated" is thrown.
The code in the test is as follows:
$this->expectDeprecation();
and the code that should be tested is like this:
\trigger_error('foo', \E_USER_DEPRECATED);
Filter a csv file with nodejs streams
So we have a CSV file with a member list and we want to filter all empty emails.
FirstName,LastName,Email Max,Mustermann,max@mustermann.de Maxi,Hasnoemail,
With nodejs streams this is almost a one liner.
We will use the csv package from the CSV project which has some sophisticated packages to parse and transform csv data with nodejs streams.
npm install csv
We will further use node as ESM (ECMAScript modules) to be shiningly modern and so lets create a file: index.mjs
Note the .mjs extension, which will tell node to interprete this as ESM. (Since nodejs v12.20.0 && v14.13.0)
We import the packages and create the filesystem streams to read the file, then built a pipeline with the streams and the single steps to process the data and write the results into a new file.
Ok let’s go:
ImageMagick: unable to read font
I was about to integrate Github Actions to one of my pet projects but the tests failed with:
convert-im6.q16: unable to read font `helvetica' @ error/annotate.c/RenderFreetype/1338.
In the project i was using ImageMagick convert command directly as sub process and obviously some fonts where missing.
Makes sense because i used convert to add text to an image.
Migrating user table from Mysql to Postgres with Symfony and Doctrine
When using bin/console make:entity on Mysql and then later you switch your application to Postgres and you have a table called user, which you most likely have when using security component of Symfony.
Then you will receive an error because user is a reserved word in Postgres!
An exception occurred while executing 'INSERT INTO user (id, email, roles, password, is_verified) VALUES (?, ?, ?, ?, ?)' with params [3, "dev@dev.de", "[]", "your-encrypted-password", 0]:
SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "user"
LINE 1: INSERT INTO user (id, email, roles, password, is_verified) V...
Recreate pruned docker networks with docker-compose
So here is nice chain of docker errors and its solution.
1. Docker has reached its maximum of created networks and errors like this:
ERROR: could not find an available, non-overlapping IPv4 address pool among the defaults to assign to the network
The easiest (and most brute though) solution to this is to prune all networks, as suggested here on SO.
docker network prune
This will delete all networks that are not connected to currently active containers.
But this also means it will delete all networks of your not runnning dev projects.
(Which might be numerous as in my case.)