def info(request, coll_name): content = {} db = getConn(request) # db = connection[request.session['db']] items_per_page = 10 if "page" in request.GET: page = int(request.GET.get('page')) else: page = 1 no_pages = int(math.ceil(float(db[coll_name].find().count()) / items_per_page)) content = { 'count': db[coll_name].count(), 'documents': list(db[coll_name].find())[(page - 1) * items_per_page:page * items_per_page], 'collstats': db.command("collstats", coll_name), 'collections': db.collection_names(), 'db': request.session['db'], 'name': coll_name, 'read': True, 'coll_name': coll_name, 'dbstats': db.command("dbstats"), 'current_page': page, 'last_page': no_pages, 'request': request, } return render_to_response('home.html', content)
def index(request): if request.method == "POST": db = mongoauth(request.POST.get('host'), request.POST.get('port'), request.POST.get('db'), request.POST.get('uid'), request.POST.get('pwd')) if not db: data = {'login': False} return HttpResponse(json.dumps(data)) else: request.session['host'] = request.POST.get('host') request.session['port'] = request.POST.get('port') request.session['db'] = request.POST.get('db') request.session['uid'] = request.POST.get('uid') request.session['pwd'] = request.POST.get('pwd') request.session['login'] = True data = {'login': True} return HttpResponse(json.dumps(data)) elif 'login' in request.session: content = {} db = getConn(request) content['collections'] = db.collection_names() content['request'] = request return render_to_response('home.html', content) else: c = {} c.update(csrf(request)) return render_to_response('login.html', {'csrf_token': c['csrf_token']})
def info(request, coll_name): content = {} db = getConn(request) # db = connection[request.session['db']] items_per_page = 10 if "page" in request.GET: page = int(request.GET.get('page')) else: page = 1 no_pages = int( math.ceil(float(db[coll_name].find().count()) / items_per_page)) content = { 'count': db[coll_name].count(), 'documents': list(db[coll_name].find())[(page - 1) * items_per_page:page * items_per_page], 'collstats': db.command("collstats", coll_name), 'collections': db.collection_names(), 'db': request.session['db'], 'name': coll_name, 'read': True, 'coll_name': coll_name, 'dbstats': db.command("dbstats"), 'current_page': page, 'last_page': no_pages, 'request': request, } return render_to_response('home.html', content)
def query_process(request): content = {} coll_name = request.POST.get('collection') # db = connection[request.session['db']] db = getConn(request) content = { 'collections': db.collection_names(), 'db': request.session['db'], 'request': request, } if request.method == 'GET': c = {} c.update(csrf(request)) return render_to_response('home.html', {'csrf_token': c['csrf_token'], 'request': request, 'content': content}) q = request.POST.get('ta') if not q.startswith('db'): resp = 'Please Enter Valid Query:' return render_to_response('home.html', {'resp': resp, 'request': request, 'content': content}) m = re.search("({.*})", q) if m is None: d = None else: d = m.group(0) resp = None try: if 'insert' in q: try: c = db[q.split('.')[1]] except Exception as e: c = db.createCollection(q.split('.')[1]) try: d = ast.literal_eval(d) resp = c.save(d) resp = 'Status: Document Inserted Succesfully ' + str(resp) except (SyntaxError, TypeError, ValueError, NameError): resp = 'Please Enter Valid Query' return render_to_response('home.html', {'resp': resp, 'request': request, 'content': content}) if 'remove' in q: try: c = db[q.split('.')[1]] except Exception as e: pass if d is None: c.remove() resp = 'Status: Documents Removed Succesfully' return render_to_response('home.html', {'resp': resp, 'request': request, 'content': content}) try: d = ast.literal_eval(d) resp = c.remove(d) resp = 'Status: ' + str(resp) except (SyntaxError, TypeError, ValueError, NameError): resp = 'Please Enter valid Query' return render_to_response('home.html', {'resp': resp, 'request': request, 'content': content}) if 'update' in q: try: c = db[q.split('.')[1]] except Exception as e: pass try: d = ast.literal_eval(d) resp = c.update(d[0], {'$set': d[1]}) resp = 'Status: ' + str(resp) except (SyntaxError, TypeError, ValueError, NameError): resp = "Please Enter valid Query" return render_to_response('home.html', {'resp': resp, 'request': request, 'content': content}) if 'find' in q: c = db[q.split('.')[1]] if d: d = ast.literal_eval(d) if c is None: resp = 'Collection not found' else: if 'findOne' in q: resp = dumps(c.find_one(d)) resp = list(resp) else: resp = c.find(d) resp = list(resp) return render_to_response('home.html', {'documents': resp, 'request': request, 'coll_name': c.name, 'content': content}) resp = list(c.find()) return render_to_response('home.html', {'documents': resp, 'request': request, 'coll_name': c.name, 'content': content}) if 'drop' in q: try: c = db[q.split('.')[1]] c.drop() resp = "Status: Collection Dropped Succesfully" except Exception as e: resp = "Please Enter Valid Collection Name or Query" return render_to_response('home.html', {'resp': resp, 'request': request, 'content': content}) resp = "'Please Enter valid Query'" return render_to_response('home.html', {'resp': resp, 'request': request, 'content': content}) except Exception as e: return render_to_response('home.html', {'resp': resp, 'request': request, 'content': content})
def query_process(request): content = {} coll_name = request.POST.get('collection') # db = connection[request.session['db']] db = getConn(request) content = { 'collections': db.collection_names(), 'db': request.session['db'], 'request': request, } if request.method == 'GET': c = {} c.update(csrf(request)) return render_to_response('home.html', { 'csrf_token': c['csrf_token'], 'request': request, 'content': content }) q = request.POST.get('ta') if not q.startswith('db'): resp = 'Please Enter Valid Query:' return render_to_response('home.html', { 'resp': resp, 'request': request, 'content': content }) m = re.search("({.*})", q) if m is None: d = None else: d = m.group(0) resp = None try: if 'insert' in q: try: c = db[q.split('.')[1]] except Exception as e: c = db.createCollection(q.split('.')[1]) try: d = ast.literal_eval(d) resp = c.save(d) resp = 'Status: Document Inserted Succesfully ' + str(resp) except (SyntaxError, TypeError, ValueError, NameError): resp = 'Please Enter Valid Query' return render_to_response('home.html', { 'resp': resp, 'request': request, 'content': content }) if 'remove' in q: try: c = db[q.split('.')[1]] except Exception as e: pass if d is None: c.remove() resp = 'Status: Documents Removed Succesfully' return render_to_response('home.html', { 'resp': resp, 'request': request, 'content': content }) try: d = ast.literal_eval(d) resp = c.remove(d) resp = 'Status: ' + str(resp) except (SyntaxError, TypeError, ValueError, NameError): resp = 'Please Enter valid Query' return render_to_response('home.html', { 'resp': resp, 'request': request, 'content': content }) if 'update' in q: try: c = db[q.split('.')[1]] except Exception as e: pass try: d = ast.literal_eval(d) resp = c.update(d[0], {'$set': d[1]}) resp = 'Status: ' + str(resp) except (SyntaxError, TypeError, ValueError, NameError): resp = "Please Enter valid Query" return render_to_response('home.html', { 'resp': resp, 'request': request, 'content': content }) if 'find' in q: c = db[q.split('.')[1]] if d: d = ast.literal_eval(d) if c is None: resp = 'Collection not found' else: if 'findOne' in q: resp = dumps(c.find_one(d)) resp = list(resp) else: resp = c.find(d) resp = list(resp) return render_to_response( 'home.html', { 'documents': resp, 'request': request, 'coll_name': c.name, 'content': content }) resp = list(c.find()) return render_to_response( 'home.html', { 'documents': resp, 'request': request, 'coll_name': c.name, 'content': content }) if 'drop' in q: try: c = db[q.split('.')[1]] c.drop() resp = "Status: Collection Dropped Succesfully" except Exception as e: resp = "Please Enter Valid Collection Name or Query" return render_to_response('home.html', { 'resp': resp, 'request': request, 'content': content }) resp = "'Please Enter valid Query'" return render_to_response('home.html', { 'resp': resp, 'request': request, 'content': content }) except Exception as e: return render_to_response('home.html', { 'resp': resp, 'request': request, 'content': content })