Advertisement
Guest User

Untitled

a guest
Dec 2nd, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. from flask import Flask
  2. from flask_sqlalchemy import SQLAlchemy
  3.  
  4. app = Flask(__name__)
  5. app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:password@localhost:8889/database_name'
  6. db = SQLAlchemy(app)
  7.  
  8.  
  9. class Stocks(db.Model):
  10. __tablename__ = 'stocks'
  11. stock_id = db.Column('stock_id', db.Integer, primary_key=True)
  12. adj_close = db.Column('adj_close', db.Float)
  13. close = db.Column('close', db.Float)
  14. date = db.Column('date', db.Date)
  15. high = db.Column('high', db.Float)
  16. low = db.Column('low', db.Float)
  17. open = db.Column('open', db.Float)
  18. symbol = db.Column('symbol', db.String(10))
  19. volume = db.Column('volume ', db.Float)
  20.  
  21. >>>from file.py import Stocks
  22. >>>data = Stocks.query.all()
  23.  
  24. ImportError: No module named MySQLdb
  25.  
  26. ImportError: No module named 'MySQLdb'
  27.  
  28. Could not find a version that satisfies the requirement MySQLdb (from versions: )
  29. No matching distribution found for MySQLdb
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement