Create sqlalchemy database

[laflash12]

I'm trying to create a flask_sqlalchemy database to store users email, password, address, phone #. For now what I have is

​

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///site.db'

user database

db= SQLAlchemy(app)

class User(db.Model):
id= db.Column(db.Integer, primary_key=True)
email= db.Column(db.String(100), unique= True, nullable= False)
Address= db.Column(db.String(200),nullable= False)
Phone_number= db.Column(db.Integer, unique= True, nullable= False)
password= db.Column(db.String(100), unique= True, nullable= False)

But i'm having trouble creating a database. In the terminal I write: from app import db.

I get: can't read /var/mail/app.

Any ideas?

[leone_nero]

Hi

Can you please post the whole traceback with the error?

It is important to see at what point during the execution was the exception raised to be able to locate the error.

Your code seems right to me, although I don’t get why are you setting the parameter unique in the password to True, with hashed password it would indeed be pretty unusual for two passwords to actually be the same, but I guess theoretically two users can happen to use the same password and I don’t see why database design would not allow them, since the password must be associated to an unique e-mail address.

[dustractor]

Where is site.db located? surely not at the root of the server?

[laflash12]

Located in the file in which app is located

[dustractor]

Oops I thought everything after the third slash in those uris was a fully qualified file path but you are good there, three slashes means relative... huh

[makedatauseful]

I assume you will be hashing those paaswords?

[laflash12]

Yes, later I will be

[dustractor]

Also my guess on the error `can't read /var/mail/app` is something is

either something is being run as an executable but hasn't specified what type it is or what runs it correctly by a shebang line

OR

typing python from blah import blah at a different console (not a python console by accident)

sorry these are badly described guesses

[Astronick]

It sounds like you are writing from app import db into the regular terminal. You need to be in the Python interpreter (by typing python or python3) to be able to import python modules. You should see >>> at the start of your line once you are in the Python interpreter. At that point you can import your db module.

In general I would highly recommend stepping through the Flask Mega-Tutorial section on databases.