Module rxmicro.data.sql
Package io.rxmicro.data.sql

Class SupportedVariables

  • public final class SupportedVariables
extends Object
    Author:
    nedis

    • Field Summary

      Fields 
      Modifier and Type Field Description
      static String ALL_COLUMNS
      All table columns defined at java class, separated by comma (,)
      static String BY_ID_FILTER
      By primary key filters, separated by comma (,)
      static String ID_COLUMNS
      Primary keys defined at java class, separated by comma (,) ${id-columns} = {primary keys}
      static String INSERTED_COLUMNS
      Table columns defined at java class and available to insert to database table, separated by comma (,) ${inserted-columns} = ${all-columns} minus {Columns annotated by @NotInsertable} minus {auto generated primary keys}
      static String TABLE
      Database full table name.
      static String UPDATED_COLUMNS
      Table column set expressions defined at java class and available to update to database table, separated by comma (,) ${updated-columns} = ${all-columns} minus {Columns annotated by @NotUpdatable} minus {primary keys}
      static String VALUES
      Insertable values, separated by comma (,)

    • Field Detail

      • TABLE

        public static final String TABLE
        Database full table name. i.e. if schema defined, then ${table} = schemaName.tableName, otherwise ${table} = tableName
        See Also:
        Constant Field Values

      • ALL_COLUMNS

        public static final String ALL_COLUMNS
        All table columns defined at java class, separated by comma (,)

        For example: ${all-columns} = id, login, name, password

        See Also:
        Constant Field Values

      • INSERTED_COLUMNS

        public static final String INSERTED_COLUMNS
        Table columns defined at java class and available to insert to database table, separated by comma (,) ${inserted-columns} = ${all-columns} minus {Columns annotated by @NotInsertable} minus {auto generated primary keys}

        For example: ${inserted-columns} = login, name, password

        See Also:
        Constant Field Values

      • UPDATED_COLUMNS

        public static final String UPDATED_COLUMNS
        Table column set expressions defined at java class and available to update to database table, separated by comma (,) ${updated-columns} = ${all-columns} minus {Columns annotated by @NotUpdatable} minus {primary keys}

        For example: ${updated-columns} = login = ?, name = ?, password = ?

        See Also:
        Constant Field Values

      • VALUES

        public static final String VALUES
        Insertable values, separated by comma (,)

        For example: ${values} = ?, ?, ?

        See Also:
        Constant Field Values

      • ID_COLUMNS

        public static final String ID_COLUMNS
        Primary keys defined at java class, separated by comma (,) ${id-columns} = {primary keys}

        For example: ${id-columns} = id1, id2 if primary key is complex For example: ${id-columns} = id if primary key is simple

        See Also:
        Constant Field Values

      • BY_ID_FILTER

        public static final String BY_ID_FILTER
        By primary key filters, separated by comma (,)

        For example: ${by-id-filter} = id1 = ? AND id2 = ? if primary key is complex For example: ${by-id-filter} = id = ? if primary key is simple

        See Also:
        Constant Field Values