I am trying to build a REST API unsing golang and GORM specifically. I have four entities: Promo, which contains many PromoUnique entities, one Target entity which also contains many Category entities. Code: type Promo struct { PromoID string `json:"promo_id"…
I'm working on a Spring Boot project that connects to a PostgreSQL database, but I'm encountering issues with the database connection setup. The logs show the following: The database driver is reported as "undefined/unknown." There are warnings related to Hibernate,…
I want to arrange pending orders by eta in asc order and completed orders in desc order, with all completed orders appearing at the bottom of the list. Not sure if this is possible in a single query. Example data…
I need to update a column in a PostGIS database. I want to do that with this: UPDATE cj_geometry SET groundgeometry = CASE WHEN NOT ST_IsValid(groundgeometry) THEN ST_Multi( ST_CollectionExtract( ST_MakeValid(groundgeometry), 3 ) ) ELSE ST_MakeValid(groundgeometry) END It's around 65.000.000 lines.…
Here is the first table A in Redshift: team origin_id targte_id a 1 11 b 2 22 b NULL 33 c 5 55 c NULL 66 The origin_id and target_id could be NULL, but they couldn't both NULL in one…
My attempt to create/integrate Postgresql database and run Django development server continues to fail and I've followed every step in this tutorial (search page for 'Setting Up PostgreSQL with Django'): (website 1) https://www.hostinger.com/tutorials/django-tutorial When I run the development server and…
I am a student and working on a query to update all records in a table with the distance from a specific point (a town). I am using Pgadmin4 with a postgreSQL/postgis database. I created a select query that calculates…
I'm trying to bulid a REST API using go and specifically GORM. My entities look like this: type Business struct { ID string `json:"id" gorm:"primaryKey;not null;type:uuid;default:gen_random_uuid()"` CreatedAt time.Time `json:"-"` UpdatedAt time.Time `json:"-"` Email string `json:"email" gorm:"uniqueIndex;not null;"` Password []byte `json:"-"`…
I have prepared a DB Fiddle for my question and I will also show my complete code below - I am trying to store data in a vehicle_data table and each data record has an expires_at column: -- Create table…
I am trying to select data from two tables A and B (which have more or less the same column), and create a third table C which will also contain similar columns Something like this: CREATE TABLE C as (…