Package org.sgrewritten.stargate.database

Enum Class SQLQuery

java.lang.Object
java.lang.Enum<SQLQuery>
org.sgrewritten.stargate.database.SQLQuery
All Implemented Interfaces:
Serializable, Comparable<SQLQuery>, Constable
public enum SQLQuery extends Enum<SQLQuery>
All SQL queries used by this plugin

  • Enum Constant Details

    • CREATE_TABLE_PORTAL

      public static final SQLQuery CREATE_TABLE_PORTAL
      The query for creating the portal table

    • CREATE_TABLE_INTER_PORTAL

      public static final SQLQuery CREATE_TABLE_INTER_PORTAL
      The query for creating the inter-portal table

    • CREATE_TABLE_PORTAL_POSITION_TYPE

      public static final SQLQuery CREATE_TABLE_PORTAL_POSITION_TYPE
      The query for creating the position type table

    • CREATE_TABLE_PORTAL_POSITION

      public static final SQLQuery CREATE_TABLE_PORTAL_POSITION
      The query for creating the portal position table

    • CREATE_TABLE_INTER_PORTAL_POSITION

      public static final SQLQuery CREATE_TABLE_INTER_PORTAL_POSITION
      The query for creating the inter-portal position table

    • CREATE_TABLE_PORTAL_FLAG

      public static final SQLQuery CREATE_TABLE_PORTAL_FLAG
      The query for creating the (portal) flag table

    • CREATE_TABLE_SERVER_INFO

      public static final SQLQuery CREATE_TABLE_SERVER_INFO
      The query for creating the server info table

    • CREATE_TABLE_LAST_KNOWN_NAME

      public static final SQLQuery CREATE_TABLE_LAST_KNOWN_NAME
      The query for creating the last known name table

    • CREATE_TABLE_PORTAL_FLAG_RELATION

      public static final SQLQuery CREATE_TABLE_PORTAL_FLAG_RELATION
      The query for creating the portal flag relation table

    • CREATE_TABLE_INTER_PORTAL_FLAG_RELATION

      public static final SQLQuery CREATE_TABLE_INTER_PORTAL_FLAG_RELATION
      The query for creating the inter-portal flag relation table

    • CREATE_VIEW_PORTAL

      public static final SQLQuery CREATE_VIEW_PORTAL
      The query for creating the portal view

    • CREATE_VIEW_INTER_PORTAL

      public static final SQLQuery CREATE_VIEW_INTER_PORTAL
      The query for creating the inter-portal view

    • CREATE_INDEX_PORTAL_POSITION

      public static final SQLQuery CREATE_INDEX_PORTAL_POSITION
      The query for creating the (name,network) index on the portal position table

    • CREATE_INDEX_INTER_PORTAL_POSITION

      public static final SQLQuery CREATE_INDEX_INTER_PORTAL_POSITION
      The query for creating the (name,network) index on the inter-portal position table

    • GET_ALL_PORTALS

      public static final SQLQuery GET_ALL_PORTALS
      The query for getting every portal

    • GET_ALL_INTER_PORTALS

      public static final SQLQuery GET_ALL_INTER_PORTALS
      The query for getting every inter-portal

    • GET_ALL_PORTAL_FLAGS

      public static final SQLQuery GET_ALL_PORTAL_FLAGS
      The query for getting all portal flags

    • GET_ALL_PORTAL_POSITION_TYPES

      public static final SQLQuery GET_ALL_PORTAL_POSITION_TYPES
      The query for getting all portal position types

    • GET_PORTAL_POSITIONS

      public static final SQLQuery GET_PORTAL_POSITIONS
      The query for getting all portal positions

    • GET_INTER_PORTAL_POSITIONS

      public static final SQLQuery GET_INTER_PORTAL_POSITIONS
      The query for getting all inter-portal positions

    • INSERT_PORTAL_POSITION_TYPE

      public static final SQLQuery INSERT_PORTAL_POSITION_TYPE
      The query for inserting a new portal position type

    • INSERT_PORTAL_POSITION

      public static final SQLQuery INSERT_PORTAL_POSITION
      The query for inserting a new portal position

    • INSERT_INTER_PORTAL_POSITION

      public static final SQLQuery INSERT_INTER_PORTAL_POSITION
      The query for inserting a new inter-portal position

    • INSERT_PORTAL_FLAG

      public static final SQLQuery INSERT_PORTAL_FLAG
      The query for inserting a new portal flag

    • INSERT_PORTAL_FLAG_RELATION

      public static final SQLQuery INSERT_PORTAL_FLAG_RELATION
      The query for inserting a new portal flag relation

    • INSERT_INTER_PORTAL_FLAG_RELATION

      public static final SQLQuery INSERT_INTER_PORTAL_FLAG_RELATION
      The query for inserting a new inter-portal flag relation

    • INSERT_PORTAL

      public static final SQLQuery INSERT_PORTAL
      The query for inserting a new portal

    • INSERT_INTER_PORTAL

      public static final SQLQuery INSERT_INTER_PORTAL
      The query for inserting a new inter-portal

    • REPLACE_LAST_KNOWN_NAME

      public static final SQLQuery REPLACE_LAST_KNOWN_NAME
      The query for replacing the last known name of a player

    • REPLACE_SERVER_INFO

      public static final SQLQuery REPLACE_SERVER_INFO
      The query for replacing the known information about a server

    • DELETE_PORTAL_POSITIONS

      public static final SQLQuery DELETE_PORTAL_POSITIONS
      The query for deleting a portal position

    • DELETE_INTER_PORTAL_POSITIONS

      public static final SQLQuery DELETE_INTER_PORTAL_POSITIONS
      The query for deleting an inter-portal position

    • DELETE_PORTAL_FLAG_RELATIONS

      public static final SQLQuery DELETE_PORTAL_FLAG_RELATIONS
      The query for deleting a portal flag relation

    • DELETE_INTER_PORTAL_FLAG_RELATIONS

      public static final SQLQuery DELETE_INTER_PORTAL_FLAG_RELATIONS
      The query for deleting an inter-portal flag relation

    • DELETE_PORTAL_FLAG_RELATION

      public static final SQLQuery DELETE_PORTAL_FLAG_RELATION
      The query for deleting one portal flag relation

    • DELETE_INTER_PORTAL_FLAG_RELATION

      public static final SQLQuery DELETE_INTER_PORTAL_FLAG_RELATION
      The query for deliting one inter-portal flag relation

    • DELETE_PORTAL

      public static final SQLQuery DELETE_PORTAL
      The query for deleting a portal

    • DELETE_INTER_PORTAL

      public static final SQLQuery DELETE_INTER_PORTAL
      The query for deleting an inter-portal

    • SHOW_INDEX_PORTAL_POSITION

      public static final SQLQuery SHOW_INDEX_PORTAL_POSITION
      The query for checking if the portal position index exists

    • SHOW_INDEX_INTER_PORTAL_POSITION

      public static final SQLQuery SHOW_INDEX_INTER_PORTAL_POSITION
      The query for checking if the inter-portal position index exists

    • DELETE_PORTAL_POSITION

      public static final SQLQuery DELETE_PORTAL_POSITION
      Remove portal position from the database

    • DELETE_INTER_PORTAL_POSITION

      public static final SQLQuery DELETE_INTER_PORTAL_POSITION
      Remove inter portal from the database

    • GET_PORTAL

      public static final SQLQuery GET_PORTAL
      The query for getting data of one portal

    • GET_INTER_PORTAL

      public static final SQLQuery GET_INTER_PORTAL
      The query for getting data of one inteserver portal

    • SET_PORTAL_META

      public static final SQLQuery SET_PORTAL_META
      The query for setting the metadata of a portal

    • SET_INTER_PORTAL_META

      public static final SQLQuery SET_INTER_PORTAL_META
      The query for setting the metadata of an inter-server portal

    • SET_PORTAL_POSITION_META

      public static final SQLQuery SET_PORTAL_POSITION_META
      The query for setting the meta for a portal position

    • SET_INTER_PORTAL_POSITION_META

      public static final SQLQuery SET_INTER_PORTAL_POSITION_META
      The query for setting the meta for an inter-portal-position

    • GET_PORTAL_POSITION_META

      public static final SQLQuery GET_PORTAL_POSITION_META
      Get the meta inside a portal position

    • GET_INTER_PORTAL_POSITION_META

      public static final SQLQuery GET_INTER_PORTAL_POSITION_META
      Get the meta inside a inter-portal position

    • UPDATE_NETWORK_NAME

      public static final SQLQuery UPDATE_NETWORK_NAME
      Change the name of the network

    • UPDATE_INTER_NETWORK_NAME

      public static final SQLQuery UPDATE_INTER_NETWORK_NAME
      Change the name of an inter server network

    • UPDATE_PORTAL_NAME

      public static final SQLQuery UPDATE_PORTAL_NAME
      Change the name of a portal

    • UPDATE_INTER_PORTAL_NAME

      public static final SQLQuery UPDATE_INTER_PORTAL_NAME
      Change the name of an inter server portal

    • GET_ALL_PORTALS_OF_NETWORK

      public static final SQLQuery GET_ALL_PORTALS_OF_NETWORK
      Get all portals of specified network

    • GET_ALL_INTER_PORTALS_OF_NETWORK

      public static final SQLQuery GET_ALL_INTER_PORTALS_OF_NETWORK
      Get all inter server portals of network

    • DELETE_WORLD

      public static final SQLQuery DELETE_WORLD
      Delete all portals residing in specified world

    • DELETE_INTER_WORLD

      public static final SQLQuery DELETE_INTER_WORLD
      Delete all inter server portals residing in specified world and server

    • DELETE_GATE_FORMAT

      public static final SQLQuery DELETE_GATE_FORMAT
      Delete all portals with the specified gate format

    • DELETE_INTER_GATE_FORMAT

      public static final SQLQuery DELETE_INTER_GATE_FORMAT
      Delete all inter server portals with the specified gate format and server

  • Method Details

    • values

      public static SQLQuery[] values()
      Returns an array containing the constants of this enum class, in the order they are declared.
      Returns:
      an array containing the constants of this enum class, in the order they are declared

    • valueOf

      public static SQLQuery valueOf(String name)
      Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (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 class has no constant with the specified name
      NullPointerException - if the argument is null