public static AdminDatasetQuery Read(SqlMapper.GridReader grid)
{
var query = grid.ReadFirstOrDefault <DatasetQueryRecord>();
if (query == null)
{
return(null);
}
var tags = grid.Read <DatasetQueryTag>();
var cons = grid.Read <DatasetQueryConstraintRecord>();
return(new AdminDatasetQuery
{
Id = query.Id,
UniversalId = DatasetQueryUrn.From(query.UniversalId),
Shape = (Shape)query.Shape,
Name = query.Name,
CategoryId = query.CategoryId,
Description = query.Description,
IsEncounterBased = query.IsEncounterBased,
SqlStatement = query.SqlStatement,
SqlFieldDate = query.SqlFieldDate,
SqlFieldValueString = query.SqlFieldValueString,
SqlFieldValueNumeric = query.SqlFieldValueNumeric,
Schema = DynamicDatasetSchemaFieldSerde.Deserialize(query.Schema),
Created = query.Created,
CreatedBy = query.CreatedBy,
Updated = query.Updated,
UpdatedBy = query.UpdatedBy,
Tags = tags.Select(t => t.Tag),
Constraints = cons.Select(c => c.Constraint())
});
}
public static AdminDatasetQuery AdminDatasetQuery(this AdminDatasetQueryDTO q)
{
if (q == null)
{
return(null);
}
return(new AdminDatasetQuery
{
Id = q.Id,
UniversalId = DatasetQueryUrn.From(q.UniversalId),
Shape = q.Shape,
Name = q.Name,
CategoryId = q.CategoryId,
Description = q.Description,
SqlStatement = q.SqlStatement,
IsEncounterBased = q.IsEncounterBased,
SqlFieldDate = q.SqlFieldDate,
SqlFieldValueString = q.SqlFieldValueString,
SqlFieldValueNumeric = q.SqlFieldValueNumeric,
Schema = q.Schema,
Created = q.Created,
CreatedBy = q.CreatedBy,
Updated = q.Updated,
UpdatedBy = q.UpdatedBy,
Tags = q.Tags,
Constraints = q.Constraints
});
}
public static AdminDatasetQuery Read(SqlMapper.GridReader grid)
{
var query = grid.ReadFirstOrDefault <DatasetQueryRecord>();
if (query == null)
{
return(null);
}
var tags = grid.Read <DatasetQueryTag>();
var cons = grid.Read <DatasetQueryConstraintRecord>();
return(new AdminDatasetQuery
{
Id = query.Id,
UniversalId = DatasetQueryUrn.From(query.UniversalId),
Shape = (Shape)query.Shape,
Name = query.Name,
CategoryId = query.CategoryId,
Description = query.Description,
SqlStatement = query.SqlStatement,
Created = query.Created,
CreatedBy = query.CreatedBy,
Updated = query.Updated,
UpdatedBy = query.UpdatedBy,
Tags = tags.Select(t => t.Tag),
Constraints = cons.Select(c => c.Constraint())
});
}
public void DatasetQueryUrn_From_DatasetQuery_Urn_Ok()
{
var urn = "urn:leaf:dataset:diabetes-a1c-agar-10x";
var curn = DatasetQueryUrn.From(urn);
Assert.Equal(urn, curn.ToString());
}
public void DatasetQueryUrn_TryParse_From_DatasetQuery_Urn_Ok()
{
var urn = "urn:leaf:dataset:diabetes-a1c-agar-10x";
var ok = DatasetQueryUrn.TryParse(urn, out var _);
Assert.True(ok);
}
public DatasetQuery DatasetQuery()
{
return(new DatasetQuery
{
Id = Id,
UniversalId = DatasetQueryUrn.From(UniversalId),
Shape = Shape,
Name = Name,
Category = Category,
Description = Description,
SqlStatement = SqlStatement
});
}
public DatasetQueryRef(string identifier, Shape shape)
{
if (Guid.TryParse(identifier, out var guid))
{
Id = guid;
}
else if (DatasetQueryUrn.TryParse(identifier, out var urn))
{
UniversalId = urn;
}
else
{
throw new FormatException($"Dataset identifier {identifier} is not a valid Guid or Urn");
}
Shape = shape;
}
public static AdminDatasetQuery AdminDatasetQuery(this AdminDatasetQueryDTO q)
{
if (q == null)
{
return(null);
}
return(new AdminDatasetQuery
{
Id = q.Id,
UniversalId = DatasetQueryUrn.From(q.UniversalId),
Shape = q.Shape,
Name = q.Name,
CategoryId = q.CategoryId,
Description = q.Description,
SqlStatement = q.SqlStatement,
Created = q.Created,
CreatedBy = q.CreatedBy,
Updated = q.Updated,
UpdatedBy = q.UpdatedBy,
Tags = q.Tags,
Constraints = q.Constraints
});
}
public void DatasetQueryUrn_From_NonDatasetQueryUrn_Should_Fail()
{
var urn = "urn:leaf:concept:diag:codeset=ICD9+code=123.42";
Assert.Throws <FormatException>(() => DatasetQueryUrn.From(urn));
}
public void DatasetQueryUrn_From_EmptyWS_Null()
{
Assert.Null(DatasetQueryUrn.From(" "));
}
public void DatasetQueryUrn_From_Null_Null()
{
Assert.Null(DatasetQueryUrn.From(null));
}
public void DatasetQueryUrn_TryParse_NonDatasetQueryUrn_False()
{
var urn = "urn:leaf:concept:diag:codeset=ICD9+code=123.42";
Assert.False(DatasetQueryUrn.TryParse(urn, out var _));
}
public void DatasetQueryUrn_TryParse_EmptyWS_False()
{
Assert.False(DatasetQueryUrn.TryParse(" ", out var _));
}
public void DatasetQueryUrn_TryParse_Null_False()
{
Assert.False(DatasetQueryUrn.TryParse(null, out var _));
}
