aden-generate-queries

Description

Generate a query for a specific acho customer. Acho customer is defined by API token. The query will be generated based on the metadata of the customer's database and the query description.

Structure of the project

.
├── config
│   └── index.js
├── data
│   ├── prompts
│   ├── system_instructions
│   ├── barChartObject.json
│   ├── lineChartObject.json
│   ├── scoreCardObject.json
│   └── tableObject.json
├── routes
│   ├── chartRoutes.js
│   └── queryRoutes.js
├── services
│   ├── acho.js
│   ├── agentChart.js
│   ├── agentQuery.js
│   ├── chartCreator.js
│   └── queryNodeCreator.js
├── utils
│   └── metadataProcessor.js
├── index.js
└── server.js

Start the server

npm install
node server.js

Endpoint

/api/generate-query

Request

Body

Field	Type	Description
queryDescription	string	The description of the query to be generated
appId	string	The id of the app
verId	string	The id of the version

Headers

Field	Type	Description
Authorization	string	The API token of the acho customer

Response

Field	Type	Description
query	string	The generated query
queryName	string	The name of the generated query
tablesNodeIds	array	The tableNodeIds of the tables used in the query