NOTICE: All information contained herein is, and remains
the property of TechnoCore.
The intellectual and technical concepts contained
herein are proprietary to TechnoCore and dissemination of this information or reproduction of this material
is strictly forbidden unless prior written permission is obtained
from TechnoCore.
ObjTextFHDescription is a Python module responsible for generating a consolidated product description by aggregating individual feature fields from a database. It reads up to 15 feature fields, concatenates them into a single pipe-separated string, and updates the product's description field in the database.
trader.meta_product table.__init__(self, db_connection: DatabaseConnection = 0, page=0)Initializes the ObjTextFHDescription object.
DatabaseConnection object for database operations.read_features(self, param_1)Reads the feature fields for a given product code, generates the consolidated description, and updates the database.
Process(self, param_1="", ...)The main processing method that orchestrates the reading of features and updating the description.
To generate and update the description for a product, use the Process method:
import ObjTextFHDescription
# Initialize the object with a database connection
description_processor = ObjTextFHDescription.ObjProcessText(db_connection=db)
# Process a product with a specific code
product_code = "19436"
description_processor.Process(product_code)
All three statements live in ObjTextFHDescription.yaml
(database.queries) and are loaded with
get_queries(name).format(...):
| Query | Purpose |
|---|---|
read_features |
the fifteen Feature* columns for a product |
insert_product |
creates the meta_product row when the read finds none |
update_description |
writes the assembled Description back |
Applied 2026-08-16, replacing three inline heredocs:
$param1$; the update used a hand-rolled "'" -> "''" replace,escape_sql(). This matters here — thesql_execute returns (written, rows)read_features and insert_product key on Param1[0:10];
update_description keys on the whole of Param1. For a product code
longer than ten characters those are different rows — the features
are read from one product and the assembled description written to
another, or to none. Tagged in the source. Which of the two is the
intended key is a FullHouse data question, so a standards pass is the
wrong place to decide it.