def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select(
'FileChooser',
commonBits.sampleDir() + 'Ams_LocDownload_20041228_Extract2.txt')
commonBits.setRecordLayout(select, 'ams Store')
click(commonBits.fl('Edit') + '1')
select_menu(commonBits.fl('Data') + '>>' + commonBits.fl('Sort'))
## select('List', 'ams Store')
select('Table', 'Loc Type', commonBits.fl('Field') + ',0')
select('Table', 'Loc Nbr', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(Loc Nbr)')
commonBits.sort(click)
select('Table', 'cell:10 - 35|Loc Name,6(Ringwood)')
assert_p(
'Table', 'Content',
'[[TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [TAR, 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, NSW, A], [TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A], [TAR, 5002, ST, Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, NSW, A], [TAR, 5012, ST, Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, A], [TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5030, ST, Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5054, ST, Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, A], [TAR, 5062, ST, Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, A], [TAR, 5096, ST, Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, A], [TAR, 5138, ST, Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, A], [TAR, 5141, ST, The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, A], [TAR, 5146, ST, Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 0830, NT, A]]'
)
select('Table', 'cell:10 - 35|Loc Name,6(Ringwood)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
if window(
commonBits.fl('Save Changes to file: ' +
commonBits.sampleDir() +
'Ams_LocDownload_20041228_Extract2.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() + 'Ams_LocDownload_20041228_Extract.txt')
commonBits.setRecordLayout(select, 'ams Store')
click(commonBits.fl('Edit') + '1')
select('Table', 'cell:4 - 4|Loc Nbr,0(5015)')
rightclick('Table', '10 - 35|Loc Name,0')
select_menu('Sort')
## select('List', 'ams Store')
select('Table', 'Loc Name', commonBits.fl('Field') + ',0')
select('Table', 'cell:' + commonBits.fl('Field') + ',0(Loc Name)')
commonBits.sort(click)
select('Table', 'cell:10 - 35|Loc Name,0(Ashfield)')
assert_p(
'Table', 'Content',
'[[TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A]]'
)
# select('Table', 'cell:10 - 35|Loc Name,1(Bankstown)')
assert_p('Table', 'Text', 'Bankstown', '10 - 35|Loc Name,1')
select('Table', 'cell:10 - 35|Loc Name,1(Bankstown)')
##doubleclick('LineList$HeaderToolTips', '45 - 40|Loc Addr Ln1')
doubleclick('BaseDisplay$HeaderToolTips', '45 - 40|Loc Addr Ln1')
select('Table', 'cell:45 - 40|Loc Addr Ln1,1(Bankstown)')
assert_p(
'Table', 'Content',
'[[TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A]]'
)
select('Table', 'cell:45 - 40|Loc Addr Ln1,1(Bankstown)')
select_menu(commonBits.fl('Data') + '>>' + commonBits.fl('Sort'))
# select('Table1', 'cell:45 - 40|Loc Addr Ln1,1(Bankstown)')
# select('List', 'ams Store')
select('Table', 'Loc Nbr', commonBits.fl('Field') + ',0')
select('Table', 'cell:' + commonBits.fl('Field') + ',0(Loc Nbr)')
commonBits.sort(click)
select('Table', 'cell:4 - 4|Loc Nbr,1(5019)')
assert_p('Table', 'Text', '5019', '4 - 4|Loc Nbr,1')
select('Table', 'cell:4 - 4|Loc Nbr,2(5033)')
assert_p(
'Table', 'Content',
'[[TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A]]'
)
select('Table', 'cell:4 - 4|Loc Nbr,2(5033)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
if window(
commonBits.fl('Save Changes to file: ' +
commonBits.sampleDir() +
'Ams_LocDownload_20041228_Extract.txt')):
click('No')
close()
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_20'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
click(commonBits.fl('Edit') + '1')
assert_p(
'Table', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69684558, 20, 40118, 280, 1, 5.01], [69694158, 20, 40118, 280, 1, 19.00], [69694158, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [63604808, 20, 40118, 170, 1, 4.87], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99], [64634429, 20, 40118, 957, 1, 3.99], [66624458, 20, 40118, 957, 1, 0.89], [63674861, 20, 40118, 957, 10, 2.70], [65674532, 20, 40118, 929, 1, 3.59], [64614401, 59, 40118, 957, 1, 1.99], [64614401, 59, 40118, 957, 1, 1.99], [61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99], [68634752, 59, 40118, 410, 1, 8.99], [60614487, 59, 40118, 878, 1, 5.95], [63644339, 59, 40118, 878, 1, 12.65], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [62684217, 59, 40118, 957, 1, 9.99], [67674686, 59, 40118, 929, 1, 3.99], [61684613, 59, 40118, 335, 1, 12.99], [64624770, 59, 40118, 957, 1, 2.59], [69694814, 166, 40118, 360, 1, 2.50], [69694814, 166, 40118, 360, 1, 2.50], [69644164, 166, 40118, 193, 1, 21.59], [62684907, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, -1, -13.99], [62694193, 166, 40118, 375, 1, 11.99], [63654450, 166, 40118, 320, 1, 13.99], [62664576, 166, 40118, 320, 1, 9.72], [63634260, 166, 40118, 320, 1, 5.59], [64684534, 166, 40118, 440, 1, 14.99], [64674965, 166, 40118, 235, 1, 19.99], [64674965, 166, 40118, 235, -1, -19.99], [64674965, 166, 40118, 235, 1, 12.00], [60624523, 166, 40118, 261, 1, 12.00], [66624253, 166, 40118, 957, 1, 3.49], [66624253, 166, 40118, 957, 1, 3.49], [64654284, 166, 40118, 957, 1, 3.99], [60684907, 166, 40118, 805, 1, 5.50], [63624299, 166, 40118, 870, 1, 10.99], [63624367, 166, 40118, 870, 1, 11.19], [62694575, 166, 40118, 475, 1, 14.99], [69614011, 166, 40118, 905, 1, 6.99], [62634996, 166, 40118, 650, 1, 9.99], [67634503, 166, 40118, 970, 1, 24.99], [65604476, 166, 40118, 830, 1, 19.95], [62694170, 166, 40118, 851, 1, 16.99], [63684098, 166, 40118, 410, 1, 1.98], [63684098, 166, 40118, 410, 1, 1.98], [63684098, 166, 40118, 410, 1, 1.98], [64674609, 166, 40118, 485, 1, 29.99], [62614014, 166, 40118, 366, 1, 14.99], [61694741, 166, 40118, 432, 1, 9.06], [62614534, 166, 40118, 432, 1, 9.09], [64604876, 166, 40118, 801, 1, 29.62], [66624829, 166, 40118, 957, 1, 1.99], [62694843, 166, 40118, 193, 1, 13.59], [62684580, 166, 40118, 265, 1, 19.00], [62664909, 166, 40118, 957, 1, 3.29], [62674751, 166, 40118, 957, 1, 1.99], [62674492, 166, 40118, 957, 1, 1.49], [62674492, 166, 40118, 957, 1, 1.49], [62694706, 166, 40118, 193, 1, 13.59], [69644602, 166, 40118, 265, 1, 19.00], [63634768, 166, 40118, 270, 1, 12.00], [62684207, 166, 40118, 265, 1, 19.00], [69644961, 166, 40118, 230, 1, 9.60], [69604743, 166, 40118, 250, 1, 29.95], [63634081, 166, 40118, 929, 1, 3.89], [69614229, 166, 40118, 902, 1, 15.95], [62654454, 166, 40118, 845, 1, 5.95], [64634712, 166, 40118, 845, 1, 3.90], [62674092, 166, 40118, 851, 1, 15.99], [67664966, 166, 40118, 929, 1, 0.89], [67664966, 166, 40118, 929, 1, 0.89], [64674633, 166, 40118, 220, 1, 15.99], [64624081, 166, 40118, 280, 1, 26.24], [69674069, 166, 40118, 910, 1, 10.49], [62684028, 166, 40118, 520, 1, 29.99], [64604876, 166, 40118, 801, 1, 29.62], [68644966, 166, 40118, 902, 1, 12.50], [68644966, 166, 40118, 902, -1, -12.50], [68644966, 166, 40118, 902, 1, 0.01], [62664347, 166, 40118, 370, 1, 8.99], [62664231, 166, 40118, 370, 1, 8.99], [62694605, 166, 40118, 261, 1, 25.00], [69634922, 166, 40118, 261, 1, 19.00], [63694928, 166, 40118, 904, 1, 11.49], [60624185, 166, 40118, 500, 1, 8.99], [60624314, 166, 40118, 500, 1, 8.99], [69694959, 166, 40118, 270, 1, 11.99], [69624033, 166, 40118, 80, 1, 18.19], [62694485, 166, 40118, 193, 1, 17.56], [60614646, 166, 40118, 60, 1, 6.00], [63654066, 166, 40118, 275, 1, 24.99], [62684548, 166, 40118, 415, 1, 39.99], [62684548, 166, 40118, 415, 1, 39.99], [69694685, 166, 40118, 360, 1, 6.99], [63614741, 166, 40118, 395, 1, 27.99], [60664302, 166, 40118, 270, 1, 9.00], [60664241, 166, 40118, 270, 1, 9.00], [66674979, 166, 40118, 360, 1, 4.50], [62634862, 166, 40118, 355, 1, 11.89], [62604139, 166, 40118, 335, 1, 7.99], [62624382, 166, 40118, 370, 1, 18.98], [62624382, 166, 40118, 370, -1, -18.98], [69694937, 166, 40118, 360, 1, 2.50], [62624382, 166, 40118, 370, 1, 18.98], [62624382, 166, 40118, 370, 1, 18.98], [62624382, 166, 40118, 370, -1, -18.98], [62624382, 166, 40118, 370, -1, -18.98], [62624382, 166, 40118, 370, 1, 18.98], [62624382, 166, 40118, 370, 1, 18.98], [61684889, 166, 40118, 685, 1, 4.49], [68614651, 166, 40118, 370, 1, 3.99], [62664674, 166, 40118, 471, 1, 24.99], [61684889, 166, 40118, 685, 1, 4.49], [60694417, 166, 40118, 929, 1, 0.65], [65694328, 166, 40118, 929, 1, 0.59], [63684449, 166, 40118, 320, 1, 16.99], [62614815, 166, 40118, 405, 1, 20.00], [62664151, 166, 40118, 455, 1, 25.00], [64684719, 166, 40118, 410, 1, 9.99], [69654084, 166, 40118, 60, 1, 6.00], [69644897, 166, 40118, 60, 1, 5.08], [68654655, 166, 40118, 60, 1, 5.08], [68674560, 166, 40118, 170, 1, 5.99], [62694387, 166, 40118, 432, 1, 7.99], [62664568, 166, 40118, 432, 1, 5.99], [69634261, 166, 40118, 261, 1, 12.00], [69634660, 166, 40118, 261, 1, 12.00], [69684947, 166, 40118, 280, 1, 22.49], [60654072, 166, 40118, 905, 1, 4.33], [60654072, 166, 40118, 905, 1, 4.33], [69624221, 166, 40118, 355, 1, 16.99], [62654800, 166, 40118, 355, 1, 19.99], [64644495, 166, 40118, 801, 1, 29.65], [67664645, 166, 40118, 929, 1, 1.39], [60614265, 166, 40118, 395, 1, 15.99], [68604583, 166, 40118, 905, 1, 15.99], [60614265, 166, 40118, 395, 1, 15.99], [60614265, 166, 40118, 395, -1, -15.99], [60614265, 166, 40118, 395, -1, -15.99], [68604583, 166, 40118, 905, -1, -15.99], [68604583, 166, 40118, 905, 1, 15.99], [68604583, 166, 40118, 905, -1, -15.99], [68604583, 166, 40118, 905, 1, 12.80], [60614265, 166, 40118, 395, 1, 15.99], [60614265, 166, 40118, 395, -1, -15.99], [60614265, 166, 40118, 395, 1, 12.80], [69664661, 166, 40118, 904, 1, 14.95], [68664211, 166, 40118, 193, 1, 11.19], [60614707, 166, 40118, 60, 1, 6.00], [64604513, 166, 40118, 235, 1, 16.99], [60624864, 166, 40118, 261, 1, 15.00], [69644909, 166, 40118, 261, 1, 9.00], [60604100, 166, 40118, 80, 1, 13.30], [69634263, 166, 40118, 261, 1, 25.00], [69634263, 166, 40118, 261, -1, -25.00], [69634263, 166, 40118, 261, 1, 12.00], [61674701, 166, 40118, 670, 1, 3.99], [63654007, 166, 40118, 670, 1, 56.99], [67624103, 166, 40118, 801, 1, 16.50], [68614329, 166, 40118, 905, 1, 39.99], [67644384, 166, 40118, 193, 1, 23.96], [64644495, 166, 40118, 801, 1, 29.65], [60684484, 184, 40118, 220, 1, 9.00], [60684484, 184, 40118, 220, 1, 9.00], [67674299, 184, 40118, 905, 1, 4.99], [69664620, 184, 40118, 355, 1, 11.89], [69664620, 184, 40118, 355, -1, -11.89], [69664620, 184, 40118, 355, 1, 9.09], [60674210, 184, 40118, 275, -1, -15.00], [60664048, 184, 40118, 60, -1, -4.80], [60614866, 184, 40118, 60, -1, -4.80], [60664048, 184, 40118, 60, -1, -4.80], [60664048, 184, 40118, 60, -1, -4.80], [60614866, 184, 40118, 60, -1, -4.80], [69654081, 184, 40118, 70, 1, 12.99], [63664643, 184, 40118, 193, 1, 16.79], [69654135, 184, 40118, 70, 1, 12.99], [60644672, 184, 40118, 160, 1, 9.09], [62654852, 184, 40118, 345, -1, -19.59], [62674960, 184, 40118, 490, -1, -16.00], [62674960, 184, 40118, 490, 1, 16.00], [65674126, 184, 40118, 929, 1, 2.69], [60634192, 184, 40118, 500, 1, 24.99], [64634500, 184, 40118, 957, -1, -9.99], [66624803, 184, 40118, 170, 1, 2.00], [66624803, 184, 40118, 170, -1, -2.00], [66624803, 184, 40118, 170, 1, 1.04], [66624889, 184, 40118, 170, 1, 2.00], [66624889, 184, 40118, 170, -1, -2.00], [66624889, 184, 40118, 170, 1, 1.04], [60624241, 184, 40118, 500, 1, 34.99], [62644079, 184, 40118, 650, 1, 9.99], [62664183, 184, 40118, 320, -1, -20.99], [64654047, 184, 40118, 320, -1, -25.99], [62694327, 184, 40118, 375, -1, -10.39], [69604894, 184, 40118, 275, -1, -19.00], [67644821, 184, 40118, 60, -1, -14.99], [67644118, 184, 40118, 60, 1, 16.99], [66664981, 184, 40118, 901, 1, 3.09], [66684899, 184, 40118, 901, 1, 12.99], [64634942, 184, 40118, 270, 1, 15.99], [63654826, 184, 40118, 275, 1, 19.00], [69604993, 184, 40118, 220, -1, -14.39], [63624118, 184, 40118, 250, -1, -15.00], [62684517, 184, 40118, 475, -1, -29.99], [67634503, 184, 40118, 970, 1, 24.99], [62694782, 184, 40118, 193, -1, -16.99], [62694683, 184, 40118, 193, -1, -16.99], [62694782, 184, 40118, 193, -1, -16.99], [62694782, 184, 40118, 193, -1, -16.99], [62684096, 184, 40118, 310, 1, 14.00], [69644199, 184, 40118, 193, 1, 19.19], [60634366, 184, 40118, 904, 1, 7.99], [67654448, 184, 40118, 70, 1, 23.00], [67654448, 184, 40118, 70, -1, -23.00], [67654448, 184, 40118, 70, 1, 19.01], [69654459, 184, 40118, 60, 1, 5.08], [60664779, 184, 40118, 60, 1, 5.08], [63674002, 184, 40118, 310, -1, -29.99], [68604041, 184, 40118, 870, -1, -19.99], [67634503, 184, 40118, 970, 1, 24.99], [68644941, 184, 40118, 60, -1, -10.39], [68644941, 184, 40118, 60, -1, -10.39], [68644941, 184, 40118, 60, -1, -10.39], [68644941, 184, 40118, 60, -1, -10.39], [68644934, 184, 40118, 60, 1, 10.39], [62674884, 184, 40118, 350, -1, -8.99], [68654381, 184, 40118, 235, 1, 14.95], [64644433, 184, 40118, 801, 1, 24.99], [64604829, 184, 40118, 805, -1, -29.99], [62634996, 184, 40118, 650, 1, 9.99], [60624270, 184, 40118, 670, 1, 0.95], [63664932, 184, 40118, 929, 1, 1.59], [69684804, 184, 40118, 851, 1, 9.99], [68664363, 184, 40118, 415, -1, -29.95], [62694503, 184, 40118, 929, 1, 2.99], [62644205, 184, 40118, 590, 1, 24.99], [62604912, 184, 40118, 590, 1, 24.89], [64634802, 184, 40118, 904, 1, 4.29], [60664257, 184, 40118, 901, 1, 2.12], [62684043, 184, 40118, 878, -1, -19.95], [62684043, 184, 40118, 878, 1, 19.95], [64644860, 184, 40118, 805, -1, -3.95], [62644590, 184, 40118, 590, -1, -22.99], [64664587, 184, 40118, 432, -1, -16.99], [64604930, 184, 40118, 801, -1, -35.95], [60604880, 184, 40118, 250, 1, 9.00], [68674372, 184, 40118, 845, 1, 2.00], [63684755, 184, 40118, 845, 1, 2.00], [64684439, 184, 40118, 929, 1, 9.99], [67624120, 184, 40118, 940, 1, 0.98], [67624120, 184, 40118, 940, -1, -0.98], [67624120, 184, 40118, 940, 1, 0.49], [67624120, 184, 40118, 940, 1, 0.98], [67624120, 184, 40118, 940, -1, -0.98], [67624120, 184, 40118, 940, 1, 0.49], [66614192, 184, 40118, 940, 1, 1.23], [66614192, 184, 40118, 940, -1, -1.23], [66614192, 184, 40118, 940, 1, 0.69], [66614192, 184, 40118, 940, 1, 1.23], [66614192, 184, 40118, 940, -1, -1.23], [66614192, 184, 40118, 940, 1, 0.69], [67624473, 184, 40118, 940, 1, 0.50], [67624473, 184, 40118, 940, -1, -0.50], [67624473, 184, 40118, 940, 1, 0.19], [67614923, 184, 40118, 875, -1, -19.95], [63604715, 184, 40118, 432, -1, -6.99], [63604715, 184, 40118, 432, -1, -6.99], [63604715, 184, 40118, 432, -1, -6.99], [62684102, 184, 40118, 310, 1, 14.00], [63654091, 184, 40118, 805, 1, 4.95], [68694729, 184, 40118, 855, -1, -16.99], [60684563, 184, 40118, 220, 1, 9.59], [68664957, 184, 40118, 80, 1, 13.99], [67604116, 184, 40118, 801, 1, 21.00], [64664047, 184, 40118, 801, 1, 22.99], [67634497, 184, 40118, 970, 1, 24.99], [64664270, 184, 40118, 929, 1, 3.19], [60634150, 184, 40118, 160, -1, -14.99], [68684135, 184, 40118, 878, -1, -249.00], [68684135, 184, 40118, 878, 1, 269.00], [68684135, 184, 40118, 878, -1, -269.00], [68684135, 184, 40118, 878, 1, 249.00], [69624909, 184, 40118, 235, -1, -26.21], [62634962, 184, 40118, 530, -1, -6.89], [67614726, 184, 40118, 160, -1, -9.95], [68654094, 184, 40118, 170, -1, -4.50], [60674335, 184, 40118, 485, 1, 19.95], [60674335, 184, 40118, 485, -1, -19.95], [60674335, 184, 40118, 485, 1, 12.99], [60644305, 184, 40118, 929, 1, 0.89], [64604604, 184, 40118, 366, 1, 6.99], [63694367, 184, 40118, 290, 1, 19.00], [62644079, 184, 40118, 650, 1, 9.99], [67674119, 184, 40118, 929, 1, 1.89], [69614627, 184, 40118, 265, 1, 19.00], [69614740, 184, 40118, 265, 1, 19.00], [60614135, 184, 40118, 230, -1, -14.25], [69674452, 184, 40118, 970, 1, 19.99], [62694272, 184, 40118, 957, 1, 2.49], [69614274, 184, 40118, 902, 1, 9.95], [60634379, 184, 40118, 290, 1, 25.00], [60674904, 184, 40118, 261, 1, 19.00], [66614582, 184, 40118, 670, -1, -15.99], [64654096, 184, 40118, 805, 1, 4.95], [62634605, 184, 40118, 405, 1, 29.99], [69694354, 184, 40118, 929, 1, 2.99], [69634699, 184, 40118, 80, 1, 20.99], [69634712, 184, 40118, 80, 1, 20.99], [69664171, 184, 40118, 250, -1, -27.95], [69694479, 184, 40118, 280, 1, 14.99], [63634656, 184, 40118, 929, -1, -5.50], [69664149, 184, 40118, 903, -1, -5.99], [69664163, 184, 40118, 903, -1, -1.39], [67674341, 184, 40118, 901, -1, -19.95], [69644053, 184, 40118, 230, 1, 18.74], [63674184, 184, 40118, 957, 1, 164.00], [62604338, 184, 40118, 870, 1, 69.99], [62644344, 184, 40118, 432, 1, 10.99], [66644706, 184, 40118, 432, 1, 10.99], [62644528, 184, 40118, 432, 1, 10.99], [62644764, 184, 40118, 432, 1, 10.99], [62664135, 184, 40118, 405, 1, 11.00], [62664244, 184, 40118, 405, 1, 11.00], [62664197, 184, 40118, 405, 1, 11.00], [62654875, 184, 40118, 471, 1, 39.99], [64614653, 184, 40118, 265, 1, 34.99], [64614653, 184, 40118, 265, 1, 34.99], [61694023, 184, 40118, 650, 1, 14.99], [61694023, 184, 40118, 650, 1, 14.99], [60694909, 184, 40118, 998, 1, 2.00], [68614241, 184, 40118, 70, 1, 12.99], [69654638, 184, 40118, 60, 1, 6.00], [67634923, 184, 40118, 60, 1, 17.59], [64614285, 184, 40118, 70, 1, 22.99], [69644389, 184, 40118, 193, 1, 17.59], [68614787, 184, 40118, 70, 1, 27.99], [69644337, 184, 40118, 70, 1, 29.99], [68634061, 184, 40118, 70, 1, 27.99], [69644184, 184, 40118, 193, 1, 15.99], [63624756, 184, 40118, 801, 1, 21.00], [67604116, 184, 40118, 801, 1, 21.00], [68654451, 184, 40118, 193, 1, 27.99], [62614172, 184, 40118, 193, 1, 19.19], [61614174, 184, 40118, 620, 1, 49.99], [61614174, 184, 40118, 620, 1, 29.99], [62644445, 184, 40118, 801, 1, 69.95], [62634323, 184, 40118, 905, 1, 149.00], [66674079, 184, 40118, 901, 1, 3.95], [66674130, 184, 40118, 901, 1, 3.95], [61604095, 184, 40118, 902, 1, 12.50], [66664028, 184, 40118, 902, 1, 14.95], [68654621, 184, 40118, 902, 1, 12.95], [63694264, 184, 40118, 830, 1, 19.95], [63604361, 184, 40118, 901, 1, 3.99], [62634259, 184, 40118, 901, 1, 6.69], [62634259, 184, 40118, 901, 1, 6.69], [60684429, 184, 40118, 904, 1, 4.89], [60684037, 184, 40118, 904, 1, 9.95], [69694875, 184, 40118, 904, 1, 19.95], [69694875, 184, 40118, 904, 1, 19.95], [69694875, 184, 40118, 904, 1, 19.95], [69694875, 184, 40118, 904, -1, -19.95], [69694875, 184, 40118, 904, -1, -19.95], [69694875, 184, 40118, 904, -1, -19.95], [63604108, 184, 40118, 901, 1, 3.95], [63694928, 184, 40118, 904, 1, 11.49], [60634765, 184, 40118, 904, 1, 4.99], [69664668, 184, 40118, 903, 1, 8.95]]'
)
select(
'Table',
'rows:[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16],columns:[9 - 2|STORE-NO]'
)
select_menu(
commonBits.fl('View') + '>>' +
commonBits.fl('Table View #{Selected Records#}'))
## select('Table2', 'rows:[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16],columns:[9 - 2|STORE-NO]')
select_menu(
commonBits.fl('Window') + '>>DTAR020.bin>>' +
commonBits.fl('Table:'))
## select('Table', 'rows:[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16],columns:[9 - 2|STORE-NO]')
select(
'Table',
'rows:[17,18,19,20,21,22,23,24,25,26,27,28,29,30,31],columns:[9 - 2|STORE-NO,11 - 4|DATE]'
)
select_menu(
commonBits.fl('View') + '>>' +
commonBits.fl('Table View #{Selected Records#}'))
## select('Table2', 'rows:[18,19,20,21,22,23,24,25,26,27,28,29,30,31],columns:[9 - 2|STORE-NO,11 - 4|DATE]')
assert_p(
'Table', 'Content',
'[[60614487, 59, 40118, 878, 1, 5.95], [63644339, 59, 40118, 878, 1, 12.65], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [62684217, 59, 40118, 957, 1, 9.99], [67674686, 59, 40118, 929, 1, 3.99], [61684613, 59, 40118, 335, 1, 12.99], [64624770, 59, 40118, 957, 1, 2.59], [69694814, 166, 40118, 360, 1, 2.50], [69694814, 166, 40118, 360, 1, 2.50], [69644164, 166, 40118, 193, 1, 21.59], [62684907, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, -1, -13.99]]'
)
select_menu(
commonBits.fl('Window') + '>>DTAR020.bin>>' +
commonBits.fl('Table:') + '1')
assert_p(
'Table', 'Content',
'[[69684558, 20, 40118, 280, 1, 5.01], [69694158, 20, 40118, 280, 1, 19.00], [69694158, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [63604808, 20, 40118, 170, 1, 4.87], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99], [64634429, 20, 40118, 957, 1, 3.99], [66624458, 20, 40118, 957, 1, 0.89], [63674861, 20, 40118, 957, 10, 2.70], [65674532, 20, 40118, 929, 1, 3.59], [64614401, 59, 40118, 957, 1, 1.99], [64614401, 59, 40118, 957, 1, 1.99], [61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99]]'
)
select_menu(
commonBits.fl('Window') + '>>DTAR020.bin>>' +
commonBits.fl('Table:'))
select(
'Table',
'rows:[18,19,20,21,22,23,24,25,26,27,28,29,30,31],columns:[9 - 2|STORE-NO,11 - 4|DATE]'
)
select('Table', 'cell:9 - 2|STORE-NO,1(20)')
rightclick('Table', '9 - 2|STORE-NO,1')
select_menu('Sort')
# select('Table1', 'cell:9 - 2|STORE-NO,1(20)')
# select('List', 'DTAR020')
# select('List', 'DTAR020')
select('Table', 'cell:' + commonBits.fl('Field') + ',0( )')
# select('List', 'DTAR020')
select('Table', 'DEPT-NO', commonBits.fl('Field') + ',0')
select('Table', 'STORE-NO', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(STORE-NO)')
commonBits.sort(click)
assert_p(
'Table', 'Content',
'[[60614646, 166, 40118, 60, 1, 6.00], [69654084, 166, 40118, 60, 1, 6.00], [69644897, 166, 40118, 60, 1, 5.08], [68654655, 166, 40118, 60, 1, 5.08], [60614707, 166, 40118, 60, 1, 6.00], [60664048, 184, 40118, 60, -1, -4.80], [60614866, 184, 40118, 60, -1, -4.80], [60664048, 184, 40118, 60, -1, -4.80], [60664048, 184, 40118, 60, -1, -4.80], [60614866, 184, 40118, 60, -1, -4.80], [67644821, 184, 40118, 60, -1, -14.99], [67644118, 184, 40118, 60, 1, 16.99], [69654459, 184, 40118, 60, 1, 5.08], [60664779, 184, 40118, 60, 1, 5.08], [68644941, 184, 40118, 60, -1, -10.39], [68644941, 184, 40118, 60, -1, -10.39], [68644941, 184, 40118, 60, -1, -10.39], [68644941, 184, 40118, 60, -1, -10.39], [68644934, 184, 40118, 60, 1, 10.39], [69654638, 184, 40118, 60, 1, 6.00], [67634923, 184, 40118, 60, 1, 17.59], [69654081, 184, 40118, 70, 1, 12.99], [69654135, 184, 40118, 70, 1, 12.99], [67654448, 184, 40118, 70, 1, 23.00], [67654448, 184, 40118, 70, -1, -23.00], [67654448, 184, 40118, 70, 1, 19.01], [68614241, 184, 40118, 70, 1, 12.99], [64614285, 184, 40118, 70, 1, 22.99], [68614787, 184, 40118, 70, 1, 27.99], [69644337, 184, 40118, 70, 1, 29.99], [68634061, 184, 40118, 70, 1, 27.99], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30], [68664957, 184, 40118, 80, 1, 13.99], [69634699, 184, 40118, 80, 1, 20.99], [69634712, 184, 40118, 80, 1, 20.99], [60644672, 184, 40118, 160, 1, 9.09], [60634150, 184, 40118, 160, -1, -14.99], [67614726, 184, 40118, 160, -1, -9.95], [63604808, 20, 40118, 170, 1, 4.87], [68674560, 166, 40118, 170, 1, 5.99], [66624803, 184, 40118, 170, 1, 2.00], [66624803, 184, 40118, 170, -1, -2.00], [66624803, 184, 40118, 170, 1, 1.04], [66624889, 184, 40118, 170, 1, 2.00], [66624889, 184, 40118, 170, -1, -2.00], [66624889, 184, 40118, 170, 1, 1.04], [68654094, 184, 40118, 170, -1, -4.50], [69644164, 166, 40118, 193, 1, 21.59], [62694843, 166, 40118, 193, 1, 13.59], [62694706, 166, 40118, 193, 1, 13.59], [62694485, 166, 40118, 193, 1, 17.56], [68664211, 166, 40118, 193, 1, 11.19], [67644384, 166, 40118, 193, 1, 23.96], [63664643, 184, 40118, 193, 1, 16.79], [62694782, 184, 40118, 193, -1, -16.99], [62694683, 184, 40118, 193, -1, -16.99], [62694782, 184, 40118, 193, -1, -16.99], [62694782, 184, 40118, 193, -1, -16.99], [69644199, 184, 40118, 193, 1, 19.19], [69644389, 184, 40118, 193, 1, 17.59], [69644184, 184, 40118, 193, 1, 15.99], [68654451, 184, 40118, 193, 1, 27.99], [62614172, 184, 40118, 193, 1, 19.19], [64674633, 166, 40118, 220, 1, 15.99], [60684484, 184, 40118, 220, 1, 9.00], [60684484, 184, 40118, 220, 1, 9.00], [69604993, 184, 40118, 220, -1, -14.39], [60684563, 184, 40118, 220, 1, 9.59], [69644961, 166, 40118, 230, 1, 9.60], [60614135, 184, 40118, 230, -1, -14.25], [69644053, 184, 40118, 230, 1, 18.74], [64674965, 166, 40118, 235, 1, 19.99], [64674965, 166, 40118, 235, -1, -19.99], [64674965, 166, 40118, 235, 1, 12.00], [64604513, 166, 40118, 235, 1, 16.99], [68654381, 184, 40118, 235, 1, 14.95], [69624909, 184, 40118, 235, -1, -26.21], [69604743, 166, 40118, 250, 1, 29.95], [63624118, 184, 40118, 250, -1, -15.00], [60604880, 184, 40118, 250, 1, 9.00], [69664171, 184, 40118, 250, -1, -27.95], [60624523, 166, 40118, 261, 1, 12.00], [62694605, 166, 40118, 261, 1, 25.00], [69634922, 166, 40118, 261, 1, 19.00], [69634261, 166, 40118, 261, 1, 12.00], [69634660, 166, 40118, 261, 1, 12.00], [60624864, 166, 40118, 261, 1, 15.00], [69644909, 166, 40118, 261, 1, 9.00], [69634263, 166, 40118, 261, 1, 25.00], [69634263, 166, 40118, 261, -1, -25.00], [69634263, 166, 40118, 261, 1, 12.00], [60674904, 184, 40118, 261, 1, 19.00], [62684580, 166, 40118, 265, 1, 19.00], [69644602, 166, 40118, 265, 1, 19.00], [62684207, 166, 40118, 265, 1, 19.00], [69614627, 184, 40118, 265, 1, 19.00], [69614740, 184, 40118, 265, 1, 19.00], [64614653, 184, 40118, 265, 1, 34.99], [64614653, 184, 40118, 265, 1, 34.99], [63634768, 166, 40118, 270, 1, 12.00], [69694959, 166, 40118, 270, 1, 11.99], [60664302, 166, 40118, 270, 1, 9.00], [60664241, 166, 40118, 270, 1, 9.00], [64634942, 184, 40118, 270, 1, 15.99], [63654066, 166, 40118, 275, 1, 24.99], [60674210, 184, 40118, 275, -1, -15.00], [69604894, 184, 40118, 275, -1, -19.00], [63654826, 184, 40118, 275, 1, 19.00], [69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69684558, 20, 40118, 280, 1, 5.01], [69694158, 20, 40118, 280, 1, 19.00], [69694158, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [64624081, 166, 40118, 280, 1, 26.24], [69684947, 166, 40118, 280, 1, 22.49], [69694479, 184, 40118, 280, 1, 14.99], [63694367, 184, 40118, 290, 1, 19.00], [60634379, 184, 40118, 290, 1, 25.00], [62684096, 184, 40118, 310, 1, 14.00], [63674002, 184, 40118, 310, -1, -29.99], [62684102, 184, 40118, 310, 1, 14.00], [63654450, 166, 40118, 320, 1, 13.99], [62664576, 166, 40118, 320, 1, 9.72], [63634260, 166, 40118, 320, 1, 5.59], [63684449, 166, 40118, 320, 1, 16.99], [62664183, 184, 40118, 320, -1, -20.99], [64654047, 184, 40118, 320, -1, -25.99], [61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99], [61684613, 59, 40118, 335, 1, 12.99], [62604139, 166, 40118, 335, 1, 7.99], [62654852, 184, 40118, 345, -1, -19.59], [62674884, 184, 40118, 350, -1, -8.99], [62634862, 166, 40118, 355, 1, 11.89], [69624221, 166, 40118, 355, 1, 16.99], [62654800, 166, 40118, 355, 1, 19.99], [69664620, 184, 40118, 355, 1, 11.89], [69664620, 184, 40118, 355, -1, -11.89], [69664620, 184, 40118, 355, 1, 9.09], [69694814, 166, 40118, 360, 1, 2.50], [69694814, 166, 40118, 360, 1, 2.50], [69694685, 166, 40118, 360, 1, 6.99], [66674979, 166, 40118, 360, 1, 4.50], [69694937, 166, 40118, 360, 1, 2.50], [62614014, 166, 40118, 366, 1, 14.99], [64604604, 184, 40118, 366, 1, 6.99], [62664347, 166, 40118, 370, 1, 8.99], [62664231, 166, 40118, 370, 1, 8.99], [62624382, 166, 40118, 370, 1, 18.98], [62624382, 166, 40118, 370, -1, -18.98], [62624382, 166, 40118, 370, 1, 18.98], [62624382, 166, 40118, 370, 1, 18.98], [62624382, 166, 40118, 370, -1, -18.98], [62624382, 166, 40118, 370, -1, -18.98], [62624382, 166, 40118, 370, 1, 18.98], [62624382, 166, 40118, 370, 1, 18.98], [68614651, 166, 40118, 370, 1, 3.99], [62684907, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, -1, -13.99], [62694193, 166, 40118, 375, 1, 11.99], [62694327, 184, 40118, 375, -1, -10.39], [63614741, 166, 40118, 395, 1, 27.99], [60614265, 166, 40118, 395, 1, 15.99], [60614265, 166, 40118, 395, 1, 15.99], [60614265, 166, 40118, 395, -1, -15.99], [60614265, 166, 40118, 395, -1, -15.99], [60614265, 166, 40118, 395, 1, 15.99], [60614265, 166, 40118, 395, -1, -15.99], [60614265, 166, 40118, 395, 1, 12.80], [62614815, 166, 40118, 405, 1, 20.00], [62634605, 184, 40118, 405, 1, 29.99], [62664135, 184, 40118, 405, 1, 11.00], [62664244, 184, 40118, 405, 1, 11.00], [62664197, 184, 40118, 405, 1, 11.00], [68634752, 59, 40118, 410, 1, 8.99], [63684098, 166, 40118, 410, 1, 1.98], [63684098, 166, 40118, 410, 1, 1.98], [63684098, 166, 40118, 410, 1, 1.98], [64684719, 166, 40118, 410, 1, 9.99], [62684548, 166, 40118, 415, 1, 39.99], [62684548, 166, 40118, 415, 1, 39.99], [68664363, 184, 40118, 415, -1, -29.95], [61694741, 166, 40118, 432, 1, 9.06], [62614534, 166, 40118, 432, 1, 9.09], [62694387, 166, 40118, 432, 1, 7.99], [62664568, 166, 40118, 432, 1, 5.99], [64664587, 184, 40118, 432, -1, -16.99], [63604715, 184, 40118, 432, -1, -6.99], [63604715, 184, 40118, 432, -1, -6.99], [63604715, 184, 40118, 432, -1, -6.99], [62644344, 184, 40118, 432, 1, 10.99], [66644706, 184, 40118, 432, 1, 10.99], [62644528, 184, 40118, 432, 1, 10.99], [62644764, 184, 40118, 432, 1, 10.99], [64684534, 166, 40118, 440, 1, 14.99], [62664151, 166, 40118, 455, 1, 25.00], [62664674, 166, 40118, 471, 1, 24.99], [62654875, 184, 40118, 471, 1, 39.99], [62694575, 166, 40118, 475, 1, 14.99], [62684517, 184, 40118, 475, -1, -29.99], [64674609, 166, 40118, 485, 1, 29.99], [60674335, 184, 40118, 485, 1, 19.95], [60674335, 184, 40118, 485, -1, -19.95], [60674335, 184, 40118, 485, 1, 12.99], [62674960, 184, 40118, 490, -1, -16.00], [62674960, 184, 40118, 490, 1, 16.00], [60624185, 166, 40118, 500, 1, 8.99], [60624314, 166, 40118, 500, 1, 8.99], [60634192, 184, 40118, 500, 1, 24.99], [60624241, 184, 40118, 500, 1, 34.99], [62684028, 166, 40118, 520, 1, 29.99], [62634962, 184, 40118, 530, -1, -6.89], [62644205, 184, 40118, 590, 1, 24.99], [62604912, 184, 40118, 590, 1, 24.89], [62644590, 184, 40118, 590, -1, -22.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [61614174, 184, 40118, 620, 1, 49.99], [61614174, 184, 40118, 620, 1, 29.99], [62634996, 166, 40118, 650, 1, 9.99], [62644079, 184, 40118, 650, 1, 9.99], [62634996, 184, 40118, 650, 1, 9.99], [62644079, 184, 40118, 650, 1, 9.99], [61694023, 184, 40118, 650, 1, 14.99], [61694023, 184, 40118, 650, 1, 14.99], [61674701, 166, 40118, 670, 1, 3.99], [63654007, 166, 40118, 670, 1, 56.99], [60624270, 184, 40118, 670, 1, 0.95], [66614582, 184, 40118, 670, -1, -15.99], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99], [61684889, 166, 40118, 685, 1, 4.49], [61684889, 166, 40118, 685, 1, 4.49], [64604876, 166, 40118, 801, 1, 29.62], [64604876, 166, 40118, 801, 1, 29.62], [64644495, 166, 40118, 801, 1, 29.65], [67624103, 166, 40118, 801, 1, 16.50], [64644495, 166, 40118, 801, 1, 29.65], [64644433, 184, 40118, 801, 1, 24.99], [64604930, 184, 40118, 801, -1, -35.95], [67604116, 184, 40118, 801, 1, 21.00], [64664047, 184, 40118, 801, 1, 22.99], [63624756, 184, 40118, 801, 1, 21.00], [67604116, 184, 40118, 801, 1, 21.00], [62644445, 184, 40118, 801, 1, 69.95], [60684907, 166, 40118, 805, 1, 5.50], [64604829, 184, 40118, 805, -1, -29.99], [64644860, 184, 40118, 805, -1, -3.95], [63654091, 184, 40118, 805, 1, 4.95], [64654096, 184, 40118, 805, 1, 4.95], [65604476, 166, 40118, 830, 1, 19.95], [63694264, 184, 40118, 830, 1, 19.95], [62654454, 166, 40118, 845, 1, 5.95], [64634712, 166, 40118, 845, 1, 3.90], [68674372, 184, 40118, 845, 1, 2.00], [63684755, 184, 40118, 845, 1, 2.00], [62694170, 166, 40118, 851, 1, 16.99], [62674092, 166, 40118, 851, 1, 15.99], [69684804, 184, 40118, 851, 1, 9.99], [68694729, 184, 40118, 855, -1, -16.99], [63624299, 166, 40118, 870, 1, 10.99], [63624367, 166, 40118, 870, 1, 11.19], [68604041, 184, 40118, 870, -1, -19.99], [62604338, 184, 40118, 870, 1, 69.99], [67614923, 184, 40118, 875, -1, -19.95], [60614487, 59, 40118, 878, 1, 5.95], [63644339, 59, 40118, 878, 1, 12.65], [62684043, 184, 40118, 878, -1, -19.95], [62684043, 184, 40118, 878, 1, 19.95], [68684135, 184, 40118, 878, -1, -249.00], [68684135, 184, 40118, 878, 1, 269.00], [68684135, 184, 40118, 878, -1, -269.00], [68684135, 184, 40118, 878, 1, 249.00], [66664981, 184, 40118, 901, 1, 3.09], [66684899, 184, 40118, 901, 1, 12.99], [60664257, 184, 40118, 901, 1, 2.12], [67674341, 184, 40118, 901, -1, -19.95], [66674079, 184, 40118, 901, 1, 3.95], [66674130, 184, 40118, 901, 1, 3.95], [63604361, 184, 40118, 901, 1, 3.99], [62634259, 184, 40118, 901, 1, 6.69], [62634259, 184, 40118, 901, 1, 6.69], [63604108, 184, 40118, 901, 1, 3.95], [69614229, 166, 40118, 902, 1, 15.95], [68644966, 166, 40118, 902, 1, 12.50], [68644966, 166, 40118, 902, -1, -12.50], [68644966, 166, 40118, 902, 1, 0.01], [69614274, 184, 40118, 902, 1, 9.95], [61604095, 184, 40118, 902, 1, 12.50], [66664028, 184, 40118, 902, 1, 14.95], [68654621, 184, 40118, 902, 1, 12.95], [69664149, 184, 40118, 903, -1, -5.99], [69664163, 184, 40118, 903, -1, -1.39], [69664668, 184, 40118, 903, 1, 8.95], [63694928, 166, 40118, 904, 1, 11.49], [69664661, 166, 40118, 904, 1, 14.95], [60634366, 184, 40118, 904, 1, 7.99], [64634802, 184, 40118, 904, 1, 4.29], [60684429, 184, 40118, 904, 1, 4.89], [60684037, 184, 40118, 904, 1, 9.95], [69694875, 184, 40118, 904, 1, 19.95], [69694875, 184, 40118, 904, 1, 19.95], [69694875, 184, 40118, 904, 1, 19.95], [69694875, 184, 40118, 904, -1, -19.95], [69694875, 184, 40118, 904, -1, -19.95], [69694875, 184, 40118, 904, -1, -19.95], [63694928, 184, 40118, 904, 1, 11.49], [60634765, 184, 40118, 904, 1, 4.99], [69614011, 166, 40118, 905, 1, 6.99], [60654072, 166, 40118, 905, 1, 4.33], [60654072, 166, 40118, 905, 1, 4.33], [68604583, 166, 40118, 905, 1, 15.99], [68604583, 166, 40118, 905, -1, -15.99], [68604583, 166, 40118, 905, 1, 15.99], [68604583, 166, 40118, 905, -1, -15.99], [68604583, 166, 40118, 905, 1, 12.80], [68614329, 166, 40118, 905, 1, 39.99], [67674299, 184, 40118, 905, 1, 4.99], [62634323, 184, 40118, 905, 1, 149.00], [69674069, 166, 40118, 910, 1, 10.49], [65674532, 20, 40118, 929, 1, 3.59], [67674686, 59, 40118, 929, 1, 3.99], [63634081, 166, 40118, 929, 1, 3.89], [67664966, 166, 40118, 929, 1, 0.89], [67664966, 166, 40118, 929, 1, 0.89], [60694417, 166, 40118, 929, 1, 0.65], [65694328, 166, 40118, 929, 1, 0.59], [67664645, 166, 40118, 929, 1, 1.39], [65674126, 184, 40118, 929, 1, 2.69], [63664932, 184, 40118, 929, 1, 1.59], [62694503, 184, 40118, 929, 1, 2.99], [64684439, 184, 40118, 929, 1, 9.99], [64664270, 184, 40118, 929, 1, 3.19], [60644305, 184, 40118, 929, 1, 0.89], [67674119, 184, 40118, 929, 1, 1.89], [69694354, 184, 40118, 929, 1, 2.99], [63634656, 184, 40118, 929, -1, -5.50], [67624120, 184, 40118, 940, 1, 0.98], [67624120, 184, 40118, 940, -1, -0.98], [67624120, 184, 40118, 940, 1, 0.49], [67624120, 184, 40118, 940, 1, 0.98], [67624120, 184, 40118, 940, -1, -0.98], [67624120, 184, 40118, 940, 1, 0.49], [66614192, 184, 40118, 940, 1, 1.23], [66614192, 184, 40118, 940, -1, -1.23], [66614192, 184, 40118, 940, 1, 0.69], [66614192, 184, 40118, 940, 1, 1.23], [66614192, 184, 40118, 940, -1, -1.23], [66614192, 184, 40118, 940, 1, 0.69], [67624473, 184, 40118, 940, 1, 0.50], [67624473, 184, 40118, 940, -1, -0.50], [67624473, 184, 40118, 940, 1, 0.19], [64634429, 20, 40118, 957, 1, 3.99], [66624458, 20, 40118, 957, 1, 0.89], [63674861, 20, 40118, 957, 10, 2.70], [64614401, 59, 40118, 957, 1, 1.99], [64614401, 59, 40118, 957, 1, 1.99], [62684217, 59, 40118, 957, 1, 9.99], [64624770, 59, 40118, 957, 1, 2.59], [66624253, 166, 40118, 957, 1, 3.49], [66624253, 166, 40118, 957, 1, 3.49], [64654284, 166, 40118, 957, 1, 3.99], [66624829, 166, 40118, 957, 1, 1.99], [62664909, 166, 40118, 957, 1, 3.29], [62674751, 166, 40118, 957, 1, 1.99], [62674492, 166, 40118, 957, 1, 1.49], [62674492, 166, 40118, 957, 1, 1.49], [64634500, 184, 40118, 957, -1, -9.99], [62694272, 184, 40118, 957, 1, 2.49], [63674184, 184, 40118, 957, 1, 164.00], [67634503, 166, 40118, 970, 1, 24.99], [67634503, 184, 40118, 970, 1, 24.99], [67634503, 184, 40118, 970, 1, 24.99], [67634497, 184, 40118, 970, 1, 24.99], [69674452, 184, 40118, 970, 1, 19.99], [60694909, 184, 40118, 998, 1, 2.00]]'
)
select_menu(
commonBits.fl('Window') + '>>DTAR020.bin>>' +
commonBits.fl('Table:') + '1')
assert_p(
'Table', 'Content',
'[[69684558, 20, 40118, 280, 1, 5.01], [69694158, 20, 40118, 280, 1, 19.00], [69694158, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [63604808, 20, 40118, 170, 1, 4.87], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99], [64634429, 20, 40118, 957, 1, 3.99], [66624458, 20, 40118, 957, 1, 0.89], [63674861, 20, 40118, 957, 10, 2.70], [65674532, 20, 40118, 929, 1, 3.59], [64614401, 59, 40118, 957, 1, 1.99], [64614401, 59, 40118, 957, 1, 1.99], [61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99]]'
)
select_menu(
commonBits.fl('Window') + '>>DTAR020.bin>>' +
commonBits.fl('Table:') + '2')
assert_p(
'Table', 'Content',
'[[60614487, 59, 40118, 878, 1, 5.95], [63644339, 59, 40118, 878, 1, 12.65], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [62684217, 59, 40118, 957, 1, 9.99], [67674686, 59, 40118, 929, 1, 3.99], [61684613, 59, 40118, 335, 1, 12.99], [64624770, 59, 40118, 957, 1, 2.59], [69694814, 166, 40118, 360, 1, 2.50], [69694814, 166, 40118, 360, 1, 2.50], [69644164, 166, 40118, 193, 1, 21.59], [62684907, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, -1, -13.99]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'Ams_LocDownload_20041228.txt')
commonBits.setRecordLayout(select, 'ams Store')
click(commonBits.fl('Edit') + '1')
click('Filter')
commonBits.filter(click)
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(commonBits.fl('Data') + '>>' + commonBits.fl('Sort'))
# select('Table1', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)')
## select('List', 'ams Store')
select('Table', 'cell:' + commonBits.fl('Field') + ',0( )')
click('ScrollPane$ScrollBar', 9, 108)
select('Table', 'Loc State', commonBits.fl('Field') + ',0')
select('Table', 'Loc Nbr', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(Loc Nbr)')
commonBits.sort(click)
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(commonBits.fl('Edit Record'))
select('Table', 'cell:' + commonBits.fl('Data') + ',2(ST)')
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:' + commonBits.fl('Data') + ',2(ST)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(Coffs Harbour)')
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:' + commonBits.fl('Data') + ',4(Coffs Harbour)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(Albury)')
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:' + commonBits.fl('Data') + ',4(Albury)')
click('RightM')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Cnr Nicholson & Bannister Rd\'s)')
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:' + commonBits.fl('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', 'ams Store')
select('Table', 'Loc Type', commonBits.fl('Field') + ',0')
select('Table', 'Loc Nbr', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(Loc Nbr)')
commonBits.sort(click)
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(commonBits.fl('Edit Record'))
## select('Table1', 'cell:10 - 35|Loc Name,0(National Ad Support)')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(National Ad Support)')
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:' + commonBits.fl('Data') + ',3(National Ad Support)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(Head Office)')
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:' + commonBits.fl('Data') + ',3(Head Office)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(30-68 Taras Ave)')
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:' + commonBits.fl('Data') + ',5(30-68 Taras Ave)')
click('Right')
click('Right')
click('Right')
click('Right')
click('Right')
click('Right')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(No 2 Sydney Gate)')
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:' + commonBits.fl('Data') + ',4(No 2 Sydney Gate)')
click('RightM')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Cnr Grove Way & Golden Grove)')
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:' + commonBits.fl('Data') + ',5(Cnr Grove Way & Golden Grove)')
click('Left')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(2-50 Murray Road)')
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:' + commonBits.fl('Data') + ',5(2-50 Murray Road)')
click('Left')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Gilchrist Drive)')
assert_p('Table', 'Text', 'Gilchrist Drive', commonBits.fl('Data') + ',5')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Gilchrist Drive)')
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:' + commonBits.fl('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()