Category "sqlalchemy"

PickleType hysteresis: PickleType column sometimes doesn't auto-pickle list, sometimes does

I'm trying to store Python objects (including lists) as blobs in PickleType columns. re PickleType: | PickleType builds upon the Binary type to apply Python's

Setting Data Frame Column Names with Data Frame includes extra characters: ('ColumnName',)

I've got a python script set to pull data and column names from a Pervasive PSQL database, and it then creates the table and records in MS SQL. I'm creating dat

Flask SQLAlchemy: many to many relationship error

I am trying to set up many-to-many relationship in SQLAlchemy but I am getting the error: from shopapp import db db.create_all() sqlalchemy.exc.NoReferencedTab

AttributeError: 'BaseModel' object has no attribute '_sa_instance_state'

I have the following code in my app: models.py class MainTable(Base): __tablename__ = "main_table" id = Column(Integer, primary_key=True, index=True)

Creating db tables with SQLAlchemy and running Celery tasks raises "error with status PGRES_TUPLES_OK and no message from the libpq"

I have an application that runs 2 tasks every minute. Both of them have almost the same code, except for the API endpoint they communicate with (see below). Whe

Is there any way to filter by the first child using SqlAlchemy?

I'm trying to find a way to filter by the attribute of the first row returned as children. class Parent(Base): __tablename__ = "parent_table" id = Colum

Export HANA SQL query or table in CSV

I use a HANA 2.0 database. I want to export a table or a sql query from the database to an external client as fast as possible and using a command line (i'm on

How to fix error in db.create_all() in docker?

Trying to launch postgres and flask in docker. Postgres is working ok as i see. But flask is cancelling to work properly The head of log is here: Traceback (mo

sqlalchemy return constant dict in select

I am using sqlalchemy with MySql. I need to return a dict in select. Adding that dict value to fetched data is not an option. Is there any way in sqlalchemy or

Multiple flask calls in single pytest having different databases

So I'm trying to test an endpoint in flask that I need to call multiple times in one test. The issue I am having is that on the second request the objects I pla

How to use a standalone Operations instance and rollback changes?

The Alembic documentation states that "a standalone Operations instance can be made for use cases external to regular Alembic migrations by passing in a Migrati

Hybrid expression for relationship of relationship

I have three models linked by a relationship chain. An entry has requests and a partner. So every request has a related partner by this: class Request(db.Model)

Parameter substitution when calculating the distance between each row and a common point results in psycopg2 parse error

I have two models with no relation Port and a WareHouse each with a lat and long fields. I want to be able to get the distance for each warehouse from the Port

Inserting rows into Microsoft SQL Server using pandas raises precision error

I am trying to insert data into a mssql database. I needed as fast method for this so I set the fast_executemany param to true. The upload works fine for most p

How to suppress warnings on cross join select without where clause in sqlalchemy?

When doing something like : import sqlalchemy as sa with session() as S: print(S.execute(sa.orm.select(A, B)).all()) sqlalchemy display this warning : <i

ForeignKey serialized as empty dict and not getting populated with data

I've two models Profile & Product representing One-Many relationship. One profile can have many products. I'm serializing all the fields. The column which h

Query difference between db.session.query and Model.query in flask-SQLAlchemy

The database is near 5 millions rows. I declare a model like below: class Amodel(db.Model): id = db.Column(db.Integer, primary_key=True) date = db.Col

SQLAlchemy column name with space

I'm trying to filter a table on a column that contain spaces. ... events = database_session.query(table) events.filter(table.column with space == 'xvalue') &

Join same table twice in SQLALCHEMY selecting only some columns

Consider I have 2 models: class User(db.Model): __tablename__ = 'user' id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(255)

How to get query data converting foreign table's another column

I'm now using sqlalchemy, fastapi develop some REST API. And facing some problem to join multiple tables I have 2 tables as below [campaigns] class Campaign(Bas

Other Categories