initDB.py

#-*- coding: utf-8 -*-

from SmellGuess.models import *
from SmellGift.models import *

def SaveHumor(nameFr, nameEn, rgb):
	h = Humor.objects.language('fr').create(name=nameFr, color=rgb)
	h.translate('en')
	h.name = nameEn
	h.save()

# Creating humors
SaveHumor('AFFECTION','AFFECTION','rgb(5,176,197)')
SaveHumor('ANXIETE','ANXIETY','rgb(203,211,0)')
SaveHumor('BONHEUR','HAPPINESS','rgb(229,39,120)')
SaveHumor('COLÈRE','ANGER','rgb(229,53,45)')
SaveHumor('DEPRESSION','DEPRESSION','rgb(200,174,151)')
SaveHumor('DOUCEUR','SWEETNESS','rgb(219,226,235)')
SaveHumor('EXITATION','EXCITEMENT','rgb(255,219,13)')
SaveHumor('FOLIE','MADNESS','rgb(12,49,131)')
SaveHumor('IRRITATION','IRRITATION','rgb(148,176,128)')
SaveHumor('NERVOSITÉ','NERVOUSNESS','rgb(225,142,16)')
SaveHumor('PEUR','FEAR','rgb(112,113,115)')
SaveHumor('RAGE','RAGE','rgb(149,57,125)')
SaveHumor('TRISTESSE','SADNESS','rgb(148,203,173)')

print "Humors created"


def SaveNote(nameFr, nameEn, rgb):
	n = Note.objects.language('fr').create(name=nameFr, color=rgb)
	n.translate('en')
	n.name = nameEn
	n.save()

# Creating notes
SaveNote('ANIMALE','ANIMALIC','rgb(200,174,151)')
SaveNote('CHIMIQUE','CHEMICAL','rgb(219,226,235)')
SaveNote('EPICEE','SPICY','rgb(216,147,71)')
SaveNote('FRUITEE','FRUITY','rgb(203,201,0)')
SaveNote('GRASSE','FATTY','rgb(245,187,211)')
SaveNote('VEGETALE','VEGETATIVE','rgb(148,203,173)')

print "Notes created"


def SaveImage(nameFr, nameEn, path):
	i = Image.objects.language('fr').create(name=nameFr, pathImage=path)
	i.translate('en')
	i.name = nameEn
	i.save()

# Creating common names
SaveImage('POISSON','FISHY','images/Image/poisson.png')
SaveImage('CHIENMOUILLÉ','WETDOG','images/Image/chienMouille.png')
SaveImage('BOUC/CHÈVRE','GOATY','images/Image/boucChevre.png')
SaveImage('SANGLIER','BOARTAINT','images/Image/sanglier.png')
SaveImage('BOUILLONDEPOULET','CHICKENBROAT','images/Image/bouillonDePoulet.png')
SaveImage('FROMAGE','CHEESY','images/Image/fromage.png')
SaveImage('BEURRERANCE','RANCIDBUTTER','images/Image/beurreRance.png')
SaveImage('RAISIN','GRAPEFRUIT','images/Image/raisin.png')
SaveImage('FRUITDELAPASSION','PASSIONFRUIT','images/Image/fruitDeLaPassion.png')
SaveImage('OIGNON','ONION','images/Image/oignon.png')
SaveImage('AIL','GARLIC','images/Image/ail.png')
SaveImage('CHOUX','GABBAGE','images/Image/choux.png')
SaveImage('ASPERGE','ASPARAGUS','images/Image/asperge.png')
SaveImage('MENTHE','MINT','images/Image/menthe.png')
SaveImage('PIMENT','CHILI','images/Image/piment.png')
SaveImage('CUMIN','CUMIN','images/Image/cumin.png')
SaveImage('VINAIGRE','VINEGAR','images/Image/vinaigre.png')
SaveImage('ALCOOL','ALCOHOL','images/Image/alcool.png')
SaveImage('ESSENCE','GASOLINE','images/Image/essence.png')

print "Images created"


def SaveFood(nameFr, nameEn):
	f = Food.objects.language('fr').create(name=nameFr)
	f.translate('en')
	f.name = nameEn
	f.save()

# Creating common names
SaveFood('Brocoli','Broccoli')
SaveFood('Choux','Gabbage')
SaveFood('Choux-fleur','cauliflower')
SaveFood('Asperge','Asparagus')
SaveFood('Poisson','Fish')
SaveFood('Viande Rouge','Red meat')
SaveFood('Fast-food','Fast-food')
SaveFood('Plat épicé','Spicy food')
SaveFood('Alcool','Alcohol')
SaveFood('Antibiotiques','Antibiotics')

print "Food created"


def SaveGiverAndSample(_age,_sex,_smoker,_diet,_deodorant,_email,_testDuration,_activity,_intensity,_feeling,_idFoodList,_idSample,_nameSample) :
	giver = SampleGiver(age=_age,sex=_sex,smoker=_smoker,diet=_diet,deodorant=_deodorant,email=_email,testDuration=_testDuration,activity=_activity,intensity=_intensity,feeling=_feeling)
	giver.save()
	giver.date_registration = None
	for idFood in _idFoodList : giver.foodRecentlyEaten.add(Food.objects.get(id=idFood))
	giver.save()
	Sample(id=_idSample,name=_nameSample,sampleGiver=giver).save()

# Creating samples and giver
SaveGiverAndSample(16,'F',False,'VR',None,'gotheil.salome@gmail.com',None,None,40,56,[],121,'CS1')
SaveGiverAndSample(15,'F',False,'N',None,'annaroselescure@yahoo.fr',None,None,68,52,[4,6],122,'CS2')
SaveGiverAndSample(16,'F',False,'N',False,'c.leblanc@eleves-alsacienne.org',None,None,48,60,[5],123,'CS3')
SaveGiverAndSample(42,'M',False,'N',None,'yrougy@gmail.com',None,None,None,None,[],124,'CS4')
SaveGiverAndSample(53,'M',False,'N',False,'arnaud.IKER@laposte.net',None,None,60,40,[1,4,5,6,8,9],125,'CS5')
SaveGiverAndSample(37,'M',False,'N',None,'jcouffle@yahoo.fr',None,None,None,None,[8],126,'CS6')
SaveGiverAndSample(31,'F',False,'N',None,'emilie.fuchs82@gmail.com',None,None,None,None,[8],127,'CS7')
SaveGiverAndSample(9,'F',False,'N',False,None,None,None,0,100,[7],128,'CS8')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],129,'CS9')
SaveGiverAndSample(34,'F',False,'HP',None,None,None,None,None,None,[1,7,8],130,'CS10')
SaveGiverAndSample(34,'M',False,'N',None,'vincent@matibus.net',None,None,100,0,[3,7],131,'CS11')
SaveGiverAndSample(36,'F',False,'N',True,'aline@montibus.net',None,None,2,98,[3,6,7],132,'CS12')
SaveGiverAndSample(33,'F',True,'N',None,None,None,None,56,42,[],133,'CS13')
SaveGiverAndSample(17,'M',False,'N',None,None,None,None,None,None,[7],134,'CS14')
SaveGiverAndSample(16,'M',False,'N',None,None,None,None,None,None,[7],135,'CS15')
SaveGiverAndSample(16,'M',False,'N',None,'maboujaraude@free.fr',None,None,20,0,[7],136,'CS16')
SaveGiverAndSample(18,'M',False,'HP',False,'alexlelionbox360@hotmail.fr',None,None,60,20,[7],137,'CS17')
SaveGiverAndSample(17,'F',False,'N',False,'0',None,None,20,76,[7],138,'CS18')
SaveGiverAndSample(19,'F',False,'N',None,'ishi.gomes@hotmail.fr',None,None,20,62,[7],139,'CS19')
SaveGiverAndSample(21,'F',False,'N',None,'gomes.milita@eive.fr',None,None,40,60,[7],140,'CS20')
SaveGiverAndSample(20,'F',False,'N',None,'mariagomes24@hotmail.fr',None,None,None,None,[7],141,'CS21')
SaveGiverAndSample(28,'F',False,'N',None,'flo_dt3@hotmail.com',None,None,40,60,[1],142,'CS22')
SaveGiverAndSample(25,'M',False,'N',False,None,None,None,48,52,[6],143,'CS23')
SaveGiverAndSample(24,'F',False,'VR',None,None,None,None,36,54,[7,9],144,'CS24')
SaveGiverAndSample(23,'F',False,'N',None,None,None,None,22,34,[6,7,9],145,'CS25')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],146,'CS26')
SaveGiverAndSample(16,'M',False,'N',None,None,None,None,40,60,[5,6],147,'CS27')
SaveGiverAndSample(26,'F',True,'VR',True,'marie.afane@gmail.com',None,None,64,52,[5,6],148,'CS28')
SaveGiverAndSample(30,'M',False,'N',True,'jerome.combes@gmail.com',None,None,46,56,[5],149,'CS29')
SaveGiverAndSample(28,'F',False,'N',True,'lizzau86@hotmail.com',None,None,86,34,[5],150,'CS30')
SaveGiverAndSample(27,'F',False,'N',True,'saraart@live.it',None,None,20,90,[8],151,'CS31')
SaveGiverAndSample(21,'M',False,'HP',True,'nico.krebs92@gmail.com',None,None,66,20,[7],152,'CS32')
SaveGiverAndSample(23,'M',True,'HP',True,None,None,None,64,60,[7],153,'CS33')
SaveGiverAndSample(34,'F',False,'N',True,'annascllemp@live.fr',None,None,26,52,[],154,'CS34')
SaveGiverAndSample(42,'M',False,'N',False,'cyrsit@hotmail.com',None,None,40,64,[8,9,6],155,'CS35')
SaveGiverAndSample(64,'F',False,'N',False,'moelle.naudet@wanadoo.fr',None,None,78,18,[3],156,'CS36')
SaveGiverAndSample(30,'F',False,'N',True,'libelluledulot@hotmail.com',None,None,50,50,[6],157,'CS37')
SaveGiverAndSample(63,'M',True,'N',True,'mauro.tortac@gmail.com',None,None,82,20,[10],158,'CS38')
SaveGiverAndSample(16,'M',True,'N',True,None,None,None,8,92,[7],159,'CS39')
SaveGiverAndSample(30,'M',False,'VR',False,None,None,None,66,42,[1,8,9],160,'CS40')
SaveGiverAndSample(37,'M',False,'HP',None,'xl.perrin@gmail.com',None,None,60,36,[1,6],161,'CS41')
SaveGiverAndSample(14,'M',False,'HP',None,'julienlucas99@icloud.com',None,None,56,44,[6],162,'CS42')
SaveGiverAndSample(15,'F',False,'HP',None,'hugolinelecoq@gmail.com',None,None,48,52,[5],163,'CS43')
SaveGiverAndSample(39,'M',True,'N',None,'justartigues@gmail.com',None,None,82,40,[6,9],164,'CS44')
SaveGiverAndSample(14,'F',False,'N',None,'miminirad@hotmail.fr',None,None,48,20,[4,10],165,'CS45')
SaveGiverAndSample(15,'F',False,'VR',None,'n.dutitre@orange.fr',None,None,None,None,[1],166,'CS46')
SaveGiverAndSample(9,'M',False,'N',False,None,None,None,None,None,[],167,'CS47')
SaveGiverAndSample(10,'M',False,'N',None,None,None,None,None,None,[7],168,'CS48')
SaveGiverAndSample(39,'M',False,'HP',False,'7clement@gmail.com',None,None,66,None,[5],169,'CS49')
SaveGiverAndSample(23,'M',False,'N',True,'since.GPH@gmail.com',None,None,8,52,[6,8,7,9],170,'CS50')
SaveGiverAndSample(None,'M',True,'HP',None,'fil.richere@orange.fr',None,None,68,40,[7],171,'CS51')
SaveGiverAndSample(32,'F',False,'N',True,'amieseb@orange.fr',None,None,40,80,[6,7],172,'CS52')
SaveGiverAndSample(34,'M',False,'N',False,'fan.rapin@free.fr',None,None,40,64,[6,9],173,'CS53')
SaveGiverAndSample(34,'M',False,'N',True,'ammieseb@orange.fr',None,None,36,72,[5,6,7,8,9],174,'CS54')
SaveGiverAndSample(33,'F',False,'N',True,'alex.rapin@sfr.fr',None,None,40,58,[6,7],175,'CS55')
SaveGiverAndSample(32,'F',False,'N',True,'olive.tricoire@orange.fr',None,None,40,60,[9],176,'CS56')
SaveGiverAndSample(16,'M',True,'N',None,'theophile.homebe@laposte.net',None,None,None,None,[7,6],177,'CS57')
SaveGiverAndSample(22,'M',False,'HP',False,'Ihab',None,None,76,42,[6,7,8],101,'PB1')
SaveGiverAndSample(22,'F',False,'VR',False,'Aakriti',None,None,22,42,[8,9],102,'PB2')
SaveGiverAndSample(24,'M',True,'HP',False,'Antonio',None,None,80,100,[6,7,8,9],103,'PB3')
SaveGiverAndSample(20,'M',False,'N',None,'PL',None,None,44,20,[],104,'PB4')
SaveGiverAndSample(30,'M',False,'VR',False,'Ian',None,None,None,None,[1,8,9],105,'PB5')
SaveGiverAndSample(23,'F',False,'N',None,'Irene',None,None,42,40,[],106,'PB6')
SaveGiverAndSample(23,'F',False,'HP',False,'ULA',None,None,60,22,[6,7,8,9],107,'PB7')
SaveGiverAndSample(23,'F',False,'N',True,'CRIS',None,None,38,62,[5],108,'PB8')
SaveGiverAndSample(22,'M',False,'N',False,'HENRY',None,None,44,52,[9],109,'PB9')
SaveGiverAndSample(22,'F',False,'N',False,None,None,None,28,40,[6,9],28,'S28')
SaveGiverAndSample(23,'F',False,'N',True,None,None,None,48,42,[],30,'S30')
SaveGiverAndSample(26,'F',False,'N',False,None,None,None,None,None,[6,9],32,'S32')
SaveGiverAndSample(29,'M',False,'N',False,'alexey.zaytsev@gmail.com',None,None,20,80,[],36,'S36')
SaveGiverAndSample(25,'F',True,'HP',False,None,None,None,60,72,[9],38,'S38')
SaveGiverAndSample(23,'F',False,'N',False,None,None,None,60,40,[],40,'S40')
SaveGiverAndSample(28,'M',False,'N',False,'raphael.goujet@gmail.com',None,None,40,20,[4,5,9],41,'S41')
SaveGiverAndSample(24,'F',True,'N',False,'marion.segall@live.fr',None,None,48,40,[5,9],44,'S44')
SaveGiverAndSample(23,'M',False,'HP',False,'Guillaume.terradot@symbiose6.fr',None,None,40,80,[6,9],45,'S45')
SaveGiverAndSample(23,'F',False,'N',False,'cristina',None,None,24,78,[5,9],46,'S46')
SaveGiverAndSample(27,'F',True,'N',False,None,None,None,58,20,[4,5,9],47,'S47')
SaveGiverAndSample(30,'M',False,None,None,None,None,None,None,None,[1,4,5,6,9],48,'S48')
SaveGiverAndSample(24,'F',False,'N',None,None,None,None,54,40,[5,9],53,'S53')
SaveGiverAndSample(21,'M',False,'N',False,'Q.MARCOU@HOTMAIL.FR',None,None,18,82,[9],63,'S63')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],71,'S71')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],178,'CS58')
SaveGiverAndSample(29,'H',None,None,False,None,None,None,None,None,[],179,'CS59')
SaveGiverAndSample(21,'F',None,None,True,None,None,None,None,None,[],180,'CS60')
SaveGiverAndSample(36,'M',None,None,False,None,None,None,None,None,[],181,'CS61')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],182,'CS62')
SaveGiverAndSample(11,'M',None,None,False,None,None,None,None,None,[],183,'CS63')
SaveGiverAndSample(53,'M',None,None,False,None,None,None,None,None,[],184,'CS64')
SaveGiverAndSample(19,'M',None,None,True,None,None,None,None,None,[],185,'CS65')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],186,'CS66')
SaveGiverAndSample(22,'M',None,None,True,None,None,None,None,None,[],187,'CS67')
SaveGiverAndSample(22,'F',None,None,True,None,None,None,None,None,[],188,'CS68')
SaveGiverAndSample(65,'F',None,None,True,None,None,None,None,None,[],189,'CS69')
SaveGiverAndSample(20,'M',None,None,True,None,None,None,None,None,[],190,'CS70')
SaveGiverAndSample(19,'F',None,None,False,None,None,None,None,None,[],191,'CS71')
SaveGiverAndSample(18,'M',None,None,True,None,None,None,None,None,[],192,'CS72')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],193,'CS73')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],194,'CS74')
SaveGiverAndSample(22,'M',None,None,False,None,None,None,None,None,[],195,'CS75')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],196,'CS76')
SaveGiverAndSample(27,'F',None,None,True,None,None,None,None,None,[],197,'CS77')
SaveGiverAndSample(20,'M',None,None,True,None,None,None,None,None,[],198,'CS78')
SaveGiverAndSample(27,'M',None,None,True,None,None,None,None,None,[],199,'CS79')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],200,'CS80')
SaveGiverAndSample(25,'M',None,None,True,None,None,None,None,None,[],201,'CS81')
SaveGiverAndSample(20,'M',None,None,True,None,None,None,None,None,[],202,'CS82')
SaveGiverAndSample(22,'M',None,None,False,None,None,None,None,None,[],203,'68A')
SaveGiverAndSample(23,'F',None,None,False,None,None,None,None,None,[],204,'77A')
SaveGiverAndSample(24,'F',None,None,False,None,None,None,None,None,[],205,'64A')
SaveGiverAndSample(38,'M',None,None,False,None,None,None,None,None,[],206,'9A')
SaveGiverAndSample(23,'F',None,None,False,None,None,None,None,None,[],207,'65A')
SaveGiverAndSample(24,'M',None,None,False,None,None,None,None,None,[],208,'4A')
SaveGiverAndSample(22,'M',None,None,False,None,None,None,None,None,[],209,'71A')
SaveGiverAndSample(25,'M',None,None,False,None,None,None,None,None,[],210,'66A')
SaveGiverAndSample(None,None,None,None,False,None,None,None,None,None,[],211,'A39')
SaveGiverAndSample(21,'F',None,None,False,None,None,None,None,None,[],212,'A40')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],213,'A41')
SaveGiverAndSample(22,'M',None,None,False,None,None,None,None,None,[],214,'A42')
SaveGiverAndSample(22,'M',None,None,False,None,None,None,None,None,[],215,'A43')
SaveGiverAndSample(23,'F',None,None,False,None,None,None,None,None,[],216,'A44')
SaveGiverAndSample(19,'F',None,None,False,None,None,None,None,None,[],217,'A45')
SaveGiverAndSample(22,'M',None,None,False,None,None,None,None,None,[],218,'A46')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],219,'A47')
SaveGiverAndSample(20,'M',None,None,False,None,None,None,None,None,[],220,'A48')
SaveGiverAndSample(24,'M',None,None,False,None,None,None,None,None,[],221,'A49')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],222,'A50')
SaveGiverAndSample(22,'F',None,None,False,None,None,None,None,None,[],223,'A51')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],224,'A52')
SaveGiverAndSample(22,'M',None,None,False,None,None,None,None,None,[],225,'A53')
SaveGiverAndSample(19,'F',None,None,False,None,None,None,None,None,[],226,'A54')
SaveGiverAndSample(20,'M',None,None,True,None,None,None,None,None,[],227,'A55')
SaveGiverAndSample(None,None,None,None,None,None,None,None,None,None,[],228,'A56')
SaveGiverAndSample(19,'F',None,None,True,None,None,None,None,None,[],229,'A57')

print "Samples and Giver created"


def SaveSmeller(_id,_sex,_age,_date_registration) :
	smeller = Smeller(id=_id,sex=_sex,age=_age)
	smeller.save()
	smeller.date_registration = _date_registration
	smeller.save()

# Creating Smeller
SaveSmeller(1,None,None,None)
SaveSmeller(2,None,None,None)
SaveSmeller(3,None,None,None)
SaveSmeller(4,None,None,None)
SaveSmeller(5,None,None,None)
SaveSmeller(6,None,None,None)
SaveSmeller(7,None,None,None)
SaveSmeller(8,None,None,None)
SaveSmeller(9,None,None,None)
SaveSmeller(10,None,None,None)
SaveSmeller(11,None,None,None)
SaveSmeller(12,None,None,None)
SaveSmeller(13,None,None,None)
SaveSmeller(14,None,None,None)
SaveSmeller(15,None,None,None)
SaveSmeller(16,None,None,None)
SaveSmeller(17,None,None,None)
SaveSmeller(18,None,None,None)
SaveSmeller(19,None,None,None)
SaveSmeller(20,None,None,None)
SaveSmeller(21,None,None,None)
SaveSmeller(22,None,None,None)
SaveSmeller(23,None,None,None)
SaveSmeller(24,None,None,None)
SaveSmeller(25,None,None,None)
SaveSmeller(26,None,None,None)
SaveSmeller(27,None,None,None)
SaveSmeller(28,None,None,None)
SaveSmeller(29,None,None,None)
SaveSmeller(30,None,None,None)
SaveSmeller(34,'M',29,'2014-10-04 12:58:45.431538')
SaveSmeller(35,'F',21,'2014-10-04 12:58:52.521385')
SaveSmeller(36,'M',40,'2014-10-04 12:59:24.073528')
SaveSmeller(37,'M',22,'2014-10-04 13:23:43.867382')
SaveSmeller(38,'M',53,'2014-10-04 14:02:12.311307')
SaveSmeller(39,'F',22,'2014-10-04 14:23:37.035255')
SaveSmeller(40,'M',22,'2014-10-04 14:23:38.670368')
SaveSmeller(41,'M',22,'2014-10-04 14:27:44.731666')
SaveSmeller(42,'M',28,'2014-10-04 14:42:21.649796')
SaveSmeller(43,'F',27,'2014-10-04 14:42:58.231719')
SaveSmeller(44,'M',22,'2014-10-04 14:54:09.758449')
SaveSmeller(45,'F',18,'2014-10-04 15:10:36.830624')
SaveSmeller(46,'F',20,'2014-10-04 15:16:27.081263')
SaveSmeller(47,'M',20,'2014-10-04 15:17:44.840366')
SaveSmeller(48,'F',19,'2014-10-04 15:18:09.428699')
SaveSmeller(49,'M',36,'2014-10-04 15:52:17.718803')
SaveSmeller(50,'F',5,'2014-10-04 15:52:45.523027')
SaveSmeller(53,'M',30,'2014-10-08 14:30:25.213857')
SaveSmeller(54,'M',22,'2014-10-08 14:36:08.817170')
SaveSmeller(55,'M',23,'2014-10-08 14:38:29.772989')
SaveSmeller(56,'F',18,'2014-10-08 15:28:21.699569')
SaveSmeller(57,'M',30,'2014-10-09 10:38:10.659232')
SaveSmeller(58,'F',23,'2014-10-09 10:40:07.329143')
SaveSmeller(59,'M',20,'2014-10-09 10:52:37.955167')
SaveSmeller(60,'F',23,'2014-10-09 11:02:19.054941')
SaveSmeller(61,'M',24,'2014-10-09 11:11:13.674938')
SaveSmeller(62,'F',18,'2014-10-09 12:33:03.501228')
SaveSmeller(63,'M',21,'2014-10-09 12:33:42.876037')
SaveSmeller(64,'F',22,'2014-10-11 15:30:04.760336')
SaveSmeller(65,'F',20,'2014-10-11 15:40:38.836204')
SaveSmeller(68,'M',32,'2014-10-13 09:37:36.774410')
SaveSmeller(74,'M',30,'2014-10-13 16:04:48.175558')
SaveSmeller(75,'M',20,'2014-10-13 16:05:00.899751')
SaveSmeller(76,'F',22,'2014-10-13 16:13:04.652376')
SaveSmeller(77,'M',24,'2014-10-13 16:14:05.200317')
SaveSmeller(78,'F',23,'2014-10-13 16:21:12.931529')
SaveSmeller(83,'M',20,'2014-10-14 16:59:47.938956')
SaveSmeller(84,'F',22,'2014-10-14 16:59:49.749784')
SaveSmeller(87,'F',24,'2014-10-14 17:07:35.235494')
SaveSmeller(88,'F',23,'2014-10-14 17:07:40.464378')
SaveSmeller(89,'F',21,'2014-10-14 17:07:42.967134')
SaveSmeller(90,'F',23,'2014-10-14 17:18:36.326496')
SaveSmeller(91,'M',32,'2014-10-14 17:21:55.538601')
SaveSmeller(92,'F',18,'2014-10-14 17:33:27.508210')
SaveSmeller(93,'M',22,'2014-10-16 13:07:41.323235')
SaveSmeller(94,'M',22,'2014-10-16 13:14:43.457471')
SaveSmeller(95,'M',22,'2014-10-16 13:35:52.677034')
SaveSmeller(113,'M',22,'2014-10-19 19:04:20.142065')

print "Smeller created"


#Creating Guess
Guess(id=1,smeller_id=1,sample_id=30,intensity=80,humor_id=9,note_id=None,image_id=None,feeling=80,name="").save()
Guess(id=2,smeller_id=2,sample_id=32,intensity=0,humor_id=None,note_id=6,image_id=None,feeling=80,name="").save()
Guess(id=3,smeller_id=3,sample_id=41,intensity=60,humor_id=6,note_id=2,image_id=18,feeling=20,name="").save()
Guess(id=4,smeller_id=4,sample_id=44,intensity=60,humor_id=6,note_id=4,image_id=None,feeling=20,name="").save()
Guess(id=5,smeller_id=5,sample_id=44,intensity=80,humor_id=9,note_id=4,image_id=None,feeling=0,name="").save()
Guess(id=6,smeller_id=6,sample_id=45,intensity=60,humor_id=6,note_id=4,image_id=None,feeling=0,name="").save()
Guess(id=7,smeller_id=7,sample_id=32,intensity=20,humor_id=None,note_id=None,image_id=None,feeling=40,name="").save()
Guess(id=8,smeller_id=8,sample_id=45,intensity=60,humor_id=None,note_id=4,image_id=9,feeling=20,name="").save()
Guess(id=9,smeller_id=9,sample_id=48,intensity=40,humor_id=6,note_id=None,image_id=9,feeling=20,name="").save()
Guess(id=10,smeller_id=10,sample_id=71,intensity=40,humor_id=13,note_id=2,image_id=None,feeling=60,name="").save()
Guess(id=11,smeller_id=11,sample_id=121,intensity=40,humor_id=2,note_id=2,image_id=19,feeling=80,name="").save()
Guess(id=12,smeller_id=12,sample_id=124,intensity=60,humor_id=None,note_id=None,image_id=None,feeling=60,name="").save()
Guess(id=13,smeller_id=13,sample_id=127,intensity=80,humor_id=4,note_id=2,image_id=None,feeling=80,name="").save()
Guess(id=14,smeller_id=14,sample_id=130,intensity=40,humor_id=6,note_id=2,image_id=19,feeling=20,name="").save()
Guess(id=15,smeller_id=15,sample_id=125,intensity=40,humor_id=13,note_id=5,image_id=None,feeling=60,name="").save()
Guess(id=16,smeller_id=16,sample_id=123,intensity=20,humor_id=None,note_id=2,image_id=19,feeling=60,name="").save()
Guess(id=17,smeller_id=17,sample_id=136,intensity=100,humor_id=2,note_id=5,image_id=7,feeling=80,name="").save()
Guess(id=18,smeller_id=18,sample_id=141,intensity=40,humor_id=None,note_id=2,image_id=None,feeling=60,name="").save()
Guess(id=19,smeller_id=19,sample_id=144,intensity=40,humor_id=1,note_id=4,image_id=8,feeling=40,name="").save()
Guess(id=20,smeller_id=20,sample_id=144,intensity=80,humor_id=9,note_id=5,image_id=16,feeling=80,name="").save()
Guess(id=21,smeller_id=21,sample_id=102,intensity=80,humor_id=6,note_id=5,image_id=None,feeling=40,name="").save()
Guess(id=22,smeller_id=22,sample_id=101,intensity=60,humor_id=9,note_id=1,image_id=4,feeling=80,name="").save()
Guess(id=23,smeller_id=23,sample_id=102,intensity=100,humor_id=4,note_id=1,image_id=2,feeling=60,name="").save()
Guess(id=24,smeller_id=24,sample_id=103,intensity=100,humor_id=1,note_id=4,image_id=None,feeling=0,name="").save()
Guess(id=25,smeller_id=25,sample_id=103,intensity=80,humor_id=6,note_id=5,image_id=None,feeling=20,name="").save()
Guess(id=26,smeller_id=26,sample_id=104,intensity=100,humor_id=1,note_id=1,image_id=3,feeling=100,name="").save()
Guess(id=27,smeller_id=27,sample_id=104,intensity=100,humor_id=4,note_id=1,image_id=4,feeling=100,name="").save()
Guess(id=28,smeller_id=28,sample_id=105,intensity=40,humor_id=None,note_id=None,image_id=None,feeling=60,name="").save()
Guess(id=29,smeller_id=29,sample_id=107,intensity=80,humor_id=6,note_id=2,image_id=None,feeling=20,name="").save()
Guess(id=30,smeller_id=30,sample_id=108,intensity=40,humor_id=None,note_id=5,image_id=None,feeling=0,name="").save()
Guess(id=40,smeller_id=34,sample_id=125,intensity=16,humor_id=1,note_id=2,image_id=18,feeling=38,name="Tuyau").save()
Guess(id=41,smeller_id=35,sample_id=28,intensity=5,humor_id=6,note_id=6,image_id=8,feeling=49,name="Le néant").save()
Guess(id=42,smeller_id=36,sample_id=41,intensity=79,humor_id=1,note_id=1,image_id=2,feeling=100,name="fourure").save()
Guess(id=43,smeller_id=35,sample_id=36,intensity=0,humor_id=13,note_id=6,image_id=8,feeling=49,name="Rien").save()
Guess(id=44,smeller_id=36,sample_id=169,intensity=70,humor_id=7,note_id=3,image_id=15,feeling=0,name="poivre frais").save()
Guess(id=45,smeller_id=34,sample_id=139,intensity=84,humor_id=10,note_id=1,image_id=3,feeling=57,name="Voiture").save()
Guess(id=46,smeller_id=35,sample_id=153,intensity=29,humor_id=3,note_id=4,image_id=9,feeling=13,name="Fruit fruit").save()
Guess(id=47,smeller_id=34,sample_id=128,intensity=56,humor_id=2,note_id=3,image_id=16,feeling=33,name="mangrove").save()
Guess(id=48,smeller_id=36,sample_id=32,intensity=11,humor_id=7,note_id=1,image_id=9,feeling=0,name="amour").save()
Guess(id=49,smeller_id=35,sample_id=158,intensity=0,humor_id=13,note_id=6,image_id=8,feeling=100,name="Rien").save()
Guess(id=50,smeller_id=35,sample_id=144,intensity=78,humor_id=10,note_id=2,image_id=16,feeling=62,name="Champignon de piscine").save()
Guess(id=51,smeller_id=34,sample_id=147,intensity=78,humor_id=7,note_id=6,image_id=15,feeling=24,name="Camphre").save()
Guess(id=52,smeller_id=35,sample_id=149,intensity=0,humor_id=1,note_id=6,image_id=8,feeling=100,name="Rien").save()
Guess(id=53,smeller_id=34,sample_id=171,intensity=90,humor_id=11,note_id=5,image_id=12,feeling=86,name="Effort").save()
Guess(id=55,smeller_id=34,sample_id=170,intensity=74,humor_id=10,note_id=3,image_id=17,feeling=59,name="Bar").save()
Guess(id=56,smeller_id=37,sample_id=44,intensity=90,humor_id=3,note_id=4,image_id=9,feeling=0,name="Mandarinne").save()
Guess(id=57,smeller_id=37,sample_id=135,intensity=18,humor_id=6,note_id=1,image_id=19,feeling=17,name="Sueur froide").save()
Guess(id=58,smeller_id=37,sample_id=174,intensity=0,humor_id=6,note_id=2,image_id=8,feeling=24,name="odeur trés neutre").save()
Guess(id=59,smeller_id=37,sample_id=103,intensity=71,humor_id=7,note_id=3,image_id=15,feeling=14,name="good peper ! :)").save()
Guess(id=60,smeller_id=37,sample_id=46,intensity=17,humor_id=1,note_id=4,image_id=8,feeling=24,name="").save()
Guess(id=62,smeller_id=38,sample_id=137,intensity=19,humor_id=6,note_id=6,image_id=8,feeling=0,name="fade").save()
Guess(id=64,smeller_id=39,sample_id=123,intensity=10,humor_id=6,note_id=2,image_id=14,feeling=30,name="").save()
Guess(id=65,smeller_id=40,sample_id=38,intensity=0,humor_id=1,note_id=1,image_id=5,feeling=100,name="").save()
Guess(id=66,smeller_id=40,sample_id=63,intensity=50,humor_id=None,note_id=None,image_id=None,feeling=0,name="").save()
Guess(id=67,smeller_id=39,sample_id=173,intensity=97,humor_id=9,note_id=1,image_id=3,feeling=100,name="").save()
Guess(id=68,smeller_id=41,sample_id=48,intensity=57,humor_id=9,note_id=4,image_id=6,feeling=49,name="test").save()
Guess(id=69,smeller_id=41,sample_id=142,intensity=100,humor_id=13,note_id=2,image_id=18,feeling=52,name="hopital").save()
Guess(id=70,smeller_id=39,sample_id=131,intensity=72,humor_id=2,note_id=2,image_id=17,feeling=53,name="").save()
Guess(id=71,smeller_id=41,sample_id=151,intensity=24,humor_id=6,note_id=1,image_id=5,feeling=55,name="").save()
Guess(id=72,smeller_id=39,sample_id=144,intensity=40,humor_id=2,note_id=2,image_id=17,feeling=63,name="").save()
Guess(id=73,smeller_id=39,sample_id=125,intensity=70,humor_id=6,note_id=2,image_id=17,feeling=77,name="").save()
Guess(id=74,smeller_id=41,sample_id=138,intensity=100,humor_id=11,note_id=2,image_id=7,feeling=100,name="").save()
Guess(id=75,smeller_id=41,sample_id=44,intensity=87,humor_id=3,note_id=4,image_id=9,feeling=0,name="").save()
Guess(id=76,smeller_id=39,sample_id=38,intensity=73,humor_id=3,note_id=3,image_id=9,feeling=21,name="").save()
Guess(id=78,smeller_id=42,sample_id=139,intensity=9,humor_id=13,note_id=2,image_id=18,feeling=95,name="HOPITAL").save()
Guess(id=79,smeller_id=43,sample_id=45,intensity=81,humor_id=1,note_id=6,image_id=19,feeling=37,name="déodorant").save()
Guess(id=80,smeller_id=42,sample_id=150,intensity=0,humor_id=6,note_id=2,image_id=1,feeling=73,name="inodore").save()
Guess(id=81,smeller_id=43,sample_id=32,intensity=67,humor_id=3,note_id=4,image_id=9,feeling=23,name="orange").save()
Guess(id=82,smeller_id=42,sample_id=156,intensity=0,humor_id=6,note_id=3,image_id=17,feeling=80,name="doux").save()
Guess(id=83,smeller_id=43,sample_id=132,intensity=73,humor_id=3,note_id=2,image_id=18,feeling=47,name="peinture").save()
Guess(id=84,smeller_id=42,sample_id=127,intensity=80,humor_id=6,note_id=4,image_id=9,feeling=21,name="deodorant").save()
Guess(id=85,smeller_id=43,sample_id=105,intensity=68,humor_id=8,note_id=2,image_id=18,feeling=44,name="plastique").save()
Guess(id=86,smeller_id=42,sample_id=158,intensity=11,humor_id=6,note_id=6,image_id=8,feeling=71,name="végétal").save()
Guess(id=87,smeller_id=43,sample_id=161,intensity=50,humor_id=10,note_id=1,image_id=3,feeling=70,name="transpi").save()
Guess(id=88,smeller_id=42,sample_id=109,intensity=82,humor_id=9,note_id=3,image_id=15,feeling=54,name="chimique").save()
Guess(id=89,smeller_id=44,sample_id=134,intensity=41,humor_id=9,note_id=2,image_id=4,feeling=54,name="").save()
Guess(id=90,smeller_id=43,sample_id=164,intensity=50,humor_id=2,note_id=1,image_id=2,feeling=59,name="...").save()
Guess(id=91,smeller_id=44,sample_id=129,intensity=37,humor_id=6,note_id=5,image_id=7,feeling=14,name="").save()
Guess(id=92,smeller_id=44,sample_id=150,intensity=0,humor_id=5,note_id=2,image_id=19,feeling=27,name="pas vraiment d'odeur").save()
Guess(id=93,smeller_id=44,sample_id=101,intensity=80,humor_id=2,note_id=3,image_id=16,feeling=76,name="").save()
Guess(id=94,smeller_id=44,sample_id=157,intensity=0,humor_id=3,note_id=6,image_id=9,feeling=8,name="odeur trés faible (mais bonne ! )").save()
Guess(id=95,smeller_id=44,sample_id=133,intensity=57,humor_id=3,note_id=4,image_id=9,feeling=20,name="").save()
Guess(id=96,smeller_id=45,sample_id=106,intensity=80,humor_id=10,note_id=2,image_id=5,feeling=71,name="smell like a bad deodorant").save()
Guess(id=97,smeller_id=45,sample_id=71,intensity=50,humor_id=9,note_id=6,image_id=18,feeling=20,name="").save()
Guess(id=98,smeller_id=46,sample_id=53,intensity=82,humor_id=10,note_id=5,image_id=2,feeling=100,name="diaki").save()
Guess(id=99,smeller_id=47,sample_id=126,intensity=77,humor_id=10,note_id=2,image_id=18,feeling=50,name="feutre de tableau blanc").save()
Guess(id=100,smeller_id=48,sample_id=150,intensity=0,humor_id=6,note_id=5,image_id=15,feeling=76,name="inodore").save()
Guess(id=102,smeller_id=46,sample_id=152,intensity=83,humor_id=10,note_id=2,image_id=11,feeling=100,name="tabac froid").save()
Guess(id=103,smeller_id=48,sample_id=44,intensity=67,humor_id=9,note_id=3,image_id=15,feeling=100,name="piment").save()
Guess(id=104,smeller_id=47,sample_id=163,intensity=7,humor_id=7,note_id=6,image_id=12,feeling=47,name="sciure").save()
Guess(id=105,smeller_id=47,sample_id=167,intensity=0,humor_id=2,note_id=3,image_id=8,feeling=48,name="poivré").save()
Guess(id=106,smeller_id=47,sample_id=158,intensity=0,humor_id=3,note_id=4,image_id=9,feeling=49,name="inodore").save()
Guess(id=107,smeller_id=48,sample_id=46,intensity=63,humor_id=5,note_id=1,image_id=4,feeling=100,name="vomi").save()
Guess(id=108,smeller_id=47,sample_id=173,intensity=50,humor_id=9,note_id=1,image_id=16,feeling=75,name="transpiration").save()
Guess(id=109,smeller_id=46,sample_id=175,intensity=61,humor_id=13,note_id=2,image_id=19,feeling=98,name="enfant turbulant").save()
Guess(id=110,smeller_id=48,sample_id=102,intensity=100,humor_id=6,note_id=4,image_id=8,feeling=42,name="grappe").save()
Guess(id=111,smeller_id=46,sample_id=143,intensity=21,humor_id=8,note_id=2,image_id=12,feeling=77,name="DEO NARTA").save()
Guess(id=112,smeller_id=45,sample_id=140,intensity=24,humor_id=6,note_id=2,image_id=7,feeling=23,name="colle").save()
Guess(id=113,smeller_id=45,sample_id=28,intensity=4,humor_id=3,note_id=6,image_id=19,feeling=27,name="houx").save()
Guess(id=114,smeller_id=48,sample_id=155,intensity=0,humor_id=11,note_id=5,image_id=1,feeling=100,name="Odeur de rien").save()
Guess(id=116,smeller_id=45,sample_id=174,intensity=0,humor_id=13,note_id=5,image_id=7,feeling=78,name="distante").save()
Guess(id=117,smeller_id=45,sample_id=132,intensity=36,humor_id=9,note_id=2,image_id=7,feeling=27,name="colle").save()
Guess(id=118,smeller_id=48,sample_id=152,intensity=0,humor_id=13,note_id=6,image_id=19,feeling=65,name="Odeur de rien").save()
Guess(id=119,smeller_id=49,sample_id=146,intensity=90,humor_id=10,note_id=2,image_id=17,feeling=95,name="").save()
Guess(id=120,smeller_id=50,sample_id=155,intensity=16,humor_id=3,note_id=3,image_id=1,feeling=86,name="").save()
Guess(id=121,smeller_id=49,sample_id=151,intensity=2,humor_id=3,note_id=4,image_id=16,feeling=11,name="femme").save()
Guess(id=122,smeller_id=50,sample_id=128,intensity=2,humor_id=3,note_id=1,image_id=5,feeling=36,name="").save()
Guess(id=127,smeller_id=53,sample_id=107,intensity=39,humor_id=10,note_id=2,image_id=16,feeling=53,name="Baby Powder").save()
Guess(id=128,smeller_id=54,sample_id=171,intensity=7,humor_id=13,note_id=2,image_id=8,feeling=27,name="Pas d'odeur").save()
Guess(id=129,smeller_id=53,sample_id=44,intensity=6,humor_id=11,note_id=6,image_id=14,feeling=41,name="no smell").save()
Guess(id=130,smeller_id=54,sample_id=168,intensity=12,humor_id=10,note_id=2,image_id=19,feeling=16,name="almost no smell").save()
Guess(id=131,smeller_id=55,sample_id=45,intensity=0,humor_id=13,note_id=3,image_id=7,feeling=51,name="néant").save()
Guess(id=132,smeller_id=53,sample_id=167,intensity=31,humor_id=11,note_id=6,image_id=14,feeling=45,name="doesn't really smell").save()
Guess(id=133,smeller_id=54,sample_id=153,intensity=8,humor_id=6,note_id=4,image_id=8,feeling=0,name="").save()
Guess(id=134,smeller_id=54,sample_id=160,intensity=13,humor_id=7,note_id=6,image_id=13,feeling=22,name="").save()
Guess(id=135,smeller_id=53,sample_id=109,intensity=63,humor_id=2,note_id=1,image_id=2,feeling=85,name="sweaty animal").save()
Guess(id=136,smeller_id=54,sample_id=152,intensity=37,humor_id=9,note_id=1,image_id=4,feeling=28,name="").save()
Guess(id=137,smeller_id=53,sample_id=103,intensity=53,humor_id=10,note_id=2,image_id=19,feeling=75,name="").save()
Guess(id=138,smeller_id=54,sample_id=139,intensity=47,humor_id=9,note_id=1,image_id=3,feeling=16,name="").save()
Guess(id=139,smeller_id=53,sample_id=159,intensity=98,humor_id=4,note_id=1,image_id=4,feeling=96,name="").save()
Guess(id=140,smeller_id=55,sample_id=149,intensity=0,humor_id=11,note_id=5,image_id=13,feeling=0,name="pas d'odeur").save()
Guess(id=141,smeller_id=55,sample_id=128,intensity=67,humor_id=10,note_id=2,image_id=19,feeling=69,name="plastique d'un tube falcon 50 mL,pas d'odeur à part cette odeur de plastique et aucune émotion, salut c'est alex").save()
Guess(id=142,smeller_id=55,sample_id=167,intensity=0,humor_id=8,note_id=4,image_id=6,feeling=0,name="aucune odeur").save()
Guess(id=143,smeller_id=55,sample_id=133,intensity=100,humor_id=10,note_id=2,image_id=19,feeling=89,name="falcon 50 mL").save()
Guess(id=144,smeller_id=55,sample_id=176,intensity=50,humor_id=12,note_id=3,image_id=13,feeling=0,name="pas d'odeur").save()
Guess(id=145,smeller_id=56,sample_id=36,intensity=0,humor_id=6,note_id=4,image_id=8,feeling=54,name="rien").save()
Guess(id=146,smeller_id=56,sample_id=144,intensity=74,humor_id=9,note_id=2,image_id=17,feeling=100,name="creme réparatrice").save()
Guess(id=147,smeller_id=56,sample_id=175,intensity=24,humor_id=10,note_id=1,image_id=2,feeling=100,name="sueur d'homme").save()
Guess(id=148,smeller_id=56,sample_id=130,intensity=87,humor_id=7,note_id=2,image_id=18,feeling=100,name="désinfectant").save()
Guess(id=149,smeller_id=56,sample_id=160,intensity=0,humor_id=2,note_id=1,image_id=2,feeling=100,name="rien").save()
Guess(id=150,smeller_id=56,sample_id=71,intensity=34,humor_id=1,note_id=6,image_id=13,feeling=100,name="rien").save()
Guess(id=151,smeller_id=57,sample_id=176,intensity=90,humor_id=12,note_id=5,image_id=2,feeling=95,name="stay far away from me").save()
Guess(id=152,smeller_id=58,sample_id=138,intensity=11,humor_id=6,note_id=2,image_id=8,feeling=46,name="light odor").save()
Guess(id=153,smeller_id=57,sample_id=123,intensity=52,humor_id=9,note_id=2,image_id=10,feeling=87,name="did you shower today?").save()
Guess(id=154,smeller_id=58,sample_id=121,intensity=61,humor_id=3,note_id=4,image_id=15,feeling=31,name="rien").save()
Guess(id=155,smeller_id=57,sample_id=142,intensity=17,humor_id=7,note_id=4,image_id=17,feeling=51,name="doesnt smell much").save()
Guess(id=156,smeller_id=57,sample_id=103,intensity=47,humor_id=1,note_id=6,image_id=16,feeling=57,name="baby powder").save()
Guess(id=157,smeller_id=58,sample_id=175,intensity=84,humor_id=10,note_id=3,image_id=15,feeling=81,name="").save()
Guess(id=158,smeller_id=57,sample_id=36,intensity=96,humor_id=3,note_id=6,image_id=14,feeling=3,name="Minty Fresh").save()
Guess(id=159,smeller_id=58,sample_id=170,intensity=50,humor_id=1,note_id=4,image_id=9,feeling=16,name="verger").save()
Guess(id=160,smeller_id=58,sample_id=130,intensity=63,humor_id=6,note_id=6,image_id=8,feeling=35,name="smell").save()
Guess(id=161,smeller_id=57,sample_id=175,intensity=93,humor_id=13,note_id=5,image_id=3,feeling=99,name="stay far away from me").save()
Guess(id=162,smeller_id=58,sample_id=167,intensity=7,humor_id=5,note_id=5,image_id=14,feeling=23,name="rain").save()
Guess(id=163,smeller_id=59,sample_id=163,intensity=65,humor_id=9,note_id=1,image_id=3,feeling=100,name="vestiaire").save()
Guess(id=164,smeller_id=59,sample_id=167,intensity=13,humor_id=10,note_id=5,image_id=7,feeling=57,name="").save()
Guess(id=165,smeller_id=59,sample_id=103,intensity=83,humor_id=10,note_id=2,image_id=17,feeling=100,name="").save()
Guess(id=166,smeller_id=59,sample_id=162,intensity=30,humor_id=9,note_id=1,image_id=2,feeling=58,name="").save()
Guess(id=167,smeller_id=59,sample_id=145,intensity=80,humor_id=9,note_id=2,image_id=17,feeling=100,name="").save()
Guess(id=168,smeller_id=59,sample_id=127,intensity=75,humor_id=9,note_id=1,image_id=4,feeling=100,name="").save()
Guess(id=169,smeller_id=60,sample_id=123,intensity=15,humor_id=9,note_id=4,image_id=9,feeling=47,name="morning wake up").save()
Guess(id=170,smeller_id=60,sample_id=162,intensity=0,humor_id=13,note_id=3,image_id=19,feeling=48,name="just passing by").save()
Guess(id=171,smeller_id=60,sample_id=45,intensity=85,humor_id=7,note_id=4,image_id=9,feeling=0,name="orangine").save()
Guess(id=172,smeller_id=60,sample_id=148,intensity=0,humor_id=11,note_id=5,image_id=7,feeling=67,name="monday morning").save()
Guess(id=173,smeller_id=60,sample_id=158,intensity=0,humor_id=6,note_id=5,image_id=2,feeling=58,name="where are you?").save()
Guess(id=174,smeller_id=60,sample_id=161,intensity=6,humor_id=11,note_id=5,image_id=12,feeling=50,name="calm down").save()
Guess(id=175,smeller_id=61,sample_id=129,intensity=0,humor_id=6,note_id=2,image_id=18,feeling=46,name="PLASTIC").save()
Guess(id=176,smeller_id=61,sample_id=106,intensity=100,humor_id=6,note_id=4,image_id=19,feeling=24,name="Flower").save()
Guess(id=177,smeller_id=61,sample_id=145,intensity=0,humor_id=6,note_id=2,image_id=18,feeling=61,name="PLASTIC").save()
Guess(id=178,smeller_id=61,sample_id=175,intensity=76,humor_id=5,note_id=1,image_id=4,feeling=80,name="Fat").save()
Guess(id=180,smeller_id=62,sample_id=125,intensity=6,humor_id=6,note_id=6,image_id=13,feeling=4,name="subtle (not super smelly) ").save()
Guess(id=181,smeller_id=63,sample_id=45,intensity=81,humor_id=3,note_id=4,image_id=9,feeling=0,name="orange").save()
Guess(id=182,smeller_id=63,sample_id=40,intensity=100,humor_id=13,note_id=1,image_id=2,feeling=100,name="sick").save()
Guess(id=183,smeller_id=63,sample_id=158,intensity=0,humor_id=6,note_id=2,image_id=7,feeling=0,name="odorless--").save()
Guess(id=184,smeller_id=62,sample_id=172,intensity=36,humor_id=6,note_id=6,image_id=4,feeling=12,name="subtle2").save()
Guess(id=185,smeller_id=63,sample_id=133,intensity=0,humor_id=13,note_id=6,image_id=18,feeling=0,name="odorles--").save()
Guess(id=186,smeller_id=63,sample_id=148,intensity=64,humor_id=6,note_id=1,image_id=2,feeling=20,name="").save()
Guess(id=187,smeller_id=62,sample_id=175,intensity=96,humor_id=9,note_id=3,image_id=11,feeling=95,name="BO").save()
Guess(id=188,smeller_id=62,sample_id=173,intensity=93,humor_id=9,note_id=3,image_id=2,feeling=98,name="BO2").save()
Guess(id=189,smeller_id=63,sample_id=150,intensity=24,humor_id=13,note_id=5,image_id=16,feeling=21,name="little odor").save()
Guess(id=190,smeller_id=62,sample_id=130,intensity=58,humor_id=13,note_id=5,image_id=3,feeling=69,name="BO3").save()
Guess(id=191,smeller_id=62,sample_id=170,intensity=74,humor_id=9,note_id=1,image_id=2,feeling=58,name="BO4").save()
Guess(id=192,smeller_id=64,sample_id=159,intensity=61,humor_id=9,note_id=3,image_id=7,feeling=71,name="meh").save()
Guess(id=193,smeller_id=64,sample_id=176,intensity=0,humor_id=13,note_id=6,image_id=8,feeling=48,name="not much smell").save()
Guess(id=194,smeller_id=64,sample_id=124,intensity=58,humor_id=9,note_id=2,image_id=11,feeling=60,name="chemically").save()
Guess(id=195,smeller_id=64,sample_id=175,intensity=59,humor_id=3,note_id=4,image_id=14,feeling=0,name="ok smell").save()
Guess(id=196,smeller_id=64,sample_id=45,intensity=87,humor_id=3,note_id=4,image_id=8,feeling=0,name="mandarinn!!!!").save()
Guess(id=197,smeller_id=64,sample_id=142,intensity=28,humor_id=13,note_id=5,image_id=4,feeling=63,name="plasticy").save()
Guess(id=198,smeller_id=65,sample_id=163,intensity=10,humor_id=6,note_id=2,image_id=19,feeling=11,name="Almost no odor").save()
Guess(id=199,smeller_id=65,sample_id=134,intensity=15,humor_id=2,note_id=2,image_id=19,feeling=54,name="").save()
Guess(id=200,smeller_id=65,sample_id=53,intensity=66,humor_id=13,note_id=1,image_id=4,feeling=75,name="").save()
Guess(id=201,smeller_id=65,sample_id=107,intensity=18,humor_id=10,note_id=2,image_id=19,feeling=48,name="").save()
Guess(id=202,smeller_id=65,sample_id=122,intensity=26,humor_id=13,note_id=2,image_id=19,feeling=43,name="").save()
Guess(id=203,smeller_id=65,sample_id=157,intensity=11,humor_id=6,note_id=6,image_id=13,feeling=14,name="").save()
Guess(id=206,smeller_id=68,sample_id=171,intensity=71,humor_id=12,note_id=1,image_id=7,feeling=100,name="rage").save()
Guess(id=214,smeller_id=74,sample_id=154,intensity=18,humor_id=13,note_id=2,image_id=8,feeling=77,name="").save()
Guess(id=215,smeller_id=75,sample_id=104,intensity=73,humor_id=2,note_id=2,image_id=19,feeling=66,name="").save()
Guess(id=216,smeller_id=74,sample_id=121,intensity=7,humor_id=6,note_id=5,image_id=17,feeling=73,name="").save()
Guess(id=217,smeller_id=75,sample_id=130,intensity=23,humor_id=11,note_id=1,image_id=1,feeling=63,name="").save()
Guess(id=218,smeller_id=74,sample_id=143,intensity=3,humor_id=3,note_id=3,image_id=19,feeling=69,name="").save()
Guess(id=219,smeller_id=75,sample_id=108,intensity=68,humor_id=10,note_id=5,image_id=7,feeling=66,name="").save()
Guess(id=220,smeller_id=75,sample_id=141,intensity=30,humor_id=10,note_id=1,image_id=5,feeling=61,name="").save()
Guess(id=221,smeller_id=74,sample_id=162,intensity=39,humor_id=8,note_id=4,image_id=9,feeling=49,name="").save()
Guess(id=222,smeller_id=75,sample_id=169,intensity=5,humor_id=9,note_id=1,image_id=1,feeling=56,name="Odeur indéfinissable").save()
Guess(id=223,smeller_id=74,sample_id=102,intensity=56,humor_id=1,note_id=2,image_id=16,feeling=49,name="").save()
Guess(id=224,smeller_id=75,sample_id=152,intensity=0,humor_id=9,note_id=1,image_id=1,feeling=55,name="Odeur indéfinissable").save()
Guess(id=225,smeller_id=74,sample_id=128,intensity=17,humor_id=9,note_id=6,image_id=12,feeling=67,name="").save()
Guess(id=226,smeller_id=76,sample_id=122,intensity=86,humor_id=9,note_id=3,image_id=16,feeling=80,name="BOOO").save()
Guess(id=227,smeller_id=77,sample_id=109,intensity=87,humor_id=6,note_id=4,image_id=18,feeling=41,name="creme").save()
Guess(id=228,smeller_id=76,sample_id=151,intensity=67,humor_id=5,note_id=2,image_id=7,feeling=90,name="ickypoo").save()
Guess(id=229,smeller_id=76,sample_id=171,intensity=77,humor_id=9,note_id=3,image_id=11,feeling=98,name="mewmewmewmew").save()
Guess(id=230,smeller_id=76,sample_id=167,intensity=59,humor_id=9,note_id=2,image_id=4,feeling=43,name="ickypooooo2").save()
Guess(id=231,smeller_id=77,sample_id=152,intensity=0,humor_id=9,note_id=3,image_id=19,feeling=100,name="PLASTIC").save()
Guess(id=232,smeller_id=76,sample_id=121,intensity=50,humor_id=12,note_id=2,image_id=18,feeling=59,name="WHY IS A BABY GIVEN ALCOHOL?!?").save()
Guess(id=233,smeller_id=76,sample_id=150,intensity=24,humor_id=4,note_id=5,image_id=13,feeling=62,name="tralalala").save()
Guess(id=234,smeller_id=77,sample_id=142,intensity=66,humor_id=9,note_id=2,image_id=19,feeling=100,name="PLASTIC").save()
Guess(id=235,smeller_id=77,sample_id=46,intensity=50,humor_id=1,note_id=1,image_id=2,feeling=0,name="NO TUBE").save()
Guess(id=236,smeller_id=77,sample_id=151,intensity=100,humor_id=2,note_id=5,image_id=4,feeling=50,name="sweat").save()
Guess(id=237,smeller_id=77,sample_id=149,intensity=4,humor_id=7,note_id=1,image_id=19,feeling=0,name="Printemps").save()
Guess(id=238,smeller_id=78,sample_id=152,intensity=0,humor_id=6,note_id=5,image_id=5,feeling=33,name="droplets of oil").save()
Guess(id=239,smeller_id=78,sample_id=133,intensity=83,humor_id=2,note_id=2,image_id=16,feeling=96,name="hard day").save()
Guess(id=240,smeller_id=78,sample_id=142,intensity=27,humor_id=8,note_id=5,image_id=9,feeling=79,name="sport").save()
Guess(id=241,smeller_id=78,sample_id=154,intensity=57,humor_id=10,note_id=6,image_id=6,feeling=85,name="pamezan").save()
Guess(id=242,smeller_id=78,sample_id=127,intensity=70,humor_id=1,note_id=2,image_id=2,feeling=92,name="rain and sweat").save()
Guess(id=243,smeller_id=78,sample_id=121,intensity=25,humor_id=6,note_id=4,image_id=14,feeling=8,name="grass").save()
Guess(id=253,smeller_id=83,sample_id=188,intensity=60,humor_id=10,note_id=2,image_id=7,feeling=70,name="").save()
Guess(id=254,smeller_id=84,sample_id=214,intensity=68,humor_id=9,note_id=3,image_id=7,feeling=65,name="colombian beauty").save()
Guess(id=255,smeller_id=85,sample_id=203,intensity=50,humor_id=7,note_id=2,image_id=18,feeling=24,name="Extrait chimique").save()
Guess(id=256,smeller_id=84,sample_id=199,intensity=36,humor_id=11,note_id=2,image_id=10,feeling=60,name="bleh").save()
Guess(id=257,smeller_id=83,sample_id=229,intensity=50,humor_id=13,note_id=6,image_id=19,feeling=0,name="Pas d'échantillon").save()
Guess(id=258,smeller_id=83,sample_id=185,intensity=63,humor_id=10,note_id=2,image_id=7,feeling=77,name="").save()
Guess(id=259,smeller_id=84,sample_id=221,intensity=88,humor_id=9,note_id=5,image_id=13,feeling=76,name="i dont like these choices").save()
Guess(id=260,smeller_id=83,sample_id=178,intensity=60,humor_id=6,note_id=6,image_id=8,feeling=21,name="").save()
Guess(id=261,smeller_id=84,sample_id=208,intensity=36,humor_id=13,note_id=2,image_id=8,feeling=25,name="mrep").save()
Guess(id=262,smeller_id=83,sample_id=224,intensity=75,humor_id=4,note_id=4,image_id=10,feeling=69,name="").save()
Guess(id=263,smeller_id=84,sample_id=203,intensity=90,humor_id=9,note_id=3,image_id=10,feeling=88,name="ew").save()
Guess(id=264,smeller_id=83,sample_id=217,intensity=81,humor_id=9,note_id=5,image_id=6,feeling=72,name="").save()
Guess(id=265,smeller_id=84,sample_id=189,intensity=66,humor_id=10,note_id=5,image_id=4,feeling=56,name="meow").save()
Guess(id=267,smeller_id=87,sample_id=190,intensity=21,humor_id=6,note_id=6,image_id=9,feeling=31,name="crême hydratante ").save()
Guess(id=268,smeller_id=88,sample_id=227,intensity=11,humor_id=6,note_id=4,image_id=9,feeling=25,name="Lemony me").save()
Guess(id=269,smeller_id=89,sample_id=223,intensity=20,humor_id=6,note_id=5,image_id=7,feeling=60,name="fade").save()
Guess(id=271,smeller_id=88,sample_id=183,intensity=0,humor_id=4,note_id=3,image_id=4,feeling=54,name="Empty tube").save()
Guess(id=272,smeller_id=88,sample_id=205,intensity=50,humor_id=13,note_id=2,image_id=18,feeling=66,name="Chemistry class").save()
Guess(id=273,smeller_id=88,sample_id=220,intensity=70,humor_id=9,note_id=2,image_id=2,feeling=70,name="LEAVE ME ALONE").save()
Guess(id=274,smeller_id=89,sample_id=204,intensity=68,humor_id=7,note_id=2,image_id=11,feeling=88,name="acide").save()
Guess(id=275,smeller_id=88,sample_id=225,intensity=6,humor_id=4,note_id=5,image_id=16,feeling=54,name="Super macho").save()
Guess(id=276,smeller_id=87,sample_id=189,intensity=4,humor_id=6,note_id=2,image_id=9,feeling=22,name="women deodorant").save()
Guess(id=277,smeller_id=88,sample_id=211,intensity=50,humor_id=6,note_id=4,image_id=19,feeling=37,name="Deodorant me").save()
Guess(id=278,smeller_id=89,sample_id=211,intensity=10,humor_id=1,note_id=4,image_id=9,feeling=11,name="fruit doux").save()
Guess(id=279,smeller_id=87,sample_id=219,intensity=50,humor_id=7,note_id=5,image_id=16,feeling=11,name="missing tube").save()
Guess(id=280,smeller_id=89,sample_id=227,intensity=11,humor_id=3,note_id=3,image_id=7,feeling=27,name="chaleur").save()
Guess(id=281,smeller_id=87,sample_id=216,intensity=87,humor_id=2,note_id=2,image_id=19,feeling=98,name="dirty swimming pool").save()
Guess(id=282,smeller_id=90,sample_id=212,intensity=82,humor_id=7,note_id=5,image_id=11,feeling=76,name="mec").save()
Guess(id=283,smeller_id=87,sample_id=179,intensity=14,humor_id=6,note_id=6,image_id=8,feeling=36,name="woman deodorant").save()
Guess(id=284,smeller_id=90,sample_id=197,intensity=7,humor_id=6,note_id=1,image_id=10,feeling=97,name="dinner").save()
Guess(id=285,smeller_id=89,sample_id=195,intensity=57,humor_id=3,note_id=4,image_id=14,feeling=24,name="dynamique").save()
Guess(id=286,smeller_id=90,sample_id=199,intensity=73,humor_id=8,note_id=2,image_id=19,feeling=78,name="a guy with to much perfumes").save()
Guess(id=287,smeller_id=87,sample_id=185,intensity=18,humor_id=6,note_id=6,image_id=9,feeling=47,name="woman deodorant ").save()
Guess(id=288,smeller_id=89,sample_id=206,intensity=83,humor_id=9,note_id=1,image_id=2,feeling=94,name="sport").save()
Guess(id=289,smeller_id=91,sample_id=190,intensity=50,humor_id=3,note_id=4,image_id=8,feeling=12,name="Candy").save()
Guess(id=290,smeller_id=90,sample_id=185,intensity=20,humor_id=6,note_id=4,image_id=9,feeling=20,name="fresh flower").save()
Guess(id=291,smeller_id=90,sample_id=226,intensity=0,humor_id=11,note_id=3,image_id=14,feeling=47,name="almost  othing").save()
Guess(id=292,smeller_id=91,sample_id=187,intensity=23,humor_id=6,note_id=2,image_id=12,feeling=50,name="Paper").save()
Guess(id=293,smeller_id=90,sample_id=178,intensity=81,humor_id=3,note_id=6,image_id=8,feeling=0,name="soap").save()
Guess(id=294,smeller_id=91,sample_id=229,intensity=8,humor_id=1,note_id=3,image_id=18,feeling=49,name="").save()
Guess(id=295,smeller_id=91,sample_id=180,intensity=43,humor_id=3,note_id=4,image_id=9,feeling=31,name="Bubble gum").save()
Guess(id=296,smeller_id=91,sample_id=195,intensity=12,humor_id=13,note_id=5,image_id=4,feeling=21,name="Clay").save()
Guess(id=298,smeller_id=92,sample_id=183,intensity=20,humor_id=4,note_id=1,image_id=17,feeling=10,name="").save()
Guess(id=299,smeller_id=93,sample_id=226,intensity=10,humor_id=13,note_id=2,image_id=9,feeling=44,name="").save()
Guess(id=300,smeller_id=93,sample_id=201,intensity=57,humor_id=3,note_id=4,image_id=9,feeling=16,name="").save()
Guess(id=301,smeller_id=93,sample_id=217,intensity=88,humor_id=7,note_id=1,image_id=4,feeling=42,name="").save()
Guess(id=302,smeller_id=93,sample_id=220,intensity=63,humor_id=2,note_id=1,image_id=4,feeling=77,name="").save()
Guess(id=303,smeller_id=93,sample_id=208,intensity=62,humor_id=9,note_id=2,image_id=19,feeling=84,name="").save()
Guess(id=304,smeller_id=93,sample_id=181,intensity=31,humor_id=1,note_id=4,image_id=9,feeling=19,name="").save()
Guess(id=305,smeller_id=94,sample_id=213,intensity=0,humor_id=9,note_id=5,image_id=12,feeling=0,name="no tube").save()
Guess(id=306,smeller_id=94,sample_id=202,intensity=56,humor_id=7,note_id=2,image_id=15,feeling=74,name="").save()
Guess(id=307,smeller_id=94,sample_id=188,intensity=45,humor_id=6,note_id=3,image_id=15,feeling=50,name="").save()
Guess(id=308,smeller_id=94,sample_id=206,intensity=100,humor_id=7,note_id=1,image_id=4,feeling=86,name="").save()
Guess(id=309,smeller_id=94,sample_id=227,intensity=67,humor_id=9,note_id=3,image_id=16,feeling=76,name="").save()
Guess(id=310,smeller_id=94,sample_id=186,intensity=12,humor_id=3,note_id=6,image_id=9,feeling=39,name="").save()
Guess(id=311,smeller_id=95,sample_id=217,intensity=84,humor_id=1,note_id=1,image_id=4,feeling=41,name="Very manly").save()
Guess(id=312,smeller_id=95,sample_id=225,intensity=29,humor_id=13,note_id=5,image_id=7,feeling=72,name="").save()
Guess(id=313,smeller_id=95,sample_id=215,intensity=76,humor_id=10,note_id=2,image_id=9,feeling=54,name="").save()
Guess(id=314,smeller_id=95,sample_id=205,intensity=76,humor_id=1,note_id=2,image_id=8,feeling=19,name="").save()
Guess(id=315,smeller_id=95,sample_id=182,intensity=45,humor_id=3,note_id=4,image_id=9,feeling=17,name="").save()
Guess(id=316,smeller_id=95,sample_id=216,intensity=64,humor_id=7,note_id=1,image_id=9,feeling=25,name="").save()
Guess(id=341,smeller_id=113,sample_id=198,intensity=50,humor_id=11,note_id=4,image_id=None,feeling=0,name="").save()

print "Guess created"