def test02(self):
''' Select first name and surname '''
pa = PatentTable()
rows = pa.selectcols(idx=True, first_name=True, surname=True)
for row in rows:
print row
def test04(self):
pa = PatentTable()
for i in range(5,13):
pa.update(i, work_phone='01444-129666', post_code='BN238BJ')
where = pa.singlewhere(work_phone='01444-129666', post_code='BN238BJ')
rows = pa.selectall(whereStr=where)
for row in rows:
print row
def test03(self):
pa = PatentTable()
idx = pa.get_id("Paul", "Limb")
assert idx != None, "Item not found"
row = pa.showItem(idx)
print row
def test01(self):
''' Selete all data '''
pa = PatentTable()
rows = pa.selectall()
n = len(rows)
assert n == 35, "Need to have 35 rows "
def test00(self):
''' Initalise Table with date '''
pa = PatentTable()
pa.add("Steve", "Dean")
pa.add("Stephen", "Bennett")
pa.add("Stephen", "Brunton")
pa.add("Simon", "Robinson")
pa.add("Roger", "Smith")
pa.add("Robert", "Poole")
pa.add("Robert", "Gardner")
pa.add("Richard", "Howell")
pa.add("Richard", "Fewing")
pa.add("Richard", "Carter")
pa.add("Peter", "King")
pa.add("Peter", "Connolly")
pa.add("Paul", "Limb")
pa.add("Paul", "Leeming")
pa.add("Paul", "Hill")
pa.add("Paul", "Arthurs")
pa.add("Paul", "Bergin")
pa.add("Paul", "Arnold")
pa.add("Nigel", "Williams")
pa.add("Neville", "Smith")
pa.add("Neil", "Clark")
pa.add("Mike T", "Robson")
pa.add("Michael", "Peirce")
pa.add("Max", "Borkowski")
pa.add("Martin", "Kirby")
pa.add("Mark", "Stanley")
pa.add("Mark", "Ingram")
pa.add("Mark", "Collins")
pa.add("Malcolm", "Stenning")
pa.add("Louis", "Kenney")
pa.add("Leon", "Tanner")
pa.add("Krystyn", "Rogers")
pa.add("Kevin", "Ellwood")
pa.add("Steve", "Kersley")
pa.add("dave","fresdrickson" )
def test09(self):
''' Delete all data '''
pa = PatentTable()
pa.deleteall()
rows = pa.selectall()
assert len(rows) == 0, "Table not empty"