예제 #1
0
func TestModelInstanceApi(t *testing.T) {
	var err error
	user := models.User{}
	user.Name = "mijia"
	user.Password = "******"
	user.Age = 15

	if user, err = user.Insert(db); err != nil || user.Id == 0 {
		t.Errorf("Insert is not working, %v", err)
	}

	userId := user.Id
	objs := models.UserObjs
	query := objs.Select().Where(objs.FilterId("=", userId))

	if user, err = query.One(db); err != nil {
		t.Errorf("Select one is not working, %v", err)
	}

	user.Age = 36
	user.IsMarried = 1
	if affected, err := user.Update(db); err != nil || affected == 0 {
		t.Errorf("Update is not working, %v", err)
	}
	if user, err = query.One(db); err != nil {
		t.Errorf("Select one is not working, %v", err)
	}

	article := models.Article{
		UserId: user.Id,
		Title:  "Hello World",
	}
	if article, err = article.Insert(db); err != nil || article.Id == 0 {
		t.Errorf("Insert is not working for article, %v", err)
	}

	comment := models.Comment{
		UserId:    user.Id,
		ArticleId: article.Id,
	}
	if comment, err = comment.Insert(db); err != nil {
		t.Errorf("Fail to insert a comment, %v", err)
	}
	comment.Content = "Woow"
	if affected, err := comment.Update(db); err != nil || affected == 0 {
		t.Errorf("Fail to update a comment, %s", err)
	}

	if affected, err := user.Delete(db); err != nil || affected == 0 {
		t.Errorf("Delete is not working, %v", err)
	}
}
예제 #2
0
func TestModelBatchApi(t *testing.T) {
	rand.Seed(time.Now().UnixNano())
	err := gmq.WithinTx(db, func(tx *gmq.Tx) error {
		for i := 0; i < 5; i++ {
			user := models.User{}
			user.Name = fmt.Sprintf("mijia_%d_%d", time.Now().UnixNano(), rand.Int63())
			user.Password = "******"
			user.Age = rand.Intn(120) + 1
			if _, err := user.Insert(tx); err != nil {
				t.Errorf("Failed to insert test data for batch query, %s", user)
				return err
			}
		}
		return nil
	})
	if err != nil {
		t.Errorf("Failed to insert test data in transaction, %s", err)
	}

	objs := models.UserObjs
	query := objs.Select().Where(objs.FilterName("LIKE", "mijia%"))
	if _, err := query.List(db); err != nil {
		t.Errorf("Failed to list query, %s", err)
	}

	query = objs.Select("Id", "Age").Where(objs.FilterAge(">=", 10)).
		OrderBy("Age", "+Id").Page(9, 5)
	if _, err := query.List(db); err != nil {
		t.Errorf("Failed to list query, %s", err)
	}

	query = objs.Select("Age", "Id").Where(objs.FilterAge("IN", 12, 13, 14)).
		GroupBy("Age")
	if _, err := query.List(db); err != nil {
		t.Errorf("Failed to list query, %s", err)
	}

	data := models.User{Age: 19, IsMarried: 1}
	query = objs.Update(data, "Age", "IsMarried").Where(objs.FilterAge("=", data.Age-1))
	if _, err := query.Run(db); err != nil {
		t.Errorf("Failed to do batch update, %s", err)
	}

	query = objs.Delete().Where(objs.FilterAge(">", 70))
	if _, err := query.Run(db); err != nil {
		t.Errorf("Failed to do batch delete, %s", err)
	}
}