def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('File_Txt',
commonBits.sampleDir() + 'Ams_PODownload_20041231.txt')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Fields.FieldRelationship_JTbl', '4',
commonBits.fl('Value') + ',0')
select(
'Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Operator') + ',0(' +
commonBits.fl('Contains') + ')')
## click('ScrollPane$ScrollBar', 10, 33)
select('Fields.FieldRelationship_JTbl', commonBits.fl('>= (Numeric)'),
commonBits.fl('Operator') + ',0')
select('TabbedPane', commonBits.fl('Group Filter'))
select('Fields.FieldRelationship_JTbl1', '4',
commonBits.fl('Value') + ',0')
select(
'Fields.FieldRelationship_JTbl1',
'cell:' + commonBits.fl('Operator') + ',0(' +
commonBits.fl('Contains') + ')')
## click('ScrollPane$ScrollBar', 8, 92)
select('Fields.FieldRelationship_JTbl1', commonBits.fl('>= (Numeric)'),
commonBits.fl('Operator') + ',0')
select('Fields.FieldRelationship_JTbl1',
'cell:' + commonBits.fl('Value') + ',1()')
select('Fields.FieldRelationship_JTbl1',
'cell:' + commonBits.fl('Field') + ',0(0)')
select('Filter.RecordSelection_JTbl1',
'cell:' + commonBits.fl('Include') + ',1(true)')
select('Fields.FieldRelationship_JTbl1',
'cell:' + commonBits.fl('Value') + ',2()')
select('Fields.FieldRelationship_JTbl1',
'cell:' + commonBits.fl('Field') + ',0(-2147483647)')
click('ArrowButton')
select_menu('ams PO Download: Allocation>>Pack Quantity 1')
commonBits.save2(click)
## click(commonBits.fl('Save') + '1')
## select('File name', 'xx4')
if commonBits.isWindowsLook():
select('File name', 'xx4')
else:
select('File Name', 'xx4')
commonBits.save(click)
##click(commonBits.fl('Save'))
select_menu(
commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' +
commonBits.fl('Filter Options'))
click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(
commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' +
commonBits.fl('Table:'))
## click('MetalInternalFrameTitlePane', 644, 18)
click('Filter1')
click(commonBits.fl('Load'))
if window('Open'):
##select('FilePane$3', 'xx4')
##select(commonBits.selectPane(), 'xx4')
##click('Open')
if commonBits.isWindowsLook():
select('File name', 'xx4')
else:
select('File Name', 'xx4')
click('Open')
## select('FileName', 'xx4')
## doubleclick('FilePane$3', '5')
close()
select('TabbedPane', commonBits.fl('Group Filter'))
assert_p(
'Fields.FieldRelationship_JTbl1', 'Content',
'[[, , 200004, true, ' + commonBits.fl('First') + ', ' +
commonBits.fl('>= (Numeric)') + ', 4], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') +
', ' + commonBits.fl('Contains') + ', ]]')
commonBits.filter2(click)
## click(commonBits.fl('Filter') + '1')
## select('TabbedPane1', 'Table:')
select_menu(
commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' +
commonBits.fl('Filter Options'))
select_menu(
commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' +
commonBits.fl('Table:'))
assert_p(
'LineList.FileDisplay_JTbl1', 'Content',
'[[D1, 4, 40000000, 1, 48320000, 4561, 50710000, 5, 45400000, 44, 207, 5354, , 4561, 5071, M, .ROSE 24, -6, 607 SHWL], [S1, 5009, 5, 5021, 5, 5025, 4, 5026, 4, 5047, 3, 5077, 2, 5127, 5, 5134, 4, 5142, 2], [S1, 5044, 2, 5071, 2, , 0, , 0, , 0, , 0, , 0, , 0, , 0]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_03'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
click(commonBits.fl('Edit') + '1')
select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Sorted Field Tree'))
# select('List', 'DTAR020')
# select('List', 'DTAR020')
select('Table', 'cell:' + commonBits.fl('Field') + ',0( )')
# select('List', 'DTAR020')
select('Table', 'DEPT-NO', commonBits.fl('Field') + ',0')
select('Table', 'DATE', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(DATE)')
select('Table1', 'cell:' + commonBits.fl('Function') + ',2()')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(DATE)')
select('Table1', commonBits.fl('Maximum'), commonBits.fl('Function') + ',2')
select('Table1', commonBits.fl('Maximum'), commonBits.fl('Function') + ',3')
select('Table1', commonBits.fl('Sum'), commonBits.fl('Function') + ',4')
select('Table1', commonBits.fl('Sum'), commonBits.fl('Function') + ',5')
select('Table1', 'cell:' + commonBits.fl('Function') + ',5(Sum)')
##commonBits.save1(click)
commonBits.save(click)
##select('FileChooser', commonBits.userDir() + 'SortTree' + commonBits.fileSep() + 'xx2')
commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'SortTree' + commonBits.fileSep() + 'xx2')
commonBits.save1(click)
select_menu(commonBits.fl('Window') + '>>DTAR020.bin>>' + commonBits.fl('Create Sorted Tree'))
click(commonBits.fl('Build Tree'))
select('JTreeTable', 'cell:DATE,0(40118)')
assert_p('JTreeTable', 'Text', '40118', 'DATE,0')
select('JTreeTable', 'cell:DEPT-NO,0(60)')
assert_p('JTreeTable', 'Text', '5', 'QTY-SOLD,2')
select('JTreeTable', 'cell:SALE-PRICE,0(8.74)')
assert_p('JTreeTable', 'Text', '166.94', 'SALE-PRICE,1')
select('JTreeTable', 'cell:SALE-PRICE,1(166.94)')
assert_p('JTreeTable', 'Text', '166.94', 'SALE-PRICE,1')
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',1(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',1')
select_menu(commonBits.fl('Expand Tree'))
select('JTreeTable', 'cell:QTY-SOLD,2(8)')
assert_p('JTreeTable', 'Text', '5', 'QTY-SOLD,3')
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',2(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',2')
select_menu(commonBits.fl('Expand Tree'))
select('JTreeTable', 'cell:SALE-PRICE,3(12.99)')
assert_p('JTreeTable', 'Text', '12.99', 'SALE-PRICE,4')
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',14(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',14')
select_menu(commonBits.fl('Edit Record'))
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',14(null)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(commonBits.fl('Window') + '>>DTAR020.bin>>' + commonBits.fl('Table:'))
select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Execute Sort Tree'))
##select('FileChooser', commonBits.userDir() + 'SortTree' + commonBits.fileSep() + 'xx2')
commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'SortTree' + commonBits.fileSep() + 'xx2')
click(commonBits.fl('Run')
)
select('JTreeTable', 'cell:SALE-PRICE,1(166.94)')
assert_p('JTreeTable', 'Text', '166.94', 'SALE-PRICE,1')
select('JTreeTable', 'cell:SALE-PRICE,2(87.46)')
assert_p('JTreeTable', 'Text', '87.46', 'SALE-PRICE,2')
select('JTreeTable', 'cell:SALE-PRICE,3(-15.85)')
assert_p('JTreeTable', 'Text', '-15.85', 'SALE-PRICE,3')
select('JTreeTable', 'cell:SALE-PRICE,9(-4.00)')
select('JTreeTable', 'cell:SALE-PRICE,7(14.09)')
assert_p('JTreeTable', 'Text', '17.73', 'SALE-PRICE,8')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'Ams_PODownload_20041231.txt')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Field') + ',0(null)')
select('Filter.RecordSelection_JTbl', 'false', commonBits.fl('Include') + ',1')
select('TabbedPane', commonBits.fl('Group Filter'))
select('Filter.RecordSelection_JTbl1', 'false', commonBits.fl('In Group') + ',1')
## select('Filter.RecordSelection_JTbl1', 'cell:' + commonBits.fl('In Group') + ',1(false)')
select('Fields.FieldRelationship_JTbl1', 'cell:' + commonBits.fl('Operator') + ',0(' + commonBits.fl('Contains') + ')')
select('Fields.FieldRelationship_JTbl1', '>', commonBits.fl('Operator') + ',0')
select('Fields.FieldRelationship_JTbl1', '4', commonBits.fl('Value') + ',0')
select('Fields.FieldRelationship_JTbl1', 'cell:' + commonBits.fl('Value') + ',0()')
select('Fields.FieldRelationship_JTbl1', 'cell:' + commonBits.fl('Field') + ',0(-2147483647)')
click('ArrowButton')
## select('Fields.FieldRelationship_JTbl1', 'cell:' + commonBits.fl('Field') + ',0(0)')
select_menu('ams PO Download: Allocation>>Pack Quantity 1')
# select('Fields.FieldRelationship_JTbl1', 'cell:' + commonBits.fl('Operator') + ',0(' + commonBits.fl('Contains') + ')')
# select('Fields.FieldRelationship_JTbl1', '>', commonBits.fl('Operator') + ',0')
# select('Fields.FieldRelationship_JTbl1', '4', commonBits.fl('Value') + ',0')
# select('Fields.FieldRelationship_JTbl1', 'cell:' + commonBits.fl('Value') + ',0()')
commonBits.save2(click)
## click(commonBits.fl('Save') + '1')
## select('File Name', 'xx5')
if commonBits.isWindowsLook():
select('File name', 'xx5')
else:
select('File Name', 'xx5')
commonBits.save(click)
## click(commonBits.fl('Save'))
commonBits.filter2(click)
# click(commonBits.fl('Filter') + '1')
## select('TabbedPane1', 'Table:')
## click('BasicInternalFrameTitlePane$NoFocusButton2')
select('LineList.FileDisplay_JTbl1', 'cell:15 - 4|DC Number 2,0(1)')
select('LineList.FileDisplay_JTbl1', 'cell:15 - 4|DC Number 2,0(1)')
assert_p('LineList.FileDisplay_JTbl1', 'Content', '[[D1, 4, 40000000, 1, 48320000, 4561, 50710000, 5, 45400000, 44, 207, 5354, , 4561, 5071, M, .ROSE 24, -6, 607 SHWL], [S1, 5009, 5, 5021, 5, 5025, 4, 5026, 4, 5047, 3, 5077, 2, 5127, 5, 5134, 4, 5142, 2], [S1, 5044, 2, 5071, 2, , 0, , 0, , 0, , 0, , 0, , 0, , 0]]')
select('LineList.FileDisplay_JTbl1', 'cell:15 - 4|DC Number 2,0(1)')
click('DisplayFrame$TabButton', 25, 24)
select('TabbedPane', 'Table:')
select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Execute Saved Filter'))
select('File Name', 'xx5')
click(commonBits.fl('Run Dialog'))
select('TabbedPane', commonBits.fl('Group Filter'))
select('Filter.RecordSelection_JTbl1', 'cell:' + commonBits.fl('Record') + ',1(ams PO Download: Header)')
assert_p('Filter.RecordSelection_JTbl1', 'Content', '[[ams PO Download: Detail, true, true], [ams PO Download: Header, false, true], [ams PO Download: Allocation, true, true]]')
select('Filter.RecordSelection_JTbl1', 'cell:' + commonBits.fl('Record') + ',1(ams PO Download: Header)')
assert_p('Fields.FieldRelationship_JTbl1', 'Content', '[[, , 200004, true, ' + commonBits.fl('First') + ', >, 4], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ]]')
select('Filter.RecordSelection_JTbl1', 'cell:' + commonBits.fl('Record') + ',1(ams PO Download: Header)')
commonBits.filter2(click)
# click(commonBits.fl('Filter') + '1')
## select('TabbedPane1', 'Table:')
select_menu(commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' + commonBits.fl('Table:'))
select('LineList.FileDisplay_JTbl2', 'cell:15 - 4|DC Number 2,1(5021)')
assert_p('LineList.FileDisplay_JTbl2', 'Content', '[[D1, 4, 40000000, 1, 48320000, 4561, 50710000, 5, 45400000, 44, 207, 5354, , 4561, 5071, M, .ROSE 24, -6, 607 SHWL], [S1, 5009, 5, 5021, 5, 5025, 4, 5026, 4, 5047, 3, 5077, 2, 5127, 5, 5134, 4, 5142, 2], [S1, 5044, 2, 5071, 2, , 0, , 0, , 0, , 0, , 0, , 0, , 0]]')
select('LineList.FileDisplay_JTbl2', 'cell:15 - 4|DC Number 2,1(5021)')
select_menu(commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' + commonBits.fl('Filter Options'))
## select('LineList.FileDisplay_JTbl2', 'cell:15 - 4|DC Number 2,1(5021)')
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('LineList.FileDisplay_JTbl2', 'cell:15 - 4|DC Number 2,1(5021)')
select('LineList.FileDisplay_JTbl2', 'cell:15 - 4|DC Number 2,1(5021)')
select_menu(commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' + commonBits.fl('Table:'))
select('LineList.FileDisplay_JTbl2', 'cell:15 - 4|DC Number 2,1(5021)')
click(commonBits.fl('Table:'))
select('TabbedPane', 'Table:')
click('Find1')
click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Filter1')
click(commonBits.fl('Load'))
if window('Open'):
##select('FilePane$3', 'xx5')
if commonBits.isWindowsLook():
select('File name', 'xx5')
else:
select('File Name', 'xx5')
## select('File Name', 'xx5')
click('Open')
close()
##
select('TabbedPane', commonBits.fl('Group Filter'))
assert_p('Filter.RecordSelection_JTbl1', 'Content', '[[ams PO Download: Detail, true, true], [ams PO Download: Header, false, true], [ams PO Download: Allocation, true, true]]')
assert_p('Fields.FieldRelationship_JTbl1', 'Content', '[[, , 200004, true, ' + commonBits.fl('First') + ', >, 4], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', 0, true, ' + commonBits.fl('First') + ', ' + commonBits.fl('Contains') + ', ]]')
commonBits.filter2(click)
# click(commonBits.fl('Filter') + '1')
## select('TabbedPane1', 'Table:')
## click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' + commonBits.fl('Table:'))
click(commonBits.fl('Table:') + '2')
select('TabbedPane', 'Table:')
click(commonBits.fl('Table:') + '3')
select('TabbedPane', 'Table:')
assert_p('LineList.FileDisplay_JTbl3', 'Content', '[[D1, 4, 40000000, 1, 48320000, 4561, 50710000, 5, 45400000, 44, 207, 5354, , 4561, 5071, M, .ROSE 24, -6, 607 SHWL], [S1, 5009, 5, 5021, 5, 5025, 4, 5026, 4, 5047, 3, 5077, 2, 5127, 5, 5134, 4, 5142, 2], [S1, 5044, 2, 5071, 2, , 0, , 0, , 0, , 0, , 0, , 0, , 0]]')
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_17'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'Ams_PODownload_20041231.txt')
commonBits.doEdit(click)
select_menu(
commonBits.fl('Edit') + '>>' + commonBits.fl('Show / Hide Fields'))
select('Table', 'cell:' + commonBits.fl('Show') + ',3(true)')
select('Table', 'cell:' + commonBits.fl('Show') + ',4(true)')
select('Table', 'cell:' + commonBits.fl('Show') + ',7(true)')
select('Table', 'cell:' + commonBits.fl('Show') + ',8(true)')
click(commonBits.fl('Go'))
select('LayoutCombo', 'ams PO Download: Detail')
## select('Table', '')
rightclick('Table', '38 - 1|Filler,2')
select_menu(commonBits.fl('Hide Column'))
## select('Table', '')
rightclick('Table', '72 - 15|pmg dtl tech key,2')
select_menu(commonBits.fl('Hide Column'))
## select('Table', '')
rightclick('Table', '3 - 9|Pack Qty,0')
select_menu(commonBits.fl('Edit Record'))
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(
commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' +
commonBits.fl('Table:'))
select_menu(
commonBits.fl('Edit') + '>>' + commonBits.fl('Show / Hide Fields'))
commonBits.save(click)
##select('FileChooser', commonBits.CobolCopybookDir() + 't1Hide.xml')
commonBits.selectFileName(select, keystroke,
commonBits.CobolCopybookDir() + 't1Hide.xml')
commonBits.save1(click)
## select_menu(commonBits.fl('Window') + '>>Menu')
## click('MetalInternalFrameTitlePane', 215, 10)
##commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
## click('MetalInternalFrameTitlePane', 458, 5)
select_menu(
commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' +
commonBits.fl('Table:'))
## select('Table', '')
rightclick('Table', '1 - 2|Record Type,0')
select_menu(commonBits.fl('Edit Record'))
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.349, 45349], [Vendor, 8, 10, 6060, 0000006060], [PO, 18, 12, 286225, 286225], [Entry Date, 30, 6, 040909, 040909], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 200, 200], [Expected Reciept Date, 52, 6, 050102, 050102], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, LADIES KNI, LADIES KNI], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
select_menu(
commonBits.fl('View') + '>>' +
commonBits.fl('Load Saved Hidden Fields'))
##select('FileChooser', commonBits.CobolCopybookDir() + 't1Hide.xml')
commonBits.selectFileName(select, keystroke,
commonBits.CobolCopybookDir() + 't1Hide.xml')
click(commonBits.fl('Run'))
select('Table', 'cell:' + commonBits.fl('Data') + ',3(286225)')
select_menu(
commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' +
commonBits.fl('Record:'))
select('Table', 'cell:' + commonBits.fl('Data') + ',2(6060)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.349, 45349], [Vendor, 8, 10, 6060, 0000006060], [PO, 18, 12, 286225, 286225], [Entry Date, 30, 6, 040909, 040909], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 200, 200], [Expected Reciept Date, 52, 6, 050102, 050102], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, LADIES KNI, LADIES KNI], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(6060)')
click('Right')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 7.0000, 000070000], [Pack Cost, 12, 13, 0.0002, 0000000000002], [APN, 25, 13, 2222500000000, 2222500000000], [Product, 39, 8, 43314531, 43314531], [Case Pack id, 87, 15, 45614531, 45614531], [Product Name, 101, 50, DONKEY 24-006607 SHWL WRAP CARD, DONKEY 24-006607 SHWL WRAP CARD]]'
)
click('Right')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5043, 5043], [Pack Quantity 1, 7, 8, 1, 00000001], [DC Number 4, 39, 4, 5076, 5076], [Pack Quantity 4, 43, 8, 1, 00000001], [DC Number 6, 63, 4, 5151, 5151], [Pack Quantity 6, 67, 8, 1, 00000001], [DC Number 7, 75, 4, 5072, 5072], [Pack Quantity 7, 79, 8, 1, 00000001], [DC Number 8, 87, 4, , ], [Pack Quantity 8, 91, 8, 0, 00000000], [DC Number 9, 99, 4, , ], [Pack Quantity 9, 103, 8, 0, 00000000], [DC Number 10, 111, 4, , ], [Pack Quantity 10, 115, 8, 0, 00000000]]'
)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_10'
if window('Record Editor'):
commonBits.selectOldFilemenu(select_menu, 'Utilities', 'File Copy Menu')
click('*3')
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
select('FileChooser1', commonBits.sampleDir() + 'CpyCsvDtar020.Txt')
commonBits.setRecordLayout2(select, 'DTAR020')
## select('ComboBox3', commonBits.fl('<Tab>'))
select('DelimiterCombo', commonBits.fl('<Tab>'))
click('Right')
select('TabbedPane', '')
select('Table1', 'cell:' + commonBits.fl('Include') + ',3(true)')
click('Right')
select('TabbedPane', '')
select('FileChooser', commonBits.userDir() + 'cpy2csvDTAR020.xml')
##commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'cpy2csvDTAR020.xml')
commonBits.save(click)
commonBits.copy(click)
##commonBits.save1(click)
##click('Copy2')
assert_p('TextField1', 'Text', commonBits.fl('Copy Done !!!')
)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(commonBits.fl('Window') + '>>' + commonBits.fl('Menu') + '>>' + commonBits.fl('Copy Menu')
)
select_menu(commonBits.fl('Window') + '>>' + commonBits.fl('Open File')
)
select('FileChooser', commonBits.sampleDir() + 'CpyCsvDtar020.Txt')
##commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'cpy2csvDTAR020.xml')
##select('ComboBox2', 'Tab Delimited, names on the first line')
commonBits.setRecordLayout(select, 'Tab Delimited, names on the first line')
commonBits.doEdit(click)
select('Table', 'cell:2|STORE-NO,0(20)')
rightclick('Table', '1|KEYCODE-NO,0')
## select('Table', 'cell:2|STORE-NO,0(20)')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:2|STORE-NO,0(20)')
select('Table', 'cell:' + commonBits.fl('Data') + ',0(69684558)')
assert_p('JTableHeader', 'Text', commonBits.fl('Data'), commonBits.fl('Data')
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p('Table', 'Content', '[[KEYCODE-NO, 1, , 69684558, 69684558], [STORE-NO, 2, , 20, 20], [DATE, 3, , 40118, 40118], [QTY-SOLD, 4, , 1, 1], [SALE-PRICE, 5, , 19.00, 19.00]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(-19.00)')
assert_p('Table', 'Text', '-19.00', commonBits.fl('Data') + ',4')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p('Table', 'Content', '[[KEYCODE-NO, 1, , 69684558, 69684558], [STORE-NO, 2, , 20, 20], [DATE, 3, , 40118, 40118], [QTY-SOLD, 4, , -1, -1], [SALE-PRICE, 5, , -19.00, -19.00]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(5.01)')
assert_p('Table', 'Content', '[[KEYCODE-NO, 1, , 69684558, 69684558], [STORE-NO, 2, , 20, 20], [DATE, 3, , 40118, 40118], [QTY-SOLD, 4, , 1, 1], [SALE-PRICE, 5, , 5.01, 5.01]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p('Table', 'Content', '[[KEYCODE-NO, 1, , 69694158, 69694158], [STORE-NO, 2, , 20, 20], [DATE, 3, , 40118, 40118], [QTY-SOLD, 4, , 1, 1], [SALE-PRICE, 5, , 19.00, 19.00]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(-19.00)')
assert_p('Table', 'Text', '-19.00', commonBits.fl('Data') + ',4')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p('Table', 'Content', '[[KEYCODE-NO, 1, , 69694158, 69694158], [STORE-NO, 2, , 20, 20], [DATE, 3, , 40118, 40118], [QTY-SOLD, 4, , -1, -1], [SALE-PRICE, 5, , -19.00, -19.00]]')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_03'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
click(commonBits.fl('Edit') + '1')
select_menu(
commonBits.fl('View') + '>>' + commonBits.fl('Sorted Field Tree'))
# select('List', 'DTAR020')
# select('List', 'DTAR020')
select('Table', 'cell:' + commonBits.fl('Field') + ',0( )')
# select('List', 'DTAR020')
select('Table', 'DEPT-NO', commonBits.fl('Field') + ',0')
select('Table', 'DATE', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(DATE)')
select('Table1', 'cell:' + commonBits.fl('Function') + ',2()')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(DATE)')
select('Table1', commonBits.fl('Maximum'),
commonBits.fl('Function') + ',2')
select('Table1', commonBits.fl('Maximum'),
commonBits.fl('Function') + ',3')
select('Table1', commonBits.fl('Sum'),
commonBits.fl('Function') + ',4')
select('Table1', commonBits.fl('Sum'),
commonBits.fl('Function') + ',5')
select('Table1', 'cell:' + commonBits.fl('Function') + ',5(Sum)')
commonBits.save(click)
##commonBits.save1(click)
##select('FileChooser', commonBits.userDir() + 'SortTree' + commonBits.fileSep() + 'xx1')
commonBits.selectFileName(
select, keystroke,
commonBits.userDir() + 'SortTree' + commonBits.fileSep() + 'xx1')
commonBits.save1(click)
select_menu(
commonBits.fl('Window') + '>>DTAR020.bin>>' +
commonBits.fl('Create Sorted Tree'))
click(commonBits.fl('Build Tree'))
select('JTreeTable', 'cell:DATE,0(40118)')
assert_p('JTreeTable', 'Text', '40118', 'DATE,0')
select('JTreeTable', 'cell:DEPT-NO,0(60)')
assert_p('JTreeTable', 'Text', '5', 'QTY-SOLD,2')
select('JTreeTable', 'cell:SALE-PRICE,0(8.74)')
assert_p('JTreeTable', 'Text', '166.94', 'SALE-PRICE,1')
select('JTreeTable', 'cell:SALE-PRICE,1(166.94)')
assert_p('JTreeTable', 'Text', '166.94', 'SALE-PRICE,1')
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',1(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',1')
select_menu(commonBits.fl('Expand Tree'))
select('JTreeTable', 'cell:QTY-SOLD,2(8)')
assert_p('JTreeTable', 'Text', '5', 'QTY-SOLD,3')
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',2(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',2')
select_menu(commonBits.fl('Expand Tree'))
select('JTreeTable', 'cell:SALE-PRICE,3(12.99)')
assert_p('JTreeTable', 'Text', '12.99', 'SALE-PRICE,4')
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',14(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',14')
select_menu(commonBits.fl('Edit Record'))
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',14(null)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(
commonBits.fl('Window') + '>>DTAR020.bin>>' +
commonBits.fl('Table:'))
select_menu(
commonBits.fl('View') + '>>' + commonBits.fl('Execute Sort Tree'))
##select('FileChooser', commonBits.userDir() + 'SortTree' + commonBits.fileSep() + 'xx1')
commonBits.selectFileName(
select, keystroke,
commonBits.userDir() + 'SortTree' + commonBits.fileSep() + 'xx1')
##if commonBits.isJava7():
## keystroke('File Name', 'Enter')
click(commonBits.fl('Run Dialog'))
# select('List', 'DTAR020')
# select('List', 'DTAR020')
select('Table1', 'cell:' + commonBits.fl('Field') + ',1(STORE-NO)')
# select('List', 'DTAR020')
select('Table1', 'cell:' + commonBits.fl('Field') + ',1(STORE-NO)')
assert_p(
'Table1', 'Content', '[[KEYCODE-NO, ], [STORE-NO, ], [DATE, ' +
commonBits.fl('Maximum') + '], [DEPT-NO, ' +
commonBits.fl('Maximum') + '], [QTY-SOLD, ' +
commonBits.fl('Sum') + '], [SALE-PRICE, ' + commonBits.fl('Sum') +
']]')
select('Table1', 'cell:' + commonBits.fl('Field') + ',1(STORE-NO)')
select('Table', 'cell:' + commonBits.fl('Ascending') + ',0(true)')
select('Table1', 'cell:' + commonBits.fl('Field') + ',1(STORE-NO)')
select('Table', 'cell:' + commonBits.fl('Ascending') + ',0(false)')
select('Table1', 'cell:' + commonBits.fl('Field') + ',1(STORE-NO)')
assert_p(
'Table', 'Content',
'[[DEPT-NO, true], [DATE, true], [ , true], [ , true], [ , true]]')
select('Table1', 'cell:' + commonBits.fl('Field') + ',1(STORE-NO)')
click(commonBits.fl('Build Tree'))
select('JTreeTable', 'cell:SALE-PRICE,1(166.94)')
assert_p('JTreeTable', 'Text', '166.94', 'SALE-PRICE,1')
select('JTreeTable', 'cell:SALE-PRICE,5(150.26)')
assert_p('JTreeTable', 'Text', '150.26', 'SALE-PRICE,5')
close()