def __init__(self,
host='localhost',
port=8080,
path='sensei',
sysinfo=None):
self.host = host
self.port = port
self.path = path
self.url = 'http://%s:%d/%s' % (self.host, self.port, self.path)
self.opener = urllib2.build_opener()
self.opener.addheaders = [(
'User-agent',
'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_7) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.91 Safari/534.30'
)]
if sysinfo:
self.sysinfo = SenseiSystemInfo(sysinfo)
else:
urlReq = urllib2.Request(self.url + "/sysinfo")
res = self.opener.open(urlReq)
line = res.read()
jsonObj = json.loads(line)
# print json.dumps(jsonObj, indent=4)
self.sysinfo = SenseiSystemInfo(jsonObj)
self.facet_map = {}
for facet_info in self.sysinfo.get_facet_infos():
self.facet_map[facet_info.get_name()] = facet_info
self.parser = BQLParser(self.facet_map)
def __init__(self, host='localhost', port=8080, path='sensei', sysinfo=None):
self.host = host
self.port = port
self.path = path
self.url = 'http://%s:%d/%s' % (self.host, self.port, self.path)
self.opener = urllib2.build_opener()
self.opener.addheaders = [('User-agent', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_7) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.91 Safari/534.30')]
if sysinfo:
self.sysinfo = SenseiSystemInfo(sysinfo)
else:
urlReq = urllib2.Request(self.url + "/sysinfo")
res = self.opener.open(urlReq)
line = res.read()
jsonObj = json.loads(line)
# print json.dumps(jsonObj, indent=4)
self.sysinfo = SenseiSystemInfo(jsonObj)
self.facet_map = {}
for facet_info in self.sysinfo.get_facet_infos():
self.facet_map[facet_info.get_name()] = facet_info
self.parser = BQLParser(self.facet_map)
class SenseiClient:
"""Sensei client class."""
def __init__(self, host='localhost', port=8080, path='sensei', sysinfo=None):
self.host = host
self.port = port
self.path = path
self.url = 'http://%s:%d/%s' % (self.host, self.port, self.path)
self.opener = urllib2.build_opener()
self.opener.addheaders = [('User-agent', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_7) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.91 Safari/534.30')]
if sysinfo:
self.sysinfo = SenseiSystemInfo(sysinfo)
else:
urlReq = urllib2.Request(self.url + "/sysinfo")
res = self.opener.open(urlReq)
line = res.read()
jsonObj = json.loads(line)
# print json.dumps(jsonObj, indent=4)
self.sysinfo = SenseiSystemInfo(jsonObj)
self.facet_map = {}
for facet_info in self.sysinfo.get_facet_infos():
self.facet_map[facet_info.get_name()] = facet_info
self.parser = BQLParser(self.facet_map)
def compile(self, bql_stmt):
tokens = self.parser.parse(bql_stmt)
if tokens:
logger.debug("tokens: %s" % tokens)
bql_req = BQLRequest(tokens, self.facet_map)
return SenseiRequest(bql_req, facet_map=self.facet_map)
return None
def buildJsonString(self, req, sort_keys=True, indent=None):
"""Build a Sensei request in JSON format.
Once built, a Sensei request in JSON format can be sent to a Sensei
broker using the following command:
$ curl -XPOST http://localhost:8080/sensei -d '{
"fetchStored": "true",
"from": 0,
"size": 10
}'
"""
output_json = {}
output_json[JSON_PARAM_FROM] = req.offset
output_json[JSON_PARAM_SIZE] = req.count
if req.query:
output_json[JSON_PARAM_QUERY] = {
JSON_PARAM_QUERY_STRING: {
JSON_PARAM_QUERY: req.query
}
}
if req.explain:
output_json[JSON_PARAM_QUERY] = True
if req.fetch_stored:
output_json[JSON_PARAM_FETCH_STORED] = True
if req.route_param:
output_json[JSON_PARAM_ROUTEPARAM] = req.route_param
if req.sorts:
output_json[JSON_PARAM_SORT] = [sort.build_sort_spec() for sort in req.sorts]
if req.filter:
output_json[JSON_PARAM_FILTER] = req.filter
if req.query_pred:
output_json[JSON_PARAM_QUERY] = req.query_pred[JSON_PARAM_QUERY]
if req.selections:
output_json[JSON_PARAM_SELECTIONS] = req.selections
facet_spec_map = {}
for facet_name, facet_spec in req.facets.iteritems():
facet_spec_map[facet_name] = {
PARAM_FACET_MAX: facet_spec.maxCounts,
PARAM_FACET_ORDER: facet_spec.orderBy,
PARAM_FACET_EXPAND: facet_spec.expand,
PARAM_FACET_MINHIT: facet_spec.minHits
}
if facet_spec_map:
output_json[JSON_PARAM_FACETS] = facet_spec_map
facet_init_map = {}
for facet_name, initParams in req.facet_init_param_map.iteritems():
inner_map = {}
for name, vals in initParams.bool_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_BOOL,
"values" : vals}
for name, vals in initParams.int_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_INT,
"values" : [safe_str(val) for val in vals]}
for name, vals in initParams.long_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_LONG,
"values" : [safe_str(val) for val in vals]}
for name, vals in initParams.string_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_STRING,
"values" : vals}
for name, vals in initParams.byte_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_BYTEARRAY,
"values" : [safe_str(val) for val in vals]}
for name, vals in initParams.double_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_DOUBLE,
"values" : [safe_str(val) for val in vals]}
facet_init_map[facet_name] = inner_map
if facet_init_map:
output_json[JSON_PARAM_FACET_INIT] = facet_init_map
if req.groupby:
# For now we only support group-by on single column
output_json[JSON_PARAM_GROUPBY] = {
JSON_PARAM_COLUMNS: [req.groupby],
JSON_PARAM_TOP: req.max_per_group
}
# print ">>> output_json = ", output_json
return json.dumps(output_json, sort_keys=sort_keys, indent=indent)
@staticmethod
def buildUrlString(req):
paramMap = {}
paramMap[PARAM_OFFSET] = req.offset
paramMap[PARAM_COUNT] = req.count
if req.query:
paramMap[PARAM_QUERY]=req.query
if req.explain:
paramMap[PARAM_SHOW_EXPLAIN] = "true"
if req.fetch_stored:
paramMap[PARAM_FETCH_STORED] = "true"
if req.route_param:
paramMap[PARAM_ROUTE_PARAM] = req.route_param
if req.sorts:
paramMap[PARAM_SORT] = ",".join(sort.build_sort_field() for sort in req.sorts)
if req.qParam.get("query"):
paramMap[PARAM_QUERY] = req.qParam.get("query")
del req.qParam["query"]
if req.qParam:
paramMap[PARAM_QUERY_PARAM] = ",".join(param + ":" + req.qParam.get(param)
for param in req.qParam.keys() if param != "query")
for selection in req.selections.values():
paramMap[selection.getSelectNotParam()] = selection.getSelectNotParamValues()
paramMap[selection.getSelectOpParam()] = selection.operation
paramMap[selection.getSelectValParam()] = selection.getSelectValParamValues()
if selection.properties:
paramMap[selection.getSelectPropParam()] = selection.getSelectPropParamValues()
for facet_name, facet_spec in req.facets.iteritems():
paramMap["%s.%s.%s" % (PARAM_FACET, facet_name, PARAM_FACET_MAX)] = facet_spec.maxCounts
paramMap["%s.%s.%s" % (PARAM_FACET, facet_name, PARAM_FACET_ORDER)] = facet_spec.orderBy
paramMap["%s.%s.%s" % (PARAM_FACET, facet_name, PARAM_FACET_EXPAND)] = facet_spec.expand and "true" or "false"
paramMap["%s.%s.%s" % (PARAM_FACET, facet_name, PARAM_FACET_MINHIT)] = facet_spec.minHits
for facet_name, initParams in req.facet_init_param_map.iteritems():
for name, vals in initParams.bool_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_BOOL
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([val and "true" or "false" for val in vals])
for name, vals in initParams.int_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_INT
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([safe_str(val) for val in vals])
for name, vals in initParams.long_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_LONG
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([safe_str(val) for val in vals])
for name, vals in initParams.string_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_STRING
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join(vals)
for name, vals in initParams.byte_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_BYTEARRAY
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([safe_str(val) for val in vals])
for name, vals in initParams.double_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_DOUBLE
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([safe_str(val) for val in vals])
if req.groupby:
paramMap[PARAM_GROUP_BY] = req.groupby
if req.max_per_group > 0:
paramMap[PARAM_MAX_PER_GROUP] = req.max_per_group
return urllib.urlencode(paramMap)
def doQuery(self, req, using_json=True):
"""Execute a search query."""
time1 = datetime.now()
query_string = None
if using_json: # Use JSON format
# query_string = self.buildJsonString(req)
bql = {"bql": req}
query_string = json.dumps(bql)
else:
query_string = SenseiClient.buildUrlString(req)
logger.debug(query_string)
urlReq = urllib2.Request(self.url, query_string)
res = self.opener.open(urlReq)
line = res.read()
jsonObj = json.loads(line)
logger.debug("Result jsonObj = " + json.dumps(jsonObj))
res = SenseiResult(jsonObj)
delta = datetime.now() - time1
res.total_time = delta.seconds * 1000 + delta.microseconds / 1000
return res
def get_sysinfo(self):
return self.sysinfo
def get_facet_map(self):
return self.facet_map
def run_example(self):
""" a sample sensei request"""
# create a SenseiRequest object firstly;
req = SenseiRequest();
# add paging info;
req.set_count(50)
req.set_offset(0)
# add query info;
# term_query = SenseiQueryTerm("tags", "automatic")
# req.set_query(term_query.get_query())
# add selection info;
req.append_range_selection("year", "1995", "2000", True, False) # [1995 TO 2000)
# add filter info;
range_filter = SenseiFilterRange("price", 7900, 11000)
req.set_filter(range_filter.get_filter())
# add group by;
req.set_groupby("category")
req.set_max_per_group(4)
# add sort;
sort = SenseiSort("color", True)
req.append_sort(sort)
# add fetch_stored
req.set_fetch_stored(False)
# need explain or not
req.set_explain(False)
# execute and display results;
res = self.doQuery(req)
columns = []
columns.append("*")
res.display(columns, max_col_width=40)
class SenseiClient:
"""Sensei client class."""
def __init__(self, host='localhost', port=8080, path='sensei', sysinfo=None):
self.host = host
self.port = port
self.path = path
self.url = 'http://%s:%d/%s' % (self.host, self.port, self.path)
self.opener = urllib2.build_opener()
self.opener.addheaders = [('User-agent', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_7) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.91 Safari/534.30')]
if sysinfo:
self.test_sysinfo = SenseiSystemInfo(sysinfo)
self.sysinfo = self.test_sysinfo
else:
# Here we assume that the index has been started
self.test_sysinfo = None
urlReq = urllib2.Request(self.url + "/sysinfo")
res = self.opener.open(urlReq)
line = res.read()
jsonObj = json.loads(line)
self.sysinfo = SenseiSystemInfo(jsonObj)
self.facet_map = {}
for facet_info in self.sysinfo.get_facet_infos():
self.facet_map[facet_info.get_name()] = facet_info
self.parser = BQLParser(self.facet_map)
def compile(self, bql_stmt):
tokens = self.parser.parse(bql_stmt)
if tokens:
logger.debug("tokens: %s" % tokens)
bql_req = BQLRequest(tokens, self.facet_map)
return SenseiRequest(bql_req, facet_map=self.facet_map)
return None
def buildJsonString(self, req, sort_keys=True, indent=None):
"""Build a Sensei request in JSON format.
Once built, a Sensei request in JSON format can be sent to a Sensei
broker using the following command:
$ curl -XPOST http://localhost:8080/sensei -d '{
"fetchStored": "true",
"from": 0,
"size": 10
}'
"""
output_json = {}
output_json[JSON_PARAM_FROM] = req.offset
output_json[JSON_PARAM_SIZE] = req.count
if req.query:
output_json[JSON_PARAM_QUERY] = {
JSON_PARAM_QUERY_STRING: {
JSON_PARAM_QUERY: req.query
}
}
if req.explain:
output_json[JSON_PARAM_QUERY] = True
if req.fetch_stored:
output_json[JSON_PARAM_FETCH_STORED] = True
if req.route_param:
output_json[JSON_PARAM_ROUTEPARAM] = req.route_param
if req.sorts:
output_json[JSON_PARAM_SORT] = [sort.build_sort_spec() for sort in req.sorts]
if req.filter:
output_json[JSON_PARAM_FILTER] = req.filter
if req.query_pred:
output_json[JSON_PARAM_QUERY] = req.query_pred[JSON_PARAM_QUERY]
if req.selections:
output_json[JSON_PARAM_SELECTIONS] = req.selections
facet_spec_map = {}
for facet_name, facet_spec in req.facets.iteritems():
facet_spec_map[facet_name] = {
PARAM_FACET_MAX: facet_spec.maxCounts,
PARAM_FACET_ORDER: facet_spec.orderBy,
PARAM_FACET_EXPAND: facet_spec.expand,
PARAM_FACET_MINHIT: facet_spec.minHits
}
if facet_spec_map:
output_json[JSON_PARAM_FACETS] = facet_spec_map
facet_init_map = {}
for facet_name, initParams in req.facet_init_param_map.iteritems():
inner_map = {}
for name, vals in initParams.bool_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_BOOL,
"values" : vals}
for name, vals in initParams.int_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_INT,
"values" : [safe_str(val) for val in vals]}
for name, vals in initParams.long_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_LONG,
"values" : [safe_str(val) for val in vals]}
for name, vals in initParams.string_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_STRING,
"values" : vals}
for name, vals in initParams.byte_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_BYTEARRAY,
"values" : [safe_str(val) for val in vals]}
for name, vals in initParams.double_map.iteritems():
inner_map[name] = {PARAM_DYNAMIC_TYPE : PARAM_DYNAMIC_TYPE_DOUBLE,
"values" : [safe_str(val) for val in vals]}
facet_init_map[facet_name] = inner_map
if facet_init_map:
output_json[JSON_PARAM_FACET_INIT] = facet_init_map
if req.groupby:
# For now we only support group-by on single column
output_json[JSON_PARAM_GROUPBY] = {
JSON_PARAM_COLUMNS: [req.groupby],
JSON_PARAM_TOP: req.max_per_group
}
# print ">>> output_json = ", output_json
return json.dumps(output_json, sort_keys=sort_keys, indent=indent)
@staticmethod
def buildUrlString(req):
paramMap = {}
paramMap[PARAM_OFFSET] = req.offset
paramMap[PARAM_COUNT] = req.count
if req.query:
paramMap[PARAM_QUERY]=req.query
if req.explain:
paramMap[PARAM_SHOW_EXPLAIN] = "true"
if req.fetch_stored:
paramMap[PARAM_FETCH_STORED] = "true"
if req.route_param:
paramMap[PARAM_ROUTE_PARAM] = req.route_param
if req.sorts:
paramMap[PARAM_SORT] = ",".join(sort.build_sort_field() for sort in req.sorts)
if req.qParam.get("query"):
paramMap[PARAM_QUERY] = req.qParam.get("query")
del req.qParam["query"]
if req.qParam:
paramMap[PARAM_QUERY_PARAM] = ",".join(param + ":" + req.qParam.get(param)
for param in req.qParam.keys() if param != "query")
for selection in req.selections.values():
paramMap[selection.getSelectNotParam()] = selection.getSelectNotParamValues()
paramMap[selection.getSelectOpParam()] = selection.operation
paramMap[selection.getSelectValParam()] = selection.getSelectValParamValues()
if selection.properties:
paramMap[selection.getSelectPropParam()] = selection.getSelectPropParamValues()
for facet_name, facet_spec in req.facets.iteritems():
paramMap["%s.%s.%s" % (PARAM_FACET, facet_name, PARAM_FACET_MAX)] = facet_spec.maxCounts
paramMap["%s.%s.%s" % (PARAM_FACET, facet_name, PARAM_FACET_ORDER)] = facet_spec.orderBy
paramMap["%s.%s.%s" % (PARAM_FACET, facet_name, PARAM_FACET_EXPAND)] = facet_spec.expand and "true" or "false"
paramMap["%s.%s.%s" % (PARAM_FACET, facet_name, PARAM_FACET_MINHIT)] = facet_spec.minHits
for facet_name, initParams in req.facet_init_param_map.iteritems():
for name, vals in initParams.bool_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_BOOL
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([val and "true" or "false" for val in vals])
for name, vals in initParams.int_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_INT
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([safe_str(val) for val in vals])
for name, vals in initParams.long_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_LONG
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([safe_str(val) for val in vals])
for name, vals in initParams.string_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_STRING
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join(vals)
for name, vals in initParams.byte_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_BYTEARRAY
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([safe_str(val) for val in vals])
for name, vals in initParams.double_map.iteritems():
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name, PARAM_DYNAMIC_TYPE)] = PARAM_DYNAMIC_TYPE_DOUBLE
paramMap["%s.%s.%s.%s" %
(PARAM_DYNAMIC_INIT, facet_name, name,
PARAM_DYNAMIC_VAL)] = ','.join([safe_str(val) for val in vals])
if req.groupby:
paramMap[PARAM_GROUP_BY] = req.groupby
if req.max_per_group > 0:
paramMap[PARAM_MAX_PER_GROUP] = req.max_per_group
return urllib.urlencode(paramMap)
def doQuery(self, req, using_json=True, var_map={}):
"""Execute a search query."""
time1 = datetime.now()
query_string = None
if using_json: # Use JSON format
bql = {"bql": req}
if var_map:
bql["templateMapping"] = var_map;
query_string = json.dumps(bql)
else:
query_string = SenseiClient.buildUrlString(req)
logger.debug(query_string)
urlReq = urllib2.Request(self.url, query_string)
res = self.opener.open(urlReq)
line = res.read()
jsonObj = json.loads(line)
logger.debug("Result jsonObj = " + json.dumps(jsonObj))
res = SenseiResult(jsonObj)
delta = datetime.now() - time1
res.total_time = delta.seconds * 1000 + delta.microseconds / 1000
return res
def get_sysinfo(self):
"""Get Sensei system info."""
if self.test_sysinfo:
return self.test_sysinfo
urlReq = urllib2.Request(self.url + "/sysinfo")
res = self.opener.open(urlReq)
line = res.read()
jsonObj = json.loads(line)
self.sysinfo = SenseiSystemInfo(jsonObj)
return self.sysinfo
def get_facet_map(self):
return self.facet_map
def run_example(self):
""" a sample sensei request"""
# create a SenseiRequest object firstly;
req = SenseiRequest();
# add paging info;
req.set_count(50)
req.set_offset(0)
# add query info;
# term_query = SenseiQueryTerm("tags", "automatic")
# req.set_query(term_query.get_query())
# add selection info;
req.append_range_selection("year", "1995", "2000", True, False) # [1995 TO 2000)
# add filter info;
range_filter = SenseiFilterRange("price", 7900, 11000)
req.set_filter(range_filter.get_filter())
# add group by;
req.set_groupby("category")
req.set_max_per_group(4)
# add sort;
sort = SenseiSort("color", True)
req.append_sort(sort)
# add fetch_stored
req.set_fetch_stored(False)
# need explain or not
req.set_explain(False)
# execute and display results;
res = self.doQuery(req)
columns = []
columns.append("*")
res.display(columns, max_col_width=40)
