首頁(yè) 猿問對(duì)于復(fù)合 SQL...

對(duì)于復(fù)合 SQL 查詢，go-sqlmock 中不需要使用 args [] 調(diào)用查詢

Go

慕碼人2483693 2023-07-26 17:15:29

我能夠成功模擬查詢以從一張表中進(jìn)行選擇，如下所示：sqlMock.ExpectQuery("^SELECT DISTINCT (.+) FROM myTable1, myTable2"). WillReturnRows(myResultRows)但我無法模擬以下查詢來檢查我的 postgres 數(shù)據(jù)庫(kù)中是否存在該表：SELECT EXISTS ( SELECT 1 FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'myTable3' );組合： existsRows := sqlmock.NewRows([]string{"exists"}). AddRow(true)和 slMock.ExpectQuery("^SELECT EXISTS"). WillReturnRows(existsRows)我SELECT 1也嘗試過嘲笑，但得到了完全相同的錯(cuò)誤：time="2019-09-27T15:49:41-07:00" level=panic msg="db query" error="call to Query 'SELECT EXISTS\n\t\t( SELECT 1\n\t\tFROM information_schema.tables\n\t\tWHERE table_schema = 'public'\n\t\t AND table_name = 'myTable3' );' with args [], was not expected, next expectation is: ExpectedExec => expecting Exec or ExecContext which......我正在使用的包：import ( "database/sql" "db" "os" "testing" // not explicitly called _ "github.com/denisenkom/go-mssqldb" _ "github.com/lib/pq" "github.com/DATA-DOG/go-sqlmock" "github.com/sirupsen/logrus")任何想法或指示表示贊賞。我在網(wǎng)上找不到相關(guān)的例子

查看完整描述

2 回答

慕妹3146593

TA貢獻(xiàn)1820條經(jīng)驗(yàn) 獲得超9個(gè)贊

實(shí)際上，

? ? sqlMock.ExpectQuery("SELECT EXISTS \\( SELECT 1 FROM information_schema\\.tables WHERE table_schema = 'public' AND table_name = 'myTable3' \\);").

? ? ? ? WillReturnRows(existsRows)

成功了。

線索是它立即期待下一個(gè)查詢。所以我們知道它根本沒有讀過這個(gè)。我的同事指出了這一點(diǎn):)

反對(duì) 回復(fù) 2023-07-26

動(dòng)漫人物

TA貢獻(xiàn)1815條經(jīng)驗(yàn) 獲得超10個(gè)贊

我不確定，但認(rèn)為問題出在您的查詢的縮進(jìn)中，嘗試刪除查詢中的換行符或表格SELECT EXISTS ( SELECT 1 FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'myTable3' );

像這樣 SELECT EXISTS( SELECT 1 FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'myTable3' );

反對(duì) 回復(fù) 2023-07-26