sqlqueries

README

Package sqlqueries

This package holds references to relevant SQL queries and exports variables to hold references to relevant queries, organized by relevant entity

Documentation

Index

• Variables
• type SystemIntakeGovReqFeedbackScripts

Variables

var CedarBookmarkSystemsForm = cedarBookmarkSystemScripts{
	SelectByCedarSystemIDs: selectCedarSystemBookmarkedByCedarSystemIDsSQL,
}

var GetAttendeeByEUAIDAndTRBIDSQL string

GetAttendeeByEUAIDAndTRBIDSQL holds the SQL query to get an attendee by EUA and TRB Req ID

var GetAttendeesByEUAIDsAndTRBIDsSQL string

GetAttendeesByEUAIDsAndTRBIDsSQL holds the SQL query to get a list of attendees by EUA and TRB Req IDs

var RelatedRequests = relatedRequests{
	IntakesByIntakeIDs:         relatedIntakesByIntakeIDsSQL,
	IntakesByTRBRequestIDs:     relatedIntakesByTRBRequestIDsSQL,
	TRBRequestsByIntakeIDs:     relatedTRBRequestsByIntakeIDsSQL,
	TRBRequestsByTRBRequestIDs: relatedTRBRequestsByTRBRequestIDsSQL,
}

RelatedRequests holds all relevant SQL scripts for getting related TRB Requests and System Intakes

var SystemIntake = systemIntakeScripts{
	GetByUser: getByUser,
}

var SystemIntakeActions = systemIntakeActionScripts{
	SelectBySystemIntakeID:  selectActionsBySystemIntakeIDSQL,
	SelectBySystemIntakeIDs: selectActionsBySystemIntakeIDsSQL,
}

SystemIntakeActions holds all relevant SQL scripts for System Intake Actions

var SystemIntakeBusinessCase = systemIntakeBusinessCasecripts{
	GetBusinessCaseByIntakeID:                  getBusinessCaseByIntakeIDSQL,
	GetBusinessCaseByIntakeIDs:                 getBusinessCaseByIntakeIDsSQL,
	GetEstimatedLifecycleCostLinesByBizCaseID:  getLifecycleCostsByBusinessCaseID,
	GetEstimatedLifecycleCostLinesByBizCaseIDs: getLifecycleCostsByBusinessCaseIDs,
}

SystemIntakeBusinessCase holds all relevant SQL scripts for System Intake Business Case

var SystemIntakeContractNumberForm = systemIntakeContractNumberScripts{
	Set:                     setSystemIntakeContractNumbersSQL,
	Delete:                  deleteSystemIntakeContractNumbersSQL,
	SelectBySystemIntakeIDs: selectContractNumbersBySystemIntakeIDsSQL,
}

SystemIntakeContractNumberForm holds all relevant SQL scripts for a System Intake Contract Number

var SystemIntakeDocument = systemIntakeDocumentScripts{
	Create:                           createSystemIntakeDocument,
	Delete:                           deleteSystemIntakeDocument,
	GetByDocumentID:                  getSystemIntakeDocumentByID,
	GetByS3Key:                       getSystemIntakeDocumentByS3Key,
	SelectDocumentsBySystemIntakeID:  selectDocumentsBySystemIntakeID,
	SelectDocumentsBySystemIntakeIDs: selectDocumentsBySystemIntakeIDs,
}

var SystemIntakeFundingSources = systemIntakeFundingSourcesScripts{
	GetAllBySystemIntakeIDs: getSystemIntakeFundingSourcesBySystemIntakeIDs,
	GetAllBySystemIntakeID:  getSystemIntakeFundingSourcesBySystemIntakeID,
}

SystemIntakeFundingSources holds all relevant SQL scripts for a System Intake's funding sources

var SystemIntakeGRBReviewer = systemIntakeGRBReviewerScripts{
	Create:                         insertSystemIntakeGRBReviewerSQL,
	GetBySystemIntakeID:            getSystemIntakeGRBReviewersByIntakeIDsSQL,
	GetIntakesWhereReviewRequested: getSystemIntakesWhereReviewIsRequestedSQL,
	CompareGRBReviewers:            compareSystemIntakeGRBReviewersByIntakeIDSQL,
	Update:                         updateSystemIntakeGRBReviewerByIDSQL,
	Delete:                         deleteSystemIntakeGRBReviewerByIDSQL,
}

SystemIntakeGRBReviewer holds all SQL scripts for GRB Reviewers

var SystemIntakeGovReqFeedback = SystemIntakeGovReqFeedbackScripts{
	GetBySystemIntakeID:  getSystemIntakeGovReqFeedbackByIntakeIDSQL,
	GetBySystemIntakeIDs: getSystemIntakeGovReqFeedbackByIntakeIDsSQL,
}

SystemIntakeGovReqFeedback holds all relevant SQL scripts for a System Intake Governance Request Feedback

var SystemIntakeNotes = systemIntakeNotesScripts{
	SelectBySystemIntakeID:  getSystemIntakeNotesByIntakeID,
	SelectBySystemIntakeIDs: getSystemIntakeNotesByIntakeIDs,
}

SystemIntakeNotes holds all relevant SQL scripts for a System Intake system

var SystemIntakeSystemForm = systemIntakeSystemScripts{
	Set:                     setSystemIntakeSystemsSQL,
	Delete:                  deleteSystemIntakeSystemsSQL,
	SelectByCedarSystemIDs:  systemIntakeSelectByCedarSystemIDs,
	SelectBySystemIntakeIDs: selectSystemsBySystemIntakeIDsSQL,
}

SystemIntakeSystemForm holds all relevant SQL scripts for a System Intake system

var TRBRequest = trbRequestScripts{
	Create:                              trbRequestCreateSQL,
	Update:                              trbRequestUpdateSQL,
	GetByID:                             trbRequestGetByIDSQL,
	CollectionGet:                       trbRequestCollectionGetSQL,
	CollectionGetByUserAndArchivedState: trbRequestCollectionGetByUserAndArchivedStateSQL,
}

TRBRequest holds all relevant SQL scripts for a TRB Request

var TRBRequestAdminNotes = trbAdminNotesScripts{
	GetByTRBID:  getAdminNotesByTRBReqIDSQL,
	GetByTRBIDs: getAdminNotesByTRBReqIDsSQL,
}

var TRBRequestAttendees = trbAttendeesScripts{
	GetByTRBID:                  getAttendeesByTRBReqIDSQL,
	GetByTRBIDs:                 getAttendeesByTRBReqIDsSQL,
	GetAttendeeByEUAAndTRBID:    GetAttendeeByEUAIDAndTRBIDSQL,
	GetAttendeesByEUAsAndTRBIDs: GetAttendeesByEUAIDsAndTRBIDsSQL,
}

var TRBRequestContractNumbersForm = trbRequestContractNumberScripts{
	Set:                   setTRBRequestContractNumbersSQL,
	Delete:                deleteTRBRequestContractNumbersSQL,
	SelectByTRBRequestIDs: selectContractNumbersByTRBRequestIDsSQL,
}

TRBRequestContractNumbersForm holds all relevant SQL scripts for a TRB Request Contract Number

var TRBRequestDocuments = trbRequestDocumentsScripts{
	GetByTRBID:  getTRBDocumentsByTRBIDSQL,
	GetByTRBIDs: getTRBDocumentsByTRBIDsSQL,
}

TRBRequestDocuments holds all relevant SQL scripts for a TRB Request Contract Number

var TRBRequestFeedback = trbRequestFeedbackScripts{
	GetByID:           trbRequestFeedbackGetByIDSQL,
	GetByIDs:          trbRequestFeedbackGetByIDsSQL,
	GetByNewestByID:   trbRequestFeedbackGetNewestByIDSQL,
	GetByNewestsByIDs: trbRequestFeedbackGetNewestsByIDsSQL,
}

TRBRequestFeedback holds all relevant SQL scripts for TRB Request feedback

var TRBRequestForm = trbRequestFormScripts{
	Create:   trbRequestFormCreateSQL,
	GetByID:  trbRequestFormGetByIDSQL,
	GetByIDs: trbRequestFormGetByIDsSQL,
}

TRBRequestForm holds all relevant SQL scripts for a TRB Request Form

var TRBRequestFormSystemIntakes = trbRequestSystemIntakesScripts{
	GetByTRBRequestID:  getIntakesByTRBReqID,
	GetByTRBRequestIDs: getIntakesByTRBReqIDs,
}

TRBRequestFormSystemIntakes holds all relevant SQL scripts for TRB Request Form System Intakes

var TRBRequestFundingSources = trbRequestFundingSourcesScripts{
	GetByTRBReqID:  getTRBRequestFundingSourcesByTRBIDSQL,
	GetByTRBReqIDs: getTRBRequestFundingSourcesByTRBIDsSQL,
}

TRBRequestFundingSources holds all relevant SQL scripts for a TRB Request Form

var TRBRequestGuidanceLetter = trbGuidanceLetterScripts{
	GetByTRBID:  getGuidanceLetterByTRBReqIDSQL,
	GetByTRBIDs: getGuidanceLettersByTRBReqIDsSQL,
}

var TRBRequestSystemForm = trbRequestSystemScripts{
	Set:                    setTRBRequestSystemsSQL,
	Delete:                 deleteTRBRequestSystemsSQL,
	SelectByCedarSystemIDs: trbRequestSelectByCedarSystemIDs,
	SelectByTRBRequestIDs:  selectSystemsByTRBRequestIDsSQL,
}

TRBRequestSystemForm holds all relevant SQL scripts for a TRB Request system

var UserAccount = userAccount{
	GetByUsername:   userAccountGetByUsername,
	GetByUsernames:  userAccountGetByUsernames,
	GetByCommonName: userAccountGetByCommonName,
	GetByID:         userAccountGetByID,
	GetByIDs:        userAccountGetByIDs,
	Create:          userAccountCreate,
	Update:          userAccountUpdate,
	BulkUpdate:      userAccountBulkUpdate,
}

UserAccount holds all relevant SQL queries related to a user account

Types

type SystemIntakeGovReqFeedbackScripts

type SystemIntakeGovReqFeedbackScripts struct {
	GetBySystemIntakeIDs string
	GetBySystemIntakeID  string
}