Python db_connect示例

示例#1

 def __init__(self):
     """
     Initializes database connection and sessionmaker
     """
     engine = db_connect()
     create_deals_table(engine)
     self.Session = sessionmaker(bind=engine)

示例#2

文件： pipelines.py 项目： dsimpson1980/my_scraper

 def __init__(self):
     """
     Initializes database connection and sessionmaker.
     Creates deals table.
     """
     engine = db_connect()
     create_deals_table(engine)
     self.Session = sessionmaker(bind=engine)

示例#3

 def __init__(self):
     engine = db_connect()
     create_houses_table(engine)
     self.Session = sessionmaker(bind=engine)

示例#4

文件： app.py 项目： lotohov/wrapbootstrap-scraper

from sqlalchemy.orm import sessionmaker
from flask import Flask, render_template
from scraper_app.models import Template, db_connect
from scraper_app.settings import DATABASE

app = Flask(__name__)
app.secret_key = 'dev'
app.config['SQLALCHEMY_DATABASE_URI'] = DATABASE

engine = db_connect()
Session = sessionmaker(bind=engine)
session = Session()


@app.route('/')
def index():
    templates = session.query(Template).all()
    return render_template('data.html', templates=templates)


if __name__ == "__main__":
    app.run(host='0.0.0.0', port=7778, debug=True)