test: all test cases for db passing. Need to add more #SOCRFW-80