Uses of Annotation Interface
uk.ac.manchester.spinnaker.storage.ResultColumns

Packages that use ResultColumns

Package	Description
uk.ac.manchester.spinnaker.alloc.db	Database support for Spalloc server.

Uses of ResultColumns in uk.ac.manchester.spinnaker.alloc.db

Fields in uk.ac.manchester.spinnaker.alloc.db with annotations of type ResultColumns

Modifier and Type	Field	Description
protected static final String	SQLQueries.CHECK_LOCATION	Check a board with a specific board ID is allocatable.
protected SQL	SQLQueries.checkRectangle	Check that a rectangle of triads of boards that may be allocated.
protected SQL	SQLQueries.checkRectangleAt	Find a rectangle of triads of boards rooted at a specific board that may be allocated.
protected static final String	SQLQueries.COUNT_CHANGES_FOR_JOB	Get the number of changes that are not completed for a job.
protected static final String	SQLQueries.COUNT_MACHINE_THINGS	Count things on a machine.
protected static final String	SQLQueries.FIND_BOARD_BY_ID	Get a board's full coordinate info given it's ID.
protected static final String	SQLQueries.FIND_BOARD_BY_NAME_AND_CFB	Get a board's ID given it's physical coordinates.
protected static final String	SQLQueries.FIND_BOARD_BY_NAME_AND_IP_ADDRESS	Get a board's ID given it's IP address.
protected static final String	SQLQueries.FIND_BOARD_BY_NAME_AND_XYZ	Get a board's ID given it's triad coordinates.
protected static final String	SQLQueries.FIND_FREE_BOARD	Find a single free board.
protected static final String	SQLQueries.FIND_LOCATION	Find an allocatable board with a specific board ID.
protected Resource	SQLQueries.findBoardByGlobalChip	Locate a board (using a full set of coordinates) based on global chip coordinates.
protected Resource	SQLQueries.findBoardByIPAddress	Locate a board (using a full set of coordinates) based on the IP address of its ethernet chip.
protected Resource	SQLQueries.findBoardByJobChip	Locate a board (using a full set of coordinates) based on allocation-local chip coordinates.
protected Resource	SQLQueries.findBoardByLogicalCoords	Locate a board (using a full set of coordinates) based on logical triad coordinates.
protected Resource	SQLQueries.findBoardByPhysicalCoords	Locate a board (using a full set of coordinates) based on physical cabinet-frame-board coordinates.
protected SQL	SQLQueries.findRectangle	Find a rectangle of triads of boards that may be allocated.
protected SQL	SQLQueries.findRectangleAt	Find a rectangle of triads of boards rooted at a specific board that may be allocated.
protected static final String	SQLQueries.GET_ALL_BMP_BOARDS	Get all the boards of a BMP.
protected static final String	SQLQueries.GET_ALL_BMPS	Get all the BMPs.
protected static final String	SQLQueries.GET_ALL_BOARDS	Get all the boards (and related info) of a machine.
protected static final String	SQLQueries.GET_ALL_BOARDS_OF_ALL_MACHINES	Get all the boards (and related info) known to the service.
protected static final String	SQLQueries.GET_ALL_MACHINES	Get basic information about all machines.
protected static final String	SQLQueries.GET_BLACKLIST_READS	Get the list of reads (from the machine) of blacklist data to perform.
protected static final String	SQLQueries.GET_BLACKLIST_WRITES	Get the list of writes (to the machine) of blacklist data to perform.
protected static final String	SQLQueries.GET_BLACKLISTED_CHIPS	Read the blacklisted chips for a board.
protected static final String	SQLQueries.GET_BLACKLISTED_CORES	Read the blacklisted cores for a board.
protected static final String	SQLQueries.GET_BLACKLISTED_LINKS	Read the blacklisted links for a board.
protected static final String	SQLQueries.GET_BOARD_CONNECT_INFO	Get connection info for board allocated to a job.
protected static final String	SQLQueries.GET_BOARD_POWER_INFO	Get whether a board is powered.
protected static final String	SQLQueries.GET_BOARD_REPORTS	Get the problem reports about a board.
protected static final String	SQLQueries.GET_CHANGES	Get the requests to change the power of boards on a BMP.
protected static final String	SQLQueries.GET_COMPLETED_BLACKLIST_OP	Retrieve a completed request to read or write a BMP-related data for a board.
protected static final String	SQLQueries.GET_CONSOLIDATION_TARGETS	Get resource usage info about completed jobs that have yet to be consolidated into the main quota table.
protected static final String	SQLQueries.GET_DEAD_BOARDS	Get the boards (and related info) of a machine that have been disabled.
protected static final String	SQLQueries.GET_GROUP_BY_ID	Get a group by it's ID.
protected static final String	SQLQueries.GET_GROUP_BY_NAME	Get a group by it's name.
protected static final String	SQLQueries.GET_JOB	Get basic information about a specific job.
protected static final String	SQLQueries.GET_JOB_BOARD_COORDS	Get the coords of boards assigned to a job.
protected static final String	SQLQueries.GET_JOB_BOARDS	Get what boards are allocated to a job.
protected static final String	SQLQueries.GET_JOB_CHIP_DIMENSIONS	Get the chip dimensions of a job.
protected static final String	SQLQueries.GET_JOB_IDS	Get basic information about jobs.
protected static final String	SQLQueries.GET_JOB_NMPI_JOB	Get the NMPI Job for a Job.
protected static final String	SQLQueries.GET_JOB_SESSION	Get the NMPI Session for a Job.
protected static final String	SQLQueries.GET_JOB_USAGE_AND_QUOTA	Get usage of a job and the quota against which that applies.
protected static final String	SQLQueries.GET_LIVE_BOARDS	Get the boards (and related info) of a machine that are in service.
protected static final String	SQLQueries.GET_LIVE_JOB_IDS	Get basic information about live jobs.
protected static final String	SQLQueries.GET_LOCAL_USER_DETAILS	Get a local user's basic details.
protected static final String	SQLQueries.GET_MACHINE_BY_ID	Get basic information about a specific machine.
protected static final String	SQLQueries.GET_MACHINE_JOBS	Get basic info about active jobs on a machine.
protected static final String	SQLQueries.GET_MACHINE_REPORTS	Get the problem reports about boards in a machine.
protected static final String	SQLQueries.GET_MACHINE_WRAPS	Get whether a machine wraps in horizontal or vertical directions.
protected static final String	SQLQueries.GET_MEMBERSHIP	Get the details from a specific membership.
protected static final String	SQLQueries.GET_MEMBERSHIPS_OF_USER	Get the memberships of a user.
protected static final String	SQLQueries.GET_NAMED_MACHINE	Get basic information about a specific machine.
protected static final String	SQLQueries.GET_ROOT_COORDS	Get the coordinates of a board.
protected static final String	SQLQueries.GET_ROOT_OF_BOARD	Get the coordinates of the root chip of a board.
protected static final String	SQLQueries.GET_SERIAL_INFO_REQS	Get the list of reads (from the machine) of serial data to perform.
protected static final String	SQLQueries.GET_TEMP_INFO_REQS	Get the list of reads (from the machine) of temperature data to perform.
protected static final String	SQLQueries.GET_USER_AUTHORITIES	Get the permissions and encrypted password for a user.
protected static final String	SQLQueries.GET_USER_DETAILS	Get details about a user.
protected static final String	SQLQueries.GET_USER_DETAILS_BY_NAME	Get details about a user.
protected static final String	SQLQueries.GET_USER_DETAILS_BY_SUBJECT	Get details about a user.
protected static final String	SQLQueries.GET_USER_QUOTA	Get the quota for a user.
protected static final String	SQLQueries.GET_USERS_OF_GROUP	List the members of a group.
protected Resource	SQLQueries.getAllocationTasks	Get the list of allocation tasks.
protected Resource	SQLQueries.getDeadLinks	Get the links of a machine that have been disabled.
protected Resource	SQLQueries.getPerimeterLinks	Get the links on the perimeter of the allocation to a job.
protected Resource	SQLQueries.getReportedBoards	Get enabled boards with at least as many reported problems as a given threshold.
protected static final String	SQLQueries.IS_USER_LOCKED	Test if a user account is locked or disabled.
protected static final String	SQLQueries.LIST_ALL_GROUPS	Get a list of all groups.
protected static final String	SQLQueries.LIST_ALL_GROUPS_OF_TYPE	Get a list of all groups of a given type.
protected static final String	SQLQueries.LIST_ALL_USERS	Get a list of all users.
protected static final String	SQLQueries.LIST_ALL_USERS_OF_TYPE	Get a list of all users.
protected static final String	SQLQueries.LIST_LIVE_JOBS	Gets information about live jobs.
protected static final String	SQLQueries.LIST_MACHINE_NAMES	Get the machine names in alphabetical order.
protected static final String	SQLQueries.LOAD_DIR_INFO	Get descriptions of how to move from a board to its neighbours.
protected static final String	SQLQueries.READ_HISTORICAL_ALLOCS	Read historical allocations to be written to the historical data DB.
protected static final String	SQLQueries.READ_HISTORICAL_JOBS	Read historical jobs to be written to the historical data DB.