Comments (5)
from chatdb.
from chatdb.
It means your database is not connected
…
On Mon, 17 Jul 2023 at 6:14 PM, TianMin @.> wrote: [image: image] https://user-images.githubusercontent.com/10555409/253911188-a4906d0c-5071-45ee-869a-07c46d3c2f86.png — Reply to this email directly, view it on GitHub <#7>, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADDKTMVPCQ47PC7XG3GYHQTXQUF6VANCNFSM6AAAAAA2MW4OJY . You are receiving this because you are subscribed to this thread.Message ID: @.>
Change the pattern to:
pattern = r"Step(\d+):\s+(.?)\n(.)\n"
from chatdb.
Hello, author. We followed the advice and modified the pattern of the regular expression. However, this caused all the answers to the questions to include the phrase "not need memory". We suspect that there might still be an issue with the pattern here. @potong
from chatdb.
I try to ask the question "What was the total revenue for January 2023?", The LLM generates the following middle-stage answer:
` ` `
Step1: Calculate the total revenue for January 2023
SELECT SUM(total_price) AS total_revenue
FROM sales
WHERE sale_date >= '2023-01-01' AND sale_date <= '2023-01-31';
` ` `
Notice that, the SQL is not surrounded by backtick `
. Therefore, causing the regular expression pattern pattern = r"Step(\d+):\s+(.*?)\n
(.*?)"
fail to match the SQL, which induces this error.
According to the prompt in this program, the LLM's output should look like the text that is shown below with the SQL surrounded by backtick `
:
` ` `
Step1: Calculate the total revenue for January 2023
`SELECT SUM(total_price) AS total_revenue
FROM sales
WHERE sale_date >= '2023-01-01' AND sale_date <= '2023-01-31';`
` ` `
from chatdb.
Related Issues (14)
- Any Update for ChatDB code? HOT 3
- 请问为什么在提问的时候会先输出一句“NOT NEED MEMORY”,好像也不会根据数据库来做出回答? HOT 1
- -
- 点击 Get Started 返回 JSON
- 关于sql_results_history, new_mem_ops 这两个变量的问题
- 只能接入chatgpt么?或者是否可以自定义baseurl和model name.
- ChatGLM怎么使用这个项目呢? HOT 2
- 非常感兴趣这个项目,有交流群吗? HOT 6
- 文章中的50个问题会提供吗? HOT 2
- Doesn't seem to see a different table schema HOT 2
- pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost'
- bug HOT 1
- What's the meaning of function 'need_update_sql' in chatdb.py ?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from chatdb.