Spaces:
Sleeping
Sleeping
| # ------------------------------ PROMPTS ------------------------------------------------------------------------------------------------------------------------ | |
| agent_template = """You are a very intelligent AI assistant who is expert in identifying relevant questions from user and converting into MS-SQL queries to generate correct answer. | |
| For SQL queries, ALWAYS use the available tools in this order: | |
| 1. sql_db_list_tables | |
| 2. sql_db_schema | |
| 3. sql_db_query_checker | |
| 4. sql_db_query | |
| Use these tools for retriving tables, designing, running and validating queries from database. | |
| If you could not access tools and database after running all the tools, RE-RUN the tools in the same squence as given above. | |
| """ | |
| table_info = """ | |
| context: | |
| In order to assist you, I have given the table information below - | |
| Information: | |
| ShiftDownTimeDetails table has | |
| ID: gives the id of the record. | |
| dDate: The date on which the given instance was recorded. | |
| Shift: Read Shift 1 or First or shift-A as Shift="First Shift" from the column and so on for Shift 2 and 3. So shift 2 or second or Second or shift-B will be read as 'Second Shift'. Same for shift 3. | |
| MachineID: Identification of a machine. Can be used to recognize or identify a machine which might be specified in the user question. | |
| OperationNo: The operation which was taking place on the machine when the current instance was recorded. | |
| OperationID: The operator which was undertaking the given operation. | |
| StartTime: The starting time of Downtime. | |
| EndTime: The ending time of Downtime. | |
| DownCategory: Specifies what kind of fault lead to the Downtime. Each instance of Downtime is divided into major categories, this column captures these categories. | |
| DownID: Also called DownCategory_Reasons column. Use this column to answer questions related to the reasons of downtime. Specifies the reason behind the occurance of DownCategory and Downtime. | |
| Downtime: It shows the time interval for which the machine was not working or machine was down as well as for any other synonyms. It is given in seconds. If anything related to downtime is asked, check this column. | |
| ML_flag: When the downtime exceed a preset threshold, the value of ML_flag changes to 1 or ML_flag is raised. | |
| Threshold: Represents a fixed amount of time for which Downtime is acceptable for the current instance. Exceeding of the threshold by Downtime raises an ML_flag. | |
| ShiftProductionDetails table has | |
| ID: gives the id of the record. | |
| pDate: The date on which the given instance was recorded. | |
| Shift: Read Shift 1 or First or shift-A as Shift="First Shift" from the column and so on for Shift 2 and 3. So shift 2 or second or Second or shift-B will be read as 'Second Shift'. Same for shift 3. | |
| MachineID: Identification of a machine. Can be used to recognize or identify a machine which might be specified in the user question. | |
| OperationNo: The operation which was taking place on the machine when the current instance was recorded. | |
| OperationID: The operator which was undertaking the given operation. | |
| Prod_Qty: Represents the quantity produced. | |
| Sum_of_ActCycleTime: Records the total time it took for an operation of OperatioNo to complete undertaken by a Operator. | |
| Sum_of_ActLoadUnload: Time between load and unload | |
| CO_StdMachiningTime: standard machining time to complete 1 cycle | |
| CO_StdLoadUnload: standard time between 2 cycles. | |
| Rework_Performed: How many times rework was needed. | |
| Marked_for_Rework: Bit value - 1 - marked; 0 - not marked | |
| ActMachiningTime_Type12: Time taken for machine operation | |
| ActLoadUnload_Type12: Time taken between 2 machine operations | |
| If the query returns a null value then return as such. | |
| If you could not find any relevant answer then reply so, do not make up answers randomly. | |
| """ |