I am using Java, Spring and JPA and cannot get cascade deletion to work. I have a class Tenant that looks like this @Entity @Validated @Data @Builder @NoArgsConstructor @AllArgsConstructor @TenantConstraints public class Tenant { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator =…
Suppose I have the following table id | items | price | 1| item_1 | 15.0 | 2| item_2 | 10.0 | 3| item_1 | 15.0 | 4| item_1 | 15.0 | 5| item_2 | 10.0 | 6| item_2 |…
I have created some schemas (dsfv, dsfn, etc.) and insert some tables inside each schema, including the following tables : poste_hta_bt (parent table with attribute "code_pt" as unique key); transfo_hta_bt (having also "code_pt" attribute as foreign key that referenced poste_hta_bt).…
Hi I'm trying to select the minimum and NOT the maximun date in a table. Instead of the maximun date I want to select the date of the fourth event. Any advice? User Event Date xyz 1 2021-06-06 xyz 2…
I have read-only access to a Postgres database. I can not write to the database. Q. Is there a way to construct and run a SQL query where I join a data frame (or other R object) to a table…
I am trying to filter out records where one specific field has special characters with words in them. For example: -[ RECORD 1 ]--------------+------------------------------ id | 3151 description | Manual add from SCCM mac_address | d4258be8d064 status | Unknown mac_vendor…
I trying to append a JSON value in the Postgres table Table structure id | name | field ------------------------------------ 1 | jack |{age:22, place:"london"} 2 | rocky|{age:34, place:"nyc"} for the first records, I'm appending the value "NYC" to the existing…
I have a project with Django, Django REST Framework and PostgreSQL. And my goal to make a search with certain conditions: logical operators (AND, OR, NOT) case insensitive operator like * To search by prefixes. som* -> search for some,…
I'm trying to sum a column based on a condition in another column with partition by in SQL, but it's not working. So I hope somebody can help me with this. My table is like this: Group_1 Group_2 Date Value…
I have an entity Message that has a sender (User) and a receiver, but the receiver can either be a User or a Channel (both entities have the messagesIn member), and I want to implement this using TypeORM relationships. Would…