Alrite i have no idea why is it doing this ? My Json file contains 2567 entries per column
My Models File:
from django.db import models
import base64
from django.utils import timezone
from django_extensions.db.fields import AutoSlugField
# Create your models here.
class retailers(models.Model):
links = models.CharField(max_length=2000,unique=True)
shop = models.TextField()
country = models.TextField()
category = models.TextField()
title = models.CharField(max_length=300)
price = models.DecimalField(max_digits=10, decimal_places=2)
images = models.TextField()
color = models.TextField()
slug = AutoSlugField(populate_from=['country', 'shop', 'category', 'title'])
date_posted = models.DateTimeField(default=timezone.now)
def __str__(self):
return self.title
def save(self, *args, **kwargs):
if self.images[0:3] == "\\x":
A = self.images.replace("\\x","")
binary_data = bytes.fromhex(A)
base64_bytes = base64.b64encode(binary_data)
base64_string = base64_bytes.decode()
self.images = base64_string
super().save(*args, **kwargs)
My Manage py Shell Code:
import pandas as pd
from prods.models import retailers
R = pd.read_json("Final.json")
Links = R["links"].tolist()
Shop = R["shop"].tolist()
Country = R["country"].tolist()
Category = R["category"].tolist()
Title = R["title"].tolist()
Price = R["price"].tolist()
Images = R["images"].tolist()
Color = R["color"].tolist()
for L,S,CTRY,CT,T,P,I,CL in zip(Links,Shop,Country,Category,Title,Price,Images,Color):
K = retailers(links = L , shop = S,country = CTRY ,category = CT, title = T, price = P ,images = I,color = CL)
K.save()
This exact same code works when i had only 86 entries… SO maybe too much data ??
I Even tried retailers.objects.create, still no data is saved