fork download
  1. from flask import Flask, jsonify, request
  2. from sqlalchemy import create_engine
  3. from sqlalchemy import text #for raw queries from db
  4.  
  5.  
  6. engine = create_engine('postgresql://postgres:123@localhost:5432/test')
  7.  
  8. app = Flask(__name__)
  9.  
  10. @app.route('/devs', methods=['GET'])
  11. def dev_list():
  12. res = []
  13. db_response = engine.execute(text("select * from courses"))
  14. for row in db_response:
  15. res.append(
  16. {
  17. "title": row['title'],
  18. "c_no": row['c_no'],
  19. "hours": row['hours']
  20. }
  21. )
  22.  
  23. return jsonify(res)# your code goes here
Runtime error #stdin #stdout #stderr 0.42s 38304KB
stdin
Standard input is empty
stdout
Standard output is empty
stderr
Traceback (most recent call last):
  File "./prog.py", line 6, in <module>
  File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/__init__.py", line 435, in create_engine
    return strategy.create(*args, **kwargs)
  File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/strategies.py", line 87, in create
    dbapi = dialect_cls.dbapi(**dbapi_args)
  File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 632, in dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'