My project is web back-end that using Go http framework: gin-gonic/gin module. My example repository PostgreSQL database I am using a remote hosted database (Render) and jmoiron/sqlx module to connect to PostgreSQL database. With the local database exactly the same…
I have the next Tree Structure : This structure is represented in the database with the next Table: --------------------------------Employees------------------------------------------- ------------------------------------------------------------------------------------- | Employee_name | Global_Team | Team | ------------------------------------------------------------------------------------- |name_of_head_of_engineering | - | Engineering | ------------------------------------------------------------------------------------- |name_1_T1 | Engineering | Team_1…
In RoR app I want to write a model method that will return some records. It should select by ids if ids are present or all records if not def viewing_duration(ids = nil) if ids tracks.where(video_id: ids).sum('age(updated_at, created_at)') else tracks.sum('age(updated_at,…
I have created 2 triggers in postgresql that execute the same function. One for insert and the other one for update. The update trigger seems to be working fine, but the insert trigger is not working the way I would…
I have table with jsonb column "Details": {"Type": "VIP", "Quantity": 1} I want update column, using query that copies value from "Type" field to new one "Subscription" and change value "VIP"->2. Exp below: {"Type": 2, "Quantity": 1, "Subscription": "VIP"} I…
I recently gave test on codility platform and was stuck on below SQL question. Question: For an online platform assessments were conducted for 3 topics and scores were provided. Table: Assessments Input: |Id|experience|sql|algo|bug_fixing| |1 |5 |100|null|100 | |2 |1 |100|100…
I am creating a VM in azure to upload a postgres instance in docker and connect to it with my local backend in Spring. What happens is that once connected to the DB after X time of inactivity when trying…
I have 2 models: class Item < ApplicationRecord has_many :tags, dependent: :destroy end class Tag < ApplicationRecord belongs_to :item end My current query will return Items that have ANY of the tags in a list, I need it to only…
I need to dynamically create tables in python this statement works when the variable is statically identified but when I use a variable I get the following error import psycopg2 from psycopg2 import sql def create_table(table_name): """ create tables in…
I'm new with PostgreSQL. I'm trying to add a connection using the extension PostgreSQL by Chris Kolkman, the error mentioned cannot get password on the lower right of VS code. here's the image.