Doctrine auto-truncate values on insert

Question

I'm working on a script that reads XML from a third party partner and places the data in a database table. I have no control over the length or quality of the content. I want to avoid adding logic to inspect the length of every field.

For example: I have a column in a mysql DB of type varchar(255), the value from the XML import is greater than 255 characters. I want Doctrine to insert the first 255 character instead of throwing a Doctrine_Validator_Exception with message "1 validator failed on headline (length)"

Using Doctrine 1.2

score 2 · Answer 1 · answered Jun 23 '11 at 03:23

I know you said you "want to avoid adding logic to inspect the length of every field", but you didn't specify whether that was for performance reasons, or because there were many, and you didn't want to write the code individually. If it is the latter, I would use something like this on the Doctrine Record:

function set($fieldName, $value, $load = true) {
  switch($fieldName) {
  case 'id':
  case 'foo':
  case 'bar': 
    // list all of the fields that you DON'T want to truncate in this section
    break;
  default:
    $value = substr($value, 0, 255);
  }
  parent::set($fieldName, $value, $load);
}

This function overrides the default set() method on the Record. It is going to truncate all fields to 255 characters that don't match the ones listed in the first part (id, foo, bar).

If that isn't what you want, you can let MySQL do the truncation, it issues a warning if you write past the column length (1265 | Data truncated for column 'xxx' at row 1), but that is discarded by Doctrine as the query will complete. To do that, you can change the column type from "string" to "blob" and make the second parameter null instead of the column length, then just set the proper limits in MySQL.

Doctrine auto-truncate values on insert

1 Answers1