Enum NCSqlJoinType

  • All Implemented Interfaces:
    Serializable, Comparable<NCSqlJoinType>

    public enum NCSqlJoinType
    extends Enum<NCSqlJoinType>
    Type of the SQL join.

    In JSON/YAML generated model SQL join type is declared with the following data model metadata (example):

       sql:joins:
       - fromtable: "orders"
         fromcolumns:
         - "customer_id"
         totable: "customers"
         tocolumns:
         - "customer_id"
         jointype: "left"
     
    Refer to SQL Join.
    • Enum Constant Summary

      Enum Constants 
      Enum Constant Description
      INNER
      The INNER JOIN keyword selects records that have matching values in both tables.
      LEFT
      The LEFT JOIN keyword returns all records from the left table, and the matched records from the right table.
      OUTER
      The FULL OUTER JOIN keyword returns all records when there is a match in left or right table records.
      RIGHT
      The RIGHT JOIN keyword returns all records from the right table, and the matched records from the left table.
    • Enum Constant Detail

      • INNER

        public static final NCSqlJoinType INNER
        The INNER JOIN keyword selects records that have matching values in both tables.
      • LEFT

        public static final NCSqlJoinType LEFT
        The LEFT JOIN keyword returns all records from the left table, and the matched records from the right table.
      • RIGHT

        public static final NCSqlJoinType RIGHT
        The RIGHT JOIN keyword returns all records from the right table, and the matched records from the left table.
      • OUTER

        public static final NCSqlJoinType OUTER
        The FULL OUTER JOIN keyword returns all records when there is a match in left or right table records.
    • Method Detail

      • values

        public static NCSqlJoinType[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
        for (NCSqlJoinType c : NCSqlJoinType.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static NCSqlJoinType valueOf​(String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        IllegalArgumentException - if this enum type has no constant with the specified name
        NullPointerException - if the argument is null