I have a query such as: select_query = [text(f) for f in fields] with engine.connect() as conn: query = select(*select_query, MyTable.id).select_from( table(MyTable.__tablename__) ... Everything works fine except when the field (inside select_query) is camelcase. Is there any function or directive…
If there is a field in the description of the resulting table in the function declaration (for example, field1) that occurs in parentheses "insert ... on conflict(field1)", then an error occurs when executing the function: SQL Error [42702]: ERROR: column…
I need to convert number to timestamp in PostgreSQL. I got numbers in database as character varying. I have seen there is a lot of solutions for integers but I got decimal numbers and here comes the issue. The max…
id client_id driver_id city_id status request_at 1 1 10 1 completed 2023-12-23 2 2 11 1 cancelled_by_driver 2023-12-23 3 3 12 6 completed 2023-12-23 4 4 13 6 cancelled_by_client 2023-12-23 5 1 10 1 completed 2023-12-24 6 2 11 6…
I have rewritten the below query from using a correlated subquery to using a LATERAL JOIN. It is now faster, and I would like to understand why? This SO answer says that there is no golden rule and that it…
I have a table that consists information about status of each customer every day. However, due to space saving, I would like to keep that information only if something has changed. More specifically: ID Customer ID Date Status 1 1…
After setting the configuration parameter with set_config() I can read it with current_setting(). But if exception ocured and I try to read value within the exception block it is undefined. do $$declare l_ctx_prm text := 'some_value'; l_dummy numeric; begin raise…
I have a type that represents a persisted record. I want to have a very similar type that represents data that should be POSTed to create a new record. This is the full type: data Record = Reading { id:…
I have been doing side spring-boot demo project about heroes and villains. Below is the Character class which is extended by Superhero and Villain classes: @Data @NoArgsConstructor @Entity @Table(name = "characters") @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) @JsonTypeInfo(use = JsonTypeInfo.Id.NAME, property = "type")…
I'm developing a Spring Boot application with a PostgreSQL database. Within this application, I've implemented the functionality to create bots. Here's a glimpse of my Bot entity: @Data @Entity @Table(name = "bots") @NoArgsConstructor @AllArgsConstructor @Builder public class Bot { @Id…