public void SavesUnsupportedTypes()
{
UnsupportedTypes item = null;
var serializer = new BlobSerializerDelegate(
obj =>
{
if (obj is DateTimeOffset)
{
Assert.AreEqual(item.DateTimeOffset, obj);
var offset = (DateTimeOffset)obj;
var bytes = new byte[16];
Buffer.BlockCopy(BitConverter.GetBytes(offset.Ticks), 0, bytes, 0, 8);
Buffer.BlockCopy(BitConverter.GetBytes(offset.Offset.Ticks), 0, bytes, 8, 8);
return(bytes);
}
throw new InvalidOperationException(string.Format("Type {0} should not be requested.", obj.GetType()));
},
(d, t) =>
{
if (t == typeof(DateTimeOffset))
{
var ticks = BitConverter.ToInt64(d, 0);
var offset = BitConverter.ToInt64(d, 8);
return(new DateTimeOffset(ticks, TimeSpan.FromTicks(offset)));
}
if (t == typeof(TimeSpan))
{
return(TimeSpan.FromTicks(BitConverter.ToInt64(d, 0)));
}
throw new InvalidOperationException(string.Format("Type {0} should not be requested.", t));
},
t => true);
using (var db = new BlobDatabase(serializer))
{
db.CreateTable <UnsupportedTypes>();
item = new UnsupportedTypes()
{
Id = Guid.NewGuid(),
DateTimeOffset = DateTime.Now
};
db.Insert(item);
var dbItem = db.Find <UnsupportedTypes>(item.Id);
Assert.AreEqual(item.Id, dbItem.Id);
Assert.AreEqual(item.DateTimeOffset, dbItem.DateTimeOffset);
}
}
public void SavesUnsupportedTypes()
{
UnsupportedTypes item = null;
var serializer = new BlobSerializerDelegate(
obj =>
{
if (obj is DivideByZeroException)
{
var e = (DivideByZeroException)obj;
var json = JsonConvert.SerializeObject(e); // subst your own serializer
return(Encoding.UTF8.GetBytes(json));
}
throw new InvalidOperationException(string.Format("Type {0} should not be requested.", obj.GetType()));
},
(d, t) =>
{
if (t == typeof(DivideByZeroException))
{
var json = Encoding.UTF8.GetString(d);
var result = JsonConvert.DeserializeObject <DivideByZeroException>(json);
return(result);
}
throw new InvalidOperationException(string.Format("Type {0} should not be requested.", t));
},
t => true);
using (var db = new BlobDatabase(serializer))
{
db.CreateTable <UnsupportedTypes>();
item = new UnsupportedTypes()
{
Id = Guid.NewGuid(),
DateTimeOffset = DateTime.Now,
DivideByZeroException = new DivideByZeroException("a message")
};
db.Insert(item);
var dbItem = db.Find <UnsupportedTypes>(item.Id);
Assert.AreEqual(item.Id, dbItem.Id);
Assert.AreEqual(item.DateTimeOffset, dbItem.DateTimeOffset);
//most db stores datetimeoffset as utc, forgetting the offset part. This one is not an exception.
//TODO: test fails
Assert.AreEqual(item.DateTimeOffset.Offset, dbItem.DateTimeOffset.Offset);
//TODO: test fails
Assert.AreEqual(item.DivideByZeroException.Message, dbItem.DivideByZeroException.Message);
}
}
public void SavesUnsupportedTypes()
{
UnsupportedTypes item = null;
var serializer = new BlobSerializerDelegate(
obj =>
{
if (obj is DivideByZeroException)
{
var e = (DivideByZeroException)obj;
var json = JsonConvert.SerializeObject(e); // subst your own serializer
return(Encoding.UTF8.GetBytes(json));
}
throw new InvalidOperationException(string.Format("Type {0} should not be requested.", obj.GetType()));
},
(d, t) =>
{
if (t == typeof(DivideByZeroException))
{
#if __WINRT__ || WINDOWS_PHONE
var json = Encoding.UTF8.GetString(d, 0, d.Length);
#else
var json = Encoding.UTF8.GetString(d);
#endif
var result = JsonConvert.DeserializeObject <DivideByZeroException>(json);
return(result);
}
throw new InvalidOperationException(string.Format("Type {0} should not be requested.", t));
},
t => true);
using (var db = new BlobDatabase(serializer))
{
db.CreateTable <UnsupportedTypes>();
item = new UnsupportedTypes()
{
Id = Guid.NewGuid(),
DateTimeOffset = DateTime.Now,
DivideByZeroException = new DivideByZeroException("a message")
};
db.Insert(item);
var dbItem = db.Find <UnsupportedTypes>(item.Id);
Assert.AreEqual(item.Id, dbItem.Id);
Assert.AreEqual(item.DateTimeOffset, dbItem.DateTimeOffset);
Assert.AreEqual(item.DivideByZeroException.Message, dbItem.DivideByZeroException.Message);
}
}
internal ColumnType GetColumnType(string dataType, string columnDefault)
{
try
{
ColumnType columnType = null;
if (!string.IsNullOrEmpty(columnDefault))
{
columnType = this.ColumnTypes.FirstOrDefault(c => c.TypeName == dataType);
}
if (columnType == null)
{
columnType = this.ColumnTypes.First(c => c.TypeName == dataType);
}
return(columnType);
}
catch (InvalidOperationException)
{
if (!UnsupportedTypes.Contains(dataType))
{
this.UnsupportedTypes.Add(dataType);
}
return(this.ColumnTypes.First(c => c.DataType == DataType.Text));
}
}
