Skip to content

correlated

sqllocks_spindle.engine.strategies.correlated

Correlated strategy — derive a value from another column in the same row.

Produces a value that is mathematically related to a source column, useful for cost/price relationships, margin calculations, derived metrics, etc.

Supported rules

multiply — result = source * random_factor in [factor_min, factor_max] add — result = source + random_offset in [offset_min, offset_max] subtract — result = source - random_offset (clipped to >= 0)

cost correlated with unit_price

"cost": { "generator": { "strategy": "correlated", "source_column": "unit_price", "rule": "multiply", "params": {"factor_min": 0.30, "factor_max": 0.70} } }

Classes

CorrelatedStrategy

Bases: Strategy

Generate a column whose values are derived from another column in the same row.