From 08b148eaae0bf5121022acae9cc91e27cbf37263 Mon Sep 17 00:00:00 2001
From: guowenxue <guowenxue@gmail.com>
Date: Sat, 24 May 2025 17:57:29 +0800
Subject: [PATCH] update devsn in socketd project
---
project/socketd/booster/database.c | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/project/socketd/booster/database.c b/project/socketd/booster/database.c
index 00b10cb..93f386a 100644
--- a/project/socketd/booster/database.c
+++ b/project/socketd/booster/database.c
@@ -125,7 +125,7 @@
return -2;
}
- snprintf(sql, sizeof(sql), "insert into %s(packet) values(?)", TABLE_NAME);
+ snprintf(sql, sizeof(sql), "INSERT INTO %s(packet) VALUES(?)", TABLE_NAME);
rv = sqlite3_prepare_v2(s_clidb, sql, -1, &stat, NULL);
if(SQLITE_OK!=rv || !stat)
{
@@ -188,7 +188,7 @@
}
/* Only query the first packet record */
- snprintf(sql, sizeof(sql), "select packet from %s limit 0,1;", TABLE_NAME);
+ snprintf(sql, sizeof(sql), "SELECT packet FROM %s WHERE rowid = (SELECT rowid FROM %s LIMIT 1);", TABLE_NAME, TABLE_NAME);
rv = sqlite3_prepare_v2(s_clidb, sql, -1, &stat, NULL);
if(SQLITE_OK!=rv || !stat)
{
@@ -248,7 +248,7 @@
/* remove packet from db */
memset(sql, 0, sizeof(sql));
- snprintf(sql, sizeof(sql), "delete from %s limit 0,1;", TABLE_NAME);
+ snprintf(sql, sizeof(sql), "DELETE FROM %s WHERE rowid = (SELECT rowid FROM %s LIMIT 1);", TABLE_NAME, TABLE_NAME);
if( SQLITE_OK != sqlite3_exec(s_clidb, sql, NULL, 0, &errmsg) )
{
log_error("delete first blob packet from database failure: %s\n", errmsg);
--
Gitblit v1.9.1