def addGlasses(acc_id, m_num, f_type, g_pads, l_shape, l_color, l_size, dist_bet_glasses, temp_type, temp_size):
#before adding, check if entry already exists in db
if Glasses.objects.filter(account_id = acc_id,
map_num = m_num,
frame_type = f_type,
gold_pads = g_pads,
lens_shape = l_shape,
lens_color = l_color,
lens_size = l_size,
dbl = dist_bet_glasses,
temple_type = temp_type,
temple_size = temp_size).exists():
print "Cannot add duplicate entry!"
else:
p = Glasses(account_id = acc_id,
map_num = m_num,
frame_type = f_type,
gold_pads = g_pads,
lens_shape = l_shape,
lens_color = l_color,
lens_size = l_size,
dbl = dist_bet_glasses,
temple_type = temp_type,
temple_size = temp_size)
p.save()
def populate_db():
p = Glasses(account_id = 1,
map_num = 1,
frame_type = 42,
gold_pads = 'g',
lens_shape = 'P-5',
lens_color = 'Clr',
lens_size = '42',
dbl = '21',
temple_type = 'CC',
temple_size = 'NA')
p.save()
q = Glasses(account_id = 2,
map_num = 1,
frame_type = 43,
gold_pads = 'ng',
lens_shape = 'Francis',
lens_color = 'Clr',
lens_size = '42',
dbl = '20',
temple_type = 'NS',
temple_size = 'NA')
q.save()
r = Glasses(account_id = 3,
map_num = 2,
frame_type = 43,
gold_pads = 'g',
lens_shape = 'Cuthbert',
lens_color = 'Clr',
lens_size = '43',
dbl = '24',
temple_type = 'NS',
temple_size = 'NA')
r.save()
s = Glasses(account_id = 4,
map_num = 2,
frame_type = '42',
gold_pads = 'g',
lens_shape = 'StanWest',
lens_color = 'Clr',
lens_size = '45',
dbl = '21',
temple_type = 'NS',
temple_size = 'NA')
s.save()
