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')
