I have a Django project with ATOMIC_REQUESTS=True. When authentication fails I need to store critical data for the login attempt, here is example code: class LoginSerializer(serializers.Serializer): ... def validate(self, data): ... user = authenticate(email=email, password=password) if user is None: failed_login_attempt(email)…
I am using the row_number() functon to identify duplicates, partitioned by ID and Name: SELECT * , ROW_NUMBER() OVER(PARTITION BY "ID", "Name" ORDER BY "date" ASC) as row_number from table; My data looks like: ID Name date row_number 1 Name1…
Say I have a table with dates and associated data for each date. I want to select every date, but only show the associated data if it matches a WHERE clause, otherwise just fill it with NULL. The goal is…
I need to update jsonb column by jsonb_set, to use jsonb_set, need a full Json Path. How could I get full jsonb path when jsonb has list? For example, I got a JSON : { "Laptop": { "brand": "Dell", "price":…
I tried to make an API with golang and postgres using gorm framework.I got error that said cannot use r.GetBooks (value of type func(context *fiber.Ctx) error) as func(*fiber.Ctx) value in argument to api.Get Here's my code: import ( "fmt" "log"…
I'm working in a multi-tenant software to manage inventory of products and I'm having difficulties to create a query to bring products inventory based on quantity criteria. Use case: Bring all products with all their inventory from all warehouses from…
The wxvc_collection column data type is int[], t_hot_hub_operation_item is table name. fun main() { val connection = DriverManager.getConnection("jdbc:postgresql://localhost:5432/sage-dev", "postgres", "123456") val sql = "INSERT INTO t_hot_hub_operation_item (wxvc_collection) VALUES (?)" val statement = connection.prepareStatement(sql) val array = connection.createArrayOf("int4", arrayOf(listOf(1, 2, 3)))…
This is what I get as result for a simple query SELECT * FROM public.normative_documents ORDER BY id ASC I don't know why is it stacked like this, as it a clean Docker image. I tried to query from the…
I am getting raw data from a customer which I am loading into a db using a script. As of now, I am storing everything as strings. I have data in this format: 18.02.2024 00:06:09.125. I want to convert the…
I am using the Bitnami Postgresql-HA Helm charts to run a Postgresql cluster in Kubernetes. I also have a PersistentVolumeClaim (PVC) full of data that isn't going into the database. I'd like to mount this PVC in my Postgres pods…