#1403: Exporting Doctrine_Search table on I18n - missing search index columns
----------------------------------------+-----------------------------------
Reporter: eXtreme | Owner: jwage
Type: defect | Status: new
Priority: blocker | Milestone: New
Component: Import/Export | Version: 1.0
Keywords: search, yaml, export, i18n | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
----------------------------------------+-----------------------------------
I decided to export all "virtual" plugin tables into files in my
Symfony+Doctrine. My previous related ticket #1355 is fixed now - OK. I18n
exported correctly, Versionable (or AuditLog) exported correctly,
Searchable... yea, here's a problem.
Searchable is a child of I18n. Below example schema is created for
testing:
{{{
---
options:
type: MyISAM
buildTables: &buildTables
generateFiles: yes
generatePath: <?php echo
(dirname(dirname(__FILE__)).DIRECTORY_SEPARATOR.'models')."\n" ?>
Table:
actAs:
I18n:
<<: *buildTables
fields: [name]
actAs:
Searchable:
<<: *buildTables
fields: [name]
columns:
id:
primary: true
autoincrement: true
type: integer(10)
name:
type: string(100)
}}}
(MyISAM forced here because of ticket #1351; and BTW. I've found nice way
to share export options - using YAML references ;))
When I'm trying to export Searchable table it does not export
doctrine_search columns (keyword, field, position) to php class and even
to database. There are only ID and LANG columns (in DB and .php file):
{{{
abstract class BaseTableTranslationIndex extends Doctrine_Record
{
public function setTableDefinition()
{
$this->setTableName('table_translation_index');
$this->hasColumn('id', 'integer', 10, array('type' => 'integer',
'length' => 10, 'primary' => true));
$this->hasColumn('lang', 'string', 2, array('fixed' => true, 'type' =>
'string', 'length' => 2, 'primary' => true));
}
}
}}}
I think it is an issue of I18n - as you can see, there is column named
"lang" which is not specified in schema (in key "fields"). When generating
tables without exporting - it correctly creates in DB table with fields:
id, lang, keyword, field and position.
What is more, when Searchable is not a child of I18n Doctrine can export
correctly its table (to DB and to file with fields: id, keyword, field and
position) so it must be something with this i18n and "lang" column.
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1403>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
