In [3]:

    

import csv, re


    

In [4]:

    

len(ImageThesaurus.objects.all())


    

    
Out[4]:





137

In [5]:

    

#for y in ImageThesaurus.objects.all():
    #y.delete()


    

In [6]:

    

file = "images.csv"


    

In [7]:

    

with open(file, 'r') as data:
    reader = csv.reader(data)
    datalist = list(reader)


    

In [8]:

    

failed_saves = []
c = 0


    

In [9]:

    

for x in datalist[1:]:
    if len(ImageThesaurus.objects.filter(filename=x[0])) != 0:
        print(ImageThesaurus.objects.filter(filename=x[6]))
        print("{} already in db".format(x[3]))
    else:
        newImage, _ = ImageThesaurus.objects.get_or_create(name=x[3],
                                                           filename=x[0],
                                                           page=x[5],
                                                           image='images/'+x[6])
        newImage.save()
        split_region = x[1].split("_")
        region_objects = []
        for region_name in split_region:
        #print(region_name)
            new_region = DC_region.objects.get(name=region_name)
            region_objects.append(new_region)
        newImage.region = region_objects
        newImage.literature = Book.objects.get(zoterokey=x[4])
        newImage.save()


    

    




[]
Barbotine already in db
[]
Brushed already in db
[]
Burnished already in db
[]
Coarse already in db
[]
Grooved already in db
[]
Incised_Pointillé_Decoration already in db
[]
Incised already in db
[]
Painted already in db
[]
Pattern_Burnished already in db
[]
Pellet_Decoration already in db
[]
Plastic_Cordon_Decoration already in db
[]
Plastic already in db
[]
Pointillé_Decoration already in db
[]
Red_On_Buff already in db
[]
Rippled_Burnished already in db
[]
Rippled already in db
[]
Scribble_Burnished already in db
[]
Wiped already in db
[]
Baking_Pan already in db
[]
Bowl already in db
[]
Carinated_Bowl already in db
[]
Carinated_Incurved_Bowl already in db
[]
Carinated_Jar already in db
[]
Chalice already in db
[]
Cheese_Pot already in db
[]
Collared_Jar already in db
[]
Cup already in db
[]
Deep_Bowl already in db
[]
Funnel_Necked_Jar already in db
[]
Hole_Mouthed_Jar already in db
[]
Jar already in db
[]
Jug already in db
[]
Pyxis already in db
[]
Rhyton already in db
[]
Coarse_Urfirnis already in db
[]
Elephant_Lug already in db
[]
Flat_Base already in db
[]
Knob already in db
[]
Ledge_Lug already in db
[]
Pedestal_Base already in db
[]
Rim_Attachement already in db
[]
Rolled_Rim already in db
[]
Round_Bar_Handle already in db
[]
Strap_Handle already in db
[]
Stringhole_Lug already in db
[]
Tab_Handle already in db
[]
Tubular_Lug already in db
[]
Amphora already in db
[]
Askos already in db
[]
Baking_Pan already in db
[]
Bowl already in db
[]
Carinated_Bowl already in db
[]
Cheese_Pot already in db
[]
Collared_Bowl already in db
[]
Collared_Jar already in db
[]
Cup already in db
[]
Fruitstand already in db
[]
Globular_Jar already in db
[]
Gouged_Bowl already in db
[]
Hole_Mouthed_Jar already in db
[]
Jar already in db
[]
Jug already in db
[]
Piriform_Jar already in db
[]
Pithos already in db
[]
Scoop already in db
[]
Shouldered_Bowl already in db
[]
Skyphos already in db
[]
Brown_On_Buff already in db
[]
Channeled already in db
[]
Excised_With_Graphite already in db
[]
Grooved_With_Graphite already in db
[]
Plastic already in db
[]
Red_On_White already in db
[]
Red_Slipped already in db
[]
Rippled already in db
[]
Rusticated already in db
[]
Shell_Stamped already in db
[]
Smeared already in db
[]
Smooth_Ware already in db
[]
White_On_Red already in db
[]
High_Strap_Handle already in db
[]
Mushroom_Handle already in db
[]
Amphora already in db
[]
Bowl already in db
[]
Cup already in db
[]
Jar already in db
[]
Jug already in db
[]
Lid already in db
[]
Pithos already in db
[]
Plate already in db
[]
Pyxis already in db
[]
Scoop already in db
[]
Sieve already in db
[]
Stand already in db
[]
Tripod already in db
[]
Double_Tab_Handle already in db
[]
Elephant_Lug already in db
[]
Flat_Base already in db
[]
High_Strap_Handle_With_Knob already in db
[]
Horned_Strap_Handle already in db
[]
Horn_Handle already in db
[]
Knob already in db
[]
Ledge_Lug already in db
[]
Pedestal_Base already in db
[]
Rim_Attachement already in db
[]
Ring_Handle already in db
[]
Rolled_Rim already in db
[]
Small_Ring_Handle already in db
[]
Spout already in db
[]
Strap_Handle_With_Knob already in db
[]
Strap_Handle already in db
[]
Stringhole_Lug already in db
[]
Tab_Handle already in db
[]
Triangular_Ring_Handle already in db
[]
Vertical_Knob_Row already in db
[]
Wishbone_Handle already in db
[]
Zoomorphic_Handle_Attachement already in db
[]
Amphora already in db
[]
Askos already in db
[]
Baking_Pan already in db
[]
Basin already in db
[]
Bowl already in db
[]
Carinated_Bowl already in db
[]
Cheese_Pot already in db
[]
Collared_Jar already in db
[]
Cup already in db
[]
Dimini_Bowl already in db
[]
Fruitstand already in db
[]
Globular_Jar already in db
[]
Hole_Mouthed_Jar already in db
[]
Jug already in db
[]
Ladle already in db
[]
Lamp already in db
[]
Pithos already in db
[]
Scoop already in db
[]
Tripod already in db
[]
Tulip_Shaped_Beaker already in db

In [10]:

    

len(ImageThesaurus.objects.all())


    

    
Out[10]:





232