I am working on a system using JPA where Entity 'Events' are associated with Entity 'Groups' and each Group has five boolean columns (Group1, Group2...) indicating their attendance status for an event. Now, I need to enhance the system by…
i have a table like bellow in postgres start_at end_at 17/1/2023 15/3/2023 i want to split this like bellow start_at end_at 17/1/2023 31/1/2023 01/2/2023 28/2/2023 1/3/2023 15/3/2023 I have tried generate series of postgres but not able to generate desire…
I have two tables similar to this example (simplified for clarity): parent: | id | name | amount | year | ---------------------------------------- | 101 | Henry | 300 | 2020 | ---------------------------------------- | 102 | Carol | 100 | 2020…
What is the better way to insert a very large data into PostgreSQL Table? OS: Ubuntu 22.04 LTS DB: PostgreSQL 14 Framework: Python 3.11 Django For now I am using insert into statement of 100,000 rows at a time. It…
I have a table named user_activity. user_id book_id event_type_id 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 2 1 1 3 1 event_type_id represents "User has viewed the book". I want to…
I am currently working on a Laravel project and encountering an issue with Eloquent relationships. I have two models, User and Post, and I'm trying to establish a one-to-many relationship between them. However, I'm facing issues when trying to retrieve…
So i have a code here of me getting my users data so its like this in postman now when i do it in frontend its not fetching the data of it this is the hook state of my code…
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'employee_id' cannot be null (Connection: mysql, SQL: update attendance_employees set employee_id = ?, date = ?, clock_in = ?, clock_out = ?, late = -473049:00:00, early_leaving = 473058:00:00, attendance_employees.updated_at = 2023-12-19 16:23:08 where id…
I want to optimize performance of this MySQL query SELECT * FROM ( (SELECT * FROM users USE INDEX(names) WHERE name LIKE '%leo%') UNION (SELECT * FROM users USE INDEX(names) WHERE name LIKE '%le%') UNION (SELECT * FROM users USE…
I need assistance in building this custom query. Given this data: f_id sub_id field_name field_val 79 263 track_id 57162 80 263 track_title Antoniomontes 81 263 info_2 green 82 263 others older 83 264 track_id 37164 84 264 track_title veinticuatro treintado…