def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window(commonBits.applicationName()): select_menu('Utilities>>Compare Menu') click('*1') click('FileSearch') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract.bin') click('Open') close() click('FileSearch1') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract2.bin') click('Open') close() #commonBits.setRecordLayout2(select, 'ams Store') click('Right') select('TabbedPane', '') select('Table1', 'cell:Include,2(true)') select('Table1', 'cell:Include,5(true)') select('Table1', 'cell:Include,8(true)') select('Table1', 'cell:Field,5(Loc_Addr_Ln2)') assert_p( 'Table1', 'Content', '[[Brand_Id, true], [Loc_Nbr, true], [Loc_Type, false], [Loc_Name, true], [Loc_Addr_Ln1, true], [Loc_Addr_Ln2, false], [Loc_Addr_Ln3, true], [Loc_Postcode, true], [Loc_State, false], [Loc_Actv_Ind, true]]' ) select('Table1', 'cell:Field,5(Loc_Addr_Ln2)') click('Right') select('TabbedPane', '') click('Compare') select('Table', 'cell:Loc_Addr_Ln1,8(Marayong Offsite Reserve)') assert_p('Table', 'Text', 'Marketown', 'Loc_Addr_Ln1,10') ##zzzzzz select('Table', 'cell:Loc_Addr_Ln1,14(Bass Hill Plaza)') assert_p( 'Table', 'Content', '[[, , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC - Taras Ave, , Altona North, 3025, A], [, , , , , , , , , ], [, Inserted, 2, TAR, 5850, VIC West Ad Support, , Laverton, 3028, A], [, Old, 4, TAR, 5035, Rockdale, Building B, Portside DC, Botany, 2019, A], [, New, 6, , 5096, Canberra Civic, Target Canberra, Canberra, 2601, ], [, Old, 5, TAR, 5037, Miranda, Westfield Shoppingtown, Miranda, 2228, A], [, New, 7, , 5012, Ringwood, Ringwood, Ringwood, 3134, ], [, Old, 6, TAR, 5052, Eastwood, Marayong Offsite Reserve, Marayong, 2148, A], [, New, 8, , 5030, Epping, Epping Plaza Shopping Centre, Epping, 3076, ], [, Old, 7, TAR, 5055, Leichhardt, Marketown, Leichhardt, 2040, A], [, New, 9, , 5054, Highpoint City, Laverton, Laverton, 3028, ], [, Old, 8, TAR, 5060, St Marys, St. Mary\'s, St Mary\'s, 2760, A], [, New, 10, , 5062, Castletown, Townsville, Townsville, 4810, ], [, Old, 9, TAR, 5070, Bass Hill, Bass Hill Plaza, Bass Hill, 2197, A], [, New, 11, , 5138, Cairns Central, Cairns, Cairns, 4870, ], [, Old, 10, TAR, 5074, Campbelltown, Campbelltown Mall, Campbelltown, 2560, A], [, New, 12, , 5141, The Willows, Thuringowa Central, Thuringowa Central, 4817, ], [, Old, 11, TAR, 5078, Warringah Mall, Frenchs Forest, Frenchs Forest, 2086, A], [, New, 13, , 5146, Palmerston, Palmerston Shopping Centre, Palmerston, 830, ], [, Old, 12, TAR, 5081, Ashfield, Ashfield Mall, Ashfield, 2131, A], [, New, 14, , 5002, Coffs Harbour, Coffs Harbour, Coffs Harbour, 2450, ], [, Old, 13, TAR, 5085, Roselands, Condell park, Condell Park, 2200, A], [, New, 15, , 5966, Huntingwood DC, Huntingwood DC, Huntingwood, 2148, ], [, , , , , , , , , ], [, Inserted, 16, TAR, 5967, Hendra DC, Hendra DC, Hendra, 4011, A], [, , , , , , , , , ], [, Inserted, 17, TAR, 5968, Beverly DC, Beverly DC, Beverly, 5009, A]]' ) select('Table', 'cell:Loc_Postcode,15(4870)') assert_p('Table', 'Text', '4817', 'Loc_Postcode,17') select('Table', 'cell:Loc_Postcode,15(4870)') click('All Included Lines') select('Table', 'cell:Loc_Addr_Ln3,8(Marayong)') assert_p('Table', 'Text', '', 'Loc_Addr_Ln3,9') select('Table', 'cell:Loc_Addr_Ln3,6(Penrith)') assert_p('Table', 'RowCount', '34') select('Table', 'cell:Loc_Addr_Ln1,6(Penrith)') assert_p( 'Table', 'Content', '[[, , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC - Taras Ave, , Altona North, 3025, A], [, , , , , , , , , ], [, Inserted, 2, TAR, 5850, VIC West Ad Support, , Laverton, 3028, A], [, Old, 1, TAR, 5015, Bankstown, Bankstown, Condell Park, 2200, A], [, New, 3, , , , , , , ], [, Old, 2, TAR, 5019, Penrith, Penrith, Penrith, 2750, A], [, New, 4, , , , , , , ], [, Old, 3, TAR, 5033, Blacktown, Marayong, Marayong, 2148, A], [, New, 5, , , , , , , ], [, Old, 4, TAR, 5035, Rockdale, Building B, Portside DC, Botany, 2019, A], [, New, 6, , 5096, Canberra Civic, Target Canberra, Canberra, 2601, ], [, Old, 5, TAR, 5037, Miranda, Westfield Shoppingtown, Miranda, 2228, A], [, New, 7, , 5012, Ringwood, Ringwood, Ringwood, 3134, ], [, Old, 6, TAR, 5052, Eastwood, Marayong Offsite Reserve, Marayong, 2148, A], [, New, 8, , 5030, Epping, Epping Plaza Shopping Centre, Epping, 3076, ], [, Old, 7, TAR, 5055, Leichhardt, Marketown, Leichhardt, 2040, A], [, New, 9, , 5054, Highpoint City, Laverton, Laverton, 3028, ], [, Old, 8, TAR, 5060, St Marys, St. Mary\'s, St Mary\'s, 2760, A], [, New, 10, , 5062, Castletown, Townsville, Townsville, 4810, ], [, Old, 9, TAR, 5070, Bass Hill, Bass Hill Plaza, Bass Hill, 2197, A], [, New, 11, , 5138, Cairns Central, Cairns, Cairns, 4870, ], [, Old, 10, TAR, 5074, Campbelltown, Campbelltown Mall, Campbelltown, 2560, A], [, New, 12, , 5141, The Willows, Thuringowa Central, Thuringowa Central, 4817, ], [, Old, 11, TAR, 5078, Warringah Mall, Frenchs Forest, Frenchs Forest, 2086, A], [, New, 13, , 5146, Palmerston, Palmerston Shopping Centre, Palmerston, 830, ], [, Old, 12, TAR, 5081, Ashfield, Ashfield Mall, Ashfield, 2131, A], [, New, 14, , 5002, Coffs Harbour, Coffs Harbour, Coffs Harbour, 2450, ], [, Old, 13, TAR, 5085, Roselands, Condell park, Condell Park, 2200, A], [, New, 15, , 5966, Huntingwood DC, Huntingwood DC, Huntingwood, 2148, ], [, , , , , , , , , ], [, Inserted, 16, TAR, 5967, Hendra DC, Hendra DC, Hendra, 4011, A], [, , , , , , , , , ], [, Inserted, 17, TAR, 5968, Beverly DC, Beverly DC, Beverly, 5009, A]]' ) close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Protocol Buffer Editor'): select_menu('Utilities>>Compare Menu') click('*1') click('Choose File') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract.bin') click('Open') close() click('Choose File1') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract2.bin') click('Open') close() #commonBits.setRecordLayout2(select, 'ams Store') click('Right') select('TabbedPane', '') select('Table1', 'cell:Include,2(true)') select('Table1', 'cell:Include,5(true)') select('Table1', 'cell:Include,8(true)') select('Table1', 'cell:Field,5(Loc_Addr_Ln2)') assert_p('Table1', 'Content', '[[Brand_Id, true], [Loc_Nbr, true], [Loc_Type, false], [Loc_Name, true], [Loc_Addr_Ln1, true], [Loc_Addr_Ln2, false], [Loc_Addr_Ln3, true], [Loc_Postcode, true], [Loc_State, false], [Loc_Actv_Ind, true]]') select('Table1', 'cell:Field,5(Loc_Addr_Ln2)') click('Right') select('TabbedPane', '') click('Compare') select('Table', 'cell:Loc_Addr_Ln1,8(Marayong Offsite Reserve)') assert_p('Table', 'Text', 'Marketown', 'Loc_Addr_Ln1,10') ##zzzzzz select('Table', 'cell:Loc_Addr_Ln1,14(Bass Hill Plaza)') assert_p('Table', 'Content', '[[, , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC - Taras Ave, , Altona North, 3025, A], [, , , , , , , , , ], [, Inserted, 2, TAR, 5850, VIC West Ad Support, , Laverton, 3028, A], [, Old, 4, TAR, 5035, Rockdale, Building B, Portside DC, Botany, 2019, A], [, New, 6, , 5096, Canberra Civic, Target Canberra, Canberra, 2601, ], [, Old, 5, TAR, 5037, Miranda, Westfield Shoppingtown, Miranda, 2228, A], [, New, 7, , 5012, Ringwood, Ringwood, Ringwood, 3134, ], [, Old, 6, TAR, 5052, Eastwood, Marayong Offsite Reserve, Marayong, 2148, A], [, New, 8, , 5030, Epping, Epping Plaza Shopping Centre, Epping, 3076, ], [, Old, 7, TAR, 5055, Leichhardt, Marketown, Leichhardt, 2040, A], [, New, 9, , 5054, Highpoint City, Laverton, Laverton, 3028, ], [, Old, 8, TAR, 5060, St Marys, St. Mary\'s, St Mary\'s, 2760, A], [, New, 10, , 5062, Castletown, Townsville, Townsville, 4810, ], [, Old, 9, TAR, 5070, Bass Hill, Bass Hill Plaza, Bass Hill, 2197, A], [, New, 11, , 5138, Cairns Central, Cairns, Cairns, 4870, ], [, Old, 10, TAR, 5074, Campbelltown, Campbelltown Mall, Campbelltown, 2560, A], [, New, 12, , 5141, The Willows, Thuringowa Central, Thuringowa Central, 4817, ], [, Old, 11, TAR, 5078, Warringah Mall, Frenchs Forest, Frenchs Forest, 2086, A], [, New, 13, , 5146, Palmerston, Palmerston Shopping Centre, Palmerston, 830, ], [, Old, 12, TAR, 5081, Ashfield, Ashfield Mall, Ashfield, 2131, A], [, New, 14, , 5002, Coffs Harbour, Coffs Harbour, Coffs Harbour, 2450, ], [, Old, 13, TAR, 5085, Roselands, Condell park, Condell Park, 2200, A], [, New, 15, , 5966, Huntingwood DC, Huntingwood DC, Huntingwood, 2148, ], [, , , , , , , , , ], [, Inserted, 16, TAR, 5967, Hendra DC, Hendra DC, Hendra, 4011, A], [, , , , , , , , , ], [, Inserted, 17, TAR, 5968, Beverly DC, Beverly DC, Beverly, 5009, A]]') select('Table', 'cell:Loc_Postcode,15(4870)') assert_p('Table', 'Text', '4817', 'Loc_Postcode,17') select('Table', 'cell:Loc_Postcode,15(4870)') click('All Included Lines') select('Table', 'cell:Loc_Addr_Ln3,8(Marayong)') assert_p('Table', 'Text', '', 'Loc_Addr_Ln3,9') select('Table', 'cell:Loc_Addr_Ln3,6(Penrith)') assert_p('Table', 'RowCount', '34') select('Table', 'cell:Loc_Addr_Ln1,6(Penrith)') assert_p('Table', 'Content', '[[, , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC - Taras Ave, , Altona North, 3025, A], [, , , , , , , , , ], [, Inserted, 2, TAR, 5850, VIC West Ad Support, , Laverton, 3028, A], [, Old, 1, TAR, 5015, Bankstown, Bankstown, Condell Park, 2200, A], [, New, 3, , , , , , , ], [, Old, 2, TAR, 5019, Penrith, Penrith, Penrith, 2750, A], [, New, 4, , , , , , , ], [, Old, 3, TAR, 5033, Blacktown, Marayong, Marayong, 2148, A], [, New, 5, , , , , , , ], [, Old, 4, TAR, 5035, Rockdale, Building B, Portside DC, Botany, 2019, A], [, New, 6, , 5096, Canberra Civic, Target Canberra, Canberra, 2601, ], [, Old, 5, TAR, 5037, Miranda, Westfield Shoppingtown, Miranda, 2228, A], [, New, 7, , 5012, Ringwood, Ringwood, Ringwood, 3134, ], [, Old, 6, TAR, 5052, Eastwood, Marayong Offsite Reserve, Marayong, 2148, A], [, New, 8, , 5030, Epping, Epping Plaza Shopping Centre, Epping, 3076, ], [, Old, 7, TAR, 5055, Leichhardt, Marketown, Leichhardt, 2040, A], [, New, 9, , 5054, Highpoint City, Laverton, Laverton, 3028, ], [, Old, 8, TAR, 5060, St Marys, St. Mary\'s, St Mary\'s, 2760, A], [, New, 10, , 5062, Castletown, Townsville, Townsville, 4810, ], [, Old, 9, TAR, 5070, Bass Hill, Bass Hill Plaza, Bass Hill, 2197, A], [, New, 11, , 5138, Cairns Central, Cairns, Cairns, 4870, ], [, Old, 10, TAR, 5074, Campbelltown, Campbelltown Mall, Campbelltown, 2560, A], [, New, 12, , 5141, The Willows, Thuringowa Central, Thuringowa Central, 4817, ], [, Old, 11, TAR, 5078, Warringah Mall, Frenchs Forest, Frenchs Forest, 2086, A], [, New, 13, , 5146, Palmerston, Palmerston Shopping Centre, Palmerston, 830, ], [, Old, 12, TAR, 5081, Ashfield, Ashfield Mall, Ashfield, 2131, A], [, New, 14, , 5002, Coffs Harbour, Coffs Harbour, Coffs Harbour, 2450, ], [, Old, 13, TAR, 5085, Roselands, Condell park, Condell Park, 2200, A], [, New, 15, , 5966, Huntingwood DC, Huntingwood DC, Huntingwood, 2148, ], [, , , , , , , , , ], [, Inserted, 16, TAR, 5967, Hendra DC, Hendra DC, Hendra, 4011, A], [, , , , , , , , , ], [, Inserted, 17, TAR, 5968, Beverly DC, Beverly DC, Beverly, 5009, A]]') close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Record Editor'): commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare Menu') click('*2') click('Choose File') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract.txt') click('Open') close() commonBits.setRecordLayout(select, 'ams Store') click('Right') select('TabbedPane', '') click('Choose File') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract2.txt') click('Open') close() commonBits.setRecordLayout(select, 'ams Store') click('Right') select('TabbedPane', '') click('Right') select('TabbedPane', '') click('Compare') select('Table', 'cell:Loc Name,11(Highpoint City)') assert_p('Table', 'Text', 'St Marys', 'Loc Name,12') select('Table', 'cell:Loc Name,14(Bass Hill)') assert_p( 'Table', 'Content', '[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 0830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]' ) select('Table', 'cell:Loc Name,14(Bass Hill)') click('All Included Lines') select('Table', 'cell:Loc Addr Ln1,8(Marayong)') assert_p( 'Table', 'Content', '[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 1, TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 3, , , , , , , , , , ], [, Old, 2, TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [, New, 4, , , , , , , , , , ], [, Old, 3, TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 5, , , , , , , , , , ], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 0830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]' ) select('Table', 'cell:Loc Addr Ln1,8(Marayong)') close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Record Editor'): commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare Menu') click('*1') click('Choose File') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract.txt') click('Open') close() commonBits.setRecordLayout2(select, 'ams Store') click('Choose File1') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract2.txt') click('Open') close() click('Right') select('TabbedPane', '') select('Table1', 'cell:Include,4(true)') select('Table1', 'cell:Include,5(true)') select('Table1', 'cell:Include,6(true)') click('Right') select('TabbedPane', '') click('Compare') select('Table', 'cell:Loc Name,6(Miranda)') assert_p('Table', 'Text', 'Miranda', 'Loc Name,6') select('Table', 'cell:Loc Name,6(Miranda)') assert_p( 'Table', 'Content', '[[, , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, 3025, VIC, A], [, , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, 2148, NSW, A], [, New, 8, , 5030, , Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, 2760, NSW, A], [, New, 10, , 5062, , Castletown, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, 0830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, 2148, , ], [, , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, 4011, QLD, A], [, , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, 5009, SA, A]]' ) assert_p( 'Table', 'Content', '[[, , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, 3025, VIC, A], [, , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, 2148, NSW, A], [, New, 8, , 5030, , Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, 2760, NSW, A], [, New, 10, , 5062, , Castletown, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, 0830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, 2148, , ], [, , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, 4011, QLD, A], [, , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, 5009, SA, A]]' ) select('Table', 'cell:Loc Name,21(Coffs Harbour)') assert_p('Table', 'Text', 'Coffs Harbour', 'Loc Name,21') select('Table', 'cell:Loc Name,21(Coffs Harbour)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window(commonBits.applicationName()): from Modules import commonBits click('FileSearch') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228.bin') click('Open') close() #commonBits.setRecordLayout(select, 'ams Store') click('Edit1') select('LinesTbl', 'cell:4|Loc_Name,2(NSW North Sydney Ad Support)') assert_p('LinesTbl', 'Text', 'NSW North Sydney Ad Support', '4|Loc_Name,2') select('LinesTbl', 'cell:4|Loc_Name,2(NSW North Sydney Ad Support)') assert_p('LinesTbl', 'Text', 'cell:4|Loc_Name,2(NSW North Sydney Ad Support)') select('LinesTbl', 'cell:4|Loc_Name,2(NSW North Sydney Ad Support)') 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(commonBits.fl('Choose File')) if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228.txt') click('Open') close() commonBits.setRecordLayout(select, 'ams Store') click(commonBits.fl('Edit') + '1') select('Table', 'cell:10 - 35|Loc Name,2(NSW North Sydney Ad Support)') assert_p('Table', 'Text', 'NSW North Sydney Ad Support', '10 - 35|Loc Name,2') select('Table', 'cell:10 - 35|Loc Name,2(NSW North Sydney Ad Support)') assert_p('Table', 'Text', 'cell:10 - 35|Loc Name,2(NSW North Sydney Ad Support)') select('Table', 'cell:10 - 35|Loc Name,2(NSW North Sydney Ad Support)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Protocol Buffer Editor'): select_menu('Utilities>>Compare Menu') click('*2') click('Choose File') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract.bin') click('Open') close() #commonBits.setRecordLayout(select, 'ams Store') click('Right') select('TabbedPane', '') click('Choose File') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract2.bin') click('Open') close() #commonBits.setRecordLayout(select, 'ams Store') click('Right') select('TabbedPane', '') click('Right') select('TabbedPane', '') click('Compare') select('Table', 'cell:Loc_Name,11(Highpoint City)') assert_p('Table', 'Text', 'St Marys', 'Loc_Name,12') select('Table', 'cell:Loc_Name,14(Bass Hill)') assert_p('Table', 'Content', '[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]') select('Table', 'cell:Loc_Name,14(Bass Hill)') click('All Included Lines') select('Table', 'cell:Loc_Addr_Ln1,8(Marayong)') assert_p('Table', 'Content', '[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 1, TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 3, , , , , , , , , , ], [, Old, 2, TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [, New, 4, , , , , , , , , , ], [, Old, 3, TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 5, , , , , , , , , , ], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]') select('Table', 'cell:Loc_Addr_Ln1,8(Marayong)') close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Protocol Buffer Editor'): click('Choose File') if window('Open'): select(commonBits.selectPane(), 'ams_locdownload_20041228.bin') click('Open') close() click('Edit1') click('Filter1') select('Table1', 'Loc_Type', 'Field,0') select('Table1', 'st', 'Value,0') select('Table1', 'cell:Field,2(null)') click('Save1') ##select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1') commonBits.selectFileName(select, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1') click('Save1') select_menu('Window>>ams_locdownload_20041228.bin>>Filter Options') click('Filter1') select('Table', 'cell:4|Loc_Name,0(Bankstown)') assert_p('Table', 'Text', 'Bankstown', '4|Loc_Name,0') select('Table', 'cell:3|Loc_Type,1(ST)') rightclick('Table', '3|Loc_Type,1') select_menu('Edit Record') ## select('Table1', 'cell:3|Loc_Type,1(ST)') select('Table', 'cell:Data,5(58 Leland Street)') assert_p('Table', 'Text', 'Penrith', 'Data,6') select('Table', 'cell:Data,5(58 Leland Street)') assert_p('Table', 'Content', '[[Brand_Id, 1, , TAR, TAR], [Loc_Nbr, 2, , 5019, 5019], [Loc_Type, 3, , ST, ST], [Loc_Name, 4, , Penrith, Penrith], [Loc_Addr_Ln1, 5, , Penrith, Penrith], [Loc_Addr_Ln2, 6, , 58 Leland Street, 58 Leland Street], [Loc_Addr_Ln3, 7, , Penrith, Penrith], [Loc_Postcode, 8, , 2750, 2750], [Loc_State, 9, , NSW, NSW], [Loc_Actv_Ind, 10, , A, A]]') select('Table', 'cell:Data,5(58 Leland Street)') click('BasicInternalFrameTitlePane$NoFocusButton2') select('Table', 'cell:3|Loc_Type,1(ST)') select('Table', 'cell:3|Loc_Type,1(ST)') select_menu('Window>>ams_locdownload_20041228.bin>>Table:') select('Table2', 'cell:3|Loc_Type,1(ST)') select_menu('View>>Execute Saved Filter') #select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() +'xx1') commonBits.selectFileName(select, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1') click('Run') select('Table', 'cell:4|Loc_Name,2(Blacktown)') assert_p('Table', 'Text', 'Blacktown', '4|Loc_Name,2') select('Table', 'cell:4|Loc_Name,5(Eastwood)') rightclick('Table', '4|Loc_Name,5') select_menu('Edit Record') ## select('Table1', 'cell:4|Loc_Name,5(Eastwood)') select('Table', 'cell:Data,4(Marayong Offsite Reserve)') assert_p('Table', 'Text', 'Marayong Offsite Reserve', 'Data,4') select('Table', 'cell:Data,4(Marayong Offsite Reserve)') assert_p('Table', 'Content', '[[Brand_Id, 1, , TAR, TAR], [Loc_Nbr, 2, , 5052, 5052], [Loc_Type, 3, , ST, ST], [Loc_Name, 4, , Eastwood, Eastwood], [Loc_Addr_Ln1, 5, , Marayong Offsite Reserve, Marayong Offsite Reserve], [Loc_Addr_Ln2, 6, , 11 Melissa Place, 11 Melissa Place], [Loc_Addr_Ln3, 7, , Marayong, Marayong], [Loc_Postcode, 8, , 2148, 2148], [Loc_State, 9, , NSW, NSW], [Loc_Actv_Ind, 10, , A, A]]') 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'): 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.6.0_03' if window('Protocol Buffer Editor'): select_menu('Utilities>>Compare Menu') click('*1') click('Choose File') if window('Open'): select(commonBits.selectPaneFn(), 'Ams_LocDownload_20041228_Extract.bin') click('Open') close() #commonBits.setRecordLayout2(select, 'ams Store') click('Choose File1') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228_Extract2.bin') click('Open') close() click('Right') select('TabbedPane', '') select('Table1', 'cell:Include,4(true)') select('Table1', 'cell:Include,5(true)') select('Table1', 'cell:Include,6(true)') click('Right') select('TabbedPane', '') click('Compare') select('Table', 'cell:Loc_Name,6(Miranda)') assert_p('Table', 'Text', 'Miranda', 'Loc_Name,6') select('Table', 'cell:Loc_Name,6(Miranda)') assert_p('Table', 'Content', '[[, , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, 3025, VIC, A], [, , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, 2148, NSW, A], [, New, 8, , 5030, , Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, 2760, NSW, A], [, New, 10, , 5062, , Castletown, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, 830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, 2148, , ], [, , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, 4011, QLD, A], [, , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, 5009, SA, A]]') select('Table', 'cell:Loc_Name,21(Coffs Harbour)') assert_p('Table', 'Text', 'Coffs Harbour', 'Loc_Name,21') select('Table', 'cell:Loc_Name,21(Coffs Harbour)') click('BasicInternalFrameTitlePane$NoFocusButton2') close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Record Editor'): click(commonBits.fl('Choose File')) if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228.txt') click('Open') close() commonBits.setRecordLayout(select, 'ams Store') click(commonBits.fl('Edit') + '1') select('Table', '1', '45 - 40|Loc Addr Ln1,0') select('Table', '22', '45 - 40|Loc Addr Ln1,1') select('Table', '33', '85 - 40|Loc Addr Ln2,2') select('Table', 'cell:125 - 35|Loc Addr Ln3,2()') commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare with Disk') ## select('Table1', 'cell:125 - 35|Loc Addr Ln3,2()') select('Table', 'cell:Loc Name,0(DC - Taras Ave)') assert_p('Table', 'Text', 'DC - Taras Ave', 'Loc Name,0') select('Table', 'cell:Loc Name,0(DC - Taras Ave)') ### assert_p('Table', 'Content', '[[, Old, 1, TAR, 5839, DC, DC - Taras Ave, 1, 30-68 Taras Ave, Altona North, 3025, VIC, A], [, New, 1, , , , , , , , , , ], [, Old, 2, TAR, 5850, DC, VIC West Ad Support, 22, Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, New, 2, , , , , , , , , , ], [, Old, 3, TAR, 5853, DC, NSW North Sydney Ad Support, , 33, , , , A], [, New, 3, , , , , , , , , , ]]') assert_p('Table', 'Content', '[[, Old, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, New, 1, , , , , 1, , , , , ], [, Old, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, New, 2, , , , , 22, , , , , ], [, Old, 3, TAR, 5853, DC, NSW North Sydney Ad Support, , , , , , A], [, New, 3, , , , , , 33, , , , ]]') select('Table', 'cell:Loc Name,0(DC - Taras Ave)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select('Table', 'cell:125 - 35|Loc Addr Ln3,2()') select('Table', 'cell:125 - 35|Loc Addr Ln3,2()') ## if window(r'Save Changes to file: C:\Program Files\RecordEdit\HSQLDB\SampleFiles\Ams_LocDownload_20041228.txt'): ## click('No') ## click('No') ## close() close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Record Editor'): click(commonBits.fl('Choose File')) if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228.txt') click('Open') close() click(commonBits.fl('Edit') + '1') rightclick('Table', '10 - 35|Loc Name,0') select_menu(commonBits.fl('Edit Record')) click('Find1') # click('MetalInternalFrameTitlePane', 193, 6) select('TextField', 'West') commonBits.find(click) select('Table', 'cell:' + commonBits.fl('Data') + ',3(VIC West Ad Support)') select('Table', 'cell:' + commonBits.fl('Data') + ',3(VIC West Ad Support)') assert_p('Table', 'Text', 'VIC West Ad Support', commonBits.fl('Data') + ',3') select('Table', 'cell:' + commonBits.fl('Data') + ',3(VIC West Ad Support)') commonBits.findA(click) commonBits.find(click) # commonBits.find(click) select('Table', 'cell:' + commonBits.fl('Data') + ',4(Westfield Shoppingtown)') select('Table', 'cell:' + commonBits.fl('Data') + ',4(Westfield Shoppingtown)') assert_p('Table', 'Text', 'Westfield Shoppingtown', commonBits.fl('Data') + ',4') select('Table', 'cell:' + commonBits.fl('Data') + ',4(Westfield Shoppingtown)') commonBits.findA(click) commonBits.find(click) # commonBits.find(click) select('Table', 'cell:' + commonBits.fl('Data') + ',4(Westfield Phoenix Plaza)') select('Table', 'cell:' + commonBits.fl('Data') + ',4(Westfield Phoenix Plaza)') assert_p('Table', 'Text', 'Westfield Phoenix Plaza', commonBits.fl('Data') + ',4') close()
## Check def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Protocol Buffer Editor'): from Modules import commonBits click('Choose File') if window('Open'): select(commonBits.selectPane(), 'ams_locdownload_20041228.bin') click('Open') close() #commonBits.setRecordLayout(select, 'ams Store') click('Edit1') select('Table', 'cell:4|Loc_Name,2(NSW North Sydney Ad Support)') assert_p('Table', 'Text', 'NSW North Sydney Ad Support', '4|Loc_Name,2') select('Table', 'cell:4|Loc_Name,2(NSW North Sydney Ad Support)') assert_p('Table', 'Text', 'cell:4|Loc_Name,2(NSW North Sydney Ad Support)') select('Table', 'cell:4|Loc_Name,2(NSW North Sydney Ad Support)') click('BasicInternalFrameTitlePane$NoFocusButton2')
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.6.0_03' if window('Record Editor'): click(commonBits.fl('Choose File')) if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228.txt') click('Open') close() click(commonBits.fl('Edit') + '1') click('Filter1') select('Table1', 'Loc Type', commonBits.fl('Field') + ',0') select('Table1', 'st', commonBits.fl('Value') + ',0') select('Table1', 'cell:' + commonBits.fl('Field') + ',2(null)') commonBits.save1(click) #select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1') commonBits.selectFileName( select, keystroke, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1') commonBits.save1(click) select_menu( commonBits.fl('Window') + '>>Ams_LocDownload_20041228.txt>>' + commonBits.fl('Filter Options')) commonBits.filter(click) select('Table', 'cell:10 - 35|Loc Name,0(Bankstown)') assert_p('Table', 'Text', 'Bankstown', '10 - 35|Loc Name,0') select('Table', 'cell:8 - 2|Loc Type,1(ST)') rightclick('Table', '8 - 2|Loc Type,1') select_menu(commonBits.fl('Edit Record')) ## select('Table1', 'cell:8 - 2|Loc Type,1(ST)') select('Table', 'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)') assert_p('Table', 'Text', 'Penrith', commonBits.fl('Data') + ',6') select('Table', 'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)') assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5019, 5019], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Penrith, Penrith], [Loc Addr Ln1, 45, 40, Penrith, Penrith], [Loc Addr Ln2, 85, 40, 58 Leland Street, 58 Leland Street], [Loc Addr Ln3, 125, 35, Penrith, Penrith], [Loc Postcode, 160, 10, 2750, 2750], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) select('Table', 'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select('Table', 'cell:8 - 2|Loc Type,1(ST)') select('Table', 'cell:8 - 2|Loc Type,1(ST)') select_menu( commonBits.fl('Window') + '>>Ams_LocDownload_20041228.txt>>' + commonBits.fl('Table:')) select('Table2', 'cell:8 - 2|Loc Type,1(ST)') select_menu( commonBits.fl('View') + '>>' + commonBits.fl('Execute Saved Filter')) ##select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() +'xx1') commonBits.selectFileName( select, keystroke, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1') click(commonBits.fl('Run')) select('Table', 'cell:10 - 35|Loc Name,2(Blacktown)') assert_p('Table', 'Text', 'Blacktown', '10 - 35|Loc Name,2') select('Table', 'cell:10 - 35|Loc Name,5(Eastwood)') rightclick('Table', '10 - 35|Loc Name,5') select_menu(commonBits.fl('Edit Record')) ## select('Table1', 'cell:10 - 35|Loc Name,5(Eastwood)') select( 'Table', 'cell:' + commonBits.fl('Data') + ',4(Marayong Offsite Reserve)') assert_p('Table', 'Text', 'Marayong Offsite Reserve', commonBits.fl('Data') + ',4') select( 'Table', 'cell:' + commonBits.fl('Data') + ',4(Marayong Offsite Reserve)') assert_p( 'Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5052, 5052], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Eastwood, Eastwood], [Loc Addr Ln1, 45, 40, Marayong Offsite Reserve, Marayong Offsite Reserve], [Loc Addr Ln2, 85, 40, 11 Melissa Place, 11 Melissa Place], [Loc Addr Ln3, 125, 35, Marayong, Marayong], [Loc Postcode, 160, 10, 2148, 2148], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]' ) close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Record Editor'): click(commonBits.fl('Choose File')) if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228.txt') click('Open') close() commonBits.setRecordLayout(select, 'ams Store') click(commonBits.fl('Edit') + '1') select('Table', 'cell:1 - 3|Brand Id,2(TAR)') rightclick('Table', '1 - 3|Brand Id,2') select_menu(commonBits.fl('Edit Record')) ## select('Table1', 'cell:1 - 3|Brand Id,2(TAR)') click('Find1') ## click('MetalInternalFrameTitlePane', 230, 8) select('TextField', 'West') select('TextField1', 'West_') select('ComboBox', commonBits.fl('All Fields')) click(commonBits.fl('Replace')) ## select('Table', '') select('Table', 'cell:' + commonBits.fl('Data') + ',4(West_field Shoppingtown)') select('Table', 'cell:' + commonBits.fl('Data') + ',4(West_field Shoppingtown)') assert_p('Table', 'Text', 'West_field Shoppingtown', commonBits.fl('Data') + ',4') select('Table', 'cell:' + commonBits.fl('Data') + ',4(West_field Shoppingtown)') ## click('MetalInternalFrameTitlePane', 253, 21) commonBits.findA(click) ## click('MetalInternalFrameTitlePane', 80, 17) select('ComboBox', commonBits.fl('All Fields')) commonBits.find(click) assert_p('Table', 'Text', 'Westfield Phoenix Plaza', commonBits.fl('Data') + ',4') commonBits.find(click) ## click('MetalInternalFrameTitlePane', 80, 17) select('ComboBox', commonBits.fl('All Fields')) commonBits.find(click) ## click(commonBits.fl('Replace')) ## select('ComboBox', commonBits.fl('All Fields')) click(commonBits.fl('Replace')) select( 'Table', 'cell:' + commonBits.fl('Data') + ',4(West_field Phoenix Plaza)') select( 'Table', 'cell:' + commonBits.fl('Data') + ',4(West_field Phoenix Plaza)') ## assert_p('Table', 'Text', 'West_field Phoenix Plaza', commonBits.fl('Data') + ',4') select( 'Table', 'cell:' + commonBits.fl('Data') + ',4(West_field Phoenix Plaza)') commonBits.find(click) ## click('MetalInternalFrameTitlePane', 80, 17) select('ComboBox', commonBits.fl('All Fields')) commonBits.find(click) click(commonBits.fl('Replace')) ## select('Table', '') select( 'Table', 'cell:' + commonBits.fl('Data') + ',4(West_field Shoppingtown Eastgardens)') select( 'Table', 'cell:' + commonBits.fl('Data') + ',4(West_field Shoppingtown Eastgardens)') ## assert_p('Table', 'Text', '152 Bunnerong Road', commonBits.fl('Data') + ',5') select( 'Table', 'cell:' + commonBits.fl('Data') + ',4(West_field Shoppingtown Eastgardens)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select('Table', 'cell:1 - 3|Brand Id,2(TAR)') select('Table', 'cell:1 - 3|Brand Id,2(TAR)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') # if window(r'Save Changes to file: ' + commonBits.implementationSampleDir() + 'Ams_LocDownload_20041228.txt'): # click('No') # close() close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Record Editor'): select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin') commonBits.setRecordLayout(select, 'DTAR020') commonBits.doEdit(click) select_menu('View>>Sorted Field Tree') # select('List', 'DTAR020') # select('List', 'DTAR020') select('Table', 'cell:Field,0( )') # select('List', 'DTAR020') select('Table', 'DEPT-NO', 'Field,0') select('Table', 'DATE', 'Field,1') select('Table', 'cell:Field,1(DATE)') select('Table1', 'cell:Function,3()') select('Table', 'cell:Field,1(DATE)') select('Table1', 'Maximum', 'Function,3') select('Table1', 'Sum', 'Function,4') select('Table1', 'Sum', 'Function,5') select('Table1', 'cell:Function,5(Sum)') click('Build Tree') select('JTreeTable', 'cell:DEPT-NO,0(60)') assert_p('JTreeTable', 'Text', '60', 'DEPT-NO,0') select('JTreeTable', 'cell:SALE-PRICE,0(8.74)') assert_p('JTreeTable', 'Text', '8.74', 'SALE-PRICE,0') select('JTreeTable', 'cell:SALE-PRICE,1(166.94)') assert_p('JTreeTable', 'Text', '87.46', 'SALE-PRICE,2') select('JTreeTable', 'cell:SALE-PRICE,2(87.46)') assert_p('JTreeTable', 'Text', '87.46', 'SALE-PRICE,2') select('JTreeTable', 'cell:DEPT-NO,3(160)') assert_p('JTreeTable', 'Text', '160', 'DEPT-NO,3') select('JTreeTable', 'cell:QTY-SOLD,3(-1)') assert_p('JTreeTable', 'Text', '3', 'QTY-SOLD,4') select('JTreeTable', 'cell:QTY-SOLD,1(8)') assert_p('JTreeTable', 'Text', '-1', 'QTY-SOLD,3') select_menu('File>>Save Tree as XML') if window('Open'): ## select('FilePane$3', 'x1DTAR020.bin.xml') ## select('File Name', 'x1DTAR020.bin.xml') if commonBits.isWindowsLook(): select(commonBits.selectPane(), 'xx2DTAR020.bin.xml') else: select('File Name', 'xx2DTAR020.bin.xml') click('Open') close() click('Open') select('FileChooser', commonBits.sampleDir() + 'xx2DTAR020.bin.xml') commonBits.doEdit(click) ##------------------------------------------------- rightclick('JTreeTable', 'Tree,0') # select_menu('Fully Expand Tree') select_menu('Expand Tree') select('LayoutCombo', 'DEPT-NO') #-------------------------------------------------- select('JTreeTable', 'cell:DEPT-NO,1(998)') select('JTreeTable', 'cell:DEPT-NO,1(998)') select('JTreeTable', 'cell:SALE-PRICE,1(2996.75)') select('JTreeTable', 'cell:Xml~Prefix,1(null)') rightclick('JTreeTable', 'Xml~Prefix,1') select_menu('Expand Tree') select('JTreeTable', 'cell:SALE-PRICE,1(2996.75)') assert_p('JTreeTable', 'Text', '8.44', 'SALE-PRICE,6') select('JTreeTable', 'cell:SALE-PRICE,2(8.74)') assert_p('JTreeTable', 'Text', '1', 'QTY-SOLD,9') select('JTreeTable', 'cell:SALE-PRICE,3(166.94)') assert_p('JTreeTable', 'Text', '135.00', 'SALE-PRICE,12') select('JTreeTable', 'cell:SALE-PRICE,4(87.46)') assert_p('JTreeTable', 'Text', '-4.00', 'SALE-PRICE,11') select('JTreeTable', 'cell:Key,5(160)') assert_p('JTreeTable', 'Text', '220', 'Key,8') select('JTreeTable', 'cell:SALE-PRICE,7(150.26)') assert_p('JTreeTable', 'Text', '7', 'QTY-SOLD,13') select('JTreeTable', 'cell:Xml~Prefix,2(null)') rightclick('JTreeTable', 'Xml~Prefix,2') select_menu('Edit Record') select('JTreeTable', 'cell:Xml~Prefix,2(null)') select('Table', 'cell:Data,6(8.74)') assert_p('Table', 'Text', '8.74', 'Data,6') select('Table', 'cell:Data,4(60)') assert_p( 'Table', 'Content', '[[Xml~Name, 0, , DEPT-NO, DEPT-NO], [Xml~Prefix, 3, , , ], [Xml~Namespace, 4, , , ], [Key, 5, , 60, 60], [DEPT-NO, 6, , 60, 60], [QTY-SOLD, 7, , 1, 1], [SALE-PRICE, 8, , 8.74, 8.74], [Xml~End, 1, , , ], [Following~Text, 2, , , ]]' ) click('Right') select('Table', 'cell:Data,3(40118)') select('Table', 'cell:Data,3(40118)') assert_p('Table', 'Text', '1', 'Data,5') select('Table', 'cell:Data,6(8.74)') assert_p( 'Table', 'Content', '[[Xml~Name, 0, , DATE, DATE], [Xml~Prefix, 3, , , ], [Xml~Namespace, 4, , , ], [Key, 5, , 40118, 40118], [DEPT-NO, 6, , 60, 60], [QTY-SOLD, 7, , 1, 1], [SALE-PRICE, 8, , 8.74, 8.74], [Xml~End, 1, , , ], [Following~Text, 2, , , ]]' ) click('Right') select('Table', 'cell:Data,3(60614646)') select('Table', 'cell:Data,3(60614646)') assert_p('Table', 'Text', '60614646', 'Data,3') select('Table', 'cell:Data,5(40118)') assert_p( 'Table', 'Content', '[[Xml~Name, 0, , DTAR020, DTAR020], [Xml~Prefix, 3, , , ], [Xml~Namespace, 4, , , ], [KEYCODE-NO, 5, , 60614646, 60614646], [STORE-NO, 6, , 166, 166], [DATE, 7, , 40118, 40118], [DEPT-NO, 8, , 60, 60], [QTY-SOLD, 9, , 1, 1], [SALE-PRICE, 10, , 6.00, 6.00], [Xml~End, 1, , True, True], [Following~Text, 2, , , ]]' ) click('Right') click('Right') select('Table', 'cell:Data,3(69644897)') select('Table', 'cell:Data,3(69644897)') assert_p('Table', 'Text', '166', 'Data,4') select('Table', 'cell:Data,5(40118)') assert_p( 'Table', 'Content', '[[Xml~Name, 0, , DTAR020, DTAR020], [Xml~Prefix, 3, , , ], [Xml~Namespace, 4, , , ], [KEYCODE-NO, 5, , 69644897, 69644897], [STORE-NO, 6, , 166, 166], [DATE, 7, , 40118, 40118], [DEPT-NO, 8, , 60, 60], [QTY-SOLD, 9, , 1, 1], [SALE-PRICE, 10, , 5.08, 5.08], [Xml~End, 1, , True, True], [Following~Text, 2, , , ]]' ) select('Table', 'cell:Data,6(60)') select('Table', 'cell:Data,6(60)') assert_p('Table', 'Text', '1', 'Data,7') select('Table', 'cell:Data,6(60)') click('Right') select('Table', 'cell:Data,3(68654655)') select('Table', 'cell:Data,3(68654655)') assert_p( 'Table', 'Content', '[[Xml~Name, 0, , DTAR020, DTAR020], [Xml~Prefix, 3, , , ], [Xml~Namespace, 4, , , ], [KEYCODE-NO, 5, , 68654655, 68654655], [STORE-NO, 6, , 166, 166], [DATE, 7, , 40118, 40118], [DEPT-NO, 8, , 60, 60], [QTY-SOLD, 9, , 1, 1], [SALE-PRICE, 10, , 5.08, 5.08], [Xml~End, 1, , True, True], [Following~Text, 2, , , ]]' ) close()
def test(): from Modules import commonBits java_recorded_version = '1.5.0_11' if window('Record Editor'): click('Choose File') if window('Open'): select(commonBits.selectPane(), 'Ams_PODownload_20041231.txt') click('Open') close() commonBits.setRecordLayout(select, 'ams PO Download') click('Edit1') select('Table', 'cell:3 - 4|DC Number 1,0(4534)') rightclick('Table', '3 - 4|DC Number 1,0') select_menu('Edit Record') ## select('Table1', 'cell:3 - 4|DC Number 1,0(4534)') select('Table', 'cell:Data,2(6060)') assert_p('Table', 'Text', '6060', 'Data,2') select('Table', 'cell:Data,3(286225)') assert_p('Table', 'Content', '[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.349, 45349], [Vendor, 8, 10, 6060, 0000006060], [PO, 18, 12, 286225, 286225], [Entry Date, 30, 6, 040909, 040909], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 200, 200], [Expected Reciept Date, 52, 6, 050102, 050102], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, LADIES KNI, LADIES KNI], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]') select('Table', 'cell:Data,3(286225)') assert_p('Table', 'RowCount', '17') select('Table', 'cell:Data,3(286225)') click('Right') select('Table', 'cell:Field,3(APN)') assert_p('Table', 'Text', 'APN', 'Field,3') select('Table', 'cell:Field,3(APN)') select('Table', 'cell:Field,5(Product)') assert_p('Table', 'Content', '[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 7.0000, 000070000], [Pack Cost, 12, 13, 0.0002, 0000000000002], [APN, 25, 13, 2222500000000, 2222500000000], [Filler, 38, 1, , ], [Product, 39, 8, 43314531, 43314531], [pmg dtl tech key, 72, 15, 2075359, 2075359], [Case Pack id, 87, 15, 45614531, 45614531], [Product Name, 101, 50, DONKEY 24-006607 SHWL WRAP CARD, DONKEY 24-006607 SHWL WRAP CARD]]') select('Table', 'cell:Field,8(Product Name)') assert_p('Table', 'RowCount', '9') select('Table', 'cell:Field,8(Product Name)') click('Right') select('Table', 'cell:Data,0(S1)') assert_p('Table', 'RowCount', '19') select('Table', 'cell:Data,0(S1)') assert_p('Table', 'Content', '[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5043, 5043], [Pack Quantity 1, 7, 8, 1, 00000001], [DC Number 2, 15, 4, 5045, 5045], [Pack Quantity 2, 19, 8, 1, 00000001], [DC Number 4, 39, 4, 5076, 5076], [Pack Quantity 4, 43, 8, 1, 00000001], [DC Number 5, 51, 4, 5079, 5079], [Pack Quantity 5, 55, 8, 1, 00000001], [DC Number 6, 63, 4, 5151, 5151], [Pack Quantity 6, 67, 8, 1, 00000001], [DC Number 7, 75, 4, 5072, 5072], [Pack Quantity 7, 79, 8, 1, 00000001], [DC Number 8, 87, 4, , ], [Pack Quantity 8, 91, 8, 0, 00000000], [DC Number 9, 99, 4, , ], [Pack Quantity 9, 103, 8, 0, 00000000], [DC Number 10, 111, 4, , ], [Pack Quantity 10, 115, 8, 0, 00000000]]') select('Table', 'cell:Data,11(5072)') assert_p('Table', 'Text', '5072', 'Data,11') select('Table', 'cell:Data,11(5072)') click('Right') select('Table', 'cell:Data,8( MILK 24-006607 SHWL WRAP CARD)') assert_p('Table', 'Text', ' MILK 24-006607 SHWL WRAP CARD', 'Data,8') select('Table', 'cell:Data,8( MILK 24-006607 SHWL WRAP CARD)') select('Table', 'cell:Data,7(5614944)') assert_p('Table', 'Content', '[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 4.0000, 000040000], [Pack Cost, 12, 13, 148.3200, 0000001483200], [APN, 25, 13, 0, 0000000000000], [Filler, 38, 1, , ], [Product, 39, 8, 5614944, 05614944], [pmg dtl tech key, 72, 15, 2075360, 2075360], [Case Pack id, 87, 15, 5614944, 5614944], [Product Name, 101, 50, MILK 24-006607 SHWL WRAP CARD, MILK 24-006607 SHWL WRAP CARD]]') select('Table', 'cell:Data,6(2075360)') assert_p('Table', 'RowCount', '9') select('Table', 'cell:Data,6(2075360)') click('Right') select('Table', 'cell:Data,6(49440001)') assert_p('Table', 'Text', '49440001', 'Data,6') select('Table', 'cell:Data,1(5045)') assert_p('Table', 'Content', '[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5045, 5045], [Pack Quantity 1, 7, 8, 1, 00000001], [DC Number 2, 15, 4, 5076, 5076], [Pack Quantity 2, 19, 8, 1, 00000001], [DC Number 4, 39, 4, 3331, 3331], [Pack Quantity 4, 43, 8, 49440001, 49440001], [DC Number 5, 51, 4, , ], [Pack Quantity 5, 55, 8, 0, 00000000], [DC Number 6, 63, 4, , ], [Pack Quantity 6, 67, 8, 0, 00000000], [DC Number 7, 75, 4, , ], [Pack Quantity 7, 79, 8, 0, 00000000], [DC Number 8, 87, 4, , ], [Pack Quantity 8, 91, 8, 0, 00000000], [DC Number 9, 99, 4, , ], [Pack Quantity 9, 103, 8, 0, 00000000], [DC Number 10, 111, 4, , ], [Pack Quantity 10, 115, 8, 0, 00000000]]') select('Table', 'cell:Data,1(5045)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') click('Filter1') select('Table', 'false', 'Include,1') select('Table', 'false', 'Include,2') click('Filter1') select('Table', 'cell:12 - 13|Pack Cost,1(148.3200)') assert_p('Table', 'Text', '148.3200', '12 - 13|Pack Cost,1') select('Table', 'cell:12 - 13|Pack Cost,1(148.3200)') ## assert_p('Table', 'Content', '[[D1, 7.0000, 0.0002, 2222500000000, , 43314531, 2075359, 45614531, DONKEY 24-006607 SHWL WRAP CARD], [D1, 4.0000, 148.3200, 0, , 5614944, 2075360, 5614944, MILK 24-006607 SHWL WRAP CARD], [D1, 48.0000, 148.3200, 0, , 55615071, 2075361, 55615071, M.ROSE 24-006607 SHWL WRAP CARD], [D1, 4.0000, 148.3200, 0, , 55615156, 2075362, 55615156, AQUA 24-006607 SHWL WRAP CARD], [D1, 16.0000, 62281483200, 2222, , 2224531, 2075348, 5614531, DONKEY 24-006607 SHWL WRAP CARD], [D1, 8.0000, 148.3200, 0, , 62224944, 2075349, 65614944, MILK 24-006607 SHWL WRAP CARD], [D1, 108.0000, 148.3200, 0, , 62225071, 2075350, 65615071, M.ROSE 24-006607 SHWL WRAP CARD], [D1, 8.0000, 148.3200, 0, , 52225156, 2075351, 55615156, M.ROSE 24-006607 SHWL WRAP CARD], [D1, 6.0000, 148.3200, 0, , 45614531, 2075352, 45614531, DONKEY 24-006607 SHWL WRAP CARD], [D1, 3.0000, 148.3200, 0, , 45614944, 2075353, 45614944, MILK 24-006607 SHWL WRAP CARD], [D1, 44.0000, 148.3200, 0, , 45615071, 2075354, 45615071, M.ROSE 24-006607 SHWL WRAP CARD], [D1, 3.0000, 148.3200, 0, , 45615156, 2075355, 35615156, AQUA 24-006607 SHWL WRAP CARD], [D1, 30.0000, 292.6800, 0, , 45846680, 2120736, 45615156, CONCERTO BLACK LEATHER ANKLE BOOT], [D1, 29.0000, 198.3600, 0, , 45846772, 2121104, 5846772, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 29.0000, 198.3600, 0, , 45847489, 2121627, 45847489, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 25.0000, 465.4800, 0, , 45848707, 2179843, 45848707A, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 8.0000, 82.1600, 0, , 46164790, 2203070, 46164790B8, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 24.0000, 112.9700, 0, , 46164790, 2203056, 46164790, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 7.0000, 82.1600, 0, , 46165360, 2203075, 46165360B8, CABERETCARAMEL MICRO SUEDE PEEP TOE], [D1, 23.0000, 112.9700, 0, , 46165360, 2203072, 46165360, CABERETCARAMEL MICRO SUEDE PEEP TOE], [D1, 8.0000, 83.8400, 0, , 45928553, 2203222, 45928553B8, CABERETCARAMEL MICRO SUEDE PEEP TOE], [D1, 22.0000, 125.7600, 0, , 45928553, 2203219, 45928553, CABERETCARAMEL MICRO SUEDE PEEP TOE], [D1, 22.0000, 125.7600, 0, , 15935759, 2203223, 05935759, JAZZ DUSTY PINK HEELED PEEP TOE], [D1, 7.0000, 83.8400, 0, , 45935759, 2203224, 45935759B8, JAZZ DUSTY PINK HEELED PEEP TOE]]') assert_p('Table', 'Content', '[[D1, 7.0000, 0.0002, 2222500000000, , 43314531, 2075359, 45614531, DONKEY 24-006607 SHWL WRAP CARD], [D1, 4.0000, 148.3200, 0, , 5614944, 2075360, 5614944, MILK 24-006607 SHWL WRAP CARD], [D1, 48.0000, 148.3200, 0, , 55615071, 2075361, 55615071, M.ROSE 24-006607 SHWL WRAP CARD], [D1, 4.0000, 148.3200, 0, , 55615156, 2075362, 55615156, AQUA 24-006607 SHWL WRAP CARD], [D1, 16.0000, 6228148.3200, 2222, , 2224531, 2075348, 5614531, DONKEY 24-006607 SHWL WRAP CARD], [D1, 8.0000, 148.3200, 0, , 62224944, 2075349, 65614944, MILK 24-006607 SHWL WRAP CARD], [D1, 108.0000, 148.3200, 0, , 62225071, 2075350, 65615071, M.ROSE 24-006607 SHWL WRAP CARD], [D1, 8.0000, 148.3200, 0, , 52225156, 2075351, 55615156, M.ROSE 24-006607 SHWL WRAP CARD], [D1, 6.0000, 148.3200, 0, , 45614531, 2075352, 45614531, DONKEY 24-006607 SHWL WRAP CARD], [D1, 3.0000, 148.3200, 0, , 45614944, 2075353, 45614944, MILK 24-006607 SHWL WRAP CARD], [D1, 44.0000, 148.3200, 0, , 45615071, 2075354, 45615071, M.ROSE 24-006607 SHWL WRAP CARD], [D1, 3.0000, 148.3200, 0, , 45615156, 2075355, 35615156, AQUA 24-006607 SHWL WRAP CARD], [D1, 30.0000, 292.6800, 0, , 45846680, 2120736, 45615156, CONCERTO BLACK LEATHER ANKLE BOOT], [D1, 29.0000, 198.3600, 0, , 45846772, 2121104, 5846772, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 29.0000, 198.3600, 0, , 45847489, 2121627, 45847489, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 25.0000, 465.4800, 0, , 45848707, 2179843, 45848707A, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 8.0000, 82.1600, 0, , 46164790, 2203070, 46164790B8, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 24.0000, 112.9700, 0, , 46164790, 2203056, 46164790, ANGEL PINK SYNTHETIC MICRO SUEDE SLOUCH BOOT], [D1, 7.0000, 82.1600, 0, , 46165360, 2203075, 46165360B8, CABERETCARAMEL MICRO SUEDE PEEP TOE], [D1, 23.0000, 112.9700, 0, , 46165360, 2203072, 46165360, CABERETCARAMEL MICRO SUEDE PEEP TOE], [D1, 8.0000, 83.8400, 0, , 45928553, 2203222, 45928553B8, CABERETCARAMEL MICRO SUEDE PEEP TOE], [D1, 22.0000, 125.7600, 0, , 45928553, 2203219, 45928553, CABERETCARAMEL MICRO SUEDE PEEP TOE], [D1, 22.0000, 125.7600, 0, , 15935759, 2203223, 05935759, JAZZ DUSTY PINK HEELED PEEP TOE], [D1, 7.0000, 83.8400, 0, , 45935759, 2203224, 45935759B8, JAZZ DUSTY PINK HEELED PEEP TOE]]') select('Table', 'cell:12 - 13|Pack Cost,1(148.3200)') select('Table', 'cell:12 - 13|Pack Cost,4(62281483200)') assert_p('Table', 'RowCount', '24') select('Table', 'cell:12 - 13|Pack Cost,5(148.3200)') assert_p('Table', 'ColumnCount', '9') select('Table', 'cell:12 - 13|Pack Cost,5(148.3200)') select('LayoutCombo', 'Full Line') select('Table', 'cell:Full Line,3(D100004000000000014832000000000000000 55615156000000054540000004 2075362 55615156 AQUA 24-006607 SHWL WRAP CARD )') assert_p('Table', 'Text', 'D100048000000000014832000000000000000 55615071000000054540000048 2075361 55615071 M.ROSE 24-006607 SHWL WRAP CARD ', 'Full Line,2') select('Table', 'cell:Full Line,4(D100016000000622814832000000000002222 02224531000000054540000016 2075348 5614531 DONKEY 24-006607 SHWL WRAP CARD )') assert_p('Table', 'ColumnCount', '1') select('Table', 'cell:Full Line,0(D100007000000000000000022222500000000 43314531000000054540000007 2075359 45614531 DONKEY 24-006607 SHWL WRAP CARD )') assert_p('Table', 'Text', 'cell:Full Line,0(D100007000000000000000022222500000000 43314531000000054540000007 2075359 45614531 DONKEY 24-006607 SHWL WRAP CARD )') select('Table', 'cell:Full Line,1(D100004000000000014832000000000000000 05614944000000054540000004 2075360 5614944 MILK 24-006607 SHWL WRAP CARD )') assert_p('Table', 'Text', 'cell:Full Line,1(D100004000000000014832000000000000000 05614944000000054540000004 2075360 5614944 MILK 24-006607 SHWL WRAP CARD )') select('Table', 'cell:Full Line,3(D100004000000000014832000000000000000 55615156000000054540000004 2075362 55615156 AQUA 24-006607 SHWL WRAP CARD )') assert_p('Table', 'Text', 'cell:Full Line,3(D100004000000000014832000000000000000 55615156000000054540000004 2075362 55615156 AQUA 24-006607 SHWL WRAP CARD )') select('LayoutCombo', 'ams PO Download: Detail') rightclick('Table', '3 - 9|Pack Qty,0') select_menu('Edit Record') select('Table', 'cell:Data,8( DONKEY 24-006607 SHWL WRAP CARD)') assert_p('Table', 'Content', '[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 7.0000, 000070000], [Pack Cost, 12, 13, 0.0002, 0000000000002], [APN, 25, 13, 2222500000000, 2222500000000], [Filler, 38, 1, , ], [Product, 39, 8, 43314531, 43314531], [pmg dtl tech key, 72, 15, 2075359, 2075359], [Case Pack id, 87, 15, 45614531, 45614531], [Product Name, 101, 50, DONKEY 24-006607 SHWL WRAP CARD, DONKEY 24-006607 SHWL WRAP CARD]]') select('Table', 'cell:Data,8( DONKEY 24-006607 SHWL WRAP CARD)') click('Right') select('Table', 'cell:Data,8( MILK 24-006607 SHWL WRAP CARD)') assert_p('Table', 'Text', ' MILK 24-006607 SHWL WRAP CARD', 'Data,8') select('Table', 'cell:Data,8( MILK 24-006607 SHWL WRAP CARD)') click('Right') select('Table', 'cell:Data,8( M.ROSE 24-006607 SHWL WRAP CARD)') assert_p('Table', 'Text', 'cell:Data,8( M.ROSE 24-006607 SHWL WRAP CARD)') select('Table', 'cell:Data,8( M.ROSE 24-006607 SHWL WRAP CARD)') click('Right') select('Table', 'cell:Data,7(55615156)') assert_p('Table', 'Text', 'cell:Data,7(55615156)') select('Table', 'cell:Data,7(55615156)') click('RightM') select('Table', 'cell:Data,8( JAZZ DUSTY PINK HEELED PEEP TOE)') assert_p('Table', 'Content', '[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 7.0000, 000070000], [Pack Cost, 12, 13, 83.8400, 0000000838400], [APN, 25, 13, 0, 0000000000000], [Filler, 38, 1, , ], [Product, 39, 8, 45935759, 45935759], [pmg dtl tech key, 72, 15, 2203224, 2203224], [Case Pack id, 87, 15, 45935759B8, 45935759B8], [Product Name, 101, 50, JAZZ DUSTY PINK HEELED PEEP TOE, JAZZ DUSTY PINK HEELED PEEP TOE]]') select('Table', 'cell:Data,8( JAZZ DUSTY PINK HEELED PEEP TOE)') 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.6.0_03' if window(commonBits.applicationName()): select_menu('Utilities>>Compare Menu') click('*1') click('FileSearch') if window('Open'): select(commonBits.selectPaneFn(), 'Ams_LocDownload_20041228_Extract.bin') click('Open') close() click('FileSearch1') if window('Open'): select(commonBits.selectPaneFn(), 'Ams_LocDownload_20041228_Extract2.bin') click('Open') close() #commonBits.setRecordLayout2(select, 'ams Store') click('Right') select('TabbedPane', '') click('Right') select('TabbedPane', '') click('FileSearch') if window('Save'): ## select(commonBits.selectPane(), 'Compare') ## doubleclick(commonBits.selectPane(), '0') if commonBits.isWindowsLook(): select(commonBits.selectPane(), 'zzTest_asmLocation.Xml') else: select('File Name', 'zzTest_asmLocation.Xml') click('Save') close() click('Save1') assert_p('TextField', 'Text', '') assert_p('TextArea', 'Text', '') click('Compare') select('Table', 'cell:Loc_Name,3(VIC West Ad Support)') assert_p('Table', 'Text', 'VIC West Ad Support', 'Loc_Name,3') select('Table', 'cell:Loc_Name,6(Miranda)') assert_p('Table', 'Text', 'Miranda', 'Loc_Name,6') select('Table', 'cell:Loc_Name,7(Ringwood)') assert_p( 'Table', 'Content', '[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]' ) select('Table', 'cell:Loc_Name,7(Ringwood)') click('BasicInternalFrameTitlePane$NoFocusButton2') click('BasicInternalFrameTitlePane$NoFocusButton2') click('*') select( 'FileNameTxtFld', commonBits.userDir() + 'Compare' + commonBits.fileSep() + 'zzTest_asmLocation.Xml') click('Run Compare') select('Table', 'cell:Loc_Name,11(Highpoint City)') assert_p('Table', 'Text', 'Laverton', 'Loc_Addr_Ln1,11') select('Table', 'cell:Loc_Name,14(Bass Hill)') assert_p('Table', 'Text', 'Bass Hill', 'Loc_Name,14') select('Table', 'cell:Loc_Name,16(Campbelltown)') assert_p( 'Table', 'Content', '[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]' ) 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_PODownload_20041231.txt') click('Open') close() commonBits.setRecordLayout(select, 'utf8_ams PO Download') click('Edit1') select_menu('View>>Record Based Tree') select('Table', 'ams PO Download: Header', 'Parent Record,0') select('Table', 'ams PO Download: Detail', 'Parent Record,2') # select('Table', '1', 'Parent Record,0') # select('Table', '0', 'Parent Record,2') select('Table', 'cell:Parent Record,2(0)') click('Save1') ##select('FileChooser', commonBits.userDir() + 'RecordTree' + commonBits.fileSep() + 'xx') commonBits.selectFileName( select, keystroke, commonBits.userDir() + 'RecordTree' + commonBits.fileSep() + 'xx') click('Save1') select_menu( 'Window>>utf8a_Ams_PODownload_20041231.txt>>Create Record Tree') click('Build') select('JTreeTable', 'cell:PO,0(286225)') assert_p('JTreeTable', 'Text', '286225', 'PO,0') select('JTreeTable', 'cell:PO,0(286225)') assert_p( 'JTreeTable', 'Content', '[[, , H1, 45.349, 6060, 286225, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [, , H1, 45.350, 6228, 222227, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [, , H1, 45.351, 6228, 222243, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [, , H1, 45.352, 5341, 294915, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.353, 5341, 294987, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.354, 5341, 295139, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.355, 5341, 303662, 041110, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT], [, , H1, 45.356, 5341, 304100, 041111, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT]]' ) select('JTreeTable', 'cell:PO,0(286225)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select_menu('Window>>utf8a_Ams_PODownload_20041231.txt>>Table:') select_menu('View>>Execute Record Tree') ##select('FileChooser', commonBits.userDir() + 'RecordTree' + commonBits.fileSep() + 'xx') commonBits.selectFileName( select, keystroke, commonBits.userDir() + 'RecordTree' + commonBits.fileSep() + 'xx') click('Run Dialog') select('Table', 'cell:Record,1(ams PO Download: Header)') assert_p( 'Table', 'Content', '[[ams PO Download: Detail, 1], [ams PO Download: Header, -1], [ams PO Download: Allocation, 0]]' ) select('Table', 'cell:Record,1(ams PO Download: Header)') click('Build') select('JTreeTable', 'cell:PO,0(286225)') assert_p('JTreeTable', 'Text', '222227', 'PO,1') select('JTreeTable', 'cell:PO,3(294915)') assert_p('JTreeTable', 'Text', '294915', 'PO,3') select('JTreeTable', 'cell:PO,3(294915)') select('JTreeTable', 'cell:PO,5(295139)') assert_p( 'JTreeTable', 'Content', '[[, , H1, 45.349, 6060, 286225, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [, , H1, 45.350, 6228, 222227, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [, , H1, 45.351, 6228, 222243, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [, , H1, 45.352, 5341, 294915, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.353, 5341, 294987, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.354, 5341, 295139, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.355, 5341, 303662, 041110, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT], [, , H1, 45.356, 5341, 304100, 041111, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT]]' ) select('JTreeTable', 'cell:PO,5(295139)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select_menu('Window>>utf8a_Ams_PODownload_20041231.txt>>Table:') select_menu('View>>Execute Record Tree') ##select('FileChooser', commonBits.userDir() + 'RecordTree' + commonBits.fileSep() + 'xx') commonBits.selectFileName( select, keystroke, commonBits.userDir() + 'RecordTree' + commonBits.fileSep() + 'xx') click('Run') select('JTreeTable', 'cell:Sequence Number,2(45.351)') assert_p('JTreeTable', 'Text', '45.352', 'Sequence Number,3') select('JTreeTable', 'cell:PO,5(295139)') assert_p( 'JTreeTable', 'Content', '[[, , H1, 45.349, 6060, 286225, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [, , H1, 45.350, 6228, 222227, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [, , H1, 45.351, 6228, 222243, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [, , H1, 45.352, 5341, 294915, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.353, 5341, 294987, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.354, 5341, 295139, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.355, 5341, 303662, 041110, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT], [, , H1, 45.356, 5341, 304100, 041111, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT]]' ) select('JTreeTable', 'cell:PO,5(295139)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') close()
def test(): from Modules import commonBits java_recorded_version = '1.6.0_03' if window('Record Editor'): click(commonBits.fl('Choose File')) if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228.txt') click('Open') close() click(commonBits.fl('Edit') + '1') click('Filter1') select('Table1', 'Loc Type', commonBits.fl('Field') + ',0') select('Table1', 'st', commonBits.fl('Value') + ',0') select('Table1', 'cell:' + commonBits.fl('Field') + ',2(null)') commonBits.save1(click) ##select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx2') commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx2') commonBits.save1(click) select_menu(commonBits.fl('Window') + '>>Ams_LocDownload_20041228.txt>>' + commonBits.fl('Filter Options')) commonBits.filter(click) select('Table', 'cell:10 - 35|Loc Name,0(Bankstown)') assert_p('Table', 'Text', 'Bankstown', '10 - 35|Loc Name,0') select('Table', 'cell:8 - 2|Loc Type,1(ST)') rightclick('Table', '8 - 2|Loc Type,1') select_menu(commonBits.fl('Edit Record')) ## select('Table1', 'cell:8 - 2|Loc Type,1(ST)') select('Table', 'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)') assert_p('Table', 'Text', 'Penrith', commonBits.fl('Data') + ',6') select('Table', 'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)') assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5019, 5019], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Penrith, Penrith], [Loc Addr Ln1, 45, 40, Penrith, Penrith], [Loc Addr Ln2, 85, 40, 58 Leland Street, 58 Leland Street], [Loc Addr Ln3, 125, 35, Penrith, Penrith], [Loc Postcode, 160, 10, 2750, 2750], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]') select('Table', 'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)') commonBits.closeWindow(click) ##click('BasicInternalFrameTitlePane$NoFocusButton2') select('Table', 'cell:8 - 2|Loc Type,1(ST)') select('Table', 'cell:8 - 2|Loc Type,1(ST)') select_menu(commonBits.fl('Window') + '>>Ams_LocDownload_20041228.txt>>' + commonBits.fl('Table:')) select('Table2', 'cell:8 - 2|Loc Type,1(ST)') select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Execute Saved Filter')) ##select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx2') commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx2') click(commonBits.fl('Run Dialog') ) select('Table1', 'cell:' + commonBits.fl('Value') + ',0(st)') rightclick('Table1', commonBits.fl('Value') + ',0') select('Table1', 'cell:' + commonBits.fl('Value') + ',0(st)') rightclick('Table1', commonBits.fl('Value') + ',0') assert_p('Table1', 'Text', 'st', commonBits.fl('Value') + ',0') select('Table1', 'cell:' + commonBits.fl('Value') + ',0(st)') ## assert_p('Table1', 'Content', '[[Loc Type, true, Contains, st], [, true, Contains, ], [, true, Contains, ], [, true, Contains, ]]') ## assert_p('Table1', 'Content', '[[, , Loc Type, true, Contains, st], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ]]'); ## assert_p('Table1', 'Content', '[[, , Loc Type, true, ' + commonBits.fl('Contains') + ', st], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ]]'); assert_p('Table1', 'Content', '[[, , Loc Type, true, ' + commonBits.fl('Contains') + ', st], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ]]'); ## assert_p('Table1', 'Content', '[[, , Loc Type, true, ' + commonBits.fl('Contains') + ', st], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ]]'); select('Table1', 'cell:' + commonBits.fl('Value') + ',0(st)') commonBits.filter(click) select('Table', 'cell:10 - 35|Loc Name,6(Leichhardt)') assert_p('Table', 'Text', 'Leichhardt', '10 - 35|Loc Name,6') select('Table', 'cell:10 - 35|Loc Name,13(Carlingford Court)') rightclick('Table', '10 - 35|Loc Name,13') select_menu(commonBits.fl('Edit Record')) ## select('Table1', 'cell:10 - 35|Loc Name,13(Carlingford Court)') select('Table', 'cell:' + commonBits.fl('Data') + ',5(Dock 1, 11 Melissa Place)') assert_p('Table', 'Text', 'Dock 1, 11 Melissa Place', commonBits.fl('Data') + ',5') select('Table', 'cell:' + commonBits.fl('Data') + ',5(Dock 1, 11 Melissa Place)') assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5090, 5090], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Carlingford Court, Carlingford Court], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, Dock 1, 11 Melissa Place, Dock 1, 11 Melissa Place], [Loc Addr Ln3, 125, 35, Marayong, Marayong], [Loc Postcode, 160, 10, 2148, 2148], [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(commonBits.applicationName()): click('FileSearch') if window('Open'): select(commonBits.selectPane(), 'Ams_LocDownload_20041228.bin') click('Open') close() click('Edit1') click('Filter1') select('Table1', 'Loc_Type', 'Field,0') select('Table1', 'st', 'Value,0') select('Table1', 'cell:Field,2(null)') click('Save1') ##select('FileNameTxtFld', commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1') commonBits.selectFileName( select, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1') click('Save1') select_menu('Window>>Ams_LocDownload_20041228.bin>>Filter Options') click('Filter1') select('LinesTbl', 'cell:4|Loc_Name,0(Bankstown)') assert_p('LinesTbl', 'Text', 'Bankstown', '4|Loc_Name,0') select('LinesTbl', 'cell:3|Loc_Type,1(ST)') rightclick('LinesTbl', '3|Loc_Type,1') select_menu('Edit Record') ## select('Table1', 'cell:3|Loc_Type,1(ST)') select('BaseLineAsColumn$LineAsColTbl', 'cell:Data,5(58 Leland Street)') assert_p('BaseLineAsColumn$LineAsColTbl', 'Text', 'Penrith', 'Data,6') select('BaseLineAsColumn$LineAsColTbl', 'cell:Data,5(58 Leland Street)') assert_p( 'BaseLineAsColumn$LineAsColTbl', 'Content', '[[Brand_Id, 1, , TAR, TAR], [Loc_Nbr, 2, , 5019, 5019], [Loc_Type, 3, , ST, ST], [Loc_Name, 4, , Penrith, Penrith], [Loc_Addr_Ln1, 5, , Penrith, Penrith], [Loc_Addr_Ln2, 6, , 58 Leland Street, 58 Leland Street], [Loc_Addr_Ln3, 7, , Penrith, Penrith], [Loc_Postcode, 8, , 2750, 2750], [Loc_State, 9, , NSW, NSW], [Loc_Actv_Ind, 10, , A, A]]' ) select('BaseLineAsColumn$LineAsColTbl', 'cell:Data,5(58 Leland Street)') click('BasicInternalFrameTitlePane$NoFocusButton2') select('LinesTbl', 'cell:3|Loc_Type,1(ST)') select('LinesTbl', 'cell:3|Loc_Type,1(ST)') select_menu('Window>>Ams_LocDownload_20041228.bin>>Table:') select('LinesTbl', 'cell:3|Loc_Type,1(ST)') select_menu('View>>Execute Saved Filter') #select('FileNameTxtFld', commonBits.userDir() + 'Filter' + commonBits.fileSep() +'xx1') commonBits.selectFileName( select, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1') click('Run') select('LinesTbl', 'cell:4|Loc_Name,2(Blacktown)') assert_p('LinesTbl', 'Text', 'Blacktown', '4|Loc_Name,2') select('LinesTbl', 'cell:4|Loc_Name,5(Eastwood)') rightclick('LinesTbl', '4|Loc_Name,5') select_menu('Edit Record') ## select('Table1', 'cell:4|Loc_Name,5(Eastwood)') select('BaseLineAsColumn$LineAsColTbl', 'cell:Data,4(Marayong Offsite Reserve)') assert_p('BaseLineAsColumn$LineAsColTbl', 'Text', 'Marayong Offsite Reserve', 'Data,4') select('BaseLineAsColumn$LineAsColTbl', 'cell:Data,4(Marayong Offsite Reserve)') assert_p( 'BaseLineAsColumn$LineAsColTbl', 'Content', '[[Brand_Id, 1, , TAR, TAR], [Loc_Nbr, 2, , 5052, 5052], [Loc_Type, 3, , ST, ST], [Loc_Name, 4, , Eastwood, Eastwood], [Loc_Addr_Ln1, 5, , Marayong Offsite Reserve, Marayong Offsite Reserve], [Loc_Addr_Ln2, 6, , 11 Melissa Place, 11 Melissa Place], [Loc_Addr_Ln3, 7, , Marayong, Marayong], [Loc_Postcode, 8, , 2148, 2148], [Loc_State, 9, , NSW, NSW], [Loc_Actv_Ind, 10, , A, A]]' ) close()
def test(): from Modules import commonBits java_recorded_version = "1.6.0_03" if window("Protocol Buffer Editor"): select_menu("Utilities>>Compare Menu") click("*1") click("Choose File") if window("Open"): select(commonBits.selectPaneFn(), "Ams_LocDownload_20041228_Extract.bin") click("Open") close() click("Choose File1") if window("Open"): select(commonBits.selectPaneFn(), "Ams_LocDownload_20041228_Extract2.bin") click("Open") close() # commonBits.setRecordLayout2(select, 'ams Store') click("Right") select("TabbedPane", "") click("Right") select("TabbedPane", "") click("Choose File") if window("Save"): ## select(commonBits.selectPane(), 'Compare') ## doubleclick(commonBits.selectPane(), '0') if commonBits.isWindowsLook(): select(commonBits.selectPane(), "zzTest_asmLocation.Xml") else: select("File Name", "zzTest_asmLocation.Xml") click("Save") close() click("Save1") assert_p("TextField", "Text", "") assert_p("TextArea", "Text", "") click("Compare") select("Table", "cell:Loc_Name,3(VIC West Ad Support)") assert_p("Table", "Text", "VIC West Ad Support", "Loc_Name,3") select("Table", "cell:Loc_Name,6(Miranda)") assert_p("Table", "Text", "Miranda", "Loc_Name,6") select("Table", "cell:Loc_Name,7(Ringwood)") assert_p( "Table", "Content", "[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary's, Charles Hackett Drive, St Mary's, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]", ) select("Table", "cell:Loc_Name,7(Ringwood)") click("BasicInternalFrameTitlePane$NoFocusButton2") click("BasicInternalFrameTitlePane$NoFocusButton2") click("*") select("FileChooser", commonBits.userDir() + "Compare" + commonBits.fileSep() + "zzTest_asmLocation.Xml") click("Run Compare") select("Table", "cell:Loc_Name,11(Highpoint City)") assert_p("Table", "Text", "Laverton", "Loc_Addr_Ln1,11") select("Table", "cell:Loc_Name,14(Bass Hill)") assert_p("Table", "Text", "Bass Hill", "Loc_Name,14") select("Table", "cell:Loc_Name,16(Campbelltown)") assert_p( "Table", "Content", "[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary's, Charles Hackett Drive, St Mary's, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]", ) close()