rela589n

WITH period_ranges AS (
    SELECT 
        id, 
        tstzrange(period_start, period_end) AS period
    FROM 
        your_table
), recursive_group AS (
    SELECT 
        id,
        period,

rela589n

<?php

final class PricesHttpClient implements PricesClient
{
    public function __construct(
        // AMPHP http client (https://github.com/amphp/http-client)
        private HttpClient $httpClient,
    ) {
    }

rela589n

#[AsDoctrineListener(event: ToolEvents::postGenerateSchema)]
final readonly class QuestionForeignKeyListener
{
    /** @throws SchemaException */
    public function postGenerateSchema(GenerateSchemaEventArgs $eventArgs): void
    {
        $schema = $eventArgs->getSchema();

        $table = $schema->getTable('answers');

rela589n

// warning: this approach is error-prone in case if there's a doctrine's lazy-entity proxy! 
// when trying to call getQuestion() method on such non-initialized object, "property not initialized" error will come up

trait ManyToOneOtherEntityRelationshipMappingTrait
{
    protected Question $question;

    #[ORM\Column(type: 'uuid')]
    private Uuid $questionId;

rela589n

Useful commands:

• composer outdated (check for outdated packages);
• composer why-not (check for version constraints not allowing us to upgrade);
• composer recipes:update - update symfony-packages automatically;

In order to upgrade symfony to a new version, consider following 3-step the scenario:

Step 1:

rela589n

// Doctrine Type

final class YourCustomType extends Type
{
    public const NAME = 'your_custom_type';

    private YourCustomService $yourCustomService;

    public function setYourCustomService(YourCustomService $yourCustomService): void
    {

rela589n

class ForUpdateOfTableWalker extends SqlWalker
{
    public const FOR_UPDATE_OF_TABLE = 'ForUpdateOfTable';

    public function walkSelectStatement(SelectStatement $AST): string
    {
        $sql = parent::walkSelectStatement($AST);
        /** @var array $hint */
        $hint = $this->getQuery()->getHint(self::FOR_UPDATE_OF_TABLE);

rela589n

services:
    routable.event.bus:
        class: Symfony\Component\Messenger\RoutableMessageBus
        arguments:
            - !tagged_locator { tag: 'messenger.bus', index_by: 'id' }
            - '@event.bus'

rela589n

document.body.removeEventListener('mousedown',getEventListeners(document.body).mousedown[0].listener)
document.removeEventListener('copy',getEventListeners(document).copy[0].listener)
document.removeEventListener('paste',getEventListeners(document).paste[0].listener)

rela589n

    public function findCategories(): array
    {
        // dfs preorder tree traversal

        $sql = <<<'SQL'
WITH RECURSIVE preorder_categories_traversal
                   AS (SELECT category.id,
                              category.parent_id,
                              ARRAY [ROW (category.sort_order,category.id)] AS path
                       FROM categories category