private string GeneratePostgreSQLScriptForTargetResource(SearchParam SearchParam)
{
StringBuilder sb = new StringBuilder();
if (SearchParam.TargetResourceTypeList.Count > 0)
{
StringBuilder Subsb = new StringBuilder();
foreach (var Res in SearchParam.TargetResourceTypeList)
{
string SearchParamResourceName = SearchParam.Resource;
string TargetResourceInt = Convert.ToInt32(Res.ResourceType).ToString();
string Name = SearchParam.Name;
string Query =
"INSERT INTO public.\"_SParamResource\"(" +
"\"ServiceSearchParameterId\", \"ResourceType\") " +
"SELECT " +
"sp.\"Id\", " +
$"'{TargetResourceInt}' " +
"FROM " +
"public.\"_SearchParam\" sp " +
"WHERE " +
$"sp.\"Resource\" = '{SearchParamResourceName}' and sp.\"Name\" = '{Name}'; ";
sb.AppendLine(Query);
}
}
return(sb.ToString());
}
private string GeneratePostgreSQLScriptForSearchParam(SearchParam SearchParam)
{
string Resource = SearchParam.Resource;
string Name = SearchParam.Name;
string Url = SearchParam.Url;
string Description = Pyro.DbManager.Tools.StringSupport.EscapePostgreSQL(SearchParam.Description);
string Type = Convert.ToInt32(SearchParam.Type).ToString();
string XPath = Pyro.DbManager.Tools.StringSupport.EscapePostgreSQL(SearchParam.XPath);
string Expression = Pyro.DbManager.Tools.StringSupport.EscapePostgreSQL(SearchParam.Expression);
string IsIndexed = Pyro.DbManager.Tools.StringSupport.GetBoolToByteString(SearchParam.IsIndexed);
string Status = Convert.ToInt32(SearchParam.Status).ToString();
string LastUpdated = Pyro.DbManager.Tools.StringSupport.GetPostgreSQLDateTimeOffSet(SearchParam.LastUpdated);
string SearchParameterResourceId = SearchParam.SearchParameterResourceId;
string SearchParameterResourceVersion = SearchParam.SearchParameterResourceVersion;
string Query = $"INSERT INTO public.\"_SearchParam\"(\"Resource\", \"Name\", \"Url\", \"Description\", \"Type\", \"XPath\", \"Expression\", \"IsIndexed\", \"Status\", \"LastUpdated\") " +
$"VALUES('{Resource}', '{Name}', '{Url}', '{Description}', '{Type}', '{XPath}', '{Expression}', '{IsIndexed}', '{Status}', '{LastUpdated}');";
return(Query);
}
private string GenerateMicrosoftSQLServerScriptForSearchParam(SearchParam SearchParam)
{
string Resource = SearchParam.Resource;
string Name = SearchParam.Name;
string Url = SearchParam.Url;
string Description = Pyro.DbManager.Tools.StringSupport.EscapePostgreSQL(SearchParam.Description);
string Type = Convert.ToInt32(SearchParam.Type).ToString();
string XPath = Pyro.DbManager.Tools.StringSupport.EscapePostgreSQL(SearchParam.XPath);
string Expression = Pyro.DbManager.Tools.StringSupport.EscapePostgreSQL(SearchParam.Expression);
string IsIndexed = Pyro.DbManager.Tools.StringSupport.GetBoolToByteString(SearchParam.IsIndexed);
string Status = Convert.ToInt32(SearchParam.Status).ToString();
string LastUpdated = Pyro.DbManager.Tools.StringSupport.GetPostgreSQLDateTimeOffSet(SearchParam.LastUpdated);
string SearchParameterResourceId = SearchParam.SearchParameterResourceId;
string SearchParameterResourceVersion = SearchParam.SearchParameterResourceVersion;
string Query = $"INSERT INTO [dbo].[_SearchParam] ([Resource], [Name], [Url], [Description], [Type], [XPath], [Expression], [IsIndexed], [Status], [LastUpdated]) " +
$"VALUES ('{Resource}', '{Name}', '{Url}', '{Description}', '{Type}', '{XPath}', '{Expression}', '{IsIndexed}', '{Status}', '{LastUpdated}');";
return(Query);
}
/// <summary>
/// Get the search Parameters to seed the database on database creation.
/// Only seed for Resource types 'Resource', 'Task', 'AuditEvent' and 'SearchParameter' as all others will be loaded by the server
/// start-up task Pyro.Common.PyroHealthFhirResource.Tasks.SetSearchParameterDefinitions. We must however load these three
/// now as they are required to index the search parameters for the Tasks resources and SearchParameter and AuditEvent resources loaded on start-up
/// The Task SetSearchParameterDefinitions will update these search parameters table entries with their matching Resource Id and versions
/// as the Task runs.
/// </summary>
/// <returns></returns>
private IList <SearchParam> GetServiceSearchParameterList()
{
IList <DtoServiceSearchParameter> ServiceSearchParameterList = ServiceSearchParameterFactory.FhirAPISearchParameters();
var ReturnList = new List <SearchParam>();
var LastUpdated = DateTimeOffset.Now;
foreach (var SearchParameter in ServiceSearchParameterList.Where(x =>
x.Resource == ResourceType.Resource.GetLiteral() ||
x.Resource == ResourceType.Task.GetLiteral() ||
x.Resource == ResourceType.SearchParameter.GetLiteral() ||
x.Resource == ResourceType.AuditEvent.GetLiteral()))
{
var ServiceSearchParameter = new SearchParam()
{
Name = SearchParameter.Name,
Description = SearchParameter.Description,
Expression = SearchParameter.Expression,
Resource = SearchParameter.Resource,
Type = SearchParameter.Type,
Url = SearchParameter.Url,
XPath = SearchParameter.XPath,
IsIndexed = true,
LastUpdated = LastUpdated,
Status = PublicationStatus.Active
};
if (SearchParameter.TargetResourceTypeList != null && SearchParameter.TargetResourceTypeList.Count > 0)
{
foreach (var ResourceTypeTarget in SearchParameter.TargetResourceTypeList)
{
ServiceSearchParameter.TargetResourceTypeList.Add(new SParamResource()
{
ResourceType = ResourceTypeTarget.ResourceType
});
}
}
ReturnList.Add(ServiceSearchParameter);
}
return(ReturnList);
}
private string GenerateMicrosoftSQLServerScriptForTargetResource(SearchParam SearchParam)
{
StringBuilder sb = new StringBuilder();
if (SearchParam.TargetResourceTypeList.Count > 0)
{
StringBuilder Subsb = new StringBuilder();
foreach (var Res in SearchParam.TargetResourceTypeList)
{
string SearchParamResourceName = SearchParam.Resource;
string TargetResourceInt = Convert.ToInt32(Res.ResourceType).ToString();
string Name = SearchParam.Name;
string Query =
"INSERT INTO [dbo].[_SParamResource]([ServiceSearchParameterId], [ResourceType]) " +
"VALUES ( " +
$"(SELECT Id FROM [dbo].[_SearchParam] WHERE [Resource] = '{SearchParamResourceName}' and [Name] = '{Name}'), " +
$"'{TargetResourceInt}' )";
sb.AppendLine(Query);
}
}
return(sb.ToString());
}
