text: # manage.py
  
  
  import os
  import unittest
  import coverage
  
  from flask_script import Manager
  from flask_migrate import Migrate, MigrateCommand
  import json
  
  COV = coverage.coverage(
      branch=True,
      include='project/*',
      omit=[
          'project/tests/*',
          'project/server/config.py',
          'project/server/*/__init__.py'
      ]
  )
  COV.start()
  
  from project.server import app, db, models
  
  
  migrate = Migrate(app, db)
  manager = Manager(app)
  
  # migrations
  manager.add_command('db', MigrateCommand)
  
  
  @manager.command
  def test():
      """Runs the unit tests without test coverage."""
      tests = unittest.TestLoader().discover('project/tests', pattern='test*.py')
      result = unittest.TextTestRunner(verbosity=2).run(tests)
      if result.wasSuccessful():
          return 0
      return 1
  
  
  @manager.command
  def cov():
      """Runs the unit tests with coverage."""
      tests = unittest.TestLoader().discover('project/tests')
      result = unittest.TextTestRunner(verbosity=2).run(tests)
      if result.wasSuccessful():
          COV.stop()
          COV.save()
          print('Coverage Summary:')
          COV.report()
          basedir = os.path.abspath(os.path.dirname(__file__))
          covdir = os.path.join(basedir, 'tmp/coverage')
          COV.html_report(directory=covdir)
          print('HTML version: file://%s/index.html' % covdir)
          COV.erase()
          return 0
      return 1
  
  
  @manager.command
  def create_db():
      """Creates the db tables."""
      db.create_all()
  
  
  @manager.command
  def drop_db():
      """Drops the db tables."""
      db.drop_all()
  
  @app.route("/users/index")
  def home():
      list_data = []
      temp = db.session.query(models.User)
      count = 1
      for s in temp:
          temp2 = {}
          temp2['User#' + str(count)] = s.email
          list_data.append(temp2)
          count = count + 1
      return str(list_data)
  
  if __name__ == '__main__':
      manager.run()
  