public static SqliteJournalMode Convert(SQLiteJournalModeEnum journalMode) { switch (journalMode) { case SQLiteJournalModeEnum.Delete: return(SqliteJournalMode.Delete); case SQLiteJournalModeEnum.Off: return(SqliteJournalMode.Off); case SQLiteJournalModeEnum.Persist: return(SqliteJournalMode.Persist); case SQLiteJournalModeEnum.Memory: return(SqliteJournalMode.Memory); case SQLiteJournalModeEnum.Truncate: return(SqliteJournalMode.Truncate); case SQLiteJournalModeEnum.Wal: return(SqliteJournalMode.Wal); case SQLiteJournalModeEnum.Default: default: return(SqliteJournalMode.Default); } }
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 JournalMode(string text, SQLiteJournalModeEnum expected) { SQLiteConnectionStringBuilder csb = new SQLiteConnectionStringBuilder { ConnectionString = "Journal Mode=" + text }; Assert.AreEqual(expected, csb.JournalMode); }
public static VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum ToSQLiteJournalModeEnum(SQLiteJournalModeEnum value) { switch(value) { case SQLiteJournalModeEnum.Delete: return VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Delete; case SQLiteJournalModeEnum.Persist: return VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Persist; case SQLiteJournalModeEnum.Off: return VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Off; #if DOTNET_BUILD case SQLiteJournalModeEnum.Default: return VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Default; case SQLiteJournalModeEnum.Truncate: return VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Truncate; case SQLiteJournalModeEnum.Memory: return VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Memory; case SQLiteJournalModeEnum.Wal: return VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Wal; #endif default: throw new NotImplementedException(); } }
private static Mono.Data.Sqlite.SQLiteJournalModeEnum GetJournalMode(SQLiteJournalModeEnum journalMode) { switch (journalMode) { case SQLiteJournalModeEnum.Delete: return(Mono.Data.Sqlite.SQLiteJournalModeEnum.Delete); case SQLiteJournalModeEnum.Off: return(Mono.Data.Sqlite.SQLiteJournalModeEnum.Off); case SQLiteJournalModeEnum.Persist: return(Mono.Data.Sqlite.SQLiteJournalModeEnum.Persist); default: return(Mono.Data.Sqlite.SQLiteJournalModeEnum.Delete); } }
/// <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)); }
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); }
public static VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum ToSQLiteJournalModeEnum(SQLiteJournalModeEnum value) { switch (value) { case SQLiteJournalModeEnum.Delete: return(VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Delete); case SQLiteJournalModeEnum.Persist: return(VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Persist); case SQLiteJournalModeEnum.Off: return(VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Off); #if DOTNET_BUILD case SQLiteJournalModeEnum.Default: return(VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Default); case SQLiteJournalModeEnum.Truncate: return(VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Truncate); case SQLiteJournalModeEnum.Memory: return(VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Memory); case SQLiteJournalModeEnum.Wal: return(VirtualRadar.Interface.SQLite.SQLiteJournalModeEnum.Wal); #endif default: throw new NotImplementedException(); } }