print("Reading CART_CONTENT model ...")
cc = CART_CONTENT()
cc.Cart_contentID = int(row[0])
print("Cart_contentID = " + str(cc.Cart_contentID))
# Reading ISBN ...
bList = BOOK.objects.filter(ISBN=row[1])
if bList:
b = bList[0]
if b:
cc.ISBN = b
else:
b = BOOK()
b.ISBN = row[1]
b.save()
cc.ISBN = b
print("ISBN = " + cc.ISBN.ISBN)
# Reading Cart_ID ...
cList = CART.objects.filter(Cart_ID=row[2])
if cList:
c = cList[0]
if c:
cc.Cart_ID = c
else:
c = CART()
c.Cart_ID = row[2]
django.setup()
from BookDetails.models import BOOK, AUTHOR, PUBLISHER_INFO, GENRE
count = 0
data = csv.reader(open(
"/home/HOMEGROUP/adelg000/school/CEN4010/BookStore/sample_data/BOOK.csv"),
delimiter=",")
for row in data:
if count == 1:
print("Reading BOOK model ...")
book = BOOK()
book.ISBN = row[0]
print("ISBN = " + book.ISBN)
# Reading Genre ...
gList = GENRE.objects.filter(GenreID=row[1])
if gList:
g = gList[0]
if g:
book.GenreID = g
else:
g = GENRE()
g.GenreID = row[1]
g.save()