def get(self, request, **kwargs): if check_user(request): return check_user(request) id = request.GET.get('id', False) if id: executeQuery("SET FOREIGN_KEY_CHECKS = 0", False) user = User.objects.get(pk=id) user.delete() return HttpResponse("ok") return HttpResponse("ko")
def get(self, request, **kwargs): if check_user(request): return check_user(request) id = int(request.GET.get('id', False)) sql = 'select * from sensor where id_user = %d' % (id) return HttpResponse(dumps(executeQuery(sql), default=myconverter), content_type='application/json; charset=utf-8')
def get(self, request, **kwargs): if check_user(request): return check_user(request) sql = 'select * from sensor where id_user in ( select id_sub from user_created_by where id_super=%d)' % ( int(request.user.id)) return HttpResponse(dumps(executeQuery(sql), default=myconverter), content_type='application/json; charset=utf-8')
def get(self, request, **kwargs): if check_user(request): return check_user(request) sql = 'select id,first_name,last_name,email,username from auth_user,user_created_by where auth_user.id=user_created_by.id_sub and user_created_by.id_super=%d' % ( request.user.id) return HttpResponse(dumps(executeQuery(sql), default=myconverter), content_type='application/json; charset=utf-8')
def get(self, request, **kwargs): if check_user(request): return check_user(request) id = request.GET.get('id', False) if id: sql = 'select * from sensor,statique where sensor.id=statique.id_sensor and sensor.id=%d' % ( int(id)) if executeQuery(sql): d = executeQuery(sql) else: d = executeQuery('select * from sensor where id=' + id) info = d[0] data = dumps(d, default=myconverter) return render(request, 'InfoSensor.html', { 'data': data, 'info': info }) return HttpResponse('kooooooooooooooooo')
def get(self, request, **kwargs): if check_user(request): return check_user(request) username = request.GET['username'] password = request.GET['password'] first_name = request.GET['first_name'] last_name = request.GET['last_name'] email = request.GET['email'] cin = request.GET['cin'] dn = request.GET['dn'] city = request.GET['city'] job = request.GET['job'] tel = request.GET['tel'] adress = request.GET['adresse'] user = User.objects.create_user(username, email, password) user.first_name = first_name user.last_name = last_name executeQuery( 'insert into user_created_by values(%d,%d)' % (request.user.id, user.id), False) executeQuery('insert into user_privi values(%d,3)' % (user.id), False) executeQuery( "insert into user_info values(%d,'%s','%s','%s','%s','%s','%s')" % (user.id, cin, dn, job, city, tel, adress), False) user.save() return HttpResponse('ohoooooooooooooooooooooooooo!!!!')
def get(self, request, **kwargs): if check_user(request): return check_user(request) id = request.GET.get('id', False) if not id: sql = 'select id,first_name,last_name,email,job,cin,dn,city,adresse,tel from auth_user,user_info where auth_user.id=user_info.id_user and auth_user.id=%d' % ( request.user.id) else: sql = 'select id,first_name,last_name,email,job,cin,dn,city,adresse,tel from auth_user,user_info where auth_user.id=user_info.id_user and auth_user.id=%d' % ( int(id)) response = HttpResponse(dumps(executeQuery(sql), default=myconverter), content_type='application/json; charset=utf-8') response["Access-Control-Allow-Origin"] = "*" response["Access-Control-Allow-Methods"] = "POST, GET, OPTIONS" response["Access-Control-Max-Age"] = "1000" response["Access-Control-Allow-Headers"] = "*" return response
def get(self, request, **kwargs): if check_user(request): return check_user(request) first_name = request.GET['first_name'] last_name = request.GET['last_name'] email = request.GET['email'] cin = request.GET['cin'] dn = request.GET['dn'] city = request.GET['city'] job = request.GET['job'] tel = request.GET['tel'] adresse = request.GET['adresse'] user = User.objects.get(pk=request.user.id) user.first_name = first_name user.last_name = last_name user.email = email user.save() sql = "update info_user set cin='%s',dn='%s',city='%s',job='%s',tel='%s',adresse='%s' where id_user=%d" % ( cin, dn, city, job, tel, adresse, request.user.id) if executeQuery(sql, False): return HttpResponse('ok ') return HttpResponse('ko')
def get(self, request, **kwargs): if check_user(request): return check_user(request) sql = 'select sensor.id,username,model,sensor_name from sensor,auth_user where auth_user.id=sensor.id_user' return HttpResponse(dumps(executeQuery(sql), default=myconverter), content_type='application/json; charset=utf-8')