public IEnumerable <T> ExecuteQuery <T> () where T : new()
{
var stmt = Prepare();
var props = Orm.GetColumns(typeof(T));
var cols = new System.Reflection.PropertyInfo[SQLite3.ColumnCount(stmt)];
for (int i = 0; i < cols.Length; i++)
{
cols[i] = MatchColProp(SQLite3.ColumnName(stmt, i), props);
}
while (SQLite3.Step(stmt) == SQLite3.Result.Row)
{
var obj = new T();
for (int i = 0; i < cols.Length; i++)
{
if (cols[i] == null)
{
continue;
}
var val = ReadCol(stmt, i, cols[i].PropertyType);
cols[i].SetValue(obj, val, null);
}
yield return(obj);
}
SQLite3.Finalize(stmt);
}
public int ExecuteNonQuery()
{
var r = SQLite3.Result.OK;
for (int i = 0; i < _conn.MaxExecuteAttempts; i++)
{
var stmt = Prepare();
r = SQLite3.Step(stmt);
SQLite3.Finalize(stmt);
if (r == SQLite3.Result.Error)
{
string msg = SQLite3.GetErrmsg(_conn.Handle);
throw SQLiteException.New(r, msg);
}
else if (r == SQLite3.Result.Done)
{
int rowsAffected = SQLite3.Changes(_conn.Handle);
return(rowsAffected);
}
else if (r == SQLite3.Result.Busy)
{
// We will retry
System.Threading.Thread.Sleep(1000);
}
else
{
throw SQLiteException.New(r, r.ToString());
}
}
throw SQLiteException.New(r, r.ToString());
}
public IEnumerable <object> ExecuteQuery(TableMapping map)
{
if (_conn.Trace)
{
Console.WriteLine("Executing Query: " + this);
}
var stmt = Prepare();
var cols = new TableMapping.Column[SQLite3.ColumnCount(stmt)];
for (int i = 0; i < cols.Length; i++)
{
var name = Marshal.PtrToStringUni(SQLite3.ColumnName16(stmt, i));
cols[i] = map.FindColumn(name);
}
while (SQLite3.Step(stmt) == SQLite3.Result.Row)
{
var obj = Activator.CreateInstance(map.MappedType);
map.SetConnection(obj, _conn);
for (int i = 0; i < cols.Length; i++)
{
if (cols[i] == null)
{
continue;
}
var val = ReadCol(stmt, i, cols[i].ColumnType);
cols[i].SetValue(obj, val);
}
yield return(obj);
}
SQLite3.Finalize(stmt);
}
/// <summary>
/// Executes the query.
/// </summary>
/// <param name="maxRows">
/// The maximum rows.
/// </param>
/// <returns>
/// The <see cref="ResultCollection"/>.
/// </returns>
public virtual ResultCollection ExecuteQuery(int maxRows)
{
ResultCollection results;
IntPtr stmt = IntPtr.Zero;
try
{
stmt = this.Prepare();
var cols = new ColumnInfoExt[SQLite3.ColumnCount(stmt)];
for (var i = 0; i < cols.Length; i++)
{
cols[i] = new ColumnInfoExt {
Name = SQLite3.ColumnName16(stmt, i), ColumnIndex = i
};
}
results = new ResultCollection(cols);
var rows = 0;
while (SQLite3.Step(stmt) == SQLite3.Result.Row)
{
var obj = new ResultRow();
for (var i = 0; i < cols.Length; i++)
{
if (cols[i] == null)
{
continue;
}
var colType = SQLite3.ColumnType(stmt, i);
cols[i].ColumnMainType = colType;
var val = this.ReadCol(stmt, i, colType, cols[i].ColumnClrType);
obj[cols[i].ColumnIndex] = val;
}
results.Add(obj);
if (maxRows != 0 && ++rows == maxRows)
{
break;
}
}
}
finally
{
if (stmt != IntPtr.Zero)
{
SQLite3.Finalize(stmt);
}
}
return(results);
}
public void ResetStatement()
{
try
{
SQLite3.Finalize(Statement);
}
finally
{
Statement = NullStatement;
Prepared = false;
}
}
private void Dispose(bool disposing)
{
if (Statement != NullStatement)
{
try {
SQLite3.Finalize(Statement);
} finally {
Statement = NullStatement;
Connection = null;
}
}
}
public T ExecuteScalar <T> ()
{
T val = default(T);
var stmt = Prepare();
if (SQLite3.Step(stmt) == SQLite3.Result.Row)
{
val = (T)ReadCol(stmt, 0, typeof(T));
}
SQLite3.Finalize(stmt);
return(val);
}
public IEnumerable <T> ExecuteDeferredQuery <T>(TableMapping map)
{
if (_conn.Trace)
{
Debug.WriteLine("Executing Query: " + this);
}
var stmt = Prepare();
try {
var cols = new TableMapping.Column[SQLite3.ColumnCount(stmt)];
for (int i = 0; i < cols.Length; i++)
{
var name = SQLite3.ColumnName16(stmt, i);
cols[i] = map.FindColumn(name);
}
while (SQLite3.Step(stmt) == SQLite3.Result.Row)
{
var obj = Activator.CreateInstance(map.MappedType);
for (int i = 0; i < cols.Length; i++)
{
if (cols[i] == null)
{
continue;
}
var colType = SQLite3.ColumnType(stmt, i);
var val = ReadCol(stmt, i, colType, cols[i].ColumnType);
cols[i].SetValue(obj, val);
}
OnInstanceCreated(obj);
yield return((T)obj);
}
} finally {
SQLite3.Finalize(stmt);
}
}
public int ExecuteNonQuery()
{
var stmt = Prepare();
var r = SQLite3.Step(stmt);
if (r == SQLite3.Result.Error)
{
string msg = SQLite3.Errmsg(_db);
SQLite3.Finalize(stmt);
throw SQLiteException.New(r, msg);
}
else if (r == SQLite3.Result.Done)
{
int rowsAffected = SQLite3.Changes(_db);
SQLite3.Finalize(stmt);
return(rowsAffected);
}
else
{
SQLite3.Finalize(stmt);
throw SQLiteException.New(r, "Unknown error");
}
}
private void Finalize(IntPtr stmt)
{
SQLite3.Finalize(stmt);
}
void Finalize(Sqlite3Statement stmt)
{
SQLite3.Finalize(stmt);
}