README.md in getto-repository-sequel-1.0.2 vs README.md in getto-repository-sequel-1.1.0
- old
+ new
@@ -45,10 +45,13 @@
"name.cont_as_hira": "カナ",
"name.cont_any": "カナ",
"active.in": ["True"],
+
+ "date.gteq": "2018-10-01",
+ "date.lteq": "2018-10-31",
},
)
where = search.where do |w|
w.search "id.eq", &w.eq(::Sequel[:accounts][:id])
@@ -68,10 +71,13 @@
::Sequel[:account_actives][:account_id],
"True" => true,
"False" => false,
)
)
+
+ w.search "date.gteq", &w.gteq(::Sequel[:accounts][:created_at])
+ w.search "date.lteq", &w.lteq(::Sequel[:accounts][:created_at])
end
order = search.order do |o|
o.order :active, o.is_not_null(::Sequel[:account_actives][:account_id], 0, 1)
@@ -164,9 +170,37 @@
```sql
-- { "id.eq": "1" }
WHERE
(`accounts`.`id` = 1)
+```
+
+- less than or equals to
+
+```ruby
+where = search.where do |w|
+ w.search "date.lteq", &w.lteq(::Sequel[:accounts][:created_at])
+end
+```
+
+```sql
+-- { "date.lteq": "2018-10-01" }
+WHERE
+ (`accounts`.`created_at` <= "2018-10-01")
+```
+
+- greater than or equals to
+
+```ruby
+where = search.where do |w|
+ w.search "date.gteq", &w.gteq(::Sequel[:accounts][:created_at])
+end
+```
+
+```sql
+-- { "date.gteq": "2018-10-01" }
+WHERE
+ (`accounts`.`created_at` >= "2018-10-01")
```
- contains
```ruby