Class alltypes

java.lang.Object
fc.jdbc.dbo.DBO
fc.jdbc.dbo.generated.alltypes
public class alltypes extends DBO
Represents a row in the alltypes table.

  • Constructor Details

  • Method Details

    • isModified_id

      public boolean isModified_id()
      returns true if id has changed since it was created/loaded, false otherwise

    • isNullInDB_id

      public boolean isNullInDB_id()
      returns true if id was null in the database

    • isModified_smallint_val

      public boolean isModified_smallint_val()
      returns true if smallint_val has changed since it was created/loaded, false otherwise

    • isModifiedSetNull_smallint_val

      public boolean isModifiedSetNull_smallint_val()
      returns <true> is primitive type smallint_val has been set to null via the setNull mechanism

    • isNullInDB_smallint_val

      public boolean isNullInDB_smallint_val()
      returns true if smallint_val was null in the database

    • isModified_int_val

      public boolean isModified_int_val()
      returns true if int_val has changed since it was created/loaded, false otherwise

    • isNullInDB_int_val

      public boolean isNullInDB_int_val()
      returns true if int_val was null in the database

    • isModified_bigint_val

      public boolean isModified_bigint_val()
      returns true if bigint_val has changed since it was created/loaded, false otherwise

    • isModifiedSetNull_bigint_val

      public boolean isModifiedSetNull_bigint_val()
      returns <true> is primitive type bigint_val has been set to null via the setNull mechanism

    • isNullInDB_bigint_val

      public boolean isNullInDB_bigint_val()
      returns true if bigint_val was null in the database

    • isModified_float_val

      public boolean isModified_float_val()
      returns true if float_val has changed since it was created/loaded, false otherwise

    • isModifiedSetNull_float_val

      public boolean isModifiedSetNull_float_val()
      returns <true> is primitive type float_val has been set to null via the setNull mechanism

    • isNullInDB_float_val

      public boolean isNullInDB_float_val()
      returns true if float_val was null in the database

    • isModified_double_val

      public boolean isModified_double_val()
      returns true if double_val has changed since it was created/loaded, false otherwise

    • isModifiedSetNull_double_val

      public boolean isModifiedSetNull_double_val()
      returns <true> is primitive type double_val has been set to null via the setNull mechanism

    • isNullInDB_double_val

      public boolean isNullInDB_double_val()
      returns true if double_val was null in the database

    • isModified_numeric_val

      public boolean isModified_numeric_val()
      returns true if numeric_val has changed since it was created/loaded, false otherwise

    • isNullInDB_numeric_val

      public boolean isNullInDB_numeric_val()
      returns true if numeric_val was null in the database

    • isModified_char_val

      public boolean isModified_char_val()
      returns true if char_val has changed since it was created/loaded, false otherwise

    • isNullInDB_char_val

      public boolean isNullInDB_char_val()
      returns true if char_val was null in the database

    • isModified_varchar_val

      public boolean isModified_varchar_val()
      returns true if varchar_val has changed since it was created/loaded, false otherwise

    • isNullInDB_varchar_val

      public boolean isNullInDB_varchar_val()
      returns true if varchar_val was null in the database

    • isModified_longvarchar_val

      public boolean isModified_longvarchar_val()
      returns true if longvarchar_val has changed since it was created/loaded, false otherwise

    • isNullInDB_longvarchar_val

      public boolean isNullInDB_longvarchar_val()
      returns true if longvarchar_val was null in the database

    • isModified_date_val

      public boolean isModified_date_val()
      returns true if date_val has changed since it was created/loaded, false otherwise

    • isNullInDB_date_val

      public boolean isNullInDB_date_val()
      returns true if date_val was null in the database

    • isModified_time_val

      public boolean isModified_time_val()
      returns true if time_val has changed since it was created/loaded, false otherwise

    • isNullInDB_time_val

      public boolean isNullInDB_time_val()
      returns true if time_val was null in the database

    • isModified_timestamp_val

      public boolean isModified_timestamp_val()
      returns true if timestamp_val has changed since it was created/loaded, false otherwise

    • isNullInDB_timestamp_val

      public boolean isNullInDB_timestamp_val()
      returns true if timestamp_val was null in the database

    • isModified_bit_val

      public boolean isModified_bit_val()
      returns true if bit_val has changed since it was created/loaded, false otherwise

    • isNullInDB_bit_val

      public boolean isNullInDB_bit_val()
      returns true if bit_val was null in the database

    • isModified_array_val

      public boolean isModified_array_val()
      returns true if array_val has changed since it was created/loaded, false otherwise

    • isNullInDB_array_val

      public boolean isNullInDB_array_val()
      returns true if array_val was null in the database

    • isModified_boolean_val

      public boolean isModified_boolean_val()
      returns true if boolean_val has changed since it was created/loaded, false otherwise

    • isNullInDB_boolean_val

      public boolean isNullInDB_boolean_val()
      returns true if boolean_val was null in the database

    • isModified_varbinary_val

      public boolean isModified_varbinary_val()
      returns true if varbinary_val has changed since it was created/loaded, false otherwise

    • isNullInDB_varbinary_val

      public boolean isNullInDB_varbinary_val()
      returns true if varbinary_val was null in the database

    • isModified_json_val

      public boolean isModified_json_val()
      returns true if json_val has changed since it was created/loaded, false otherwise

    • isNullInDB_json_val

      public boolean isNullInDB_json_val()
      returns true if json_val was null in the database

    • isModified_jsonb_val

      public boolean isModified_jsonb_val()
      returns true if jsonb_val has changed since it was created/loaded, false otherwise

    • isNullInDB_jsonb_val

      public boolean isNullInDB_jsonb_val()
      returns true if jsonb_val was null in the database

    • isNew

      public boolean isNew()
      returns true if this object is newly created and has not been loaded from the database, false otherwise

    • isModified

      public boolean isModified()
      returns true if this object's data (for any field) has changed since it was created/loaded, false otherwise

    • putExtraData

      public void putExtraData(Object key, Object value)
      Allows putting arbitrary object-specific data into this object. This is useful to store additional query-specific columns when performing arbitrary queries. For example: 
      String query = "select 1+1 as my_sum, 
    now() as my_time, alltypesMgr.columns() 
    from alltypes";
PreparedStatement ps = con.prepareStatment(query);
ResultSet rs = ps.executeQuery();
List list = new ArrayList();
while (rs.next()) {
  alltypes obj = alltypesMgr.getFromRS(rs);
  obj.putExtraData("my_sum", rs.getInt("my_sum"));
  obj.putExtraData("my_time", rs.getDate("my_time"));
  }
//use the list later on...each alltypes object in the list will 
//have the extra data..

    • put

      public void put(Object key, Object value)

    • getExtraData

      public Object getExtraData(Object key)
      Allows retrieving arbitrary object-specific data from this object. This data should have been put via the putExtraData method prior to invoking this method

    • get

      public Object get(Object key)

    • toString

      public String toString()
      Overrides:
      toString in class Object

    • allFieldsMap

      public Map allFieldsMap()
      Returns a map of all fields->values (as Strings) contained in this object. This is useful when sending auto converting the object to JSON, etc.

    • get_id

      public int get_id()
      serial (INTEGER); PK=yes; Nullable=false; AutoInc=true; MaxSize=10

    • get_smallint_val

      public short get_smallint_val()
      int2 (SMALLINT); Nullable=true; AutoInc=false; MaxSize=5

    • set_smallint_val

      public alltypes set_smallint_val(short smallint_val)
      int2 (SMALLINT); Nullable=true; AutoInc=false; MaxSize=5

    • setNull_smallint_val

      public alltypes setNull_smallint_val()

    • get_int_val

      public int get_int_val()
      int4 (INTEGER); Nullable=false; AutoInc=false; MaxSize=10

    • set_int_val

      public alltypes set_int_val(int int_val)
      int4 (INTEGER); Nullable=false; AutoInc=false; MaxSize=10

    • get_bigint_val

      public long get_bigint_val()
      int8 (BIGINT); Nullable=true; AutoInc=false; MaxSize=19

    • set_bigint_val

      public alltypes set_bigint_val(long bigint_val)
      int8 (BIGINT); Nullable=true; AutoInc=false; MaxSize=19

    • setNull_bigint_val

      public alltypes setNull_bigint_val()

    • get_float_val

      public float get_float_val()
      float4 (REAL); Nullable=true; AutoInc=false; MaxSize=8

    • set_float_val

      public alltypes set_float_val(float float_val)
      float4 (REAL); Nullable=true; AutoInc=false; MaxSize=8

    • setNull_float_val

      public alltypes setNull_float_val()

    • get_double_val

      public double get_double_val()
      float8 (DOUBLE); Nullable=true; AutoInc=false; MaxSize=17

    • set_double_val

      public alltypes set_double_val(double double_val)
      float8 (DOUBLE); Nullable=true; AutoInc=false; MaxSize=17

    • setNull_double_val

      public alltypes setNull_double_val()

    • get_numeric_val

      public BigDecimal get_numeric_val()
      numeric (NUMERIC); Nullable=true; AutoInc=false; MaxSize=5

    • set_numeric_val

      public alltypes set_numeric_val(BigDecimal numeric_val)
      numeric (NUMERIC); Nullable=true; AutoInc=false; MaxSize=5

    • get_char_val

      public String get_char_val()
      bpchar (CHAR); Nullable=true; AutoInc=false; MaxSize=10

    • set_char_val

      public alltypes set_char_val(String char_val)
      bpchar (CHAR); Nullable=true; AutoInc=false; MaxSize=10

    • get_varchar_val

      public String get_varchar_val()
      varchar (VARCHAR); Nullable=true; AutoInc=false; MaxSize=10

    • set_varchar_val

      public alltypes set_varchar_val(String varchar_val)
      varchar (VARCHAR); Nullable=true; AutoInc=false; MaxSize=10

    • get_longvarchar_val

      public String get_longvarchar_val()
      text (VARCHAR); Nullable=true; AutoInc=false; MaxSize=2147483647

    • set_longvarchar_val

      public alltypes set_longvarchar_val(String longvarchar_val)
      text (VARCHAR); Nullable=true; AutoInc=false; MaxSize=2147483647

    • get_date_val

      public Date get_date_val()
      date (DATE); Nullable=true; AutoInc=false; MaxSize=13

    • set_date_val

      public alltypes set_date_val(Date date_val)
      date (DATE); Nullable=true; AutoInc=false; MaxSize=13

    • get_time_val

      public Time get_time_val()
      time (TIME); Nullable=true; AutoInc=false; MaxSize=15

    • set_time_val

      public alltypes set_time_val(Time time_val)
      time (TIME); Nullable=true; AutoInc=false; MaxSize=15

    • get_timestamp_val

      public Timestamp get_timestamp_val()
      timestamp (TIMESTAMP); Nullable=true; AutoInc=false; MaxSize=29

    • set_timestamp_val

      public alltypes set_timestamp_val(Timestamp timestamp_val)
      timestamp (TIMESTAMP); Nullable=true; AutoInc=false; MaxSize=29

    • get_bit_val

      public Boolean get_bit_val()
      bit (BIT); Nullable=true; AutoInc=false; MaxSize=1

    • set_bit_val

      public alltypes set_bit_val(Boolean bit_val)
      bit (BIT); Nullable=true; AutoInc=false; MaxSize=1

    • get_array_val

      public Array get_array_val()
      _varchar (ARRAY); Nullable=true; AutoInc=false; MaxSize=10

    • set_array_val

      public alltypes set_array_val(Array array_val)
      _varchar (ARRAY); Nullable=true; AutoInc=false; MaxSize=10

    • get_boolean_val

      public Boolean get_boolean_val()
      bool (BIT); Nullable=true; AutoInc=false; MaxSize=1

    • set_boolean_val

      public alltypes set_boolean_val(Boolean boolean_val)
      bool (BIT); Nullable=true; AutoInc=false; MaxSize=1

    • get_varbinary_val

      public byte[] get_varbinary_val()
      bytea (BINARY); Nullable=true; AutoInc=false; MaxSize=2147483647

    • set_varbinary_val

      public alltypes set_varbinary_val(byte[] varbinary_val)
      bytea (BINARY); Nullable=true; AutoInc=false; MaxSize=2147483647

    • get_json_val

      public String get_json_val()
      json (OTHER); Nullable=true; AutoInc=false; MaxSize=2147483647

    • set_json_val

      public alltypes set_json_val(String json_val)
      json (OTHER); Nullable=true; AutoInc=false; MaxSize=2147483647

    • get_jsonb_val

      public String get_jsonb_val()
      jsonb (OTHER); Nullable=true; AutoInc=false; MaxSize=2147483647

    • set_jsonb_val

      public alltypes set_jsonb_val(String jsonb_val)
      jsonb (OTHER); Nullable=true; AutoInc=false; MaxSize=2147483647

    • inc_int_val

      public alltypes inc_int_val()
      Increments int_val by 1

    • inc_int_val

      public alltypes inc_int_val(int amount)
      Increments int_val by the specified amount

    • inc_int_val

      public alltypes inc_int_val(int amount, int upper_bound)
      Increments int_val by the specified amount, upto but not above the upper bound (bound is inclusive)

    • dec_int_val

      public alltypes dec_int_val()
      Decrements int_val by 1

    • dec_int_val

      public alltypes dec_int_val(int amount)
      Decrements int_val by the specified amount

    • dec_int_val

      public alltypes dec_int_val(int amount, int lower_bound)
      Decrements int_val by the specified amount, upto but not below the lower bound (bound is inclusive)

    • inc_bigint_val

      public alltypes inc_bigint_val()
      Increments bigint_val by 1

    • inc_bigint_val

      public alltypes inc_bigint_val(long amount)
      Increments bigint_val by the specified amount

    • inc_bigint_val

      public alltypes inc_bigint_val(long amount, int upper_bound)
      Increments bigint_val by the specified amount, upto but not above the upper bound (bound is inclusive)

    • dec_bigint_val

      public alltypes dec_bigint_val()
      Decrements bigint_val by 1

    • dec_bigint_val

      public alltypes dec_bigint_val(long amount)
      Decrements bigint_val by the specified amount

    • dec_bigint_val

      public alltypes dec_bigint_val(long amount, int lower_bound)
      Decrements bigint_val by the specified amount, upto but not below the lower bound (bound is inclusive)