def updateUserStatus(user_id):
try:
checked_user = sess.query(User).filter(User.id == user_id)
if checked_user.first() is not None:
print(checked_user.first().isVerified)
edit = checked_user.update(
{'isVerified': not checked_user.first().isVerified},
synchronize_session=False)
sess.commit()
if edit == 1:
ret = {'status': 200, 'message': 'Data updated!'}
else:
ret = {
'status':
500,
'message':
"Something's went wrong with our server. Please try again later!"
}
return ret
else:
ret = {'status': 400, 'message': "ID not found"}
return ret
except Exception as e:
ret = {
'status': 500,
'message': e.args,
}
return ret
def save(self):
try:
sess.add(self)
sess.commit()
res = {
'status': 201,
'message': "New Bebep Account Created",
'results': {
'id': self.id,
'user_id': self.user_id,
'balance': self.balance
}
}
return res
except Exception as e:
ret = {'status': 500, 'message': e.args}
return ret
def save(self):
try:
sess.add(self)
sess.commit()
res = {
'status': 201,
'message': "New Booking History Created",
'results': {
'id': self.id,
'user_id': self.user_id,
'booking_id': self.booking_id,
}
}
return res
except Exception as e:
ret = {'status': 500, 'message': e.args}
return ret
def save(self):
try:
sess.add(self)
sess.commit()
res = {
'status': 201,
'message': "New User Created",
'results': {
'id': self.id,
'nama': self.nama,
'email': self.email,
'password': self.password,
'phone': self.password,
'registered_at': self.registered_at,
'isVerified': self.isVerified
}
}
return res
except Exception as e:
ret = {'status': 500, 'message': e.args}
return ret
def save(self):
try:
sess.add(self)
sess.commit()
res = {
'status': 201,
'message': "New Booking Created",
'results': {
'id': self.id,
'user_id': self.user_id,
'venue_id': self.venue_id,
'start_hour': self.start_hour,
'end_hour': self.end_hour,
'total_price': self.total_price,
'booked_at': self.booked_at,
'isFinished': self.isFinished
}
}
return res
except Exception as e:
ret = {'status': 500, 'message': e.args}
return ret
def save(self):
try:
sess.add(self)
sess.commit()
res = {
'status': 201,
'message': "New Venue Created",
'results': {
'id': self.id,
'image_path': self.image_path,
'name': self.name,
'address': self.address,
'category': self.category,
'price_per_hour': self.price_per_hour,
'open_hour': self.open_hour,
'close_hour': self.close_hour,
'registered_at': self.registered_at
}
}
return res
except Exception as e:
ret = {'status': 500, 'message': e.args}
return ret
def topup_bebep(user_id, balance):
try:
selected_account = sess.query(Bebep).filter(
Bebep.user_id == user_id).first()
if selected_account is not None:
new_balance = selected_account.balance + balance
data = {'balance': new_balance}
edited_account = sess.query.filter(
Bebep.user_id == user_id).update(data,
synchronize_session=False)
sess.commit()
if edited_account == 1:
ret = {
'status':
200,
'message':
'Data updated! Your Bebep balance is ' + new_balance +
" now!"
}
else:
ret = {
'status':
500,
'message':
"Something's went wrong with our server. Please try again later!"
}
return ret
else:
ret = {'status': 200, 'message': "Bebep Account is not found"}
return ret
except Exception as e:
ret = {
'status': 200,
'message': e.args,
}
return ret