I have a little problem writing a request. With the data example below, i want to recover the archive_id that have a document_type_id = 18 and 20 +------------+------------------+ | archive_id | document_type_id | +------------+------------------+ | 1 | 20 | |…
I have two dates, e.g. '2022-01-03' and '2022-03-04', is there any neat way to calculate ONLY the completed full calendar months between these dates? Some examples with their requested outputs: '2022-01-03' and '2022-03-04' full calendar months = 1 since only…
What I'm trying to do: Deploy my django app to render.com with a postgres database. I'm following the render guide: Getting Started with Django on Render. Problem: I am getting a build failed log error saying the following: django.db.utils.OperationalError: could…
I am using the dotenv framework to connect my python script to a postgres database. I have a list of ids and want to delete all the rows containing thoses ids ids_to_delete = df["food_id"].tolist() conn = create_conn() with conn.cursor() as…
I have a gaps and islands SQL problem combined with a recursion. Background: I run a PostgreSQL database with school vacations and bank holidays from which I render calendar views for schools, city and what not. I code a lot…
I have a table with event entity create table event_entity ( id varchar(36) not null constraint constraint_4 primary key, details_json varchar(2550), event_time bigint, type varchar(255), user_id varchar(255) ); details_json has such data: { "custom_required_action":"VERIFY_EMAIL", } I need to create a…
I have a table CREATE TABLE items( id SERIAL PRIMARY KEY, group_id INT NOT NULL, item_id INT NOT NULL, name TEXT, ..... ..... ); I am creating a function that takes set of row values for a single group_id, fail…
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…
I am new to SQL and still learning functions and triggers. I have 3 tables: PRODUCTS_BOUGHT CUSTOMER DATE PRODUCTS 3FG 2022-12-15 25 4HZ 2022-12-18 30 PRODUCTS_PRICE: DATE TYPE PRICE 2022-12-15 A 125$ 2022-12-18 B 147$ CUSTOMERS_REGISTER: CUSTOMER TYPE 3FG A…
I have the following structure: Training Type Contains multiple sessions Each session can have multiple slots A slot has a start date. (date column) How to compute for each Training Type the total of sessions whose all the slots are…