#012937: DatabaseSchema: ezcDbSchemaPersistentWriter, non increment id

For the second part of your issue I created the following enhancement request: http://issues.ez.no/12943

But I do not understand the first part of your message. Could you please write this a bit more detailed, with perhaps an example?

#256524 by Derick Rethans on May 2nd, 2008 [Permanent Link]

Ok. Example:
lets create a "user" table, with non integer primary key.
CREATE TABLE `user` (
`email` CHAR( 64 ) NOT NULL ,
`name` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `email` )
) ENGINE = innodb;

After this lets generate persistent objects definition (using ezcDbSchemaPersistentWriter)
require 'ezc/ezc_autoload.php';
$db = ezcDbFactory::create( 'mysql://root:password@localhost/temp' );
$dbSchema = ezcDbSchema::createFromDb( $db );
write perssitents
$persistentWriter = new ezcDbSchemaPersistentWriter;
$persistentWriter->saveToFile('persistent', $dbSchema);

<?php
Autogenerated PersistentObject definition

$def = new ezcPersistentObjectDefinition();
$def->table = 'user';
$def->class = 'user';

$def->idProperty = new ezcPersistentObjectIdProperty();
$def->idProperty->columnName = 'email';
$def->idProperty->propertyName = 'email';
$def->idProperty->generator = new ezcPersistentGeneratorDefinition( 'ezcPersistentManualGenerator' );

$def->properties['name'] = new ezcPersistentObjectProperty();
$def->properties['name']->columnName = 'name';
$def->properties['name']->propertyName = 'name';
$def->properties['name']->propertyType = ezcPersistentObjectProperty::PHP_TYPE_STRING;

return $def;

?>

But id havent propertyType, wich must be a PHP_TYPE_STRING.

I think that we need add a line ' fwrite( $file, "\$def->idProperty->propertyType = {$this->translateType($field->type)};\n" );' in DatabaseSchema/src/handlers/persistent/writer.php, line 117

#256525 by Serhey Dolgushev on May 2nd, 2008 [Permanent Link]

Fixed in rev. #8248. The feature part of this issue will be implemented in one of the next releases.

#256922 by Tobias Schlitt on June 3rd, 2008 [Permanent Link]