def test2():
mm = mm_po(po_no='P003')
s1 = dset(item_type=mm_po)
s1.append(mm_po(po_no='P201'))
s1.append(mm_po(po_no='P202'))
s1.append(mm_po(po_no='P203'))
dmerge(s1)
s2 = s1.copy()
s2[0].vendor_sn = vendor_seq()
s2[1].vendor_sn = vendor_seq()
dmerge(s2, s1)
print(s2)
def test():
s = seq_po()
# s.value =100
print('100, ', bool(s))
s.value = '100'
print('200, ', bool(s))
print('ddd %d' % s)
mm = mm_po('P003')
print(mm)
dbc << 'SELECT %s'
dbc << (1,)
dbc << (2,)
dbc << [(3,), (4,)]
dbc << ''
dbc << 'SELECT %s' << (200,)
dbc << 'select 100'
s1 = dset(item_type=mm_po)
s1.append(mm_po(po_no='P001', po_date=dt.date(2015,7,1), notes='abc'))
s1.append(mm_po(po_no='P002', po_date=dt.date(2015,7,2), notes='xyz'))
s1.append(mm_po(po_no='P004', po_date=dt.date(2015,7,4), notes='hij'))
s1.append(mm_po(po_no='P003', po_date=dt.date(2015,7,3), notes='efg'))
dmerge(s1, None)
s2 = s1.copy()
s2[0].notes = 'abc21'
s2[2].po_date = dt.date(2015, 6, 2)
s2[2].notes = 'abc22'
dmerge(s2, s1)
s3 = s2.copy()
del s3[1]
dmerge(s3, s2)
po_no = 'P001'
dbc << 'SELECT * FROM mm_po WHERE po_no=%s'
po_old = dset(mm_po, dbc << (po_no,))
po_new = po_old.copy()
po_new[0].notes = 'test2-123'
dmerge(po_new, po_old)
print(po_new)
