Database File Not Existing in Flask Python

Question

I have created a database in Flask Python

app = Flask(__name__)
app.config['SQALCHEMY_DATABASE_URI'] = "sqlite:///site.db"
db = SQLAlchemy(app)

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


    def __repr__(self):
        return f"User Details \n Name:{self.username}\n Email:{self.email} \n"

class product(db.Model):
    id = db.Column(db.Integer,primary_key=True)
    item_name = db.Column(db.String(10),nullable=False,unique=False)
    price = db.Column(db.Integer,unique=False,nullable=False)
    Currency = db.Column(db.String(3),unique=False,nullable=False)
    Category = db.Column(db.String(15),unique=False,nullable=True)
    product_image = db.Column(db.String(20),unique=False,nullable=False)

    def __repr__(self):
        return "Product Details \n Name: {self.item_name} \n price: {self.price}\n"

db.create_all()

I am currently creating an e-commerce site as a project and I'm following Corey Schafer's online tutorial on Flask to do so

A file named site.db is supposed to be created , I have searched my entire project repository by no file named site.db was created

Where did I go wrong? Please help me! I am beginner programmer trying to learn web development with flask

Have you tried creating the database with db.create_all() in the console? — Patrick Yoder
– Patrick Yoder, Commented Nov 11, 2021 at 15:41

BSP · Accepted Answer · 2021-11-11 13:48:18Z

1

You are not saving your database in your project directory, but at your user´s root level. Instead of this: sqlite:///site.db. You should use something like this: sqlite:////absolute/path/to/foo.db

From documentation

#Unix/Mac (note the four leading slashes)
sqlite:////absolute/path/to/foo.db

#Windows (note 3 leading forward slashes and backslash escapes)
sqlite:///C:\\absolute\\path\\to\\foo.db

#Windows (alternative using raw string)
r'sqlite:///C:\absolute\path\to\foo.db'

answered Nov 11, 2021 at 13:48

BSP

7751 gold badge10 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

DarthTensor Over a year ago

I tried both of them. Still file not saving :(

BSP Over a year ago

both? you have to use the format according to your OS.

BSP Over a year ago

If you are in an unix system: sqlite:////~/foo.db Then check your home directory

DarthTensor Over a year ago

By both I mean - sqlite:////absolute/path/to/foo.db ;

Collectives™ on Stack Overflow

Database File Not Existing in Flask Python

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related