Evidence and archive

20260510033149_session_usage.ts · part 1

Full reference
Topics
Status
Showing all 7

7 text occurrences from packages/core/src/database/migration/20260510033149_session_usage.ts, part 1. Every entry preserves the shipped literal and its saved verdict or selection reason.

File contents and all parts · All files

Shipped text

ALTER TABLE session ADD cost real DEFAULT 0 NOT NULL;

Source: packages/core/src/database/migration/20260510033149_session_usage.ts, characters 210–273, SHA-256 35614dca19c4cab4.

Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.

Readable text: ALTER TABLE 'session' ADD 'cost' real DEFAULT 0 NOT NULL;

ALTER TABLE `session` ADD `cost` real DEFAULT 0 NOT NULL;

ALTER TABLE session ADD tokens input integer DEFAULT 0 NOT NULL;

Source: packages/core/src/database/migration/20260510033149_session_usage.ts, characters 295–369, SHA-256 20ed5c30429ee289.

Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.

Readable text: ALTER TABLE 'session' ADD 'tokens_input' integer DEFAULT 0 NOT NULL;

ALTER TABLE `session` ADD `tokens_input` integer DEFAULT 0 NOT NULL;

ALTER TABLE session ADD tokens output integer DEFAULT 0 NOT NULL;

Source: packages/core/src/database/migration/20260510033149_session_usage.ts, characters 391–466, SHA-256 8a9255a195157e73.

Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.

Readable text: ALTER TABLE 'session' ADD 'tokens_output' integer DEFAULT 0 NOT NULL;

ALTER TABLE `session` ADD `tokens_output` integer DEFAULT 0 NOT NULL;

ALTER TABLE session ADD tokens reasoning integer DEFAULT 0 NOT NULL;

Source: packages/core/src/database/migration/20260510033149_session_usage.ts, characters 488–566, SHA-256 888de2dc8913fd5a.

Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.

Readable text: ALTER TABLE 'session' ADD 'tokens_reasoning' integer DEFAULT 0 NOT NULL;

ALTER TABLE `session` ADD `tokens_reasoning` integer DEFAULT 0 NOT NULL;

ALTER TABLE session ADD tokens cache read integer DEFAULT 0 NOT NULL;

Source: packages/core/src/database/migration/20260510033149_session_usage.ts, characters 588–667, SHA-256 2082134b3c65f238.

Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.

Readable text: ALTER TABLE 'session' ADD 'tokens_cache_read' integer DEFAULT 0 NOT NULL;

ALTER TABLE `session` ADD `tokens_cache_read` integer DEFAULT 0 NOT NULL;

ALTER TABLE session ADD tokens cache write integer DEFAULT 0 NOT NULL;

Source: packages/core/src/database/migration/20260510033149_session_usage.ts, characters 689–769, SHA-256 cac32cf0863b36f2.

Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.

Readable text: ALTER TABLE 'session' ADD 'tokens_cache_write' integer DEFAULT 0 NOT NULL;

ALTER TABLE `session` ADD `tokens_cache_write` integer DEFAULT 0 NOT NULL;

UPDATE session SET cost = coalesce(( SELECT sum(coalesce(json extract(message.da

Source: packages/core/src/database/migration/20260510033149_session_usage.ts, characters 791–2524, SHA-256 29b08e478ff45a10.

Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.

Readable text: UPDATE session SET cost = coalesce(( SELECT sum(coalesce(json_extract(message.data, '$.cost'), 0)) FROM message WHERE message.session_id = session.id AND json_extr…


        UPDATE session
        SET
          cost = coalesce((
            SELECT sum(coalesce(json_extract(message.data, '$.cost'), 0))
            FROM message
            WHERE message.session_id = session.id
              AND json_extract(message.data, '$.role') = 'assistant'
          ), 0),
          tokens_input = coalesce((
            SELECT sum(coalesce(json_extract(message.data, '$.tokens.input'), 0))
            FROM message
            WHERE message.session_id = session.id
              AND json_extract(message.data, '$.role') = 'assistant'
          ), 0),
          tokens_output = coalesce((
            SELECT sum(coalesce(json_extract(message.data, '$.tokens.output'), 0))
            FROM message
            WHERE message.session_id = session.id
              AND json_extract(message.data, '$.role') = 'assistant'
          ), 0),
          tokens_reasoning = coalesce((
            SELECT sum(coalesce(json_extract(message.data, '$.tokens.reasoning'), 0))
            FROM message
            WHERE message.session_id = session.id
              AND json_extract(message.data, '$.role') = 'assistant'
          ), 0),
          tokens_cache_read = coalesce((
            SELECT sum(coalesce(json_extract(message.data, '$.tokens.cache.read'), 0))
            FROM message
            WHERE message.session_id = session.id
              AND json_extract(message.data, '$.role') = 'assistant'
          ), 0),
          tokens_cache_write = coalesce((
            SELECT sum(coalesce(json_extract(message.data, '$.tokens.cache.write'), 0))
            FROM message
            WHERE message.session_id = session.id
              AND json_extract(message.data, '$.role') = 'assistant'
          ), 0)