public byte[] ColumnBlob(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; int length = ColumnBytes(stmt, index); byte[] result = new byte[length]; if (length > 0) Marshal.Copy(SQLite3.ColumnBlob(dbStatement.InternalStmt, index), result, 0, length); return result; }
public int BindBlob(IDbStatement stmt, int index, byte[] val, int n, IntPtr free) { var dbStatement = (DbStatement)stmt; if (_useWinSqlite) { return WinSQLite3.BindBlob(dbStatement.InternalStmt, index, val, n, free); } else { return SQLite3.BindBlob(dbStatement.InternalStmt, index, val, n, free); } }
public int BindInt(IDbStatement stmt, int index, int val) { var dbStatement = (DbStatement)stmt; if (_useWinSqlite) { return WinSQLite3.BindInt(dbStatement.InternalStmt, index, val); } else { return SQLite3.BindInt(dbStatement.InternalStmt, index, val); } }
public int ExecuteNonQuery(object[] source) { Connection.TraceListener.WriteLine("Executing: {0}", CommandText); if (!Initialized) { Statement = Prepare(); Initialized = true; } var sqlitePlatform = Connection.Platform; //bind the values. if (source != null) { for (var i = 0; i < source.Length; i++) { SQLiteCommand.BindParameter(sqlitePlatform.SQLiteApi, Statement, i + 1, source[i], Connection.StoreDateTimeAsTicks, Connection.Serializer); } } Result r; lock (_locker) { r = sqlitePlatform.SQLiteApi.Step(Statement); } if (r == Result.Done) { var rowsAffected = sqlitePlatform.SQLiteApi.Changes(Connection.Handle); sqlitePlatform.SQLiteApi.Reset(Statement); return rowsAffected; } if (r == Result.Error) { var msg = sqlitePlatform.SQLiteApi.Errmsg16(Connection.Handle); sqlitePlatform.SQLiteApi.Reset(Statement); throw SQLiteException.New(r, msg); } if (r == Result.Constraint && sqlitePlatform.SQLiteApi.ExtendedErrCode(Connection.Handle) == ExtendedResult.ConstraintNotNull) { sqlitePlatform.SQLiteApi.Reset(Statement); throw NotNullConstraintViolationException.New(r, sqlitePlatform.SQLiteApi.Errmsg16(Connection.Handle)); } sqlitePlatform.SQLiteApi.Reset(Statement); throw SQLiteException.New(r, r.ToString()); }
public int ExecuteNonQuery(object[] source) { if (Connection.Trace) { Debug.WriteLine("Executing: " + CommandText); } var r = Result.OK; if (!Initialized) { Statement = Prepare(); Initialized = true; } //bind the values. if (source != null) { for (int i = 0; i < source.Length; i++) { SQLiteCommand.BindParameter(_sqlitePlatform.SQLiteApi, Statement, i + 1, source[i], Connection.StoreDateTimeAsTicks); } } r = _sqlitePlatform.SQLiteApi.Step(Statement); if (r == Result.Done) { int rowsAffected = _sqlitePlatform.SQLiteApi.Changes(Connection.Handle); _sqlitePlatform.SQLiteApi.Reset(Statement); return rowsAffected; } if (r == Result.Error) { string msg = _sqlitePlatform.SQLiteApi.Errmsg16(Connection.Handle); _sqlitePlatform.SQLiteApi.Reset(Statement); throw SQLiteException.New(r, msg); } _sqlitePlatform.SQLiteApi.Reset(Statement); throw SQLiteException.New(r, r.ToString()); }
public bool Equals(IDbStatement other) { return((other is DbStatement) && ((DbStatement)other).InternalStmt == InternalStmt); }
public byte[] ColumnByteArray(IDbStatement stmt, int index) { var internalStmt = (DbStatement) stmt; return SQLiteApiWin32Internal.ColumnByteArray(internalStmt.StmtPtr, index); }
public int BindParameterIndex(IDbStatement stmt, string name) { var dbStatement = (DbStatement)stmt; return SQLite3.BindParameterIndex(dbStatement.InternalStmt, name); }
public string ColumnName16(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return(SQLite3.ColumnName16(dbStatement.InternalStmt, index)); }
public string ColumnText16(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return Marshal.PtrToStringUni(SQLite3.ColumnText16(dbStatement.InternalStmt, index)); }
public Result Step(IDbStatement stmt) { var dbStatement = (DbStatement)stmt; return (Result)SQLite3.Step(dbStatement.InternalStmt); }
public int BindInt(IDbStatement stmt, int index, int val) { var internalStmt = (DbStatement)stmt; return(SQLiteApiGenericInternal.sqlite3_bind_int(internalStmt.StmtPtr, index, val)); }
public int BindBlob(IDbStatement stmt, int index, byte[] val, int n, IntPtr free) { var dbStatement = (DbStatement)stmt; return SQLite3.BindBlob(dbStatement.InternalStmt, index, val, n, free); }
public int BindText16(IDbStatement stmt, int index, string val, int n, IntPtr free) { var dbStatement = (DbStatement)stmt; return(SQLite3.BindText(dbStatement.InternalStmt, index, val, n, free)); }
protected override void OnPersistCommit(IDbStatement cmd, CommitAttempt attempt) { _raisedCommand = cmd; _raisedCommitAttempt = attempt; }
public int BindParameterIndex(IDbStatement stmt, string name) { var dbStatement = (DbStatement)stmt; return(SQLite3.BindParameterIndex(dbStatement.InternalStmt, name)); }
public int BindNull(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return(SQLite3.BindNull(dbStatement.InternalStmt, index)); }
public int BindInt64(IDbStatement stmt, int index, long val) { var dbStatement = (DbStatement)stmt; return(SQLite3.BindInt64(dbStatement.InternalStmt, index, val)); }
public Result Reset(IDbStatement stmt) { var internalStmt = (DbStatement) stmt; return SQLiteApiWin32Internal.sqlite3_reset(internalStmt.StmtPtr); }
public double ColumnDouble(IDbStatement stmt, int index) { var internalStmt = (DbStatement)stmt; return(SQLiteApiGenericInternal.sqlite3_column_double(internalStmt.StmtPtr, index)); }
public int ColumnBytes(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return SQLite3.ColumnBytes(dbStatement.InternalStmt, index); }
public string ColumnText16(IDbStatement stmt, int index) { var internalStmt = (DbStatement)stmt; return(Marshal.PtrToStringUni(SQLiteApiGenericInternal.sqlite3_column_text16(internalStmt.StmtPtr, index))); }
public long ColumnInt64(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return SQLite3.ColumnInt64(dbStatement.InternalStmt, index); }
public int ColumnBytes(IDbStatement stmt, int index) { var internalStmt = (DbStatement)stmt; return(SQLiteApiGenericInternal.sqlite3_column_bytes(internalStmt.StmtPtr, index)); }
public Result Finalize(IDbStatement stmt) { var dbStatement = (DbStatement)stmt; Sqlite3Statement internalStmt = dbStatement.InternalStmt; return (Result)SQLite3.Finalize(internalStmt); }
public byte[] ColumnByteArray(IDbStatement stmt, int index) { var internalStmt = (DbStatement)stmt; return(SQLiteApiGenericInternal.ColumnByteArray(internalStmt.StmtPtr, index)); }
public int BindInt64(IDbStatement stmt, int index, long val) { var dbStatement = (DbStatement)stmt; return SQLite3.BindInt64(dbStatement.InternalStmt, index, val); }
public int BindDouble(IDbStatement stmt, int index, double val) { var dbStatement = (DbStatement)stmt; return(SQLite3.BindDouble(dbStatement.InternalStmt, index, val)); }
public byte[] ColumnByteArray(IDbStatement stmt, int index) { return ColumnBlob(stmt, index); }
public ColType ColumnType(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return((ColType)SQLite3.ColumnType(dbStatement.InternalStmt, index)); }
public string ColumnText16(IDbStatement stmt, int index) { var internalStmt = (DbStatement) stmt; return Marshal.PtrToStringUni(SQLiteApiWin32Internal.sqlite3_column_text16(internalStmt.StmtPtr, index)); }
public Result Step(IDbStatement stmt) { var dbStatement = (DbStatement)stmt; return((Result)SQLite3.Step(dbStatement.InternalStmt)); }
public bool Equals(IDbStatement other) { return(other is DbStatement && StmtPtr == ((DbStatement)other).StmtPtr); }
public string ColumnText16(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return(Marshal.PtrToStringUni(SQLite3.ColumnText16(dbStatement.InternalStmt, index))); }
public double ColumnDouble(IDbStatement stmt, int index) { var internalStmt = (DbStatement) stmt; return SQLiteApiWin32Internal.sqlite3_column_double(internalStmt.StmtPtr, index); }
public Result Step(IDbStatement stmt) { var internalStmt = (DbStatement)stmt; return(SQLiteApiGenericInternal.sqlite3_step(internalStmt.StmtPtr)); }
public int ColumnBytes(IDbStatement stmt, int index) { var internalStmt = (DbStatement) stmt; return SQLiteApiWin32Internal.sqlite3_column_bytes(internalStmt.StmtPtr, index); }
public Result Finalize(IDbStatement stmt) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_finalize(internalStmt.StmtPtr)); }
public bool Equals(IDbStatement other) { return other is DbStatement && StmtPtr == ((DbStatement) other).StmtPtr; }
public int BindParameterIndex(IDbStatement stmt, string name) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_bind_parameter_index(internalStmt.StmtPtr, name)); }
public Result Finalize(IDbStatement stmt) { var internalStmt = (DbStatement) stmt; return SQLiteApiWin32Internal.sqlite3_finalize(internalStmt.StmtPtr); }
public int BindNull(IDbStatement stmt, int index) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_bind_null(internalStmt.StmtPtr, index)); }
public int ColumnCount(IDbStatement stmt) { var dbStatement = (DbStatement)stmt; return SQLite3.ColumnCount(dbStatement.InternalStmt); }
public int BindInt64(IDbStatement stmt, int index, long val) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_bind_int64(internalStmt.StmtPtr, index, val)); }
public double ColumnDouble(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return SQLite3.ColumnDouble(dbStatement.InternalStmt, index); }
public int BindDouble(IDbStatement stmt, int index, double val) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_bind_double(internalStmt.StmtPtr, index, val)); }
public string ColumnName16(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return SQLite3.ColumnName16(dbStatement.InternalStmt, index); }
public int BindText16(IDbStatement stmt, int index, string val, int n, IntPtr free) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_bind_text16(internalStmt.StmtPtr, index, val, n, free)); }
public ColType ColumnType(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return (ColType)SQLite3.ColumnType(dbStatement.InternalStmt, index); }
public int BindBlob(IDbStatement stmt, int index, byte[] val, int n, IntPtr free) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_bind_blob(internalStmt.StmtPtr, index, val, n, free)); }
public int BindDouble(IDbStatement stmt, int index, double val) { var dbStatement = (DbStatement)stmt; return SQLite3.BindDouble(dbStatement.InternalStmt, index, val); }
public int ColumnCount(IDbStatement stmt) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_column_count(internalStmt.StmtPtr)); }
public bool Equals(IDbStatement other) { return (other is DbStatement) && ((DbStatement)other).InternalStmt == InternalStmt; }
public string ColumnName16(IDbStatement stmt, int index) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.ColumnName16(internalStmt.StmtPtr, index)); }
public int BindNull(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return SQLite3.BindNull(dbStatement.InternalStmt, index); }
public ColType ColumnType(IDbStatement stmt, int index) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_column_type(internalStmt.StmtPtr, index)); }
public int BindText16(IDbStatement stmt, int index, string val, int n, IntPtr free) { var dbStatement = (DbStatement)stmt; return SQLite3.BindText(dbStatement.InternalStmt, index, val, n, free); }
public long ColumnInt64(IDbStatement stmt, int index) { var internalStmt = (DbStatement)stmt; return(SQLiteApiOSXInternal.sqlite3_column_int64(internalStmt.StmtPtr, index)); }
public long ColumnInt64(IDbStatement stmt, int index) { var dbStatement = (DbStatement)stmt; return(SQLite3.ColumnInt64(dbStatement.InternalStmt, index)); }