Package io.openems.backend.metadata.odoo.postgres

Class PgUtils

java.lang.Object

io.openems.backend.metadata.odoo.postgres.PgUtils

public class PgUtils
extends Object

Constructor Summary

Constructors

Constructor	Description
PgUtils()

Method Summary

Modifier and Type	Method	Description
static ZonedDateTime	getAsDate(ResultSet rs, Field field)	Return the Field of the ResultSet.
static ZonedDateTime	getAsDateOrElse(ResultSet rs, Field field, ZonedDateTime other)	Return the Field of the ResultSet; or default value on error.
static int	getAsInt(ResultSet rs, Field field)	Return the Field of the ResultSet.
static Integer	getAsIntegerOrElse(ResultSet rs, Field field, Integer other)	Return the Field of the ResultSet; or default value on error.
static String	getAsString(ResultSet rs, Field field)	Return the Field of the ResultSet.
static String	getAsStringOrElse(ResultSet rs, Field field, String other)	Return the Field of the ResultSet; or default value on error.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

PgUtils

public PgUtils()

Method Details

getAsString

public static String getAsString(ResultSet rs,
 Field field)
                          throws SQLException,
OpenemsException

Return the Field of the ResultSet.

Parameters:

rs - the ResultSet

field - the EdgeDevice

Returns:

the value as String

Throws:

SQLException - on error

OpenemsException - on null

getAsStringOrElse

public static String getAsStringOrElse(ResultSet rs,
 Field field,
 String other)

Return the Field of the ResultSet; or default value on error.

Parameters:

rs - the ResultSet

field - the EdgeDevice field

other - the default value

Returns:

the value as String

getAsInt

public static int getAsInt(ResultSet rs,
 Field field)
                    throws SQLException

Return the Field of the ResultSet.

Parameters:

rs - the ResultSet

field - the EdgeDevice

Returns:

the value as Integer

Throws:

SQLException - on error

getAsIntegerOrElse

public static Integer getAsIntegerOrElse(ResultSet rs,
 Field field,
 Integer other)

Return the Field of the ResultSet; or default value on error.

Parameters:

rs - the ResultSet

field - the EdgeDevice field

other - the default value

Returns:

the value as Integer

getAsDate

public static ZonedDateTime getAsDate(ResultSet rs,
 Field field)
                               throws SQLException,
OpenemsException

Return the Field of the ResultSet.

Parameters:

rs - the ResultSet

field - the EdgeDevice field

Returns:

the value as ZonedDateTime

Throws:

SQLException - SQL-Error

OpenemsException - OpenEMS-Error

getAsDateOrElse

public static ZonedDateTime getAsDateOrElse(ResultSet rs,
 Field field,
 ZonedDateTime other)

Return the Field of the ResultSet; or default value on error.

Parameters:

rs - the ResultSet

field - the EdgeDevice field

other - the default value

Returns:

the value as ZonedDateTime