A store can have many interests. User request a product that is tagged. Query required is to get the product requests that have tags shared with current store. # in Store -> relationship('Tag', secondary=store_interest_tags, lazy='dynamic', backref=backref('store', lazy=True)) store_tags = store.interests…
I have two columns in PostgreSQL that store time values (H:M:S) and I use SQLAlchemy. How can I make a select using SQLAlchemy for values that are not between the two values? Example 1: current time in the interrogation =…
I have a calculated (computed) column in a table and would like to insert rows with the calculated column not specified with SQLAlchemy. However, the SQL query for insert generated by SQLAlchemy includes the calculated column. Is there a way…
I am writing a Flask app with SqlAlchemy and PostgreSQL. When I try to enter a value into an enum field that has more than six characters, I get the following error: sqlalchemy.exc.DataError: (psycopg2.errors.StringDataRightTruncation) value too long for type character…
My postgres DB has a Price table where I store price data for a bunch of products. For each Price object I store when it was created (Price.timestamp), and whenever there is a new price for the product, I create…
I have the following SQL database details: import sqlalchemy as sch from config import Config db_uri = os.environ["SQLALCHEMY_DATABASE_URI"] + os.environ["DB_NAME"] in the env file I have these SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://*****:*****@instance-amazonaws.com:3306/' DB_NAME = 'DB_NAME' Now db_engine = extrac_db.create_engine(Config.db_uri) db_connection = db_engine.connect()…
I am building a Flask application in Python. I'm using SQLAlchemy to connect to PostgreSQL. In the flask application, I'm using this to connect SQLAlchemy to PostgreSQL engine = create_engine('postgresql://postgres:[mypassword]@db:5432/employee-manager-db') And this is my docker-compose.yml version: '3.8' services: backend: build:…
I am using sqlalchemy with postgresql, Tables Shape[id, name, timestamp, user_id]#user_id referring id column in user table User[id, name] this query - query1 = self.session.query(Shape.timestamp, Shape.name, User.id, extract('day', Shape.timestamp).label('day'), extract('hour', Shape.timestamp).label('hour'), func.count(Shape.id).label("total"), ) .join(User, User.id==Shape.user_id) .filter(Shape.timestamp.between(from_datetime, to_datetime)) .group_by(Shape.user_id) .group_by('hour') .all()…
Hello I have a telegram bot connected to a MySQL db. I'm using a free account of PythonAnywhere which allows me to have max 3 connections to db per user. But I've been getting a max_user_connections error, so I've configured…
I Have a Flask project. Process are work normal. Database is PostgreSql. Everything is working on this Database. But when I Can use Python Rq I dont reach tables with SqlAlchemy. My project is on heroku. How can i solve…