ParamReader

class vertica_sdk.ParamReader

Provides read access to a set of named parameters. Type-specific methods can be used to retrieve values.

containsParameter(self, fieldName)

Returns True if there is a value for fieldName and False otherwise.

getBool(self, fieldName)

Returns a boolean value corresponding to the key fieldName.

Raises an error if there is no parameter fieldName.

getDate(self, fieldName)

Returns a datetime.date corresponding to the key fieldName.

Raises an error if there is no parameter fieldName.

getFloat(self, fieldName)

Returns a float corresponding to the key fieldName.

Raises an error if there is no parameter fieldName.

getInt(self, fieldName)

Returns an int corresponding to the key fieldName.

Raises an error if there is no parameter fieldName.

getInterval(self, fieldName)

Returns a datetime.timedelta corresponding to the key fieldName.

Raises an error if there is no parameter fieldName.

getIntervalYM(self, fieldName)

Returns a int corresponding to the key fieldName whose value represents an interval in months.

Raises an error if there is no parameter fieldName.

getNumeric(self, fieldName)

Returns a decimal.Decimal corresponding to the key fieldName.

Raises an error if there is no parameter fieldName.

getParamNames(self)

Returns a list containing the names of all of the parameters.

getString(self, fieldName)

Returns a str corresponding to the key fieldName.

Raises an error if there is no parameter fieldName.

getTime(self, fieldName)

Returns a datetime.time corresponding to they key fieldName. The timezone is fixed to UTC.

Raises an error if there is no parameter fieldName.

getTimeTz(self, fieldName)

Returns a datetime.time corresponding to they key fieldName. The timezone is a constant offset from UTC.

Raises an error if there is no parameter fieldName.

getTimestamp(self, fieldName)

Returns a datetime.datetime corresponding to they key fieldName.

Raises an error if there is no parameter fieldName.

getTimestampTz(self, fieldName)

Returns a datetime.datetime corresponding to they key fieldName.

Raises an error if there is no parameter fieldName.

isEmpty(self)

Returns True if there are no parameters and False otherwise.