d1d6976de2
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3635 248e525c-4dfb-0310-94bc-949c084e9493
112 lines
2.8 KiB
Ruby
112 lines
2.8 KiB
Ruby
#---
|
||
#This unit test checks the export data function of webmip
|
||
#should check that all the tables are available for export
|
||
#may have some issues with the file downloads as I'm not sure how
|
||
#we handle these with ie and watir
|
||
#---
|
||
class Test_07_export_data < Test::Unit::TestCase
|
||
#
|
||
#Test we can logon to the system using the webmip administrator user’s login credentials
|
||
#
|
||
def test_01_data_export_screen_appears
|
||
@@ie.goto(EXPORT_DATA)
|
||
login(DEFAULT, DEFAULT_PWD)
|
||
assert(@@ie.contains_text('Data Export'),'The data export screen did not appear')
|
||
assert(@@ie.select_list(:id, 'P5_TABLES').exists?,'The tables field was not available')
|
||
assert(@@ie.select_list(:id, 'P5_COLUMN_NAMES').exists?,'The column headings field was not available')
|
||
assert(@@ie.button(:id, 'Export Data').exists?,'The export data button was not available')
|
||
end
|
||
#
|
||
#Check that all the appropriate tables are listed for export
|
||
#
|
||
def test_02_correct_list_of_tables_displayed
|
||
listoftablestoexport= ["ADDITIONAL_ITEMS",
|
||
"ADDRESSES",
|
||
"APEX_AUTHORIZATION",
|
||
"ASSET_LOCATION_TYPES",
|
||
"BASES",
|
||
"BYPASS_REASONS",
|
||
"CARE_CATEGORIES",
|
||
"CAVEAT_TEXTS",
|
||
"CONNECTION_ORIENTATIONS",
|
||
"CONNECTION_TYPES",
|
||
"CONSTRAINT_MESSAGES",
|
||
"CONTACT_MECHANISMS",
|
||
"CONTACT_MECHANISM_TYPES",
|
||
"COSTS",
|
||
"DATA_ITEM_ROLES",
|
||
"DOCUMENTS",
|
||
"DOCUMENT_EVENTS",
|
||
"DOCUMENT_ROLES",
|
||
"DOCUMENT_STATUS_TYPES",
|
||
"DRAWINGS",
|
||
"ENQUIRIES",
|
||
"ENQUIRY_EVENTS",
|
||
"ENQUIRY_ROLES",
|
||
"ENQUIRY_STATUS_TYPES",
|
||
"ENQUIRY_TYPES",
|
||
"ERR$_BASES",
|
||
"ERR$_CAVEAT_TEXTS",
|
||
"ERR$_COSTS",
|
||
"ERR$_HOUSINGS",
|
||
"ERR$_LEAD_TIMES",
|
||
"ERR$_METERS",
|
||
"ERR$_MODULES",
|
||
"ERR$_PARTIES",
|
||
"ERR$_POSTCODES",
|
||
"ERROR_LOGS",
|
||
"EXCEPTION_MESSAGES",
|
||
"EXT_BASES",
|
||
"EXT_CAVEATS",
|
||
"EXT_DATAITEM_ROLES",
|
||
"EXT_HOUSINGS",
|
||
"EXT_LABOUR_COSTS",
|
||
"EXT_LEADTIMES",
|
||
"EXT_MATERIAL_COSTS",
|
||
"EXT_METERS",
|
||
"EXT_MODULES",
|
||
"EXT_POSTCODES",
|
||
"FILTERS",
|
||
"FILTER_TYPES",
|
||
"GTT_DIR_LIST",
|
||
"HOUSINGS",
|
||
"HOUSING_TYPES",
|
||
"LEAD_TIMES",
|
||
"METERS",
|
||
"METER_SIZE_CODES",
|
||
"METER_TYPES",
|
||
"MODULES",
|
||
"PARTIES",
|
||
"PARTY_ADDRESSES",
|
||
"PARTY_ADDRESS_ROLES",
|
||
"PARTY_CONTACT_MECHANISMS",
|
||
"PARTY_CONTACT_MECHANISM_ROLES",
|
||
"PARTY_RELATIONSHIPS",
|
||
"PARTY_RELATIONSHIP_TYPES",
|
||
"PARTY_ROLES",
|
||
"PASSWORDS",
|
||
"POSTCODES",
|
||
"QUOTES",
|
||
"QUOTE_EVENTS",
|
||
"QUOTE_ITEMS",
|
||
"QUOTE_REASONING",
|
||
"QUOTE_ROLES",
|
||
"QUOTE_STATUSES",
|
||
"REGIONS",
|
||
"REGI_ENQU_EXCLUSIONS",
|
||
"REGULATORS",
|
||
"REGULATOR_TYPES",
|
||
"RELIEF_VALVES",
|
||
"RELIEF_VALVE_TYPES",
|
||
"ROLE_TYPES",
|
||
"SERVICE_PRESSURES",
|
||
"SERVICE_PRESSURE_TYPES",
|
||
"SLAMSHUT_TYPES",
|
||
"SLAMSHUT_VALVES",
|
||
"SYSTEM_CONFIGURATION",
|
||
"VALIDATION_RESULTS"]
|
||
assert_equal(listoftablestoexport,@@ie.select_list(:id, 'P5_TABLES').getAllContents ,'The expected table list for export was not found')
|
||
end
|
||
|
||
|
||
end |