def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt') commonBits.setRecordLayout(select, 'utf8_ams Store') click('Edit1') select('Table', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)') rightclick('Table', '10 - 35|Loc Name,1') select_menu('Edit Record') ## select('Table1', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)') select('Table', 'cell:Data,3(VIC West Ad Support)') assert_p('Table', 'Text', 'VIC West Ad Support', 'Data,3') select('Table', 'cell:Data,3(VIC West Ad Support)') assert_p('Table', 'Text', 'cell:Data,3(VIC West Ad Support)') select('Table', 'cell:Data,3(VIC West Ad Support)') if commonBits.isMissingCol(): assert_p('Table', 'RowCount', '9') else: assert_p('Table', 'RowCount', '10') select('Table', 'cell:Data,3(VIC West Ad Support)') select('Table', 'cell:Data,4()') select('Table', 'cell:Data,4()') click('Right') click('Left') click('Left') select('Table', 'cell:Data,2(DC)') if commonBits.isMissingCol(): assert_p('Table', 'RowCount', '9') else: assert_p('Table', 'RowCount', '10') select('Table', 'cell:Data,2(DC)') assert_p('Table', 'ColumnCount', '5') select('Table', 'cell:Data,2(DC)') click('RightM') select('Table', 'cell:Data,3(Kalgoorlie (not yet open))') assert_p('Table', 'Text', 'Kalgoorlie (not yet open)', 'Data,3') select('Table', 'cell:Data,3(Kalgoorlie (not yet open))') click('LeftM') select('Table', 'cell:Data,3(DC - Taras Ave)') assert_p('Table', 'Text', 'DC - Taras Ave', 'Data,3') select('Table', 'cell:Data,3(DC - Taras Ave)') assert_p('Table', 'Text', 'cell:Data,3(DC - Taras Ave)') select('Table', 'cell:Data,3(DC - Taras Ave)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): click(commonBits.fl('Choose File')) if window('Open'): select(commonBits.selectPane(), 'utf8a_Ams_LocDownload_20041228.txt') click('Open') close() commonBits.setRecordLayout(select, 'utf8_ams Store') click(commonBits.fl('Edit') + '1') select('Table', 'cell:4 - 4|Loc Nbr,0(5839)') rightclick('Table', '4 - 4|Loc Nbr,0') select_menu( commonBits.fl('Edit Record')) click('Find') #click('MetalInternalFrameTitlePane', 194, 3) select('TextField', 'Shopping Centre') select('ComboBox1', commonBits.fl('Contains')) ##click('Find1') commonBits.find(click) select('Table', 'cell:' + commonBits.fl('Data') + ',3(Kalgoorlie (not yet open))') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5193, 5193], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Kalgoorlie (not yet open), Kalgoorlie (not yet open)], [Loc Addr Ln1, 45, 40, Shopping Centre, Shopping Centre], [Loc Addr Ln2, 85, 40, Cnr Cassidy and Egan Streets, Cnr Cassidy and Egan Streets], [Loc Addr Ln3, 125, 35, Kalgoorlie, Kalgoorlie], [Loc Postcode, 160, 10, 6430, 6430], [Loc State, 170, 3, WA, WA], [Loc Actv Ind, 173, 1, A, A]]') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:' + commonBits.fl('Data') + ',3(Kalgoorlie (not yet open))') select('ComboBox1', commonBits.fl('Contains')) select('ComboBox2', commonBits.fl('Backward')) commonBits.find(click) select('Table', 'cell:' + commonBits.fl('Data') + ',3(Carindale)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt') commonBits.setRecordLayout(select, 'utf8_ams Store') click('Edit1') select( 'Table', 'rows:[0,1,2,3,4,5,6,7],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type,10 - 35|Loc Name]' ) select_menu('View>>Column View #{Selected Records#}') ## select('Table2', 'rows:[0,1,2,3,4,5,6,7],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type,10 - 35|Loc Name]') select('Table', 'cell:Row 1,3(DC - Taras Ave)') assert_p('Table', 'Text', 'DC', 'Row 1,2') select('Table', 'cell:Row 2,3(VIC West Ad Support)') assert_p('Table', 'Text', 'VIC West Ad Support', 'Row 2,3') select('Table', 'cell:Row 3,3(NSW North Sydney Ad Support)') assert_p('Table', 'Text', 'VIC West Ad Support', 'Row 2,3') select('Table', 'cell:Row 2,5(Lot 2 Little Boundary Rd)') assert_p('Table', 'Text', 'Lot 2 Little Boundary Rd', 'Row 2,5') select('Table', 'cell:Row 1,5(30-68 Taras Ave)') ## assert_p('Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW], [A, A, A, A, A, A, A, A]]') if commonBits.isMissingCol(): ## assert_p('Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW]]') assert_p( 'Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW]]' ) assert_p( 'Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW], [A, A, A, A, A, A, A, A]]' ) else: assert_p( 'Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW], [A, A, A, A, A, A, A, A]]' ) select('Table', 'cell:Row 5,5(Unit 2, 39-41 Allingham Street)') assert_p('Table', 'Text', '58 Leland Street', 'Row 6,5') select('Table', 'cell:Row 6,5(58 Leland Street)') assert_p('Table', 'Text', 'Penrith', 'Row 6,6') select('Table', 'cell:Row 6,5(58 Leland Street)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select( 'Table', 'rows:[0,1,2,3,4,5,6,7],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type,10 - 35|Loc Name]' ) close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Record Editor'): click('Choose File') if window('Open'): select(commonBits.selectPane(), 'utf8a_Ams_LocDownload_20041228.txt') click('Open') close() commonBits.setRecordLayout(select, 'utf8_ams Store') click('Edit1') ## select('Table', 'rows:[0,1,2,3,4,5],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type]') select('Table', 'rows:[0,1,2,3,4,5],columns:[8 - 2|Loc Type]') select_menu('View>>Column View #{Selected Records#}') ## select('Table2', 'rows:[0,1,2,3,4,5],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type]') select('Table', 'cell:Row 1,0(TAR)') assert_p('Table1', 'Text', '3', 'Len,0') select('Table', 'cell:Row 1,1(5839)') ## assert_p('Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019], [DC, DC, DC, DC, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith], [, , , , Bankstown, Penrith], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street], [Altona North, Laverton, , , Condell Park, Penrith], [3025, 3028, , , 2200, 2750], [VIC, VIC, , , NSW, NSW], [A, A, A, A, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019], [DC, DC, DC, DC, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith], [, , , , Bankstown, Penrith], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street], [Altona North, Laverton, , , Condell Park, Penrith], [3025, 3028, , , 2200, 2750], [VIC, VIC, , , NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019], [DC, DC, DC, DC, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith], [, , , , Bankstown, Penrith], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street], [Altona North, Laverton, , , Condell Park, Penrith], [3025, 3028, , , 2200, 2750], [VIC, VIC, , , NSW, NSW], [A, A, A, A, A, A]]' ) select('Table', 'cell:Row 1,1(5839)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select('Table', 'rows:[0,1,2,3,4,5],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type]') select('Table', 'rows:[8,11,15],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type]') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt') commonBits.setRecordLayout(select, 'utf8_ams Store') click(commonBits.fl('Edit') + '1') click('Filter1') select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',0') select('Table1', '1', commonBits.fl('Value') + ',0') select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',1') select('Table1', '2', commonBits.fl('Value') + ',1') select('Table1', 'cell:' + commonBits.fl('Value') + ',1()') commonBits.filter(click) select('Table', 'cell:10 - 35|Loc Name,5(Strathpine - Not Yet Open)') assert_p('Table', 'Text', 'Strathpine - Not Yet Open', '10 - 35|Loc Name,5') select('Table', 'cell:10 - 35|Loc Name,6(Robina)') ## assert_p('Table', 'Content', '[[TAR, 5129, ST, Macquarie, Maquarie Centre, Dock 2, Talavera Road, North Ryde, 2113, NSW, A], [TAR, 5162, ST, Tuggeranong, Hyperdome Shopping Centre, Pitman Street, Tuggernong, 2900, NSW, A], [TAR, 5012, ST, Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, A], [TAR, 5152, ST, Mornington, Mornington, Cnr Franklin & Gordon Streets, Momington, 3931, VIC, A], [TAR, 5132, ST, Glenorchy, Derwent Park, Lot 12-13 Riverside Industrial Estate, Derwent park, 7009, TAS, A], [TAR, 5172, ST, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, , Strathpine, 4032, QLD, A], [TAR, 5126, ST, Robina, Robina Town Centre, Robina Parkway, Robina, 4226, QLD, A], [TAR, 5021, ST, Tea Tree Plaza, Myer Tea Tree Plaza, 976 North East Road, Modbury, 5092, SA, A], [TAR, 5127, ST, Marion, Adelaide Airport, Frank Collopy Court, Adelaide Airport, 5950, SA, A], [TAR, 5142, ST, Hollywood Plaza, Hollywood Plaza Shopping Centre, Winzor Road, Salisbury Downs, 5108, SA, A], [TAR, 5128, ST, Rockingham, Rockingham Shopping Centre., Cnr. Read Street & Council Avenue, Rockingham, 6168, WA, A], [TAR, 5192, ST, Wetherill Park, , , , , , A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[TAR, 5129, ST, Macquarie, Maquarie Centre, Dock 2, Talavera Road, North Ryde, 2113, NSW], [TAR, 5162, ST, Tuggeranong, Hyperdome Shopping Centre, Pitman Street, Tuggernong, 2900, NSW], [TAR, 5012, ST, Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC], [TAR, 5152, ST, Mornington, Mornington, Cnr Franklin & Gordon Streets, Momington, 3931, VIC], [TAR, 5132, ST, Glenorchy, Derwent Park, Lot 12-13 Riverside Industrial Estate, Derwent park, 7009, TAS], [TAR, 5172, ST, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, , Strathpine, 4032, QLD], [TAR, 5126, ST, Robina, Robina Town Centre, Robina Parkway, Robina, 4226, QLD], [TAR, 5021, ST, Tea Tree Plaza, Myer Tea Tree Plaza, 976 North East Road, Modbury, 5092, SA], [TAR, 5127, ST, Marion, Adelaide Airport, Frank Collopy Court, Adelaide Airport, 5950, SA], [TAR, 5142, ST, Hollywood Plaza, Hollywood Plaza Shopping Centre, Winzor Road, Salisbury Downs, 5108, SA], [TAR, 5128, ST, Rockingham, Rockingham Shopping Centre., Cnr. Read Street & Council Avenue, Rockingham, 6168, WA], [TAR, 5192, ST, Wetherill Park, , , , , ]]' ) else: assert_p( 'Table', 'Content', '[[TAR, 5129, ST, Macquarie, Maquarie Centre, Dock 2, Talavera Road, North Ryde, 2113, NSW, A], [TAR, 5162, ST, Tuggeranong, Hyperdome Shopping Centre, Pitman Street, Tuggernong, 2900, NSW, A], [TAR, 5012, ST, Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, A], [TAR, 5152, ST, Mornington, Mornington, Cnr Franklin & Gordon Streets, Momington, 3931, VIC, A], [TAR, 5132, ST, Glenorchy, Derwent Park, Lot 12-13 Riverside Industrial Estate, Derwent park, 7009, TAS, A], [TAR, 5172, ST, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, , Strathpine, 4032, QLD, A], [TAR, 5126, ST, Robina, Robina Town Centre, Robina Parkway, Robina, 4226, QLD, A], [TAR, 5021, ST, Tea Tree Plaza, Myer Tea Tree Plaza, 976 North East Road, Modbury, 5092, SA, A], [TAR, 5127, ST, Marion, Adelaide Airport, Frank Collopy Court, Adelaide Airport, 5950, SA, A], [TAR, 5142, ST, Hollywood Plaza, Hollywood Plaza Shopping Centre, Winzor Road, Salisbury Downs, 5108, SA, A], [TAR, 5128, ST, Rockingham, Rockingham Shopping Centre., Cnr. Read Street & Council Avenue, Rockingham, 6168, WA, A], [TAR, 5192, ST, Wetherill Park, , , , , , A]]' ) select('Table', 'cell:10 - 35|Loc Name,7(Tea Tree Plaza)') assert_p('Table', 'RowCount', '12') select('Table', 'cell:10 - 35|Loc Name,7(Tea Tree Plaza)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): from Modules import commonBits click('Choose File') if window('Open'): select(commonBits.selectPane(), 'utf8a_Ams_LocDownload_20041228.txt') click('Open') close() commonBits.setRecordLayout(select, 'utf8_ams Store') click('Edit1') select('Table', 'cell:4 - 4|Loc Nbr,0(5839)') rightclick('Table', '4 - 4|Loc Nbr,4') select_menu('Edit Record') select('Table', 'cell:Data,3(Bankstown)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:Data,3(Bankstown)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') click('Choose File') if window('Open'): select(commonBits.selectPane(), 'utf8a_Ams_PODownload_20041231.txt') click('Open') close() commonBits.setRecordLayout(select, 'utf8_ams PO Download') commonBits.doEdit(click) commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') click('Choose File') if window('Open'): select(commonBits.selectPane(), 'utf8a_Ams_LocDownload_20041228.txt') click('Open') close() ##assert_p('ComboBox2', 'Text', 'ams Store') click('Edit1') select('Table', 'cell:4 - 4|Loc Nbr,0(5839)') rightclick('Table', '10 - 35|Loc Name,5') select_menu('Edit Record') select('Table', 'cell:Data,4(Penrith)') assert_p('Table', 'Text', 'Penrith', 'Data,4') select('Table', 'cell:Data,4(Penrith)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt') commonBits.setRecordLayout(select, 'utf8_ams Store') click('Edit1') click('Filter1') click('Filter1') select('Table', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)') assert_p('Table', 'Text', 'VIC West Ad Support', '10 - 35|Loc Name,1') select('Table', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)') select_menu('Data>>Sort') # select('Table1', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)') # select('List', 'utf8_ams Store') select('Table', 'cell:Field,0( )') click('ScrollPane$ScrollBar', 9, 108) select('Table', 'Loc State', 'Field,0') select('Table', 'Loc Nbr', 'Field,1') select('Table', 'cell:Field,1(Loc Nbr)') click('Sort1') select('Table', 'cell:10 - 35|Loc Name,0(National Ad Support)') assert_p('Table', 'Text', 'cell:10 - 35|Loc Name,0(National Ad Support)') select('Table', 'cell:10 - 35|Loc Name,12(Canberra Civic)') assert_p('Table', 'Text', 'cell:10 - 35|Loc Name,12(Canberra Civic)') select('Table', 'cell:10 - 35|Loc Name,12(Canberra Civic)') rightclick('Table', '10 - 35|Loc Name,12') select_menu('Edit Record') select('Table', 'cell:Data,2(ST)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5096, 5096], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Canberra Civic, Canberra Civic], [Loc Addr Ln1, 45, 40, Target Canberra, Target Canberra], [Loc Addr Ln2, 85, 40, Canberra City Centre, Akuna Ave, Canberra City Centre, Akuna Ave], [Loc Addr Ln3, 125, 35, Canberra, Canberra], [Loc Postcode, 160, 10, 2601, 2601], [Loc State, 170, 3, ACT, ACT]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5096, 5096], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Canberra Civic, Canberra Civic], [Loc Addr Ln1, 45, 40, Target Canberra, Target Canberra], [Loc Addr Ln2, 85, 40, Canberra City Centre, Akuna Ave, Canberra City Centre, Akuna Ave], [Loc Addr Ln3, 125, 35, Canberra, Canberra], [Loc Postcode, 160, 10, 2601, 2601], [Loc State, 170, 3, ACT, ACT], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,2(ST)') click('Right') select('Table', 'cell:Data,4(Coffs Harbour)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5002, 5002], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Coffs Harbour, Coffs Harbour], [Loc Addr Ln1, 45, 40, Coffs Harbour, Coffs Harbour], [Loc Addr Ln2, 85, 40, Cnr. Park Beach Road & Pacific Hwy, Cnr. Park Beach Road & Pacific Hwy], [Loc Addr Ln3, 125, 35, Coffs Harbour, Coffs Harbour], [Loc Postcode, 160, 10, 2450, 2450], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5002, 5002], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Coffs Harbour, Coffs Harbour], [Loc Addr Ln1, 45, 40, Coffs Harbour, Coffs Harbour], [Loc Addr Ln2, 85, 40, Cnr. Park Beach Road & Pacific Hwy, Cnr. Park Beach Road & Pacific Hwy], [Loc Addr Ln3, 125, 35, Coffs Harbour, Coffs Harbour], [Loc Postcode, 160, 10, 2450, 2450], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,4(Coffs Harbour)') click('Right') select('Table', 'cell:Data,4(Albury)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5005, 5005], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Albury, Albury], [Loc Addr Ln1, 45, 40, Albury, Albury], [Loc Addr Ln2, 85, 40, Kiewa Street, Kiewa Street], [Loc Addr Ln3, 125, 35, Albury, Albury], [Loc Postcode, 160, 10, 2640, 2640], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5005, 5005], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Albury, Albury], [Loc Addr Ln1, 45, 40, Albury, Albury], [Loc Addr Ln2, 85, 40, Kiewa Street, Kiewa Street], [Loc Addr Ln3, 125, 35, Albury, Albury], [Loc Postcode, 160, 10, 2640, 2640], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,4(Albury)') click('RightM') select('Table', 'cell:Data,5(Cnr Nicholson & Bannister Rd\'s)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5965, 5965], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, Canning Vale DC, Canning Vale DC], [Loc Addr Ln1, 45, 40, Canning Vale DC, Canning Vale DC], [Loc Addr Ln2, 85, 40, Cnr Nicholson & Bannister Rd\'s, Cnr Nicholson & Bannister Rd\'s], [Loc Addr Ln3, 125, 35, Canning Vale, Canning Vale], [Loc Postcode, 160, 10, 6155, 6155], [Loc State, 170, 3, WA, WA]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5965, 5965], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, Canning Vale DC, Canning Vale DC], [Loc Addr Ln1, 45, 40, Canning Vale DC, Canning Vale DC], [Loc Addr Ln2, 85, 40, Cnr Nicholson & Bannister Rd\'s, Cnr Nicholson & Bannister Rd\'s], [Loc Addr Ln3, 125, 35, Canning Vale, Canning Vale], [Loc Postcode, 160, 10, 6155, 6155], [Loc State, 170, 3, WA, WA], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,5(Cnr Nicholson & Bannister Rd\'s)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select('Table', 'cell:10 - 35|Loc Name,12(Canberra Civic)') rightclick('Table', '10 - 35|Loc Name,4') select_menu('Sort') # select('List', 'utf8_ams Store') select('Table', 'Loc Type', 'Field,0') select('Table', 'Loc Nbr', 'Field,1') select('Table', 'cell:Field,1(Loc Nbr)') click('Sort1') select('Table', 'cell:10 - 35|Loc Name,0(National Ad Support)') assert_p('Table', 'Text', 'National Ad Support', '10 - 35|Loc Name,0') select('Table', 'cell:10 - 35|Loc Name,0(National Ad Support)') rightclick('Table', '10 - 35|Loc Name,0') select_menu('Edit Record') ## select('Table1', 'cell:10 - 35|Loc Name,0(National Ad Support)') select('Table', 'cell:Data,3(National Ad Support)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5109, 5109], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, National Ad Support, National Ad Support], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5109, 5109], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, National Ad Support, National Ad Support], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,3(National Ad Support)') click('Right') select('Table', 'cell:Data,3(Head Office)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5700, 5700], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, Head Office, Head Office], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5700, 5700], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, Head Office, Head Office], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,3(Head Office)') click('Right') select('Table', 'cell:Data,5(30-68 Taras Ave)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5839, 5839], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, DC - Taras Ave, DC - Taras Ave], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, 30-68 Taras Ave, 30-68 Taras Ave], [Loc Addr Ln3, 125, 35, Altona North, Altona North], [Loc Postcode, 160, 10, 3025, 3025], [Loc State, 170, 3, VIC, VIC]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5839, 5839], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, DC - Taras Ave, DC - Taras Ave], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, 30-68 Taras Ave, 30-68 Taras Ave], [Loc Addr Ln3, 125, 35, Altona North, Altona North], [Loc Postcode, 160, 10, 3025, 3025], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,5(30-68 Taras Ave)') click('Right') click('Right') click('Right') click('Right') click('Right') click('Right') click('Right') select('Table', 'cell:Data,4(No 2 Sydney Gate)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5897, 5897], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, Sydney Gate DC, Sydney Gate DC], [Loc Addr Ln1, 45, 40, No 2 Sydney Gate, No 2 Sydney Gate], [Loc Addr Ln2, 85, 40, 830 Bourke Street, 830 Bourke Street], [Loc Addr Ln3, 125, 35, Waterloo, Waterloo], [Loc Postcode, 160, 10, 2017, 2017], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5897, 5897], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, Sydney Gate DC, Sydney Gate DC], [Loc Addr Ln1, 45, 40, No 2 Sydney Gate, No 2 Sydney Gate], [Loc Addr Ln2, 85, 40, 830 Bourke Street, 830 Bourke Street], [Loc Addr Ln3, 125, 35, Waterloo, Waterloo], [Loc Postcode, 160, 10, 2017, 2017], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,4(No 2 Sydney Gate)') click('RightM') select('Table', 'cell:Data,5(Cnr Grove Way & Golden Grove)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5305, 5305], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Golden Grove, Golden Grove], [Loc Addr Ln1, 45, 40, The Golden Way, The Golden Way], [Loc Addr Ln2, 85, 40, Cnr Grove Way & Golden Grove, Cnr Grove Way & Golden Grove], [Loc Addr Ln3, 125, 35, Golden Grove, Golden Grove], [Loc Postcode, 160, 10, 5125, 5125], [Loc State, 170, 3, SOU, SOU]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5305, 5305], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Golden Grove, Golden Grove], [Loc Addr Ln1, 45, 40, The Golden Way, The Golden Way], [Loc Addr Ln2, 85, 40, Cnr Grove Way & Golden Grove, Cnr Grove Way & Golden Grove], [Loc Addr Ln3, 125, 35, Golden Grove, Golden Grove], [Loc Postcode, 160, 10, 5125, 5125], [Loc State, 170, 3, SOU, SOU], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,5(Cnr Grove Way & Golden Grove)') click('Left') select('Table', 'cell:Data,5(2-50 Murray Road)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5304, 5304], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Northland Baby Target, Northland Baby Target], [Loc Addr Ln1, 45, 40, Northland Shopping Centre, Northland Shopping Centre], [Loc Addr Ln2, 85, 40, 2-50 Murray Road, 2-50 Murray Road], [Loc Addr Ln3, 125, 35, East Preston, East Preston], [Loc Postcode, 160, 10, 3072, 3072], [Loc State, 170, 3, VIC, VIC]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5304, 5304], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Northland Baby Target, Northland Baby Target], [Loc Addr Ln1, 45, 40, Northland Shopping Centre, Northland Shopping Centre], [Loc Addr Ln2, 85, 40, 2-50 Murray Road, 2-50 Murray Road], [Loc Addr Ln3, 125, 35, East Preston, East Preston], [Loc Postcode, 160, 10, 3072, 3072], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,5(2-50 Murray Road)') click('Left') select('Table', 'cell:Data,5(Gilchrist Drive)') assert_p('Table', 'Text', 'Gilchrist Drive', 'Data,5') select('Table', 'cell:Data,5(Gilchrist Drive)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5303, 5303], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Macarthur Square, Macarthur Square], [Loc Addr Ln1, 45, 40, Macarthur Square, Macarthur Square], [Loc Addr Ln2, 85, 40, Gilchrist Drive, Gilchrist Drive], [Loc Addr Ln3, 125, 35, Campbelltown, Campbelltown], [Loc Postcode, 160, 10, 2560, 2560], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5303, 5303], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Macarthur Square, Macarthur Square], [Loc Addr Ln1, 45, 40, Macarthur Square, Macarthur Square], [Loc Addr Ln2, 85, 40, Gilchrist Drive, Gilchrist Drive], [Loc Addr Ln3, 125, 35, Campbelltown, Campbelltown], [Loc Postcode, 160, 10, 2560, 2560], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,5(Gilchrist Drive)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt') commonBits.setRecordLayout(select, 'utf8_ams Store') click('Edit1') click('Find1') #click('MetalInternalFrameTitlePane', 199, 13) select('TextField', 'West') select('TextField1', 'West_') select('ComboBox', 'Loc Addr Ln1') click('Replace All') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select('Table', 'cell:45 - 40|Loc Addr Ln1,0()') rightclick('Table', '4 - 4|Loc Nbr,0') select_menu('Edit Record') click('Find1') #click('MetalInternalFrameTitlePane', 211, 10) select('TextField', 'West_') ##click('Find1') commonBits.find(click) select('Table', 'cell:Data,4(West_field Shoppingtown)') select('Table', 'cell:Data,4(West_field Shoppingtown)') assert_p('Table', 'Text', 'Cnr. Urunga Pde & The Kingsway', 'Data,5') select('Table', 'cell:Data,4(West_field Shoppingtown)') select('Table', 'cell:Data,5(Cnr. Urunga Pde & The Kingsway)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5037, 5037], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Miranda, Miranda], [Loc Addr Ln1, 45, 40, West_field Shoppingtown, West_field Shoppingtown], [Loc Addr Ln2, 85, 40, Cnr. Urunga Pde & The Kingsway, Cnr. Urunga Pde & The Kingsway], [Loc Addr Ln3, 125, 35, Miranda, Miranda], [Loc Postcode, 160, 10, 2228, 2228], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5037, 5037], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Miranda, Miranda], [Loc Addr Ln1, 45, 40, West_field Shoppingtown, West_field Shoppingtown], [Loc Addr Ln2, 85, 40, Cnr. Urunga Pde & The Kingsway, Cnr. Urunga Pde & The Kingsway], [Loc Addr Ln3, 125, 35, Miranda, Miranda], [Loc Postcode, 160, 10, 2228, 2228], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5037, 5037], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Miranda, Miranda], [Loc Addr Ln1, 45, 40, West_field Shoppingtown, West_field Shoppingtown], [Loc Addr Ln2, 85, 40, Cnr. Urunga Pde & The Kingsway, Cnr. Urunga Pde & The Kingsway], [Loc Addr Ln3, 125, 35, Miranda, Miranda], [Loc Postcode, 160, 10, 2228, 2228], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5037, 5037], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Miranda, Miranda], [Loc Addr Ln1, 45, 40, West_field Shoppingtown, West_field Shoppingtown], [Loc Addr Ln2, 85, 40, Cnr. Urunga Pde & The Kingsway, Cnr. Urunga Pde & The Kingsway], [Loc Addr Ln3, 125, 35, Miranda, Miranda], [Loc Postcode, 160, 10, 2228, 2228], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:Data,5(Cnr. Urunga Pde & The Kingsway)') click('Find1') select('TextField', 'West_') ##click('Find1') commonBits.find(click) select('Table', 'cell:Data,4(West_field Phoenix Plaza)') assert_p('Table', 'Text', 'Northumberland Street', 'Data,5') select('Table', 'cell:Data,5(Northumberland Street)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5093, 5093], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Liverpool, Liverpool], [Loc Addr Ln1, 45, 40, West_field Phoenix Plaza, West_field Phoenix Plaza], [Loc Addr Ln2, 85, 40, Northumberland Street, Northumberland Street], [Loc Addr Ln3, 125, 35, Liverpool, Liverpool], [Loc Postcode, 160, 10, 2170, 2170], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5093, 5093], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Liverpool, Liverpool], [Loc Addr Ln1, 45, 40, West_field Phoenix Plaza, West_field Phoenix Plaza], [Loc Addr Ln2, 85, 40, Northumberland Street, Northumberland Street], [Loc Addr Ln3, 125, 35, Liverpool, Liverpool], [Loc Postcode, 160, 10, 2170, 2170], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5093, 5093], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Liverpool, Liverpool], [Loc Addr Ln1, 45, 40, West_field Phoenix Plaza, West_field Phoenix Plaza], [Loc Addr Ln2, 85, 40, Northumberland Street, Northumberland Street], [Loc Addr Ln3, 125, 35, Liverpool, Liverpool], [Loc Postcode, 160, 10, 2170, 2170], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5093, 5093], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Liverpool, Liverpool], [Loc Addr Ln1, 45, 40, West_field Phoenix Plaza, West_field Phoenix Plaza], [Loc Addr Ln2, 85, 40, Northumberland Street, Northumberland Street], [Loc Addr Ln3, 125, 35, Liverpool, Liverpool], [Loc Postcode, 160, 10, 2170, 2170], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:Data,5(Northumberland Street)') click('Find1') select('TextField', 'West_') ##click('Find1') commonBits.find(click) select('Table', 'cell:Data,4(West_field Shoppingtown Eastgardens)') assert_p('Table', 'Text', 'cell:Data,4(West_field Shoppingtown Eastgardens)') select('Table', 'cell:Data,5(152 Bunnerong Road)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5095, 5095], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Eastgarden, Eastgarden], [Loc Addr Ln1, 45, 40, West_field Shoppingtown Eastgardens, West_field Shoppingtown Eastgardens], [Loc Addr Ln2, 85, 40, 152 Bunnerong Road, 152 Bunnerong Road], [Loc Addr Ln3, 125, 35, Eastgardens, Eastgardens], [Loc Postcode, 160, 10, 2036, 2036], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5095, 5095], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Eastgarden, Eastgarden], [Loc Addr Ln1, 45, 40, West_field Shoppingtown Eastgardens, West_field Shoppingtown Eastgardens], [Loc Addr Ln2, 85, 40, 152 Bunnerong Road, 152 Bunnerong Road], [Loc Addr Ln3, 125, 35, Eastgardens, Eastgardens], [Loc Postcode, 160, 10, 2036, 2036], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5095, 5095], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Eastgarden, Eastgarden], [Loc Addr Ln1, 45, 40, West_field Shoppingtown Eastgardens, West_field Shoppingtown Eastgardens], [Loc Addr Ln2, 85, 40, 152 Bunnerong Road, 152 Bunnerong Road], [Loc Addr Ln3, 125, 35, Eastgardens, Eastgardens], [Loc Postcode, 160, 10, 2036, 2036], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5095, 5095], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Eastgarden, Eastgarden], [Loc Addr Ln1, 45, 40, West_field Shoppingtown Eastgardens, West_field Shoppingtown Eastgardens], [Loc Addr Ln2, 85, 40, 152 Bunnerong Road, 152 Bunnerong Road], [Loc Addr Ln3, 125, 35, Eastgardens, Eastgardens], [Loc Postcode, 160, 10, 2036, 2036], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:Data,5(152 Bunnerong Road)') click('Find1') select('TextField', 'West_') ##click('Find1') commonBits.find(click) select('Table', 'cell:Data,4(West_field Shopping Centre)') assert_p('Table', 'Text', 'George Street', 'Data,5') select('Table', 'cell:Data,6(Hornsby)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, West_field Shopping Centre, West_field Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, West_field Shopping Centre, West_field Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, West_field Shopping Centre, West_field Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, West_field Shopping Centre, West_field Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:Data,6(Hornsby)') click('Find1') select('TextField', 'West_') ##click('Find1') commonBits.find(click) select('Table', 'cell:Data,4(West_ Point Shopping Ctr)') assert_p('Table', 'Text', 'cell:Data,4(West_ Point Shopping Ctr)') select('Table', 'cell:Data,5(Balmoral Street)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5178, 5178], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Blacktown - Not Yet Open, Blacktown - Not Yet Open], [Loc Addr Ln1, 45, 40, West_ Point Shopping Ctr, West_ Point Shopping Ctr], [Loc Addr Ln2, 85, 40, Balmoral Street, Balmoral Street], [Loc Addr Ln3, 125, 35, Blacktown, Blacktown], [Loc Postcode, 160, 10, 2134, 2134], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5178, 5178], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Blacktown - Not Yet Open, Blacktown - Not Yet Open], [Loc Addr Ln1, 45, 40, West_ Point Shopping Ctr, West_ Point Shopping Ctr], [Loc Addr Ln2, 85, 40, Balmoral Street, Balmoral Street], [Loc Addr Ln3, 125, 35, Blacktown, Blacktown], [Loc Postcode, 160, 10, 2134, 2134], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5178, 5178], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Blacktown - Not Yet Open, Blacktown - Not Yet Open], [Loc Addr Ln1, 45, 40, West_ Point Shopping Ctr, West_ Point Shopping Ctr], [Loc Addr Ln2, 85, 40, Balmoral Street, Balmoral Street], [Loc Addr Ln3, 125, 35, Blacktown, Blacktown], [Loc Postcode, 160, 10, 2134, 2134], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5178, 5178], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Blacktown - Not Yet Open, Blacktown - Not Yet Open], [Loc Addr Ln1, 45, 40, West_ Point Shopping Ctr, West_ Point Shopping Ctr], [Loc Addr Ln2, 85, 40, Balmoral Street, Balmoral Street], [Loc Addr Ln3, 125, 35, Blacktown, Blacktown], [Loc Postcode, 160, 10, 2134, 2134], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:Data,5(Balmoral Street)') click('Find1') select('TextField', 'West_') ##click('Find1') commonBits.find(click) select('Table', 'cell:Data,4(West_field Shoppingtown)') assert_p('Table', 'Text', 'cell:Data,4(West_field Shoppingtown)') select('Table', 'cell:Data,5(Matthews Avenue)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5168, 5168], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Airport West, Airport West], [Loc Addr Ln1, 45, 40, West_field Shoppingtown, West_field Shoppingtown], [Loc Addr Ln2, 85, 40, Matthews Avenue, Matthews Avenue], [Loc Addr Ln3, 125, 35, Airport West, Airport West], [Loc Postcode, 160, 10, 3042, 3042], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5168, 5168], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Airport West, Airport West], [Loc Addr Ln1, 45, 40, West_field Shoppingtown, West_field Shoppingtown], [Loc Addr Ln2, 85, 40, Matthews Avenue, Matthews Avenue], [Loc Addr Ln3, 125, 35, Airport West, Airport West], [Loc Postcode, 160, 10, 3042, 3042], [Loc State, 170, 3, VIC, VIC]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5168, 5168], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Airport West, Airport West], [Loc Addr Ln1, 45, 40, West_field Shoppingtown, West_field Shoppingtown], [Loc Addr Ln2, 85, 40, Matthews Avenue, Matthews Avenue], [Loc Addr Ln3, 125, 35, Airport West, Airport West], [Loc Postcode, 160, 10, 3042, 3042], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]' ) ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5168, 5168], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Airport West, Airport West], [Loc Addr Ln1, 45, 40, West_field Shoppingtown, West_field Shoppingtown], [Loc Addr Ln2, 85, 40, Matthews Avenue, Matthews Avenue], [Loc Addr Ln3, 125, 35, Airport West, Airport West], [Loc Postcode, 160, 10, 3042, 3042], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:Data,5(Matthews Avenue)') click('Find1') select('TextField', 'West_') select('ComboBox2', 'Backward') assert_p('ComboBox2', 'Text', 'Backward') ##click('Find1') commonBits.find(click) select('Table', 'cell:Data,4(West_ Point Shopping Ctr)') assert_p('Table', 'Text', 'cell:Data,4(West_ Point Shopping Ctr)') select('Table', 'cell:Data,5(Balmoral Street)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5178, 5178], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Blacktown - Not Yet Open, Blacktown - Not Yet Open], [Loc Addr Ln1, 45, 40, West_ Point Shopping Ctr, West_ Point Shopping Ctr], [Loc Addr Ln2, 85, 40, Balmoral Street, Balmoral Street], [Loc Addr Ln3, 125, 35, Blacktown, Blacktown], [Loc Postcode, 160, 10, 2134, 2134], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5178, 5178], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Blacktown - Not Yet Open, Blacktown - Not Yet Open], [Loc Addr Ln1, 45, 40, West_ Point Shopping Ctr, West_ Point Shopping Ctr], [Loc Addr Ln2, 85, 40, Balmoral Street, Balmoral Street], [Loc Addr Ln3, 125, 35, Blacktown, Blacktown], [Loc Postcode, 160, 10, 2134, 2134], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5178, 5178], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Blacktown - Not Yet Open, Blacktown - Not Yet Open], [Loc Addr Ln1, 45, 40, West_ Point Shopping Ctr, West_ Point Shopping Ctr], [Loc Addr Ln2, 85, 40, Balmoral Street, Balmoral Street], [Loc Addr Ln3, 125, 35, Blacktown, Blacktown], [Loc Postcode, 160, 10, 2134, 2134], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,4(West_ Point Shopping Ctr)') click('Find1') select('TextField', 'West_') ##click('Find1') commonBits.find(click) select('Table', 'cell:Data,4(West_field Shopping Centre)') assert_p('Table', 'Text', 'cell:Data,4(West_field Shopping Centre)') select('Table', 'cell:Data,5(George Street)') ## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, West_field Shopping Centre, West_field Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, West_field Shopping Centre, West_field Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW]]' ) else: select('Table', 'cell:Data,5(George Street)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') ## click('BasicInternalFrameTitlePane$NoFocusButton5') #select('Table', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)') #click('MetalInternalFrameTitlePane', 396, 14) #click('BasicInternalFrameTitlePane$NoFocusButton2') #close() if window('Save Changes to file: ' + commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt'): click('No') close() close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt') commonBits.setRecordLayout(select, 'utf8_ams Store') click(commonBits.fl('Edit') + '1') click('Filter1') select('Table', 'false', commonBits.fl('Include') + ',0') select('Table', 'false', commonBits.fl('Include') + ',2') select('Table', 'false', commonBits.fl('Include') + ',5') select('Table', 'false', commonBits.fl('Include') + ',6') select('Table', 'false', commonBits.fl('Include') + ',7') #select('Table1', 'cell:' + commonBits.fl('Include') + ',7(false)') select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',0') select('Table1', '1', commonBits.fl('Value') + ',0') select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',1') select('Table1', '2', commonBits.fl('Value') + ',1') select('Table1', 'cell:' + commonBits.fl('Value') + ',1()') commonBits.filter(click) select('Table', 'cell:45 - 40|Loc Addr Ln1,4(Derwent Park)') assert_p('Table', 'Text', 'Derwent Park', '45 - 40|Loc Addr Ln1,4') select( 'Table', 'cell:45 - 40|Loc Addr Ln1,5(Chermside Shopping Centre, G ie Rd)') ## assert_p('Table', 'Content', '[[5129, Macquarie, Maquarie Centre, NSW, A], [5162, Tuggeranong, Hyperdome Shopping Centre, NSW, A], [5012, Ringwood, Ringwood, VIC, A], [5152, Mornington, Mornington, VIC, A], [5132, Glenorchy, Derwent Park, TAS, A], [5172, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, QLD, A], [5126, Robina, Robina Town Centre, QLD, A], [5021, Tea Tree Plaza, Myer Tea Tree Plaza, SA, A], [5127, Marion, Adelaide Airport, SA, A], [5142, Hollywood Plaza, Hollywood Plaza Shopping Centre, SA, A], [5128, Rockingham, Rockingham Shopping Centre., WA, A], [5192, Wetherill Park, , , A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[5129, Macquarie, Maquarie Centre, NSW], [5162, Tuggeranong, Hyperdome Shopping Centre, NSW], [5012, Ringwood, Ringwood, VIC], [5152, Mornington, Mornington, VIC], [5132, Glenorchy, Derwent Park, TAS], [5172, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, QLD], [5126, Robina, Robina Town Centre, QLD], [5021, Tea Tree Plaza, Myer Tea Tree Plaza, SA], [5127, Marion, Adelaide Airport, SA], [5142, Hollywood Plaza, Hollywood Plaza Shopping Centre, SA], [5128, Rockingham, Rockingham Shopping Centre., WA], [5192, Wetherill Park, , ]]' ) else: assert_p( 'Table', 'Content', '[[5129, Macquarie, Maquarie Centre, NSW, A], [5162, Tuggeranong, Hyperdome Shopping Centre, NSW, A], [5012, Ringwood, Ringwood, VIC, A], [5152, Mornington, Mornington, VIC, A], [5132, Glenorchy, Derwent Park, TAS, A], [5172, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, QLD, A], [5126, Robina, Robina Town Centre, QLD, A], [5021, Tea Tree Plaza, Myer Tea Tree Plaza, SA, A], [5127, Marion, Adelaide Airport, SA, A], [5142, Hollywood Plaza, Hollywood Plaza Shopping Centre, SA, A], [5128, Rockingham, Rockingham Shopping Centre., WA, A], [5192, Wetherill Park, , , A]]' ) select('Table', 'cell:45 - 40|Loc Addr Ln1,7(Myer Tea Tree Plaza)') assert_p('Table', 'RowCount', '12') select('Table', 'cell:10 - 35|Loc Name,2(Ringwood)') rightclick('Table', '10 - 35|Loc Name,2') select_menu(commonBits.fl('Edit Record')) ## select('Table1', 'cell:10 - 35|Loc Name,2(Ringwood)') select('Table', 'cell:' + commonBits.fl('Data') + ',1(Ringwood)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Loc Nbr, 4, 4, 5012, 5012], [Loc Name, 10, 35, Ringwood, Ringwood], [Loc Addr Ln1, 45, 40, Ringwood, Ringwood], [Loc State, 170, 3, VIC, VIC]]' ) else: assert_p( 'Table', 'Content', '[[Loc Nbr, 4, 4, 5012, 5012], [Loc Name, 10, 35, Ringwood, Ringwood], [Loc Addr Ln1, 45, 40, Ringwood, Ringwood], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:' + commonBits.fl('Data') + ',3(VIC)') assert_p('Table', 'Text', 'VIC', commonBits.fl('Data') + ',3') select('Table', 'cell:' + commonBits.fl('Data') + ',2(Ringwood)') if commonBits.isMissingCol(): assert_p('Table', 'RowCount', '4') else: assert_p('Table', 'RowCount', '5') close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt') commonBits.setRecordLayout(select, 'utf8_ams Store') click(commonBits.fl('Edit') + '1') click('Filter1') select('Table1', 'Loc Type', commonBits.fl('Field') + ',0') select('Table1', ' = ', commonBits.fl('Operator') + ',0') select('Table1', 'dc', commonBits.fl('Value') + ',0') select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',1') select('Table1', '8', commonBits.fl('Value') + ',1') select('Table1', 'cell:' + commonBits.fl('Value') + ',1()') select('Table', 'false', commonBits.fl('Include') + ',0') select('Table', 'false', commonBits.fl('Include') + ',2') select('Table', 'false', commonBits.fl('Include') + ',7') select('Table', 'false', commonBits.fl('Include') + ',6') select('Table', 'false', commonBits.fl('Include') + ',5') #select('Table1', 'cell:' + commonBits.fl('Include') + ',5(false)') commonBits.filter(click) select('Table', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)') ## assert_p('Table', 'Content', '[[5839, DC - Taras Ave, , VIC, A], [5850, VIC West Ad Support, , VIC, A], [5853, NSW North Sydney Ad Support, , , A], [5866, WA Ad Support, , , A], [5887, QLD Ad Support, , , A], [5888, SA Ad Support, , , A], [5895, VIC East Ad Support, , , A], [5897, Sydney Gate DC, No 2 Sydney Gate, NSW, A], [5958, State Warehouse WA, Target State Warehouse (WA) FCL, WA, A], [5968, Beverly DC, Beverly DC, SA, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[5839, DC - Taras Ave, , VIC], [5850, VIC West Ad Support, , VIC], [5853, NSW North Sydney Ad Support, , ], [5866, WA Ad Support, , ], [5887, QLD Ad Support, , ], [5888, SA Ad Support, , ], [5895, VIC East Ad Support, , ], [5897, Sydney Gate DC, No 2 Sydney Gate, NSW], [5958, State Warehouse WA, Target State Warehouse (WA) FCL, WA], [5968, Beverly DC, Beverly DC, SA]]' ) else: assert_p( 'Table', 'Content', '[[5839, DC - Taras Ave, , VIC, A], [5850, VIC West Ad Support, , VIC, A], [5853, NSW North Sydney Ad Support, , , A], [5866, WA Ad Support, , , A], [5887, QLD Ad Support, , , A], [5888, SA Ad Support, , , A], [5895, VIC East Ad Support, , , A], [5897, Sydney Gate DC, No 2 Sydney Gate, NSW, A], [5958, State Warehouse WA, Target State Warehouse (WA) FCL, WA, A], [5968, Beverly DC, Beverly DC, SA, A]]' ) select('Table', 'cell:10 - 35|Loc Name,7(Sydney Gate DC)') assert_p('Table', 'Text', 'cell:10 - 35|Loc Name,7(Sydney Gate DC)') select('Table', 'cell:10 - 35|Loc Name,5(SA Ad Support)') assert_p('Table', 'RowCount', '10') select('Table', 'cell:10 - 35|Loc Name,7(Sydney Gate DC)') rightclick('Table', '10 - 35|Loc Name,7') select_menu(commonBits.fl('Edit Record')) ## select('Table1', 'cell:10 - 35|Loc Name,7(Sydney Gate DC)') select('Table', 'cell:' + commonBits.fl('Data') + ',1(Sydney Gate DC)') ## assert_p('Table', 'Content', '[[Loc Nbr, 4, 4, 5897, 5897], [Loc Name, 10, 35, Sydney Gate DC, Sydney Gate DC], [Loc Addr Ln1, 45, 40, No 2 Sydney Gate, No 2 Sydney Gate], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Loc Nbr, 4, 4, 5897, 5897], [Loc Name, 10, 35, Sydney Gate DC, Sydney Gate DC], [Loc Addr Ln1, 45, 40, No 2 Sydney Gate, No 2 Sydney Gate], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Loc Nbr, 4, 4, 5897, 5897], [Loc Name, 10, 35, Sydney Gate DC, Sydney Gate DC], [Loc Addr Ln1, 45, 40, No 2 Sydney Gate, No 2 Sydney Gate], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:' + commonBits.fl('Data') + ',3(NSW)') assert_p('Table', 'Text', 'cell:' + commonBits.fl('Data') + ',3(NSW)') select('Table', 'cell:' + commonBits.fl('Data') + ',1(Sydney Gate DC)') if commonBits.isMissingCol(): assert_p('Table', 'RowCount', '4') else: assert_p('Table', 'RowCount', '5') close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt') commonBits.setRecordLayout(select, 'utf8_ams Store') click(commonBits.fl('Edit') + '1') select('Table', 'rows:[2,4,8,11,14],columns:[10 - 35|Loc Name]') select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Record View #{Selected Records#}') ) ## select('Table1', 'rows:[2,4,8,11,14],columns:[10 - 35|Loc Name]') select('Table', 'cell:' + commonBits.fl('Data') + ',1(5853)') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5853, 5853], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, NSW North Sydney Ad Support, NSW North Sydney Ad Support], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5853, 5853], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, NSW North Sydney Ad Support, NSW North Sydney Ad Support], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:' + commonBits.fl('Data') + ',3(NSW North Sydney Ad Support)') assert_p('Table', 'Text', 'cell:' + commonBits.fl('Data') + ',3(NSW North Sydney Ad Support)') select('Table', 'cell:' + commonBits.fl('Data') + ',3(NSW North Sydney Ad Support)') click('Right') select('Table', 'cell:' + commonBits.fl('Data') + ',4(Bankstown)') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:' + commonBits.fl('Data') + ',5(Unit 2, 39-41 Allingham Street)') assert_p('Table', 'Text', 'cell:' + commonBits.fl('Data') + ',5(Unit 2, 39-41 Allingham Street)') select('Table', 'cell:' + commonBits.fl('Data') + ',5(Unit 2, 39-41 Allingham Street)') click('Right') select('Table', 'cell:' + commonBits.fl('Data') + ',5(Cnr. Urunga Pde & The Kingsway)') assert_p('Table', 'Text', 'Cnr. Urunga Pde & The Kingsway', commonBits.fl('Data') + ',5') select('Table', 'cell:' + commonBits.fl('Data') + ',4(Westfield Shoppingtown)') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5037, 5037], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Miranda, Miranda], [Loc Addr Ln1, 45, 40, Westfield Shoppingtown, Westfield Shoppingtown], [Loc Addr Ln2, 85, 40, Cnr. Urunga Pde & The Kingsway, Cnr. Urunga Pde & The Kingsway], [Loc Addr Ln3, 125, 35, Miranda, Miranda], [Loc Postcode, 160, 10, 2228, 2228], [Loc State, 170, 3, NSW, NSW]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5037, 5037], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Miranda, Miranda], [Loc Addr Ln1, 45, 40, Westfield Shoppingtown, Westfield Shoppingtown], [Loc Addr Ln2, 85, 40, Cnr. Urunga Pde & The Kingsway, Cnr. Urunga Pde & The Kingsway], [Loc Addr Ln3, 125, 35, Miranda, Miranda], [Loc Postcode, 160, 10, 2228, 2228], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:' + commonBits.fl('Data') + ',4(Westfield Shoppingtown)') click('Right') select('Table', 'cell:' + commonBits.fl('Data') + ',5(Charles Hackett Drive)') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5060, 5060], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, St Marys, St Marys], [Loc Addr Ln1, 45, 40, St. Mary\'s, St. Mary\'s], [Loc Addr Ln2, 85, 40, Charles Hackett Drive, Charles Hackett Drive], [Loc Addr Ln3, 125, 35, St Mary\'s, St Mary\'s], [Loc Postcode, 160, 10, 2760, 2760], [Loc State, 170, 3, NSW, NSW]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5060, 5060], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, St Marys, St Marys], [Loc Addr Ln1, 45, 40, St. Mary\'s, St. Mary\'s], [Loc Addr Ln2, 85, 40, Charles Hackett Drive, Charles Hackett Drive], [Loc Addr Ln3, 125, 35, St Mary\'s, St Mary\'s], [Loc Postcode, 160, 10, 2760, 2760], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:' + commonBits.fl('Data') + ',5(Charles Hackett Drive)') click('Right') select('Table', 'cell:' + commonBits.fl('Data') + ',5(Units 2-3, 14 Aquatic Drive)') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5078, 5078], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Warringah Mall, Warringah Mall], [Loc Addr Ln1, 45, 40, Frenchs Forest, Frenchs Forest], [Loc Addr Ln2, 85, 40, Units 2-3, 14 Aquatic Drive, Units 2-3, 14 Aquatic Drive], [Loc Addr Ln3, 125, 35, Frenchs Forest, Frenchs Forest], [Loc Postcode, 160, 10, 2086, 2086], [Loc State, 170, 3, NSW, NSW]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5078, 5078], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Warringah Mall, Warringah Mall], [Loc Addr Ln1, 45, 40, Frenchs Forest, Frenchs Forest], [Loc Addr Ln2, 85, 40, Units 2-3, 14 Aquatic Drive, Units 2-3, 14 Aquatic Drive], [Loc Addr Ln3, 125, 35, Frenchs Forest, Frenchs Forest], [Loc Postcode, 160, 10, 2086, 2086], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:' + commonBits.fl('Data') + ',5(Units 2-3, 14 Aquatic Drive)') click('LeftM') select('Table', 'cell:' + commonBits.fl('Data') + ',1(5853)') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5853, 5853], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, NSW North Sydney Ad Support, NSW North Sydney Ad Support], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5853, 5853], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, NSW North Sydney Ad Support, NSW North Sydney Ad Support], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:' + commonBits.fl('Data') + ',1(5853)') click('RightM') select('Table', 'cell:' + commonBits.fl('Data') + ',4(Frenchs Forest)') if commonBits.isMissingCol(): assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5078, 5078], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Warringah Mall, Warringah Mall], [Loc Addr Ln1, 45, 40, Frenchs Forest, Frenchs Forest], [Loc Addr Ln2, 85, 40, Units 2-3, 14 Aquatic Drive, Units 2-3, 14 Aquatic Drive], [Loc Addr Ln3, 125, 35, Frenchs Forest, Frenchs Forest], [Loc Postcode, 160, 10, 2086, 2086], [Loc State, 170, 3, NSW, NSW]]') else: assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5078, 5078], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Warringah Mall, Warringah Mall], [Loc Addr Ln1, 45, 40, Frenchs Forest, Frenchs Forest], [Loc Addr Ln2, 85, 40, Units 2-3, 14 Aquatic Drive, Units 2-3, 14 Aquatic Drive], [Loc Addr Ln3, 125, 35, Frenchs Forest, Frenchs Forest], [Loc Postcode, 160, 10, 2086, 2086], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt') commonBits.setRecordLayout(select, 'utf8_ams Store') click('Edit1') select('Table', 'rows:[0,4,8,13,18,23,27],columns:[10 - 35|Loc Name]') select_menu('View>>Table View #{Selected Records#}') ## select('Table2', 'rows:[0,4,8,13,18,23,27],columns:[10 - 35|Loc Name]') select('Table', 'cell:8 - 2|Loc Type,1(ST)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC], [TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW], [TAR, 5091, ST, Chatswood, Frenchs Forest, Unit 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW], [TAR, 5157, ST, Chirnside Park, Kilsyth South, Lot 3 & 4 Southfork Drive, Kilsyth Park, 3137, VIC], [TAR, 5170, ST, Bondi, Building B, Portside Distribution Centre, 2-8 McPherson Street, Botany, 2019, NSW]]' ) else: assert_p( 'Table', 'Content', '[[TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [TAR, 5091, ST, Chatswood, Frenchs Forest, Unit 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [TAR, 5157, ST, Chirnside Park, Kilsyth South, Lot 3 & 4 Southfork Drive, Kilsyth Park, 3137, VIC, A], [TAR, 5170, ST, Bondi, Building B, Portside Distribution Centre, 2-8 McPherson Street, Botany, 2019, NSW, A]]' ) select('Table', 'cell:10 - 35|Loc Name,3(Campbelltown)') assert_p('Table', 'Text', 'Campbelltown', '10 - 35|Loc Name,3') select('Table', 'cell:10 - 35|Loc Name,1(Bankstown)') rightclick('Table', '10 - 35|Loc Name,1') select_menu('Edit Record') ## select('Table1', 'cell:10 - 35|Loc Name,1(Bankstown)') select('Table', 'cell:Data,4(Bankstown)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,4(Bankstown)') click('RightM') select('Table', 'cell:Data,4(Building B, Portside Distribution Centre)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5170, 5170], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bondi, Bondi], [Loc Addr Ln1, 45, 40, Building B, Portside Distribution Centre, Building B, Portside Distribution Centre], [Loc Addr Ln2, 85, 40, 2-8 McPherson Street, 2-8 McPherson Street], [Loc Addr Ln3, 125, 35, Botany, Botany], [Loc Postcode, 160, 10, 2019, 2019], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5170, 5170], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bondi, Bondi], [Loc Addr Ln1, 45, 40, Building B, Portside Distribution Centre, Building B, Portside Distribution Centre], [Loc Addr Ln2, 85, 40, 2-8 McPherson Street, 2-8 McPherson Street], [Loc Addr Ln3, 125, 35, Botany, Botany], [Loc Postcode, 160, 10, 2019, 2019], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,4(Building B, Portside Distribution Centre)') click('LeftM') select('Table', 'cell:Data,5(30-68 Taras Ave)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5839, 5839], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, DC - Taras Ave, DC - Taras Ave], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, 30-68 Taras Ave, 30-68 Taras Ave], [Loc Addr Ln3, 125, 35, Altona North, Altona North], [Loc Postcode, 160, 10, 3025, 3025], [Loc State, 170, 3, VIC, VIC]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5839, 5839], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, DC - Taras Ave, DC - Taras Ave], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, 30-68 Taras Ave, 30-68 Taras Ave], [Loc Addr Ln3, 125, 35, Altona North, Altona North], [Loc Postcode, 160, 10, 3025, 3025], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,5(30-68 Taras Ave)') click('RightM') click('Left') select('Table', 'cell:Data,5(Lot 3 & 4 Southfork Drive)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5157, 5157], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Chirnside Park, Chirnside Park], [Loc Addr Ln1, 45, 40, Kilsyth South, Kilsyth South], [Loc Addr Ln2, 85, 40, Lot 3 & 4 Southfork Drive, Lot 3 & 4 Southfork Drive], [Loc Addr Ln3, 125, 35, Kilsyth Park, Kilsyth Park], [Loc Postcode, 160, 10, 3137, 3137], [Loc State, 170, 3, VIC, VIC]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5157, 5157], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Chirnside Park, Chirnside Park], [Loc Addr Ln1, 45, 40, Kilsyth South, Kilsyth South], [Loc Addr Ln2, 85, 40, Lot 3 & 4 Southfork Drive, Lot 3 & 4 Southfork Drive], [Loc Addr Ln3, 125, 35, Kilsyth Park, Kilsyth Park], [Loc Postcode, 160, 10, 3137, 3137], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:Data,5(Lot 3 & 4 Southfork Drive)') click('Left') select('Table', 'cell:Data,5(Unit 2-3, 14 Aquatic Drive)') if commonBits.isMissingCol(): assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5091, 5091], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Chatswood, Chatswood], [Loc Addr Ln1, 45, 40, Frenchs Forest, Frenchs Forest], [Loc Addr Ln2, 85, 40, Unit 2-3, 14 Aquatic Drive, Unit 2-3, 14 Aquatic Drive], [Loc Addr Ln3, 125, 35, Frenchs Forest, Frenchs Forest], [Loc Postcode, 160, 10, 2086, 2086], [Loc State, 170, 3, NSW, NSW]]' ) else: assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5091, 5091], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Chatswood, Chatswood], [Loc Addr Ln1, 45, 40, Frenchs Forest, Frenchs Forest], [Loc Addr Ln2, 85, 40, Unit 2-3, 14 Aquatic Drive, Unit 2-3, 14 Aquatic Drive], [Loc Addr Ln3, 125, 35, Frenchs Forest, Frenchs Forest], [Loc Postcode, 160, 10, 2086, 2086], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) close()