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