Hope to support semantic query building function about clover HOT 9 CLOSED

func TestBUG(t *testing.T) {
	store, _ := badgerstore.OpenWithOptions(badger.DefaultOptions("").WithInMemory(true))
	db, _ := c.OpenWithStore(store)
	text := `[
  {
    "name": "liming",
	"age": 18
  },
  {
    "name": "xiaobai",
	"age": 20
  },
  {
    "name": "xiaohong",
	"age": 22
  }
]`
	os.WriteFile("text.json", []byte(text), 0666)

	db.ImportCollection("names", "text.json")

	dataAll, err := db.FindAll(
		query.NewQuery("names").
			Where(
				query.Field("name").Eq("xiaobai").Or(query.Field("name").GtEq("liming")),
			))
	if err != nil {
		println("SEARCH_FAILED")
	}
	for _, doc := range dataAll {
		fmt.Printf("%+v\n", doc)
	}
	//&{fields:map[_id:26c9acd6-f9b1-46fe-81ce-2da6f96f886c age:20 name:xiaobai]}
	//&{fields:map[_id:83dc8aaa-94ad-4333-9945-98ec6198b83d age:18 name:liming]}
	//&{fields:map[_id:ff5f6b48-0687-49ee-a4fe-ae392ac488af age:22 name:xiaohong]}
}

func TestBUG(t *testing.T) {
	store, _ := badgerstore.OpenWithOptions(badger.DefaultOptions("").WithInMemory(true))
	db, _ := c.OpenWithStore(store)
	text := `[
  {
    "name": "liming",
	"age": 18
  },
  {
    "name": "xiaobai",
	"age": 20
  },
  {
    "name": "xiaohong",
	"age": 22
  }
]`
	os.WriteFile("text.json", []byte(text), 0666)

	db.ImportCollection("names", "text.json")

	dataAll, err := db.FindAll(
		query.NewQuery("names").
			Where(
				query.Field("name").Eq("xiaobai").And(query.Field("age").Gt("18")),
			))
	if err != nil {
		println("SEARCH_FAILED")
	}
	for _, doc := range dataAll {
		fmt.Printf("%+v\n", doc)
	}

}

>>> User = Query()
>>> # Search for a field value
>>> db.search(User.name == 'John')
[{'name': 'John', 'age': 22}, {'name': 'John', 'age': 37}]

>>> # Combine two queries with logical and
>>> db.search((User.name == 'John') & (User.age <= 30))
[{'name': 'John', 'age': 22}]

>>> # Combine two queries with logical or
>>> db.search((User.name == 'John') | (User.name == 'Bob'))
[{'name': 'John', 'age': 22}, {'name': 'John', 'age': 37}, {'name': 'Bob', 'age': 42}]

>>> # Apply transformation to field with `map`
>>> db.search((User.age.map(lambda x: x + x) == 44))
>>> [{'name': 'John', 'age': 22}]

>>> # More possible comparisons:  !=  <  >  <=  >=
>>> # More possible checks: where(...).matches(regex), where(...).test(your_test_func)

$users = DB::table('users')
                    ->where('votes', '>', 100)
                    ->orWhere('name', 'John')
                    ->get();

$users = DB::table('users')->where([
    ['status', '=', '1'],
    ['subscribed', '<>', '1'],
])->get();