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()