sqlalchemy Questions

Null instead of null values in jsonb_build_object – Postgresql

January 15, 2023
Taras Hrybyk
2 Answers

I am trying to build query that gets data from 3 different tables using sqlalchemy I tried select( models.Animals.id, models.Animals.description, models.AnimalTypes.name.label('type'), func.coalesce( func.array_agg( func.jsonb_build_object( 'id', models.Animals.id ) ), None ).label('animals') ) .join(models.FamilyTypes, models.Family.id == models.Family.family_type_id) .outerjoin(models.Animals, models.Animals.campaign_id == models.Animals.id) .group_by(models.Family.id,…

VIEW QUESTION

Trying to connect to SQLalchemy engine – Postgresql

January 2, 2023
Darman
2 Answers

So i have a YAML file with the following parameters which I read into a dictionary The part i don't get is how to connect it to the SQL engine, I have looked at the documentation and what i need…

VIEW QUESTION

sqlalchemy.exc.ArgumentError: List argument must consist only of tuples or dictionaries – Mysql

December 19, 2022
Abdulaziz Ibrahim
2 Answers

I have been trying to dump data into a mysql database using sqlalchemy. While I try do so its gives the error sqlalchemy.exc.ArgumentError: List argument must consist only of tuples or dictionaries . The following code is being used for…

VIEW QUESTION

How to define a column as an Array of any type in POSTGRESQL FlaskSQLAlchemy?

December 19, 2022
Saurav Pathak
2 Answers

I am using flask_sqlalchemy and I want to define column prompts to be an array which accepts values of any data type, particularly string or json. from flask_sqlalchemy import SQLAlchemy db = SQLAlchemy(app) class PreannotationPrompts(db.Model): id = db.Column(db.Integer, primary_key=True) name…

VIEW QUESTION

SQLAlchemy Joining 2 CTE Results in Ambiguous ON Clause – Postgresql

December 14, 2022
BusinessFawn
2 Answers

I'm attempting retrieve a max version for either a published version or, if a resource has no published versions, the highest version. I'm using 3 CTE to find these values, one to get the max version that is published, a…

VIEW QUESTION

sqlalchemy join returns results from first table only – Mysql

December 7, 2022
Isaac Rivera
2 Answers

so this is my issue, I have the following tables: class ClientCampaings(Base): __tablename__ = 'client_campaign' campaign_id = Column(INTEGER, primary_key=True) client_id = Column(VARCHAR(50)) campaign_name = Column(VARCHAR(45)) campaign_status = Column(VARCHAR(45)) campaign_type = Column(VARCHAR(45)) registration_date = Column(DATE) class ClientKpi(Base): __tablename__ = 'client_kpi' kpi_id…

VIEW QUESTION

Querying over PostgreSQL JSONB column

December 6, 2022
Irtaza
2 Answers

I have a table "blobs" with a column "metadata" in jsonb data-type, Example: { "total_count": 2, "items": [ { "name": "somename", "metadata": { "metas": [ { "id": "11258", "score": 6.1, "status": "active", "published_at": "2019-04-20T00:29:00", "nvd_modified_at": "2022-04-06T18:07:00" }, { "id": "9251",…

VIEW QUESTION

Postgresql – SQLAlchemy Error '(psycopg2.errors.NotNullViolation) null value in column "id" of relation

November 11, 2022
Malice
2 Answers

I am aware of a similar issue How to fix error: (psycopg2.errors.NotNullViolation) null value in column "id" violates not-null constraint? but the answers there did not fix my error I have the following sqlalchemy structure connected to a postgres database…

VIEW QUESTION

Postgresql – SQLAlchemy filter with many-to-many relations

November 6, 2022
John C
2 Answers

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…

VIEW QUESTION

Postgresql – How to check if time is not between two time entries within select

October 21, 2022
dpv
2 Answers

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 =…

VIEW QUESTION