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

ZnJvbSBmbGFzayBpbXBvcnQgRmxhc2ssIGpzb25pZnksIHJlcXVlc3QKZnJvbSBzcWxhbGNoZW15IGltcG9ydCBjcmVhdGVfZW5naW5lCmZyb20gc3FsYWxjaGVteSBpbXBvcnQgdGV4dCAjZm9yIHJhdyBxdWVyaWVzIGZyb20gZGIKCgplbmdpbmUgPSBjcmVhdGVfZW5naW5lKCdwb3N0Z3Jlc3FsOi8vcG9zdGdyZXM6MTIzQGxvY2FsaG9zdDo1NDMyL3Rlc3QnKQoKYXBwID0gRmxhc2soX19uYW1lX18pCgpAYXBwLnJvdXRlKCcvZGV2cycsIG1ldGhvZHM9WydHRVQnXSkKZGVmIGRldl9saXN0KCk6CiAgICByZXMgPSBbXQogICAgZGJfcmVzcG9uc2UgPSBlbmdpbmUuZXhlY3V0ZSh0ZXh0KCJzZWxlY3QgKiBmcm9tIGNvdXJzZXMiKSkKICAgIGZvciByb3cgaW4gZGJfcmVzcG9uc2U6CiAgICAgICAgcmVzLmFwcGVuZCgKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgInRpdGxlIjogcm93Wyd0aXRsZSddLAogICAgICAgICAgICAgICAgImNfbm8iOiByb3dbJ2Nfbm8nXSwKICAgICAgICAgICAgICAgICJob3VycyI6IHJvd1snaG91cnMnXQogICAgICAgICAgICB9CiAgICAgICAgKQogICAgICAgIAogICAgICAgIHJldHVybiBqc29uaWZ5KHJlcykjIHlvdXIgY29kZSBnb2VzIGhlcmU=