Class: CreateOpenRouterUsageLogs

Inherits:
Object
  • Object
show all
Defined in:
lib/generators/open_router_usage_tracker/install/templates/migration.rb

Instance Method Summary collapse

Instance Method Details

#change ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
# File 'lib/generators/open_router_usage_tracker/install/templates/migration.rb', line 2

def change
  create_table :open_router_usage_logs do |t|
    t.string :model, null: false
    t.integer :prompt_tokens, null: false, default: 0
    t.integer :completion_tokens, null: false, default: 0
    t.integer :total_tokens, null: false, default: 0
    t.decimal :cost, precision: 10, scale: 5, null: false, default: 0.0
    t.references :user, null: false, polymorphic: true
    t.string :request_id, null: false
    t.string :provider, null: false, default: "open_router"

    # Storing the raw API response is recommended for auditing and future-proofing.
    # If you are using PostgreSQL, you can change `t.json` to `t.jsonb` for
    # better performance and indexing capabilities.
    t.json :raw_usage_response, null: false, default: {}

    t.timestamps
  end

  add_index :open_router_usage_logs, [ :provider, :request_id ], unique: true
end