public override object Invoke(object[] args)
{
MD5 md5 = MD5.Create();
byte[] bkey = md5.ComputeHash(Encoding.UTF8.GetBytes(args[0].ToString()));
return(StringTool.EncodeHex(bkey));
}
public virtual void SetByteArray(byte[] value)
{
if (value.Length == 0)
{
m_text = "''";
}
else
{
m_text = "0x" + StringTool.EncodeHex(value);
}
}
public string FormatBlob(byte[] data)
{
switch (BlobMode)
{
case DataFormatBlobMode.InfoText:
return(BlobInfo);
case DataFormatBlobMode.Base64:
return(Convert.ToBase64String(data) + "=");
case DataFormatBlobMode.Hexa:
if (HexBytesOnLine > 0)
{
return(StringTool.EncodeHex(data, HexBytesOnLine));
}
else
{
return(StringTool.EncodeHex(data));
}
}
return("");
}
public static void GetValueAsSqlLiteral(ICdlValueReader rec, out string sqldata)
{
var type = rec.GetFieldType();
if (type == TypeStorage.Null)
{
sqldata = "null";
return;
}
switch (type)
{
case TypeStorage.Boolean:
sqldata = rec.GetBoolean() ? "1" : "0";
break;
case TypeStorage.Byte:
sqldata = rec.GetByte().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.Int16:
sqldata = rec.GetInt16().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.Int32:
sqldata = rec.GetInt32().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.Int64:
sqldata = rec.GetInt64().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.SByte:
sqldata = rec.GetSByte().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.UInt16:
sqldata = rec.GetUInt16().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.UInt32:
sqldata = rec.GetUInt32().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.UInt64:
sqldata = rec.GetUInt64().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.DateTime:
sqldata = "'" + StringTool.DateTimeToIsoStringExact(rec.GetDateTime()) + "'";
break;
case TypeStorage.DateTimeEx:
sqldata = "'" + rec.GetDateTimeEx().ToStringNormalized() + "'";
break;
case TypeStorage.DateEx:
sqldata = "'" + rec.GetDateEx().ToStringNormalized() + "'";
break;
case TypeStorage.TimeEx:
sqldata = "'" + rec.GetTimeEx().ToStringNormalized() + "'";
break;
case TypeStorage.Decimal:
sqldata = rec.GetDecimal().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.Float:
sqldata = rec.GetFloat().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.Double:
sqldata = rec.GetDouble().ToString(CultureInfo.InvariantCulture);
break;
case TypeStorage.String:
sqldata = "'" + rec.GetString().Replace("'", "''") + "'";
break;
case TypeStorage.Guid:
sqldata = "'" + rec.GetGuid().ToString() + "'";
break;
case TypeStorage.ByteArray:
{
byte[] data = rec.GetByteArray();
sqldata = "X'" + StringTool.EncodeHex(data) + "'";
}
break;
//case TypeStorage.Array:
// {
// xtype = "array";
// xdata = CdlArray.ToString(rec.GetArray());
// }
// break;
default:
throw new Exception("DBSH-00166 Unsupported field type:" + type.ToString());
}
}
public void GenerateCreate(ISqlDumper dmp)
{
dmp.PutCmd("^create ^assembly %i ^from 0x%s ^with ^permission_set = ^safe", m_name, StringTool.EncodeHex(m_data));
}
public override void SetByteArray(byte[] value)
{
m_text = "X'" + StringTool.EncodeHex(value) + "'";
}