private static string GetConnectionString( string dataSource, bool binaryGuid, DateTimeKind dateTimeKind, SQLiteDateFormats dateTimeFormat, SQLiteJournalModeEnum journalMode, SynchronizationModes syncMode, int pageSize, int cacheSize) { Ensure.NotNullOrEmptyOrWhiteSpace(dataSource); return(new SQLiteConnectionStringBuilder { DataSource = dataSource, FailIfMissing = false, Pooling = false, BinaryGUID = binaryGuid, DateTimeKind = dateTimeKind, DateTimeFormat = dateTimeFormat, JournalMode = journalMode, SyncMode = syncMode, UseUTF16Encoding = false, ReadOnly = false, LegacyFormat = false, PageSize = pageSize, // reverts back to default on conn.Close has to first be set when Mode is NOT WAL & before any table is created. CacheSize = cacheSize // reverts back to default on conn.Close, has to first be set when Mode is NOT WAL }.ToString()); }
public void Synchronous(string text, SynchronizationModes expected) { SQLiteConnectionStringBuilder csb = new SQLiteConnectionStringBuilder { ConnectionString = "Synchronous=" + text }; Assert.AreEqual(expected, csb.SyncMode); }
public static SqliteSyncMode Convert(SynchronizationModes syncMode) { switch (syncMode) { case SynchronizationModes.Full: return(SqliteSyncMode.Full); case SynchronizationModes.Off: return(SqliteSyncMode.Off); case SynchronizationModes.Normal: default: return(SqliteSyncMode.Normal); } }
private static Mono.Data.Sqlite.SynchronizationModes GetSyncMode(SynchronizationModes syncMode) { switch (syncMode) { case SynchronizationModes.Full: return(Mono.Data.Sqlite.SynchronizationModes.Full); case SynchronizationModes.Normal: return(Mono.Data.Sqlite.SynchronizationModes.Normal); case SynchronizationModes.Off: return(Mono.Data.Sqlite.SynchronizationModes.Off); default: return(Mono.Data.Sqlite.SynchronizationModes.Normal); } }
static SQLiteConnection GetConnection(string path, SynchronizationModes sync, SQLiteJournalModeEnum jornal) { var connectionString = new SQLiteConnectionStringBuilder() { DataSource = path, DefaultIsolationLevel = System.Data.IsolationLevel.ReadCommitted, SyncMode = sync, JournalMode = jornal, Pooling = true, CacheSize = 65535 }; var conn = new SQLiteConnection(connectionString.ToString()); conn.Open(); return(conn); }
/// <summary> /// Returns a file-based <c>SQLite</c> connection-string. /// </summary> public static string GetFileConnectionString( FileInfo file, bool binaryGuid = false, DateTimeKind dateTimeKind = DateTimeKind.Utc, SQLiteDateFormats dateTimeFormat = SQLiteDateFormats.UnixEpoch, SQLiteJournalModeEnum journalMode = SQLiteJournalModeEnum.Wal, SynchronizationModes syncMode = SynchronizationModes.Off, int pageSize = 4096, int cacheSize = -2000) { Ensure.NotNull(file, nameof(file)); return(GetConnectionString( file.FullName, binaryGuid, dateTimeKind, dateTimeFormat, journalMode, syncMode, pageSize, cacheSize)); }
private static SqliteUri BuildUri(FileInfo fileInfo, string password, bool zipVfs, bool foreignKeysOn, SQLiteJournalModeEnum journalMode = SQLiteJournalModeEnum.Wal, SynchronizationModes synchronousity = SynchronizationModes.Full, int pageSize = 4096, int cacheSize = 2000, bool binaryGuid = false, bool failIfMissing = true) { CheckPageSize(pageSize); var nvc = new NameValueCollection(); if (!string.IsNullOrWhiteSpace(password)) { nvc.Add("password", password); } if (zipVfs && !string.IsNullOrWhiteSpace(password)) { nvc.Add("vfs", "zipvfs"); nvc.Add("zv", "zlib"); nvc.Add("zipvfs_journal mode", journalMode.ToString()); } else { nvc.Add("journal mode", journalMode.ToString()); } nvc.Add("foreign keys", foreignKeysOn.ToString()); nvc.Add("synchronous", synchronousity.ToString()); nvc.Add("page size", pageSize.ToString()); nvc.Add("cache size", cacheSize.ToString()); nvc.Add("BinaryGuid", binaryGuid.ToString()); nvc.Add("FailIfMissing", failIfMissing.ToString()); return new SqliteUri(fileInfo, nvc); }
private static SqliteUri BuildUri(FileInfo fileInfo, string password, bool zipVfs, bool foreignKeysOn, SQLiteJournalModeEnum journalMode = SQLiteJournalModeEnum.Wal, SynchronizationModes synchronousity = SynchronizationModes.Full, int pageSize = 4096, int cacheSize = 2000, bool binaryGuid = false, bool failIfMissing = true) { CheckPageSize(pageSize); var nvc = new NameValueCollection(); if (!string.IsNullOrWhiteSpace(password)) { nvc.Add("password", password); } if (zipVfs && !string.IsNullOrWhiteSpace(password)) { nvc.Add("vfs", "zipvfs"); nvc.Add("zv", "zlib"); nvc.Add("zipvfs_journal mode", journalMode.ToString()); } else { nvc.Add("journal mode", journalMode.ToString()); } nvc.Add("foreign keys", foreignKeysOn.ToString()); nvc.Add("synchronous", synchronousity.ToString()); nvc.Add("page size", pageSize.ToString()); nvc.Add("cache size", cacheSize.ToString()); nvc.Add("BinaryGuid", binaryGuid.ToString()); nvc.Add("FailIfMissing", failIfMissing.ToString()); return(new SqliteUri(fileInfo, nvc)); }
internal static VirtualRadar.Interface.SQLite.SynchronizationModes ToSynchronizationModes(SynchronizationModes value) { switch(value) { case SynchronizationModes.Normal: return VirtualRadar.Interface.SQLite.SynchronizationModes.Normal; case SynchronizationModes.Full: return VirtualRadar.Interface.SQLite.SynchronizationModes.Full; case SynchronizationModes.Off: return VirtualRadar.Interface.SQLite.SynchronizationModes.Off; default: throw new NotImplementedException(); } }
internal static VirtualRadar.Interface.SQLite.SynchronizationModes ToSynchronizationModes(SynchronizationModes value) { switch (value) { case SynchronizationModes.Normal: return(VirtualRadar.Interface.SQLite.SynchronizationModes.Normal); case SynchronizationModes.Full: return(VirtualRadar.Interface.SQLite.SynchronizationModes.Full); case SynchronizationModes.Off: return(VirtualRadar.Interface.SQLite.SynchronizationModes.Off); default: throw new NotImplementedException(); } }