Cloud Native Python

GET /api/v1/users

The GET/api/v1/users method shows the list of all users.

Let's create an /api/v1/users route by adding the following code snippet to app.py:

    @app.route('/api/v1/users', methods=['GET']) 
    def get_users(): 
      return list_users() 

Now that we have added the route, we need to define the list_users() function, which will connect with the database to get you the complete list of users. Add the following code to app.py:

    def list_users():    conn = sqlite3.connect('mydb.db')    print ("Opened database successfully");    api_list=[]    cursor = conn.execute("SELECT username, full_name,    email, password, id from users")    for row in cursor:    a_dict = {}    a_dict['username'] = row[0]    a_dict['name'] = row[1]    a_dict['email'] = row[2] a_dict['password'] ...