public static SQLiteJournalModeEnum Convert(SqliteJournalMode journalMode)
{
switch (journalMode)
{
case SqliteJournalMode.Delete:
return(SQLiteJournalModeEnum.Delete);
case SqliteJournalMode.Off:
return(SQLiteJournalModeEnum.Off);
case SqliteJournalMode.Persist:
return(SQLiteJournalModeEnum.Persist);
case SqliteJournalMode.Memory:
return(SQLiteJournalModeEnum.Memory);
case SqliteJournalMode.Truncate:
return(SQLiteJournalModeEnum.Truncate);
case SqliteJournalMode.Wal:
return(SQLiteJournalModeEnum.Wal);
case SqliteJournalMode.Default:
default:
return(SQLiteJournalModeEnum.Default);
}
}
public static SqliteDAC Create(string path, string password = null, int?pageSize = null, SqliteJournalMode journalMode = SqliteJournalMode.Default, SqliteSyncMode syncMode = SqliteSyncMode.Normal, AlreadyExistsPolicy existsPolicy = AlreadyExistsPolicy.Error, ILogger logger = null)
{
var shouldDrop = false;
var shouldCreate = true;
if (ExistsByFilePath(path))
{
switch (existsPolicy)
{
case AlreadyExistsPolicy.Skip:
shouldDrop = false;
shouldCreate = false;
break;
case AlreadyExistsPolicy.Overwrite:
shouldDrop = true;
shouldCreate = true;
break;
case AlreadyExistsPolicy.Error:
throw new SoftwareException("Unable to create Sqlite database '{0}' as a file by that path already exists", path);
}
}
if (shouldDrop)
{
File.Delete(path);
}
if (shouldCreate)
{
var connString = CreateConnectionString(path, password, pageSize, false, journalMode, syncMode);
// set password, page config since ado.net doesn't do it
var dac = new SqliteDAC(connString);
using (var scope = dac.BeginScope(false)) {
// Set password explicitly since ADO.NET doesnt
var builder = dac.CreateSQLBuilder();
if (pageSize.HasValue)
{
builder.Emit("PRAGMA PAGE_SIZE={0}", pageSize.Value).EndOfStatement(SQLStatementType.DDL);
}
// VACUUM is necessary on create to ensure file is created (ADO.NET leaves empty stub otherwise)
builder.Emit("VACUUM").EndOfStatement(SQLStatementType.DDL);
dac.ExecuteNonQuery(builder.ToString());
}
}
return(Open(path, password, journalMode, syncMode, logger));
}
