I have two postgresql tables with the following data [teams] [id][team_name] 1 team 1 2 team 2 3 team 3 [matches] [participant 1][participant 2] 1 3 2 1 3 2 The matches table references the team ID. I am trying…
In my DRF project, I have a model structured like this class ServiceLocation(models.Model): ''' Represents a location where an internet service is offered ''' SERVICE_TYPES = [ ("wifi", 'wifi'), ("fibre", "fibre"), ("p2p/ptmp", "p2p/ptmp") ] id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False, null=False,…
I am designing the database for a project that I am working on, basically the project is a question bank. Each question has a flag(mark), where the user can set it as true so that they mark it to get…
I have a simple order table in my postgres db and I want to join from a table of payments to create a new column for each order where the latest payment is indicated. Each payment row looks like this:…
I've been struggling to find a straightforward solution for connecting Azure data factory or Fabric to an on-premises SSAS cube. I've searched extensively, but all I come across are guides on connecting to SQL Server or discussions stating that connecting…
Here I am trying to run this query and it is giving me error. I don't understand why it is a bad request. I am trying to get the specific user from the database using accountId. Please help This is…
I have a Laravel project set up on my MacBook and I'm encountering an issue with connecting to the database when using PHP artisan serve. Here's the problem: When I access the project via localhost/project_name/public, everything works fine, and database…
For about two weeks now I have the surreal problem that almost every order has the correct items but wrong meta datas and the ordered number of items are changed like 3-20 instead of just one. I had a bloated…
I'm encountering a database connection issue in my newly hosted Laravel 11 application on Hostinger. I've carefully configured the files and database in phpMyAdmin, but I'm getting this error: SQLSTATE[HY000] [1045] Access denied for user 'root'@'127.0.0.1' (using password: NO) this…
I tried to create a 1-to-1 relationship in PostgreSQL but when i check the ERD it looks like a 1-to-many relationship. this is my SQL script: CREATE TABLE capital ( id SERIAL PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE country…