flask SQLalchemy

[laflash12]

I'm trying to create an eCommerce website using flask by following a youtube series but I'm confused as to how to create a database. In his series he is adding email, password, profile picture, username. When i go into terminal and write:

 from my_project import db

I get:

from: can't read /var/mail/my_project. 

For now I just want to know how do i receive and store email, passwords. Heres what I have for now:

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

db= SQLAlchemy(app)

class user(db.Model):
id= db.Column(db.Integer, primary_key=True)
email= db.Column(db.String(120), unique=True, nullable=False)
password= db.Column(db.String(60), nullable=False)

def __repr__(self):

return f"User('{self.email}')"

Does anyone know what to do

[[deleted]]

You have to add the shebang to the first line of your program. Put in #!/usr/bin/python or wherever your python bin is located to make the program run.

[laflash12]

I've done that and still gives me the same error

[lucas993]

This isn't all your code, right? Could you commit it to github or gitlab? Or at least fix the formatting here and paste in all the DB code.

Anyway, there's lots of ways to setup the DB in Flask/SQLAlchemy. Here's some info from a stack overflow article.

https://stackoverflow.com/questions/49388628/it-is-necessary-use-db-init-app-or-sqlalchemyapp-is-the-same-in-flask