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

Packages that use SingleRowResult

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

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

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

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.checkRectangleAt	Find a rectangle of triads of boards rooted at a specific board that may be allocated.
protected static final String	SQLQueries.COUNT_FUNCTIONING_BOARDS	Check there is a single free board.
protected static final String	SQLQueries.COUNT_MACHINE_THINGS	Count things on a machine.
protected static final String	SQLQueries.COUNT_POWERED_BOARDS	Counts the number of powered-on boards of a job.
protected Resource	SQLQueries.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.
protected static final String	SQLQueries.DELETE_GROUP	Delete a single group record and returns the name of the deleted group.
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.findRectangleAt	Find a rectangle of triads of boards rooted at a specific board that may be allocated.
protected static final String	SQLQueries.GET_BMP_ADDRESS	Get the address of the BMP of the root board of the machine.
protected static final String	SQLQueries.GET_BOARD_ADDRESS	Get the address of the root chip of a board.
protected static final String	SQLQueries.GET_BOARD_BY_COORDS	Get a board's ID by its coordinates.
protected static final String	SQLQueries.GET_BOARD_JOB	Get What job is allocated to a board.
protected static final String	SQLQueries.GET_BOARD_POWER_INFO	Get whether a board is powered.
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_CURRENT_USAGE	Get the current non-consolidated usage for a group.
protected static final String	SQLQueries.GET_FUNCTIONING_FIELD	Get the value of a board's functioning column.
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_GROUP_BY_NAME_AND_MEMBER	Get the ID of a particular group that a particular user must be a member of.
protected static final String	SQLQueries.GET_GROUP_QUOTA	Get the quota for a group.
protected static final String	SQLQueries.GET_JOB	Get basic information about a specific job.
protected static final String	SQLQueries.GET_JOB_CHIP_DIMENSIONS	Get the chip dimensions of 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_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_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_NAMED_MACHINE	Get basic information about a specific machine.
protected static final String	SQLQueries.GET_ROOT_BMP_ADDRESS	Get the address of the BMP of the root board of the 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_SUM_BOARDS_POWERED	Get the number of boards that are allocated to a job that are switched on.
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_ID	Get the ID of a user.
protected static final String	SQLQueries.GET_USER_QUOTA	Get the quota for a user.
protected static final String	SQLQueries.IS_BOARD_BLACKLIST_CURRENT	Asks whether the blacklist model for a board is believed to be synchronised to the hardware.
protected static final String	SQLQueries.IS_USER_LOCKED	Test if a user account is locked or disabled.
protected static final String	SQLQueries.UPDATE_GROUP	Update a single group record's name and quota.