Package uk.ac.manchester.spinnaker.alloc.db

Class SQLQueries

java.lang.Object
uk.ac.manchester.spinnaker.alloc.db.SQLQueries
Direct Known Subclasses:
DatabaseAwareBean, DirInfo
public abstract class SQLQueries extends Object
The literal SQL queries used in this package.

The schema they query against (defined in spalloc.sql) is:
Database Schema

Author:
Donal Fellows

  • Field Details

    • GET_ALL_MACHINES

      @Parameter("allow_out_of_service") @ResultColumn("machine_id") @ResultColumn("machine_name") @ResultColumn("width") @ResultColumn("height") @ResultColumn("in_service") protected static final String GET_ALL_MACHINES
      Get basic information about all machines.
      See Also:

    • LIST_MACHINE_NAMES

      @Parameter("allow_out_of_service") @ResultColumn("machine_name") @ResultColumn("in_service") protected static final String LIST_MACHINE_NAMES
      Get the machine names in alphabetical order.
      See Also:

    • GET_MACHINE_BY_ID

      @Parameter("machine_id") @Parameter("allow_out_of_service") @ResultColumn("machine_id") @ResultColumn("machine_name") @ResultColumn("width") @ResultColumn("height") @ResultColumn("in_service") @SingleRowResult protected static final String GET_MACHINE_BY_ID
      Get basic information about a specific machine. Looks up by ID.
      See Also:

    • GET_NAMED_MACHINE

      @Parameter("machine_name") @Parameter("allow_out_of_service") @ResultColumn("machine_id") @ResultColumn("machine_name") @ResultColumn("width") @ResultColumn("height") @ResultColumn("in_service") @SingleRowResult protected static final String GET_NAMED_MACHINE
      Get basic information about a specific machine. Looks up by name.
      See Also:

    • GET_MACHINE_WRAPS

      @Parameter("machine_id") @ResultColumn("horizontal_wrap") @ResultColumn("vertical_wrap") @SingleRowResult protected static final String GET_MACHINE_WRAPS
      Get whether a machine wraps in horizontal or vertical directions. Machines (especially of any size) are usually expected to do so.
      See Also:

    • COUNT_MACHINE_THINGS

      @Parameter("machine_id") @ResultColumn("board_count") @ResultColumn("in_use") @ResultColumn("num_jobs") @SingleRowResult protected static final String COUNT_MACHINE_THINGS
      Count things on a machine.
      See Also:

    • GET_JOB_IDS

      @Parameter("limit") @Parameter("offset") @ResultColumn("job_id") @ResultColumn("machine_id") @ResultColumn("job_state") @ResultColumn("keepalive_timestamp") protected static final String GET_JOB_IDS
      Get basic information about jobs. Supports paging.
      See Also:

    • GET_LIVE_JOB_IDS

      @Parameter("limit") @Parameter("offset") @ResultColumn("job_id") @ResultColumn("machine_id") @ResultColumn("job_state") @ResultColumn("keepalive_timestamp") protected static final String GET_LIVE_JOB_IDS
      Get basic information about live jobs. Supports paging.
      See Also:

    • GET_ALL_LIVE_JOBS

      @ResultColumn("job_id") protected static final String GET_ALL_LIVE_JOBS
      Select all live jobs.
      See Also:

    • DESTROY_ALL_LIVE_JOBS

      @Parameter("death_reason") protected static final String DESTROY_ALL_LIVE_JOBS
      Destroy all live jobs.
      See Also:

    • GET_JOB

      @Parameter("job_id") @ResultColumn("job_id") @ResultColumn("machine_id") @ResultColumn("machine_name") @ResultColumn("width") @ResultColumn("height") @ResultColumn("depth") @ResultColumn("root_id") @ResultColumn("job_state") @ResultColumn("keepalive_timestamp") @ResultColumn("keepalive_host") @ResultColumn("keepalive_interval") @ResultColumn("create_timestamp") @ResultColumn("death_reason") @ResultColumn("death_timestamp") @ResultColumn("original_request") @ResultColumn("owner") @SingleRowResult protected static final String GET_JOB
      Get basic information about a specific job.
      See Also:

    • GET_JOB_CHIP_DIMENSIONS

      @Parameter("job_id") @ResultColumn("width") @ResultColumn("height") @SingleRowResult protected static final String GET_JOB_CHIP_DIMENSIONS
      Get the chip dimensions of a job.
      See Also:

    • GET_JOB_BOARDS

      @Parameter("job_id") @ResultColumn("board_id") @ResultColumn("bmp_id") @ResultColumn("machine_id") protected static final String GET_JOB_BOARDS
      Get what boards are allocated to a job.
      See Also:

    • LIST_LIVE_JOBS

      @ResultColumn("job_id") @ResultColumn("machine_id") @ResultColumn("create_timestamp") @ResultColumn("keepalive_interval") @ResultColumn("job_state") @ResultColumn("allocation_size") @ResultColumn("keepalive_host") @ResultColumn("user_name") @ResultColumn("machine_name") @ResultColumn("original_request") protected static final String LIST_LIVE_JOBS
      Gets information about live jobs.
      See Also:

    • COUNT_POWERED_BOARDS

      @Parameter("job_id") @ResultColumn("c") @SingleRowResult protected static final String COUNT_POWERED_BOARDS
      Counts the number of powered-on boards of a job.
      See Also:

    • GET_ROOT_OF_BOARD

      @Parameter("board_id") @ResultColumn("root_x") @ResultColumn("root_y") @SingleRowResult protected static final String GET_ROOT_OF_BOARD
      Get the coordinates of the root chip of a board.
      See Also:

    • INSERT_JOB

      @Parameter("machine_id") @Parameter("user_id") @Parameter("group_id") @Parameter("keepalive_interval") @Parameter("original_request") @GeneratesID protected static final String INSERT_JOB
      Create a job.
      See Also:

    • INSERT_REQ_N_BOARDS

      @Parameter("job_id") @Parameter("num_boards") @Parameter("max_dead_boards") @Parameter("priority") @GeneratesID protected static final String INSERT_REQ_N_BOARDS
      Create a request to allocate a number of boards.
      See Also:

    • INSERT_REQ_SIZE

      @Parameter("job_id") @Parameter("width") @Parameter("height") @Parameter("max_dead_boards") @Parameter("priority") @GeneratesID protected static final String INSERT_REQ_SIZE
      Create a request to allocate a rectangle of boards.
      See Also:

    • INSERT_REQ_BOARD

      @Parameter("job_id") @Parameter("board_id") @Parameter("priority") @GeneratesID protected static final String INSERT_REQ_BOARD
      Create a request to allocate a specific board.
      See Also:

    • INSERT_REQ_SIZE_BOARD

      @Parameter("job_id") @Parameter("board_id") @Parameter("width") @Parameter("height") @Parameter("max_dead_boards") @Parameter("priority") @GeneratesID protected static final String INSERT_REQ_SIZE_BOARD
      Create a request to allocate triads starting at a particular board.
      See Also:

    • BUMP_IMPORTANCE

      protected static final String BUMP_IMPORTANCE
      Increases the importance of a job.
      See Also:

    • GET_ROOT_BMP_ADDRESS

      @Parameter("machine_id") @ResultColumn("address") @SingleRowResult protected static final String GET_ROOT_BMP_ADDRESS
      Get the address of the BMP of the root board of the machine.
      See Also:

    • GET_BMP_ADDRESS

      @Parameter("machine_id") @Parameter("cabinet") @Parameter("frame") @ResultColumn("address") @SingleRowResult protected static final String GET_BMP_ADDRESS
      Get the address of the BMP of the root board of the machine.
      See Also:

    • GET_ALL_BMPS

      @ResultColumn("bmp_id") @ResultColumn("machine_name") @ResultColumn("address") @ResultColumn("cabinet") @ResultColumn("frame") protected static final String GET_ALL_BMPS
      Get all the BMPs.
      See Also:

    • GET_ALL_BMP_BOARDS

      @Parameter("bmp_id") @ResultColumn("board_id") @ResultColumn("board_num") @ResultColumn("address") protected static final String GET_ALL_BMP_BOARDS
      Get all the boards of a BMP.
      See Also:

    • GET_BOARD_ADDRESS

      @Parameter("board_id") @ResultColumn("address") @SingleRowResult protected static final String GET_BOARD_ADDRESS
      Get the address of the root chip of a board.
      See Also:

    • GET_BOARD_NUMBERS

      @Parameter("machine_id") @ResultColumn("board_num") protected static final String GET_BOARD_NUMBERS
      Get the boards of a machine that can be used. Excludes disabled boards.
      See Also:

    • GET_BMP_BOARD_NUMBERS

      @Parameter("machine_id") @Parameter("cabinet") @Parameter("frame") @ResultColumn("board_num") protected static final String GET_BMP_BOARD_NUMBERS
      Get the boards of a BMP that can be used. Excludes disabled boards.
      See Also:

    • GET_LIVE_BOARDS

      @Parameter("machine_id") @ResultColumn("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("address") @ResultColumn("bmp_id") @ResultColumn("machine_id") protected static final String GET_LIVE_BOARDS
      Get the boards (and related info) of a machine that are in service.
      See Also:

    • GET_DEAD_BOARDS

      @Parameter("machine_id") @ResultColumn("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("address") @ResultColumn("bmp_id") @ResultColumn("machine_id") protected static final String GET_DEAD_BOARDS
      Get the boards (and related info) of a machine that have been disabled.
      See Also:

    • GET_ALL_BOARDS

      @Parameter("machine_id") @ResultColumn("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("address") @ResultColumn("bmp_id") @ResultColumn("machine_id") protected static final String GET_ALL_BOARDS
      Get all the boards (and related info) of a machine.
      See Also:

    • GET_ALL_BOARDS_OF_ALL_MACHINES

      @ResultColumn("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("address") @ResultColumn("bmp_id") @ResultColumn("machine_id") protected static final String GET_ALL_BOARDS_OF_ALL_MACHINES
      Get all the boards (and related info) known to the service.
      See Also:

    • GET_JOB_BOARD_COORDS

      @Parameter("job_id") @ResultColumn("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("address") @ResultColumn("bmp_id") @ResultColumn("machine_id") protected static final String GET_JOB_BOARD_COORDS
      Get the coords of boards assigned to a job.
      See Also:

    • GET_MACHINE_JOBS

      @Parameter("machine_id") @ResultColumn("job_id") @ResultColumn("owner_name") protected static final String GET_MACHINE_JOBS
      Get basic info about active jobs on a machine.
      See Also:

    • GET_AVAILABLE_BOARD_NUMBERS

      @Parameter("machine_id") @ResultColumn("board_num") protected static final String GET_AVAILABLE_BOARD_NUMBERS
      Get the boards that are available for allocation.
      See Also:

    • GET_TAGS

      @Parameter("machine_id") @ResultColumn("tag") protected static final String GET_TAGS
      Get a machine's tags. Theoretically when selecting a machine by tags we should put the query in the DB, but it is awkward to move a list into SQL as part of a query and we don't really ever have that many machines or tags. So we just pull the collection of tags and do the match in Java.
      See Also:

    • UPDATE_KEEPALIVE

      @Parameter("keepalive_host") @Parameter("job_id") protected static final String UPDATE_KEEPALIVE
      Update the keepalive timestamp.
      See Also:

    • DESTROY_JOB

      @Parameter("death_reason") @Parameter("job_id") protected static final String DESTROY_JOB
      Mark a job as dead.
      See Also:

    • NOTE_DESTROY_REASON

      @Parameter("death_reason") @Parameter("job_id") protected static final String NOTE_DESTROY_REASON
      Record the reason for a job being destroyed.
      See Also:

    • GET_SUM_BOARDS_POWERED

      @Parameter("job_id") @ResultColumn("total_on") @SingleRowResult protected static final String GET_SUM_BOARDS_POWERED
      Get the number of boards that are allocated to a job that are switched on.
      See Also:

    • GET_BOARD_CONNECT_INFO

      @Parameter("job_id") @ResultColumn("board_id") @ResultColumn("address") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("root_x") @ResultColumn("root_y") protected static final String GET_BOARD_CONNECT_INFO
      Get connection info for board allocated to a job.
      See Also:

    • GET_ROOT_COORDS

      @Parameter("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("root_x") @ResultColumn("root_y") @SingleRowResult protected static final String GET_ROOT_COORDS
      Get the coordinates of a board.
      See Also:

    • GET_BOARD_POWER_INFO

      @Parameter("board_id") @ResultColumn("board_power") @ResultColumn("power_off_timestamp") @ResultColumn("power_on_timestamp") @SingleRowResult protected static final String GET_BOARD_POWER_INFO
      Get whether a board is powered.
      See Also:

    • GET_BOARD_JOB

      @Parameter("board_id") @ResultColumn("allocated_job") @SingleRowResult protected static final String GET_BOARD_JOB
      Get What job is allocated to a board.
      See Also:

    • GET_MACHINE_REPORTS

      @Parameter("machine_id") @ResultColumn("board_id") @ResultColumn("report_id") @ResultColumn("reported_issue") @ResultColumn("report_timestamp") @ResultColumn("reporter_name") protected static final String GET_MACHINE_REPORTS
      Get the problem reports about boards in a machine.
      See Also:

    • GET_BOARD_REPORTS

      @Parameter("board_id") @ResultColumn("board_id") @ResultColumn("report_id") @ResultColumn("reported_issue") @ResultColumn("report_timestamp") @ResultColumn("reporter_name") protected static final String GET_BOARD_REPORTS
      Get the problem reports about a board.
      See Also:

    • DELETE_TASK

      @Parameter("job_id") protected static final String DELETE_TASK
      Delete an allocation task.
      See Also:

    • FIND_FREE_BOARD

      @Parameter("machine_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @SingleRowResult protected static final String FIND_FREE_BOARD
      Find a single free board.
      See Also:

    • COUNT_FUNCTIONING_BOARDS

      @Parameter("machine_id") @ResultColumn("c") @SingleRowResult protected static final String COUNT_FUNCTIONING_BOARDS
      Check there is a single free board.
      See Also:

    • ALLOCATE_BOARDS_JOB

      @Parameter("width") @Parameter("height") @Parameter("depth") @Parameter("board_id") @Parameter("num_boards") @Parameter("allocated_board_id") @Parameter("job_id") protected static final String ALLOCATE_BOARDS_JOB
      Tell a job that it is allocated. Doesn't set the state.
      See Also:

    • GET_BOARD_BY_COORDS

      @Parameter("machine_id") @Parameter("x") @Parameter("y") @Parameter("z") @ResultColumn("board_id") @SingleRowResult protected static final String GET_BOARD_BY_COORDS
      Get a board's ID by its coordinates.
      See Also:

    • ALLOCATE_BOARDS_BOARD

      @Parameter("job_id") @Parameter("board_id") protected static final String ALLOCATE_BOARDS_BOARD
      Tell a board that it is allocated.
      See Also:

    • DEALLOCATE_BMP_BOARDS_JOB

      @Parameter("job_id") @Parameter("bmp_id") protected static final String DEALLOCATE_BMP_BOARDS_JOB
      Tell the boards of a job that they're no longer allocated to the job.
      See Also:

    • SET_BOARD_POWER_ON

      @Parameter("board_id") protected static final String SET_BOARD_POWER_ON
      Set the power state of a board.
      See Also:

    • SET_BOARD_POWER_OFF

      @Parameter("board_id") protected static final String SET_BOARD_POWER_OFF
      Set the power state of a board.
      See Also:

    • SET_ALL_BOARDS_OFF

      protected static final String SET_ALL_BOARDS_OFF
      Set all boards to off.
      See Also:

    • FIND_EXPIRED_JOBS

      @ResultColumn("job_id") protected static final String FIND_EXPIRED_JOBS
      Find jobs that have expired their keepalive interval.
      See Also:

    • SET_STATE_PENDING

      @Parameter("job_state") @Parameter("job_id") protected static final String SET_STATE_PENDING
      Set the state for a job.
      See Also:

    • SET_STATE_DESTROYED

      @Parameter("job_id") protected static final String SET_STATE_DESTROYED
      Set the state destroyed and number of pending changes for a job.
      See Also:

    • KILL_JOB_ALLOC_TASK

      @Parameter("job_id") protected static final String KILL_JOB_ALLOC_TASK
      Delete a request to allocate resources for a job.
      See Also:

    • KILL_ALL_JOB_ALLOC_TASK

      protected static final String KILL_ALL_JOB_ALLOC_TASK
      Delete all requests to allocate resources for a job.
      See Also:

    • FINISHED_PENDING

      @Parameter("change_id") protected static final String FINISHED_PENDING
      Delete a request to change the power of a board. Used once the change has been completed.
      See Also:

    • DELETE_PENDING

      @Parameter("job_id") @Parameter("from_state") @Parameter("to_state") protected static final String DELETE_PENDING
      Delete a requests to change the power of a board. Used once the errors have been handled.
      See Also:

    • ERROR_PENDING

      @Parameter("change_id") protected static final String ERROR_PENDING
      Set a request to change the power of a board to an error.
      See Also:

    • LOAD_DIR_INFO

      @ResultColumn("z") @ResultColumn("direction") @ResultColumn("dx") @ResultColumn("dy") @ResultColumn("dz") protected static final String LOAD_DIR_INFO
      Get descriptions of how to move from a board to its neighbours.
      See Also:

    • GET_CHANGES

      @Parameter("bmp_id") @ResultColumn("change_id") @ResultColumn("job_id") @ResultColumn("board_id") @ResultColumn("power") @ResultColumn("fpga_n") @ResultColumn("fpga_s") @ResultColumn("fpga_ne") @ResultColumn("fpga_nw") @ResultColumn("fpga_se") @ResultColumn("fpga_sw") @ResultColumn("from_state") @ResultColumn("to_state") @ResultColumn("board_num") @ResultColumn("bmp_id") @ResultColumn("power_off_timestamp") protected static final String GET_CHANGES
      Get the requests to change the power of boards on a BMP.
      See Also:

    • COUNT_CHANGES_FOR_JOB

      @Parameter("job_id") @Parameter("from_state") @Parameter("to_state") @ResultColumn("n_changes") @ResultColumn("n_errors") protected static final String COUNT_CHANGES_FOR_JOB
      Get the number of changes that are not completed for a job.
      See Also:

    • INSERT_BMP

      @Parameter("machine_id") @Parameter("address") @Parameter("cabinet") @Parameter("frame") @GeneratesID protected static final String INSERT_BMP
      Insert a BMP.
      See Also:

    • INSERT_BOARD

      @Parameter("machine_id") @Parameter("address") @Parameter("bmp_id") @Parameter("board_num") @Parameter("x") @Parameter("y") @Parameter("z") @Parameter("root_x") @Parameter("root_y") @Parameter("enabled") @GeneratesID protected static final String INSERT_BOARD
      Insert a board.
      See Also:

    • INSERT_MACHINE_SPINN_5

      @Parameter("name") @Parameter("width") @Parameter("height") @Parameter("depth") @GeneratesID protected static final String INSERT_MACHINE_SPINN_5
      Insert a machine.
      See Also:

    • INSERT_TAG

      @Parameter("machine_id") @Parameter("tag") @GeneratesID protected static final String INSERT_TAG
      Insert a tag.
      See Also:

    • DELETE_MACHINE_TAGS

      @Parameter("machine_id") protected static final String DELETE_MACHINE_TAGS
      Delete all tags for a machine.
      See Also:

    • SET_MACHINE_STATE

      @Parameter("in_service") @Parameter("machine_name") protected static final String SET_MACHINE_STATE
      Set the in-service flag for a machine.
      See Also:

    • SET_MAX_COORDS

      @Parameter("max_x") @Parameter("max_y") @Parameter("machine_id") protected static final String SET_MAX_COORDS
      Note down the maximum chip coordinates so we can calculate wraparounds correctly.
      See Also:

    • FIND_BOARD_BY_ID

      @Parameter("board_id") @ResultColumn("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("address") @ResultColumn("machine_name") @ResultColumn("bmp_serial_id") @ResultColumn("physical_serial_id") @ResultColumn("bmp_id") @ResultColumn("machine_id") @SingleRowResult protected static final String FIND_BOARD_BY_ID
      Get a board's full coordinate info given it's ID.
      See Also:

    • FIND_BOARD_BY_NAME_AND_XYZ

      @Parameter("machine_name") @Parameter("x") @Parameter("y") @Parameter("z") @ResultColumn("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("address") @ResultColumn("machine_name") @ResultColumn("bmp_serial_id") @ResultColumn("physical_serial_id") @ResultColumn("bmp_id") @ResultColumn("machine_id") @SingleRowResult protected static final String FIND_BOARD_BY_NAME_AND_XYZ
      Get a board's ID given it's triad coordinates.
      See Also:

    • FIND_BOARD_BY_NAME_AND_CFB

      @Parameter("machine_name") @Parameter("cabinet") @Parameter("frame") @Parameter("board") @ResultColumn("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("address") @ResultColumn("machine_name") @ResultColumn("bmp_serial_id") @ResultColumn("physical_serial_id") @ResultColumn("bmp_id") @ResultColumn("machine_id") @SingleRowResult protected static final String FIND_BOARD_BY_NAME_AND_CFB
      Get a board's ID given it's physical coordinates.
      See Also:

    • FIND_BOARD_BY_NAME_AND_IP_ADDRESS

      @Parameter("machine_name") @Parameter("address") @ResultColumn("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("address") @ResultColumn("machine_name") @ResultColumn("bmp_serial_id") @ResultColumn("physical_serial_id") @ResultColumn("bmp_id") @ResultColumn("machine_id") @SingleRowResult protected static final String FIND_BOARD_BY_NAME_AND_IP_ADDRESS
      Get a board's ID given it's IP address.
      See Also:

    • GET_FUNCTIONING_FIELD

      @Parameter("board_id") @ResultColumn("functioning") @SingleRowResult protected static final String GET_FUNCTIONING_FIELD
      Get the value of a board's functioning column.
      See Also:

    • SET_FUNCTIONING_FIELD

      @Parameter("enabled") @Parameter("board_id") protected static final String SET_FUNCTIONING_FIELD
      Set the value of a board's functioning column. Enables or disables allocation of the board.
      See Also:

    • GET_USER_QUOTA

      @Parameter("user_name") @ResultColumn("quota_total") @ResultColumn("user_id") @SingleRowResult protected static final String GET_USER_QUOTA
      Get the quota for a user.
      See Also:

    • GET_GROUP_QUOTA

      @Parameter("group_id") @ResultColumn("quota") @SingleRowResult protected static final String GET_GROUP_QUOTA
      Get the quota for a group.
      See Also:

    • GET_CURRENT_USAGE

      @Parameter("group_id") @ResultColumn("current_usage") @SingleRowResult protected static final String GET_CURRENT_USAGE
      Get the current non-consolidated usage for a group.
      See Also:

    • GET_JOB_USAGE_AND_QUOTA

      @Parameter("job_id") @ResultColumn("quota_used") @ResultColumn("quota") @SingleRowResult protected static final String GET_JOB_USAGE_AND_QUOTA
      Get usage of a job and the quota against which that applies.
      See Also:

    • GET_CONSOLIDATION_TARGETS

      @ResultColumn("job_id") @ResultColumn("group_id") @ResultColumn("quota_used") protected static final String GET_CONSOLIDATION_TARGETS
      Get resource usage info about completed jobs that have yet to be consolidated into the main quota table.
      See Also:

    • DECREMENT_QUOTA

      @Parameter("usage") @Parameter("group_id") protected static final String DECREMENT_QUOTA
      Reduce a group's quota on a machine by a specified amount.
      See Also:

    • MARK_CONSOLIDATED

      @Parameter("job_id") protected static final String MARK_CONSOLIDATED
      Mark a job as having had its resource usage consolidated.
      See Also:

    • ADJUST_QUOTA

      @Parameter("delta") @Parameter("group_id") protected static final String ADJUST_QUOTA
      Add or remove time from a quota. Used when someone's administratively adjusting the quota.
      See Also:

    • SET_COLLAB_QUOTA

      @Parameter("new_quota") @Parameter("group_name") protected static final String SET_COLLAB_QUOTA
      Set a quota. Used when the system is aligning quota with NMPI data.
      See Also:

    • GET_USER_DETAILS

      @Parameter("user_id") @ResultColumn("user_id") @ResultColumn("user_name") @ResultColumn("has_password") @ResultColumn("trust_level") @ResultColumn("locked") @ResultColumn("disabled") @ResultColumn("last_successful_login_timestamp") @ResultColumn("last_fail_timestamp") @ResultColumn("openid_subject") @ResultColumn("is_internal") @SingleRowResult protected static final String GET_USER_DETAILS
      Get details about a user. This is pretty much everything except their password.
      See Also:

    • GET_USER_DETAILS_BY_NAME

      @Parameter("user_name") @ResultColumn("user_id") @ResultColumn("user_name") @ResultColumn("has_password") @ResultColumn("trust_level") @ResultColumn("locked") @ResultColumn("disabled") @ResultColumn("last_successful_login_timestamp") @ResultColumn("last_fail_timestamp") @ResultColumn("openid_subject") @ResultColumn("is_internal") @SingleRowResult protected static final String GET_USER_DETAILS_BY_NAME
      Get details about a user. This is pretty much everything except their password.
      See Also:

    • GET_USER_DETAILS_BY_SUBJECT

      @Parameter("openid_subject") @ResultColumn("user_id") @ResultColumn("user_name") @ResultColumn("has_password") @ResultColumn("trust_level") @ResultColumn("locked") @ResultColumn("disabled") @ResultColumn("last_successful_login_timestamp") @ResultColumn("last_fail_timestamp") @ResultColumn("openid_subject") @ResultColumn("is_internal") @SingleRowResult protected static final String GET_USER_DETAILS_BY_SUBJECT
      Get details about a user. This is pretty much everything except their password.
      See Also:

    • GET_LOCAL_USER_DETAILS

      @Parameter("user_name") @ResultColumn("user_id") @ResultColumn("user_name") @ResultColumn("encrypted_password") @SingleRowResult protected static final String GET_LOCAL_USER_DETAILS
      Get a local user's basic details.
      See Also:

    • GET_GROUP_BY_NAME_AND_MEMBER

      @Parameter("user_name") @Parameter("group_name") @ResultColumn("group_id") @SingleRowResult protected static final String GET_GROUP_BY_NAME_AND_MEMBER
      Get the ID of a particular group that a particular user must be a member of.
      See Also:

    • GET_GROUP_NAMES_OF_USER

      @Parameter("user_name") @ResultColumn("group_name") protected static final String GET_GROUP_NAMES_OF_USER
      List all the groups that a user is a member of and that have quota left.
      See Also:

    • GET_USERS_OF_GROUP

      @Parameter("group_id") @ResultColumn("membership_id") @ResultColumn("group_id") @ResultColumn("group_name") @ResultColumn("user_id") @ResultColumn("user_name") protected static final String GET_USERS_OF_GROUP
      List the members of a group.
      See Also:

    • GET_MEMBERSHIP

      @Parameter("membership_id") @ResultColumn("membership_id") @ResultColumn("user_id") @ResultColumn("group_id") @ResultColumn("user_name") @ResultColumn("group_name") @SingleRowResult protected static final String GET_MEMBERSHIP
      Get the details from a specific membership.
      See Also:

    • GET_MEMBERSHIPS_OF_USER

      @Parameter("user_id") @ResultColumn("membership_id") @ResultColumn("user_id") @ResultColumn("group_id") @ResultColumn("group_name") @ResultColumn("user_name") protected static final String GET_MEMBERSHIPS_OF_USER
      Get the memberships of a user.
      See Also:

    • CREATE_GROUP

      @Parameter("group_name") @Parameter("quota") @Parameter("group_type") @GeneratesID protected static final String CREATE_GROUP
      Create a group record.
      See Also:

    • CREATE_GROUP_IF_NOT_EXISTS

      @Parameter("group_name") @Parameter("quota") @Parameter("group_type") protected static final String CREATE_GROUP_IF_NOT_EXISTS
      Create a group record.
      See Also:

    • DELETE_GROUP

      @Parameter("group_id") @ResultColumn("group_name") @SingleRowResult protected static final String DELETE_GROUP
      Delete a single group record and returns the name of the deleted group.
      See Also:

    • UPDATE_GROUP

      @Parameter("group_name") @Parameter("quota") @Parameter("group_id") @SingleRowResult protected static final String UPDATE_GROUP
      Update a single group record's name and quota.
      See Also:

    • ADD_USER_TO_GROUP

      @Parameter("user_id") @Parameter("group_id") @GeneratesID protected static final String ADD_USER_TO_GROUP
      Adds a user to a group.
      See Also:

    • REMOVE_USER_FROM_GROUP

      @Parameter("user_id") @Parameter("group_id") protected static final String REMOVE_USER_FROM_GROUP
      Removes a user from a group.
      See Also:

    • GROUP_SYNC_MAKE_TEMP_TABLE

      protected static final String GROUP_SYNC_MAKE_TEMP_TABLE
      Step 1 of group synchronisation: make a temporary table. Should be performed in a transaction with the other group synch steps.
      See Also:

    • GROUP_SYNC_INSERT_TEMP_ROW

      @Parameter("group_name") @Parameter("group_type") protected static final String GROUP_SYNC_INSERT_TEMP_ROW
      Step 2 of group synchronisation: add a desired group to the temp table. Should be performed in a transaction with the other group synch steps. Requires that GROUP_SYNC_MAKE_TEMP_TABLE was run first and that GROUP_SYNC_DROP_TEMP_TABLE has not yet run.
      See Also:

    • GROUP_SYNC_ADD_GROUPS

      @Parameter("user_id") protected static final String GROUP_SYNC_ADD_GROUPS
      Step 3 of group synchronisation: add real missing groups. Requires the temporary table to have been set up already. Should be performed in a transaction with the other group synch steps. Requires that GROUP_SYNC_MAKE_TEMP_TABLE was run first and that GROUP_SYNC_DROP_TEMP_TABLE has not yet run.
      See Also:

    • GROUP_SYNC_REMOVE_GROUPS

      @Parameter("user_id") protected static final String GROUP_SYNC_REMOVE_GROUPS
      Step 4 of group synchronisation: remove real groups no longer wanted. Requires the temporary table to have been set up already. Should be performed in a transaction with the other group synch steps. Requires that GROUP_SYNC_MAKE_TEMP_TABLE was run first and that GROUP_SYNC_DROP_TEMP_TABLE has not yet run.
      See Also:

    • GROUP_SYNC_DROP_TEMP_TABLE

      protected static final String GROUP_SYNC_DROP_TEMP_TABLE
      Step 5 of group synchronisation: drop the temporary table. Except we don't because that doesn't work in a transaction; squelching the contents works though (the table itself is dropped automatically when the connection is dropped so we don't need to clean it up here). Should be performed in a transaction with the other group synch steps. Requires that GROUP_SYNC_MAKE_TEMP_TABLE was run first.
      See Also:

    • IS_USER_LOCKED

      @Parameter("username") @ResultColumn("user_id") @ResultColumn("locked") @ResultColumn("disabled") @SingleRowResult protected static final String IS_USER_LOCKED
      Test if a user account is locked or disabled.
      See Also:

    • GET_USER_AUTHORITIES

      @Parameter("user_id") @ResultColumn("trust_level") @ResultColumn("encrypted_password") @ResultColumn("openid_subject") @SingleRowResult protected static final String GET_USER_AUTHORITIES
      Get the permissions and encrypted password for a user.
      See Also:

    • MARK_LOGIN_SUCCESS

      @Parameter("openid_subject") @Parameter("user_id") protected static final String MARK_LOGIN_SUCCESS
      Note the login success.
      See Also:

    • MARK_LOGIN_FAILURE

      @Parameter("failure_limit") @Parameter("user_id") protected static final String MARK_LOGIN_FAILURE
      Note the login failure.
      See Also:

    • UNLOCK_LOCKED_USERS

      @Parameter("lock_interval") protected static final String UNLOCK_LOCKED_USERS
      Unlock accounts.
      See Also:

    • DELETE_USER

      @Parameter("user_id") protected static final String DELETE_USER
      Delete a user.
      See Also:

    • GET_USER_ID

      @Parameter("user_name") @ResultColumn("user_id") @SingleRowResult protected static final String GET_USER_ID
      Get the ID of a user. Used for safety checks.
      See Also:

    • SET_USER_TRUST

      @Parameter("trust") @Parameter("user_id") protected static final String SET_USER_TRUST
      Set the amount a user is trusted.
      See Also:

    • SET_USER_LOCKED

      @Parameter("locked") @Parameter("user_id") protected static final String SET_USER_LOCKED
      Set whether a user is locked. Can be used to unlock a user early.
      See Also:

    • SET_USER_DISABLED

      @Parameter("disabled") @Parameter("user_id") protected static final String SET_USER_DISABLED
      Set whether a user is administratively disabled.
      See Also:

    • SET_USER_PASS

      @Parameter("password") @Parameter("user_id") protected static final String SET_USER_PASS
      Set a user's password. Passwords are either encrypted (with bcrypt) or null to indicate that they should be using some other system (OIDC?) to authenticate them.
      See Also:

    • SET_USER_NAME

      @Parameter("user_name") @Parameter("user_id") protected static final String SET_USER_NAME
      Set a user's name.
      See Also:

    • LIST_ALL_USERS

      @ResultColumn("user_id") @ResultColumn("user_name") @ResultColumn("openid_subject") protected static final String LIST_ALL_USERS
      Get a list of all users.
      See Also:

    • LIST_ALL_USERS_OF_TYPE

      @Parameter("internal") @ResultColumn("user_id") @ResultColumn("user_name") @ResultColumn("openid_subject") protected static final String LIST_ALL_USERS_OF_TYPE
      Get a list of all users.
      See Also:

    • CREATE_USER

      @Parameter("user_name") @Parameter("encoded_password") @Parameter("trust_level") @Parameter("disabled") @Parameter("openid_subject") @GeneratesID protected static final String CREATE_USER
      Create a user. Passwords are either encrypted (with bcrypt) or null to indicate that they should be using some other system to authenticate them.
      See Also:

    • LIST_ALL_GROUPS

      @ResultColumn("group_id") @ResultColumn("group_name") @ResultColumn("quota") @ResultColumn("group_type") protected static final String LIST_ALL_GROUPS
      Get a list of all groups.
      See Also:

    • LIST_ALL_GROUPS_OF_TYPE

      @Parameter("type") @ResultColumn("group_id") @ResultColumn("group_name") @ResultColumn("quota") @ResultColumn("group_type") protected static final String LIST_ALL_GROUPS_OF_TYPE
      Get a list of all groups of a given type.
      See Also:

    • GET_GROUP_BY_ID

      @Parameter("group_id") @ResultColumn("group_id") @ResultColumn("group_name") @ResultColumn("quota") @ResultColumn("group_type") @SingleRowResult protected static final String GET_GROUP_BY_ID
      Get a group by it's ID.
      See Also:

    • GET_GROUP_BY_NAME

      @Parameter("group_name") @ResultColumn("group_id") @ResultColumn("group_name") @ResultColumn("quota") @ResultColumn("group_type") @SingleRowResult protected static final String GET_GROUP_BY_NAME
      Get a group by it's name.
      See Also:

    • INSERT_BOARD_REPORT

      @Parameter("board_id") @Parameter("job_id") @Parameter("issue") @Parameter("user_id") @GeneratesID protected static final String INSERT_BOARD_REPORT
      Create a board issue report.
      See Also:

    • DELETE_JOB_RECORD

      @Parameter("job_id") protected static final String DELETE_JOB_RECORD
      Actually delete a job record. Only called by the data tombstone-r. This is the only thing that deletes jobs from the active database.
      See Also:

    • DELETE_ALLOC_RECORD

      @Parameter("alloc_id") protected static final String DELETE_ALLOC_RECORD
      Actually delete an allocation record. Only called by the data tombstone-r. This and triggers are the only things that delete allocation records from the active database.
      See Also:

    • DELETE_NMPI_JOB

      @Parameter("nmpi_job_id") protected static final String DELETE_NMPI_JOB
      Actually delete an NMPI job record. Only called by the data tombstone-r.
      See Also:

    • DELETE_NMPI_SESSION

      @Parameter("session_id") protected static final String DELETE_NMPI_SESSION
      Actually delete an NMPI session record. Only called by the data tombstone-r.
      See Also:

    • GET_BLACKLISTED_CHIPS

      @Parameter("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("notes") protected static final String GET_BLACKLISTED_CHIPS
      Read the blacklisted chips for a board.
      See Also:

    • GET_BLACKLISTED_CORES

      @Parameter("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("p") @ResultColumn("notes") protected static final String GET_BLACKLISTED_CORES
      Read the blacklisted cores for a board.
      See Also:

    • MARK_BOARD_BLACKLIST_CHANGED

      @Parameter("board_id") protected static final String MARK_BOARD_BLACKLIST_CHANGED
      Mark a board as having had its blacklist modified.
      See Also:

    • MARK_BOARD_BLACKLIST_SYNCHED

      @Parameter("board_id") protected static final String MARK_BOARD_BLACKLIST_SYNCHED
      Mark a board as having had its blacklist synchronised with the hardware.
      See Also:

    • IS_BOARD_BLACKLIST_CURRENT

      @Parameter("board_id") @ResultColumn("current") @SingleRowResult protected static final String IS_BOARD_BLACKLIST_CURRENT
      Asks whether the blacklist model for a board is believed to be synchronised to the hardware.
      See Also:

    • ADD_BLACKLISTED_CHIP

      @Parameter("board_id") @Parameter("x") @Parameter("y") protected static final String ADD_BLACKLISTED_CHIP
      Add a chip on a board to that board's blacklist. Does not cause the blacklist to be written to anywhere. The x,y are board-local coordinates.
      See Also:

    • ADD_BLACKLISTED_CORE

      @Parameter("board_id") @Parameter("x") @Parameter("y") @Parameter("p") protected static final String ADD_BLACKLISTED_CORE
      Add a core on a board to that board's blacklist. Does not cause the blacklist to be written to anywhere. The x,y are board-local coordinates.
      See Also:

    • CLEAR_BLACKLISTED_CHIPS

      @Parameter("board_id") protected static final String CLEAR_BLACKLISTED_CHIPS
      Delete all blacklist entries for chips on a board.
      See Also:

    • CLEAR_BLACKLISTED_CORES

      @Parameter("board_id") protected static final String CLEAR_BLACKLISTED_CORES
      Delete all blacklist entries for cores on a board.
      See Also:

    • GET_BLACKLIST_WRITES

      @Parameter("bmp_id") @ResultColumn("op_id") @ResultColumn("board_id") @ResultColumn("bmp_serial_id") @ResultColumn("board_num") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("machine_id") protected static final String GET_BLACKLIST_WRITES
      Get the list of writes (to the machine) of blacklist data to perform.
      See Also:

    • GET_BLACKLIST_READS

      @Parameter("bmp_id") @ResultColumn("op_id") @ResultColumn("board_id") @ResultColumn("bmp_serial_id") @ResultColumn("board_num") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("machine_id") protected static final String GET_BLACKLIST_READS
      Get the list of reads (from the machine) of blacklist data to perform.
      See Also:

    • GET_SERIAL_INFO_REQS

      @Parameter("bmp_id") @ResultColumn("op_id") @ResultColumn("board_id") @ResultColumn("bmp_serial_id") @ResultColumn("board_num") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("machine_id") protected static final String GET_SERIAL_INFO_REQS
      Get the list of reads (from the machine) of serial data to perform.
      See Also:

    • GET_TEMP_INFO_REQS

      @Parameter("bmp_id") @ResultColumn("op_id") @ResultColumn("board_id") @ResultColumn("bmp_serial_id") @ResultColumn("board_num") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("machine_id") protected static final String GET_TEMP_INFO_REQS
      Get the list of reads (from the machine) of temperature data to perform.
      See Also:

    • SET_BOARD_SERIAL_IDS

      @Parameter("board_id") @Parameter("bmp_serial_id") @Parameter("physical_serial_id") @GeneratesID protected static final String SET_BOARD_SERIAL_IDS
      Set the BMP and physical serial IDs based on the information actually read off the machine. A bit of care is needed because we might not yet have a row for that board.
      See Also:

    • COMPLETED_BOARD_INFO_READ

      @Parameter("data") @Parameter("op_id") protected static final String COMPLETED_BOARD_INFO_READ
      Mark a read of a blacklist or ADC data as completed.
      See Also:

    • COMPLETED_BLACKLIST_WRITE

      @Parameter("op_id") protected static final String COMPLETED_BLACKLIST_WRITE
      Mark a write of a blacklist as completed.
      See Also:

    • COMPLETED_GET_SERIAL_REQ

      @Parameter("op_id") protected static final String COMPLETED_GET_SERIAL_REQ
      Mark a read of serial data as completed. (Text same as COMPLETED_BLACKLIST_WRITE for now, but logically distinct.)
      See Also:

    • FAILED_BLACKLIST_OP

      @Parameter("failure") @Parameter("op_id") protected static final String FAILED_BLACKLIST_OP
      Mark a read or write of a blacklist as failed, noting the reason.
      See Also:

    • GET_COMPLETED_BLACKLIST_OP

      @Parameter("op_id") @ResultColumn("board_id") @ResultColumn("op") @ResultColumn("data") @ResultColumn("failure") @SingleRowResult protected static final String GET_COMPLETED_BLACKLIST_OP
      Retrieve a completed request to read or write a BMP-related data for a board.
      See Also:

    • DELETE_BLACKLIST_OP

      @Parameter("op_id") protected static final String DELETE_BLACKLIST_OP
      Delete a blacklist request.
      See Also:

    • CREATE_BLACKLIST_READ

      @Parameter("board_id") @GeneratesID protected static final String CREATE_BLACKLIST_READ
      Insert a request to read a board's blacklist.
      See Also:

    • CREATE_BLACKLIST_WRITE

      @Parameter("board_id") @Parameter("blacklist") @GeneratesID protected static final String CREATE_BLACKLIST_WRITE
      Insert a request to write a board's blacklist.
      See Also:

    • CREATE_SERIAL_READ_REQ

      @Parameter("board_id") @GeneratesID protected static final String CREATE_SERIAL_READ_REQ
      Insert a request to read a board's serial information.
      See Also:

    • CREATE_TEMP_READ_REQ

      @Parameter("board_id") @GeneratesID protected static final String CREATE_TEMP_READ_REQ
      Insert a request to read a board's temperature data.
      See Also:

    • READ_HISTORICAL_ALLOCS

      @Parameter("grace_period") @ResultColumn("alloc_id") @ResultColumn("job_id") @ResultColumn("board_id") @ResultColumn("alloc_timestamp") protected static final String READ_HISTORICAL_ALLOCS
      Read historical allocations to be written to the historical data DB. Only allocations that are already completed will ever get read here.
      See Also:

    • READ_HISTORICAL_JOBS

      @Parameter("grace_period") @ResultColumn("job_id") @ResultColumn("machine_id") @ResultColumn("owner") @ResultColumn("create_timestamp") @ResultColumn("width") @ResultColumn("height") @ResultColumn("depth") @ResultColumn("allocated_root") @ResultColumn("keepalive_interval") @ResultColumn("keepalive_host") @ResultColumn("death_reason") @ResultColumn("death_timestamp") @ResultColumn("original_request") @ResultColumn("allocation_timestamp") @ResultColumn("allocation_size") @ResultColumn("machine_name") @ResultColumn("user_name") @ResultColumn("group_id") @ResultColumn("group_name") @ResultColumn("nmpi_job_id") @ResultColumn("nmpi_session_id") protected static final String READ_HISTORICAL_JOBS
      Read historical jobs to be written to the historical data DB. Only jobs that are already completed will ever get read here.
      See Also:

    • WRITE_HISTORICAL_ALLOCS

      @Parameter("alloc_id") @Parameter("job_id") @Parameter("board_id") @Parameter("allocation_timestamp") protected static final String WRITE_HISTORICAL_ALLOCS
      Write to the historical allocations database.
      See Also:

    • WRITE_HISTORICAL_JOBS

      @Parameter("job_id") @Parameter("machine_id") @Parameter("owner") @Parameter("create_timestamp") @Parameter("width") @Parameter("height") @Parameter("depth") @Parameter("root_id") @Parameter("keepalive_interval") @Parameter("keepalive_host") @Parameter("death_reason") @Parameter("death_timestamp") @Parameter("original_request") @Parameter("allocation_timestamp") @Parameter("allocation_size") @Parameter("machine_name") @Parameter("owner_name") @Parameter("group_id") @Parameter("group_name") @Parameter("nmpi_job_id") @Parameter("nmpi_session_id") protected static final String WRITE_HISTORICAL_JOBS
      Write to the historical jobs database.
      See Also:

    • SET_JOB_SESSION

      @Parameter("job_id") @Parameter("session_id") @Parameter("quota_units") protected static final String SET_JOB_SESSION
      Set the NMPI session for a Job.
      See Also:

    • SET_JOB_NMPI_JOB

      @Parameter("job_id") @Parameter("nmpi_job_id") @Parameter("quota_units") protected static final String SET_JOB_NMPI_JOB
      Set the NMPI Job for a Job.
      See Also:

    • GET_JOB_SESSION

      @Parameter("job_id") @ResultColumn("session_id") @ResultColumn("quota_units") protected static final String GET_JOB_SESSION
      Get the NMPI Session for a Job.
      See Also:

    • GET_JOB_NMPI_JOB

      @Parameter("job_id") @ResultColumn("nmpi_job_id") @ResultColumn("quota_units") protected static final String GET_JOB_NMPI_JOB
      Get the NMPI Job for a Job.
      See Also:

    • FIND_LOCATION

      @Parameter("machine_id") @Parameter("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @SingleRowResult protected static final String FIND_LOCATION
      Find an allocatable board with a specific board ID. (This will have been previously converted from some other form of board coordinates.)
      See Also:

    • CHECK_LOCATION

      @Parameter("machine_id") @Parameter("board_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @SingleRowResult protected static final String CHECK_LOCATION
      Check a board with a specific board ID is allocatable. (This will have been previously converted from some other form of board coordinates.)
      See Also:

    • findRectangle

      @Parameter("width") @Parameter("height") @Parameter("machine_id") @Parameter("max_dead_boards") @ResultColumn("id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("available") protected SQL findRectangle
      Find a rectangle of triads of boards that may be allocated. The max_dead_boards gives the amount of allowance for non-allocatable resources to be made within the rectangle.
      See Also:

    • checkRectangle

      @Parameter("width") @Parameter("height") @Parameter("machine_id") @Parameter("max_dead_boards") @ResultColumn("id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("available") protected SQL checkRectangle
      Check that a rectangle of triads of boards that may be allocated. The max_dead_boards gives the amount of allowance for non-allocatable resources to be made within the rectangle.
      See Also:

    • findRectangleAt

      @Parameter("board_id") @Parameter("width") @Parameter("height") @Parameter("machine_id") @Parameter("max_dead_boards") @ResultColumn("id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("available") @SingleRowResult protected SQL findRectangleAt
      Find a rectangle of triads of boards rooted at a specific board that may be allocated. The max_dead_boards gives the amount of allowance for non-allocatable resources to be made within the rectangle.
      See Also:

    • checkRectangleAt

      @Parameter("board_id") @Parameter("width") @Parameter("height") @Parameter("machine_id") @Parameter("max_dead_boards") @ResultColumn("id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("available") @SingleRowResult protected SQL checkRectangleAt
      Find a rectangle of triads of boards rooted at a specific board that may be allocated. The max_dead_boards gives the amount of allowance for non-allocatable resources to be made within the rectangle.
      See Also:

    • issueChangeForJob

      @Parameter("job_id") @Parameter("board_id") @Parameter("from_state") @Parameter("to_state") @Parameter("power") @Parameter("fpga_n") @Parameter("fpga_e") @Parameter("fpga_se") @Parameter("fpga_s") @Parameter("fpga_w") @Parameter("fpga_nw") @GeneratesID @Value("classpath:queries/issue_change_for_job.sql") protected Resource issueChangeForJob
      Create a request to change the power status of a board.

    • countConnected

      @Parameter("machine_id") @Parameter("x") @Parameter("y") @Parameter("width") @Parameter("height") @ResultColumn("connected_size") @SingleRowResult @Value("classpath:queries/allocation_connected.sql") protected Resource countConnected
      Count the number of connected boards (i.e., have at least one path over enabled links to the root board of the allocation) within a rectangle of triads. The triads are taken as being full depth.

      Ideally this would be part of findRectangle, but both that query and this one are entirely complicated enough already! Also, we don't expect to have this query reject many candidate allocations.

      See Also:

    • findBoardByGlobalChip

      @Parameter("machine_id") @Parameter("x") @Parameter("y") @ResultColumn("board_id") @ResultColumn("address") @ResultColumn("bmp_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("job_id") @ResultColumn("machine_name") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("chip_x") @ResultColumn("chip_y") @ResultColumn("board_chip_x") @ResultColumn("board_chip_y") @ResultColumn("job_root_chip_x") @ResultColumn("job_root_chip_y") @SingleRowResult @Value("classpath:queries/find_board_by_global_chip.sql") protected Resource findBoardByGlobalChip
      Locate a board (using a full set of coordinates) based on global chip coordinates.
      See Also:

    • findBoardByJobChip

      @Parameter("job_id") @Parameter("board_id") @Parameter("x") @Parameter("y") @ResultColumn("board_id") @ResultColumn("address") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("job_id") @ResultColumn("machine_name") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("chip_x") @ResultColumn("chip_y") @ResultColumn("board_chip_x") @ResultColumn("board_chip_y") @SingleRowResult @Value("classpath:queries/find_board_by_job_chip.sql") protected Resource findBoardByJobChip
      Locate a board (using a full set of coordinates) based on allocation-local chip coordinates.
      See Also:

    • findBoardByLogicalCoords

      @Parameter("machine_id") @Parameter("x") @Parameter("y") @Parameter("z") @ResultColumn("board_id") @ResultColumn("address") @ResultColumn("bmp_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("job_id") @ResultColumn("machine_name") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("chip_x") @ResultColumn("chip_y") @ResultColumn("board_chip_x") @ResultColumn("board_chip_y") @SingleRowResult @Value("classpath:queries/find_board_by_logical_coords.sql") protected Resource findBoardByLogicalCoords
      Locate a board (using a full set of coordinates) based on logical triad coordinates.
      See Also:

    • findBoardByPhysicalCoords

      @Parameter("machine_id") @Parameter("cabinet") @Parameter("frame") @Parameter("board") @ResultColumn("board_id") @ResultColumn("address") @ResultColumn("bmp_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("job_id") @ResultColumn("machine_name") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("chip_x") @ResultColumn("chip_y") @ResultColumn("board_chip_x") @ResultColumn("board_chip_y") @SingleRowResult @Value("classpath:queries/find_board_by_physical_coords.sql") protected Resource findBoardByPhysicalCoords
      Locate a board (using a full set of coordinates) based on physical cabinet-frame-board coordinates.
      See Also:

    • findBoardByIPAddress

      @Parameter("machine_id") @Parameter("address") @ResultColumn("board_id") @ResultColumn("address") @ResultColumn("bmp_id") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("job_id") @ResultColumn("machine_name") @ResultColumn("cabinet") @ResultColumn("frame") @ResultColumn("board_num") @ResultColumn("chip_x") @ResultColumn("chip_y") @ResultColumn("board_chip_x") @ResultColumn("board_chip_y") @SingleRowResult @Value("classpath:queries/find_board_by_ip_address.sql") protected Resource findBoardByIPAddress
      Locate a board (using a full set of coordinates) based on the IP address of its ethernet chip.
      See Also:

    • getJobsWithChanges

      @Parameter("machine_id") @ResultColumn("job_id") @Value("classpath:queries/get_jobs_with_changes.sql") protected Resource getJobsWithChanges
      Get jobs on a machine that have changes that can be processed. (A policy of how long after switching a board on or off is applied.)

    • getConnectedBoards

      @Parameter("machine_id") @Parameter("x") @Parameter("y") @Parameter("z") @Parameter("width") @Parameter("height") @Parameter("depth") @ResultColumn("board_id") @Value("classpath:queries/connected_boards_at_coords.sql") protected Resource getConnectedBoards
      Get the set of boards at some coordinates within a triad rectangle that are connected (i.e., have at least one path over enableable links) to the root board.
      See Also:

    • getAllocationTasks

      @Parameter("job_state") @ResultColumn("req_id") @ResultColumn("job_id") @ResultColumn("num_boards") @ResultColumn("width") @ResultColumn("height") @ResultColumn("board_id") @ResultColumn("machine_id") @ResultColumn("max_dead_boards") @ResultColumn("max_width") @ResultColumn("max_height") @ResultColumn("job_state") @ResultColumn("importance") @Value("classpath:queries/get_allocation_tasks.sql") protected Resource getAllocationTasks
      Get the list of allocation tasks.

    • getReportedBoards

      @Parameter("threshold") @ResultColumn("board_id") @ResultColumn("num_reports") @ResultColumn("x") @ResultColumn("y") @ResultColumn("z") @ResultColumn("address") @Value("classpath:queries/get_reported_boards.sql") protected Resource getReportedBoards
      Get enabled boards with at least as many reported problems as a given threshold.

  • Constructor Details

    • SQLQueries

      public SQLQueries()