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 #1

Updated by Xavier Perseguers over 13 years ago

Just uploaded some ongoing work to show how this could be done.

Actions #2

Updated by Xavier Perseguers over 13 years ago

Committed to DBAL trunk (rev. 40177)

Actions #3

Updated by Susanne Moog about 13 years ago

  • Target version deleted (4.5.0)
Actions #4

Updated by Xavier Perseguers over 12 years ago

  • Status changed from Closed to New
  • Priority changed from Should have to Must have
  • TYPO3 Version set to 4.5

This is open again because the corresponding part in EM was removed and refactoring changed the method signature.

Actions #5

Updated by Xavier Perseguers over 12 years ago

  • Tracker changed from Feature to Bug
  • Project changed from TYPO3 Core to 329
  • Category deleted (999)
Actions #6

Updated by Mr. Hudson over 12 years ago

Patch set 1 of change I42e9ab7ed5513bdd031e186592b1768a7a00cedd has been pushed to the review server.
It is available at http://review.typo3.org/4616

Actions #7

Updated by Mr. Hudson over 12 years ago

Patch set 1 of change I5cb2f78e889f3abfce8e50aa7c455c79e52ad9ce has been pushed to the review server.
It is available at http://review.typo3.org/4617

Actions #8

Updated by Xavier Perseguers over 12 years ago

  • Status changed from New to Under Review
Actions #9

Updated by Xavier Perseguers over 12 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #10

Updated by Michael Stucki over 10 years ago

  • Project changed from 329 to TYPO3 Core
Actions #11

Updated by Michael Stucki over 10 years ago

  • Category set to 999
Actions #12

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF