psql1.py

psql1.py

from flask import Flask
import time
import os
from models import db
from flask_sqlalchemy import SQLAlchemy
from models import Contact

app = Flask(__name__)

POSTGRES = {
    'user': 'myUserName',
    'pw': 'myPassword',
    'db': 'myDBName',
    'host': 'endPoint',
    'port': '5432',
}

app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://%(user)s:\
%(pw)s@%(host)s:%(port)s/%(db)s' % POSTGRES
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db.init_app(app)

@app.route('/')
def hello_world():
    contacts = Contact.query.all()
    return "We have " + str(len(contacts)) + " in the db and the contact names are: " + contacts[0].name + " and " + contacts[1].name