-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathget_plan_and_usage.py
68 lines (54 loc) · 2.36 KB
/
get_plan_and_usage.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
"""
python get_plan_and_usage.py -u <username> -p <password>
Retrieves the subscription plan and usage for the organisation a user belongs to
Set HF_USERNAME and HF_PASSWORD as environment variables
"""
# *********************************************************************************************************************
# standard imports
import json
# third party imports
import click
import pandas
import humanfirst
@click.command()
@click.option('-u', '--username', type=str, default='',
help='HumanFirst username if not setting HF_USERNAME environment variable')
@click.option('-p', '--password', type=str, default='',
help='HumanFirst password if not setting HF_PASSWORD environment variable')
@click.option('-o', '--output', type=str, default=None,
help='Defaults to no output, if provided for instance ./data/someclient it will output there')
def main(username: str, password: int, output:str):
'''Gets plan information, workspace and conversationset usage
Optionall outputs to file'''
# authorise
hf_api = humanfirst.apis.HFAPI(username=username, password=password)
# get plan info as a json
print("Plan info")
plan_dict = hf_api.get_plan()
print(json.dumps(plan_dict, indent=2))
print("\n")
# get usage info
usage_dict = hf_api.get_usage()
# turn into dfs for df.to_csv or similar
print("dataPoints.conversationSets")
df_convo_summary = pandas.json_normalize(usage_dict["dataPoints"]["conversationSets"])
if output:
output_convo_name = f'{output}_convosets.csv'
df_convo_summary.to_csv(output_convo_name, index=False,header=True)
print(f'Wrote to: {output_convo_name}')
else:
print(df_workspace_summary)
print("\ndataPoints.workspaces")
df_workspace_summary = pandas.json_normalize(usage_dict["dataPoints"]["workspaces"])
if output:
output_workspaces_name = f'{output}_workspaces.csv'
df_workspace_summary.to_csv(output_workspaces_name,index=False,header=True)
print(f'Wrote to: {output_workspaces_name}')
else:
print(df_workspace_summary)
df = pandas.json_normalize(usage_dict)
print("\nUsage summary")
df.drop(columns=["dataPoints.conversationSets","dataPoints.workspaces"],inplace=True)
print(df)
if __name__ == '__main__':
main() # pylint: disable=no-value-for-parameter