db.sql

create table users(id serial primary key,
firstName text not null,
email text not null);

insert into users(firstName, email) values ('Andre', 'andre@gmail.com');
insert into users(firstName, email) values ('Andrew', 'andrew@gmail.com');
insert into users(firstName, email) values ('Bob', 'bob@gmail.com');

db_and_api.py

import psycopg2
from flask_api import FlaskAPI

try:

    app = FlaskAPI(__name__)

    connect_str = "dbname='leaderex-test' host='localhost' "
                  
    # # use our connection values to establish a connection
    conn = psycopg2.connect(connect_str)
    # # create a psycopg2 cursor that can execute queries
    cursor = conn.cursor()
    # # create a new table with a single column called "name"
    # cursor.execute("""CREATE TABLE tutorials (name char(40));""")
    # # run a SELECT statement - no data in there, but we can try it
    cursor.execute("""SELECT * from users """)

    rows = cursor.fetchall()
    # print(rows)
    for row in rows:
        print row

    @app.route('/example/<username>')
    def example(username):
        print username

        cursor.execute("SELECT * from users where firstname = '" + username + "'")
        rows = cursor.fetchall()

        return {'data' : rows}


    if __name__ == "__main__":
        app.run(debug=True)

except Exception as e:
    print("Uh oh, can't connect. Invalid dbname, user or password?")
    print(e)