def general_collection_api_aggregate(endpoint_name, collection_id):
endpoint = MongoConn.get_collection("endpoints")
ept = endpoint.find_one({'endpoint_name': endpoint_name})
if ept is not None:
collection_list = MongoConn.get_collection(ept['collection_list'])
c = collection_list.find_one({'_id': ObjectId(collection_id)})
if c is not None:
collection = MongoConn.get_collection(c['collection_name'])
req = request.json
print(req)
results = list(collection.aggregate(req))
msg = json.loads(JSONUtils.JSONEncoder().encode(results))
else:
msg = {
'result': 'failed',
'msg': "Collection_id: " + collection_id + " does not exist"
}
else:
msg = {
'result': 'failed',
'msg': "Endpoint " + endpoint_name + " does not exist"
}
return jsonify(msg)
def general_endpoint_api_get(endpoint_name, collection_id):
endpoint = MongoConn.get_endpoints_col()
ept = endpoint.find_one({'endpoint_name': endpoint_name})
if ept is not None:
collection_list = MongoConn.get_collection(ept['collection_list'])
c = collection_list.find_one({'_id': ObjectId(collection_id)})
limit = int(request.args.get('limit'))
offset = int(request.args.get('offset'))
if c is not None:
collection = MongoConn.get_collection(c['collection_name'])
results = list(collection.find().skip(offset).limit(limit))
msg = json.loads(JSONUtils.JSONEncoder().encode(results))
else:
msg = {
'result': 'failed',
'msg': "Collection_id: " + collection_id + " does not exist"
}
else:
msg = {
'result': 'failed',
'msg': "Endpoint " + endpoint_name + " does not exist"
}
return jsonify(msg)
def general_endpoint_api_list(endpoint_name):
endpoint = MongoConn.get_endpoints_col()
ept = endpoint.find_one({'endpoint_name': endpoint_name})
if ept is not None:
collection_list = MongoConn.get_collection(ept['collection_list'])
collections = list(collection_list.find())
return JSONUtils.JSONEncoder().encode(collections)
else:
msg = {
'result': 'failed',
'msg': "Endpoint " + endpoint_name + " does not exist"
}
return jsonify(msg)
def db_select():
json = request.json
rows = PostgreConn.db_table_select(json)
return JSONUtils.JSONEncoder().encode(rows)
def admin_endpoint_api_list():
endpoint = MongoConn.get_endpoints_col()
endpoints = list(endpoint.find())
return JSONUtils.JSONEncoder().encode(endpoints)
def admin_users_api_list():
user = MongoConn.get_user_col()
users = list(user.find())
return JSONUtils.JSONEncoder().encode(users)