Function Test_Model_AllAndCount

contrib/drivers/sqlitecgo/sqlitecgo_z_unit_model_test.go:578–675

(t *testing.T)

}

func Test_Model_AllAndCount(t *testing.T) {
	table := createInitTable()
	defer dropTable(table)
	tableName2 := "user_" + gtime.Now().TimestampNanoStr()
	if _, err := db.Exec(ctx, fmt.Sprintf(`
	CREATE TABLE %s (
		id         INTEGER       PRIMARY KEY AUTOINCREMENT
									UNIQUE
									NOT NULL,
		name       varchar(45) NULL,
		age        int(10)
	);
	`, tableName2,
	)); err != nil {
		gtest.AssertNil(err)
	}
	defer dropTable(tableName2)
	r, err := db.Insert(ctx, tableName2, g.Map{
		"id":   1,
		"name": "table2_1",
		"age":  18,
	})
	gtest.AssertNil(err)
	n, _ := r.RowsAffected()
	gtest.Assert(n, 1)

	// AllAndCount with all data
	gtest.C(t, func(t *gtest.T) {
		result, count, err := db.Model(table).AllAndCount(false)
		t.AssertNil(err)
		t.Assert(len(result), TableSize)
		t.Assert(count, TableSize)
	})
	// AllAndCount with no data
	gtest.C(t, func(t *gtest.T) {
		result, count, err := db.Model(table).Where("id<0").AllAndCount(false)
		t.Assert(result, nil)
		t.AssertNil(err)
		t.Assert(count, 0)
	})
	// AllAndCount with page
	gtest.C(t, func(t *gtest.T) {
		result, count, err := db.Model(table).Page(1, 5).AllAndCount(false)
		t.AssertNil(err)
		t.Assert(len(result), 5)
		t.Assert(count, TableSize)
	})
	// AllAndCount with normal result
	gtest.C(t, func(t *gtest.T) {
		result, count, err := db.Model(table).Where("id=?", 1).AllAndCount(false)
		t.AssertNil(err)
		t.Assert(count, 1)
		t.Assert(result[0]["id"], 1)
		t.Assert(result[0]["nickname"], "name_1")
		t.Assert(result[0]["passport"], "user_1")
	})
	// AllAndCount with distinct
	gtest.C(t, func(t *gtest.T) {