Testing Daily Usage Function

Testing sb_openai_get_daily_usage('2026-02-01', '2026-02-10')

Result Type: array
Is Array: Yes
Array Count: 10

Full Result (JSON):
[
    {
        "date": "2026-02-10",
        "requests": "10",
        "prompt_tokens": "9669",
        "completion_tokens": "7588",
        "total_tokens": "17257",
        "cost": "0.079106",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-09",
        "requests": "11",
        "prompt_tokens": "15128",
        "completion_tokens": "8417",
        "total_tokens": "23545",
        "cost": "0.092221",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-08",
        "requests": "7",
        "prompt_tokens": "6484",
        "completion_tokens": "5324",
        "total_tokens": "11808",
        "cost": "0.053273",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-07",
        "requests": "11",
        "prompt_tokens": "8619",
        "completion_tokens": "6429",
        "total_tokens": "15048",
        "cost": "0.064858",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-06",
        "requests": "13",
        "prompt_tokens": "13114",
        "completion_tokens": "8539",
        "total_tokens": "21653",
        "cost": "0.093356",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-05",
        "requests": "4",
        "prompt_tokens": "6048",
        "completion_tokens": "2036",
        "total_tokens": "8084",
        "cost": "0.020320",
        "models": "gpt-3.5-turbo,gpt-4o"
    },
    {
        "date": "2026-02-04",
        "requests": "14",
        "prompt_tokens": "14976",
        "completion_tokens": "11185",
        "total_tokens": "26161",
        "cost": "0.130893",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-03",
        "requests": "10",
        "prompt_tokens": "11163",
        "completion_tokens": "7126",
        "total_tokens": "18289",
        "cost": "0.083304",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-02",
        "requests": "8",
        "prompt_tokens": "8599",
        "completion_tokens": "6827",
        "total_tokens": "15426",
        "cost": "0.066791",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-01",
        "requests": "6",
        "prompt_tokens": "4061",
        "completion_tokens": "4922",
        "total_tokens": "8983",
        "cost": "0.034826",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    }
]

First Element:
Type: array
Keys: date, requests, prompt_tokens, completion_tokens, total_tokens, cost, models
Values:
  date: 2026-02-10
  requests: 10
  prompt_tokens: 9669
  completion_tokens: 7588
  total_tokens: 17257
  cost: 0.079106
  models: gpt-3.5-turbo,gpt-4o,gpt-4o-mini

============================================================
DIRECT SQL TEST
============================================================

Query:
SELECT 
                DATE(created_at) as date,
                COUNT(*) as requests,
                SUM(prompt_tokens) as prompt_tokens,
                SUM(completion_tokens) as completion_tokens,
                SUM(total_tokens) as total_tokens,
                SUM(cost) as cost,
                GROUP_CONCAT(DISTINCT model) as models
              FROM sb_openai_usage
              WHERE created_at >= '2026-02-01 00:00:00' 
                AND created_at <= '2026-02-10 23:59:59'
              GROUP BY DATE(created_at)
              ORDER BY date DESC

Direct Result Type: array
Direct Is Array: Yes
Direct Array Count: 10

Direct Result (JSON):
[
    {
        "date": "2026-02-10",
        "requests": "10",
        "prompt_tokens": "9669",
        "completion_tokens": "7588",
        "total_tokens": "17257",
        "cost": "0.079106",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-09",
        "requests": "11",
        "prompt_tokens": "15128",
        "completion_tokens": "8417",
        "total_tokens": "23545",
        "cost": "0.092221",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-08",
        "requests": "7",
        "prompt_tokens": "6484",
        "completion_tokens": "5324",
        "total_tokens": "11808",
        "cost": "0.053273",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-07",
        "requests": "11",
        "prompt_tokens": "8619",
        "completion_tokens": "6429",
        "total_tokens": "15048",
        "cost": "0.064858",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-06",
        "requests": "13",
        "prompt_tokens": "13114",
        "completion_tokens": "8539",
        "total_tokens": "21653",
        "cost": "0.093356",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-05",
        "requests": "4",
        "prompt_tokens": "6048",
        "completion_tokens": "2036",
        "total_tokens": "8084",
        "cost": "0.020320",
        "models": "gpt-3.5-turbo,gpt-4o"
    },
    {
        "date": "2026-02-04",
        "requests": "14",
        "prompt_tokens": "14976",
        "completion_tokens": "11185",
        "total_tokens": "26161",
        "cost": "0.130893",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-03",
        "requests": "10",
        "prompt_tokens": "11163",
        "completion_tokens": "7126",
        "total_tokens": "18289",
        "cost": "0.083304",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-02",
        "requests": "8",
        "prompt_tokens": "8599",
        "completion_tokens": "6827",
        "total_tokens": "15426",
        "cost": "0.066791",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    },
    {
        "date": "2026-02-01",
        "requests": "6",
        "prompt_tokens": "4061",
        "completion_tokens": "4922",
        "total_tokens": "8983",
        "cost": "0.034826",
        "models": "gpt-3.5-turbo,gpt-4o,gpt-4o-mini"
    }
]