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 AccessControl = accessControlScripts{
	CheckIfCollaborator:                    checkIfCollaboratorSQL,
	CheckIfCollaboratorByDiscussionID:      checkIfCollaboratorDiscussionIDSQL,
	CheckIfCollaboratorBySolutionID:        checkIfCollaboratorBySolutionIDSQL,
	CheckIfCollaboratorByOperationalNeedID: checkIfCollaboratorByOperationalNeedIDSQL,
}

AccessControl houses all the sql for getting data for access control from the database

var Activity = activityScripts{
	Create:        activityCreateSQL,
	GetByID:       activityGetByIDSQL,
	GetByIDLoader: activityGetByIDLoaderSQL,
}

Activity holds all the SQL scrips related to the Activity Entity

var AnalyzedAudit = analyzedAuditScripts{
	Create:                                   analyzedAuditCreate,
	CollectionGetByModelPlanIDsAndDateLoader: analyzedAuditCollectionGetByModelPlanIDsAndDateLoader,
	CollectionGetByModelPlanIDsAndDate:       analyzedAuditGetByModelPlanIDsAndDate,
	GetByDate:                                analyzedAuditGetByDate,
	GetByModelPlanIDAndDate:                  analyzedAuditGetByModelPlanIDAndDate,
}

AnalyzedAudit houses all the sql for getting data for analyzed audit from the database

var AuditChange = auditChangeScripts{

	CollectionGetByModelPlanIDAndDateRange: auditChangeCollectionGetByModelPlanIDAndDateRange,

	GetByAuditIDWithModelPlanID: auditChangeGetByAuditIDWithModelPlanID,

	GetNotTranslated: auditChangeGetNotTranslated,
}

AuditChange houses all the sql for getting data for analyzed audit from the database

var DiscussionReply = discussionReplyScripts{
	Create:                  discussionReplyCreateSQL,
	Update:                  discussionReplyUpdateSQL,
	Delete:                  discussionReplyDeleteSQL,
	GetByID:                 discussionReplyGetByID,
	GetByDiscussionIDLoader: discussionReplyGetByDiscussionIDLoaderSQL,
}

DiscussionReply houses all the sql for getting data for discussion reply from the database

var Email = emailScripts{
	SolutionSelectedDetailsGet:            solutionSelectedDetailsGet,
	DiscussionReplyToOriginatorDetailsGet: discussionReplyToOriginatorDetailsGet,
}

Email houses all the sql for getting data for email from the database

var ExistingModel = existingModelScripts{
	CollectionGet:          existingModelCollectionGetSQL,
	GetByModelPlanIDLoader: existingModelGetByModelPlanIDLoaderSQL,
	GetByID:                existingModelGetByByIDSQL,
}

ExistingModel houses all the sql for getting data for existing model from the database

var ExistingModelLink = existingModelLinkScripts{
	Merge:                              existingModelLinkMergeSQL,
	GetByID:                            existingModelLinkGetByIDSQL,
	GetByModelPlanIDAndFieldNameLoader: existingModelLinkGetByModelPlanIDAndFieldNameLoaderSQL,
	GetNamesByModelPlanIDAndFieldName:  existingModelLinkGetNamesByModelPlanIDAndFieldNameSQL,
}

ExistingModelLink houses all the sql for getting data for existing model link from the database

var ModelPlan = modelPlanScripts{
	Create:                                 modelPlanCreateSQL,
	Update:                                 modelPlanUpdateSQL,
	GetByID:                                modelPlanGetByIDSQL,
	GetByName:                              modelPlanGetByNameSQL,
	CollectionWhereArchived:                modelPlanCollectionWhereArchivedSQL,
	CollectionByCollaborator:               modelPlanCollectionByCollaboratorSQL,
	CollectionWithCRTDL:                    modelPlanCollectionWithCRTDlSQL,
	CollectionApproachingClearance:         modelPlanCollectionApproachingClearanceSQL,
	DeleteByID:                             modelPlanDeleteByID,
	GetByIDLoader:                          modelPlanGetByIDLoaderSQL,
	GetOpSolutionLastModifiedDtsByIDLoader: modelPlanPlanOpSolutionLastModifiedDtsGetByIDLoaderSQL,
	GetByOperationalSolutionKey:            modelPlanGetByOperationalSolutionKeySQL,
	CollectionWhereFavoritedByUserID:       modelPlanCollectionWhereFavoritedByUserID,
	GetTaskListStatus:                      modelPlanGetTaskListStatus,
}

ModelPlan houses all the sql for getting data for model plan from the database

var NDAAgreement = ndaAgreementScripts{
	GetByUserID: ndaAgreementGetByUserIDSQL,
	Update:      ndaAgreementUpdateSQL,
	Insert:      ndaAgreementInsertSQL,
}

NDAAgreement houses all the sql for getting data for nda agreement from the database

var OperationalNeed = operationalNeedScripts{
	CollectionByModelPlanID:       operationalNeedCollectionByModelPlanIDSQL,
	CollectionByModelPlanIDLoader: operationalNeedCollectionByModelPlanIDLOADERSQL,
	GetByModelPlanIDAndType:       operationalNeedGetByModelPlanIDAndTypeSQL,
	GetByModelPlanIDAndOtherType:  operationalNeedGetByModelPlanIDAndOtherTypeSQL,
	GetByID:                       operationalNeedGetByIDSQL,
	UpdateByID:                    operationalNeedUpdateByIDSQL,
	InsertOrUpdate:                operationalNeedInsertOrUpdateSQL,
	InsertAllPossible:             operationalNeedInsertAllPossibleSQL,
	InsertOrUpdateOther:           operationalNeedInsertOrUpdateOtherSQL,
}

OperationalNeed houses all the sql for getting data for operational need from the database

var OperationalSolution = operationalSolutionScripts{
	GetWithNumberOfSubtasksByID: operationalSolutionAndNumberOfSubtasksGetByID,
	GetByIDLOADER:               operationalSolutionGetByIDLOADER,
}

OperationalSolution holds all the SQL scrips related to the operationalSolution Entity

var OperationalSolutionSubtask = operationalSolutionSubtaskScripts{
	Create:                operationalSolutionSubtaskCreateSQL,
	GetByID:               operationalSolutionSubtaskGetByIDSQL,
	Update:                operationalSolutionSubtaskUpdateByIDSQL,
	DeleteByID:            operationalSolutionSubtaskDeleteByIDSQL,
	GetBySolutionIDLoader: operationalSolutionSubtaskGetBySolutionIDLoaderSQL,
}

OperationalSolutionSubtask houses all the sql for getting data for operational solution subtask from the database

var PlanBasics = planBasicsScripts{
	Create:                 planBasicsCreateSQL,
	Update:                 planBasicsUpdateSQL,
	GetByID:                planBasicsGetByIDSQL,
	GetByModelPlanIDLoader: planBasicsGetByModelPlanIDLoaderSQL,
	GetByModelPlanID:       planBasicsGetByModelPlanIDSQL,
}

PlanBasics houses all the sql for getting data for plan basics from the database

var PlanBeneficiaries = planBeneficiariesScripts{
	Create:                 planBeneficiariesCreateSQL,
	Update:                 planBeneficiariesUpdateSQL,
	GetByID:                planBeneficiariesGetByIDSQL,
	GetByModelPlanIDLoader: planBeneficiariesGetByModelPlanIDLoaderSQL,
}

PlanBeneficiaries houses all the sql for getting data for plan beneficiaries from the database

var PlanCR = planCRScripts{
	Create:                  planCRCreateSQL,
	Update:                  planCRUpdateSQL,
	Delete:                  planCRDeleteSQL,
	Get:                     planCRGetSQL,
	CollectionByModelPlanID: planCRCollectionByModelPlanIDSQL,
}

PlanCR houses all the sql for getting data for plan cr from the database

var PlanCollaborator = planCollaboratorScripts{
	Create:                           planCollaboratorCreateSQL,
	Update:                           planCollaboratorUpdateSQL,
	Delete:                           planCollaboratorDeleteSQL,
	GetByID:                          planCollaboratorGetByIDSQL,
	CollectionGetByIDLoader:          planCollaboratorGetByIDLoaderSQL,
	CollectionGetByModelPlanIDLoader: planCollaboratorGetByModelPlanIDLoaderSQL,
	CollectionGetByModelPlanID:       planCollaboratorGetByModelPlanIDSQL,
	GetCountByUserID:                 planCollaboratorGetCountByUserID,
}

PlanCollaborator holds all the SQL scripts related to the Plan Collaborator Entity

var PlanDiscussion = planDiscussionScripts{
	GetWithNumberOfRepliesAtTimeByID: planDiscussionAndNumberOfRepliesGetByID,
}

PlanDiscussion holds all the SQL scrips related to the PlanDiscussion Entity

var PlanDocument = planDocumentScripts{
	Create:                        planDocumentCreateSQL,
	Update:                        planDocumentUpdateSQL,
	GetByID:                       planDocumentGetByIDSQL,
	GetByModelPlanID:              planDocumentGetByModelPlanIDSQL,
	GetBySolutionID:               planDocumentsGetBySolutionIDSQL,
	GetByModelPlanIDNotRestricted: planDocumentGetByModelPlanIDNotRestrictedSQL,
	GetBySolutionIDNotRestricted:  planDocumentGetBySolutionIDNotRestrictedSQL,
	DeleteByID:                    planDocumentDeleteByIDSQL,
}

PlanDocument houses all the sql for getting data for plan document from the database

var PlanDocumentSolutionLink = planDocumentSolutionLinkScripts{
	Create:               planDocumentSolutionLinksCreateSQL,
	DeleteByIDs:          planDocumentSolutionLinkDeleteByIDsSQL,
	GetBySolutionID:      planDocumentSolutionLinksGetBySolutionIDSQL,
	GetByIDs:             planDocumentSolutionLinkGetByIDsSQL,
	NumLinksByDocumentID: planDocumentNumLinkedSolutionsSQL,
	DeleteByDocumentID:   planDocumentSolutionLinksDeleteByDocumentIDSQL,
}

PlanDocumentSolutionLink houses all the sql for getting data for plan document solution link from the database

var PlanFavorite = planFavoriteScripts{
	Create:                planFavoriteCreateSQL,
	Delete:                planFavoriteDeleteSQL,
	Get:                   planFavoriteGetSQL,
	GetCollectionByUserID: planFavoriteGetCollectionByUserIDSQL,
	GetUniqueUserIDs:      planFavoriteGetUniqueUserIDsSQL,
}

PlanFavorite houses all the sql for getting data for plan favorite from the database

var PlanGeneralCharacteristics = planGeneralCharacteristicsScripts{
	Create:                 planGeneralCharacteristicsCreateSQL,
	Update:                 planGeneralCharacteristicsUpdateSQL,
	GetByID:                planGeneralCharacteristicsGetByIDSQL,
	GetByModelPlanIDLoader: planGeneralCharacteristicsGetByModelPlanIDLoaderSQL,
}

PlanGeneralCharacteristics houses all the sql for getting data for plan general characteristics from the database

var PlanOpsEvalAndLearning = planOpsEvalAndLearningScripts{
	Create:                 planOpsEvalAndLearningCreateSQL,
	Update:                 planOpsEvalAndLearningUpdateSQL,
	GetByID:                planOpsEvalAndLearningGetByIDSQL,
	GetByModelPlanIDLoader: planOpsEvalAndLearningGetByModelPlanIDLoaderSQL,
}

PlanOpsEvalAndLearning houses all the sql for getting data for plan ops eval and learning from the database

var PlanParticipantsAndProviders = planParticipantsAndProvidersScripts{
	Create:                 planParticipantsAndProvidersCreateSQL,
	Update:                 planParticipantsAndProvidersUpdateSQL,
	GetByID:                planParticipantsAndProvidersGetByIDSQL,
	GetByModelPlanIDLoader: planParticipantsAndProvidersGetByModelPlanIDLoaderSQL,
}

PlanParticipantsAndProviders houses all the sql for getting data for plan participants and providers from the database

var PlanPayments = planPaymentsScripts{
	Create:                 planPaymentsCreateSQL,
	Update:                 planPaymentsUpdateSQL,
	GetByID:                planPaymentsGetByIDSQL,
	GetByModelPlanIDLoader: planPaymentsGetByModelPlanIDLoaderSQL,
}

PlanPayments houses all the sql for getting data for plan payments from the database

var PlanTDL = planTDLScripts{
	Create:                  planTDLCreateSQL,
	Update:                  planTDLUpdateSQL,
	Delete:                  planTDLDeleteSQL,
	Get:                     planTDLGetSQL,
	CollectionByModelPlanID: planTDLCollectionByModelPlanIDSQL,
}

PlanTDL houses all the sql for getting data for plan tdl from the database

var PossibleOperationalNeed = possibleOperationalNeedScripts{
	CollectionByModelPlanID: possibleOperationalNeedCollectionByModelPlanIDSQL,
}

PossibleOperationalNeed houses all the sql for getting data for possible operational need from the database

var PossibleOperationalSolution = possibleOperationalSolutionScripts{
	CollectionByNeedType:        possibleOperationalSolutionCollectionByNeedTypeSQL,
	CollectionGetAll:            possibleOperationalSolutionCollectionGelAllSQL,
	CollectionByOperationalNeed: possibleOperationalSolutionCollectionByOperationalNeedIDSQL,
	GetByID:                     possibleOperationalSolutionGetByIDSQL,
	GetByKey:                    possibleOperationalSolutionGetByKeySQL,
	GetByKeys:                   possibleOperationalSolutionGetByKeysSQL,
}

PossibleOperationalSolution houses all the sql for getting data for possible operational solution from the database

var PossibleOperationalSolutionContact = possibleOperationalSolutionContactScripts{
	CollectionGetByPossibleSolutionID:     possibleOperationalSolutionContactsGetByPossibleSolutionIDLOADERSQL,
	GetPrimaryContactByPossibleSolutionID: getPrimaryContactByPossibleSolutionID,
}

PossibleOperationalSolutionContact houses all the sql for getting data for possible operational solution contact from the database

var PrepareForClearance = prepareForClearanceScripts{
	GetByModelPlanID: prepareForClearanceGetByModelPlanID,
}

PrepareForClearance houses all the sql for getting data for prepare for clearance from the database

var Tag = tagScripts{
	Create:                    tagCreateSQL,
	CreateCollection:          tagCreateCollectionSQL,
	GetByTableFieldAndContent: tagGetByTableFieldAndContentIDSQL,
}

Tag houses all the sql for getting data for tag from the database

var TranslatedAudit = translatedAuditScripts{
	Create:                     translatedAuditCreateSQL,
	CollectionGetByModelPlanID: translatedAuditCollectionGetByModelPlanID,
}

TranslatedAudit holds all the SQL scrips related to the translatedAuditChange Entity

var TranslatedAuditField = translatedAuditFieldScripts{
	Create:                                 translatedAuditFieldCreateSQL,
	CollectionGetByTranslatedAuditID:       translatedAuditFieldCollectionGetByTranslatedAuditID,
	CollectionGetByTranslatedAuditIDLoader: translatedAuditFieldCollectionGetByTranslatedAuditIDLoader,
}

TranslatedAuditField holds all the SQL scrips related to the translatedAuditField Entity

var TranslatedAuditQueue = translatedAuditQueueScripts{
	Update:                   translatedAuditQueueUpdateSQL,
	GetByID:                  translatedAuditQueueGetByIDSQL,
	GetQueuedEntries:         translatedAuditQueueGetQueuedEntriesSQL,
	GetEntriesToQueue:        translatedAuditEntriesToQueueSQL,
	DANGEROUSQueueAllEntries: dangerousTranslatedAuditQueueQueueAllEntriesSQL,
}

TranslatedAuditQueue holds all the SQL scrips related to the translatedAuditQueue Entity

var UserAccount = userAccountScripts{
	GetByUsername:                          userAccountGetByUsername,
	GetByID:                                userAccountGetByID,
	GetByIDLOADER:                          userAccountGetByIDLOADER,
	InsertByUsername:                       userAccountInsertByUsername,
	UpdateByUsername:                       userAccountUpdateByUsername,
	GetNotificationPreferencesNewModelPlan: userNotificationPreferencesNewModelPlan,
	GetNotificationRecipientsDatesChanged:  userAccountGetNotificationRecipientsDatesChanged,
}

UserAccount houses all the sql for getting data for user account from the database

var UserNotification = userNotificationScripts{
	Create:                       userNotificationCreateSQL,
	CollectionGetByUserID:        userNotificationCollectionGetByUserIDSQL,
	MarksAsReadByID:              userNotificationMarkAsReadByIDSQL,
	MarkCollectionAsReadByUserID: userNotificationMarkAsReadByUserIDSQL,
}

UserNotification holds all the SQL scrips related to the userNotification Entity

var UserNotificationPreferences = userNotificationPreferencesScripts{
	Create:            userNotificationPreferencesCreateSQL,
	GetByUserID:       userNotificationPreferencesGetByUserIDSQL,
	GetByUserIDLoader: userNotificationPreferencesGetByUserIDLoaderSQL,
	Update:            userNotificationPreferencesUpdateSQL,
}

UserNotificationPreferences holds all the SQL scrips related to the userNotificationPreferences Entity

var UserViewCustomization = userViewCustomizationScripts{
	Create:      userViewCustomizationCreateSQL,
	GetByUserID: userViewCustomizationGetByUserIDSQL,
	Update:      userViewCustomizationUpdateSQL,
}

UserViewCustomization holds all the SQL scrips related to the UserViewCustomization Entity

var Utility = utilityScripts{
	SetSessionCurrentUser: setSessionCurrentUserSQL,
}

Utility houses all the sql for utility from the database