🔒 someone help pls sqlalchemy RuntimeError | Python | Page 1

lethal oriole Mar 2, 2025, 7:23 AM

#

from flaskblog import create_app

app = create_app()

if __name__ == '__main__':
    app.run(debug=True)```
```python
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_bcrypt import Bcrypt
from flask_login import LoginManager
from flask_mail import Mail
from flaskblog.config import Config


db = SQLAlchemy()
bcrypt = Bcrypt()
login_manager = LoginManager()
login_manager.login_view = 'users.login'
login_manager.login_message_category = 'info'
mail = Mail()


def create_app(config_class=Config):
    app = Flask(__name__)
    app.config.from_object(Config)

    db.init_app(app)
    bcrypt.init_app(app)
    login_manager.init_app(app)
    mail.init_app(app)

    from flaskblog.users.routes import users
    from flaskblog.posts.routes import posts
    from flaskblog.main.routes import main
    app.register_blueprint(users)
    app.register_blueprint(posts)
    app.register_blueprint(main)

    return app```

agile reefBOT Mar 2, 2025, 7:23 AM

#

lethal oriole ```python from flaskblog import create_app app = create_app() if __name__ == '...

#

@lethal oriole

Python help channel opened

Remember to:

Ask your Python question, not if you can ask or if there's an expert who can help.
Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

lethal oriole Mar 2, 2025, 7:23 AM

#

lethal oriole ```python from flaskblog import create_app app = create_app() if __name__ == '...

These are the errors.

#

I wrote the code above, as well.

#

What do I need to do to fix this...?

verbal gyro Mar 2, 2025, 7:35 AM

#

https://flask-sqlalchemy.readthedocs.io/en/stable/config/#flask_sqlalchemy.config.SQLALCHEMY_DATABASE_URI

#

set the URI app.config['...'] = "mysql...

lethal oriole Mar 2, 2025, 7:36 AM

#

Where do I do that?

#

init? run?

lethal oriole Mar 2, 2025, 7:38 AM

#

verbal gyro set the URI `app.config['...'] = "mysql...`

Do I need to write something instead of the dots?

lethal oriole Mar 2, 2025, 7:40 AM

#

lethal oriole ```python from flaskblog import create_app app = create_app() if __name__ == '...

here?

#

I'm not sure where I need to put that...

#

@verbal gyro

#

Someone help...I really want to make this code work...

#

So...I tried putting app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/test.db'

#

But...

#

Now it gave another error.

#

#

Can someone tell me what I need to do?

#

app.config['SQLALCHEMY_DATABASE_URI'] ='sqlite:///tmp/test.db' I tried it with this, 3 /'s instead of 4, and...

#

it still doesn't work...

#

Hmmmm...

#

I'm trying some other stuff, but it still doesn't seem to work...

#

I'm searching it on youtube rn.

#

No proper result...

#

Now it gives this error...

#

I've tried so many diffferent things, and none of them work...

#

@verbal gyro can you help?

#

someone help pls

#

someone help pls sqlalchemy error

#

This is the last thing I'll do with Flask for now, so I'd REALLY appreciate help.

#

Everything has worked thus far, but the LAST thing doesn't work...

#

😔

#

I just need one person to help, man...

#

someone help pls sqlalchemy RuntimeError

empty pendant Mar 2, 2025, 8:53 AM

#

🗿

#

hello

lethal oriole Mar 2, 2025, 8:55 AM

#

Hello

unborn abyss Mar 2, 2025, 9:38 AM

#

Hey @lethal oriole

#

Yesterday I saw your post was closed by you so I assumed you found a sol

unborn abyss Mar 2, 2025, 9:39 AM

#

lethal oriole So...I tried putting app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/tes...

does tmp dir and test.db exist?

#

from app import app
from app.models import (Applications, ApplicationStatus, Courses, Deans,
                        Professors, Students, db)

print("Database URI:", app.config["SQLALCHEMY_DATABASE_URI"])

with app.app_context():
    db.create_all()
    print("Database created")

Write a script like this and run it. This will create the db first

#

fix the import according to your application

unborn abyss Mar 2, 2025, 9:42 AM

#

lethal oriole Where do I do that?

you will need to do it where you create the app object

lethal oriole Mar 2, 2025, 9:43 AM

#

unborn abyss Yesterday I saw your post was closed by you so I assumed you found a sol

Nah

#

Nobody answered so

#

I had to close it.

#

I'll open my pc one sec.

lethal oriole Mar 2, 2025, 9:44 AM

#

unborn abyss does tmp dir and test.db exist?

I don't think there is tmp dir

lethal oriole Mar 2, 2025, 9:45 AM

#

unborn abyss fix the import according to your application

hmmmmmm.

#

Let me send the imports.

#

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_bcrypt import Bcrypt
from flask_login import LoginManager
from flask_mail import Mail
from flaskblog.config import Config```

#

These?

lethal oriole Mar 2, 2025, 9:47 AM

#

unborn abyss ```py from app import app from app.models import (Applications, ApplicationStatu...

where do I write this?

#

Command prompt or?

lethal oriole Mar 2, 2025, 9:49 AM

#

unborn abyss ```py from app import app from app.models import (Applications, ApplicationStatu...

I think I need to type this in python?

#

"from app" gives a red underline...?

lethal oriole Mar 2, 2025, 9:51 AM

#

unborn abyss you will need to do it where you create the app object

Hmmmm...

#

Yeah

#

No matter

#

where I put the app

#

it gives a red underline.

#

@unborn abyss

#

It says no module named app in the command prompt.

#

and in python it's red.

unborn abyss Mar 2, 2025, 9:57 AM

#

alright

#

ok

#

so

#

you have a project src dir right?

lethal oriole Mar 2, 2025, 9:57 AM

#

I do remember src being somewhere, yeah.

unborn abyss Mar 2, 2025, 9:57 AM

#

Create this file as 'temp_create_db.py' or something

#

or

#

ykw

#

forget the filw

lethal oriole Mar 2, 2025, 9:58 AM

#

#

This is how it looks like.

unborn abyss Mar 2, 2025, 9:58 AM

#

beautiful, I was about to ask for the dir structure haha

lethal oriole Mar 2, 2025, 9:58 AM

#

Okay

#

What do I do now?

unborn abyss Mar 2, 2025, 9:59 AM

#

you already have your db in instance dir

#

did you create them?

lethal oriole Mar 2, 2025, 9:59 AM

#

yeah

unborn abyss Mar 2, 2025, 9:59 AM

#

alright then

#

show whats in the run.py file

lethal oriole Mar 2, 2025, 10:00 AM

#

from flaskblog import create_app

app = create_app()

if __name__ == '__main__':
    app.run(debug=True)```

unborn abyss Mar 2, 2025, 10:00 AM

#

hmm

#

so the app object is created in flaskblog file

lethal oriole Mar 2, 2025, 10:00 AM

#

yes.

unborn abyss Mar 2, 2025, 10:00 AM

#

can you share me the code in it?

lethal oriole Mar 2, 2025, 10:00 AM

#

Which code?

lethal oriole Mar 2, 2025, 10:00 AM

#

lethal oriole ```python from flaskblog import create_app app = create_app() if __name__ == '...

This is the run.py

unborn abyss Mar 2, 2025, 10:01 AM

#

can you share the code where the app obj is created?

#

ig it should be somewhere in main dir

lethal oriole Mar 2, 2025, 10:01 AM

#

hmmmm

unborn abyss Mar 2, 2025, 10:01 AM

#

or init file, im not sure

lethal oriole Mar 2, 2025, 10:01 AM

#

It doesn't seem to be there...

#

main init is empty.

#

Let me check the snippets.

unborn abyss Mar 2, 2025, 10:02 AM

#

lethal oriole ```python from flaskblog import create_app app = create_app() if __name__ == '...

no worries you have shared it here, dint see

lethal oriole Mar 2, 2025, 10:02 AM

#

yeah main init is empty.

lethal oriole Mar 2, 2025, 10:02 AM

#

unborn abyss no worries you have shared it here, dint see

ah okay.

unborn abyss Mar 2, 2025, 10:03 AM

#

have you pushed all the code to a repo?

lethal oriole Mar 2, 2025, 10:03 AM

#

repo?

#

All the code

lethal oriole Mar 2, 2025, 10:04 AM

#

lethal oriole

is in this.

#

These files.

unborn abyss Mar 2, 2025, 10:06 AM

#

sqlite:///instance/data.db try this as the uri value

lethal oriole Mar 2, 2025, 10:06 AM

#

hmmm.

#

in config, right?

#

or wait

#

import os


class Config:
    SECRET_KEY = os.environ.get('SECRET_KEY')
    SQLALCHEMY_DATABASE_URI = os.environ.get('DATABASE_URL')
    MAIL_SERVER = 'smtp.googlemail.com'
    MAIL_PORT = 587
    MAIL_USE_TLS = True
    MAIL_USERNAME = os.environ.get('EMAIL_USER')
    MAIL_PASSWORD = os.environ.get('EMAIL_PASS')```

#

Do I write that here, then?

#

since flaskblog init doesn't have it

unborn abyss Mar 2, 2025, 10:08 AM

#

yes

lethal oriole Mar 2, 2025, 10:08 AM

#

instead of the database_url?

unborn abyss Mar 2, 2025, 10:08 AM

#

no

#

SQLALCHEMY_DATABASE_URI = "..."

lethal oriole Mar 2, 2025, 10:09 AM

#

Oh

#

okay let me try, hold on.

unborn abyss Mar 2, 2025, 10:09 AM

#

however later you will need to fetch the value from env vars

lethal oriole Mar 2, 2025, 10:09 AM

#

#

it's red...

#

import os


class Config:
    SECRET_KEY = os.environ.get('SECRET_KEY')
    SQLALCHEMY_DATABASE_URI = sqlite:///instance/data.db 
    MAIL_SERVER = 'smtp.googlemail.com'
    MAIL_PORT = 587
    MAIL_USE_TLS = True
    MAIL_USERNAME = os.environ.get('EMAIL_USER')
    MAIL_PASSWORD = os.environ.get('EMAIL_PASS')```

#

oh wait

#

I added '

unborn abyss Mar 2, 2025, 10:10 AM

#

as a string dude

lethal oriole Mar 2, 2025, 10:10 AM

#

yes yes

#

I realized that lol.

#

Hmmmm, I ran it...but will it work...?

#

...it didn't.

#

#

This same error again...

lethal oriole Mar 2, 2025, 10:13 AM

#

unborn abyss as a string dude

I ran into this error...what do I do now?

lethal oriole Mar 2, 2025, 10:14 AM

#

lethal oriole

Ughhhhhhhhhh

#

Why can't it just work???

unborn abyss Mar 2, 2025, 10:15 AM

#

lets try

#

sqlite:////instance/data.db

#

this value

lethal oriole Mar 2, 2025, 10:16 AM

#

4 /'s?

unborn abyss Mar 2, 2025, 10:16 AM

#

yeah

#

not sure

lethal oriole Mar 2, 2025, 10:16 AM

#

I tried that before, but it didn't work.

unborn abyss Mar 2, 2025, 10:16 AM

#

try it now

lethal oriole Mar 2, 2025, 10:16 AM

#

Okay let me see.

#

Yep.

#

Same error.

#

unborn abyss Mar 2, 2025, 10:17 AM

#

which file contains this function: create_app

lethal oriole Mar 2, 2025, 10:18 AM

#

let me check.

#

run.py.

#

lethal oriole Mar 2, 2025, 10:22 AM

#

unborn abyss which file contains this function: create_app

Maybe we can ask someone else for help, if you know someone?

#

I wonder if it's just as you said, it's just old...?

#

The code did work in the video, but that was in 2018...

lethal oriole Mar 2, 2025, 10:30 AM

#

unborn abyss which file contains this function: create_app

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_bcrypt import Bcrypt
from flask_login import LoginManager
from flask_mail import Mail
from flaskblog.config import Config
db = SQLAlchemy()
bcrypt = Bcrypt()
login_manager = LoginManager()
login_manager.login_view = 'users.login'
login_manager.login_message_category = 'info'
mail = Mail()


def create_app(config_class=Config):
    app = Flask(__name__)
    app.config.from_object(Config)

    db.init_app(app)
    bcrypt.init_app(app)
    login_manager.init_app(app)
    mail.init_app(app)

    from flaskblog.users.routes import users
    from flaskblog.posts.routes import posts
    from flaskblog.main.routes import main
    app.register_blueprint(users)
    app.register_blueprint(posts)
    app.register_blueprint(main)

    return app```

#

This also has the create_app.

#

@unborn abyss

lethal oriole Mar 2, 2025, 10:35 AM

#

lethal oriole ```python from flask import Flask from flask_sqlalchemy import SQLAlchemy from f...

it's in the flaskblog_init_.py.

lethal oriole Mar 2, 2025, 11:14 AM

#

I guess I will never know the answer to this error... 💀

agile reefBOT Mar 2, 2025, 12:14 PM

#

Python help channel closed for inactivity

This help channel has been closed. Feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.

#🔒 someone help pls sqlalchemy RuntimeError