示例#1
0
 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()
示例#2
0
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
示例#3
0
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
示例#4
0
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)
示例#5
0
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)
示例#6
0
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)
示例#8
0
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)
示例#9
0
 def __init__(self, *args):
     self.topic = args[0]
     self.location = args[1]
     self.happeningOn = args[2]
     self.tags = args[3]
     self.db = init_db()
示例#10
0
 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()