Update database values with same PHP values using Doctrine type

Question

I am using a Doctrine2 type to encrypt database values. The type converts the PHP value internally to and from a database value by encrypting and decrypting it. This works perfectly due to the Doctrine2 types.

The encryption is stored as a base64 encoded string. Every encrypted string is prefixed by a fixed defined prefix. This means the database field contains both encrypted and decrypted values (this is required by external requirements), recognized by the prefix.

My wish is the following:

Assume I have an entity. I want to force the encryption or decryption of all properties of an entity using Doctrine. I do this by forcing the database value within the type to be stored in the encrypted or decrypted form.

However, when I call the method EntityManager::computeChangeSets, the none of the properties of the entity is marked as changed. Of course the actual data (the PHP values) are not changed. However, the database values do (are supposed to) change.

How to accomplish this?

Some code of the Doctrine type:

<?php

use Doctrine\DBAL\Types\Type;

class EncryptedType extends Type {

    private static $forceDecrypt = false;

    // Encryption stuff, like encrypt () and decrypt ()

    public function convertToPHPValue($value, AbstractPlatform $platform) {
        if ($value === null) {
            return null;
        }
        return $this -> decrypt($value, false);
    }

    public function convertToDatabaseValue($value, AbstractPlatform $platform) {
        if ($value === null) {
            return null;
        }
        if (self::$forceDecrypt) {
            return (string) $value;
        }
        return $this -> encrypt((string) $value, false);
    }
}

I have removed all unneeded code.

mvorisek · Accepted Answer · 2016-02-16 13:50:56Z

2

+50

Isn't it a bug?

Workaround: If the entity is managed by the manager, then it has a state STATE_MANAGED, when you will change it to STATE_NEW and force update, this can solve your problem.

answered Feb 16, 2016 at 13:50

mvorisek

3,4584 gold badges21 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jan Mares Over a year ago

I don't think so. How would Doctrine know about change of some static field in class EncryptedType. I'm afraid this will have to be solved by using Doctrine events.

Hidde · Accepted Answer · 2016-05-21 12:40:15Z

I have found an answer to my own question after many hours of diving into Doctrine code.

Below the outline of my solution is shown to help others.

First of all I created a simple value class, which can hold a PHP value of any type. It has a __toString() method to convert it back to the original value.

Code:

class Value {
    private $value;

    public function __construct($value) {
        $this -> value = $value;
    }

    public function __toString() {
        return $this -> value;
    }
}

The EncryptedType class stays exactly the same. The point is the value of the entity. When a property of a class has to be force-updated in the database (and thus make use of the EncryptedType class), it will be set in the following way:

foreach (self::$properties as $property) {
    $value = $accessor -> getValue($entity, $property);
    if ($value !== null) {
        $accessor -> setValue($entity, $property, new Value($value));
    }
}

($accessor is a property accessor.)

Notice the new Value(...) wrapper, which will make sure Doctrine notices the change in property value and makes a change in the database. Of course the value will be taken from the __toString() method, which is exactly what we need.

Collectives™ on Stack Overflow

Update database values with same PHP values using Doctrine type

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related