Function Test_TableFields

contrib/drivers/sqlitecgo/sqlitecgo_z_unit_core_test.go:1540–1576

(t *testing.T)

}

func Test_TableFields(t *testing.T) {

	gtest.C(t, func(t *gtest.T) {
		tableName := "fields_" + gtime.TimestampNanoStr()
		createTable(tableName)
		defer dropTable(tableName)
		var expect = map[string][]any{
			// fields		type	null	key	default	extra	comment
			"id":          {"INTEGER", false, "pri", nil, "", ""},
			"passport":    {"VARCHAR(45)", false, "", "passport", "", ""},
			"password":    {"VARCHAR(128)", false, "", "password", "", ""},
			"nickname":    {"VARCHAR(45)", true, "", nil, "", ""},
			"create_time": {"DATETIME", true, "", nil, "", ""},
		}

		res, err := db.TableFields(context.Background(), tableName)
		gtest.AssertNil(err)

		for k, v := range expect {
			_, ok := res[k]
			gtest.AssertEQ(ok, true)
			gtest.AssertEQ(res[k].Name, k)
			gtest.AssertEQ(res[k].Type, v[0])
			gtest.AssertEQ(res[k].Null, v[1])
			gtest.AssertEQ(res[k].Key, v[2])
			gtest.AssertEQ(res[k].Default, v[3])
			gtest.AssertEQ(res[k].Extra, v[4])
			gtest.AssertEQ(res[k].Comment, v[5])
		}

	})

	gtest.C(t, func(t *gtest.T) {
		_, err := db.TableFields(context.Background(), "t1 t2")
		gtest.AssertNE(err, nil)
	})
}

func Test_TableNameIsKeyword(t *testing.T) {
	table := createInitTable(TableNameWhichIsKeyword)