qa_sqls/
├── xba/
│   ├── aoba/    # aoba7環境用（bank_code: 0117）
│   │   └── {SQL No}_{パターン名}.sql
│   └── cuba/    # cuba7環境用（bank_code: 0542）
│       └── {SQL No}_{パターン名}.sql
└── bamanager/
    ├── aoba/    # aoba7環境用（bank_code: 0117）
    │   └── {SQL No}_{パターン名}.sql
    └── cuba/    # cuba7環境用（bank_code: 0542）
        └── {SQL No}_{パターン名}.sql

{SQL No}_{パターン番号}_{説明}.sql

-- 目的: [テストパターンの説明]
-- 対象テーブル: companies

-------------------------------
-- 変数設定
-------------------------------
SET v.company_id = '企業ID';

-- companiesテーブル更新用
SET v.charge_type = 'MONTHLY';
SET v.next_charge_type = 'MONTHLY';
SET v.charge_amount = '3000';
SET v.next_charge_amount = '3000';
SET v.charge_start_at = 'YYYY-MM-01';
SET v.charge_period_start_date = 'YYYY-MM-DD';
SET v.charge_period_end_date = 'YYYY-MM-DD';
SET v.is_charge_target = '1';

-------------------------------
-- 1. 現在の状態を確認
-------------------------------
SELECT * FROM companies
WHERE company_id = current_setting('v.company_id')::int;

-------------------------------
-- 2. テストデータ更新
-------------------------------
UPDATE companies
SET
    company_charge_type = current_setting('v.charge_type'),
    company_next_charge_type = current_setting('v.next_charge_type'),
    company_charge_amount = current_setting('v.charge_amount')::int,
    company_next_charge_amount = current_setting('v.next_charge_amount')::int,
    company_charge_start_at = current_setting('v.charge_start_at')::date,
    company_charge_period_start_date = current_setting('v.charge_period_start_date')::date,
    company_charge_period_end_date = current_setting('v.charge_period_end_date')::date,
    company_is_charge_target = current_setting('v.is_charge_target')::int
WHERE company_id = current_setting('v.company_id')::int
RETURNING *;

-- 目的: [テストパターンの説明]
-- 対象テーブル: companies, charges, charge_items

-------------------------------
-- 変数設定
-------------------------------
SET v.company_id = '企業ID';
-- ... 各種変数

-------------------------------
-- トランザクション開始
-------------------------------
BEGIN;

-------------------------------
-- 1. 現在の状態を確認
-------------------------------
-- companies
SELECT * FROM companies
WHERE company_id = current_setting('v.company_id')::int;

-- charges
SELECT * FROM charges
WHERE charges.charge_company_id = current_setting('v.company_id')::int
ORDER BY charges.charge_date DESC;

-- charge_items
SELECT * FROM charge_items
WHERE charge_items.ci_charge_id IN (
    SELECT charges.charge_id FROM charges
    WHERE charges.charge_company_id = current_setting('v.company_id')::int
)
ORDER BY charge_items.ci_charge_id DESC, charge_items.ci_seq;

-------------------------------
-- 2. テストデータ更新
-------------------------------
-- 2-1. charge_historiesクリア
DELETE FROM charge_histories WHERE ...;

-- 2-2. chargesクリア
DELETE FROM charges WHERE ...;

-- 2-3. charges作成
INSERT INTO charges (...) VALUES (...);

-- 2-4. charge_items作成
INSERT INTO charge_items (...) SELECT ...;

-- 2-5. companies更新
UPDATE companies SET ... WHERE ... RETURNING *;

-------------------------------
-- トランザクション終了
-------------------------------
COMMIT;