/// <summary>
/// Map datatype
/// </summary>
public string MapDatatype(SchemaPropertyType type)
{
switch (type)
{
case SchemaPropertyType.Binary:
return("blob");
case SchemaPropertyType.Boolean:
return("boolean");
case SchemaPropertyType.Date:
case SchemaPropertyType.TimeStamp:
case SchemaPropertyType.DateTime:
return("bigint");
case SchemaPropertyType.Decimal:
return("decimal");
case SchemaPropertyType.Float:
return("float");
case SchemaPropertyType.Integer:
return("integer");
case SchemaPropertyType.String:
return("varchar(128)");
case SchemaPropertyType.Uuid:
return("blob(16)");
default:
return(null);
}
}
public CustomPropertyDefinition(SchemaPropertyType type, string name, string label, int offsetPos, bool allowInput = false)
{
Type = type;
Value = name;
Text = label;
AllowInput = allowInput;
OffsetPos = offsetPos;
}
private ValidatedPropertyMetadata getValidatedPropertyMetadata
(Newtonsoft.Json.Schema.JsonSchema value, SchemaPropertyType propertyType)
{
var result = new ValidatedPropertyMetadata(propertyType);
if (value.ExclusiveMaximum.HasValue)
{
result.ExclusiveMaximum = value.ExclusiveMaximum;
}
if (value.ExclusiveMinimum.HasValue)
{
result.ExclusiveMinimum = value.ExclusiveMinimum;
}
if (value.Maximum.HasValue)
{
result.Maximum = value.Maximum;
}
if (value.MaximumLength.HasValue)
{
result.MaximumLength = value.MaximumLength;
}
if (value.Minimum.HasValue)
{
result.Minimum = value.Minimum;
}
if (value.MinimumLength.HasValue)
{
result.MinimumLength = value.MinimumLength;
}
if (!string.IsNullOrWhiteSpace(value.Pattern))
{
result.Pattern = value.Pattern;
}
if (value.Required.HasValue)
{
result.Required = value.Required;
}
return(result);
}
/// <summary>
/// Map datatype
/// </summary>
public string MapDatatype(SchemaPropertyType type)
{
switch (type)
{
case SchemaPropertyType.Binary:
return("VARBINARY");
case SchemaPropertyType.Boolean:
return("BOOLEAN");
case SchemaPropertyType.Date:
return("DATE");
case SchemaPropertyType.DateTime:
return("TIMESTAMP");
case SchemaPropertyType.TimeStamp:
return("TIMESTAMPTZ");
case SchemaPropertyType.Decimal:
return("DECIMAL");
case SchemaPropertyType.Float:
return("FLOAT");
case SchemaPropertyType.Integer:
return("INTEGER");
case SchemaPropertyType.String:
return("VARCHAR(128)");
case SchemaPropertyType.Uuid:
return("UUID");
default:
return(null);
}
}
public SimplePropertyMetadata(SchemaPropertyType type)
{
Type = type;
}
/// <summary>
/// Get the datatype
/// </summary>
public String GetDataType(SchemaPropertyType type)
{
return(this.m_provider.MapDatatype(type));
}
public ValidatedPropertyMetadata(SchemaPropertyType type)
{
Type = type;
}
