def test_01(self):
ss = SpreadSheet(names=[u'sheet1', u'sheet2'])
self.assertEqual(len(ss), 2)
self.assertRaises(IntegrityError, ss.create_sheet, u'sheet1')
validator = SheetOrder()
ss.add_validator(validator.add, 'add_sheet')
ss.add_validator(validator.remove, 'remove_sheet')
self.assertRaises(ValueError, ss.create_sheet, u'sheet3')
self.assertEqual(len(ss), 2)
ss.create_sheet(u' 1 ')
ss.create_sheet(u' 2 ')
self.assertRaises(ValidationError, ss.create_sheet, u' 1 ')
self.assertRaises(ValueError, ss.__delitem__, u'sheet1')
self.assertRaises(ValidationError, ss.__delitem__, u'1')
del ss[u'2']
def test_02(self):
ss = SpreadSheet(
names=[u'sheet1', u'sheet2'], sheet_captions=[u'GID'])
ss.add_validator(integer_gid, 'insert_row', 'replace_row')
row_validator = UniqueIntegerValidator2(u'GID')
ss.add_validator(row_validator.insert, 'insert_row')
ss.add_validator(row_validator.delete, 'delete_row')
ss.add_validator(row_validator.replace, 'replace_row')
sheet1 = ss[u'sheet1']
sheet2 = ss[u'sheet2']
sheet1.append([1])
sheet1.append([2])
self.assertRaises(ValidationError, sheet1.append, [2])
self.assertRaises(ValidationError, sheet2.append, [2])
del sheet1[1]
sheet2.append([2])
self.assertRaises(ValidationError, sheet1.append, [2])
sheet2[0] = {u'GID': 3}
sheet1.append([2])
