public Result Open(string filename, out IDbHandle db)
{
Sqlite3.sqlite3 internalDbHandle = null;
var ret = (Result) Sqlite3.sqlite3_open(filename, ref internalDbHandle);
db = new DbHandle(internalDbHandle);
return ret;
}
public ExtendedResult ExtendedErrCode(IDbHandle db)
{
// not supported
return 0;
// var dbHandle = (DbHandle)db;
// return Sqlite3.sqlite3_extended_errcode(dbHandle.InternalDbHandle);
}
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs)
{
IntPtr dbPtr;
Result r = SQLiteApiWin32Internal.sqlite3_open_v2(filename, out dbPtr, flags, zvfs);
db = new DbHandle(dbPtr);
return r;
}
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zVfs)
{
string dbFileName = Encoding.UTF8.GetString(filename, 0, filename.Length -1 );
Database internalDbHandle = null;
var ret = (Result)Sqlite3.sqlite3_open_v2(dbFileName, out internalDbHandle, flags, "");
db = new DbHandle(internalDbHandle);
return ret;
}
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zVfs)
{
var dbFileName = System.Text.Encoding.UTF8.GetString(filename, 0, filename.Length);
Sqlite3.sqlite3 internalDbHandle = null;
var ret = (Result)Sqlite3.sqlite3_open_v2(dbFileName, ref internalDbHandle, flags, null);
db = new DbHandle(internalDbHandle);
return ret;
}
public MainWindow()
{
InitializeComponent();
SelectedLanguage = "PL";
CookingBookLanguageSelect.ChangeLanuage(SelectedLanguage, this);
DbClient = DbDependancyResolver.Resolve<IDbHandle, SQLIteClient>();
}
public IDbStatement Prepare2(IDbHandle db, string query)
{
var internalDbHandle = (DbHandle) db;
IntPtr stmt;
Result r = SQLiteApiWin32Internal.sqlite3_prepare_v2(internalDbHandle.DbPtr, query, query.Length, out stmt, IntPtr.Zero);
if (r != Result.OK)
{
throw SQLiteException.New(r, Errmsg16(internalDbHandle));
}
return new DbStatement(stmt);
}
public IDbStatement Prepare2(IDbHandle db, string query)
{
var dbHandle = (DbHandle) db;
var stmt = new Sqlite3.Vdbe();
int r = Sqlite3.sqlite3_prepare_v2(dbHandle.InternalDbHandle, query, -1, ref stmt, 0);
if (r != 0)
{
throw SQLiteException.New((Result) r, GetErrmsg(db));
}
return new DbStatement(stmt);
}
public Result Open (byte[] filename, out IDbHandle db, int flags, IntPtr zvfs)
{
ActionsTaken.Add(string.Concat(filename.ToString(), "-Opened"));
db = new MockDbHandle ();
CreateStatementsExecuted = new List<string> ();
DeleteStatementsExecuted = new List<string> ();
InsertOrReplaceStatementsExecuted = new List<string> ();
InsertStatementsExecuted = new List<string> ();
UpdateStatementsExecuted = new List<string> ();
DropStatementsExecuted = new List<string> ();
SelectStatementsExecuted= new List<string> ();
return Result.OK;
}
public MigrationBase2Base(IDbHandle dbCli)
{
InitializeComponent();
MainDB = dbCli;
MainColection = new CookingBookDataCollection(dbCli);
MainColection.GetAll();
MainDbListViev.ItemsSource = MainColection.ListOfRecipes;
CollectionView MainRecipeViev = (CollectionView)CollectionViewSource.GetDefaultView(MainDbListViev.ItemsSource);
MainRecipeViev.Filter = (item => (String.IsNullOrEmpty(MainRecipeFilterText.Text) ? true : ((item as Recipe).Name.IndexOf(MainRecipeFilterText.Text, StringComparison.OrdinalIgnoreCase) >= 0)));
}
public IDbBackupHandle BackupInit(IDbHandle destHandle, string destName, IDbHandle srcHandle, string srcName)
{
var internalDestDb = (DbHandle)destHandle;
var internalSrcDb = (DbHandle)srcHandle;
IntPtr p = SQLiteApiAndroidCipherInternal.sqlite3_backup_init (internalDestDb.DbPtr,
destName,
internalSrcDb.DbPtr,
srcName);
if (p == IntPtr.Zero) {
return null;
} else {
return new DbBackupHandle (p);
}
}
public RecipesWindow(IDbHandle dbCli)
{
InitializeComponent();
DbCli = dbCli;
DataCollection = new CookingBookDataCollection(DbCli);
MainGrid.DataContext = CookinBookDictionary.Instance.GetNames(MainWindow.SelectedLanguage);
RecipeListViev.ItemsSource = DataCollection.GetFullRecipeList();
AllComponentsViev.ItemsSource = DataCollection.GetFullComponentList();
CollectionView RecipeViev = (CollectionView)CollectionViewSource.GetDefaultView(RecipeListViev.ItemsSource);
RecipeViev.Filter = (item => (String.IsNullOrEmpty(RecipeFilterText.Text) ? true : ((item as Recipe).Name.IndexOf(RecipeFilterText.Text, StringComparison.OrdinalIgnoreCase) >= 0)));
CollectionView ComponentViev = (CollectionView)CollectionViewSource.GetDefaultView(AllComponentsViev.ItemsSource);
ComponentViev.Filter = (item => (String.IsNullOrEmpty(ComponentsFilterText.Text) ? true : ((item as Component).Name.IndexOf(ComponentsFilterText.Text, StringComparison.OrdinalIgnoreCase) >= 0)));
}
public int Changes(IDbHandle db)
{
throw new NotImplementedException();
}
public long LastInsertRowid(IDbHandle db)
{
throw new NotImplementedException();
}
public ExtendedResult ExtendedErrCode(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return(SQLite3.sqlite3_extended_errcode(dbHandle.InternalDbHandle));
}
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs)
{
throw new NotImplementedException();
}
public int Changes(IDbHandle db)
{
var internalDbHandle = (DbHandle) db;
return SQLiteApiWin32Internal.sqlite3_changes(internalDbHandle.DbPtr);
}
public bool Equals(IDbHandle other)
{
return other is DbHandle && DbPtr == ((DbHandle) other).DbPtr;
}
public Result BusyTimeout(IDbHandle db, int milliseconds)
{
var dbHandle = (DbHandle)db;
return((Result)SQLite3.BusyTimeout(dbHandle.InternalDbHandle, milliseconds));
}
public bool Equals(IDbHandle other)
{
return(other is DbHandle && InternalDbHandle == ((DbHandle)other).InternalDbHandle);
}
public string GetErrmsg(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return(NativeMethods.GetErrmsg(dbHandle.InternalDbHandle));
}
public long LastInsertRowid(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return(NativeMethods.LastInsertRowid(dbHandle.InternalDbHandle));
}
public int Changes(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return(NativeMethods.Changes(dbHandle.InternalDbHandle));
}
public string GetErrmsg(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return Sqlite3.sqlite3_errmsg(dbHandle.InternalDbHandle);
}
public string Errmsg16(IDbHandle db)
{
var internalDbHandle = (DbHandle) db;
return Marshal.PtrToStringUni(SQLiteApiWin32Internal.sqlite3_errmsg16(internalDbHandle.DbPtr));
}
public int Changes(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return(SQLite3.Changes(dbHandle.InternalDbHandle));
}
public Result Close(IDbHandle db)
{
var internalDbHandle = (DbHandle) db;
return SQLiteApiWin32Internal.sqlite3_close(internalDbHandle.DbPtr);
}
public Result Close(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return((Result)SQLite3.Close(dbHandle.InternalDbHandle));
}
public Result Close(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return((Result)NativeMethods.Close(dbHandle.InternalDbHandle));
}
public int CreateScalarFunction(IDbHandle dbHandle, IScalarFunction sqliteFunction)
{
throw new NotImplementedException();
}
public long LastInsertRowid(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return(SQLite3.LastInsertRowid(dbHandle.InternalDbHandle));
}
public int CreateCollation(IDbHandle db, ICollation collation)
{
throw new NotImplementedException();
}
public string Errmsg16(IDbHandle db)
{
throw new NotImplementedException();
}
public long LastInsertRowid(IDbHandle db)
{
var internalDbHandle = (DbHandle)db;
return(SQLiteApiAndroidInternal.sqlite3_last_insert_rowid(internalDbHandle.DbPtr));
}
public string Errmsg16(IDbHandle db)
{
var internalDbHandle = (DbHandle)db;
return(Marshal.PtrToStringUni(SQLiteApiAndroidInternal.sqlite3_errmsg16(internalDbHandle.DbPtr)));
}
public ExtendedResult ExtendedErrCode(IDbHandle db)
{
var internalDbHandle = (DbHandle)db;
return(SQLiteApiAndroidInternal.sqlite3_extended_errcode(internalDbHandle.DbPtr));
}
public IDbStatement Prepare2(IDbHandle db, string query)
{
throw new NotImplementedException();
}
public Result EnableLoadExtension(IDbHandle db, int onoff)
{
var internalDbHandle = (DbHandle)db;
return(SQLiteApiAndroidInternal.sqlite3_enable_load_extension(internalDbHandle.DbPtr, onoff));
}
public Result BusyTimeout(IDbHandle db, int milliseconds)
{
throw new NotImplementedException();
}
public ExtendedResult ExtendedErrCode(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return(NativeMethods.ExtendedErrCode(dbHandle.InternalDbHandle));
}
public long LastInsertRowid(IDbHandle db)
{
var internalDbHandle = (DbHandle) db;
return SQLiteApiWin32Internal.sqlite3_last_insert_rowid(internalDbHandle.DbPtr);
}
public string Errmsg16(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return SQLite3.GetErrmsg(dbHandle.InternalDbHandle);
}
public ExtendedResult ExtendedErrCode(IDbHandle db)
{
var internalDbHandle = (DbHandle) db;
return SQLiteApiWin32Internal.sqlite3_extended_errcode(internalDbHandle.DbPtr);
}
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs)
{
string dbFileName = Encoding.UTF8.GetString(filename, 0, filename.Length);
Sqlite3DatabaseHandle internalDbHandle;
var ret = (Result)SQLite3.Open(dbFileName, out internalDbHandle, flags, zvfs);
db = new DbHandle(internalDbHandle);
return ret;
}
public Result EnableLoadExtension(IDbHandle db, int onoff)
{
var internalDbHandle = (DbHandle) db;
return SQLiteApiWin32Internal.sqlite3_enable_load_extension(internalDbHandle.DbPtr, onoff);
}
public bool Equals(IDbHandle other)
{
return other is DbHandle && InternalDbHandle == ((DbHandle)other).InternalDbHandle;
}
public Result BusyTimeout(IDbHandle db, int milliseconds)
{
var internalDbHandle = (DbHandle) db;
return SQLiteApiWin32Internal.sqlite3_busy_timeout(internalDbHandle.DbPtr, milliseconds);
}
public int Changes(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return SQLite3.Changes(dbHandle.InternalDbHandle);
}
public bool Equals(IDbHandle other)
{
return(other is DbHandle && DbPtr == ((DbHandle)other).DbPtr);
}
public Result EnableLoadExtension(IDbHandle db, int onoff)
{
var dbHandle = (DbHandle)db;
return((Result)NativeMethods.EnableLoadExtension(dbHandle.InternalDbHandle, onoff));
}
public Result EnableLoadExtension(IDbHandle db, int onoff)
{
return (Result)1;
}
public Result Close(IDbHandle db)
{
var internalDbHandle = (DbHandle)db;
return(SQLiteApiAndroidInternal.sqlite3_close(internalDbHandle.DbPtr));
}
public long LastInsertRowid(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return SQLite3.LastInsertRowid(dbHandle.InternalDbHandle);
}
public Result BusyTimeout(IDbHandle db, int milliseconds)
{
var internalDbHandle = (DbHandle)db;
return(SQLiteApiAndroidInternal.sqlite3_busy_timeout(internalDbHandle.DbPtr, milliseconds));
}
public IDbStatement Prepare2(IDbHandle db, string query)
{
var dbHandle = (DbHandle)db;
var stmt = default(Sqlite3Statement);
var r = SQLite3.Prepare2(dbHandle.InternalDbHandle, query, query.Length, out stmt, IntPtr.Zero);
if (r != Result.OK)
{
throw SQLiteException.New(r, SQLite3.GetErrmsg(dbHandle.InternalDbHandle));
}
return new DbStatement(stmt);
}
public int Changes(IDbHandle db)
{
var internalDbHandle = (DbHandle)db;
return(SQLiteApiAndroidInternal.sqlite3_changes(internalDbHandle.DbPtr));
}
public Result BusyTimeout(IDbHandle db, int milliseconds)
{
var dbHandle = (DbHandle)db;
return (Result)SQLite3.BusyTimeout(dbHandle.InternalDbHandle, milliseconds);
}
public Result EnableLoadExtension(IDbHandle db, int onoff)
{
return((Result)1);
}
public Result Close(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return (Result)SQLite3.Close(dbHandle.InternalDbHandle);
}
public string Errmsg16(IDbHandle db)
{
var dbHandle = (DbHandle)db;
return(SQLite3.GetErrmsg(dbHandle.InternalDbHandle));
}
