Package com.github.eikecochu.sqlbuilder

Enum InsertMode

  • All Implemented Interfaces:
    QueryPart, java.io.Serializable, java.lang.Comparable<InsertMode>
    public enum InsertMode
extends java.lang.Enum<InsertMode>
implements QueryPart
    InsertMode defines how the INSERT statement inserts values into the database.

    • Method Summary

      All Methods Static Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      java.lang.String string​(QueryOptions options)
      Transforms this statement into an SQL string
      static InsertMode valueOf​(java.lang.String name)
      Returns the enum constant of this type with the specified name.
      static InsertMode[] values()
      Returns an array containing the constants of this enum type, in the order they are declared.

      • Methods inherited from class java.lang.Enum

        clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

      • Methods inherited from class java.lang.Object

        getClass, notify, notifyAll, wait, wait, wait

      • Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPart

        string

    • Enum Constant Detail

      • INSERT

        public static final InsertMode INSERT
        The INSERT mode. Default behavior. Will attempt to insert values into the database.

      • REPLACE

        public static final InsertMode REPLACE
        The REPLACE mode. Will attempt to replace values in the database.

      • INSERT_OR_REPLACE

        public static final InsertMode INSERT_OR_REPLACE
        The INSERT OR REPLACE mode. Will attempt to replace values in the database if they exist, otherwise it attempts to insert them.

      • INSERT_OR_ROLLBACK

        public static final InsertMode INSERT_OR_ROLLBACK
        The INSERT OR ROLLBACK mode. Will attempt to insert values into the database and rollback changes if any insertion fails.

      • INSERT_OR_ABORT

        public static final InsertMode INSERT_OR_ABORT
        The INSERT OR ABORT mode. Will attempt to insert values into the database and stop of any insertion fails.

      • INSERT_OR_FAIL

        public static final InsertMode INSERT_OR_FAIL
        The INSERT OR FAIL mode. Will attempt to insert values into the database and fail if any insertion fails.

      • INSERT_OR_IGNORE

        public static final InsertMode INSERT_OR_IGNORE
        The INSERT OR IGNORE mode. Will attempt to insert values into the database and ignore any failing insertion.

    • Method Detail

      • values

        public static InsertMode[] 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 (InsertMode c : InsertMode.values())
    System.out.println(c);
        Returns:
        an array containing the constants of this enum type, in the order they are declared

      • valueOf

        public static InsertMode valueOf​(java.lang.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:
        java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
        java.lang.NullPointerException - if the argument is null

      • string

        public java.lang.String string​(QueryOptions options)
        Description copied from interface: QueryPart
        Transforms this statement into an SQL string
        Specified by:
        string in interface QueryPart
        Parameters:
        options - The QueryOptions to apply for transformation
        Returns:
        The created SQL string