Project

General

Profile

Actions

Bug #23575

closed

Allow DBAL to interact with EM to configure remapping

Added by Xavier Perseguers over 13 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Must have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-09-21
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

When using an Oracle DBMS, length of identifiers is limited to 30 characters. DBAL can be configured to automatically remap table and field names to shorter or other ones.

To work, the remapping configuration must be available before the corresponding table has been created.

Idea is that EM triggers DBAL before an extension is installed. This would allow to determine whether remapping should be used (typically if DBMS is Oracle and table/field names longer than 30 characters). In such case, and if the remapping configuration is not already present in localconf.php (if administrator already "prepared" the remapping), it should provide a middle step for the installation where DBAL could propose a mapping configuration to be written to localconf.php.

User should be able to modify the automatic mapping configuration before it is written to localconf.php. After that, EM should go on as usual and show table to be created/fields to be added.

Example of remapping configuration:

$TYPO3_CONF_VARS['EXTCONF']['dbal']['mapping'] = array(
'cachingframework_cache_hash' => array(
'mapTableName' => 'cf_cache_hash',
),
'cachingframework_cache_hash_tags' => array(
'mapTableName' => 'cf_cache_hash_tags',
),
'cachingframework_cache_pages' => array(
'mapTableName' => 'cf_cache_pages',
),
'tx_templavoila_datastructure' => array(
'mapTableName' => 'tx_templavoila_ds',
),
);
(issue imported from #M15755)


Files

remapping.png (62.7 KB) remapping.png Administrator Admin, 2010-10-31 10:06
15755.diff (12.6 KB) 15755.diff Administrator Admin, 2010-10-31 16:38
15755_v2.diff (13 KB) 15755_v2.diff Administrator Admin, 2010-10-31 17:59
15755_v3.diff (14 KB) 15755_v3.diff Administrator Admin, 2010-11-02 11:27

Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Bug #23877: Add DB structure update pre-processing hook in EMClosedXavier Perseguers2010-10-30

Actions
Related to TYPO3 Core - Bug #16292: installer doesn't cope with maximum table and field length (Oracle XE, MS SQL via DBlib)ClosedAndreas Kienast2006-06-27

Actions
Related to TYPO3 Core - Feature #23911: Allow array as localconf.php configuration valuesClosedXavier Perseguers2010-11-02

Actions
Actions

Also available in: Atom PDF