private object ReadCol(sqlite3_stmt stmt, int index, SQLite3.ColType type, Type clrType)
{
if (type == SQLite3.ColType.Null)
{
return(null);
}
else
{
var clrTypeInfo = clrType.GetTypeInfo();
if (clrTypeInfo.IsGenericType && clrTypeInfo.GetGenericTypeDefinition() == typeof(Nullable <>))
{
clrType = clrTypeInfo.GenericTypeArguments[0];
clrTypeInfo = clrType.GetTypeInfo();
}
if (clrType == typeof(String))
{
return(SQLite3.ColumnString(stmt, index));
}
else if (clrType == typeof(Int32))
{
return((int)SQLite3.ColumnInt(stmt, index));
}
else if (clrType == typeof(Boolean))
{
return(SQLite3.ColumnInt(stmt, index) == 1);
}
else if (clrType == typeof(double))
{
return(SQLite3.ColumnDouble(stmt, index));
}
else if (clrType == typeof(float))
{
return((float)SQLite3.ColumnDouble(stmt, index));
}
else if (clrType == typeof(TimeSpan))
{
if (_conn.StoreTimeSpanAsTicks)
{
return(new TimeSpan(SQLite3.ColumnInt64(stmt, index)));
}
else
{
var text = SQLite3.ColumnString(stmt, index);
TimeSpan resultTime;
if (!TimeSpan.TryParseExact(text, "c", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.TimeSpanStyles.None, out resultTime))
{
resultTime = TimeSpan.Parse(text);
}
return(resultTime);
}
}
else if (clrType == typeof(DateTime))
{
if (_conn.StoreDateTimeAsTicks)
{
return(new DateTime(SQLite3.ColumnInt64(stmt, index)));
}
else
{
var text = SQLite3.ColumnString(stmt, index);
DateTime resultDate;
if (!DateTime.TryParseExact(text, _conn.DateTimeStringFormat, System.Globalization.CultureInfo.InvariantCulture, _conn.DateTimeStyle, out resultDate))
{
resultDate = DateTime.Parse(text);
}
return(resultDate);
}
}
else if (clrType == typeof(DateTimeOffset))
{
return(new DateTimeOffset(SQLite3.ColumnInt64(stmt, index), TimeSpan.Zero));
}
else if (clrTypeInfo.IsEnum)
{
if (type == SQLite3.ColType.Text)
{
var value = SQLite3.ColumnString(stmt, index);
return(Enum.Parse(clrType, value.ToString(), true));
}
else
{
return(SQLite3.ColumnInt(stmt, index));
}
}
else if (clrType == typeof(Int64))
{
return(SQLite3.ColumnInt64(stmt, index));
}
else if (clrType == typeof(UInt32))
{
return((uint)SQLite3.ColumnInt64(stmt, index));
}
else if (clrType == typeof(decimal))
{
return((decimal)SQLite3.ColumnDouble(stmt, index));
}
else if (clrType == typeof(Byte))
{
return((byte)SQLite3.ColumnInt(stmt, index));
}
else if (clrType == typeof(UInt16))
{
return((ushort)SQLite3.ColumnInt(stmt, index));
}
else if (clrType == typeof(Int16))
{
return((short)SQLite3.ColumnInt(stmt, index));
}
else if (clrType == typeof(sbyte))
{
return((sbyte)SQLite3.ColumnInt(stmt, index));
}
else if (clrType == typeof(byte[]))
{
return(SQLite3.ColumnByteArray(stmt, index));
}
else if (clrType == typeof(Guid))
{
var text = SQLite3.ColumnString(stmt, index);
return(new Guid(text));
}
else if (clrType == typeof(Uri))
{
var text = SQLite3.ColumnString(stmt, index);
return(new Uri(text));
}
else if (clrType == typeof(StringBuilder))
{
var text = SQLite3.ColumnString(stmt, index);
return(new StringBuilder(text));
}
else if (clrType == typeof(UriBuilder))
{
var text = SQLite3.ColumnString(stmt, index);
return(new UriBuilder(text));
}
else
{
throw new NotSupportedException("Don't know how to read " + clrType);
}
}
}
/// <summary>
/// Creates a delegate that can be used to quickly set object members from query columns.
///
/// Note that this frontloads the slow reflection-based type checking for columns to only happen once at the beginning of a query,
/// and then afterwards each row of the query can invoke the delegate returned by this function to get much better performance (up to 10x speed boost, depending on query size and platform).
/// </summary>
/// <typeparam name="T">The type of the destination object that the query will read into</typeparam>
/// <param name="conn">The active connection. Note that this is primarily needed in order to read preferences regarding how certain data types (such as TimeSpan / DateTime) should be encoded in the database.</param>
/// <param name="column">The table mapping used to map the statement column to a member of the destination object type</param>
/// <returns>
/// A delegate for fast-setting of object members from statement columns.
///
/// If no fast setter is available for the requested column (enums in particular cause headache), then this function returns null.
/// </returns>
internal static Action <T, sqlite3_stmt, int> GetFastSetter <T>(SQLiteConnection conn, Column column)
{
Action <T, sqlite3_stmt, int> fastSetter = null;
if (column.PropertyInfo is null)
{
return(null);
}
Type clrType = column.PropertyInfo.PropertyType;
var clrTypeInfo = clrType.GetTypeInfo();
if (clrTypeInfo.IsGenericType && clrTypeInfo.GetGenericTypeDefinition() == typeof(Nullable <>))
{
clrType = clrTypeInfo.GenericTypeArguments[0];
clrTypeInfo = clrType.GetTypeInfo();
}
if (clrType == typeof(String))
{
fastSetter = CreateTypedSetterDelegate <T, string>(column, (stmt, index) =>
{
return(SQLite3.ColumnString(stmt, index));
});
}
else if (clrType == typeof(Int32))
{
fastSetter = CreateNullableTypedSetterDelegate <T, int>(column, (stmt, index) =>
{
return(SQLite3.ColumnInt(stmt, index));
});
}
else if (clrType == typeof(Boolean))
{
fastSetter = CreateNullableTypedSetterDelegate <T, bool>(column, (stmt, index) =>
{
return(SQLite3.ColumnInt(stmt, index) == 1);
});
}
else if (clrType == typeof(double))
{
fastSetter = CreateNullableTypedSetterDelegate <T, double>(column, (stmt, index) =>
{
return(SQLite3.ColumnDouble(stmt, index));
});
}
else if (clrType == typeof(float))
{
fastSetter = CreateNullableTypedSetterDelegate <T, float>(column, (stmt, index) =>
{
return((float)SQLite3.ColumnDouble(stmt, index));
});
}
else if (clrType == typeof(TimeSpan))
{
if (conn.StoreTimeSpanAsTicks)
{
fastSetter = CreateNullableTypedSetterDelegate <T, TimeSpan>(column, (stmt, index) =>
{
return(new TimeSpan(SQLite3.ColumnInt64(stmt, index)));
});
}
else
{
fastSetter = CreateNullableTypedSetterDelegate <T, TimeSpan>(column, (stmt, index) =>
{
var text = SQLite3.ColumnString(stmt, index);
TimeSpan resultTime;
if (!TimeSpan.TryParseExact(text, "c", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.TimeSpanStyles.None, out resultTime))
{
resultTime = TimeSpan.Parse(text);
}
return(resultTime);
});
}
}
else if (clrType == typeof(DateTime))
{
if (conn.StoreDateTimeAsTicks)
{
fastSetter = CreateNullableTypedSetterDelegate <T, DateTime>(column, (stmt, index) =>
{
return(new DateTime(SQLite3.ColumnInt64(stmt, index)));
});
}
else
{
fastSetter = CreateNullableTypedSetterDelegate <T, DateTime>(column, (stmt, index) =>
{
var text = SQLite3.ColumnString(stmt, index);
DateTime resultDate;
if (!DateTime.TryParseExact(text, conn.DateTimeStringFormat, System.Globalization.CultureInfo.InvariantCulture, conn.DateTimeStyle, out resultDate))
{
resultDate = DateTime.Parse(text);
}
return(resultDate);
});
}
}
else if (clrType == typeof(DateTimeOffset))
{
fastSetter = CreateNullableTypedSetterDelegate <T, DateTimeOffset>(column, (stmt, index) =>
{
return(new DateTimeOffset(SQLite3.ColumnInt64(stmt, index), TimeSpan.Zero));
});
}
else if (clrTypeInfo.IsEnum)
{
// NOTE: Not sure of a good way (if any?) to do a strongly-typed fast setter like this for enumerated types -- for now, return null and column sets will revert back to the safe (but slow) Reflection-based method of column prop.Set()
}
else if (clrType == typeof(Int64))
{
fastSetter = CreateNullableTypedSetterDelegate <T, Int64>(column, (stmt, index) =>
{
return(SQLite3.ColumnInt64(stmt, index));
});
}
else if (clrType == typeof(UInt32))
{
fastSetter = CreateNullableTypedSetterDelegate <T, UInt32>(column, (stmt, index) =>
{
return((uint)SQLite3.ColumnInt64(stmt, index));
});
}
else if (clrType == typeof(decimal))
{
fastSetter = CreateNullableTypedSetterDelegate <T, decimal>(column, (stmt, index) =>
{
return((decimal)SQLite3.ColumnDouble(stmt, index));
});
}
else if (clrType == typeof(Byte))
{
fastSetter = CreateNullableTypedSetterDelegate <T, Byte>(column, (stmt, index) =>
{
return((byte)SQLite3.ColumnInt(stmt, index));
});
}
else if (clrType == typeof(UInt16))
{
fastSetter = CreateNullableTypedSetterDelegate <T, UInt16>(column, (stmt, index) =>
{
return((ushort)SQLite3.ColumnInt(stmt, index));
});
}
else if (clrType == typeof(Int16))
{
fastSetter = CreateNullableTypedSetterDelegate <T, Int16>(column, (stmt, index) =>
{
return((short)SQLite3.ColumnInt(stmt, index));
});
}
else if (clrType == typeof(sbyte))
{
fastSetter = CreateNullableTypedSetterDelegate <T, sbyte>(column, (stmt, index) =>
{
return((sbyte)SQLite3.ColumnInt(stmt, index));
});
}
else if (clrType == typeof(byte[]))
{
fastSetter = CreateTypedSetterDelegate <T, byte[]>(column, (stmt, index) =>
{
return(SQLite3.ColumnByteArray(stmt, index));
});
}
else if (clrType == typeof(Guid))
{
fastSetter = CreateNullableTypedSetterDelegate <T, Guid>(column, (stmt, index) =>
{
var text = SQLite3.ColumnString(stmt, index);
return(new Guid(text));
});
}
else if (clrType == typeof(Uri))
{
fastSetter = CreateTypedSetterDelegate <T, Uri>(column, (stmt, index) =>
{
var text = SQLite3.ColumnString(stmt, index);
return(new Uri(text));
});
}
else if (clrType == typeof(StringBuilder))
{
fastSetter = CreateTypedSetterDelegate <T, StringBuilder>(column, (stmt, index) =>
{
var text = SQLite3.ColumnString(stmt, index);
return(new StringBuilder(text));
});
}
else if (clrType == typeof(UriBuilder))
{
fastSetter = CreateTypedSetterDelegate <T, UriBuilder>(column, (stmt, index) =>
{
var text = SQLite3.ColumnString(stmt, index);
return(new UriBuilder(text));
});
}
else
{
// NOTE: Will fall back to the slow setter method in the event that we are unable to create a fast setter delegate for a particular column type
}
return(fastSetter);
}