internal static void BindParameter(IntPtr stmt, int index, object value, bool storeDateTimeAsTicks)
{
if (value == null)
{
SQLite3.BindNull(stmt, index);
}
else if (value is int)
{
SQLite3.BindInt(stmt, index, (int)value);
}
else if (value is string)
{
SQLite3.BindText(stmt, index, (string)value, -1, NegativePointer);
}
else if (value is byte || value is ushort || value is sbyte || value is short)
{
SQLite3.BindInt(stmt, index, Convert.ToInt32(value));
}
else if (value is bool)
{
SQLite3.BindInt(stmt, index, ((bool)value) ? 1 : 0);
}
else if (value is uint || value is long)
{
SQLite3.BindInt64(stmt, index, Convert.ToInt64(value));
}
else if (value is float || value is double || value is decimal)
{
SQLite3.BindDouble(stmt, index, Convert.ToDouble(value));
}
else if (value is TimeSpan)
{
SQLite3.BindInt64(stmt, index, ((TimeSpan)value).Ticks);
}
else if (value is DateTime)
{
if (storeDateTimeAsTicks)
{
SQLite3.BindInt64(stmt, index, ((DateTime)value).Ticks);
}
else
{
SQLite3.BindText(stmt, index, ((DateTime)value).ToString("yyyy-MM-dd HH:mm:ss"), -1, NegativePointer);
}
}
else if (value is DateTimeOffset)
{
SQLite3.BindInt64(stmt, index, ((DateTimeOffset)value).UtcTicks);
}
else if (value.GetType().IsEnum)
{
SQLite3.BindInt(stmt, index, Convert.ToInt32(value));
}
else if (value is byte[])
{
SQLite3.BindBlob(stmt, index, (byte[])value, ((byte[])value).Length, NegativePointer);
}
else
{
if (!(value is Guid))
{
throw new NotSupportedException("Cannot store type: " + value.GetType());
}
SQLite3.BindText(stmt, index, ((Guid)value).ToString(), 72, NegativePointer);
}
}
private static void BindParameter(Sqlite3Statement stmt, int index, object value, bool storeDateTimeAsTicks)
{
if (value == null)
{
SQLite3.BindNull(stmt, index);
}
else
{
if (value is Int32)
{
SQLite3.BindInt32(stmt, index, (int)value);
}
else if (value is String)
{
SQLite3.BindStringUTF8(stmt, index, (string)value, -1, NegativePointer);
}
else if (value is Byte || value is UInt16 || value is SByte || value is Int16)
{
SQLite3.BindInt32(stmt, index, Convert.ToInt32(value));
}
else if (value is Boolean)
{
SQLite3.BindInt32(stmt, index, (bool)value ? 1 : 0);
}
else if (value is UInt32 || value is Int64)
{
SQLite3.BindInt64(stmt, index, Convert.ToInt64(value));
}
else if (value is Single || value is Double || value is Decimal)
{
SQLite3.BindDouble(stmt, index, Convert.ToDouble(value));
}
else if (value is TimeSpan)
{
SQLite3.BindInt64(stmt, index, ((TimeSpan)value).Ticks);
}
else if (value is DateTime)
{
if (storeDateTimeAsTicks)
{
SQLite3.BindInt64(stmt, index, ((DateTime)value).Ticks);
}
else
{
SQLite3.BindStringUTF8(stmt, index, ((DateTime)value).ToString(DateTimeExactStoreFormat, System.Globalization.CultureInfo.InvariantCulture), -1, NegativePointer);
}
}
else if (value is DateTimeOffset)
{
SQLite3.BindInt64(stmt, index, ((DateTimeOffset)value).UtcTicks);
}
else if (value is byte[])
{
SQLite3.BindBlob(stmt, index, (byte[])value, ((byte[])value).Length, NegativePointer);
}
else if (value is Guid)
{
SQLite3.BindStringUTF8(stmt, index, ((Guid)value).ToString(), 72, NegativePointer);
}
else if (value is Uri)
{
SQLite3.BindStringUTF8(stmt, index, ((Uri)value).ToString(), -1, NegativePointer);
}
else if (value is StringBuilder)
{
SQLite3.BindStringUTF8(stmt, index, ((StringBuilder)value).ToString(), -1, NegativePointer);
}
else if (value is UriBuilder)
{
SQLite3.BindStringUTF8(stmt, index, ((UriBuilder)value).ToString(), -1, NegativePointer);
}
else
{
// Now we could possibly get an enum, retrieve cached info
var valueType = value.GetType();
var enumInfo = EnumCache.GetInfo(valueType);
if (enumInfo.IsEnum)
{
var enumIntValue = Convert.ToInt32(value);
if (enumInfo.StoreAsText)
{
SQLite3.BindStringUTF8(stmt, index, enumInfo.GetEnumFromInt32Value(enumIntValue).ToString(), -1, NegativePointer);
}
else
{
SQLite3.BindInt32(stmt, index, enumIntValue);
}
}
else
{
var type = value.GetType();
throw new NotSupportedException("Cannot store type: " + type);
}
}
}
}
private static void RegisterDefaultTypes()
{
#if UNITY_STANDALONE
Register(
typeof(Vector2),
(stmt, index) =>
{
var bytes = SQLite3.ColumnByteArray(stmt, index);
var x = BitConverter.ToSingle(bytes, 0);
var y = BitConverter.ToSingle(bytes, sizeof(float));
return(new Vector2(x, y));
},
(c) =>
{
return("blob");
},
(stmt, index, value) =>
{
var vec = (Vector2)value;
var bytes = new byte[sizeof(float) * 2];
Buffer.BlockCopy(BitConverter.GetBytes(vec.x), 0, bytes, 0, sizeof(float));
Buffer.BlockCopy(BitConverter.GetBytes(vec.y), 0, bytes, sizeof(float), sizeof(float));
SQLite3.BindBlob(stmt, index, bytes, bytes.Length, new System.IntPtr(-1));
});
Register(
typeof(Vector3),
(stmt, index) =>
{
var bytes = SQLite3.ColumnByteArray(stmt, index);
var x = BitConverter.ToSingle(bytes, 0);
var y = BitConverter.ToSingle(bytes, sizeof(float));
var z = BitConverter.ToSingle(bytes, sizeof(float) * 2);
return(new Vector3(x, y, z));
},
(c) =>
{
return("blob");
},
(stmt, index, value) =>
{
var vec = (Vector3)value;
var bytes = new byte[sizeof(float) * 3];
Buffer.BlockCopy(BitConverter.GetBytes(vec.x), 0, bytes, 0, sizeof(float));
Buffer.BlockCopy(BitConverter.GetBytes(vec.y), 0, bytes, sizeof(float), sizeof(float));
Buffer.BlockCopy(BitConverter.GetBytes(vec.z), 0, bytes, sizeof(float) * 2, sizeof(float));
SQLite3.BindBlob(stmt, index, bytes, bytes.Length, new System.IntPtr(-1));
});
Register(
typeof(Color),
(stmt, index) =>
{
var bytes = SQLite3.ColumnByteArray(stmt, index);
var r = BitConverter.ToSingle(bytes, 0);
var g = BitConverter.ToSingle(bytes, sizeof(float));
var b = BitConverter.ToSingle(bytes, sizeof(float) * 2);
var a = BitConverter.ToSingle(bytes, sizeof(float) * 3);
return(new Color(r, g, b, a));
},
(c) =>
{
return("blob");
},
(stmt, index, value) =>
{
var vec = (Color)value;
var bytes = new byte[sizeof(float) * 4];
Buffer.BlockCopy(BitConverter.GetBytes(vec.r), 0, bytes, 0, sizeof(float));
Buffer.BlockCopy(BitConverter.GetBytes(vec.g), 0, bytes, sizeof(float), sizeof(float));
Buffer.BlockCopy(BitConverter.GetBytes(vec.b), 0, bytes, sizeof(float) * 2, sizeof(float));
Buffer.BlockCopy(BitConverter.GetBytes(vec.a), 0, bytes, sizeof(float) * 3, sizeof(float));
SQLite3.BindBlob(stmt, index, bytes, bytes.Length, new System.IntPtr(-1));
});
#endif
}