text: # install mysql and flask packages
  # pip install flask
  # pip install flask-mysql
  
  # imports
  from flask import Flask, render_template
  from flaskext.mysql import MySQL
  
  # web application
  app = Flask(__name__)
  
  # connect to db
  mysql = MySQL()
  app.config['MYSQL_DATABASE_USER']     = 'root'
  app.config['MYSQL_DATABASE_PASSWORD'] = 'twin629DUKE'
  app.config['MYSQL_DATABASE_DB']       = 'education'
  app.config['MYSQL_DATABASE_HOST']     = 'localhost'
  mysql.init_app(app)
  
  # ----------------------------------- 
  #           YOUR CODE
  # ----------------------------------- 
  
  # route for colleges
  @app.route('/colleges')
  def colleges():
      cursor = mysql.get_db().cursor()
      response = cursor.execute('SELECT * FROM Colleges')
      html = ''
      if response > 0:
          colleges = cursor.fetchall()
          # replace below with a template
          # for college in colleges:
          #     html += college[1] + '<br>'
          # return html
          return render_template('colleges.html', list=colleges)
  
  if __name__ == '__main__':
      app.run(debug = True, port = 3000)
  