I've been doing the tutorial link to learn Python but I have not managed to get the import to sqlalchemy generating the following error:
$ python app.py Traceback (most recent call last): File "app.py", line 2, in from flask_sqlalchemy import SQLAlchemy File "C: \ Python27 \ lib \ site-packages \ flask_sqlalchemy__init __. Py", line 23, in import sqlalchemy File "C: \ projects \ testFlask \ sqlalchemy.py", line 2, in from flask_sqlalchemy import SQLAlchemy ImportError: can not import name SQLAlchemy
Another project tells me No module named flask_sqlalchemy
My code is as follows:
from flask import Flask, request, flash, url_for, redirect, render_template
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///students.sqlite3'
app.config['SECRET_KEY'] = "random string"
db = SQLAlchemy(app)
class students(db.Model):
id = db.Column('student_id', db.Integer, primary_key = True)
name = db.Column(db.String(100))
city = db.Column(db.String(50))
addr = db.Column(db.String(200))
pin = db.Column(db.String(10))
def __init__(self, name, city, addr,pin):
self.name = name
self.city = city
self.addr = addr
self.pin = pin
@app.route('/')
def show_all():
return render_template('show_all.html', students = students.query.all() )
@app.route('/new', methods = ['GET', 'POST'])
def new():
if request.method == 'POST':
if not request.form['name'] or not request.form['city'] or not request.form['addr']:
flash('Please enter all the fields', 'error')
else:
student = students(request.form['name'], request.form['city'],
request.form['addr'], request.form['pin'])
db.session.add(student)
db.session.commit()
flash('Record was successfully added')
return redirect(url_for('show_all'))
return render_template('new.html')
if __name__ == '__main__':
db.create_all()
app.run(debug = True)
I put the ply show of sqlalchemy by suggestion
$ pip show SQLAlchemy
Name: SQLAlchemy
Version: 1.1.6
Summary: Database Abstraction Library
Home-page: http://www.sqlalchemy.org
Author: Mike Bayer
Author-email: [email protected]
License: MIT License
Location: c:\python27\lib\site-packages
Requires: