def update(id): try: room = request.json['room'] location = request.json['location'] capacity = request.json['capacity'] rooms = Rooms.query.filter_by(id=id).first() rooms.room = room rooms.location = location rooms.capacity = capacity db.session.commit() return response.ok('', 'Successfully update data!') except Exception as e: print(e)
def store(): print('OOIII') try: print('request', request.json['name']) name = request.json['name'] email = request.json['email'] password = request.json['password'] print('DB', db) users = Users(name=name, email=email) users.setPassword(password) db.session.add(users) db.session.commit() print('CEK RESPON', response) return response.ok('', 'Successfully create data!') except Exception as e: print(e)
def update(id): try: name = request.json['name'] image = request.json['image'] address = request.json['address'] rating = request.json['rating'] merchant = Merchants.query.filter_by(id=id).first() merchant.name = name merchant.image = image merchant.address = address merchant.rating = rating db.session.commit() return response.ok('', 'Successfully update Merchant !') except Exception as e: print(e)
def update(id): try: name = request.json['name'] email = request.json['email'] password = request.json['password'] user = Users.query.filter_by(id=id).first() user.email = email user.name = name user.setPassword(password) db.session.commit() return response.ok('', 'Successfully update data!') except Exception as e: print(e)
def update(id): try: payment_type = request.json['payment_type'] gross_amount = request.json['gross_amount'] bank = request.json['bank'] order_id = request.json['order_id'] payment = Payments.query.filter_by(id=id).first() payment.payment_type = payment_type payment.gross_amount = gross_amount payment.bank = bank payment.order_id = order_id db.session.commit() return response.ok('', 'Successfully update Payment !') except Exception as e: print(e)
def store(): try: name = request.json['name'] stock = request.json['stock'] price = request.json['price'] suplier_id = request.json['suplier_id'] product = Products(name=name, stock=stock, price=price, suplier_id=suplier_id) db.session.add(product) db.session.commit() return response.ok('', 'Successfully Create Product !') except Exception as e: print(e)
def store(): try: nim = request.json['nim'] nama = request.json['nama'] email = request.json['email'] password = request.json['password'] users = Users(nim=nim, nama=nama, email=email) users.setPassword(password) db.session.add(users) db.session.commit() return response.ok('', 'Successfully create data!') except Exception as e: print(e)
def update(id): try: title = request.json['title'] message = request.json['message'] tipe = request.json['tipe'] dari = request.json['dari'] notification = Notifications.query.filter_by(id=id).first() notification.title = title notification.message = message notification.tipe = tipe notification.dari = dari db.session.commit() return response.ok('', 'Successfully update Notification !') except Exception as e: print(e)
def updatepembayaran(idpembayaran): try: deskripsi = request.json['deskripsi'] bank = request.json['bank'] norek = request.json['norek'] pembayaran = DetailPembayaran.query.filter_by( idpembayaran=idpembayaran).first() pembayaran.deskripsi = deskripsi pembayaran.bank = bank pembayaran.norek = norek db.session.commit() return response.ok('', 'Berhasil update data pembayaran!') except Exception as e: print(e)
def store(): try: full_name = request.json['full_name'] username = request.json['username'] email = request.json['email'] password = request.json['password'] role = request.json['role'] users = Users(full_name=full_name, username=username, email=email, role=role) users.setPassword(password) db.session.add(users) db.session.commit() return response.ok('', 'Successfully create User!') except Exception as e: print(e)
def update(id): try: full_name = request.json['full_name'] username = request.json['username'] email = request.json['email'] phone_number = request.json['phone_number'] gender = request.json['gender'] customer = Customers.query.filter_by(id = id).first() customer.full_name = full_name customer.username = username customer.email = email customer.phone_number = phone_number customer.gender = gender db.session.commit() return response.ok('', 'Successfully update Customer !') except Exception as e: print(e)
def update(id): try: nim = request.json['nim'] nama_mahasiswa = request.json['nama_mahasiswa'] mutu = request.json['mutu'] jumlah_sks = request.json['jumlah_sks'] ipk = request.json['ipk'] # ipk = float(mutu)/float(jumlah_sks) mahasiswa = Mahasiswas.query.filter_by(id=id).first() mahasiswa.nim = nim mahasiswa.nama_mahasiswa = nama_mahasiswa mahasiswa.mutu = mutu mahasiswa.jumlah_sks = jumlah_sks mahasiswa.ipk = ipk db.session.commit() return response.ok('', 'Successfully update IPK') except Exception as e: print(e)
def store(): try: nim = request.json['nim'] nama_mahasiswa = request.json['nama_mahasiswa'] mutu = request.json['mutu'] jumlah_sks = request.json['jumlah_sks'] ipk = request.json['ipk'] # ipk = mutu / jumlah_sks user_id = request.json['user_id'] mahasiswa = Mahasiswas(user_id=user_id, nim=nim, nama_mahasiswa=nama_mahasiswa, mutu=mutu, jumlah_sks=jumlah_sks, ipk=ipk) db.session.add(mahasiswa) db.session.commit() return response.ok('', 'Successfully create IPK') # print(mutu, jumlah_sks) except Exception as e: print(e)
def show(id): try: user_token = get_jwt_identity() if user_token["role"] != "admin": bookings = Bookings.query.filter_by( id=id, user_id=user_token['id']).first() else: bookings = Bookings.query.filter_by(id=id).first() if not bookings: return response.badRequest([], 'Empty....') data = singleTransform(bookings, withUser=True, withRoom=True) # pprint(data) data = ParseDateAndTimeBookingToString(data) # pprint(data) return response.ok(data, "") except Exception as e: print(e)
def store(): try: user_id = request.json["user_id"] account = request.json["account"] result = request.json["result"] start = request.json["start"] end = request.json["end"] tweets = request.json["tweets"] detection = Detection( user_id=user_id, account=account, result=result, start=start, end=end ) db.session.add(detection) db.session.commit() bulk = [] for t in tweets: bulk.append( History( detection_id=detection.id, raw_tweet=t["raw"], processed_tweet=t["processed"], timestamp=t["timestamp"], depressive=t["label"], ) ) db.session.add_all(bulk) db.session.commit() data = { "id": detection.id, "user_id": user_id, "account": account, "start": start, "end": end, "tweets": tweets, } return response.ok(data, "Successfully create data!") except Exception as e: return response.badRequest([], str(e))
async def update(id: str, request: Request) -> JSONResponse: try: body = await request.json() title = body['title'] description = body['description'] todo = Todos.objects(id=id).first() if todo is None: raise Exception('todo tidak ditemukan!') todo.title = title todo.description = description todo.save() todos = TodoTransformer.singleTransform(todo) return response.ok(todos, "Berhasil Mengubah Todo!") except Exception as e: return response.badRequest('', f'{e}')
def update(event_id): try: input_description = request.json['description'] except Exception as e: return response.badRequest("", Message.CONST_REQUIRED_UPDATE_EVENT_VALIDATION) try: event = Events.query.filter_by(id=event_id).first() if not event: return response.badRequest([], Message.CONST_EVENT_NOT_FOUND) event.description = input_description db.session.commit() data = singleTransform(event) return response.ok(data, Message.CONST_SUCCESS_UPDATE_EVENT_MESSAGE) except Exception as e: print(e) return response.internalServerError()
def on_post(self, req, resp): """Send newsletter to all subscribers""" try: raw_json = req.stream.read() result = json.loads(raw_json, encoding='utf-8') validate_newsletter(result) except Exception as e: raise HTTPBadRequest('Invalid JSON', e.message) else: try: rdb = RethinkDBClient() subscribers = rdb.get_everyone("subscribers") map( lambda s: send_mail.delay( json.loads(s)["email"], result["subject"], result[ "body"]), subscribers) resp.body = ok(ret='Sent to worker for delivery') except Exception as e: raise HTTPBadRequest('Bad Request', e.message)
def index(): try: print(get_jwt_identity()) user_token = get_jwt_identity() print(user_token) for key, value in user_token.items(): print(f"{key} : {value}") if user_token['role'] == 'admin': bookings = Bookings.query.all() else: bookings = Bookings.query.filter_by(user_id=user_token['id']).all() data = transform(bookings) # pprint(data) data = ParseDateAndTimeBookingToString(data) # pprint(data) return response.ok(data, "OKE DATA BOOKINGS TAMPIL") except Exception as e: print(e)
def store(): try: account = request.json["account"] content = request.json["content"] label = request.json["label"] tweet = Tweets(account=account, content=content, label=label) db.session.add(tweet) db.session.commit() data = { "id": tweet.id, "account": tweet.account, "content": tweet.content, "label": tweet.label, } return response.ok(data, "Successfully create data!") except Exception as e: return response.badRequest([], str(e))
async def update(id: str, request: Request) -> JSONResponse: try: body = await request.json() name = body['name'] if name == "": raise Exception("name couldn't be empty!") user = Users.objects(id=id).first() if user is None: raise Exception('user tidak ditemukan!') user.name = name user.save() transformer = UserTransformer.singleTransform(user) return response.ok(transformer, "Berhasil Mengubah User!") except Exception as e: return response.badRequest('', f'{e}')
def update(id): try: full_name = request.json['full_name'] username = request.json['username'] email = request.json['email'] password = request.json['password'] role = request.json['role'] user = Users.query.filter_by(id=id).first() user.email = email user.username = username user.full_name = full_name user.role = role user.setPassword(password) db.session.commit() return response.ok('', 'Successfully update Userr!') except Exception as e: print(e)
def post(self): try: name = request.json['name'] email = request.json['email'] password = request.json['password'] users = Users(name=name, email=email) users.setPassword(password) db.session.add(users) db.session.commit() access_token = jwt.encode(users) refresh_token = jwt.encode(users, access=False) return response.ok({ 'access_token': access_token, 'refresh_token': refresh_token }, 'Successfully create data!') except Exception as e: return response.badRequest('', e)
def store(): try: airline_code = request.json['airline_code'] flight_number = request.json['flight_number'] departure_port = request.json['departure_port'] arrival_port = request.json['arrival_port'] departure_time = request.json['departure_time'] arrival_time = request.json['arrival_time'] flight = Flights(airline_code=airline_code, \ flight_number=flight_number, departure_port=departure_port,\ arrival_port = arrival_port, \ departure_time = departure_time,\ arrival_time = arrival_time) db.session.add(flight) db.session.commit() return response.ok("OK", "Successfully stored data") except Exception as e: print(e)
def adduser(): try: name = request.json['name'] email = request.json['email'] sekolah = request.json['sekolah'] kota = request.json['kota'] password = request.json['password'] users = User(name=name, email=email, sekolah=sekolah, kota=kota, password=password) users.setPassword(password) db.session.add(users) db.session.commit() return response.ok('', 'Berhasil membuat user!') except Exception as e: print(e)
def update(id): try: full_name = request.json['full_name'] username = request.json['username'] email = request.json['email'] phone_number = request.json['phone_number'] gender = request.json['gender'] address = request.json['address'] customer = Customers.query.filter_by(id = id).first() customer.full_name = full_name customer.username = username customer.email = email customer.phone_number = phone_number customer.gender = gender customer.address = address db.session.commit() return response.ok('', 'Berhasil memperbaharui Data Customer !') except Exception as e: print(e)
def updateuser(iduser): try: name = request.json['name'] email = request.json['email'] sekolah = request.json['sekolah'] kota = request.json['kota'] password = request.json['password'] user = User.query.filter_by(iduser=iduser).first() user.email = email user.name = name user.sekolah = sekolah user.kota = kota user.setPassword(password) db.session.commit() return response.ok('', 'Berhasil update data user!') except Exception as e: print(e)
def on_put(self, req, resp, id): """Update subscriber""" try: raw_json = req.stream.read() result = json.loads(raw_json, encoding='utf-8') validate_subscriber(result) rdb = RethinkDBClient() rdb.get(self._table_name, 'id', id)[0] except IndexError: raise HTTPBadRequest('Subscriber ' + id + ' does not exist') except Exception as e: raise HTTPBadRequest('Invalid JSON', e.message) else: try: rdb = RethinkDBClient() rdb.update(self._table_name, id, result) except RqlError as e: raise HTTPBadRequest('Can not update subscriber' + id, e.message) else: resp.body = ok(ret='Subscriber %s updated') % id
def store(): # try: name = request.json['name'] email = request.json['email'] password = request.json['password'] role = request.json['role'] department = request.json['department'] users = Users(name=name, email=email, role=role, department=department) users.setPassword(password) db.session.add(users) db.session.commit() # msg = Message(f"Hello, {name} Selamat datang di Aplikasi Booking Ruang Rapat", # sender="*****@*****.**") # msg.add_recipient(email) # message_value = f"Hello {name}" # msg.html = render_template('index.html',message_key=message_value) # mail.send(msg) return response.ok('', 'Successfully create data!')
def on_post(self, req, resp, id=None): """Create subscriber""" try: raw_json = req.stream.read() result = json.loads(raw_json, encoding='utf-8') validate_subscriber(result) except Exception as e: raise HTTPBadRequest('Invalid JSON', e.message) else: rdb = RethinkDBClient() if rdb.get(self._table_name, 'email', result["email"]): resp.status = HTTP_400 resp.body = bad_request(info='Subscriber with that email ' 'address already exists') else: try: rdb.insert(self._table_name, result) except RqlError as e: raise HTTPBadRequest('Can not create subscriber', e.message) else: resp.body = ok(ret='Subscriber created')