sqlqueries

Documentation

Overview

Package sqlqueries holds references to relevant SQL queries it exports variables to hold references to relevant queries, organized by relevant entity it's sole responsibility is embedding sql queries for use by other modules which use these queries to interact with the database

Index

• Variables

Variables

var CedarBookmarkSystemsForm = cedarBookmarkSystemScripts{
	SelectLOADER: selectCedarBookmarkedSCEDARystemsLOADERSQL,
}

var SystemIntakeContractNumberForm = systemIntakeContractNumberScripts{
	Set:                          setSystemIntakeContractNumbersSQL,
	Delete:                       deleteSystemIntakeContractNumbersSQL,
	SelectBySystemIntakeIDLOADER: selectContractNumbersBySystemIntakeIDLOADERSQL,
}

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

var SystemIntakeSystemForm = systemIntakeSystemScripts{
	Set:                          setSystemIntakeSystemsSQL,
	Delete:                       deleteSystemIntakeSystemsSQL,
	SelectBySystemIntakeIDLOADER: selectSystemsBySystemIntakeIDLOADERSQL,
}

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 TRBRequestContractNumbersForm = trbRequestContractNumberScripts{
	Set:                        setTRBRequestContractNumbersSQL,
	Delete:                     deleteTRBRequestContractNumbersSQL,
	SelectByTRBRequestIDLOADER: selectContractNumbersByTRBRequestIDLOADERSQL,
}

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

var TRBRequestForm = trbRequestFormScripts{
	Create: trbRequestFormCreateSQL,
}

TRBRequestForm holds all relevant SQL scripts for a TRB Request Form

var TRBRequestSystemForm = trbRequestSystemScripts{
	Set:                        setTRBRequestSystemsSQL,
	Delete:                     deleteTRBRequestSystemsSQL,
	SelectByTRBRequestIDLOADER: selectSystemsByTRBRequestIDLOADERSQL,
}

TRBRequestSystemForm holds all relevant SQL scripts for a TRB Request system

var UserAccount = userAccount{
	GetByUsername:    userAccountGetByUsername,
	GetByCommonName:  userAccountGetByCommonName,
	GetByID:          userAccountGetByID,
	GetByIDLoader:    userAccountGetByIDLOADER,
	Create:           userAccountCreate,
	UpdateByUsername: userAccountUpdateByUsername,
}

UserAccount holds all relevant SQL queries related to a user account