7995bc6fe6
Migra a tabela de preços do PricingTables.rb hardcoded pras tabelas captain_pricing_categories + captain_pricing_amounts no DB. Mantém a mesma API pública Captain::Mcp::PricingTables.calculate(...) — código chama o banco via novos modelos Captain::PricingCategory e Captain::PricingAmount. Seed db/seed_pricing_tables.rb faz backfill idempotente pra Dolce Amore (unit 4) e Express (unit 5) com a mesma estrutura que tava no Ruby. Adiciona em captain_assistants: - hermes_subscription_secret (gerado pelo script de provisionamento) - hermes_port (alocado no range 8650-8699) - parent_assistant_id (link informativo Hermes → captain_interno parent pra sombrear FAQs/scenarios via header X-Captain-Assistant-Id) Adiciona em captain_units: extra_person_fee + currency. Primeiro milestone do roadmap arquitetural pro Construtor autônomo (decisões em memory/project_construtor_autonomo_decisions.md). Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
30 lines
1.2 KiB
Ruby
30 lines
1.2 KiB
Ruby
class CreateCaptainPricingTables < ActiveRecord::Migration[7.1]
|
|
# rubocop:disable Metrics/MethodLength
|
|
def change
|
|
add_column :captain_units, :extra_person_fee, :decimal, precision: 10, scale: 2, default: 0.0, null: false
|
|
add_column :captain_units, :currency, :string, default: 'BRL', null: false
|
|
|
|
create_table :captain_pricing_categories do |t|
|
|
t.references :captain_unit, null: false, foreign_key: { to_table: :captain_units }
|
|
t.string :key, null: false
|
|
t.jsonb :aliases, null: false, default: []
|
|
t.integer :extra_person_starts_at, null: false, default: 3
|
|
t.timestamps
|
|
end
|
|
add_index :captain_pricing_categories, [:captain_unit_id, :key], unique: true
|
|
|
|
create_table :captain_pricing_amounts do |t|
|
|
t.references :captain_pricing_category, null: false, foreign_key: { to_table: :captain_pricing_categories }
|
|
t.string :period, null: false
|
|
t.string :day_bucket
|
|
t.decimal :amount, precision: 10, scale: 2, null: false
|
|
t.timestamps
|
|
end
|
|
add_index :captain_pricing_amounts,
|
|
[:captain_pricing_category_id, :period, :day_bucket],
|
|
unique: true,
|
|
name: 'idx_captain_pricing_amount_uniq'
|
|
end
|
|
# rubocop:enable Metrics/MethodLength
|
|
end
|