Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from flask import Flask
- from flask_sqlalchemy import SQLAlchemy
- app = Flask(__name__)
- app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:password@localhost:8889/database_name'
- db = SQLAlchemy(app)
- class Stocks(db.Model):
- __tablename__ = 'stocks'
- stock_id = db.Column('stock_id', db.Integer, primary_key=True)
- adj_close = db.Column('adj_close', db.Float)
- close = db.Column('close', db.Float)
- date = db.Column('date', db.Date)
- high = db.Column('high', db.Float)
- low = db.Column('low', db.Float)
- open = db.Column('open', db.Float)
- symbol = db.Column('symbol', db.String(10))
- volume = db.Column('volume ', db.Float)
- >>>from file.py import Stocks
- >>>data = Stocks.query.all()
- ImportError: No module named MySQLdb
- ImportError: No module named 'MySQLdb'
- Could not find a version that satisfies the requirement MySQLdb (from versions: )
- No matching distribution found for MySQLdb
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement