public object GetValue(int columnIndex, Type propertyType) { object value = null; if (propertyType == typeof(String) || propertyType == typeof(string)) { value = SQLite3.ColumnString(statement, columnIndex); } else if (propertyType == typeof(long)) { value = SQLite3.ColumnInt64(statement, columnIndex); } else if (propertyType == typeof(Single) || propertyType == typeof(Double) || propertyType == typeof(Decimal)) { value = SQLite3.ColumnDouble(statement, columnIndex); } else if (propertyType == typeof(int)) { value = SQLite3.ColumnInt(statement, columnIndex); } else if (propertyType == typeof(bool) || propertyType == typeof(Boolean)) { value = (SQLite3.ColumnInt(statement, columnIndex) != 0); } else if (propertyType == typeof(byte[])) { value = SQLite3.ColumnByteArray(statement, columnIndex); } /* else if (column.isSingleRelationship) { * value = (V)(object)SQLite3.ColumnString(statement, columnIndex); * }*/ return(value); }
/// <summary> /// execute a query</summary> /// <returns> /// return a JArray which contains all objects </returns> /// <param name="query"> contains the query to execute</param> /// <param name="param"> contains the parameters needed to execute the query</param> public JArray execute(String query, object[] param) { JArray array = new JArray(); if (query != null && query.Length > 0) { stmt = SQLite3.Prepare2(this.Handle, query); if (stmt != null) { if (param != null && param.Length > 0) { for (int i = 1; i <= param.Length; i++) { bindValue(param.GetValue(i - 1), i); } } while (SQLite3.Step(stmt) == SQLite3.Result.Row) { int count = SQLite3.ColumnCount(stmt); JObject obj = new JObject(); for (int i = 0; i < count; i++) { string name = SQLite3.ColumnName(stmt, i); SQLite3.ColType colType = SQLite3.ColumnType(stmt, i); switch (colType) { case SQLite3.ColType.Blob: byte[] bytes = SQLite3.ColumnByteArray(stmt, i); obj.Add(name, bytes); break; case SQLite3.ColType.Integer: int intValue = SQLite3.ColumnInt(stmt, i); obj.Add(name, intValue); break; case SQLite3.ColType.Float: double doubleValue = SQLite3.ColumnDouble(stmt, i); obj.Add(name, doubleValue); break; case SQLite3.ColType.Text: string text = SQLite3.ColumnString(stmt, i); obj.Add(name, text); break; case SQLite3.ColType.Null: default: obj.Add(name, null); break; } } array.Add(obj); } } SQLite3.Finalize(stmt); } return(array); }
private object ReadCol(SQLitePCL.sqlite3_stmt stmt, int index, SQLite3.ColType type) { switch (type) { case SQLite3.ColType.Blob: return(SQLite3.ColumnByteArray(stmt, index)); case SQLite3.ColType.Float: return(SQLite3.ColumnDouble(stmt, index)); case SQLite3.ColType.Integer: return(SQLite3.ColumnInt64(stmt, index)); case SQLite3.ColType.Null: return(null); case SQLite3.ColType.Text: return(SQLite3.ColumnString(stmt, index)); } return(null); }
public object ReadCol(IntPtr stmt, int index, Type clrType) { var type = SQLite3.ColumnType(stmt, index); if (type == SQLite3.ColType.Null) { return(null); } if (clrType == typeof(Byte) || clrType == typeof(UInt16) || clrType == typeof(SByte) || clrType == typeof(Int16) || clrType == typeof(Int32)) { return(Convert.ChangeType(SQLite3.ColumnInt(stmt, index), clrType)); } if (clrType == typeof(UInt32) || clrType == typeof(Int64)) { return(Convert.ChangeType(SQLite3.ColumnInt64(stmt, index), clrType)); } if (clrType == typeof(Single) || clrType == typeof(Double) || clrType == typeof(Decimal)) { return(Convert.ChangeType(SQLite3.ColumnDouble(stmt, index), clrType)); } if (clrType == typeof(String)) { return(Convert.ChangeType(SQLite3.ColumnString(stmt, index), clrType)); } if (clrType == typeof(byte[])) { return(SQLite3.ColumnByteArray(stmt, index)); } if (clrType == typeof(DateTime)) { return(ToDateTime(SQLite3.ColumnString(stmt, index))); } if (clrType == typeof(Boolean)) { return(ToBoolean(SQLite3.ColumnString(stmt, index))); } throw new NotSupportedException("Don't know how to read " + clrType); }
public Object ExecuteScalar() { Object retObj = null; var stmt = Prepare(); var cols = new System.Reflection.PropertyInfo[SQLite3.ColumnCount(stmt)]; if (SQLite3.Step(stmt) == SQLite3.Result.Row) { if (cols.Length > 0) { var type = SQLite3.ColumnType(stmt, 0); switch (type) { case SQLite3.ColType.Integer: retObj = SQLite3.ColumnInt64(stmt, 0); break; case SQLite3.ColType.Float: retObj = SQLite3.ColumnDouble(stmt, 0); break; case SQLite3.ColType.Blob: retObj = SQLite3.ColumnByteArray(stmt, 0); break; case SQLite3.ColType.Text: retObj = SQLite3.ColumnString(stmt, 0); break; case SQLite3.ColType.Null: break; } } } SQLite3.Finalize(stmt); return(retObj); }
public bool selectAllInto(JArray results, string query) { if (_connection != null) { try { var cmd = _connection.CreateCommand(query); var stmt = SQLite3.Prepare2(_connection.Handle, cmd.CommandText); try { while (SQLite3.Step(stmt) == SQLite3.Result.Row) { int colCount = SQLite3.ColumnCount(stmt); if (colCount <= 0) { return(false); } JObject jsonObj = new JObject(); for (int i = 0; i < colCount; i++) { string columnName = SQLite3.ColumnName16(stmt, i); if (columnName.Equals(FIELD_JSON)) { MemoryStream ms = new MemoryStream(SQLite3.ColumnByteArray(stmt, i)); using (BsonReader reader = new BsonReader(ms)) { jsonObj.Add(FIELD_JSON, JToken.ReadFrom(reader)); } } else if (columnName.Equals(FIELD_ID)) { jsonObj.Add(FIELD_ID, Int32.Parse(SQLite3.ColumnString(stmt, i))); } else { if (isJSONCreatedColumn(columnName)) { jsonObj.Add(columnName, SQLite3.ColumnString(stmt, i)); } else { jsonObj.Add(columnName.Replace('_', '.'), SQLite3.ColumnString(stmt, i)); } } } results.Add(jsonObj); } } finally { SQLite3.Finalize(stmt); } return(true); } catch (Exception e) { lastErrorMsg = e.ToString(); } } return(false); }
private object ReadCol(Sqlite3Statement stmt, int index, SQLite3.ColType type, Type clrType) { if (type == SQLite3.ColType.Null) { return(null); } if (clrType == typeof(string)) { return(SQLite3.ColumnString(stmt, index)); } if (clrType == typeof(int)) { return(SQLite3.ColumnInt(stmt, index)); } if (clrType == typeof(bool)) { return(SQLite3.ColumnInt(stmt, index) == 1); } if (clrType == typeof(double)) { return(SQLite3.ColumnDouble(stmt, index)); } if (clrType == typeof(float)) { return((float)SQLite3.ColumnDouble(stmt, index)); } if (clrType == typeof(TimeSpan)) { return(new TimeSpan(SQLite3.ColumnInt64(stmt, index))); } if (clrType == typeof(DateTime)) { if (_conn.StoreDateTimeAsTicks) { return(new DateTime(SQLite3.ColumnInt64(stmt, index))); } string text = SQLite3.ColumnString(stmt, index); return(DateTime.Parse(text)); } if (clrType == typeof(DateTimeOffset)) { return(new DateTimeOffset(SQLite3.ColumnInt64(stmt, index), TimeSpan.Zero)); } if (clrType.IsEnum) { return(SQLite3.ColumnInt(stmt, index)); } if (clrType == typeof(long)) { return(SQLite3.ColumnInt64(stmt, index)); } if (clrType == typeof(uint)) { return((uint)SQLite3.ColumnInt64(stmt, index)); } if (clrType == typeof(decimal)) { return((decimal)SQLite3.ColumnDouble(stmt, index)); } if (clrType == typeof(byte)) { return((byte)SQLite3.ColumnInt(stmt, index)); } if (clrType == typeof(ushort)) { return((ushort)SQLite3.ColumnInt(stmt, index)); } if (clrType == typeof(short)) { return((short)SQLite3.ColumnInt(stmt, index)); } if (clrType == typeof(sbyte)) { return((sbyte)SQLite3.ColumnInt(stmt, index)); } if (clrType == typeof(byte[])) { return(SQLite3.ColumnByteArray(stmt, index)); } if (clrType == typeof(Guid)) { string text = SQLite3.ColumnString(stmt, index); return(new Guid(text)); } throw new NotSupportedException("Don't know how to read " + clrType); }
private static object ReadCol(SQLiteConnection connection, sqlite3_stmt stmt, int index, SQLite3.ColType type, Type clrType) { if (type == SQLite3.ColType.Null) { return(null); } else { 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)) { return(new TimeSpan(SQLite3.ColumnInt64(stmt, index))); } else if (clrType == typeof(DateTime)) { if (connection.StoreDateTimeAsTicks) { return(new DateTime(SQLite3.ColumnInt64(stmt, index))); } else { string text = SQLite3.ColumnString(stmt, index); DateTime resultDate; if (!DateTime.TryParseExact(text, DateTimeExactStoreFormat, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out resultDate)) { resultDate = DateTime.Parse(text); } return(resultDate); } } // else if (clrType == typeof(DateTimeOffset)) // { // return new DateTimeOffset(SQLite3.ColumnInt64(stmt, index), TimeSpan.Zero); //#if !USE_NEW_REFLECTION_API // } // else if (clrType.IsEnum) // { //#else // } else if (clrType.GetTypeInfo().IsEnum) { //#endif // 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)) { string text = SQLite3.ColumnString(stmt, index); return(new Guid(text)); } else { throw new NotSupportedException("Don't know how to read " + clrType); } } }