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

      returns 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 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 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 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

    • 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

    • 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

    • 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

    • 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

      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

      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

      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

      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

      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

      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

      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

      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

      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)