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()