def test_validate_cpuq_file_nok():
v = GeneralValidator(
input_object="../files_test/cpuq_altered.txt",
required_input_type="txt",
text_contains_all=["[BEGIN SCRIPT INFO]", "Virtual CPUs"])
assert_that(v.validate()).is_false()
def test_validate_review_lite_version_file_ok():
# server-name_database-name_filename.csv
v = GeneralValidator(
input_object=
"../files_test/review_lite_original/anjin_SD2213_version.csv",
required_input_type="csv",
text_contains_any=[
'DBA_FEATURE_USAGE_STATISTICS', 'ORACLE PARTITIONING INSTALLED',
'DATABASE VERSION'
])
assert_that(v.validate()).is_true()
def test_validate_rvtools_file_nok():
v = GeneralValidator(
input_object="../files_test/RVTools_altered.xlsx",
required_input_type="excel",
min_rows_number=1,
required_sheets=['tabvInfo', 'tabvCPU', 'tabvHost', 'tabvCluster'],
required_columns=[
'VM', 'Host', 'OS', 'Sockets', 'CPUs', 'Model', 'CPU Model',
'Cluster', '# CPU', '# Cores', 'ESX Version', 'HT Active', 'Name',
'NumCpuThreads', 'NumCpuCores'
])
assert_that(v.validate()).is_false()
def test_validate_lms_options_file_ok():
v = GeneralValidator(input_object="../files_test/lms_options_small.csv",
required_input_type="csv",
min_rows_number=1,
required_columns=[
'MACHINE_ID', 'DB_NAME', 'TIMESTAMP', 'HOST_NAME',
'INSTANCE_NAME', 'OPTION_NAME', 'OPTION_QUERY',
'SQL_ERROR_CODE', 'SQL_ERROR_MESSAGE', 'COL010',
'COL020', 'COL030', 'COL040', 'COL050', 'COL060',
'COL070', 'COL080', 'COL090', 'COL100', 'COL110',
'COL120', 'COL130', 'COL140', 'COL150', 'COL160'
])
assert_that(v.validate()).is_true()
def test_validate_lms_detail_file_nok():
v = GeneralValidator(input_object="../files_test/lms_detail_altered.csv",
required_input_type="csv",
min_rows_number=1,
required_columns=[
'RL_SCRIPT_VERSION', 'TIMESTAMP', 'MACHINE_ID',
'VMACHINE_ID', 'BANNER', 'DB_NAME', 'USER_COUNT',
'SERVER_MANUFACTURER', 'SERVER_MODEL',
'OPERATING_SYSTEM', 'SOCKETS_POPULATED_PHYS',
'TOTAL_PHYSICAL_CORES', 'PROCESSOR_IDENTIFIER',
'PROCESSOR_SPEED', 'TOTAL_LOGICAL_CORES',
'PARTITIONING_METHOD', 'DB_ROLE', 'INSTALL_DATE'
])
assert_that(v.validate()).is_false()