Class: MobyUtil::OperatorData

Inherits:
Object
  • Object
show all
Defined in:
lib/tdriver/util/operator_data/operator_data.rb

Class Method Summary collapse

Class Method Details

.retrieve(operator_data_lname, operator, table_name) ⇒ Object

description

Function to fetch a translation for a given logical name from the localisation DB

arguments

operator_data_lname

String
 description: operator data identifier
 example: "op_welcome_message""

operator

String
 description: Operator column name to be used when fetching operator data

example: “Orange”

table_name

String
 description: Name of the operator data table to use from the operator table DB
 example: "operator_data_week201042"

returns

String

description: Operator data string

throws

OperatorDataColumnNotFoundError

description: If the desired operator data is not found

OperatorDataColumnNotFoundError

description: If the desired data column name to be used for the output is not found

SqlError

description: if there is and sql error while executing the query

Raises:



59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
 
# File 'lib/tdriver/util/operator_data/operator_data.rb', line 59

def self.retrieve( operator_data_lname, operator, table_name )
	
    raise OperatorDataNotFoundError.new( "Search string parameter cannot be nil" ) if operator_data_lname == nil

	# Get Localization parameters for DB Connection
	db_type =  $parameters[ :operator_data_db_type, nil ].to_s.downcase
	host =  $parameters[ :operator_data_server_ip ]
	username = $parameters[ :operator_data_server_username ]
	password = $parameters[ :operator_data_server_password ]
	database_name = $parameters[ :operator_data_server_database_name ]
	
	db_connection = DBConnection.new(  db_type, host, database_name, username, password )
	
	search_string = "#{ operator_data_lname }' AND `Operator` = '#{ operator }"			
	query_string =  "select `Value` from `#{ table_name }` where `LogicalName` = '#{ search_string }' and `LogicalName` <> '#MISSING'"

	begin
		result = MobyUtil::DBAccess.query( db_connection, query_string )
	rescue
	    # if data column to be searched is not found then raise error for search column not found
	    raise OperatorDataColumnNotFoundError.new( "Search column 'Value' not found in database" ) unless $!.message.index( "Unknown column" ) == nil
	    raise SqlError.new( $!.message )
    end

	# Return always the first column of the row
	raise OperatorDataNotFoundError.new("No matches found for search string '#{ operator_data_lname }' in search column 'LogicalName' for opreator #{ operator }" ) if ( result.empty?)
	# Result is an Array of rows (Array<String>)! We want the first column of the first row.
	return result[0][0]
	
end