Interface FColorSQL

All Superinterfaces:
SQL
All Known Subinterfaces:
FColorH2, FColorMariaDB, FColorMySQL, FColorPostgreSQL, FColorSQLite
public interface FColorSQL extends SQL
SQL interface for player color data operations in FlectonePulse. Defines database queries for managing player color configurations.
Since:
0.9.0

  • Method Details

    • findFColors

      List<FColorDao.FColorInfo> findFColors(int playerId)

    • findFColorIdsByNames

      default Map<String,Integer> findFColorIdsByNames(org.jdbi.v3.core.Handle handle, List<String> names)

    • deleteFColors

      void deleteFColors(int playerId)

    • deleteFColors

      void deleteFColors(int playerId, String type)

    • deleteFColors

      void deleteFColors(int playerId, String type, List<Integer> numbers)

    • insertFColorsIfAbsent

      default void insertFColorsIfAbsent(List<String> names)
      Inserts color names into the database if they do not already exist.
      Parameters:
      names - list of color names to insert if absent
      Throws:
      UnsupportedDatabaseOperationException - if not overridden

    • batchUpsertPlayerFColors

      default void batchUpsertPlayerFColors(int playerId, List<Integer> numbers, List<Integer> fcolorIds, String type)
      Performs batch upsert operations for player color configurations. Inserts or updates multiple player color entries in a single operation, associating color numbers with their corresponding color IDs and type.
      Parameters:
      playerId - the unique identifier of the player
      numbers - list of color slot numbers
      fcolorIds - list of color identifiers corresponding to each number
      type - the classification type of the colors
      Throws:
      UnsupportedDatabaseOperationException - if not overridden