#################################################
# Database Setup
#################################################
from flask_sqlalchemy import SQLAlchemy
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get(
'DATABASE_URL', '') or "sqlite:///db.sqlite"
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
Pet = create_classes(db)
# create route that renders index.html template
@app.route("/")
def home():
return render_template("index.html")
# Query the database and send the jsonified results
@app.route("/send", methods=["GET", "POST"])
def send():
if request.method == "POST":
name = request.form["petName"]
lat = request.form["petLat"]
lon = request.form["petLon"]
from flask import (Flask, render_template, jsonify, request, redirect)
from models import create_classes
import simplejson
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get(
'DATABASE_URL', '') or "sqlite:///db.sqlite"
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
Breweries = create_classes(db)
# create route that renders index.html template
@app.route("/")
def home():
"""
Render the index.html template
"""
return render_template("index.html")
def query_results_to_dicts(results):
return simplejson.dumps(results)
engine = create_engine("sqlite:///space_DB.sqlite")
# reflect the tables
Base.prepare(engine, reflect=True)
# Save reference to the table
asteroid_impacts = Base.classes.asteroid_impacts
asteroid_orbits = Base.classes.asteroid_orbits
star_classification = Base.classes.star_classification
ufo_sightings = Base.classes.ufo_sightings
X_train = Base.classes.X_train
star_decipher = Base.classes.star_decipher
db = SQLAlchemy(app)
Stardecipher = create_classes(db)
# app = Flask(__name__)
#################################################
# Routes
#################################################
#### Front End ####
@app.route("/")
@app.route("/home")
def welcome():
return render_template("index.html")
from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import Session
from sqlalchemy import create_engine, func
from flask import Flask, render_template, redirect, jsonify
from flask_sqlalchemy import SQLAlchemy
from flask_migrate import Migrate
from models import create_classes
from config import username, password
#https://stackabuse.com/using-sqlalchemy-with-flask-and-postgresql/
app = Flask(__name__)
app.config[
'SQLALCHEMY_DATABASE_URI'] = f'postgresql://{username}:{password}@localhost:5432/meteorites_db'
db = SQLAlchemy(app)
meteorites = create_classes(db)
migrate = Migrate(app, db)
@app.route('/')
def home():
return render_template('index.html')
@app.route("/bar")
def bar():
return render_template('barchart.html')
@app.route("/bubble")
def bubble():
# Connect to the local database
connection_string = f'{username}:{password}@localhost:5432/hurricanes_db'
engine = create_engine(f'postgresql://{connection_string}')
##### end test irina
from flask_sqlalchemy import SQLAlchemy
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get('DATABASE_URL', '') or "sqlite:///db.sqlite"
# app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get('DATABASE_URL', "postgresql://*****:*****@app.route("/jsondata")
def jsondata():
# cursor.execute("select row_to_json(master) from master")
# rows = cursor.fetchall()
cursor.execute("select name, hurricane_id, year, latitude_decimal, longitude_decimal, max_wind, air_pressure, time from master")
rows = cursor.fetchall()
# print(rows)
# q = ("select row_to_json(master) from master")
# mySQL = db.executesql(q)
# return json.dumps(mySQL)
# # return
objects_list = []
for row in rows:
#################################################
app = Flask(__name__)
#################################################
# Database Setup
#################################################
from flask_sqlalchemy import SQLAlchemy
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get('DATABASE_URL', '') or "sqlite:///books.sqlite"
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
Books = create_classes(db)
#################################################
# Flask Routes
#################################################
@app.route("/")
def welcome():
"""List all available api routes."""
return render_template("index.html")
@app.route("/dashboard/")
def thedata():
"""List all available api routes."""
return render_template("dashboard.html")
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get(
'DATABASE_URL', '') or "sqlite:///db.sqlite"
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
"""
Using the `flask_sqlalchemy` library we'll creating our
variable `db` that is the connection to our database
"""
db = SQLAlchemy(app)
"""
from `models.py` we call `create_classes` that we will have
a reference to the class we defined `AvatarHistory` that is
bound to the underylying database table.
"""
AvatarHistory = create_classes(db)
# create route that renders index.html template
@app.route("/")
def home():
"""
Render the index.html template
"""
return render_template("index.html")
def query_results_to_dicts(results):
"""
A helper method for converting SQLAlchemy Query objects
(https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query)
import os
import sqlite3
import json
from flask import (
Flask,
render_template,
jsonify,
request,
redirect)
app = Flask(__name__)
from flask_sqlalchemy import SQLAlchemy
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get('DATABASE_URL', '') or "sqlite:///db.sqlite"
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
energy = create_classes(db)
# create route that renders index.html template
@app.route("/")
def home():
def get_tbl(tbl_name):
database = r"db.sqlite"
conn = sqlite3.connect(database)
cur = conn.cursor()
cur.execute(f"SELECT * FROM {tbl_name}")
temp_table = cur.fetchall()
temp_json = json.dumps(temp_table)
#for row in consumption_table:
# print(row)
return temp_json
con_json = get_tbl("consumption")
emi_json = get_tbl("emissions")
#################################################
app = Flask(__name__)
#################################################
# Database Setup
#################################################
from flask_sqlalchemy import SQLAlchemy
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get "sqlite:///db.sportsbetting.sqlite"
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
sportsbetting = create_classes(db)
# create route that renders index.html template
@app.route("/")
def home():
return render_template("index.html")
# Query the database and send the jsonified results
@app.route("/send", methods=["GET", "POST"])
def send():
if request.method == "POST":
UFC_Red_Fighter1 = request.form["Red_Corner_Fighter1"]
UFC_Blue_Fighter1 = request.form["Blue_Corner_Fighter1"]
UFC_Winner1 = request.form["Winner1"]
UFC_Red_Fighter_odds1 = request.form["Red_Fighter_odds1"]
#################################################
# Database Setup
# The connection string to the database is listed in the URI field on Heroku Postgres (View Credentials)
# Heroku will automatically assign this URI string to the DATABASE_URL environment variable that is used within app.py
# The code that is already in app.py (below) will be able to use that environment variable to connect to the Heroku database
#################################################
from flask_sqlalchemy import SQLAlchemy
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get('DATABASE_URL', '')
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
Employment = create_classes(db)
# Real_Estate_Sales = create_classes(db)
# Covid_Closed_States = create_classes(db)
# create route that renders index.html template
@app.route("/")
def home():
return render_template("index.html")
# Query the database and send the jsonified results
@app.route("/send", methods=["GET", "POST"])
def send():
if request.method == "POST":
name = request.form["petName"]
Database connection setup: Let's look for an environment variable 'DATABASE_URL'.
If there isn't one, we'll use a connection to a sqlite database.
"""
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get(
'DATABASE_URL', '') or "sqlite:///db.sqlite"
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
# Use the `flask_sqlalchemy` library we'll create our variable `db` that is the connection to our database
db = SQLAlchemy(app)
"""
From `models.py` we call `create_classes` that we will have a reference to the class
we defined `Feedback` that is bound to the underlying database table.
"""
Cuisine, Feedback = create_classes(db)
# create route that renders index.html template
@app.route("/")
def home():
cuisine_list = [
'African', 'American', 'British', 'Caribbean', 'Chinese',
'East European', 'French', 'Greek', 'Indian', 'Irish', 'Italian',
'Japanese', 'Korean', 'Mexican', 'Nordic', 'North African',
'Pakistani', 'Portuguese', 'South American', 'Spanish',
'Thai and South-East Asian', 'Turkish and Middle Eastern'
]
return render_template("index.html", cuisine_list=cuisine_list)
import sqlalchemy
from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import Session
from sqlalchemy import create_engine, func
from flask import Flask, render_template, redirect, jsonify
from flask_sqlalchemy import SQLAlchemy
from flask_migrate import Migrate
from models import create_classes
#https://stackabuse.com/using-sqlalchemy-with-flask-and-postgresql/
app = Flask(__name__, static_url_path='/static', template_folder="templates")
app.config[
'SQLALCHEMY_DATABASE_URI'] = f'postgresql://*****:*****@localhost:5432/airbnb_db'
db = SQLAlchemy(app)
airbnb = create_classes(db)
migrate = Migrate(app, db)
@app.route('/')
def index():
return render_template('index.html')
@app.route("/neighborhoods")
def neighborhoods():
return render_template('neighborhoods.html')
@app.route("/heatmap")
def heatmap():
#################################################
# Database Setup
#################################################
from flask_sqlalchemy import SQLAlchemy
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get(
'DATABASE_URL',
'') or "postgresql://*****:*****@localhost/mobility2_db"
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
Mobility = create_classes(db)
# create route that renders index.html template
@app.route("/")
def home():
return render_template("index.html")
@app.route("/api/data")
def data():
# df=pd.read_sql
receiveddata = db.session.query(
Mobility.states, Mobility.dates, Mobility.sma_retail_recreation,
#################################################
#################################################
# Flask Setup
#################################################
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get('DATABASE_URL', '') or "sqlite:///Covid_Vision.sqlite"
engine =app.config['SQLALCHEMY_DATABASE_URI']
# Remove tracking modifications
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
Covid_Vision = create_classes(db)
@app.route("/")
def index():
return render_template("index.html")
@app.route("/trends")
def trends():
return render_template("trends.html")
@app.route("/choropleth")
def choropleth():
return render_template("choropleth.html")
@app.route("/api/v1.0/covid_trends")
