public static Result Open(string filename, out Sqlite3DatabaseHandle db, int flags, IntPtr zVfs)
{
#if USE_WP8_NATIVE_SQLITE
return((Result)Sqlite3.sqlite3_open_v2(filename, out db, flags, ""));
#else
return((Result)Sqlite3.sqlite3_open_v2(filename, out db, flags, null));
#endif
}
public static int BindBlob(Sqlite3Statement stmt, int index, byte[] val, int n, IntPtr free)
{
#if USE_WP8_NATIVE_SQLITE
return(Sqlite3.sqlite3_bind_blob(stmt, index, val, n));
#else
return(Sqlite3.sqlite3_bind_blob(stmt, index, val, n, null));
#endif
}
public static int BindText(Sqlite3Statement stmt, int index, string val, int n, IntPtr free)
{
#if USE_WP8_NATIVE_SQLITE
return(Sqlite3.sqlite3_bind_text(stmt, index, val, n));
#else
return(Sqlite3.sqlite3_bind_text(stmt, index, val, n, null));
#endif
}
public static int BindBlob(IDbStatement stmt, int index, byte[] val, int n, IntPtr free)
{
var internalStmtHandle = (Sqlite3StatementInternal)stmt;
#if USE_WP8_NATIVE_SQLITE
return(Sqlite3.sqlite3_bind_blob(internalStmtHandle.Handle, index, val, n));
#else
return(Sqlite3.sqlite3_bind_blob(internalStmtHandle.Handle, index, val, n, null));
#endif
}
public static Result Open(string filename, out IDbHandle db, int flags, IntPtr zVfs)
{
#if USE_WP8_NATIVE_SQLITE
Sqlite.Database internalDbHandle;
var r = (Result)Sqlite3.sqlite3_open_v2(filename, out internalDbHandle, flags, "");
#else
Sqlite3.sqlite3 internalDbHandle;
var r = (Result)Sqlite3.sqlite3_open_v2(filename, out internalDbHandle, flags, null);
#endif
db = new Sqlite3DatabaseInternal(internalDbHandle);
return(r);
}
public static Sqlite3Statement Prepare2(Sqlite3DatabaseHandle db, string query)
{
Sqlite3Statement stmt = default(Sqlite3Statement);
#if USE_WP8_NATIVE_SQLITE
var r = Sqlite3.sqlite3_prepare_v2(db, query, out stmt);
#else
stmt = new Sqlite3Statement();
var r = Sqlite3.sqlite3_prepare_v2(db, query, -1, ref stmt, 0);
#endif
if (r != 0)
{
throw SQLiteException.New((Result)r, GetErrmsg(db));
}
return(stmt);
}
public static IDbStatement Prepare2(IDbHandle db, string query)
{
var internalDbHandle = (Sqlite3DatabaseInternal)db;
#if USE_WP8_NATIVE_SQLITE
Sqlite.Statement stmt;
var r = Sqlite3.sqlite3_prepare_v2(db, query, out stmt);
#else
var stmt = new Sqlite3.Vdbe();
var r = Sqlite3.sqlite3_prepare_v2(internalDbHandle.Handle, query, -1, ref stmt, 0);
#endif
if (r != 0)
{
throw SQLiteException.New((Result)r, GetErrmsg(db));
}
return(new Sqlite3StatementInternal(stmt));
}
public static Result Reset(Sqlite3Statement stmt)
{
return((Result)Sqlite3.sqlite3_reset(stmt));
}
public static int BindDouble(Sqlite3Statement stmt, int index, double val)
{
return(Sqlite3.sqlite3_bind_double(stmt, index, val));
}
public static Result EnableLoadExtension(Sqlite3DatabaseHandle db, int onoff)
{
return((Result)Sqlite3.sqlite3_enable_load_extension(db, onoff));
}
public static int ColumnBytes(Sqlite3Statement stmt, int index)
{
return(Sqlite3.sqlite3_column_bytes(stmt, index));
}
public static double ColumnDouble(Sqlite3Statement stmt, int index)
{
return(Sqlite3.sqlite3_column_double(stmt, index));
}
public static int ColumnInt(Sqlite3Statement stmt, int index)
{
return(Sqlite3.sqlite3_column_int(stmt, index));
}
public static string ColumnName16(Sqlite3Statement stmt, int index)
{
return(Sqlite3.sqlite3_column_name(stmt, index));
}
public static Result Close(Sqlite3DatabaseHandle db)
{
return((Result)Sqlite3.sqlite3_close(db));
}
public static Result Step(Sqlite3Statement stmt)
{
return((Result)Sqlite3.sqlite3_step(stmt));
}
public static int Changes(Sqlite3DatabaseHandle db)
{
return(Sqlite3.sqlite3_changes(db));
}
public static Result BusyTimeout(Sqlite3DatabaseHandle db, int milliseconds)
{
return((Result)Sqlite3.sqlite3_busy_timeout(db, milliseconds));
}
public static int ColumnCount(Sqlite3Statement stmt)
{
return(Sqlite3.sqlite3_column_count(stmt));
}
public static Result Finalize(Sqlite3Statement stmt)
{
return((Result)Sqlite3.sqlite3_finalize(stmt));
}
public static ColType ColumnType(Sqlite3Statement stmt, int index)
{
return((ColType)Sqlite3.sqlite3_column_type(stmt, index));
}
public static long LastInsertRowid(Sqlite3DatabaseHandle db)
{
return(Sqlite3.sqlite3_last_insert_rowid(db));
}
public static long ColumnInt64(Sqlite3Statement stmt, int index)
{
return(Sqlite3.sqlite3_column_int64(stmt, index));
}
public static string GetErrmsg(Sqlite3DatabaseHandle db)
{
return(Sqlite3.sqlite3_errmsg(db));
}
public static byte[] ColumnBlob(Sqlite3Statement stmt, int index)
{
return(Sqlite3.sqlite3_column_blob(stmt, index));
}
public static int BindParameterIndex(Sqlite3Statement stmt, string name)
{
return(Sqlite3.sqlite3_bind_parameter_index(stmt, name));
}
public static string ColumnString(Sqlite3Statement stmt, int index)
{
return(Sqlite3.sqlite3_column_text(stmt, index));
}
public static int BindNull(Sqlite3Statement stmt, int index)
{
return(Sqlite3.sqlite3_bind_null(stmt, index));
}
public static ExtendedResult ExtendedErrCode(Sqlite3DatabaseHandle db)
{
return((ExtendedResult)Sqlite3.sqlite3_extended_errcode(db));
}
public static int BindInt64(Sqlite3Statement stmt, int index, long val)
{
return(Sqlite3.sqlite3_bind_int64(stmt, index, val));
}
