def __init__(self, *args): self.firstname = args[0] self.lastname = args[1] self.othername = args[2] self.username = args[3] self.email = args[4] self.phone_number = args[5] self.password = args[6] self.db = init_db()
def create_app(configName): app = Flask(__name__) app.register_blueprint(V2_auth) app.register_blueprint(V2_meetups) app.register_blueprint(V2_questions) os.environ['FLASK_ENV'] = 'production' app.config.from_object(app_config['production']) init_db() create_tables() app.register_error_handler(404, page_not_found) app.register_error_handler(500, server_error) app.register_error_handler(405, invalid_method) app.register_error_handler(400, bad_request) return app
def login(): data = request.get_json() if not data: abort(make_response( jsonify({"message": "POST of type Application/JSON expected"}), 400)) # Check for empty inputs if not all(field in data for field in ["username", "password"]): abort(make_response( jsonify({"message": "Username and Paswword are required"}), 400)) username = data['username'] password = data['password'] # check if email exists cur = init_db().cursor() query = "SELECT email from member WHERE username = %s;" cur.execute(query, (data['username'],)) user_data = cur.fetchone() cur.close() if not user_data: abort(make_response(jsonify({"message": "User not Found"}), 404)) cur = init_db().cursor() query = "SELECT password from member WHERE username = %s;" cur.execute(query, (data['username'],)) user_data = cur.fetchone() cur.close() details = (user_data[0]) print (details) if not inputs_validate.check_password(details, data['password']): print (inputs_validate.check_password(user_data, data['password'])) abort(make_response( jsonify({"message": "Wrong Password"}), 400)) access_token = create_access_token(identity=username) return jsonify(access_token=access_token), 200
def delete_meetup(id): try: db= init_db() cur = db.cursor() query = "DELETE FROM meetups WHERE id= %s " cur.execute(query, (id,)) db.commit() return "deleted sucessfully" except (Exception, psycopg2.Error) as error: print(error)
def all_meetups(): try: cur = init_db().cursor() query = "SELECT * FROM meetups " cur.execute(query, (id,)) all_meetups = cur.fetchall() cur.close() if all_meetups == None: return "not found" return all_meetups except (Exception, psycopg2.Error) as error: print(error)
def check_quiz(id): try: cur = init_db().cursor() query = "SELECT * FROM questions WHERE id= %s" cur.execute(query, (id,)) all_meetups = cur.fetchone() cur.close() details = (all_meetups[0]) if details == None: return False return True except (Exception, psycopg2.Error) as error: print(error)
def check_voter(id, username, vote): try: cur = init_db().cursor() query = "SELECT id FROM votes WHERE question_id = %s AND created_by= %s AND status= %s" cur.execute(query, (id, username, vote)) user_exists = cur.fetchone() cur.close() details = (user_exists[0]) print(details) if details: return True return False except (Exception, psycopg2.Error) as error: print(error)
def check_admin(current_user): try: cur = init_db().cursor() # print(current_user) query = "SELECT isAdmin FROM member WHERE username= %s" cur.execute(query, (current_user,)) user_exists = cur.fetchone() cur.close() details = (user_exists[0]) print(details) if details == True: return True return False except (Exception, psycopg2.Error) as error: print(error)
def __init__(self, *args): self.topic = args[0] self.location = args[1] self.happeningOn = args[2] self.tags = args[3] self.db = init_db()
def __init__(self, *args): self.meetup_id = args[0] self.username = args[1] self.response = args[2] self.db = init_db()
def __init__(self, *args): self.username = args[0] self.quiz_id = args[1] self.upvote = args[2] self.value = args[3] self.db = init_db()
def __init__(self, *args): self.meetup_id = args[0] self.username = args[1] self.title = args[2] self.body = args[3] self.db = init_db()
def __init__(self, *args): self.quiz_id = args[0] self.username = args[1] self.comment = args[2] self.db = init_db()