from flask import Flask, jsonify, request
from sqlalchemy import create_engine
from sqlalchemy import text #for raw queries from db


engine = create_engine('postgresql://postgres:123@localhost:5432/test')

app = Flask(__name__)

@app.route('/devs', methods=['GET'])
def dev_list():
    res = []
    db_response = engine.execute(text("select * from courses"))
    for row in db_response:
        res.append(
            {
                "title": row['title'],
                "c_no": row['c_no'],
                "hours": row['hours']
            }
        )
        
        return jsonify(res)# your code goes here