本文整理匯總了Golang中github.com/c2fo/testify/assert.NoError函數的典型用法代碼示例。如果您正苦於以下問題:Golang NoError函數的具體用法?Golang NoError怎麽用?Golang NoError使用的例子?那麽, 這裏精選的函數代碼示例或許可以為您提供幫助。
在下文中一共展示了NoError函數的15個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的Golang代碼示例。
示例1: TestDelete
func (me *mysqlTest) TestDelete() {
t := me.T()
ds := me.db.From("entry")
var e entry
found, err := ds.Where(goqu.I("int").Eq(9)).Select("id").ScanStruct(&e)
assert.NoError(t, err)
assert.True(t, found)
_, err = ds.Where(goqu.I("id").Eq(e.Id)).Delete().Exec()
assert.NoError(t, err)
count, err := ds.Count()
assert.NoError(t, err)
assert.Equal(t, count, 9)
var id uint32
found, err = ds.Where(goqu.I("id").Eq(e.Id)).ScanVal(&id)
assert.NoError(t, err)
assert.False(t, found)
e = entry{}
found, err = ds.Where(goqu.I("int").Eq(8)).Select("id").ScanStruct(&e)
assert.NoError(t, err)
assert.True(t, found)
assert.NotEqual(t, e.Id, 0)
id = 0
_, err = ds.Where(goqu.I("id").Eq(e.Id)).Returning("id").Delete().ScanVal(&id)
assert.Equal(t, err.Error(), "goqu: Adapter does not support RETURNING clause")
}
示例2: TestInsertReturning
func (me *postgresTest) TestInsertReturning() {
t := me.T()
ds := me.db.From("entry")
now := time.Now()
e := entry{Int: 10, Float: 1.000000, String: "1.000000", Time: now, Bool: true, Bytes: []byte("1.000000")}
found, err := ds.Returning(goqu.Star()).Insert(e).ScanStruct(&e)
assert.NoError(t, err)
assert.True(t, found)
assert.True(t, e.Id > 0)
var ids []uint32
assert.NoError(t, ds.Returning("id").Insert([]entry{
{Int: 11, Float: 1.100000, String: "1.100000", Time: now, Bool: false, Bytes: []byte("1.100000")},
{Int: 12, Float: 1.200000, String: "1.200000", Time: now, Bool: true, Bytes: []byte("1.200000")},
{Int: 13, Float: 1.300000, String: "1.300000", Time: now, Bool: false, Bytes: []byte("1.300000")},
{Int: 14, Float: 1.400000, String: "1.400000", Time: now, Bool: true, Bytes: []byte("1.400000")},
}).ScanVals(&ids))
assert.Len(t, ids, 4)
for _, id := range ids {
assert.True(t, id > 0)
}
var ints []int64
assert.NoError(t, ds.Returning("int").Insert(
entry{Int: 15, Float: 1.500000, String: "1.500000", Time: now, Bool: false, Bytes: []byte("1.500000")},
entry{Int: 16, Float: 1.600000, String: "1.600000", Time: now, Bool: true, Bytes: []byte("1.600000")},
entry{Int: 17, Float: 1.700000, String: "1.700000", Time: now, Bool: false, Bytes: []byte("1.700000")},
entry{Int: 18, Float: 1.800000, String: "1.800000", Time: now, Bool: true, Bytes: []byte("1.800000")},
).ScanVals(&ints))
assert.True(t, found)
assert.Equal(t, ints, []int64{15, 16, 17, 18})
}
示例3: TestParallelGetColumnMap
func (me *crudExecTest) TestParallelGetColumnMap() {
t := me.T()
type item struct {
id uint
name string
}
wg := sync.WaitGroup{}
wg.Add(1)
go func() {
i := item{}
m, err := getColumnMap(i)
assert.NoError(t, err)
assert.NotNil(t, m)
wg.Done()
}()
wg.Add(1)
go func() {
i := item{}
m, err := getColumnMap(i)
assert.NoError(t, err)
assert.NotNil(t, m)
wg.Done()
}()
wg.Wait()
}
示例4: TestScanVal
func (me *crudExecTest) TestScanVal() {
t := me.T()
mDb, mock, err := sqlmock.New()
assert.NoError(t, err)
mock.ExpectQuery(`SELECT "id" FROM "items"`).
WillReturnError(fmt.Errorf("query error"))
mock.ExpectQuery(`SELECT "id" FROM "items"`).
WithArgs().
WillReturnRows(sqlmock.NewRows([]string{"id"}).FromCSVString("1"))
db := New("db-mock", mDb)
exec := newCrudExec(db, nil, `SELECT "id" FROM "items"`)
var id int64
var ids []int64
found, err := exec.ScanVal(id)
assert.EqualError(t, err, "goqu: Type must be a pointer when calling ScanVal")
assert.False(t, found)
found, err = exec.ScanVal(&ids)
assert.EqualError(t, err, "goqu: Cannot scan into a slice when calling ScanVal")
assert.False(t, found)
found, err = exec.ScanVal(&id)
assert.EqualError(t, err, "query error")
assert.False(t, found)
var ptrId int64
found, err = exec.ScanVal(&ptrId)
assert.NoError(t, err)
assert.Equal(t, ptrId, 1)
}
示例5: TestInsertSqlWithMaps
func (me *datasetTest) TestInsertSqlWithMaps() {
t := me.T()
ds1 := From("items")
sql, _, err := ds1.ToInsertSql(map[string]interface{}{"name": "Test", "address": "111 Test Addr"})
assert.NoError(t, err)
assert.Equal(t, sql, `INSERT INTO "items" ("address", "name") VALUES ('111 Test Addr', 'Test')`)
sql, _, err = ds1.ToInsertSql(
map[string]interface{}{"address": "111 Test Addr", "name": "Test1"},
map[string]interface{}{"address": "211 Test Addr", "name": "Test2"},
map[string]interface{}{"address": "311 Test Addr", "name": "Test3"},
map[string]interface{}{"address": "411 Test Addr", "name": "Test4"},
)
assert.NoError(t, err)
assert.Equal(t, sql, `INSERT INTO "items" ("address", "name") VALUES ('111 Test Addr', 'Test1'), ('211 Test Addr', 'Test2'), ('311 Test Addr', 'Test3'), ('411 Test Addr', 'Test4')`)
_, _, err = ds1.ToInsertSql(
map[string]interface{}{"address": "111 Test Addr", "name": "Test1"},
map[string]interface{}{"address": "211 Test Addr"},
map[string]interface{}{"address": "311 Test Addr", "name": "Test3"},
map[string]interface{}{"address": "411 Test Addr", "name": "Test4"},
)
assert.EqualError(t, err, "goqu: Rows with different value length expected 2 got 1")
}
示例6: TestLiteralIdentifierExpression
func (me *datasetTest) TestLiteralIdentifierExpression() {
t := me.T()
buf := NewSqlBuilder(false)
ds := From("test")
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a")))
assert.Equal(t, buf.String(), `"a"`)
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a.b")))
assert.Equal(t, buf.String(), `"a"."b"`)
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a.b.c")))
assert.Equal(t, buf.String(), `"a"."b"."c"`)
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a.b.*")))
assert.Equal(t, buf.String(), `"a"."b".*`)
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a.*")))
assert.Equal(t, buf.String(), `"a".*`)
buf = NewSqlBuilder(true)
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a")))
assert.Equal(t, buf.String(), `"a"`)
assert.Equal(t, buf.args, []interface{}{})
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a.b")))
assert.Equal(t, buf.String(), `"a"."b"`)
assert.Equal(t, buf.args, []interface{}{})
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a.b.c")))
assert.Equal(t, buf.String(), `"a"."b"."c"`)
assert.Equal(t, buf.args, []interface{}{})
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a.b.*")))
assert.Equal(t, buf.String(), `"a"."b".*`)
assert.Equal(t, buf.args, []interface{}{})
assert.NoError(t, ds.Literal(me.Truncate(buf), I("a.*")))
assert.Equal(t, buf.String(), `"a".*`)
assert.Equal(t, buf.args, []interface{}{})
}
示例7: TestPreparedInsertSqlWithEmbeddedStructPtr
func (me *datasetTest) TestPreparedInsertSqlWithEmbeddedStructPtr() {
t := me.T()
ds1 := From("items")
type Phone struct {
Primary string `db:"primary_phone"`
Home string `db:"home_phone"`
}
type item struct {
*Phone
Address string `db:"address"`
Name string `db:"name"`
}
sql, args, err := ds1.Prepared(true).ToInsertSql(item{Name: "Test", Address: "111 Test Addr", Phone: &Phone{Home: "123123", Primary: "456456"}})
assert.NoError(t, err)
assert.Equal(t, args, []interface{}{"456456", "123123", "111 Test Addr", "Test"})
assert.Equal(t, sql, `INSERT INTO "items" ("primary_phone", "home_phone", "address", "name") VALUES (?, ?, ?, ?)`)
sql, args, err = ds1.Prepared(true).ToInsertSql(
item{Address: "111 Test Addr", Name: "Test1", Phone: &Phone{Home: "123123", Primary: "456456"}},
item{Address: "211 Test Addr", Name: "Test2", Phone: &Phone{Home: "123123", Primary: "456456"}},
item{Address: "311 Test Addr", Name: "Test3", Phone: &Phone{Home: "123123", Primary: "456456"}},
item{Address: "411 Test Addr", Name: "Test4", Phone: &Phone{Home: "123123", Primary: "456456"}},
)
assert.NoError(t, err)
assert.Equal(t, args, []interface{}{
"456456", "123123", "111 Test Addr", "Test1",
"456456", "123123", "211 Test Addr", "Test2",
"456456", "123123", "311 Test Addr", "Test3",
"456456", "123123", "411 Test Addr", "Test4",
})
assert.Equal(t, sql, `INSERT INTO "items" ("primary_phone", "home_phone", "address", "name") VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?)`)
}
示例8: TestPreparedInsertSqlWithValuerNull
func (me *datasetTest) TestPreparedInsertSqlWithValuerNull() {
t := me.T()
ds1 := From("items")
type item struct {
Address string `db:"address"`
Name string `db:"name"`
Valuer sql.NullInt64 `db:"valuer"`
}
sqlString, args, err := ds1.Prepared(true).ToInsertSql(item{Name: "Test", Address: "111 Test Addr"})
assert.NoError(t, err)
assert.Equal(t, args, []interface{}{
"111 Test Addr", "Test", nil,
})
assert.Equal(t, sqlString, `INSERT INTO "items" ("address", "name", "valuer") VALUES (?, ?, ?)`)
sqlString, args, err = ds1.Prepared(true).ToInsertSql(
item{Address: "111 Test Addr", Name: "Test1"},
item{Address: "211 Test Addr", Name: "Test2"},
item{Address: "311 Test Addr", Name: "Test3"},
item{Address: "411 Test Addr", Name: "Test4"},
)
assert.NoError(t, err)
assert.Equal(t, args, []interface{}{
"111 Test Addr", "Test1", nil,
"211 Test Addr", "Test2", nil,
"311 Test Addr", "Test3", nil,
"411 Test Addr", "Test4", nil,
})
assert.Equal(t, sqlString, `INSERT INTO "items" ("address", "name", "valuer") VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?)`)
}
示例9: TestInsertWithGoquPkTagSql
func (me *datasetTest) TestInsertWithGoquPkTagSql() {
t := me.T()
ds1 := From("items")
type item struct {
Id uint32 `db:"id" goqu:"pk,skipinsert"`
Address string `db:"address"`
Name string `db:"name"`
}
sql, _, err := ds1.ToInsertSql(item{Name: "Test", Address: "111 Test Addr"})
assert.NoError(t, err)
assert.Equal(t, sql, `INSERT INTO "items" ("address", "name") VALUES ('111 Test Addr', 'Test')`)
sql, _, err = ds1.ToInsertSql(map[string]interface{}{"name": "Test", "address": "111 Test Addr"})
assert.NoError(t, err)
assert.Equal(t, sql, `INSERT INTO "items" ("address", "name") VALUES ('111 Test Addr', 'Test')`)
sql, _, err = ds1.ToInsertSql(
item{Name: "Test1", Address: "111 Test Addr"},
item{Name: "Test2", Address: "211 Test Addr"},
item{Name: "Test3", Address: "311 Test Addr"},
item{Name: "Test4", Address: "411 Test Addr"},
)
assert.NoError(t, err)
assert.Equal(t, sql, `INSERT INTO "items" ("address", "name") VALUES ('111 Test Addr', 'Test1'), ('211 Test Addr', 'Test2'), ('311 Test Addr', 'Test3'), ('411 Test Addr', 'Test4')`)
}
示例10: TestScanStructs
func (me *databaseTest) TestScanStructs() {
t := me.T()
mDb, mock, err := sqlmock.New()
assert.NoError(t, err)
mock.ExpectQuery(`SELECT \* FROM "items"`).
WithArgs().
WillReturnRows(sqlmock.NewRows([]string{"address", "name"}).FromCSVString("111 Test Addr,Test1\n211 Test Addr,Test2"))
mock.ExpectQuery(`SELECT "test" FROM "items"`).
WithArgs().
WillReturnRows(sqlmock.NewRows([]string{"test"}).FromCSVString("test1\ntest2"))
db := New("db-mock", mDb)
var items []testActionItem
assert.NoError(t, db.ScanStructs(&items, `SELECT * FROM "items"`))
assert.Len(t, items, 2)
assert.Equal(t, items[0].Address, "111 Test Addr")
assert.Equal(t, items[0].Name, "Test1")
assert.Equal(t, items[1].Address, "211 Test Addr")
assert.Equal(t, items[1].Name, "Test2")
items = items[0:0]
assert.EqualError(t, db.ScanStructs(items, `SELECT * FROM "items"`), "goqu: Type must be a pointer to a slice when calling ScanStructs")
assert.EqualError(t, db.ScanStructs(&testActionItem{}, `SELECT * FROM "items"`), "goqu: Type must be a pointer to a slice when calling ScanStructs")
assert.EqualError(t, db.ScanStructs(&items, `SELECT "test" FROM "items"`), `goqu: Unable to find corresponding field to column "test" returned by query`)
}
示例11: TestScanStruct
func (me *databaseTest) TestScanStruct() {
t := me.T()
mDb, mock, err := sqlmock.New()
assert.NoError(t, err)
mock.ExpectQuery(`SELECT \* FROM "items" LIMIT 1`).
WithArgs().
WillReturnRows(sqlmock.NewRows([]string{"address", "name"}).FromCSVString("111 Test Addr,Test1"))
mock.ExpectQuery(`SELECT "test" FROM "items" LIMIT 1`).
WithArgs().
WillReturnRows(sqlmock.NewRows([]string{"test"}).FromCSVString("test1\ntest2"))
db := New("mock", mDb)
var item testActionItem
found, err := db.ScanStruct(&item, `SELECT * FROM "items" LIMIT 1`)
assert.NoError(t, err)
assert.True(t, found)
assert.Equal(t, item.Address, "111 Test Addr")
assert.Equal(t, item.Name, "Test1")
_, err = db.ScanStruct(item, `SELECT * FROM "items" LIMIT 1`)
assert.EqualError(t, err, "goqu: Type must be a pointer to a struct when calling ScanStruct")
_, err = db.ScanStruct([]testActionItem{}, `SELECT * FROM "items" LIMIT 1`)
assert.EqualError(t, err, "goqu: Type must be a pointer to a struct when calling ScanStruct")
_, err = db.ScanStruct(&item, `SELECT "test" FROM "items" LIMIT 1`)
assert.EqualError(t, err, `goqu: Unable to find corresponding field to column "test" returned by query`)
}
示例12: TestScanVals
func (me *crudExecTest) TestScanVals() {
t := me.T()
mDb, mock, err := sqlmock.New()
assert.NoError(t, err)
mock.ExpectQuery(`SELECT "id" FROM "items"`).
WillReturnError(fmt.Errorf("query error"))
mock.ExpectQuery(`SELECT "id" FROM "items"`).
WithArgs().
WillReturnRows(sqlmock.NewRows([]string{"id"}).FromCSVString("1\n2"))
mock.ExpectQuery(`SELECT "id" FROM "items"`).
WithArgs().
WillReturnRows(sqlmock.NewRows([]string{"id"}).FromCSVString("1\n2"))
db := New("db-mock", mDb)
exec := newCrudExec(db, nil, `SELECT "id" FROM "items"`)
var id int64
var ids []int64
assert.EqualError(t, exec.ScanVals(ids), "goqu: Type must be a pointer to a slice when calling ScanVals")
assert.EqualError(t, exec.ScanVals(&id), "goqu: Type must be a pointer to a slice when calling ScanVals")
assert.EqualError(t, exec.ScanVals(&ids), "query error")
assert.NoError(t, exec.ScanVals(&ids))
assert.Equal(t, ids, []int64{1, 2})
var pointers []*int64
assert.NoError(t, exec.ScanVals(&pointers))
assert.Len(t, pointers, 2)
assert.Equal(t, *pointers[0], 1)
assert.Equal(t, *pointers[1], 2)
}
示例13: TestPreparedHaving
func (me *datasetTest) TestPreparedHaving() {
t := me.T()
ds1 := From("test")
b := ds1.Having(I("a").Gt(1)).GroupBy("created")
sql, args, err := b.Prepared(true).ToSql()
assert.NoError(t, err)
assert.Equal(t, args, []interface{}{1})
assert.Equal(t, sql, `SELECT * FROM "test" GROUP BY "created" HAVING ("a" > ?)`)
b = ds1.
Where(I("b").IsTrue()).
Having(I("a").Gt(1)).
GroupBy("created")
sql, args, err = b.Prepared(true).ToSql()
assert.NoError(t, err)
assert.Equal(t, args, []interface{}{1})
assert.Equal(t, sql, `SELECT * FROM "test" WHERE ("b" IS TRUE) GROUP BY "created" HAVING ("a" > ?)`)
b = ds1.Having(I("a").Gt(1))
sql, args, err = b.Prepared(true).ToSql()
assert.NoError(t, err)
assert.Equal(t, args, []interface{}{1})
assert.Equal(t, sql, `SELECT * FROM "test" HAVING ("a" > ?)`)
}
示例14: TestLogger
func (me *databaseTest) TestLogger() {
t := me.T()
mDb, mock, err := sqlmock.New()
assert.NoError(t, err)
mock.ExpectQuery(`SELECT \* FROM "items"`).
WithArgs().
WillReturnRows(sqlmock.NewRows([]string{"address", "name"}).FromCSVString("111 Test Addr,Test1\n211 Test Addr,Test2"))
mock.ExpectExec(`SELECT \* FROM "items" WHERE "id" = ?`).
WithArgs(1).
WillReturnResult(sqlmock.NewResult(0, 0))
db := New("db-mock", mDb)
logger := new(dbTestMockLogger)
db.Logger(logger)
var items []testActionItem
assert.NoError(t, db.ScanStructs(&items, `SELECT * FROM "items"`))
_, err = db.Exec(`SELECT * FROM "items" WHERE "id" = ?`, 1)
assert.NoError(t, err)
db.Trace("TEST", "")
assert.Equal(t, logger.Messages, []string{
"[goqu] QUERY [query:=`SELECT * FROM \"items\"`]",
"[goqu] EXEC [query:=`SELECT * FROM \"items\" WHERE \"id\" = ?` args:=[1]]",
"[goqu] TEST",
})
}
示例15: TestJoin
func (me *datasetTest) TestJoin() {
t := me.T()
ds1 := From("items")
sql, _, err := ds1.Join(I("players").As("p"), On(Ex{"p.id": I("items.playerId")})).ToSql()
assert.NoError(t, err)
assert.Equal(t, sql, `SELECT * FROM "items" INNER JOIN "players" AS "p" ON ("p"."id" = "items"."playerId")`)
sql, _, err = ds1.Join(ds1.From("players").As("p"), On(Ex{"p.id": I("items.playerId")})).ToSql()
assert.NoError(t, err)
assert.Equal(t, sql, `SELECT * FROM "items" INNER JOIN (SELECT * FROM "players") AS "p" ON ("p"."id" = "items"."playerId")`)
sql, _, err = ds1.Join(I("v1").Table("test"), On(Ex{"v1.test.id": I("items.playerId")})).ToSql()
assert.NoError(t, err)
assert.Equal(t, sql, `SELECT * FROM "items" INNER JOIN "v1"."test" ON ("v1"."test"."id" = "items"."playerId")`)
sql, _, err = ds1.Join(I("test"), Using(I("name"), I("common_id"))).ToSql()
assert.NoError(t, err)
assert.Equal(t, sql, `SELECT * FROM "items" INNER JOIN "test" USING ("name", "common_id")`)
sql, _, err = ds1.Join(I("test"), Using("name", "common_id")).ToSql()
assert.NoError(t, err)
assert.Equal(t, sql, `SELECT * FROM "items" INNER JOIN "test" USING ("name", "common_id")`)
}