This is an automated email from the ASF dual-hosted git repository.
sergeykamov pushed a commit to branch NLPCRAFT-206
in repository https://gitbox.apache.org/repos/asf/incubator-nlpcraft.git
The following commit(s) were added to refs/heads/NLPCRAFT-206 by this push:
new c9e4058 WIP.
c9e4058 is described below
commit c9e405828f4405e66f62fa8b8e0abacdf143055c
Author: Sergey Kamov <[email protected]>
AuthorDate: Thu Mar 18 16:44:20 2021 +0300
WIP.
---
.../nlpcraft/examples/sql/NCSqlModelSpec.scala | 226 ++++++++++-----------
1 file changed, 113 insertions(+), 113 deletions(-)
diff --git
a/nlpcraft/src/test/scala/org/apache/nlpcraft/examples/sql/NCSqlModelSpec.scala
b/nlpcraft/src/test/scala/org/apache/nlpcraft/examples/sql/NCSqlModelSpec.scala
index 19e002d..3483bd4 100644
---
a/nlpcraft/src/test/scala/org/apache/nlpcraft/examples/sql/NCSqlModelSpec.scala
+++
b/nlpcraft/src/test/scala/org/apache/nlpcraft/examples/sql/NCSqlModelSpec.scala
@@ -51,119 +51,119 @@ class NCSqlModelSpec extends NCEnricherBaseSpec {
txt = "order date",
usr(text = "order date", id = "col:date")
),
-// _ ⇒ checkExists(
-// txt = "show me the order dates",
-// nlp(text = "show me the", isStop = true),
-// usr(text = "order dates", id = "col:date")
-// ),
-// _ ⇒ checkExists(
-// txt = "list dates of orders",
-// nlp(text = "list", isStop = true),
-// usr(text = "dates orders", id = "col:date"),
-// nlp(text = "of")
-// ),
-// _ ⇒ checkExists(
-// txt = "orders for last month",
-// usr(text = "orders", id = "tbl:orders"),
-// dte(text = "for last month")
-// ),
-// _ ⇒ checkExists(
-// txt = "shippers data",
-// usr(text = "shippers", id = "tbl:shippers"),
-// nlp(text = "data")
-// ),
-// _ ⇒ checkExists(
-// txt = "show me orders with freight more than 10 for last
year",
-// nlp(text = "show me", isStop = true),
-// srt(text = "orders with", typ = BY_ONLY, note =
"condition:num", index = 2),
-// usr(text = "freight more than 10", id = "condition:num"),
-// dte(text = "for last year")
-// ),
-// _ ⇒ checkExists(
-// txt = "territories data",
-// usr(text = "territories", id = "tbl:territories"),
-// nlp(text = "data")
-// ),
-// _ ⇒ checkExists(
-// txt = "employees territories",
-// usr(text = "employees territories", id =
"tbl:employee_territories")
-// ),
-// _ ⇒ checkExists(
-// txt = "10 suppliers",
-// lim(text = "10", limit=10, index =1, note="tbl:suppliers"),
-// usr(text = "suppliers", id = "tbl:suppliers")
-// ),
-// _ ⇒ checkExists(
-// txt = "last year Exotic Liquids orders",
-// dte(text="last year"),
-// usr(text = "Exotic Liquids", id = "condition:value"),
-// usr(text = "orders", id = "tbl:orders")
-// ),
-// _ ⇒ checkExists(
-// txt = "give me the orders sorted by ship date",
-// nlp(text = "give me the", isStop = true),
-// usr(text = "orders", id = "tbl:orders"),
-// srt(text = "sorted by", typ = BY_ONLY, note = "col:date",
index = 3),
-// usr(text = "ship date", id = "col:date"),
-// ),
-// _ ⇒ checkExists(
-// txt = "give me the orders sorted by ship date",
-// nlp(text = "give me the", isStop = true),
-// usr(text = "orders", id = "tbl:orders"),
-// srt(text = "sorted by", typ = BY_ONLY, note = "col:date",
index = 3),
-// usr(text = "ship date", id = "col:date"),
-// ),
-// _ ⇒ checkExists(
-// txt = "give me the orders sorted by ship date asc",
-// nlp(text = "give me the", isStop = true),
-// usr(text = "orders", id = "tbl:orders"),
-// srt(text = "sorted by", typ = BY_ONLY, note = "col:date",
index = 3, asc = true),
-// usr(text = "ship date", id = "col:date"),
-// nlp(text = "asc", isStop = true)
-// ),
-// _ ⇒ checkExists(
-// txt = "give me the orders sorted by date",
-// nlp(text = "give me the", isStop = true),
-// usr(text = "orders date", id = "col:date"),
-// nlp(text = "sorted"),
-// nlp(text = "by")
-// ),
-// _ ⇒ checkExists(
-// txt = "What are the top orders for the last 2 weeks sorted
by order quantity?",
-// lim(text = "What are the top", limit = 10, index = 1, note =
"tbl:orders", asc = false),
-// usr(text = "orders", id = "tbl:orders"),
-// dte(text = "for last 2 weeks"),
-// nlp(text = "the", isStop = true),
-// srt(text = "sorted by", typ = BY_ONLY, note = "col:num",
index = 5),
-// usr(text = "order quantity", id = "col:num"),
-// nlp(text = "?", isStop = true)
-// ),
-// _ ⇒ checkExists(
-// txt = "What are the top 25 orders for the last 2 weeks
sorted by order quantity?",
-// lim(text = "What are the top 25", limit = 25, index = 1,
note = "tbl:orders", asc = false),
-// usr(text = "orders", id = "tbl:orders"),
-// dte(text = "for last 2 weeks"),
-// nlp(text = "the", isStop = true),
-// srt(text = "sorted by", typ = BY_ONLY, note = "col:num",
index = 5),
-// usr(text = "order quantity", id = "col:num"),
-// nlp(text = "?", isStop = true)
-// ),
-// _ ⇒ checkExists(
-// txt = "What are the best performing products for the last
quarter?",
-// nlp(text = "What are the", isStop = true),
-// usr(text = "best performing", id = "sort:best"),
-// usr(text = "products", id = "tbl:products"),
-// dte(text = "for last quarter"),
-// nlp(text = "the ?", isStop = true)
-// ),
-// _ ⇒ checkExists(
-// txt = "What are the least performing categories for the last
quarter?",
-// nlp(text = "What are the", isStop = true),
-// usr(text = "least performing", id = "sort:worst"),
-// usr(text = "categories", id = "tbl:categories"),
-// dte(text = "for last quarter"),
-// nlp(text = "the ?", isStop = true)
-// )
+ _ ⇒ checkExists(
+ txt = "show me the order dates",
+ nlp(text = "show me the", isStop = true),
+ usr(text = "order dates", id = "col:date")
+ ),
+ _ ⇒ checkExists(
+ txt = "list dates of orders",
+ nlp(text = "list", isStop = true),
+ usr(text = "dates orders", id = "col:date"),
+ nlp(text = "of")
+ ),
+ _ ⇒ checkExists(
+ txt = "orders for last month",
+ usr(text = "orders", id = "tbl:orders"),
+ dte(text = "for last month")
+ ),
+ _ ⇒ checkExists(
+ txt = "shippers data",
+ usr(text = "shippers", id = "tbl:shippers"),
+ nlp(text = "data")
+ ),
+ _ ⇒ checkExists(
+ txt = "show me orders with freight more than 10 for last year",
+ nlp(text = "show me", isStop = true),
+ srt(text = "orders with", typ = BY_ONLY, note =
"condition:num", index = 2),
+ usr(text = "freight more than 10", id = "condition:num"),
+ dte(text = "for last year")
+ ),
+ _ ⇒ checkExists(
+ txt = "territories data",
+ usr(text = "territories", id = "tbl:territories"),
+ nlp(text = "data")
+ ),
+ _ ⇒ checkExists(
+ txt = "employees territories",
+ usr(text = "employees territories", id =
"tbl:employee_territories")
+ ),
+ _ ⇒ checkExists(
+ txt = "10 suppliers",
+ lim(text = "10", limit=10, index =1, note="tbl:suppliers"),
+ usr(text = "suppliers", id = "tbl:suppliers")
+ ),
+ _ ⇒ checkExists(
+ txt = "last year Exotic Liquids orders",
+ dte(text="last year"),
+ usr(text = "Exotic Liquids", id = "condition:value"),
+ usr(text = "orders", id = "tbl:orders")
+ ),
+ _ ⇒ checkExists(
+ txt = "give me the orders sorted by ship date",
+ nlp(text = "give me the", isStop = true),
+ usr(text = "orders", id = "tbl:orders"),
+ srt(text = "sorted by", typ = BY_ONLY, note = "col:date",
index = 3),
+ usr(text = "ship date", id = "col:date"),
+ ),
+ _ ⇒ checkExists(
+ txt = "give me the orders sorted by ship date",
+ nlp(text = "give me the", isStop = true),
+ usr(text = "orders", id = "tbl:orders"),
+ srt(text = "sorted by", typ = BY_ONLY, note = "col:date",
index = 3),
+ usr(text = "ship date", id = "col:date"),
+ ),
+ _ ⇒ checkExists(
+ txt = "give me the orders sorted by ship date asc",
+ nlp(text = "give me the", isStop = true),
+ usr(text = "orders", id = "tbl:orders"),
+ srt(text = "sorted by", typ = BY_ONLY, note = "col:date",
index = 3, asc = true),
+ usr(text = "ship date", id = "col:date"),
+ nlp(text = "asc", isStop = true)
+ ),
+ _ ⇒ checkExists(
+ txt = "give me the orders sorted by date",
+ nlp(text = "give me the", isStop = true),
+ usr(text = "orders date", id = "col:date"),
+ nlp(text = "sorted"),
+ nlp(text = "by")
+ ),
+ _ ⇒ checkExists(
+ txt = "What are the top orders for the last 2 weeks sorted by
order quantity?",
+ lim(text = "What are the top", limit = 10, index = 1, note =
"tbl:orders", asc = false),
+ usr(text = "orders", id = "tbl:orders"),
+ dte(text = "for last 2 weeks"),
+ nlp(text = "the", isStop = true),
+ srt(text = "sorted by", typ = BY_ONLY, note = "col:num", index
= 5),
+ usr(text = "order quantity", id = "col:num"),
+ nlp(text = "?", isStop = true)
+ ),
+ _ ⇒ checkExists(
+ txt = "What are the top 25 orders for the last 2 weeks sorted
by order quantity?",
+ lim(text = "What are the top 25", limit = 25, index = 1, note
= "tbl:orders", asc = false),
+ usr(text = "orders", id = "tbl:orders"),
+ dte(text = "for last 2 weeks"),
+ nlp(text = "the", isStop = true),
+ srt(text = "sorted by", typ = BY_ONLY, note = "col:num", index
= 5),
+ usr(text = "order quantity", id = "col:num"),
+ nlp(text = "?", isStop = true)
+ ),
+ _ ⇒ checkExists(
+ txt = "What are the best performing products for the last
quarter?",
+ nlp(text = "What are the", isStop = true),
+ usr(text = "best performing", id = "sort:best"),
+ usr(text = "products", id = "tbl:products"),
+ dte(text = "for last quarter"),
+ nlp(text = "the ?", isStop = true)
+ ),
+ _ ⇒ checkExists(
+ txt = "What are the least performing categories for the last
quarter?",
+ nlp(text = "What are the", isStop = true),
+ usr(text = "least performing", id = "sort:worst"),
+ usr(text = "categories", id = "tbl:categories"),
+ dte(text = "for last quarter"),
+ nlp(text = "the ?", isStop = true)
+ )
)
}
}
