In Django I have folder with fixturesgoodscategories.js and fixturesgoodsproducts.js. I installed PostgreSQL and I have tables categories and products. But when I write python manage.py loaddata fixtures/goods/categories.json I get the error: CommandError: No fixture named 'categories' found. How do I…
Consider this [v good] example from Using recursive CTE to generate a range of data WITH RECURSIVE date_range AS ( SELECT '2023-01-01'::timestamp AS date UNION ALL SELECT date + interval '1 day' FROM date_range WHERE date < '2023-12-31' ) SELECT…
I have this database setup: class Profile(AbstractBaseUser, PermissionsMixin): email = models.CharField(max_length=30, null=True, unique=True) date_created = models.DateTimeField(auto_now=True) ... class SubProfile(models.Model): profile = models.OneToOneField(Profile, on_delete=models.CASCADE) display_name = models.CharField(max_length=25) ... class SubProfilePost(models.Model): profile = models.ForeignKey(Profile, related_name='sub_profile_postings', on_delete=models.CASCADE) title = models.CharField(max_length=20, null=False) looking_for_date =…
I'm trying to select pairs of events from my data. I have a data that looks like this: create table test(id,status,created)as values (1, 'on','2024-09-01'::date) ,(2, 'on','2024-09-02'::date) ,(1,'off','2024-09-03'::date) ,(1, 'on','2024-09-04'::date) ,(2,'off','2024-09-05'::date) ,(3, 'on','2024-09-06'::date) ,(1,'off','2024-09-07'::date) ,(4,'off','2024-09-08'::date); I would like to have data…
In postgres I can define custom option using set x.x = 12; I can also read it using following query SHOW x.x; But I couldn't find any command to list all such defined options. Is there anything I can use…
I know there are a number of questions posted around this and I have read through those, but I cannot seem to solve this issue. The Set Up I have my react app running on localhost:3000. My Express Server is…
I'm working on a gift card system where I have two main database tables: GiftCards and ActivationCodes. Each gift card can have many pre-generated activation codes, and after a user purchases a gift card, they should receive one of the…
I have a price column in my .sql file that is currently a string of numbers (prices). I want to use python to modify the string of numbers and convert them into actual numbers (floats to be specific). This is…
I am getting following error when inserting data in Postgres in a multi-threaded env, I am relying of serial data type to assign PK assuming it is thread-safe, I lose data when I get following error, how can ensure that…
I need to select rows from the database that are unique by date. Ideally, there will be very few such strings, but if they come across, then you need to select only one value among them. DISTINCT assumes just a…