I'm trying to connect to a Postgres database with SQLAlchemy. I've installed psycopg2. However, I get the error sqlalchemy.exc.NoSuchModuleError: Can't load plu
im developing a new project, im building a small CRM web app using Flask. Im very new using this technology. Im getting this error: AttributeError: Could not lo
Is there a way to delete or modify a table using flask-sqlalchemy? I am working on a Flask-based web app. I switched to flask-sqlalchemy as my project is on Her
I'm not a pro in python, I just have a username and password stored statically in my python config file, the app use this credentials to FTP some files. I canno
I am trying to configure flask SQLAlchemy with MySQLWorkBench, The following command works good: flask db migrate -m'Config' But when I try to execute flask db
I have a query using flask-sqlalchemy in which I want to delete all the stocks from the database where there ticker matches one in a list. This is the current q
I ran into the following error: File "/home/sandbox/.local/lib/python3.6/site-packages/sqlalchemy/sql/sqltypes.py", line 1973, in _strict_as_bool raise Ty
This SQL is OK CREATE TABLE `calendar` ( `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `d` date as (dt), `t` time as (dt) ); How to create this tab
I have a problem. I have IP addresses and with APScheduler I try to ping them every 10 seconds and update my database. For APScheduler I understand that I need
I have a database app, and want to create the tables and database on the fly when starting the app for the first time. If the app is restarted, it should only c
I'm learning flask web microframework and after initialization of my database I run flask db init I run flask db migrate, to migrate my models classes to the da
I have some code, but it gives me an error. It's done with Flask, and here is the error: https://hastebin.com/emifitopof.sql File forms.py class PostForm(FlaskF
I started using Flask-Migrate today and installed it on a test project. However i am getting following error: alembic.util.exc.CommandError: Can't locate r
I am new in both flask and sqlalchemy, I just start working on a flask app, and I am using sqlalchemy for now. I was wondering if there is any significant benef
I'm using the SQLalchemy association-object pattern (http://docs.sqlalchemy.org/en/rel_1_1/orm/basic_relationships.html#association-object) for three model clas
Is there a solution converting a SQLAlchemy <Query object> to a pandas DataFrame? Pandas has the capability to use pandas.read_sql but this requires use o
Is there a solution converting a SQLAlchemy <Query object> to a pandas DataFrame? Pandas has the capability to use pandas.read_sql but this requires use o
I am using SQlAlchemy in my web project. What should I use - scoped_session(sessionmaker()) or plain sessionmaker() - and why? Or should I use something else?
I'm using the declarative Base in flask_sqlalchemy. In my database.py file I have the following: from sqlalchemy import create_engine # from sqlalchemy.orm imp