def verify_file_data(self):
# USING THE TOOLS FROM FACTORY/ USING THE FACTORY IN TOOL MODE
# Assuming that below code is generating CTRL files
print "Simulating Expected Result generation....\n\n\n"
call("Utils/TableComparator.py --r E --mode=S --tc=71 --tbl=etl_process_status \
--pk=BATCH_SK,PROCESS_SK,ENV_CD --npk=PROCESS_NAME \
--wh=\"PROCESS_NAME,=,'wf_SFF_BRANCHED_QUESTIONS' \" " , \
shell=True)
'''
print "Using Tool Mode to generate Actual Results....\n\n\n"
# Get the Abstract Factory Interface
test_factory = ELTTestBaseFactory()
# Framing all necessary argument list to pass to the DB Comparision Tool, they are...
# Test Case no
# Table Name
# Primary Keys
# Non Primary Keys
# Where clause
#args = ["71", "etl_process_status", ["BATCH_SK,PROCESS_SK"], ["MIN_BATCH_ID,PROCESS_NAME"], ["PROCESS_NAME,=,'wf_SFF_BRANCHED_QUESTIONS' " ] ]
r_args = { "test_case_no" : "71",
"table" : "etl_process_status",
"pkey" : "BATCH_SK,PROCESS_SK",
"non_pkey" : "MIN_BATCH_ID,PROCESS_NAME",
"where" : "PROCESS_NAME,=,'wf_SFF_BRANCHED_QUESTIONS'",
"mode" : "S",
"run" : "A",
}
# Initialize the DB Comparision Tool
test_factory.init_test_tool("DBCompTool", r_args)
# That’s it call run_test() of factory, it will do the job.
# Take care of assertion errors.
# In case of discrepancy/issues it will throw Assertion Error
test_factory.run_check()
# USING THE FACTORY TO RUN A TEST CASE
# Assuming that below code is generating CTRL files
ctrl_file = "actual_results/ps_sfat_lead_rule_EDWDEV.out.ctl"
with open(ctrl_file) as to_read:
lines = [line for line in to_read if line.strip()]
with open(ctrl_file, "w") as to_write:
for line in lines:
line = line.strip()
line += str(" text_inject") + "\n"
to_write.write(line)
'''
# Get the Concrete factory(Load, Extract, Transform)
#load_ut_factory = LoadTestBaseFactory
load_ut_factory = ELTTestBaseFactory.get_test_factory("Load")
# Initialize the test suite Unit/Regression
load_ut_factory.init_test_suite('UNIT-TEST', 2)
# Get the test case
load_ut_factory.get_test_case()
# Run the test
load_ut_factory.run_test()
#! /usr/bin/python
from ELTTestBaseFactory import ELTTestBaseFactory
import unittest
from TestLoad.UnitTest.VerifyDSFiles import VerifyDSFiles
if __name__ == '__main__':
test_case = ELTTestBaseFactory().get_test_factory('LOAD').get_test_case()
runner = unittest.TextTestRunner()
runner.run(test_case)
#! /usr/bin/python
import sys,os.path
sys.path.append(os.path.join(os.path.dirname(__file__), '..'))
from ELTTestBaseFactory import ELTTestBaseFactory
#from TestLoad.LoadTestBaseFactory import LoadTestBaseFactory
#from TestLoad.UnitTest.LoadUnitTestBase import LoadUnitTestBase
#from ELTTestScripts.ELTTestBaseFactory import ELTTestBaseFactory
import unittest
from TestLoad.UnitTest.VerifyDSFiles import VerifyDSFiles
#from test_ns import *
if __name__ == '__main__':
#test_case = ELTTestBaseFactory.get_test_factory('LOAD').get_unittest()
base_factory = ELTTestBaseFactory()
factory = base_factory.get_test_factory('LOAD')
print factory
#test_case = factory.get_unittest(1)
test_case = factory.get_test_case()
print test_case
runner = unittest.TextTestRunner()
runner.run(test_case)
def verify_file_data(self):
# USING THE TOOLS FROM FACTORY/ USING THE FACTORY IN TOOL MODE
# Assuming that below code is generating CTRL files
print "Simulating Expected Result generation....\n\n\n"
call("Utils/TableComparator.py --r E --mode=S --tc=71 --tbl=etl_process_status \
--pk=BATCH_SK,PROCESS_SK,ENV_CD --npk=PROCESS_NAME \
--wh=\"PROCESS_NAME,=,'wf_SFF_BRANCHED_QUESTIONS' \" ", \
shell=True)
'''
print "Using Tool Mode to generate Actual Results....\n\n\n"
# Get the Abstract Factory Interface
test_factory = ELTTestBaseFactory()
# Framing all necessary argument list to pass to the DB Comparision Tool, they are...
# Test Case no
# Table Name
# Primary Keys
# Non Primary Keys
# Where clause
#args = ["71", "etl_process_status", ["BATCH_SK,PROCESS_SK"], ["MIN_BATCH_ID,PROCESS_NAME"], ["PROCESS_NAME,=,'wf_SFF_BRANCHED_QUESTIONS' " ] ]
r_args = { "test_case_no" : "71",
"table" : "etl_process_status",
"pkey" : "BATCH_SK,PROCESS_SK",
"non_pkey" : "MIN_BATCH_ID,PROCESS_NAME",
"where" : "PROCESS_NAME,=,'wf_SFF_BRANCHED_QUESTIONS'",
"mode" : "S",
"run" : "A",
}
# Initialize the DB Comparision Tool
test_factory.init_test_tool("DBCompTool", r_args)
# That’s it call run_test() of factory, it will do the job.
# Take care of assertion errors.
# In case of discrepancy/issues it will throw Assertion Error
test_factory.run_check()
# USING THE FACTORY TO RUN A TEST CASE
# Assuming that below code is generating CTRL files
ctrl_file = "actual_results/ps_sfat_lead_rule_EDWDEV.out.ctl"
with open(ctrl_file) as to_read:
lines = [line for line in to_read if line.strip()]
with open(ctrl_file, "w") as to_write:
for line in lines:
line = line.strip()
line += str(" text_inject") + "\n"
to_write.write(line)
'''
# Get the Concrete factory(Load, Extract, Transform)
#load_ut_factory = LoadTestBaseFactory
load_ut_factory = ELTTestBaseFactory.get_test_factory("Load")
# Initialize the test suite Unit/Regression
load_ut_factory.init_test_suite('UNIT-TEST', 2)
# Get the test case
load_ut_factory.get_test_case()
# Run the test
load_ut_factory.run_test()
#! /usr/bin/python
#import sys,os.path
#sys.path.append(os.path.join(os.path.dirname(__file__), '..'))
from ELTTestBaseFactory import ELTTestBaseFactory
et = ELTTestBaseFactory.get_test_factory('LOAD')
