public void TestBoolean() { var sqlite3Platform = new SQLitePlatformWin32(); string tmpFile = TestPath.GetTempFileName(); var db = new DbAcs(sqlite3Platform, tmpFile); db.buildTable(); for (int i = 0; i < 10; i++) { db.Insert(new VO { Flag = (i % 3 == 0), Text = String.Format("VO{0}", i) }); } // count vo which flag is true Assert.AreEqual(4, db.CountWithFlag(true)); Assert.AreEqual(6, db.CountWithFlag(false)); Debug.WriteLine("VO with true flag:"); foreach (VO vo in db.Query <VO>("SELECT * FROM VO Where Flag = ?", true)) { Debug.WriteLine(vo.ToString()); } Debug.WriteLine("VO with false flag:"); foreach (VO vo in db.Query <VO>("SELECT * FROM VO Where Flag = ?", false)) { Debug.WriteLine(vo.ToString()); } }
public MainWindow() { SQLitePlatformWin32 litePlatform = new SQLitePlatformWin32(); viewModel = new ViewModel(litePlatform, databasePath, File.Exists(databasePath)); InitializeComponent(); }
public override SQLiteConnection GetDatabase(string name) { ISQLitePlatform platform; if (RuntimeInfo.IsWindows) { platform = new SQLitePlatformWin32(); } else { platform = new SQLitePlatformGeneric(); } return(new SQLiteConnection(platform, @":memory:")); }
public override SQLiteConnection GetDatabase(string name) { ISQLitePlatform platform; if (RuntimeInfo.IsWindows) { platform = new SQLitePlatformWin32(Architecture.NativeIncludePath); } else { platform = new SQLitePlatformGeneric(); } return(new SQLiteConnection(platform, GetUsablePathFor($@"{name}.db", true))); }
public override SQLiteConnection GetDatabase(string name) { Directory.CreateDirectory(BasePath); ISQLitePlatform platform; if (RuntimeInfo.IsWindows) { platform = new SQLitePlatformWin32(); } else { platform = new SQLitePlatformGeneric(); } return(new SQLiteConnection(platform, Path.Combine(BasePath, $@"{name}.db"))); }
public override SQLiteConnection GetDatabase(string name, SQLiteOpenFlags openFlags = SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.Create, bool storeDateTimeAsTicks = true, IBlobSerializer serializer = null, IDictionary <string, TableMapping> tableMappings = null, IDictionary <Type, string> extraTypeMappings = null, IContractResolver resolver = null) { Directory.CreateDirectory(BasePath); ISQLitePlatform platform; if (RuntimeInfo.IsWindows) { platform = new SQLitePlatformWin32(); } else { platform = new SQLitePlatformGeneric(); } return(new SQLiteConnection(platform, Path.Combine(BasePath, $@"{name}.db"), openFlags, storeDateTimeAsTicks, serializer, tableMappings, extraTypeMappings, resolver)); }
public SQLiteAsyncConnection GetAsyncConnection() { var dbPath = GetDatabasePath(); var platForm = new SQLitePlatformWin32(); var connectionFactory = new Func <SQLiteConnectionWithLock>( () => { if (_conn == null) { _conn = new SQLiteConnectionWithLock(platForm, new SQLiteConnectionString(dbPath, storeDateTimeAsTicks: true)); } return(_conn); }); var asyncConnection = new SQLiteAsyncConnection(connectionFactory); return(asyncConnection); }
public SQLitePlatformTest() { _sqlitePlatformWin32 = new SQLitePlatformWin32(); }
public void TestFixtureSetUp() { _sqlite3Platform = new SQLitePlatformWin32(); _sqliteConnectionPool = new SQLiteConnectionPool(_sqlite3Platform); }
public SQLitePlatformDesktop() { _sqlitePlatformWin32 = new SQLitePlatformWin32(); }
public void SetUp() { _sqlite3Platform = new SQLitePlatformWin32(); }