Intended to generate fictional test data for a school project using ChatGPT API, e.g.
Movie Name | Movie Description | Movie Genre |
---|---|---|
Catman | Catman does Catman things | Action |
Name is a reference to Mockaroo
Create a .env
file containing below
OPENAI_API_KEY=<KEY>
Make sure you have balance in your OpenAI account
If recently topped-up, recreate the API key
-
Turn into a site:
- Password protect for cost reasons
- 3 Inputs:
- A model dropdown (at runtime, do a GET /models, list all gpt-*)
- Row number
- List of columns
- Show progress bar
- Downloads CSV when done
- Host the site in rpi, configure reverse proxy
-
if large number of CSV, batch the calls to OpenAI then combine results at the end- At the site, if batching, progress bar increases incrementally (e.g. 5 batches: 0% -> 20% -> 40% etc)
40 seems to be the max? maybe batch every 20 rows
-
STRETCH GOAL: Allow uploading MySQL schemas and generate full e2e test data