fix: Get current api usage InfluxDB query

[zachaysan]

Thanks for submitting a PR! Please check the boxes below:

• I have run pre-commit to check linting
• I have added information to docs/ if required so people know about the feature!
• I have filled in the "Changes" section below?
• I have filled in the "How did you test this code" section below?
• I have used a Conventional Commit title for this Pull Request

Changes

A month or two ago I wrote a function to get current API usage, but I was limited to testing with the developer and staging keys and the amount of records returned from the database seemed low, but still seemed reasonable given that organisations in staging could reasonably be argued to not have much API use.

While testing with real production data the difference in the returned results against what we already know should be the right result made it apparent that this function was malfunctioning. Looking at other queries in the InfluxDB wrapper module I was able to alter the function in order to produce the correct result.

How did you test this code?

Tested against production data and verified that the total API calls were an exact match.

(Pdb++) sum([r.get_value() for r in result.records])
816600

[vercel]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Updated (UTC)
docs	✅ Ready (Inspect)	Visit Preview	Apr 25, 2024 3:16pm
flagsmith-frontend-preview	✅ Ready (Inspect)	Visit Preview	Apr 25, 2024 3:16pm
flagsmith-frontend-staging	✅ Ready (Inspect)	Visit Preview	Apr 25, 2024 3:16pm

[github-actions]

Uffizzi Preview deployment-50849 was deleted.

[codecov-commenter]

Codecov Report

Attention: Patch coverage is 0% with 1 lines in your changes are missing coverage. Please review.

Project coverage is 95.96%. Comparing base (5068575) to head (7951150).
Report is 19 commits behind head on main.

Files	Patch %	Lines
api/app_analytics/influxdb_wrapper.py	0.00%	1 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #3846      +/-   ##
==========================================
+ Coverage   95.91%   95.96%   +0.04%     
==========================================
  Files        1122     1126       +4     
  Lines       35482    35785     +303     
==========================================
+ Hits        34034    34342     +308     
+ Misses       1448     1443       -5     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.