def _poll_vq_single(self, dname, use_devmode, ddresp): """ Initiate a view query for a view located in a design document :param ddresp: The design document to poll (as JSON) :return: True if successful, False if no views. """ vname = None query = None v_mr = ddresp.get('views', {}) v_spatial = ddresp.get('spatial', {}) if v_mr: vname = single_dict_key(v_mr) query = Query() elif v_spatial: vname = single_dict_key(v_spatial) query = SpatialQuery() if not vname: return False query.stale = STALE_OK query.limit = 1 for r in self._cb.query(dname, vname, use_devmode=use_devmode, query=query): pass return True
def show_customer(customer): doc = db.get(customer, quiet=True) if not doc.success: return "No such customer {0}".format(customer), 404 obj = CustomerRow(name=doc.value['name'], value=None, id=customer, doc=doc.value) rp = Node_SnapshotListRowProcessor() q = Query() q.mapkey_single = customer q.limit = ENTRIES_PER_PAGE log_rows = db.query("node_snapshot", "by_customer", row_processor=rp, query=q, include_docs=True) logs = [] for log in log_rows: logs.append({'id' : log.id, 'name' : log.name}) rp = RowProcessor(rowclass=CustomerRow) cluster_rows = db.query("cluster", "by_customer", row_processor=rp, query=q, include_docs=True) clusters = [] for cluster in cluster_rows: clusters.append({'id' : cluster.id, 'name' : cluster.name}) return render_template('/customer/show.html', customer=obj, logs=logs, clusters=clusters)
def getAllFactors(): q = Query() q.limit = 1 rows = c.query("dev_factor", "all", query=q) result = list() print rows for row in rows: result.append(row.key) return json.dumps(result)
def brewery_search(): value = request.args.get('value') q = Query() q.mapkey_range = [value, value + Query.STRING_RANGE_END] q.limit = ENTRIES_PER_PAGE ret = [] rp = BreweryRowProcessor() res = db.query("brewery", "by_name", row_processor=rp, query=q, include_docs=True) for brewery in res: ret.append({'id' : brewery.id, 'name' : brewery.name}) return return_search_json(ret)
def beer_search(): value = request.args.get('value') q = Query() q.mapkey_range = [value, value + Query.STRING_RANGE_END] q.limit = ENTRIES_PER_PAGE ret = [] res = db.query("beer", "by_name", row_processor=BeerRowProcessor(), query=q, include_docs=True) for beer in res: ret.append({'id' : beer.id, 'name' : beer.name, 'brewery' : beer.brewery_id}) return return_search_json(ret)
def customer_search(): value = request.args.get('value') q = Query() q.mapkey_range = [value, value + Query.STRING_RANGE_END] q.limit = ENTRIES_PER_PAGE ret = [] rp = RowProcessor(rowclass=CustomerRow) res = db.query("customer", "by_name", row_processor=rp, query=q, include_docs=True) for customer in res: print customer ret.append({'id' : customer.id, 'name' : customer.name}) return return_search_json(ret)
def log_search(): value = request.args.get('value') q = Query() q.mapkey_range = [value, value + Query.STRING_RANGE_END] q.limit = ENTRIES_PER_PAGE ret = [] rp = Node_SnapshotListRowProcessor() res = db.query("node_snapshot", "by_name", row_processor=rp, query=q, include_docs=True) for log in res: ret.append({'id' : log.id, 'name' : log.name, 'customer' : log.customer_id}) return return_search_json(ret)