Contrib.social

Stabilize the data model

Open on Drupal.org →
Created on 1 August 2025, 29 days ago

Problem/Motivation

The module has 2 tables:

  • A table storing references to source string occurrences/instance (currently {babel_source})
  • The other storing a hash representing the a unique source string within a context (currently {babel_source_status})

There are two problems arising from this:

  1. The tables naming is misleading. The 1st table name should suggest that is not a list of source strings but a list of source string occurrences/instances. For instance a source string "Foo", in the "bar" context might appear multiple times in the 1st table, in code and also in a config. The 2nd table is the one that store unique references to a source string but its name is also misleading.
  2. The 1st table column "sort_key" has duplicate values because the value is linked the a unique source string + context. If the source string has multiple occurrences/instances the value is needlessly duplicated.

Proposed resolution

  1. Rename the current table {babel_source} as {babel_source_instance}.
  2. Rename the current table {babel_source_status} as {babel_source}.
  3. Move the "sort_key" from {babel_source_instance} (new name) to {babel_source} (new name).

Remaining tasks

None.

User interface changes

None.

API changes

None.

Data model changes

  • Table names changed
  • Field "sort_key" moved to the other table
📌 Task
Status

Active

Version

1.0

Component

Code

Created by

🇷🇴Romania claudiu.cristea Arad 🇷🇴

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024